データーベース名が別々だとうまく動かないので一つにまとめた

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index f0d7b2b..f0089fe 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -3,8 +3,8 @@ grant select,
        delete,
        update on *.* to user identified by 'user';
 flush privileges;
-CREATE DATABASE IF NOT EXISTS profile;
-use profile;
+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,
@@ -17,7 +17,6 @@ CREATE TABLE list(name VARCHAR(64) NOT NULL,
        etc TEXT,
        PRIMARY KEY(name));
 CREATE DATABASE IF NOT EXISTS configure;
-use configure;
 DROP TABLE IF EXISTS ipbanlist;
 CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
        type CHAR(1));