X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F051-bin5-places.sql;h=6f8d7ad9e4417f5efc896c6f861ba3b92ef02bb8;hp=ebf3add6538d98c1ce2890d812911de99661c7e4;hb=484a365c1e66ba4b878117275423a1594c209960;hpb=31bfc5e122ec3db5c70e2587a23fabd0dae5ee33 diff --git a/sql/sql.d/051-bin5-places.sql b/sql/sql.d/051-bin5-places.sql index ebf3add..6f8d7ad 100644 --- a/sql/sql.d/051-bin5-places.sql +++ b/sql/sql.d/051-bin5-places.sql @@ -6,14 +6,14 @@ -- wee = 4 -- -DROP TABLE #PFX#bin5_places_mtime; +DROP TABLE IF EXISTS #PFX#bin5_places_mtime; CREATE TABLE #PFX#bin5_places_mtime ( code int, mtime timestamp ); INSERT INTO #PFX#bin5_places_mtime (code, mtime) VALUES (0, now()); -DROP TABLE #PFX#bin5_places; +DROP TABLE IF EXISTS #PFX#bin5_places; CREATE TABLE #PFX#bin5_places ( type integer, rank integer,