chiark / gitweb /
sql/setup-shorturl.sql: Drop old tables if they're missing.
authorMark Wooding <mdw@distorted.org.uk>
Sat, 4 Jul 2015 17:00:45 +0000 (18:00 +0100)
committerMark Wooding <mdw@distorted.org.uk>
Sat, 4 Jul 2015 17:00:45 +0000 (18:00 +0100)
sql/setup-shorturl.sql

index b2ff717325f597287bcd7ea27cab298e837e7cc4..3b20463bd2770df0590a444a5c64f22f22a05f09 100644 (file)
@@ -9,8 +9,8 @@
 
 begin;
 
-drop table odin_shorturl;
-drop table odin_shorturl_seq;
+drop table if exists odin_shorturl;
+drop table if exists odin_shorturl_seq;
 
 create table odin_shorturl_seq (seq int);
 insert into odin_shorturl_seq (seq) values (10000);