X-Git-Url: http://git.osdn.jp/view?a=blobdiff_plain;f=init.sql;h=e41a1280f879af109263d7f768ddbec825190fae;hb=4d42a4a26373e697ec2984ad6d4641973537ea34;hp=f0089fe3247a702bf8ae00ada40baa9b6dfb96e9;hpb=7239a1e045589b849569818554cc68ad453e8bef;p=webchat%2FWebChat.git

diff --git a/init.sql b/init.sql
index f0089fe..e41a128 100644
--- a/init.sql
+++ b/init.sql
@@ -1,26 +1,8 @@
 grant select,
 	insert,
 	delete,
+	create,
+	drop,
 	update on *.* to user identified by 'user';
 flush privileges;
-CREATE DATABASE IF NOT EXISTS webchat;
-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),
-	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);
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;