From 697afe0d09f38e5e1756ebced2543ac758594d7c Mon Sep 17 00:00:00 2001
Message-Id: <697afe0d09f38e5e1756ebced2543ac758594d7c.1727357625.git.mdw@distorted.org.uk>
From: Mark Wooding <mdw@chiark.greenend.org.uk>
Date: Sat, 4 Jul 2015 18:00:45 +0100
Subject: [PATCH] sql/setup-shorturl.sql: Drop old tables if they're missing.
Organization: Straylight/Edgeware

From: Mark Wooding <mdw@distorted.org.uk>

---
 sql/setup-shorturl.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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);
-- 
[mdw]

