aboutsummaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
authorSergey Poznyakoff <gray@gnu.org.ua>2005-02-09 11:05:55 +0000
committerSergey Poznyakoff <gray@gnu.org.ua>2005-02-09 11:05:55 +0000
commit4c354f3cefd9a79c3454905e27a57b59886bbe70 (patch)
tree858ea46521f600aa223993fc807d84890702b451 /data
parent27cae6b6a290cb7f708a891b97f7ef2a6a3bcd5c (diff)
downloadellinika-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.struct31
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

Return to:

Send suggestions and report system problems to the System administrator.