aboutsummaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
authorSergey Poznyakoff <gray@gnu.org.ua>2006-03-18 20:53:58 +0000
committerSergey Poznyakoff <gray@gnu.org.ua>2006-03-18 20:53:58 +0000
commit07d7fc9a5255ae20b43de916fe035c72f4506c23 (patch)
tree70c6ec208f86192f982507c3e57fbe989f1f91e8 /data
parent1a673bdd0dd428a8cf94e236fa6c656e1a673536 (diff)
downloadellinika-07d7fc9a5255ae20b43de916fe035c72f4506c23.tar.gz
ellinika-07d7fc9a5255ae20b43de916fe035c72f4506c23.tar.bz2
Finished i18n support
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@369 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-rw-r--r--data/db.struct14
1 files changed, 10 insertions, 4 deletions
diff --git a/data/db.struct b/data/db.struct
index 4113502..9adb900 100644
--- a/data/db.struct
+++ b/data/db.struct
@@ -77,15 +77,17 @@ CREATE TABLE dict(
CREATE TABLE locus(
ident int(32), # REL 4
+ lang varchar(8) not null,
file varchar(128) binary,
line int(32),
- INDEX (ident)
+ INDEX (ident),
+ INDEX (lang)
);
CREATE TABLE articles(
ident int(32) not null, # REL 1
subindex int(32) not null,
- lang varchar(8), -- FIXME
+ lang varchar(8),
meaning blob,
INDEX (ident),
INDEX (subindex),
@@ -94,11 +96,13 @@ CREATE TABLE articles(
CREATE TABLE topic(
ident int(32) not null auto_increment, # REL 2
+ lang varchar(8) not null,
title varchar(128) not null,
category int(32) not null, # REL 5
UNIQUE (ident),
INDEX (title),
- INDEX (title,category)
+ INDEX (title,category),
+ INDEX (lang)
);
CREATE TABLE topic_tab (
@@ -110,9 +114,11 @@ CREATE TABLE topic_tab (
CREATE TABLE category (
category int(32) not null auto_increment, # REL 5
+ lang varchar(8) not null,
title varchar(128) not null,
description blob,
- UNIQUE (category)
+ UNIQUE (category),
+ INDEX (lang)
);
CREATE TABLE links(

Return to:

Send suggestions and report system problems to the System administrator.