diff options
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 6 |
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'); |