chiark
/
gitweb
/
~mdw
/
odin-cgi
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
4d553a6
)
sql/setup-shorturl.sql: Drop old tables if they're missing.
author
Mark Wooding
<mdw@distorted.org.uk>
Sat, 4 Jul 2015 17:00:45 +0000
(18:00 +0100)
committer
Mark Wooding
<mdw@distorted.org.uk>
Sat, 4 Jul 2015 17:00:45 +0000
(18:00 +0100)
sql/setup-shorturl.sql
patch
|
blob
|
blame
|
history
diff --git
a/sql/setup-shorturl.sql
b/sql/setup-shorturl.sql
index b2ff717325f597287bcd7ea27cab298e837e7cc4..3b20463bd2770df0590a444a5c64f22f22a05f09 100644
(file)
--- a/
sql/setup-shorturl.sql
+++ b/
sql/setup-shorturl.sql
@@
-9,8
+9,8
@@
begin;
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);
create table odin_shorturl_seq (seq int);
insert into odin_shorturl_seq (seq) values (10000);