diff options
Diffstat (limited to 'data/db.struct')
-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( |