X-Git-Url: http://git.osdn.jp/view?a=blobdiff_plain;f=init.sql;h=e41a1280f879af109263d7f768ddbec825190fae;hb=0301dfbed680897cb05a6dc8ccf0cc5ad51c920e;hp=058468c6bf0d3519c6f0e2e557339d4082716c2f;hpb=f319482c5c7ce11832a35e9089ec0a13ff42d1d4;p=webchat%2FWebChat.git

diff --git a/init.sql b/init.sql
index 058468c..e41a128 100644
--- a/init.sql
+++ b/init.sql
@@ -1,29 +1,8 @@
 grant select,
 	insert,
 	delete,
+	create,
+	drop,
 	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(
-	name_hash INT UNSIGNED NOT NULL,
-	name VARCHAR(64) NOT NULL,
-	age SMALLINT  UNSIGNED DEFAULT 0,
-	lastmodified DATETIME,
-	height SMALLINT  UNSIGNED DEFAULT 0,
-	weight SMALLINT  UNSIGNED DEFAULT 0,
-	gender VARCHAR(8),
-	race VARCHAR(64),
-	password VARCHAR(32),
-	etc TEXT,
-	PRIMARY KEY(name_hash));
-
-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);