プロフィールのテーブル名を変更した

diff --git a/init.js b/init.js
index d8729e5..9df557e 100644 (file)
--- a/init.js
+++ b/init.js
@@ -45,11 +45,11 @@ if("lastmodified" in config.alias)
 
 async.waterfall([
        function(next){
-               var query = GetDropTableQuery("list"); 
+               var query = GetDropTableQuery("profilelist"); 
                pool.query(query,null,next);
        },
        function(result,next){
-               var query = GetCreateQuery(config.alias,"list"); 
+               var query = GetCreateQuery(config.alias,"profilelist"); 
                pool.query(query,null,next);
        },
        function(result,next){

diff --git a/profile.js b/profile.js
index df5804c..f6c8985 100644 (file)
--- a/profile.js
+++ b/profile.js
@@ -275,7 +275,7 @@ function ProfileCollection()
        this.AuthAsync = function(name,password,cb){\r
                async.waterfall([\r
                        function(next){\r
-                               pool.query("SELECT password FROM list WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],next);\r
+                               pool.query("SELECT password FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],next);\r
                        },\r
                        function(result,next){\r
                                if(result[0].password == md5_hex(password))\r
@@ -286,32 +286,32 @@ function ProfileCollection()
                ],cb);\r
        }\r
        this.GetAsync = function(name,cb){\r
-               pool.query("SELECT * FROM list WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
+               pool.query("SELECT * FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
        }\r
        this.AddAsync = function(data,cb){\r
                var item = GetItem(data);;\r
-               pool.query("INSERT INTO list SET ?",[item],cb);\r
+               pool.query("INSERT INTO profilelist SET ?",[item],cb);\r
        }\r
        this.UpdatAsync = function(name,data,newpassword,cb){\r
                var item = GetItem(data);\r
                if(newpassword != null)\r
                        item.password = md5_hex(newpassword);\r
-               pool.query("UPDATE list SET ? WHERE name = ?",[item,name],cb);\r
+               pool.query("UPDATE profilelist SET ? WHERE name = ?",[item,name],cb);\r
        }\r
        this.ClearAsync = function(cb){\r
-               pool.query("TRUNCATE TABLE list",null,cb);\r
+               pool.query("TRUNCATE TABLE profilelist",null,cb);\r
        }\r
        this.RemoveRangeAsync = function(names,cb){\r
-               pool.query("DELETE FROM list WHERE name IN (?)",[names],cb);\r
+               pool.query("DELETE FROM profilelist WHERE name IN (?)",[names],cb);\r
        }\r
        this.RemoveAsync = function(name,cb){\r
-               pool.query("DELETE FROM list WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
+               pool.query("DELETE FROM profilelist WHERE name_hash = ? and name = ?",[murmurhash.v3(name),name],cb);\r
        }\r
        this.FindByNameAsync = function(pattern,start,count,cb){\r
-               pool.query("SELECT * FROM list WHERE name LIKE ? LIMIT ?,?",[pattern+"%",start,count],cb);\r
+               pool.query("SELECT * FROM profilelist WHERE name LIKE ? LIMIT ?,?",[pattern+"%",start,count],cb);\r
        }\r
        this.ToArrayAsync = function(start,count,cb){\r
-               pool.query("SELECT name,lastmodified FROM list LIMIT ?,?",[start,count],cb);\r
+               pool.query("SELECT name,lastmodified FROM profilelist LIMIT ?,?",[start,count],cb);\r
        }\r
 \r
        var crypto = require("crypto");\r