X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~mdw/git/odin-cgi/blobdiff_plain/3300e9a2ef069dcea086ac6e510dd6540cd9fc82..07cefc9fbfcd17457b51914d4d7b58ad2416fc18:/sql/update-pastebin-v2.sql

diff --git a/sql/update-pastebin-v2.sql b/sql/update-pastebin-v2.sql
new file mode 100644
index 0000000..be7d2e7
--- /dev/null
+++ b/sql/update-pastebin-v2.sql
@@ -0,0 +1,16 @@
+/* -*-sql-*-
+ *
+ * Plain old SQL for setting up the tables for Odin web services.
+ */
+
+begin;
+alter table odin_pastebin alter column lang set default 'txt';
+alter table odin_pastebin rename column stamp to oldstamp;
+alter table odin_pastebin add column stamp bigint not null default 0;
+update odin_pastebin set stamp = extract(epoch from oldstamp);
+commit;
+
+begin;
+alter table odin_pastebin drop column oldstamp;
+alter table odin_pastebin alter column stamp drop default;
+commit;