CREATE TABLE IF NOT EXISTS `contents`(
`id_content` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(20) NOT NULL,
`date_add` DATETIME,
`date_upd` DATETIME,
PRIMARY KEY(`id_content`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
CREATE TABLE IF NOT EXISTS `contents_lang`(
`id_content` INT(11) UNSIGNED NOT NULL,
`id_lang` INT(10) UNSIGNED NOT NULL,
`title` VARCHAR(100) NOT NULL,
`description` TEXT NOT NULL,
PRIMARY KEY(`id_content`,`id_lang`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
CREATE TABLE IF NOT EXISTS `lang`(
`id_lang` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(32) NOT NULL,
`active` TINYINT(1) NOT NULL DEFAULT '0'
`iso_code` CHAR(2) NOT NULL,
PRIMARY KEY(`id_lang`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;