プロフィールの項目をカスタマイズできるようにした

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 058468c..4f7f04a 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -7,17 +7,24 @@ CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
 use webchat;
 DROP TABLE IF EXISTS list;
 CREATE TABLE list(
+# does not edit
+# from
        name_hash INT UNSIGNED NOT NULL,
        name VARCHAR(64) NOT NULL,
-       age SMALLINT  UNSIGNED DEFAULT 0,
        lastmodified DATETIME,
+       password VARCHAR(32),
+# to
+       mailto VARCHAR(255),
+       age SMALLINT  UNSIGNED DEFAULT 0,
        height SMALLINT  UNSIGNED DEFAULT 0,
        weight SMALLINT  UNSIGNED DEFAULT 0,
        gender VARCHAR(8),
        race VARCHAR(64),
-       password VARCHAR(32),
        etc TEXT,
+# does not edit
+# from
        PRIMARY KEY(name_hash));
+# to
 
 DROP TABLE IF EXISTS ipbanlist;
 CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,