aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--server/host.py2
-rw-r--r--server/sql/init.sql4
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,