aboutsummaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
authorSergey Poznyakoff <gray@gnu.org.ua>2006-03-17 19:58:44 +0000
committerSergey Poznyakoff <gray@gnu.org.ua>2006-03-17 19:58:44 +0000
commit3a351c8de5ca616e0369dc1cbf4a136b91f7152b (patch)
tree5f5dd1be5c32a2f84f3b3d9f7f43bb78c5d93309 /data
parent4633d7f905f174dd89442655ecab69a447b7bd8e (diff)
downloadellinika-3a351c8de5ca616e0369dc1cbf4a136b91f7152b.tar.gz
ellinika-3a351c8de5ca616e0369dc1cbf4a136b91f7152b.tar.bz2
Changes to allow for multi-lingual dictionaries and news tables
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@357 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-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.