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)
 );