インデックスハッシュを使用するようにした

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index a7fc3c4..6befa87 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -6,20 +6,23 @@ flush privileges;
 CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
 use webchat;
 DROP TABLE IF EXISTS list;
-CREATE TABLE list(name VARCHAR(64) NOT NULL,
+CREATE TABLE list(
+       name_hash INT UNSIGNED NOT NULL,
+       name VARCHAR(64) NOT NULL,
        age SMALLINT  UNSIGNED DEFAULT 0,
+       lastmodified DATETIME,
        height SMALLINT  UNSIGNED DEFAULT 0,
        weight SMALLINT  UNSIGNED DEFAULT 0,
        gender VARCHAR(8),
        race VARCHAR(64),
        password VARCHAR(16),
-       lastmodified DATETIME,
        etc TEXT,
-       PRIMARY KEY(name));
-CREATE DATABASE IF NOT EXISTS configure;
+       PRIMARY KEY(name_hash));
+
 DROP TABLE IF EXISTS ipbanlist;
 CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
        type CHAR(1));
+
 DROP TABLE IF EXISTS rooms;
 CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
        password VARCHAR(16),