diff options
author | Sergey Poznyakoff <gray@gnu.org.ua> | 2006-03-18 20:53:58 +0000 |
---|---|---|
committer | Sergey Poznyakoff <gray@gnu.org.ua> | 2006-03-18 20:53:58 +0000 |
commit | 07d7fc9a5255ae20b43de916fe035c72f4506c23 (patch) | |
tree | 70c6ec208f86192f982507c3e57fbe989f1f91e8 /data | |
parent | 1a673bdd0dd428a8cf94e236fa6c656e1a673536 (diff) | |
download | ellinika-07d7fc9a5255ae20b43de916fe035c72f4506c23.tar.gz ellinika-07d7fc9a5255ae20b43de916fe035c72f4506c23.tar.bz2 |
Finished i18n support
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@369 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-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( |