aboutsummaryrefslogtreecommitdiff
path: root/data/db.struct
diff options
context:
space:
mode:
Diffstat (limited to 'data/db.struct')
-rw-r--r--data/db.struct10
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(

Return to:

Send suggestions and report system problems to the System administrator.