diff options
| author | Andrew Dolgov <[email protected]> | 2007-04-18 07:25:51 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2007-04-18 07:25:51 +0100 |
| commit | 155a2a53ffc4fac6299cc165cfc56114a61873f7 (patch) | |
| tree | 0175f8c3cc74116b0498039dee4071153c0f2392 | |
| parent | 21f4756a3f2589c68c8f58fd6111678c0f8af04c (diff) | |
schema: add (unused) ttrss_feeds.auth_pass_encrypted, bump schema
| -rw-r--r-- | backend.php | 2 | ||||
| -rw-r--r-- | schema/ttrss_schema_mysql.sql | 1 | ||||
| -rw-r--r-- | schema/ttrss_schema_pgsql.sql | 3 | ||||
| -rw-r--r-- | schema/versions/mysql/16.sql | 6 | ||||
| -rw-r--r-- | schema/versions/pgsql/16.sql | 6 | ||||
| -rw-r--r-- | update.php | 2 |
6 files changed, 17 insertions, 3 deletions
diff --git a/backend.php b/backend.php index 45c978023..7c67ae639 100644 --- a/backend.php +++ b/backend.php @@ -12,7 +12,7 @@ error_reporting(DEFAULT_ERROR_LEVEL); */ - define('SCHEMA_VERSION', 15); + define('SCHEMA_VERSION', 16); require_once "sanity_check.php"; require_once "config.php"; diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 0afcac5d7..10db9b7e9 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -68,6 +68,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, rtl_content bool not null default false, hidden bool not null default false, include_in_digest boolean not null default true, + auth_pass_encrypted boolean not null default false, index(owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE, index(cat_id), diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 4501ef1c0..e65fdce4a 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -63,7 +63,8 @@ create table ttrss_feeds (id serial not null primary key, auth_pass varchar(250) not null default '', hidden boolean not null default false, include_in_digest boolean not null default true, - rtl_content boolean not null default false); + rtl_content boolean not null default false, + auth_pass_encrypted boolean not null default false); create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); diff --git a/schema/versions/mysql/16.sql b/schema/versions/mysql/16.sql new file mode 100644 index 000000000..00034df33 --- /dev/null +++ b/schema/versions/mysql/16.sql @@ -0,0 +1,6 @@ +alter table ttrss_feeds add column auth_pass_encrypted bool; +update ttrss_feeds set auth_pass_encrypted = false; +alter table ttrss_feeds change auth_pass_encrypted auth_pass_encrypted bool not null; +alter table ttrss_feeds alter column auth_pass_encrypted set default false; + +update ttrss_version set schema_version = 16; diff --git a/schema/versions/pgsql/16.sql b/schema/versions/pgsql/16.sql new file mode 100644 index 000000000..996e9a5dd --- /dev/null +++ b/schema/versions/pgsql/16.sql @@ -0,0 +1,6 @@ +alter table ttrss_feeds add column auth_pass_encrypted boolean; +update ttrss_feeds set auth_pass_encrypted = false; +alter table ttrss_feeds alter column auth_pass_encrypted set not null; +alter table ttrss_feeds alter column auth_pass_encrypted set default false; + +update ttrss_version set schema_version = 16; diff --git a/update.php b/update.php index bab0543df..665ec9495 100644 --- a/update.php +++ b/update.php @@ -25,7 +25,7 @@ exit; } - define('SCHEMA_VERSION', 15); + define('SCHEMA_VERSION', 16); ?> |