diff options
-rw-r--r-- | data/db.struct | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/data/db.struct b/data/db.struct index 4113502..9adb900 100644 --- a/data/db.struct +++ b/data/db.struct @@ -77,15 +77,17 @@ CREATE TABLE dict( CREATE TABLE locus( ident int(32), # REL 4 + lang varchar(8) not null, file varchar(128) binary, line int(32), - INDEX (ident) + INDEX (ident), + INDEX (lang) ); CREATE TABLE articles( ident int(32) not null, # REL 1 subindex int(32) not null, - lang varchar(8), -- FIXME + lang varchar(8), meaning blob, INDEX (ident), INDEX (subindex), @@ -94,11 +96,13 @@ CREATE TABLE articles( CREATE TABLE topic( ident int(32) not null auto_increment, # REL 2 + lang varchar(8) not null, title varchar(128) not null, category int(32) not null, # REL 5 UNIQUE (ident), INDEX (title), - INDEX (title,category) + INDEX (title,category), + INDEX (lang) ); CREATE TABLE topic_tab ( @@ -110,9 +114,11 @@ CREATE TABLE topic_tab ( CREATE TABLE category ( category int(32) not null auto_increment, # REL 5 + lang varchar(8) not null, title varchar(128) not null, description blob, - UNIQUE (category) + UNIQUE (category), + INDEX (lang) ); CREATE TABLE links( |