name_hashは被る可能性があるので、primaryではなくindexを指定するようにした

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 9b510c5..5d25fd2 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -1,22 +1,9 @@
-CREATE DATABASE IF NOT EXISTS profile;
 grant select,
        insert,
        delete,
-       update,
        create,
        drop,
-       file,
-       alter,
-       index on *.* to user identified by 'user';
+       index,
+       update on *.* to user identified by 'user';
 flush privileges;
-use profile;
-create table list(name VARCHAR(64) NOT NULL,
-       age INT,
-       height INT,
-       weight INT,
-       race VARCHAR(64),
-       look TEXT,
-       password VARCHAR(16),
-       lastmodified DATETIME,
-       etc TEXT,
-       PRIMARY KEY(name));
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;