IPBANLISTをMYSQLのテーブルで定義した

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 06bf100..42e084e 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -1,12 +1,12 @@
-CREATE DATABASE IF NOT EXISTS profile;
 grant select,
        insert,
        delete,
        update on *.* to user identified by 'user';
 flush privileges;
+CREATE DATABASE IF NOT EXISTS profile;
 use profile;
-drop table list;
-create table list(name VARCHAR(64) NOT NULL,
+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,
@@ -16,3 +16,8 @@ create table list(name VARCHAR(64) NOT NULL,
        lastmodified DATETIME,
        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));