2165d6279fc2cc4edef3c940ebc46742aee0129a
3 * Plain old SQL for setting up the tables for Odin web services.
7 alter table odin_shorturl
rename column stamp
to oldstamp
;
8 alter table odin_shorturl
add column stamp
bigint not null default 0;
9 update odin_shorturl
set stamp
= extract(epoch
from oldstamp
);
13 alter table odin_shorturl
drop column oldstamp
;
14 alter table odin_shorturl
alter column stamp
drop default;