From 3a351c8de5ca616e0369dc1cbf4a136b91f7152b Mon Sep 17 00:00:00 2001 From: Sergey Poznyakoff Date: Fri, 17 Mar 2006 19:58:44 +0000 Subject: 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 --- data/db.struct | 18 +++++++++++++++--- 1 file 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) ); + -- cgit v1.2.1