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

Return to:

Send suggestions and report system problems to the System administrator.