diff options
author | Andrew Dolgov <[email protected]> | 2010-10-27 12:05:20 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2010-10-27 12:05:20 +0400 |
commit | 25ea280502fbb0fb7fc51f355df8fc644dfc994d (patch) | |
tree | 1a2eb0a3a5f6d98702ac9340dbb33ee6ebf17a1e /schema | |
parent | 70543b6a400f292c6ed03d0489d0d696d1e13606 (diff) |
add ttrss_entries.date_updated; use date_updated instead of date_enered for expiry checking (bump schema)
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 3 | ||||
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 5 | ||||
-rw-r--r-- | schema/versions/mysql/67.sql | 5 | ||||
-rw-r--r-- | schema/versions/pgsql/67.sql | 9 |
4 files changed, 19 insertions, 3 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 0f4acf900..84eb985d1 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -134,6 +134,7 @@ create table ttrss_entries (id integer not null primary key auto_increment, content_hash varchar(250) not null, no_orig_date bool not null default 0, date_entered datetime not null, + date_updated datetime not null, num_comments integer not null default 0, comments varchar(250) not null default '', author varchar(250) not null default '') TYPE=InnoDB; @@ -240,7 +241,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 (66); +insert into ttrss_version values (67); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 7225f10f8..ea5465dac 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -117,7 +117,8 @@ create table ttrss_entries (id serial not null primary key, content text not null, content_hash varchar(250) not null, no_orig_date boolean not null default false, - date_entered timestamp not null default NOW(), + date_entered timestamp not null, + date_updated timestamp not null, num_comments integer not null default 0, comments varchar(250) not null default '', author varchar(250) not null default ''); @@ -212,7 +213,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 (66); +insert into ttrss_version values (67); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/67.sql b/schema/versions/mysql/67.sql new file mode 100644 index 000000000..b501bf4c3 --- /dev/null +++ b/schema/versions/mysql/67.sql @@ -0,0 +1,5 @@ +alter table ttrss_entries add column date_updated datetime; +update ttrss_entries set date_updated = date_entered; +alter table ttrss_entries change date_updated date_updated datetime not null; + +update ttrss_version set schema_version = 67; diff --git a/schema/versions/pgsql/67.sql b/schema/versions/pgsql/67.sql new file mode 100644 index 000000000..1e2aa4429 --- /dev/null +++ b/schema/versions/pgsql/67.sql @@ -0,0 +1,9 @@ +begin; + +alter table ttrss_entries add column date_updated timestamp; +update ttrss_entries set date_updated = date_entered; +alter table ttrss_entries alter column date_updated set not null; + +update ttrss_version set schema_version = 67; + +commit; |