summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2011-11-11 00:02:16 +0400
committerAndrew Dolgov <[email protected]>2011-11-11 00:02:16 +0400
commit17140b71edaad9160742a33f094f94479bbbd573 (patch)
treec7591065824d63cd189ef4a5bf5ebf5010030482 /schema
parent9837ac6691c28d1b055b3313e07153ade2dc2dbe (diff)
fix drop table
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_pgsql.sql62
1 files changed, 31 insertions, 31 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 1b065b4cd..6e56134fa 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -1,34 +1,34 @@
-drop table ttrss_linked_feeds;
-drop table ttrss_linked_instances;
-drop table ttrss_access_keys;
-drop table ttrss_user_labels2;
-drop table ttrss_labels2;
-drop table ttrss_feedbrowser_cache;
-drop table ttrss_version;
-drop table ttrss_labels;
-drop table ttrss_filters;
-drop table ttrss_filter_types;
-drop table ttrss_filter_actions;
-drop table ttrss_user_prefs;
-drop table ttrss_prefs;
-drop table ttrss_prefs_types;
-drop table ttrss_prefs_sections;
-drop table ttrss_tags;
-drop table ttrss_enclosures;
-drop table ttrss_settings_profiles;
-drop table ttrss_entry_comments;
-drop table ttrss_user_entries;
-drop table ttrss_entries;
-drop table ttrss_scheduled_updates;
-drop table ttrss_counters_cache;
-drop table ttrss_cat_counters_cache;
-drop table ttrss_archived_feeds;
-drop table ttrss_feeds;
-drop table ttrss_feed_categories;
-drop table ttrss_users;
-drop table ttrss_themes;
-drop table ttrss_sessions;
-drop function SUBSTRING_FOR_DATE(timestamp, int, int);
+drop table if exists ttrss_linked_feeds;
+drop table if exists ttrss_linked_instances;
+drop table if exists ttrss_access_keys;
+drop table if exists ttrss_user_labels2;
+drop table if exists ttrss_labels2;
+drop table if exists ttrss_feedbrowser_cache;
+drop table if exists ttrss_version;
+drop table if exists ttrss_labels;
+drop table if exists ttrss_filters;
+drop table if exists ttrss_filter_types;
+drop table if exists ttrss_filter_actions;
+drop table if exists ttrss_user_prefs;
+drop table if exists ttrss_prefs;
+drop table if exists ttrss_prefs_types;
+drop table if exists ttrss_prefs_sections;
+drop table if exists ttrss_tags;
+drop table if exists ttrss_enclosures;
+drop table if exists ttrss_settings_profiles;
+drop table if exists ttrss_entry_comments;
+drop table if exists ttrss_user_entries;
+drop table if exists ttrss_entries;
+drop table if exists ttrss_scheduled_updates;
+drop table if exists ttrss_counters_cache;
+drop table if exists ttrss_cat_counters_cache;
+drop table if exists ttrss_archived_feeds;
+drop table if exists ttrss_feeds;
+drop table if exists ttrss_feed_categories;
+drop table if exists ttrss_users;
+drop table if exists ttrss_themes;
+drop table if exists ttrss_sessions;
+drop function if exists SUBSTRING_FOR_DATE(timestamp, int, int);
begin;