init.jsでテーブルの定義を行うようにした

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 4f7f04a..3d2bd2f 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -4,33 +4,3 @@ grant select,
        update on *.* to user identified by 'user';
 flush privileges;
 CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
-use webchat;
-DROP TABLE IF EXISTS list;
-CREATE TABLE list(
-# does not edit
-# from
-       name_hash INT UNSIGNED NOT NULL,
-       name VARCHAR(64) NOT NULL,
-       lastmodified DATETIME,
-       password VARCHAR(32),
-# to
-       mailto VARCHAR(255),
-       age SMALLINT  UNSIGNED DEFAULT 0,
-       height SMALLINT  UNSIGNED DEFAULT 0,
-       weight SMALLINT  UNSIGNED DEFAULT 0,
-       gender VARCHAR(8),
-       race VARCHAR(64),
-       etc TEXT,
-# does not edit
-# from
-       PRIMARY KEY(name_hash));
-# to
-
-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);