· 8 years ago · Jan 06, 2018, 12:50 AM
1drop table if exists texts;
2create table `texts` (
3 `id` int(10) unsigned not null auto_increment,
4 `object_id` int(10) unsigned not null,
5 `text` text not null,
6 `lang` varchar(10) not null default 'nb',
7 foreign key(`lang`) references lang(langtag),
8 primary key(`id`)
9) engine=InnoDB default charset=utf8;