merge install/schema_postgres.sql from dev

1 files changed, 148 insertions, 148 deletions

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 5d1b8baaa..cb4476628 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1,6 +1,6 @@
 CREATE TABLE "abconfig" (
   "id" serial  NOT NULL,
-  "chan" bigint NOT NULL DEFAULT 0,
+  "chan" bigint NOT NULL DEFAULT '0',
   "xchan" text NOT NULL,
   "cat" text NOT NULL,
   "k" text NOT NULL,
@@ -73,13 +73,13 @@ CREATE TABLE "account" (
   "account_language" varchar(16) NOT NULL DEFAULT 'en',
   "account_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "account_lastlog" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "account_flags" bigint  NOT NULL DEFAULT 0 ,
-  "account_roles" bigint  NOT NULL DEFAULT 0 ,
+  "account_flags" bigint  NOT NULL DEFAULT '0',
+  "account_roles" bigint  NOT NULL DEFAULT '0',
   "account_reset" text NOT NULL DEFAULT '',
   "account_expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "account_expire_notified" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "account_service_class" varchar(32) NOT NULL DEFAULT '',
-  "account_level" bigint  NOT NULL DEFAULT 0 ,
+  "account_level" bigint  NOT NULL DEFAULT '0',
   "account_password_changed" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY ("account_id")
 );
@@ -97,11 +97,11 @@ create index "account_password_changed"  on account ("account_password_changed")
 CREATE TABLE "addon" (
   "id" serial NOT NULL,
   "aname" text NOT NULL,
-  "version" text NOT NULL DEFAULT 0 ,
-  "installed" numeric(1) NOT NULL DEFAULT 0 ,
-  "hidden" numeric(1) NOT NULL DEFAULT 0 ,
-  "tstamp" numeric(20) NOT NULL DEFAULT 0 ,
-  "plugin_admin" numeric(1) NOT NULL DEFAULT 0 ,
+  "version" text NOT NULL DEFAULT '0',
+  "installed" numeric(1) NOT NULL DEFAULT '0',
+  "hidden" numeric(1) NOT NULL DEFAULT '0',
+  "tstamp" numeric(20) NOT NULL DEFAULT '0',
+  "plugin_admin" numeric(1) NOT NULL DEFAULT '0',
   PRIMARY KEY ("id")
 );
 create index "addon_hidden_idx" on addon ("hidden");
@@ -117,13 +117,13 @@ CREATE TABLE "app" (
   "app_url" text NOT NULL DEFAULT '',
   "app_photo" text NOT NULL DEFAULT '',
   "app_version" text NOT NULL DEFAULT '',
-  "app_channel" bigint NOT NULL DEFAULT 0 ,
+  "app_channel" bigint NOT NULL DEFAULT '0',
   "app_addr" text NOT NULL DEFAULT '',
   "app_price" text NOT NULL DEFAULT '',
   "app_page" text NOT NULL DEFAULT '',
   "app_requires" text NOT NULL DEFAULT '',
-  "app_deleted" smallint NOT NULL DEFAULT 0 ,
-  "app_system" smallint NOT NULL DEFAULT 0 ,
+  "app_deleted" smallint NOT NULL DEFAULT '0',
+  "app_system" smallint NOT NULL DEFAULT '0',
   "app_plugin" text NOT NULL DEFAULT '',
   "app_options" smallint NOT NULL DEFAULT '0',
   "app_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -159,19 +159,19 @@ create index atoken_expires on atoken (atoken_expires);
 
 CREATE TABLE "attach" (
   "id" serial  NOT NULL,
-  "aid" bigint  NOT NULL DEFAULT 0 ,
-  "uid" bigint  NOT NULL DEFAULT 0 ,
+  "aid" bigint  NOT NULL DEFAULT '0',
+  "uid" bigint  NOT NULL DEFAULT '0',
   "hash" varchar(64) NOT NULL DEFAULT '',
   "creator" varchar(128) NOT NULL DEFAULT '',
   "filename" text NOT NULL DEFAULT '',
   "filetype" varchar(64) NOT NULL DEFAULT '',
-  "filesize" bigint  NOT NULL DEFAULT 0 ,
-  "revision" bigint  NOT NULL DEFAULT 0 ,
+  "filesize" bigint  NOT NULL DEFAULT '0',
+  "revision" bigint  NOT NULL DEFAULT '0',
   "folder" varchar(64) NOT NULL DEFAULT '',
-  "flags" bigint  NOT NULL DEFAULT 0 ,
-  "is_dir" smallint NOT NULL DEFAULT 0 ,
-  "is_photo" smallint NOT NULL DEFAULT 0 ,
-  "os_storage" smallint NOT NULL DEFAULT 0 ,
+  "flags" bigint  NOT NULL DEFAULT '0',
+  "is_dir" smallint NOT NULL DEFAULT '0',
+  "is_photo" smallint NOT NULL DEFAULT '0',
+  "os_storage" smallint NOT NULL DEFAULT '0',
   "os_path" text NOT NULL,
   "display_path" text NOT NULL,
   "content" bytea NOT NULL,
@@ -215,8 +215,8 @@ CREATE TABLE "cache" (
 );
 CREATE TABLE "cal" (
   "cal_id" serial  NOT NULL,
-  "cal_aid" bigint NOT NULL DEFAULT 0 ,
-  "cal_uid" bigint NOT NULL DEFAULT 0 ,
+  "cal_aid" bigint NOT NULL DEFAULT '0',
+  "cal_uid" bigint NOT NULL DEFAULT '0',
   "cal_hash" text NOT NULL,
   "cal_name" text NOT NULL,
   "uri" text NOT NULL,
@@ -224,7 +224,7 @@ CREATE TABLE "cal" (
   "pass" text NOT NULL,
   "ctag" text NOT NULL,
   "synctoken" text NOT NULL,
-  "cal_types" text NOT NULL DEFAULT 0 ,
+  "cal_types" text NOT NULL DEFAULT '0',
   PRIMARY KEY ("cal_id")
 );
 create index "cal_hash_idx" on cal ("cal_hash");
@@ -235,8 +235,8 @@ create index "cal_uid_idx" on cal ("cal_uid");
 
 CREATE TABLE "channel" (
   "channel_id" serial  NOT NULL,
-  "channel_account_id" bigint  NOT NULL DEFAULT 0 ,
-  "channel_primary" numeric(1)  NOT NULL DEFAULT 0 ,
+  "channel_account_id" bigint  NOT NULL DEFAULT '0',
+  "channel_primary" numeric(1)  NOT NULL DEFAULT '0',
   "channel_name" text NOT NULL DEFAULT '',
   "channel_address" text NOT NULL DEFAULT '',
   "channel_guid" text NOT NULL DEFAULT '',
@@ -248,8 +248,8 @@ CREATE TABLE "channel" (
   "channel_startpage" text NOT NULL DEFAULT '',
   "channel_pubkey" text NOT NULL,
   "channel_prvkey" text NOT NULL,
-  "channel_notifyflags" bigint  NOT NULL DEFAULT 65535,
-  "channel_pageflags" bigint  NOT NULL DEFAULT 0 ,
+  "channel_notifyflags" bigint  NOT NULL DEFAULT '65535',
+  "channel_pageflags" bigint  NOT NULL DEFAULT '0',
   "channel_dirdate" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "channel_lastpost" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "channel_deleted" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -294,7 +294,7 @@ create index "channel_system" on channel ("channel_system");
 create index "channel_moved" on channel ("channel_moved");
 CREATE TABLE "chat" (
   "chat_id" serial  NOT NULL,
-  "chat_room" bigint  NOT NULL DEFAULT 0 ,
+  "chat_room" bigint  NOT NULL DEFAULT '0',
   "chat_xchan" text NOT NULL DEFAULT '',
   "chat_text" text NOT NULL,
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -305,7 +305,7 @@ create index "chat_xchan_idx" on chat ("chat_xchan");
 create index "chat_created_idx" on chat ("created");
 CREATE TABLE "chatpresence" (
   "cp_id" serial  NOT NULL,
-  "cp_room" bigint  NOT NULL DEFAULT 0 ,
+  "cp_room" bigint  NOT NULL DEFAULT '0',
   "cp_xchan" text NOT NULL DEFAULT '',
   "cp_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "cp_status" text NOT NULL,
@@ -319,12 +319,12 @@ create index "cp_status" on chatpresence ("cp_status");
 
 CREATE TABLE "chatroom" (
   "cr_id" serial  NOT NULL,
-  "cr_aid" bigint  NOT NULL DEFAULT 0 ,
-  "cr_uid" bigint  NOT NULL DEFAULT 0 ,
+  "cr_aid" bigint  NOT NULL DEFAULT '0',
+  "cr_uid" bigint  NOT NULL DEFAULT '0',
   "cr_name" text NOT NULL DEFAULT '',
   "cr_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "cr_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "cr_expire" bigint  NOT NULL DEFAULT 0 ,
+  "cr_expire" bigint  NOT NULL DEFAULT '0',
   "allow_cid" text NOT NULL,
   "allow_gid" text NOT NULL,
   "deny_cid" text NOT NULL,
@@ -343,7 +343,7 @@ CREATE TABLE "clients" (
   "redirect_uri" varchar(200) NOT NULL,
   "clname" text,
   "icon" text,
-  "uid" bigint NOT NULL DEFAULT 0 ,
+  "uid" bigint NOT NULL DEFAULT '0',
   PRIMARY KEY ("client_id")
 );
 CREATE TABLE "config" (
@@ -390,9 +390,9 @@ create index "dreport_channel" on dreport ("dreport_channel");
 
 CREATE TABLE "event" (
   "id" serial NOT NULL,
-  "aid" bigint  NOT NULL DEFAULT 0 ,
+  "aid" bigint  NOT NULL DEFAULT '0',
   "uid" bigint NOT NULL,
-  "cal_id" bigint NOT NULL DEFAULT 0 ,
+  "cal_id" bigint NOT NULL DEFAULT '0',
   "event_xchan" text NOT NULL DEFAULT '',
   "event_hash" text NOT NULL DEFAULT '',
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -403,19 +403,19 @@ CREATE TABLE "event" (
   "description" text NOT NULL,
   "location" text NOT NULL,
   "etype" text NOT NULL,
-  "nofinish" numeric(1) NOT NULL DEFAULT 0 ,
-  "adjust" numeric(1) NOT NULL DEFAULT 1,
-  "dismissed" numeric(1) NOT NULL DEFAULT 0 ,
+  "nofinish" numeric(1) NOT NULL DEFAULT '0',
+  "adjust" numeric(1) NOT NULL DEFAULT '1',
+  "dismissed" numeric(1) NOT NULL DEFAULT '0',
   "allow_cid" text NOT NULL,
   "allow_gid" text NOT NULL,
   "deny_cid" text NOT NULL,
   "deny_gid" text NOT NULL,
   "event_status" varchar(255) NOT NULL DEFAULT '',
   "event_status_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "event_percent" smallint NOT NULL DEFAULT 0 ,
+  "event_percent" smallint NOT NULL DEFAULT '0',
   "event_repeat" text NOT NULL,
-  "event_sequence" smallint NOT NULL DEFAULT 0 ,
-  "event_priority" smallint NOT NULL DEFAULT 0 ,
+  "event_sequence" smallint NOT NULL DEFAULT '0',
+  "event_priority" smallint NOT NULL DEFAULT '0',
   "event_vdata" text NOT NULL,
   PRIMARY KEY ("id")
 );
@@ -449,8 +449,8 @@ CREATE TABLE "pgrp" (
   "id" serial  NOT NULL,
   "hash" text NOT NULL DEFAULT '',
   "uid" bigint  NOT NULL,
-  "visible" numeric(1) NOT NULL DEFAULT 0 ,
-  "deleted" numeric(1) NOT NULL DEFAULT 0 ,
+  "visible" numeric(1) NOT NULL DEFAULT '0',
+  "deleted" numeric(1) NOT NULL DEFAULT '0',
   "gname" text NOT NULL,
   PRIMARY KEY ("id")
 
@@ -465,8 +465,8 @@ CREATE TABLE "hook" (
   "hook" text NOT NULL,
   "file" text NOT NULL,
   "fn" text NOT NULL,
-  "priority" smallint  NOT NULL DEFAULT 0 ,
-  "hook_version" smallint NOT NULL DEFAULT 0 ,
+  "priority" smallint  NOT NULL DEFAULT '0',
+  "hook_version" smallint NOT NULL DEFAULT '0',
   PRIMARY KEY ("id")
 
 );
@@ -483,8 +483,8 @@ CREATE TABLE "hubloc" (
   "hubloc_hash" text NOT NULL,
   "hubloc_addr" text NOT NULL DEFAULT '',
   "hubloc_network" text NOT NULL DEFAULT '',
-  "hubloc_flags" bigint  NOT NULL DEFAULT 0 ,
-  "hubloc_status" bigint  NOT NULL DEFAULT 0 ,
+  "hubloc_flags" bigint  NOT NULL DEFAULT '0',
+  "hubloc_status" bigint  NOT NULL DEFAULT '0',
   "hubloc_url" text NOT NULL DEFAULT '',
   "hubloc_url_sig" text NOT NULL DEFAULT '',
   "hubloc_site_id" text NOT NULL DEFAULT '',
@@ -494,10 +494,10 @@ CREATE TABLE "hubloc" (
   "hubloc_sitekey" text NOT NULL DEFAULT '',
   "hubloc_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "hubloc_connected" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "hubloc_primary" smallint NOT NULL DEFAULT 0 ,
-  "hubloc_orphancheck" smallint NOT NULL DEFAULT 0 ,
-  "hubloc_error" smallint NOT NULL DEFAULT 0 ,
-  "hubloc_deleted" smallint NOT NULL DEFAULT 0 ,
+  "hubloc_primary" smallint NOT NULL DEFAULT '0',
+  "hubloc_orphancheck" smallint NOT NULL DEFAULT '0',
+  "hubloc_error" smallint NOT NULL DEFAULT '0',
+  "hubloc_deleted" smallint NOT NULL DEFAULT '0',
   PRIMARY KEY ("hubloc_id")
 );
 create index "hubloc_url" on hubloc ("hubloc_url");
@@ -518,11 +518,11 @@ create index "hubloc_error" on hubloc ("hubloc_error");
 create index "hubloc_deleted" on hubloc ("hubloc_deleted");
 CREATE TABLE "iconfig" (
   "id" serial NOT NULL,
-  "iid" bigint NOT NULL DEFAULT 0 ,
+  "iid" bigint NOT NULL DEFAULT '0',
   "cat" text NOT NULL DEFAULT '',
   "k" text NOT NULL DEFAULT '',
   "v" text NOT NULL DEFAULT '',
-  "sharing" int NOT NULL DEFAULT 0 ,
+  "sharing" int NOT NULL DEFAULT '0',
   PRIMARY KEY("id")
 );
 create index "iconfig_iid" on iconfig ("iid");
@@ -549,9 +549,9 @@ create index "issue_component" on issue ("issue_component");
 CREATE TABLE "item" (
   "id" serial  NOT NULL,
   "mid" text  NOT NULL DEFAULT '',
-  "aid" bigint  NOT NULL DEFAULT 0 ,
-  "uid" bigint  NOT NULL DEFAULT 0 ,
-  "parent" bigint  NOT NULL DEFAULT 0 ,
+  "aid" bigint  NOT NULL DEFAULT '0',
+  "uid" bigint  NOT NULL DEFAULT '0',
+  "parent" bigint  NOT NULL DEFAULT '0',
   "parent_mid" text  NOT NULL DEFAULT '',
   "thr_parent" text NOT NULL DEFAULT '',
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -570,7 +570,7 @@ CREATE TABLE "item" (
   "html" text NOT NULL,
   "app" text NOT NULL DEFAULT '',
   "lang" varchar(64) NOT NULL DEFAULT '',
-  "revision" bigint  NOT NULL DEFAULT 0 ,
+  "revision" bigint  NOT NULL DEFAULT '0',
   "verb" text NOT NULL DEFAULT '',
   "obj_type" text NOT NULL DEFAULT '',
   "obj" text NOT NULL,
@@ -593,32 +593,32 @@ CREATE TABLE "item" (
   "allow_gid" text NOT NULL,
   "deny_cid" text NOT NULL,
   "deny_gid" text NOT NULL,
-  "item_restrict" bigint NOT NULL DEFAULT 0 ,
-  "item_flags" bigint NOT NULL DEFAULT 0 ,
-  "item_private" numeric(4) NOT NULL DEFAULT 0 ,
-  "item_unseen" smallint NOT NULL DEFAULT 0 ,
-  "item_wall" smallint NOT NULL DEFAULT 0 ,
-  "item_origin" smallint NOT NULL DEFAULT 0 ,
-  "item_starred" smallint NOT NULL DEFAULT 0 ,
-  "item_uplink" smallint NOT NULL DEFAULT 0 ,
-  "item_consensus" smallint NOT NULL DEFAULT 0 ,
-  "item_thread_top" smallint NOT NULL DEFAULT 0 ,
-  "item_notshown" smallint NOT NULL DEFAULT 0 ,
-  "item_nsfw" smallint NOT NULL DEFAULT 0 ,
-  "item_relay" smallint NOT NULL DEFAULT 0 ,
-  "item_mentionsme" smallint NOT NULL DEFAULT 0 ,
-  "item_nocomment" smallint NOT NULL DEFAULT 0 ,
-  "item_obscured" smallint NOT NULL DEFAULT 0 ,
-  "item_verified" smallint NOT NULL DEFAULT 0 ,
-  "item_retained" smallint NOT NULL DEFAULT 0 ,
-  "item_rss" smallint NOT NULL DEFAULT 0 ,
-  "item_deleted" smallint NOT NULL DEFAULT 0 ,
-  "item_type" int NOT NULL DEFAULT 0 ,
-  "item_hidden" smallint NOT NULL DEFAULT 0 ,
-  "item_unpublished" smallint NOT NULL DEFAULT 0 ,
-  "item_delayed" smallint NOT NULL DEFAULT 0 ,
-  "item_pending_remove" smallint NOT NULL DEFAULT 0 ,
-  "item_blocked" smallint NOT NULL DEFAULT 0 ,
+  "item_restrict" bigint NOT NULL DEFAULT '0',
+  "item_flags" bigint NOT NULL DEFAULT '0',
+  "item_private" numeric(4) NOT NULL DEFAULT '0',
+  "item_unseen" smallint NOT NULL DEFAULT '0',
+  "item_wall" smallint NOT NULL DEFAULT '0',
+  "item_origin" smallint NOT NULL DEFAULT '0',
+  "item_starred" smallint NOT NULL DEFAULT '0',
+  "item_uplink" smallint NOT NULL DEFAULT '0',
+  "item_consensus" smallint NOT NULL DEFAULT '0',
+  "item_thread_top" smallint NOT NULL DEFAULT '0',
+  "item_notshown" smallint NOT NULL DEFAULT '0',
+  "item_nsfw" smallint NOT NULL DEFAULT '0',
+  "item_relay" smallint NOT NULL DEFAULT '0',
+  "item_mentionsme" smallint NOT NULL DEFAULT '0',
+  "item_nocomment" smallint NOT NULL DEFAULT '0',
+  "item_obscured" smallint NOT NULL DEFAULT '0',
+  "item_verified" smallint NOT NULL DEFAULT '0',
+  "item_retained" smallint NOT NULL DEFAULT '0',
+  "item_rss" smallint NOT NULL DEFAULT '0',
+  "item_deleted" smallint NOT NULL DEFAULT '0',
+  "item_type" int NOT NULL DEFAULT '0',
+  "item_hidden" smallint NOT NULL DEFAULT '0',
+  "item_unpublished" smallint NOT NULL DEFAULT '0',
+  "item_delayed" smallint NOT NULL DEFAULT '0',
+  "item_pending_remove" smallint NOT NULL DEFAULT '0',
+  "item_blocked" smallint NOT NULL DEFAULT '0',
   "item_search_vector" tsvector,
   PRIMARY KEY ("id")
 );
@@ -731,9 +731,9 @@ create index "ltype_idx" on listeners ("ltype");
 
 CREATE TABLE "mail" (
   "id" serial  NOT NULL,
-  "convid" bigint  NOT NULL DEFAULT 0 ,
+  "convid" bigint  NOT NULL DEFAULT '0',
   "conv_guid" text NOT NULL,
-  "mail_flags" bigint  NOT NULL DEFAULT 0 ,
+  "mail_flags" bigint  NOT NULL DEFAULT '0',
   "from_xchan" text NOT NULL DEFAULT '',
   "to_xchan" text NOT NULL DEFAULT '',
   "account_id" bigint  NOT NULL DEFAULT '0',
@@ -745,13 +745,13 @@ CREATE TABLE "mail" (
   "attach" text NOT NULL DEFAULT '',
   "mid" text NOT NULL,
   "parent_mid" text NOT NULL,
-  "mail_deleted" smallint NOT NULL DEFAULT 0 ,
-  "mail_replied" smallint NOT NULL DEFAULT 0 ,
-  "mail_isreply" smallint NOT NULL DEFAULT 0 ,
-  "mail_seen" smallint NOT NULL DEFAULT 0 ,
-  "mail_recalled" smallint NOT NULL DEFAULT 0 ,
-  "mail_obscured" smallint NOT NULL DEFAULT 0 ,
-  "mail_raw" smallint NOT NULL DEFAULT 0 ,
+  "mail_deleted" smallint NOT NULL DEFAULT '0',
+  "mail_replied" smallint NOT NULL DEFAULT '0',
+  "mail_isreply" smallint NOT NULL DEFAULT '0',
+  "mail_seen" smallint NOT NULL DEFAULT '0',
+  "mail_recalled" smallint NOT NULL DEFAULT '0',
+  "mail_obscured" smallint NOT NULL DEFAULT '0',
+  "mail_raw" smallint NOT NULL DEFAULT '0',
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY ("id")
@@ -775,10 +775,10 @@ create index "mail_recalled" on mail ("mail_recalled");
 create index "mail_obscured" on mail ("mail_obscured");
 CREATE TABLE "menu" (
   "menu_id" serial  NOT NULL,
-  "menu_channel_id" bigint  NOT NULL DEFAULT 0 ,
+  "menu_channel_id" bigint  NOT NULL DEFAULT '0',
   "menu_name" text NOT NULL DEFAULT '',
   "menu_desc" text NOT NULL DEFAULT '',
-  "menu_flags" bigint NOT NULL DEFAULT 0 ,
+  "menu_flags" bigint NOT NULL DEFAULT '0',
   "menu_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "menu_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY ("menu_id")
@@ -792,14 +792,14 @@ CREATE TABLE "menu_item" (
   "mitem_id" serial  NOT NULL,
   "mitem_link" text NOT NULL DEFAULT '',
   "mitem_desc" text NOT NULL DEFAULT '',
-  "mitem_flags" bigint NOT NULL DEFAULT 0 ,
+  "mitem_flags" bigint NOT NULL DEFAULT '0',
   "allow_cid" text NOT NULL,
   "allow_gid" text NOT NULL,
   "deny_cid" text NOT NULL,
   "deny_gid" text NOT NULL,
   "mitem_channel_id" bigint  NOT NULL,
-  "mitem_menu_id" bigint  NOT NULL DEFAULT 0 ,
-  "mitem_order" bigint NOT NULL DEFAULT 0 ,
+  "mitem_menu_id" bigint  NOT NULL DEFAULT '0',
+  "mitem_order" bigint NOT NULL DEFAULT '0',
   PRIMARY KEY ("mitem_id")
 
 );
@@ -818,7 +818,7 @@ CREATE TABLE "notify" (
   "uid" bigint NOT NULL,
   "link" text NOT NULL,
   "parent" text NOT NULL DEFAULT '',
-  "seen" numeric(1) NOT NULL DEFAULT 0 ,
+  "seen" numeric(1) NOT NULL DEFAULT '0',
   "ntype" bigint NOT NULL,
   "verb" text NOT NULL,
   "otype" varchar(16) NOT NULL,
@@ -867,18 +867,18 @@ create index "obj_quantity" on obj ("obj_quantity");
 
 CREATE TABLE "outq" (
   "outq_hash" text NOT NULL,
-  "outq_account" bigint  NOT NULL DEFAULT 0 ,
-  "outq_channel" bigint  NOT NULL DEFAULT 0 ,
+  "outq_account" bigint  NOT NULL DEFAULT '0',
+  "outq_channel" bigint  NOT NULL DEFAULT '0',
   "outq_driver" varchar(32) NOT NULL DEFAULT '',
   "outq_posturl" text NOT NULL DEFAULT '',
-  "outq_async" numeric(1) NOT NULL DEFAULT 0 ,
-  "outq_delivered" numeric(1) NOT NULL DEFAULT 0 ,
+  "outq_async" numeric(1) NOT NULL DEFAULT '0',
+  "outq_delivered" numeric(1) NOT NULL DEFAULT '0',
   "outq_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "outq_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "outq_scheduled" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "outq_notify" text NOT NULL,
   "outq_msg" text NOT NULL,
-  "outq_priority" smallint NOT NULL DEFAULT 0 ,
+  "outq_priority" smallint NOT NULL DEFAULT '0',
   PRIMARY KEY ("outq_hash")
 );
 create index "outq_account" on outq ("outq_account");
@@ -906,7 +906,7 @@ create index "pchan_hash" on pchan ("pchan_hash");
 
 CREATE TABLE "pconfig" (
   "id" serial NOT NULL,
-  "uid" bigint NOT NULL DEFAULT 0 ,
+  "uid" bigint NOT NULL DEFAULT '0',
   "cat" text  NOT NULL,
   "k" text  NOT NULL,
   "v" text NOT NULL,
@@ -916,7 +916,7 @@ CREATE TABLE "pconfig" (
 
 CREATE TABLE "photo" (
   "id" serial  NOT NULL,
-  "aid" bigint  NOT NULL DEFAULT 0 ,
+  "aid" bigint  NOT NULL DEFAULT '0',
   "uid" bigint  NOT NULL,
   "xchan" text NOT NULL DEFAULT '',
   "resource_id" text NOT NULL,
@@ -929,16 +929,16 @@ CREATE TABLE "photo" (
   "mimetype" varchar(128) NOT NULL DEFAULT 'image/jpeg',
   "height" numeric(6) NOT NULL,
   "width" numeric(6) NOT NULL,
-  "filesize" bigint  NOT NULL DEFAULT 0 ,
+  "filesize" bigint  NOT NULL DEFAULT '0',
   "content" bytea NOT NULL,
-  "imgscale" numeric(3) NOT NULL DEFAULT 0 ,
-  "profile" numeric(1) NOT NULL DEFAULT 0 ,
-  "photo_usage" smallint NOT NULL DEFAULT 0 ,
-  "is_nsfw" smallint NOT NULL DEFAULT 0 ,
-  "os_storage" smallint NOT NULL DEFAULT 0 ,
+  "imgscale" numeric(3) NOT NULL DEFAULT '0',
+  "profile" numeric(1) NOT NULL DEFAULT '0',
+  "photo_usage" smallint NOT NULL DEFAULT '0',
+  "is_nsfw" smallint NOT NULL DEFAULT '0',
+  "os_storage" smallint NOT NULL DEFAULT '0',
   "os_path" text NOT NULL,
   "display_path" text NOT NULL,
-  "photo_flags" bigint  NOT NULL DEFAULT 0 ,
+  "photo_flags" bigint  NOT NULL DEFAULT '0',
   "allow_cid" text NOT NULL,
   "allow_gid" text NOT NULL,
   "deny_cid" text NOT NULL,
@@ -965,8 +965,8 @@ CREATE TABLE "poll" (
   "poll_channel" bigint  NOT NULL DEFAULT '0',
   "poll_author" text NOT NULL,
   "poll_desc" text NOT NULL,
-  "poll_flags" bigint NOT NULL DEFAULT 0 ,
-  "poll_votes" bigint NOT NULL DEFAULT 0 ,
+  "poll_flags" bigint NOT NULL DEFAULT '0',
+  "poll_votes" bigint NOT NULL DEFAULT '0',
   PRIMARY KEY ("poll_id")
 
 );
@@ -1002,7 +1002,7 @@ CREATE TABLE "profdef" (
 create index "profdef_field_name" on profdef ("field_name");
 CREATE TABLE "profext" (
   "id" serial  NOT NULL,
-  "channel_id" bigint  NOT NULL DEFAULT 0 ,
+  "channel_id" bigint  NOT NULL DEFAULT '0',
   "hash" text NOT NULL DEFAULT '',
   "k" text NOT NULL DEFAULT '',
   "v" text NOT NULL,
@@ -1018,8 +1018,8 @@ CREATE TABLE "profile" (
   "aid" bigint  NOT NULL DEFAULT '0',
   "uid" bigint NOT NULL,
   "profile_name" text NOT NULL,
-  "is_default" numeric(1) NOT NULL DEFAULT 0 ,
-  "hide_friends" numeric(1) NOT NULL DEFAULT 0 ,
+  "is_default" numeric(1) NOT NULL DEFAULT '0',
+  "hide_friends" numeric(1) NOT NULL DEFAULT '0',
   "fullname" text NOT NULL,
   "pdesc" text NOT NULL DEFAULT '',
   "chandesc" text NOT NULL DEFAULT '',
@@ -1056,7 +1056,7 @@ CREATE TABLE "profile" (
   "homepage" text NOT NULL DEFAULT '',
   "photo" text NOT NULL,
   "thumb" text NOT NULL,
-  "publish" numeric(1) NOT NULL DEFAULT 0 ,
+  "publish" numeric(1) NOT NULL DEFAULT '0',
   "profile_vcard" text NOT NULL DEFAULT '',
   PRIMARY KEY ("id"),
   UNIQUE ("profile_guid","uid")
@@ -1078,7 +1078,7 @@ create index "profile_guid" on profile ("profile_guid");
 CREATE TABLE "profile_check" (
   "id" serial  NOT NULL,
   "uid" bigint  NOT NULL,
-  "cid" bigint  NOT NULL DEFAULT 0 ,
+  "cid" bigint  NOT NULL DEFAULT '0',
   "dfrn_id" text NOT NULL,
   "sec" text NOT NULL,
   "expire" bigint NOT NULL,
@@ -1113,8 +1113,8 @@ create index "session_sid" on session ("sid");
 create index "session_expire" on session ("expire");
 CREATE TABLE "shares" (
   "share_id" serial  NOT NULL,
-  "share_type" bigint NOT NULL DEFAULT 0 ,
-  "share_target" bigint  NOT NULL DEFAULT 0 ,
+  "share_type" bigint NOT NULL DEFAULT '0',
+  "share_target" bigint  NOT NULL DEFAULT '0',
   "share_xchan" text NOT NULL DEFAULT '',
   PRIMARY KEY ("share_id")
 );
@@ -1124,8 +1124,8 @@ create index "share_xchan" on shares ("share_xchan");
 
 CREATE TABLE "sign" (
   "id" serial  NOT NULL,
-  "iid" bigint  NOT NULL DEFAULT 0 ,
-  "retract_iid" bigint  NOT NULL DEFAULT 0 ,
+  "iid" bigint  NOT NULL DEFAULT '0',
+  "retract_iid" bigint  NOT NULL DEFAULT '0',
   "signed_text" text NOT NULL,
   "signature" text NOT NULL,
   "signer" text NOT NULL,
@@ -1136,19 +1136,19 @@ create index "sign_retract_iid" on "sign" ("retract_iid");
 
 CREATE TABLE "site" (
   "site_url" text NOT NULL,
-  "site_access" bigint NOT NULL DEFAULT 0 ,
-  "site_flags" bigint NOT NULL DEFAULT 0 ,
+  "site_access" bigint NOT NULL DEFAULT '0',
+  "site_flags" bigint NOT NULL DEFAULT '0',
   "site_update" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "site_pull" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "site_sync" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "site_directory" text NOT NULL DEFAULT '',
-  "site_register" bigint NOT NULL DEFAULT 0 ,
+  "site_register" bigint NOT NULL DEFAULT '0',
   "site_sellpage" text NOT NULL DEFAULT '',
   "site_location" text NOT NULL DEFAULT '',
   "site_realm" text NOT NULL DEFAULT '',
-  "site_valid" smallint NOT NULL DEFAULT 0 ,
-  "site_dead" smallint NOT NULL DEFAULT 0 ,
-  "site_type" smallint NOT NULL DEFAULT 0 ,
+  "site_valid" smallint NOT NULL DEFAULT '0',
+  "site_dead" smallint NOT NULL DEFAULT '0',
+  "site_type" smallint NOT NULL DEFAULT '0',
   "site_project" text NOT NULL DEFAULT '',
   "site_version" text NOT NULL DEFAULT '',
   "site_crypto" text NOT NULL DEFAULT '',
@@ -1168,7 +1168,7 @@ create index "site_project" on site ("site_project");
 
 CREATE TABLE "source" (
   "src_id" serial  NOT NULL,
-  "src_channel_id" bigint  NOT NULL DEFAULT 0 ,
+  "src_channel_id" bigint  NOT NULL DEFAULT '0',
   "src_channel_xchan" text NOT NULL DEFAULT '',
   "src_xchan" text NOT NULL DEFAULT '',
   "src_patt" text NOT NULL DEFAULT '',
@@ -1188,8 +1188,8 @@ CREATE TABLE "sys_perms" (
 );
 CREATE TABLE "term" (
   "tid" serial  NOT NULL,
-  "aid" bigint  NOT NULL DEFAULT 0 ,
-  "uid" bigint  NOT NULL DEFAULT 0 ,
+  "aid" bigint  NOT NULL DEFAULT '0',
+  "uid" bigint  NOT NULL DEFAULT '0',
   "oid" bigint  NOT NULL,
   "otype" numeric(3)  NOT NULL,
   "ttype" numeric(3)  NOT NULL,
@@ -1228,7 +1228,7 @@ CREATE TABLE "updates" (
   "ud_guid" text NOT NULL DEFAULT '',
   "ud_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "ud_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "ud_flags" bigint NOT NULL DEFAULT 0 ,
+  "ud_flags" bigint NOT NULL DEFAULT '0',
   "ud_addr" text NOT NULL DEFAULT '',
   PRIMARY KEY ("ud_id")
 );
@@ -1240,7 +1240,7 @@ create index "ud_addr" on updates ("ud_addr");
 create index "ud_last" on updates ("ud_last");
 CREATE TABLE "verify" (
   "id" serial  NOT NULL,
-  "channel" bigint  NOT NULL DEFAULT 0 ,
+  "channel" bigint  NOT NULL DEFAULT '0',
   "vtype" varchar(32) NOT NULL DEFAULT '',
   "token" text NOT NULL DEFAULT '',
   "meta" text NOT NULL DEFAULT '',
@@ -1282,16 +1282,16 @@ CREATE TABLE "xchan" (
   "xchan_name" text NOT NULL DEFAULT '',
   "xchan_network" text NOT NULL DEFAULT '',
   "xchan_instance_url" text NOT NULL DEFAULT '',
-  "xchan_flags" bigint  NOT NULL DEFAULT 0 ,
+  "xchan_flags" bigint  NOT NULL DEFAULT '0',
   "xchan_photo_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "xchan_name_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "xchan_hidden" smallint NOT NULL DEFAULT 0 ,
-  "xchan_orphan" smallint NOT NULL DEFAULT 0 ,
-  "xchan_censored" smallint NOT NULL DEFAULT 0 ,
-  "xchan_selfcensored" smallint NOT NULL DEFAULT 0 ,
-  "xchan_system" smallint NOT NULL DEFAULT 0 ,
-  "xchan_pubforum" smallint NOT NULL DEFAULT 0 ,
-  "xchan_deleted" smallint NOT NULL DEFAULT 0 ,
+  "xchan_hidden" smallint NOT NULL DEFAULT '0',
+  "xchan_orphan" smallint NOT NULL DEFAULT '0',
+  "xchan_censored" smallint NOT NULL DEFAULT '0',
+  "xchan_selfcensored" smallint NOT NULL DEFAULT '0',
+  "xchan_system" smallint NOT NULL DEFAULT '0',
+  "xchan_pubforum" smallint NOT NULL DEFAULT '0',
+  "xchan_deleted" smallint NOT NULL DEFAULT '0',
   PRIMARY KEY ("xchan_hash")
 );
 create index "xchan_guid" on xchan ("xchan_guid");
@@ -1336,7 +1336,7 @@ create index "xconfig_cat" on xconfig ("cat");
 create index "xconfig_k" on xconfig ("k");
 CREATE TABLE "xign" (
   "id" serial  NOT NULL,
-  "uid" bigint NOT NULL DEFAULT 0 ,
+  "uid" bigint NOT NULL DEFAULT '0',
   "xchan" text NOT NULL DEFAULT '',
   PRIMARY KEY ("id")
 );
@@ -1346,10 +1346,10 @@ CREATE TABLE "xlink" (
   "xlink_id" serial  NOT NULL,
   "xlink_xchan" text NOT NULL DEFAULT '',
   "xlink_link" text NOT NULL DEFAULT '',
-  "xlink_rating" bigint NOT NULL DEFAULT 0 ,
+  "xlink_rating" bigint NOT NULL DEFAULT '0',
   "xlink_rating_text" TEXT NOT NULL DEFAULT '',
   "xlink_updated" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
-  "xlink_static" numeric(1) NOT NULL DEFAULT 0 ,
+  "xlink_static" numeric(1) NOT NULL DEFAULT '0',
   "xlink_sig" text NOT NULL DEFAULT '',
   PRIMARY KEY ("xlink_id")
 );
@@ -1361,7 +1361,7 @@ create index "xlink_static" on xlink ("xlink_static");
 CREATE TABLE "xperm" (
   "xp_id" serial NOT NULL,
   "xp_client" varchar( 20 ) NOT NULL DEFAULT '',
-  "xp_channel" bigint NOT NULL DEFAULT 0 ,
+  "xp_channel" bigint NOT NULL DEFAULT '0',
   "xp_perm" varchar( 64 ) NOT NULL DEFAULT '',
   PRIMARY KEY ("xp_id")
 );
@@ -1370,7 +1370,7 @@ create index "xp_channel" on xperm ("xp_channel");
 create index "xp_perm" on xperm ("xp_perm");
 CREATE TABLE "xprof" (
   "xprof_hash" text NOT NULL,
-  "xprof_age" numeric(3)  NOT NULL DEFAULT 0 ,
+  "xprof_age" numeric(3)  NOT NULL DEFAULT '0',
   "xprof_desc" text NOT NULL DEFAULT '',
   "xprof_dob" varchar(12) NOT NULL DEFAULT '',
   "xprof_gender" text NOT NULL DEFAULT '',
@@ -1401,7 +1401,7 @@ CREATE TABLE "xtag" (
   "xtag_id" serial  NOT NULL,
   "xtag_hash" text NOT NULL,
   "xtag_term" text NOT NULL DEFAULT '',
-  "xtag_flags" bigint NOT NULL DEFAULT 0 ,
+  "xtag_flags" bigint NOT NULL DEFAULT '0',
   PRIMARY KEY ("xtag_id")
 );
 create index "xtag_term" on xtag ("xtag_term");