From 70f6dbb10b5354500c7979d4f090f9a8ec9d3092 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 20 Mar 2006 11:28:14 +0100 Subject: experimental RTL support features (schema, version bump) --- schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql | 20 ++++++++++++++++++++ schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql | 24 ++++++++++++++++++++++++ schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 5 +++-- schema/upgrade-1.1.3-1.1.4-mysql.sql | 20 -------------------- schema/upgrade-1.1.3-1.1.4-pgsql.sql | 24 ------------------------ schema/upgrade-1.1.4-1.1.5-mysql.sql | 9 +++++++++ schema/upgrade-1.1.4-1.1.5-pgsql.sql | 12 ++++++++++++ 8 files changed, 70 insertions(+), 47 deletions(-) create mode 100644 schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql create mode 100644 schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql delete mode 100644 schema/upgrade-1.1.3-1.1.4-mysql.sql delete mode 100644 schema/upgrade-1.1.3-1.1.4-pgsql.sql create mode 100644 schema/upgrade-1.1.4-1.1.5-mysql.sql create mode 100644 schema/upgrade-1.1.4-1.1.5-pgsql.sql (limited to 'schema') diff --git a/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql b/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql new file mode 100644 index 000000000..1018bcf4d --- /dev/null +++ b/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql @@ -0,0 +1,20 @@ +alter table ttrss_entries add column author varchar(250); + +update ttrss_entries set author = ''; + +alter table ttrss_entries change author author varchar(250) not null; +alter table ttrss_entries alter column author set default ''; + +create table ttrss_sessions (id varchar(250) not null primary key, + data text, + expire integer not null, + ip_address varchar(15) not null default '', + index (id), + index (expire)) TYPE=InnoDB; + +delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH'; + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2); + +update ttrss_version set schema_version = 6; + diff --git a/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql b/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql new file mode 100644 index 000000000..6c406495d --- /dev/null +++ b/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql @@ -0,0 +1,24 @@ +begin; + +alter table ttrss_entries add column author varchar(250); + +update ttrss_entries set author = ''; + +alter table ttrss_entries alter column author set not null; +alter table ttrss_entries alter column author set default ''; + +create table ttrss_sessions (id varchar(250) unique not null primary key, + data text, + expire integer not null, + ip_address varchar(15) not null default ''); + +create index ttrss_sessions_id_index on ttrss_sessions(id); +create index ttrss_sessions_expire_index on ttrss_sessions(expire); + +delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH'; + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2); + +update ttrss_version set schema_version = 6; + +commit; diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index f629b7570..7f96362b8 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -59,6 +59,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, auth_pass varchar(250) not null default '', parent_feed integer default null, private bool not null default false, + rtl_content bool not null default false, index(owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE, index(cat_id), @@ -174,7 +175,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB; -insert into ttrss_version values (6); +insert into ttrss_version values (7); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null) TYPE=InnoDB; diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 2fd548efe..7013228fb 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -54,7 +54,8 @@ create table ttrss_feeds (id serial not null primary key, auth_login varchar(250) not null default '', parent_feed integer default null references ttrss_feeds(id) on delete set null, private boolean not null default false, - auth_pass varchar(250) not null default ''); + auth_pass varchar(250) not null default '', + rtl_content boolean not null default false); create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); @@ -156,7 +157,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (6); +insert into ttrss_version values (7); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); diff --git a/schema/upgrade-1.1.3-1.1.4-mysql.sql b/schema/upgrade-1.1.3-1.1.4-mysql.sql deleted file mode 100644 index 1018bcf4d..000000000 --- a/schema/upgrade-1.1.3-1.1.4-mysql.sql +++ /dev/null @@ -1,20 +0,0 @@ -alter table ttrss_entries add column author varchar(250); - -update ttrss_entries set author = ''; - -alter table ttrss_entries change author author varchar(250) not null; -alter table ttrss_entries alter column author set default ''; - -create table ttrss_sessions (id varchar(250) not null primary key, - data text, - expire integer not null, - ip_address varchar(15) not null default '', - index (id), - index (expire)) TYPE=InnoDB; - -delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH'; - -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2); - -update ttrss_version set schema_version = 6; - diff --git a/schema/upgrade-1.1.3-1.1.4-pgsql.sql b/schema/upgrade-1.1.3-1.1.4-pgsql.sql deleted file mode 100644 index 6c406495d..000000000 --- a/schema/upgrade-1.1.3-1.1.4-pgsql.sql +++ /dev/null @@ -1,24 +0,0 @@ -begin; - -alter table ttrss_entries add column author varchar(250); - -update ttrss_entries set author = ''; - -alter table ttrss_entries alter column author set not null; -alter table ttrss_entries alter column author set default ''; - -create table ttrss_sessions (id varchar(250) unique not null primary key, - data text, - expire integer not null, - ip_address varchar(15) not null default ''); - -create index ttrss_sessions_id_index on ttrss_sessions(id); -create index ttrss_sessions_expire_index on ttrss_sessions(expire); - -delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH'; - -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2); - -update ttrss_version set schema_version = 6; - -commit; diff --git a/schema/upgrade-1.1.4-1.1.5-mysql.sql b/schema/upgrade-1.1.4-1.1.5-mysql.sql new file mode 100644 index 000000000..2c48e0390 --- /dev/null +++ b/schema/upgrade-1.1.4-1.1.5-mysql.sql @@ -0,0 +1,9 @@ +alter table ttrss_feeds add column rtl_content bool; + +update ttrss_feeds set rtl_content = false; + +alter table ttrss_feeds change rtl_content rtl_content bool not null; +alter table ttrss_feeds alter column rtl_content set default false; + +update ttrss_version set schema_version = 7; + diff --git a/schema/upgrade-1.1.4-1.1.5-pgsql.sql b/schema/upgrade-1.1.4-1.1.5-pgsql.sql new file mode 100644 index 000000000..67bb7d86c --- /dev/null +++ b/schema/upgrade-1.1.4-1.1.5-pgsql.sql @@ -0,0 +1,12 @@ +begin; + +alter table ttrss_feeds add column rtl_content boolean; + +update ttrss_feeds set rtl_content = false; + +alter table ttrss_feeds alter column rtl_content set not null; +alter table ttrss_feeds alter column rtl_content set default false; + +update ttrss_version set schema_version = 7; + +commit; -- cgit v1.2.3