summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-09-08 10:35:05 +0100
committerAndrew Dolgov <[email protected]>2005-09-08 10:35:05 +0100
commita82065a18b430f808799634cf1132c9921a5f18b (patch)
tree8e7eb0536f5daf99b6ab05e6fa572fca46215349 /schema
parent7f4bd25627184798f9aa38e164dfa902172b3375 (diff)
no entries found -> no articles found
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index b7267e3b7..0ed2b8df5 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -60,11 +60,11 @@ create table ttrss_filters (id integer primary key auto_increment,
reg_exp varchar(250) not null,
description varchar(250) not null default '') TYPE=InnoDB;
-drop table ttrss_labels;
+drop table if exists ttrss_labels;
-create table ttrss_labels (id integer primary key auto increment,
+create table ttrss_labels (id integer primary key auto_increment,
sql_exp varchar(250) not null,
- description varchar(250) not null);
+ description varchar(250) not null) TYPE=InnoDB;
insert into ttrss_labels (sql_exp,description) values ('title = \'Interesting Topic\'',
'Example Label');