テーブルのデータ型を変更した

[webchat/WebChat.git] / init.sql

diff --git a/init.sql b/init.sql
index 9b510c5..a86107b 100644 (file)
--- a/init.sql
+++ b/init.sql
@@ -2,20 +2,15 @@ CREATE DATABASE IF NOT EXISTS profile;
 grant select,
        insert,
        delete,
-       update,
-       create,
-       drop,
-       file,
-       alter,
-       index on *.* to user identified by 'user';
+       update on *.* to user identified by 'user';
 flush privileges;
 use profile;
+drop table list;
 create table list(name VARCHAR(64) NOT NULL,
-       age INT,
-       height INT,
-       weight INT,
+       age SMALLINT  UNSIGNED DEFAULT 0,
+       height SMALLINT  UNSIGNED DEFAULT 0,
+       weight SMALLINT  UNSIGNED DEFAULT 0,
        race VARCHAR(64),
-       look TEXT,
        password VARCHAR(16),
        lastmodified DATETIME,
        etc TEXT,