From e962dedc874695bc349c18697d5b5619dd67305f Mon Sep 17 00:00:00 2001 From: piaip Date: Fri, 11 Apr 2008 18:02:15 +0000 Subject: - 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 --- upgrade/r4132_reglog2db.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'upgrade') 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() -- cgit v1.2.3