diff options
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r-- | install/schema_postgres.sql | 296 |
1 files changed, 148 insertions, 148 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index d4ffed130..4584e4f2e 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_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "app_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', @@ -158,19 +158,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, @@ -214,8 +214,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, @@ -223,7 +223,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"); @@ -234,8 +234,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 '', @@ -247,8 +247,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', @@ -293,7 +293,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', @@ -304,7 +304,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, @@ -318,12 +318,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, @@ -342,7 +342,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" ( @@ -389,9 +389,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', @@ -402,19 +402,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") ); @@ -448,8 +448,8 @@ CREATE TABLE "groups" ( "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") @@ -464,8 +464,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") ); @@ -480,8 +480,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_host" text NOT NULL DEFAULT '', @@ -490,10 +490,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"); @@ -512,11 +512,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"); @@ -543,9 +543,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', @@ -564,7 +564,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, @@ -587,32 +587,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") ); @@ -714,9 +714,9 @@ create index "likes_target_type" on likes ("target_type"); create index "likes_target_id" on likes ("target_id"); 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', @@ -728,13 +728,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") @@ -758,10 +758,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") @@ -775,14 +775,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") ); @@ -801,7 +801,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, @@ -850,18 +850,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"); @@ -889,7 +889,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, @@ -899,7 +899,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, @@ -912,16 +912,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, @@ -948,8 +948,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") ); @@ -985,7 +985,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, @@ -1001,8 +1001,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 '', @@ -1039,7 +1039,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") @@ -1061,7 +1061,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, @@ -1096,8 +1096,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") ); @@ -1107,8 +1107,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, @@ -1119,19 +1119,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 '', @@ -1151,7 +1151,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 '', @@ -1171,8 +1171,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, @@ -1211,7 +1211,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") ); @@ -1223,7 +1223,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 '', @@ -1265,16 +1265,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"); @@ -1319,7 +1319,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") ); @@ -1329,10 +1329,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") ); @@ -1344,7 +1344,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") ); @@ -1353,7 +1353,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 '', @@ -1384,7 +1384,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"); |