bin/populate-lang-table, mason/pastebin/%show: Add Markdown support.

[odin-cgi] / sql / update-shorturl-v2.sql

/* -*-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;