From e797001be4cd982ed778bda16744ab4007eb31c8 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Wed, 5 Aug 2009 16:02:47 -0400 Subject: add livetweeter to notice source --- db/notice_source.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') diff --git a/db/notice_source.sql b/db/notice_source.sql index 983ea9150..71fa89344 100644 --- a/db/notice_source.sql +++ b/db/notice_source.sql @@ -22,6 +22,7 @@ VALUES ('IdentiFox','IdentiFox','http://www.bitbucket.org/uncryptic/identifox/', now()), ('identitwitch','IdentiTwitch','http://richfish.org/identitwitch/', now()), ('LaTwit','LaTwit','http://latwit.mac65.com/', now()), + ('livetweeter', 'livetweeter', 'http://addons.songbirdnest.com/addon/1204', now()), ('maisha', 'Maisha', 'http://maisha.grango.org/', now()), ('mbpidgin','mbpidgin','http://code.google.com/p/microblog-purple/', now()), ('Mobidentica', 'Mobidentica', 'http://www.substanceofcode.com/software/mobidentica/', now()), -- cgit v1.2.3-54-g00ecf From 43e1c3d71f0366be96c4d7fe8d6b7d76c7f90498 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 6 Aug 2009 12:30:56 -0400 Subject: add qwit --- db/notice_source.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') diff --git a/db/notice_source.sql b/db/notice_source.sql index 71fa89344..f1d52403b 100644 --- a/db/notice_source.sql +++ b/db/notice_source.sql @@ -35,6 +35,7 @@ VALUES ('pocketwit','PockeTwit','http://code.google.com/p/pocketwit/', now()), ('posty','Posty','http://spreadingfunkyness.com/posty/', now()), ('qtwitter','qTwitter','http://qtwitter.ayoy.net/', now()), + ('qwit', 'Qwit', 'http://code.google.com/p/qwit/', now()), ('royalewithcheese','Royale With Cheese','http://p.hellyeah.org/', now()), ('rssdent','rssdent','http://github.com/zcopley/rssdent/tree/master', now()), ('rygh.no','rygh.no','http://rygh.no/', now()), -- cgit v1.2.3-54-g00ecf From 406020df38642b59f59b42d59c617487386bd4d9 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 6 Aug 2009 12:35:35 -0400 Subject: add LiveTweeter (note caps) --- db/notice_source.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'db') diff --git a/db/notice_source.sql b/db/notice_source.sql index f1d52403b..f590d1b97 100644 --- a/db/notice_source.sql +++ b/db/notice_source.sql @@ -22,6 +22,7 @@ VALUES ('IdentiFox','IdentiFox','http://www.bitbucket.org/uncryptic/identifox/', now()), ('identitwitch','IdentiTwitch','http://richfish.org/identitwitch/', now()), ('LaTwit','LaTwit','http://latwit.mac65.com/', now()), + ('LiveTweeter', 'LiveTweeter', 'http://addons.songbirdnest.com/addon/1204', now()), ('livetweeter', 'livetweeter', 'http://addons.songbirdnest.com/addon/1204', now()), ('maisha', 'Maisha', 'http://maisha.grango.org/', now()), ('mbpidgin','mbpidgin','http://code.google.com/p/microblog-purple/', now()), -- cgit v1.2.3-54-g00ecf From c1b19929f6234c4b9e30e16bae419c89c38c1169 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Mon, 10 Aug 2009 09:41:07 +1200 Subject: changed file.url column type from varcahr(255) to varchar(2047) --- db/074to080.sql | 2 +- db/074to080_pg.sql | 2 +- db/laconica.sql | 2 +- db/laconica_pg.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) (limited to 'db') diff --git a/db/074to080.sql b/db/074to080.sql index ff0819159..e667798eb 100644 --- a/db/074to080.sql +++ b/db/074to080.sql @@ -17,7 +17,7 @@ alter table user_group create table file ( id integer primary key auto_increment, - url varchar(255) comment 'destination URL after following redirections', + url varchar(2047) comment 'destination URL after following redirections', mimetype varchar(50) comment 'mime type of resource', size integer comment 'size of resource when available', title varchar(255) comment 'title of resource when available', diff --git a/db/074to080_pg.sql b/db/074to080_pg.sql index 0a7171ae5..e1cb92c7f 100644 --- a/db/074to080_pg.sql +++ b/db/074to080_pg.sql @@ -36,7 +36,7 @@ alter table user_group create sequence file_seq; create table file ( id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */, - url varchar(255) unique, + url varchar(2047) unique, mimetype varchar(50), size integer, title varchar(255), diff --git a/db/laconica.sql b/db/laconica.sql index 2c04f680a..c1b76d1fa 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -433,7 +433,7 @@ create table group_inbox ( create table file ( id integer primary key auto_increment, - url varchar(255) comment 'destination URL after following redirections', + url varchar(2047) comment 'destination URL after following redirections', mimetype varchar(50) comment 'mime type of resource', size integer comment 'size of resource when available', title varchar(255) comment 'title of resource when available', diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index ad34720a2..4fe223380 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -450,7 +450,7 @@ create index group_inbox_created_idx on group_inbox using btree(created); create sequence file_seq; create table file ( id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */, - url varchar(255) unique, + url varchar(2047) unique, mimetype varchar(50), size integer, title varchar(255), -- cgit v1.2.3-54-g00ecf From f2cd83dd51e856022e75b0e3c5bffb333bf10c8e Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Tue, 11 Aug 2009 14:41:48 +1200 Subject: Revert "changed file.url column type from varcahr(255) to varchar(2047)" This reverts commit c1b19929f6234c4b9e30e16bae419c89c38c1169. --- db/074to080.sql | 2 +- db/074to080_pg.sql | 2 +- db/laconica.sql | 2 +- db/laconica_pg.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) (limited to 'db') diff --git a/db/074to080.sql b/db/074to080.sql index e667798eb..ff0819159 100644 --- a/db/074to080.sql +++ b/db/074to080.sql @@ -17,7 +17,7 @@ alter table user_group create table file ( id integer primary key auto_increment, - url varchar(2047) comment 'destination URL after following redirections', + url varchar(255) comment 'destination URL after following redirections', mimetype varchar(50) comment 'mime type of resource', size integer comment 'size of resource when available', title varchar(255) comment 'title of resource when available', diff --git a/db/074to080_pg.sql b/db/074to080_pg.sql index e1cb92c7f..0a7171ae5 100644 --- a/db/074to080_pg.sql +++ b/db/074to080_pg.sql @@ -36,7 +36,7 @@ alter table user_group create sequence file_seq; create table file ( id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */, - url varchar(2047) unique, + url varchar(255) unique, mimetype varchar(50), size integer, title varchar(255), diff --git a/db/laconica.sql b/db/laconica.sql index c1b76d1fa..2c04f680a 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -433,7 +433,7 @@ create table group_inbox ( create table file ( id integer primary key auto_increment, - url varchar(2047) comment 'destination URL after following redirections', + url varchar(255) comment 'destination URL after following redirections', mimetype varchar(50) comment 'mime type of resource', size integer comment 'size of resource when available', title varchar(255) comment 'title of resource when available', diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 4fe223380..ad34720a2 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -450,7 +450,7 @@ create index group_inbox_created_idx on group_inbox using btree(created); create sequence file_seq; create table file ( id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */, - url varchar(2047) unique, + url varchar(255) unique, mimetype varchar(50), size integer, title varchar(255), -- cgit v1.2.3-54-g00ecf