From: Mark Wooding <mdw@distorted.org.uk>
Date: Sat, 4 Jul 2015 17:00:45 +0000 (+0100)
Subject: sql/setup-shorturl.sql: Drop old tables if they're missing.
X-Git-Url: https://www.chiark.greenend.org.uk/ucgi/~mdw/git/odin-cgi/commitdiff_plain/697afe0d09f38e5e1756ebced2543ac758594d7c?ds=sidebyside

sql/setup-shorturl.sql: Drop old tables if they're missing.
---

diff --git a/sql/setup-shorturl.sql b/sql/setup-shorturl.sql
index b2ff717..3b20463 100644
--- a/sql/setup-shorturl.sql
+++ b/sql/setup-shorturl.sql
@@ -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);