diff options
author | Sergey Poznyakoff <gray@gnu.org.ua> | 2005-02-09 11:05:55 +0000 |
---|---|---|
committer | Sergey Poznyakoff <gray@gnu.org.ua> | 2005-02-09 11:05:55 +0000 |
commit | 4c354f3cefd9a79c3454905e27a57b59886bbe70 (patch) | |
tree | 858ea46521f600aa223993fc807d84890702b451 /data | |
parent | 27cae6b6a290cb7f708a891b97f7ef2a6a3bcd5c (diff) | |
download | ellinika-4c354f3cefd9a79c3454905e27a57b59886bbe70.tar.gz ellinika-4c354f3cefd9a79c3454905e27a57b59886bbe70.tar.bz2 |
(topic.category): New column
(category): New table
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@291 941c8c0f-9102-463b-b60b-cd22ce0e6858
Diffstat (limited to 'data')
-rw-r--r-- | data/db.struct | 31 |
1 files changed, 29 insertions, 2 deletions
diff --git a/data/db.struct b/data/db.struct index f68e077..663ed13 100644 --- a/data/db.struct +++ b/data/db.struct @@ -1,3 +1,21 @@ +# This file is part of Ellinika +# Copyright (C) 2004, 2005 Sergey Poznyakoff +# +# Ellinika is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 2 of the License, or +# (at your option) any later version. +# +# Ellinika is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with Ellinika; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. +# + CREATE DATABASE ellinika; use ellinika @@ -73,9 +91,11 @@ CREATE TABLE articles( CREATE TABLE topic( ident int(32) not null auto_increment, # REL 2 - title varchar(128) not null, + title varchar(128) not null, + category int(32) not null, # REL 5 UNIQUE (ident), - INDEX (title) + INDEX (title), + INDEX (title,category) ); CREATE TABLE topic_tab ( @@ -85,6 +105,13 @@ CREATE TABLE topic_tab ( INDEX (word_ident) ); +CREATE TABLE category ( + category int(32) not null auto_increment, # REL 5 + title varchar(128) not null, + description blob, + UNIQUE (category) +); + CREATE TABLE links( type enum('XREF','ANT') not null, ident int(32) not null, # REL 1 |