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 91399d89dd6f1bd4447690fc6e87c2ffba81f2b4 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Tue, 11 Aug 2009 09:24:18 +1200 Subject: upgrade script for postgres --- db/08to09_pg.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 db/08to09_pg.sql (limited to 'db') diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql new file mode 100644 index 000000000..892df4a39 --- /dev/null +++ b/db/08to09_pg.sql @@ -0,0 +1,2 @@ +// SQL commands to update an 0.8.x version of Laconica +// to 0.9.x. -- cgit v1.2.3-54-g00ecf From 002cc755b2a521486b0216e2d6f8a3952bda0bae Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Tue, 11 Aug 2009 09:25:13 +1200 Subject: change file.url to from a varchar(255) to varchar(2047) because urls get translated from tinyurl.com etc into their originals before saving and urls can be that long --- db/laconica.sql | 2 +- db/laconica_pg.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index f01107176..ff8c4c13e 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 b5626d3f4..59300c8ca 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 f4f13166f712153b704329804be5508d78437cdd Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Tue, 11 Aug 2009 09:38:17 +1200 Subject: Revert "change file.url to from a varchar(255) to varchar(2047)" This reverts commit 002cc755b2a521486b0216e2d6f8a3952bda0bae. mysql doesn't allow varchar > 255 chars reverting until have a working solution --- db/laconica.sql | 2 +- db/laconica_pg.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index ff8c4c13e..f01107176 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 59300c8ca..b5626d3f4 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 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 From d94a4eae8a68014c2f78ede52364d410c274cbbf Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 20 Aug 2009 16:53:00 -0400 Subject: update database to allow large posts --- db/08to09.sql | 5 +++-- db/laconica.sql | 2 +- 2 files changed, 4 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql index 892df4a39..e8518a98d 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -1,2 +1,3 @@ -// SQL commands to update an 0.8.x version of Laconica -// to 0.9.x. +alter table notice + modify column content text comment 'update content'; + diff --git a/db/laconica.sql b/db/laconica.sql index f01107176..8a1027d48 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -110,7 +110,7 @@ create table notice ( id integer auto_increment primary key comment 'unique identifier', profile_id integer not null comment 'who made the update' references profile (id), uri varchar(255) unique key comment 'universally unique identifier, usually a tag URI', - content varchar(140) comment 'update content', + content text comment 'update content', rendered text comment 'HTML version of the content', url varchar(255) comment 'URL of any attachment (image, video, bookmark, whatever)', created datetime not null comment 'date this record was created', -- cgit v1.2.3-54-g00ecf From 4ac0fe009fd1dbc61b8c7c605ba2c5b76e441f06 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 20 Aug 2009 17:02:25 -0400 Subject: allow unlimited text in messages in DB --- db/08to09.sql | 3 +++ db/laconica.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql index e8518a98d..cad095169 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -1,3 +1,6 @@ alter table notice modify column content text comment 'update content'; +alter table message + modify column content text comment 'message content'; + diff --git a/db/laconica.sql b/db/laconica.sql index 8a1027d48..a59c5fe76 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -331,7 +331,7 @@ create table message ( uri varchar(255) unique key comment 'universally unique identifier', from_profile integer not null comment 'who the message is from' references profile (id), to_profile integer not null comment 'who the message is to' references profile (id), - content varchar(140) comment 'message content', + content text comment 'message content', rendered text comment 'HTML version of the content', url varchar(255) comment 'URL of any attachment (image, video, bookmark, whatever)', created datetime not null comment 'date this record was created', -- cgit v1.2.3-54-g00ecf From 2d6039fb69772dec233df8fbf8fdc2c6d492e86b Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 20 Aug 2009 17:07:20 -0400 Subject: Allow unlimited-size bios in profiles --- db/08to09.sql | 3 +++ db/laconica.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql index cad095169..83bb42e35 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -4,3 +4,6 @@ alter table notice alter table message modify column content text comment 'message content'; +alter table profile + modify column bio text comment 'descriptive biography'; + diff --git a/db/laconica.sql b/db/laconica.sql index a59c5fe76..724877f92 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -6,7 +6,7 @@ create table profile ( fullname varchar(255) comment 'display name', profileurl varchar(255) comment 'URL, cached so we dont regenerate', homepage varchar(255) comment 'identifying URL', - bio varchar(140) comment 'descriptive biography', + bio text comment 'descriptive biography', location varchar(255) comment 'physical location', created datetime not null comment 'date this record was created', modified timestamp comment 'date this record was modified', -- cgit v1.2.3-54-g00ecf From d50d24dcf499795f5b697132d9450cf72453feef Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 20 Aug 2009 17:11:34 -0400 Subject: update database to allow >140c in group descriptions --- db/08to09.sql | 3 +++ db/laconica.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql index 83bb42e35..4d1830611 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -7,3 +7,6 @@ alter table message alter table profile modify column bio text comment 'descriptive biography'; +alter table user_group + modify column description text comment 'group description'; + diff --git a/db/laconica.sql b/db/laconica.sql index 724877f92..56bd4b1e3 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -380,7 +380,7 @@ create table user_group ( nickname varchar(64) unique key comment 'nickname for addressing', fullname varchar(255) comment 'display name', homepage varchar(255) comment 'URL, cached so we dont regenerate', - description varchar(140) comment 'descriptive biography', + description text comment 'group description', location varchar(255) comment 'related physical location, if any', original_logo varchar(255) comment 'original size logo', -- cgit v1.2.3-54-g00ecf From c944edfb50e81a8880b02ee5496a29323021331e Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sun, 16 Aug 2009 10:36:23 -0400 Subject: Add table for configuration settings Add a table for configuration settings. --- db/laconica.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index 56bd4b1e3..1662ef7a8 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -547,3 +547,13 @@ create table deleted_notice ( index deleted_notice_profile_id_idx (profile_id) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table config ( + + section varchar(32) comment 'configuration section', + setting varchar(32) comment 'configuration setting', + value varchar(255) comment 'configuration value', + + constraint primary key (section, setting) + +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; -- cgit v1.2.3-54-g00ecf