X-Git-Url: http://git.osdn.jp/view?a=blobdiff_plain;f=init.sql;h=e41a1280f879af109263d7f768ddbec825190fae;hb=dae1e7941a88115304fa798b6de458c8f81c7af7;hp=bc45162a4df80bf6e5b1154536a0ef339233f181;hpb=f96e550254b626a3ea9179ba1d976ab0e24a3cdb;p=webchat%2FWebChat.git

diff --git a/init.sql b/init.sql
index bc45162..e41a128 100644
--- a/init.sql
+++ b/init.sql
@@ -1,21 +1,8 @@
-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,
-	race VARCHAR(64),
-	look TEXT,
-	password VARCHAR(16),
-	etc TEXT,
-	PRIMARY KEY(name));
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;