diff options
author | 2011-06-16 02:25:16 +0530 | |
---|---|---|
committer | 2011-06-16 02:25:16 +0530 | |
commit | d7090ff923b5cc1d6cab963b0f3431f64be31107 (patch) | |
tree | 44ab5040ee6adc6c5f660da6c3b75cc69ad9ef6a | |
parent | fix index page (diff) | |
download | gentoostats-d7090ff923b5cc1d6cab963b0f3431f64be31107.tar.gz gentoostats-d7090ff923b5cc1d6cab963b0f3431f64be31107.tar.bz2 gentoostats-d7090ff923b5cc1d6cab963b0f3431f64be31107.zip |
fix timestamps
-rw-r--r-- | server/host.py | 2 | ||||
-rw-r--r-- | server/sql/init.sql | 4 |
2 files changed, 3 insertions, 3 deletions
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, |