From 0b315ce875985af58a7d7d8640c3074c85de5387 Mon Sep 17 00:00:00 2001 From: Sergey Poznyakoff Date: Tue, 28 Sep 2004 15:58:09 +0000 Subject: Updated git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@174 941c8c0f-9102-463b-b60b-cd22ce0e6858 --- data/db.struct | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'data/db.struct') 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) ); -- cgit v1.2.1