diff options
author | Sergey Poznyakoff <gray@gnu.org.ua> | 2006-03-17 19:58:44 +0000 |
---|---|---|
committer | Sergey Poznyakoff <gray@gnu.org.ua> | 2006-03-17 19:58:44 +0000 |
commit | 3a351c8de5ca616e0369dc1cbf4a136b91f7152b (patch) | |
tree | 5f5dd1be5c32a2f84f3b3d9f7f43bb78c5d93309 /data | |
parent | 4633d7f905f174dd89442655ecab69a447b7bd8e (diff) | |
download | ellinika-3a351c8de5ca616e0369dc1cbf4a136b91f7152b.tar.gz ellinika-3a351c8de5ca616e0369dc1cbf4a136b91f7152b.tar.bz2 |
Changes to allow for multi-lingual dictionaries and news tables
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@357 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-rw-r--r-- | data/db.struct | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/data/db.struct b/data/db.struct index 6d5cdd6..4113502 100644 --- a/data/db.struct +++ b/data/db.struct @@ -85,9 +85,11 @@ CREATE TABLE locus( CREATE TABLE articles( ident int(32) not null, # REL 1 subindex int(32) not null, + lang varchar(8), -- FIXME meaning blob, INDEX (ident), - INDEX (subindex) + INDEX (subindex), + INDEX (lang) ); CREATE TABLE topic( @@ -122,8 +124,10 @@ CREATE TABLE links( ); CREATE TABLE stat( + lang varchar(8) not null, updated datetime not null, count int(32) not null + KEY lang ); CREATE TABLE pending_links( @@ -133,10 +137,18 @@ CREATE TABLE pending_links( ); CREATE TABLE news( - ident int(32) not null auto_increment, + ident int(32) not null auto_increment, # REL 7 date datetime not null, + UNIQUE(ident), + INDEX(date) +); + +CREATE TABLE newsart( + ident int(32) not null, # REL 7 + lang varchar(8), header varchar(255), text blob, UNIQUE(ident), - INDEX(date) + INDEX(lang) ); + |