aboutsummaryrefslogtreecommitdiff
path: root/data/db.struct
diff options
context:
space:
mode:
Diffstat (limited to 'data/db.struct')
-rw-r--r--data/db.struct9
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)
);

Return to:

Send suggestions and report system problems to the System administrator.