From d7090ff923b5cc1d6cab963b0f3431f64be31107 Mon Sep 17 00:00:00 2001 From: Vikraman Choudhury Date: Thu, 16 Jun 2011 02:25:16 +0530 Subject: fix timestamps --- server/host.py | 2 +- server/sql/init.sql | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'server') diff --git a/server/host.py b/server/host.py index 50df581..f737a6d 100644 --- a/server/host.py +++ b/server/host.py @@ -117,7 +117,7 @@ class Host(object): rkey = helpers.get_rkey(db, post_data_pkg['REPO']) # Insert in INSTALLED_PACKAGES - ipkey = db.insert('INSTALLED_PACKAGES', UUID=uuid, PKEY=pkey, BUILD_TIME=post_data_pkg['BUILD_TIME'], + ipkey = db.insert('INSTALLED_PACKAGES', UUID=uuid, PKEY=pkey, BUILD_TIME=int(post_data_pkg['BUILD_TIME']), COUNTER=post_data_pkg['COUNTER'], KWKEY=kwkey, RKEY=rkey, SIZE=post_data_pkg['SIZE']) # Insert in PLUS_USEFLAGS diff --git a/server/sql/init.sql b/server/sql/init.sql index 70b1ba7..5d7d6ab 100644 --- a/server/sql/init.sql +++ b/server/sql/init.sql @@ -37,7 +37,7 @@ create table `ENV` ( `FFLAGS` varchar (64), `LDFLAGS` varchar (64), `MAKEOPTS` varchar (8), - `LASTSYNC` timestamp null default null, + `LASTSYNC` varchar(32), `PROFILE` varchar (64), `SYNC` varchar (128), primary key (`UUID`), @@ -127,7 +127,7 @@ create table `INSTALLED_PACKAGES` ( `IPKEY` serial, `UUID` binary (16), `PKEY` bigint unsigned, - `build_time` timestamp null default null, + `BUILD_TIME` bigint unsigned, `COUNTER` bigint unsigned, `KWKEY` bigint unsigned, `RKEY` bigint unsigned, -- cgit v1.2.3-65-gdbad