管理コンソール操作後、元の画面に戻れない不具合を修正した

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 42e084e..e41a128 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -1,23 +1,8 @@
 grant select,
        insert,
        delete,
+       create,
+       drop,
        update on *.* to user identified by 'user';
 flush privileges;
-CREATE DATABASE IF NOT EXISTS profile;
-use profile;
-DROP TABLE IF EXISTS list;
-CREATE TABLE list(name VARCHAR(64) NOT NULL,
-       age SMALLINT  UNSIGNED DEFAULT 0,
-       height SMALLINT  UNSIGNED DEFAULT 0,
-       weight SMALLINT  UNSIGNED DEFAULT 0,
-       gender VARCHAR(8),
-       race VARCHAR(64),
-       password VARCHAR(16),
-       lastmodified DATETIME,
-       etc TEXT,
-       PRIMARY KEY(name));
-CREATE DATABASE IF NOT EXISTS configure;
-use configure;
-DROP TABLE IF EXISTS ipbanlist;
-CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
-       type CHAR(1));
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;