プロフィール機能を追加した

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
new file mode 100644 (file)
index 0000000..bc45162
--- /dev/null
+++ b/init.sql
@@ -0,0 +1,21 @@
+CREATE DATABASE IF NOT EXISTS profile;
+grant select,
+       insert,
+       delete,
+       update,
+       create,
+       drop,
+       file,
+       alter,
+       index 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));