diff -r cfd5d3270f99 -r c79135c217df server/sources/native.py --- a/server/sources/native.py Tue Dec 22 09:27:28 2009 +0100 +++ b/server/sources/native.py Tue Dec 22 10:27:49 2009 +0100 @@ -579,6 +579,7 @@ def sql_schema(driver): helper = get_adv_func_helper(driver) + tstamp_col_type = helper.TYPE_MAPPING.get('TIMESTAMP', 'TIMESTAMP') schema = """ /* Create the repository's system database */ @@ -588,7 +589,7 @@ eid INTEGER PRIMARY KEY NOT NULL, type VARCHAR(64) NOT NULL, source VARCHAR(64) NOT NULL, - mtime TIMESTAMP NOT NULL, + mtime %s NOT NULL, extid VARCHAR(256) ); CREATE INDEX entities_type_idx ON entities(type); @@ -599,13 +600,13 @@ eid INTEGER PRIMARY KEY NOT NULL, type VARCHAR(64) NOT NULL, source VARCHAR(64) NOT NULL, - dtime TIMESTAMP NOT NULL, + dtime %s NOT NULL, extid VARCHAR(256) ); CREATE INDEX deleted_entities_type_idx ON deleted_entities(type); CREATE INDEX deleted_entities_dtime_idx ON deleted_entities(dtime); CREATE INDEX deleted_entities_extid_idx ON deleted_entities(extid); -""" % helper.sql_create_sequence('entities_id_seq') +""" % (helper.sql_create_sequence('entities_id_seq'), tstamp_col_type, tstamp_col_type) return schema