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

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,

diff --git a/profile.js b/profile.js
index 170ce9b..6bcca77 100644 (file)
--- a/profile.js
+++ b/profile.js
@@ -237,7 +237,6 @@ function ProfileCollection()
                        height:data.height,\r
                        weight:data.weight,\r
                        race:data.race,\r
-                       look:data.look,\r
                        password:data.password,\r
                        lastmodified:new Date(),\r
                        etc:data.etc\r
@@ -264,7 +263,6 @@ function ProfileCollection()
                        height:data.height,\r
                        weight:data.weight,\r
                        race:data.race,\r
-                       look:data.look,\r
                        password:data.password,\r
                        lastmodified:new Date(),\r
                        etc:data.etc\r

diff --git a/public/profile/detail.ejs b/public/profile/detail.ejs
index 4dc77d8..d261b61 100644 (file)
--- a/public/profile/detail.ejs
+++ b/public/profile/detail.ejs
@@ -30,10 +30,6 @@
                        <td><%= list[0].race %></td>\r
                </tr>\r
                <tr>\r
-                       <td>外見</td>\r
-                       <td><%= list[0].look %></td>\r
-               </tr>\r
-               <tr>\r
                        <td>備考</td>\r
                        <td><%= list[0].etc %></td>\r
                </tr>\r

diff --git a/public/profile/edit.ejs b/public/profile/edit.ejs
index eeba9f8..d61d5da 100644 (file)
--- a/public/profile/edit.ejs
+++ b/public/profile/edit.ejs
@@ -35,10 +35,6 @@
                                <td><input type="text" value="<%= list[0].race %>" name="race"/></td>\r
                        </tr>\r
                        <tr>\r
-                               <td>外見</td>\r
-                               <td><textarea name="look" rows="4" cols="50"><%= list[0].look %></textarea></td>\r
-                       </tr>\r
-                       <tr>\r
                                <td>備考</td>\r
                                <td><textarea name="etc" rows="4" cols="50"><%= list[0].etc %></textarea></td>\r
                        </tr>\r

diff --git a/public/profile/registor.ejs b/public/profile/registor.ejs
index abc0ecf..2401b49 100644 (file)
--- a/public/profile/registor.ejs
+++ b/public/profile/registor.ejs
@@ -35,10 +35,6 @@
                                <td><input type="text" value="" name="race"/></td>\r
                        </tr>\r
                        <tr>\r
-                               <td>外見</td>\r
-                               <td><textarea name="look" rows="4" cols="50"></textarea></td>\r
-                       </tr>\r
-                       <tr>\r
                                <td>備考</td>\r
                                <td><textarea name="etc" rows="4" cols="50"></textarea></td>\r
                        </tr>\r