trac31 pg support, fixing 2tu typo, set ur1.ca as default service

darcs-hash:20081113152718-099f7-42b60d02395f016c54c5f3c301f9dbe987c1283f.gz

2 files changed, 2 insertions, 1 deletions

diff --git a/db/laconica.sql b/db/laconica.sql
index d9a6dbf86..d1e5a76a5 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -65,7 +65,7 @@ create table user (
     smsemail varchar(255) comment 'built from sms and carrier',
     uri varchar(255) unique key comment 'universally unique identifier, usually a tag URI',
     autosubscribe tinyint default 0 comment 'automatically subscribe to users who subscribe to us',
-	urlshorteningservice varchar(50) default 'metamark.net' comment 'service to use for auto-shortening URLs',
+    urlshorteningservice varchar(50) default 'ur1.ca' comment 'service to use for auto-shortening URLs',
     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified',
 
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index 8d0db9a80..d027dc0af 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -63,6 +63,7 @@ create table "user" (
     smsemail varchar(255) /* comment 'built from sms and carrier' */,

     uri varchar(255) unique /* comment 'universally unique identifier, usually a tag URI' */,

     autosubscribe integer default 0 /* comment 'automatically subscribe to users who subscribe to us' */,

+    urlshorteningservice varchar(50) default 'ur1.ca' /* comment 'service to use for auto-shortening URLs' */,

     created timestamp not null /* comment 'date this record was created' */,

     modified timestamp /* comment 'date this record was modified' */