diff options
author | Sergey Poznyakoff <gray@gnu.org.ua> | 2004-09-28 15:58:09 +0000 |
---|---|---|
committer | Sergey Poznyakoff <gray@gnu.org.ua> | 2004-09-28 15:58:09 +0000 |
commit | 0b315ce875985af58a7d7d8640c3074c85de5387 (patch) | |
tree | f9ac42ea9861c4ab17e3b5aee08b692c7cd1e648 /data | |
parent | e3e73709fb31335c1d086fdb542b3f9553298b87 (diff) | |
download | ellinika-0b315ce875985af58a7d7d8640c3074c85de5387.tar.gz ellinika-0b315ce875985af58a7d7d8640c3074c85de5387.tar.bz2 |
Updated
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@174 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-rw-r--r-- | data/db.struct | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/data/db.struct b/data/db.struct index afb5eee..6459f96 100644 --- a/data/db.struct +++ b/data/db.struct @@ -57,6 +57,7 @@ CREATE TABLE dict( ); CREATE TABLE articles( + index int(32) not null auto_increment, # REL 5 ident int(32) not null, # REL 1 subindex int(32) not null, meaning blob, @@ -64,9 +65,17 @@ CREATE TABLE articles( INDEX (subindex) ); +CREATE TABLE reverse( + ident int(32) not null auto_increment, + word varchar(128) binary, + article int(32) # REL 5 +); + CREATE TABLE topic( ident int(32) not null auto_increment, # REL 2 title varchar(128) not null, + type varchar(128), # Defines whether this is a topic or a + # lesson reference or (maybe) something else UNIQUE (ident), INDEX (title) ); |