From 57e24c82675e37ea9262e54e30836596caf77e76 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 22 Nov 2010 16:26:00 +0300 Subject: add experimental support for Twitter OAuth and Twitter feeds (bump schema) --- schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 3 ++- schema/versions/mysql/76.sql | 8 ++++++++ schema/versions/pgsql/76.sql | 8 ++++++++ 4 files changed, 20 insertions(+), 2 deletions(-) create mode 100644 schema/versions/mysql/76.sql create mode 100644 schema/versions/pgsql/76.sql (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index e50b72818..e64df5a90 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -52,6 +52,7 @@ create table ttrss_users (id integer primary key not null auto_increment, email_digest bool not null default false, last_digest_sent datetime default null, created datetime default null, + twitter_oauth longtext default null, index (theme_id), foreign key (theme_id) references ttrss_themes(id)) TYPE=InnoDB DEFAULT CHARSET=UTF8; @@ -257,7 +258,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (75); +insert into ttrss_version values (76); 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 af96b5fd1..fbbcab05b 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -48,6 +48,7 @@ create table ttrss_users (id serial not null primary key, full_name varchar(250) not null default '', email_digest boolean not null default false, last_digest_sent timestamp default null, + twitter_oauth text default null, created timestamp default null, theme_id integer references ttrss_themes(id) default null); @@ -228,7 +229,7 @@ create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (75); +insert into ttrss_version values (76); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/76.sql b/schema/versions/mysql/76.sql new file mode 100644 index 000000000..95c352b45 --- /dev/null +++ b/schema/versions/mysql/76.sql @@ -0,0 +1,8 @@ +begin; + +alter table ttrss_users add column twitter_oauth longtext; +alter table ttrss_users alter column twitter_oauth set default null; + +update ttrss_version set schema_version = 76; + +commit; diff --git a/schema/versions/pgsql/76.sql b/schema/versions/pgsql/76.sql new file mode 100644 index 000000000..b7cc12c7a --- /dev/null +++ b/schema/versions/pgsql/76.sql @@ -0,0 +1,8 @@ +begin; + +alter table ttrss_users add column twitter_oauth text; +alter table ttrss_users alter column twitter_oauth set default null; + +update ttrss_version set schema_version = 76; + +commit; -- cgit v1.2.3