From d46f2ee350b9bf2c70371f7bcd2f2793e7ed8110 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 e9edb803bc66028204defcfa659cccbf23da97c6 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Mon, 31 Aug 2009 11:53:59 +1200 Subject: added missing parts to postgres update, and the config+user_role tables to both upgrade scripts Conflicts: db/08to09.sql --- db/08to09.sql | 34 ++++++++++++++++++++++++++++++++++ db/08to09_pg.sql | 38 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 72 insertions(+) create mode 100644 db/08to09.sql (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql new file mode 100644 index 000000000..953e0e5f4 --- /dev/null +++ b/db/08to09.sql @@ -0,0 +1,34 @@ +alter table notice + modify column content text comment 'update content'; + +alter table message + modify column content text comment 'message content'; + +alter table profile + modify column bio text comment 'descriptive biography'; + +alter table user_group + modify column description text comment 'group description'; + +alter table file_oembed + add column mimetype varchar(50) comment 'mime type of resource'; + +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; + +create table user_role ( + + user_id integer not null comment 'user having the role' references user (id), + role varchar(32) not null comment 'string representing the role', + created datetime not null comment 'date the role was granted', + + constraint primary key (user_id, role) + +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index 892df4a39..492b3ebb9 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -1,2 +1,40 @@ // SQL commands to update an 0.8.x version of Laconica // to 0.9.x. + +--these are just comments +/* +alter table notice + modify column content text comment 'update content'; + +alter table message + modify column content text comment 'message content'; + +alter table profile + modify column bio text comment 'descriptive biography'; + +alter table user_group + modify column description text comment 'group description'; +*/ + +alter table file_oembed + add column mimetype varchar(50) /*comment 'mime type of resource'*/; + +create table config ( + + section varchar(32) /* comment 'configuration section'*/, + setting varchar(32) /* comment 'configuration setting'*/, + value varchar(255) /* comment 'configuration value'*/, + + primary key (section, setting) + +); + +create table user_role ( + + user_id integer not null /* comment 'user having the role'*/ references "user" (id), + role varchar(32) not null /* comment 'string representing the role'*/, + created timestamp /* not null comment 'date the role was granted'*/, + + primary key (user_id, role) + +); \ No newline at end of file -- cgit v1.2.3-54-g00ecf From 6704ddddf227865de43c1fdd846b68f76f723fe6 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Mon, 31 Aug 2009 11:01:01 +1200 Subject: fixed up some invalid comment syntax - this is ANSI SQL --- db/08to09_pg.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index 492b3ebb9..9e37314aa 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -1,5 +1,5 @@ -// SQL commands to update an 0.8.x version of Laconica -// to 0.9.x. +-- SQL commands to update an 0.8.x version of Laconica +-- to 0.9.x. --these are just comments /* @@ -37,4 +37,4 @@ create table user_role ( primary key (user_id, role) -); \ No newline at end of file +); -- cgit v1.2.3-54-g00ecf From c0eca0e59b1b9bb74d4457348d1e310e18cc082f Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 19 Oct 2009 18:07:03 -0400 Subject: Revert "fixed up some invalid comment syntax - this is ANSI SQL" This reverts commit 6704ddddf227865de43c1fdd846b68f76f723fe6. --- db/08to09_pg.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index 9e37314aa..492b3ebb9 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -1,5 +1,5 @@ --- SQL commands to update an 0.8.x version of Laconica --- to 0.9.x. +// SQL commands to update an 0.8.x version of Laconica +// to 0.9.x. --these are just comments /* @@ -37,4 +37,4 @@ create table user_role ( primary key (user_id, role) -); +); \ No newline at end of file -- cgit v1.2.3-54-g00ecf From 689b3ae73d83495774fa3ec500527ecb3edab1a1 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 19 Oct 2009 18:07:19 -0400 Subject: Revert "added missing parts to postgres update, and the config+user_role tables to both upgrade scripts" This reverts commit e9edb803bc66028204defcfa659cccbf23da97c6. --- db/08to09.sql | 34 ---------------------------------- db/08to09_pg.sql | 38 -------------------------------------- 2 files changed, 72 deletions(-) delete mode 100644 db/08to09.sql (limited to 'db') diff --git a/db/08to09.sql b/db/08to09.sql deleted file mode 100644 index 953e0e5f4..000000000 --- a/db/08to09.sql +++ /dev/null @@ -1,34 +0,0 @@ -alter table notice - modify column content text comment 'update content'; - -alter table message - modify column content text comment 'message content'; - -alter table profile - modify column bio text comment 'descriptive biography'; - -alter table user_group - modify column description text comment 'group description'; - -alter table file_oembed - add column mimetype varchar(50) comment 'mime type of resource'; - -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; - -create table user_role ( - - user_id integer not null comment 'user having the role' references user (id), - role varchar(32) not null comment 'string representing the role', - created datetime not null comment 'date the role was granted', - - constraint primary key (user_id, role) - -) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index 492b3ebb9..892df4a39 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -1,40 +1,2 @@ // SQL commands to update an 0.8.x version of Laconica // to 0.9.x. - ---these are just comments -/* -alter table notice - modify column content text comment 'update content'; - -alter table message - modify column content text comment 'message content'; - -alter table profile - modify column bio text comment 'descriptive biography'; - -alter table user_group - modify column description text comment 'group description'; -*/ - -alter table file_oembed - add column mimetype varchar(50) /*comment 'mime type of resource'*/; - -create table config ( - - section varchar(32) /* comment 'configuration section'*/, - setting varchar(32) /* comment 'configuration setting'*/, - value varchar(255) /* comment 'configuration value'*/, - - primary key (section, setting) - -); - -create table user_role ( - - user_id integer not null /* comment 'user having the role'*/ references "user" (id), - role varchar(32) not null /* comment 'string representing the role'*/, - created timestamp /* not null comment 'date the role was granted'*/, - - primary key (user_id, role) - -); \ No newline at end of file -- cgit v1.2.3-54-g00ecf From d72748eb8e71f81e7cddca610ec98a8910dd347f Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 19 Oct 2009 18:07:36 -0400 Subject: Revert "upgrade script for postgres" This reverts commit d46f2ee350b9bf2c70371f7bcd2f2793e7ed8110. --- db/08to09_pg.sql | 2 -- 1 file changed, 2 deletions(-) delete mode 100644 db/08to09_pg.sql (limited to 'db') diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql deleted file mode 100644 index 892df4a39..000000000 --- a/db/08to09_pg.sql +++ /dev/null @@ -1,2 +0,0 @@ -// SQL commands to update an 0.8.x version of Laconica -// to 0.9.x. -- cgit v1.2.3-54-g00ecf From 603f95d17db5f8e65fa23b9c5cf997c3c0ba15ed Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sat, 31 Oct 2009 15:40:26 -0400 Subject: add and update choqok --- 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 2657763f4..2982bac58 100644 --- a/db/notice_source.sql +++ b/db/notice_source.sql @@ -7,6 +7,7 @@ VALUES ('anyio', 'Any.IO', 'http://any.io/', now()), ('betwittered','BeTwittered','http://www.32hours.com/betwitteredinfo/', now()), ('bti','bti','http://gregkh.github.com/bti/', now()), + ('choqok', 'Choqok', 'http://choqok.gnufolks.org/', now()), ('cliqset', 'Cliqset', 'http://www.cliqset.com/', now()), ('deskbar','Deskbar-Applet','http://www.gnome.org/projects/deskbar-applet/', now()), ('Do','Gnome Do','http://do.davebsd.com/wiki/index.php?title=Microblog_Plugin', now()), -- cgit v1.2.3-54-g00ecf From 659da177ea017daaab137b7e608c6c0500c6d586 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sat, 31 Oct 2009 15:49:21 -0400 Subject: Add SocialOomph --- 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 2982bac58..5c5c939dd 100644 --- a/db/notice_source.sql +++ b/db/notice_source.sql @@ -44,6 +44,7 @@ VALUES ('rygh.no','rygh.no','http://rygh.no/', now()), ('ryghsms','ryghsms','http://sms.rygh.no/', now()), ('smob','SMOB','http://smob.sioc-project.org/', now()), + ('socialoomphBfD4pMqz31', 'SocialOomph', 'http://www.socialoomph.com/', now()), ('spaz','Spaz','http://funkatron.com/spaz', now()), ('tarpipe','tarpipe','http://tarpipe.com/', now()), ('tjunar','Tjunar','http://nederflash.nl/boek/titels/tjunar-air', now()), -- cgit v1.2.3-54-g00ecf