List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:May 1 2013 12:53pm
Subject:Adding language support to tables
View as plain text  
Hi,

I've the following database structure of 4 tables for geographical
information



CREATE  TABLE IF NOT EXISTS `mydb`.`country` (

  `country_id` INT NOT NULL ,

  `country_code` CHAR(2) NOT NULL ,

  `name` VARCHAR(255) NOT NULL ,

  PRIMARY KEY (`country_id`) ,

  UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) )

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;





CREATE  TABLE IF NOT EXISTS `mydb`.`region` (

  `region_id` INT NOT NULL ,

  `name` VARCHAR(255) NOT NULL ,

  `country_code` CHAR(2) NOT NULL ,

  PRIMARY KEY (`region_id`) ,

  INDEX `FK_country_code` (`country_code` ASC) ,

  CONSTRAINT `FK_country_code`

    FOREIGN KEY (`country_code` )

    REFERENCES `mydb`.`country` (`country_code` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;





CREATE  TABLE IF NOT EXISTS `mydb`.`city` (

  `city_id` INT NOT NULL ,

  `region_id` INT NOT NULL ,

  `name` VARCHAR(255) NOT NULL ,

  `latitude` DOUBLE NOT NULL ,

  `longitude` DOUBLE NOT NULL ,

  PRIMARY KEY (`city_id`) ,

  INDEX `FK_region_id` (`region_id` ASC) ,

  CONSTRAINT `FK_region_id`

    FOREIGN KEY (`region_id` )

    REFERENCES `mydb`.`region` (`region_id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;





CREATE  TABLE IF NOT EXISTS `mydb`.`district` (

  `district_id` INT NOT NULL ,

  `city_id` INT NOT NULL ,

  `name` VARCHAR(255) NOT NULL ,

  `latitude` DOUBLE NOT NULL ,

  `longitude` DOUBLE NOT NULL ,

  PRIMARY KEY (`district_id`) ,

  INDEX `FK_city_id` (`city_id` ASC) ,

  CONSTRAINT `FK_city_id`

    FOREIGN KEY (`city_id` )

    REFERENCES `mydb`.`city` (`city_id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;




Basically I'm wanting to add language support for each table to translate
the name field in each instance.  All other information will remain the
same.

Therefore is my best approach to add some sort of look-up table with the
translation...?

Thanks
Neil

Thread
Adding language support to tablesNeil Tompkins1 May
  • RE: Adding language support to tablesRick James1 May
    • Re: Adding language support to tablesNeil Tompkins1 May