# 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 CREATE TABLE pos( id bigint not null, # REL 0 name char(64) not null, abbr char(12) not null, abbr_lat char(12) not null, canonical enum('Y','N') not null default 'Y', INDEX(id), INDEX(abbr) ); INSERT INTO pos VALUES(0, "άρθρο", "άρθρ.", "art", 'Y'); INSERT INTO pos VALUES(conv("100",16,10), "ουσιαστικό", "ουσ.", "subst", 'Y'); INSERT INTO pos VALUES(conv("101",16,10), "αρσενικό", "ο", "m", 'Y'); INSERT INTO pos VALUES(conv("102",16,10), "θηλυκό", "η", "f", 'Y'); INSERT INTO pos VALUES(conv("104",16,10), "ουδέτερο", "το", "n", 'Y'); INSERT INTO pos VALUES(conv("101",16,10)|2, "αρσενικό και θηλυκό", "ο/η", "m/f", 'N'); INSERT INTO pos VALUES(conv("101",16,10)|2, "αρσενικό και θηλυκό", "ο,η", "m,f", 'Y'); INSERT INTO pos VALUES(conv("101",16,10)|2|4,"αρσενικό,θηλυκό,ουδέτερο", "ο,η,το", "m,f,n", 'N'); INSERT INTO pos VALUES(conv("114",16,10), "πληθυντικό ουδέτερο", "τα", "pl.n", 'Y'); INSERT INTO pos VALUES(conv("200",16,10), "επίθετο", "επίθ.", "adj", 'Y'); INSERT INTO pos VALUES(conv("400",16,10), "επίρρημα", "επίρρ.", "adv", 'Y'); INSERT INTO pos VALUES(conv("800",16,10), "αριθμός", "αριθ.", "num", 'Y'); INSERT INTO pos VALUES(conv("1000",16,10), "αντωνυμία", "αντων.", "pron", 'Y'); INSERT INTO pos VALUES(conv("100000",16,10), "ρήμα", "ρήμα", "v", 'Y'); INSERT INTO pos VALUES(conv("110000",16,10), "μεταβατικό", "μετ.", "vt", 'Y'); INSERT INTO pos VALUES(conv("120000",16,10), "αμετάβατο", "αμετ.", "vi", 'Y'); INSERT INTO pos VALUES(conv("140000",16,10), "απρώσοπο", "απρώσ.", "vimp", 'Y'); INSERT INTO pos VALUES(conv("180000",16,10), "αποθετικό", "αποθ.", "vdep", 'Y'); INSERT INTO pos VALUES(conv("200000",16,10), "επιφώνημα", "επιφ.", "int", 'Y'); INSERT INTO pos VALUES(conv("400000",16,10), "μετοχή", "μετχ.", "part", 'Y'); INSERT INTO pos VALUES(conv("800000",16,10), "μόριο", "μόριο.", "ptc", 'Y'); INSERT INTO pos VALUES(conv("1000000",16,10), "πρόθεση", "πρόθ.", "prep", 'Y'); INSERT INTO pos VALUES(conv("2000000",16,10), "σύνδεσμος", "σύνδ.", "conj", 'Y'); CREATE TABLE dict( ident int(32), # REL 1,3,4 word varchar(128) binary, # REL 4 sound varchar(128) binary, pos int(4), # REL 0 forms blob, INDEX (ident), INDEX (word) ); CREATE TABLE locus( ident int(32), # REL 4 file varchar(128) binary, line int(32), INDEX (ident) ); CREATE TABLE articles( ident int(32) not null, # REL 1 subindex int(32) not null, meaning blob, INDEX (ident), INDEX (subindex) ); CREATE TABLE topic( ident int(32) not null auto_increment, # REL 2 title varchar(128) not null, category int(32) not null, # REL 5 UNIQUE (ident), INDEX (title), INDEX (title,category) ); CREATE TABLE topic_tab ( topic_ident int(32) not null, # REL 2 word_ident int(32) not null, # REL 1 INDEX (topic_ident), 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 xref int(32) not null, # REL 1 INDEX (ident), UNIQUE (ident,xref) ); CREATE TABLE stat( updated datetime not null, count int(32) not null ); CREATE TABLE pending_links( type enum('CLOSED','XREF','ANT') not null, originator int(32) not null, # REL 3 word varchar(128) binary, # REL 4 ); CREATE TABLE news( ident int(32) not null auto_increment, date datetime not null, header varchar(255), text blob, UNIQUE(ident), INDEX(date) );