- reglogdb: integer type of timestamp is easier for processing (sort).

git-svn-id: http://opensvn.csie.org/pttbbs/trunk/pttbbs@4133 63ad8ddf-47c3-0310-b6dd-a9e9d9715204

1 files changed, 3 insertions, 3 deletions

diff --git a/upgrade/r4132_reglog2db.py b/upgrade/r4132_reglog2db.py
index 5fe7ed49..b5e47e8f 100755
--- a/upgrade/r4132_reglog2db.py
+++ b/upgrade/r4132_reglog2db.py
@@ -22,10 +22,10 @@ def initdb(dbfn) :
     # since the 'rejected' is rarely used...
     c.execute('create table if not exists approved ' +
             '(uid text, name text, career text, ' +
-            ' addr text, phone text, date text, approved text)');
+            ' addr text, phone text, date integer, approved text)');
     c.execute('create table if not exists rejected ' +
             '(uid text, name text, career text, ' +
-            ' addr text, phone text, date text, rejected text)');
+            ' addr text, phone text, date integer, rejected text)');
     return (db, c)
 
 def processblk(m) :
@@ -100,7 +100,7 @@ for s in f :
             sys.exit(-1)
         v = v[0] + ' ' + v[1]
         # build timestamp
-        v = str(int(time.mktime(time.strptime(v, "%m/%d/%Y %H:%M:%S"))))
+        v = int(time.mktime(time.strptime(v, "%m/%d/%Y %H:%M:%S")))
     m[k] = v
 
 f.close()