diff options
author | Sergey Poznyakoff <gray@gnu.org.ua> | 2005-03-29 16:20:33 +0000 |
---|---|---|
committer | Sergey Poznyakoff <gray@gnu.org.ua> | 2005-03-29 16:20:33 +0000 |
commit | 95827d8054cecf2f54faac954c7c16ae9b35ddb3 (patch) | |
tree | 5dfedcc796ac88d16468b44502643fb32e06470d | |
parent | 2e4d2e4cf75ab8e249753c3b6ad799f7121eeb52 (diff) | |
download | ellinika-95827d8054cecf2f54faac954c7c16ae9b35ddb3.tar.gz ellinika-95827d8054cecf2f54faac954c7c16ae9b35ddb3.tar.bz2 |
Updated for mysql >= 4.1.10
git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@321 941c8c0f-9102-463b-b60b-cd22ce0e6858
-rw-r--r-- | data/db.struct | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/data/db.struct b/data/db.struct index 86a843a..b5df912 100644 --- a/data/db.struct +++ b/data/db.struct @@ -16,12 +16,12 @@ # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. # -CREATE DATABASE ellinika; +CREATE DATABASE ellinika CHARACTER SET utf8; use ellinika CREATE TABLE pos( id bigint not null, # REL 0 - name char(64) not null, + name char(64) not null , abbr char(12) not null, abbr_lat char(12) not null, canonical enum('Y','N') not null default 'Y', @@ -66,8 +66,8 @@ INSERT INTO pos VALUES(conv("2000000",16,10), "σύνδεσμος", "σύν CREATE TABLE dict( ident int(32), # REL 1,3,4 - word varchar(128) binary, # REL 4 - sound varchar(128) binary, + word varchar(128), # REL 4 + sound varchar(128), pos int(4), # REL 0 forms blob, INDEX (ident), @@ -128,7 +128,7 @@ CREATE TABLE stat( CREATE TABLE pending_links( type enum('CLOSED','XREF','ANT') not null, originator int(32) not null, # REL 3 - word varchar(128) binary, # REL 4 + word varchar(128) # REL 4 ); CREATE TABLE news( |