summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2009-01-18 14:54:40 +0100
committerAndrew Dolgov <[email protected]>2009-01-18 14:54:40 +0100
commite2549229e1a10d8dbb41802d19027741040ab61c (patch)
treea0b6ec0e119345da61e33da5cbb6e5534c03962d /schema
parent814bff66496bb8d57ced77771edcfb4f173ce5ee (diff)
display article labels in headlines buffer
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql12
-rw-r--r--schema/ttrss_schema_pgsql.sql10
2 files changed, 11 insertions, 11 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 8ba72e8f4..11b2106e0 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -400,12 +400,12 @@ create table ttrss_labels2 (id integer not null primary key auto_increment,
foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
) TYPE=InnoDB;
-INSERT INTO ttrss_labels2 (owner_uid, caption) VALUES (1, 'All Articles');
-
-INSERT INTO ttrss_filters (owner_uid, feed_id, filter_type, reg_exp, enabled,
- action_id, action_param, filter_param)
- VALUES (1, NULL, 1, '.', true, 7, 'All Articles', 'before');
-
+--INSERT INTO ttrss_labels2 (owner_uid, caption) VALUES (1, 'All Articles');
+--
+--INSERT INTO ttrss_filters (owner_uid, feed_id, filter_type, reg_exp, enabled,
+-- action_id, action_param, filter_param)
+-- VALUES (1, NULL, 1, '.', true, 7, 'All Articles', 'before');
+--
create table ttrss_user_labels2 (label_id integer not null,
article_id integer not null,
foreign key (label_id) references ttrss_labels2(id) ON DELETE CASCADE,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 6c7f9d98a..b2ea2a596 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -368,11 +368,11 @@ create table ttrss_labels2 (id serial not null primary key,
caption varchar(250) not null
);
-INSERT INTO ttrss_labels2 (owner_uid, caption) VALUES (1, 'All Articles');
-
-INSERT INTO ttrss_filters (owner_uid, feed_id, filter_type, reg_exp, enabled,
- action_id, action_param, filter_param)
- VALUES (1, NULL, 1, '.', true, 7, 'All Articles', 'before');
+--INSERT INTO ttrss_labels2 (owner_uid, caption) VALUES (1, 'All Articles');
+--
+--INSERT INTO ttrss_filters (owner_uid, feed_id, filter_type, reg_exp, enabled,
+-- action_id, action_param, filter_param)
+-- VALUES (1, NULL, 1, '.', true, 7, 'All Articles', 'before');
create table ttrss_user_labels2 (
label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE,