/diceコマンド実行時にbbcodeが処理されない不具合を修正した

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index bc45162..a7fc3c4 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -1,21 +1,26 @@
-CREATE DATABASE IF NOT EXISTS profile;
 grant select,
        insert,
        delete,
-       update,
-       create,
-       drop,
-       file,
-       alter,
-       index on *.* to user identified by 'user';
+       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,
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
+use webchat;
+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),
-       look TEXT,
        password VARCHAR(16),
+       lastmodified DATETIME,
        etc TEXT,
        PRIMARY KEY(name));
+CREATE DATABASE IF NOT EXISTS configure;
+DROP TABLE IF EXISTS ipbanlist;
+CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
+       type CHAR(1));
+DROP TABLE IF EXISTS rooms;
+CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
+       password VARCHAR(16),
+       hiddenlog BOOL);