/* -*-sql-*-
 *
 * Plain old SQL for setting up the tables for Odin web services.
 */

begin;
alter table odin_shorturl rename column stamp to oldstamp;
alter table odin_shorturl add column stamp bigint not null default 0;
update odin_shorturl set stamp = extract(epoch from oldstamp);
commit;

begin;
alter table odin_shorturl drop column oldstamp;
alter table odin_shorturl alter column stamp drop default;
commit;
