From 4c354f3cefd9a79c3454905e27a57b59886bbe70 Mon Sep 17 00:00:00 2001 From: Sergey Poznyakoff Date: Wed, 9 Feb 2005 11:05:55 +0000 Subject: (topic.category): New column (category): New table git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@291 941c8c0f-9102-463b-b60b-cd22ce0e6858 --- data/db.struct | 31 +++++++++++++++++++++++++++++-- 1 file changed, 29 insertions(+), 2 deletions(-) (limited to 'data') 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 -- cgit v1.2.1