ALTER TABLE "public"."accounts_paymentuserprofile" DROP CONSTRAINT "user_id_refs_id_6551d7ece0dfe686";

ALTER TABLE "public"."atlas_configurationstore" DROP CONSTRAINT "site_id_refs_id_615f21722fba4554";

ALTER TABLE "public"."atlas_configurationstore" ADD CONSTRAINT "atlas_configurationstore_name_2a87f79c_uniq" UNIQUE ("name", "site_id");

ALTER TABLE "public"."atlas_configurationstore" DROP CONSTRAINT "atlas_configurationstore_name_2aab71482a87f79c_uniq";

ALTER TABLE "public"."atlas_countrydata" DROP CONSTRAINT "country_id_refs_iso_7b5d2ca1c3e2f851";

ALTER TABLE "public"."atlas_countrydata" DROP COLUMN "display_state";

ALTER TABLE "public"."atlas_countrydata" DROP COLUMN "measurement_system";

ALTER TABLE "public"."atlas_countrydata" DROP COLUMN "short_name";

ALTER TABLE "public"."atlas_device" ADD CONSTRAINT "atlas_device_name_key" UNIQUE ("name");

ALTER TABLE "public"."atlas_device" DROP CONSTRAINT "atlas_device_name_uniq";

ALTER TABLE "public"."atlas_emote" ADD CONSTRAINT "atlas_emote_shortcut_key" UNIQUE ("shortcut");

ALTER TABLE "public"."atlas_emote" DROP CONSTRAINT "atlas_emote_shortcut_uniq";

ALTER TABLE "public"."atlas_emoticon" DROP CONSTRAINT "atlas_emoticon_shortcut_uniq";

ALTER TABLE "public"."atlas_emoticon" DROP CONSTRAINT "owner_id_refs_id_5eec1e3213add2f6";

ALTER TABLE "public"."atlas_emoticon" ALTER COLUMN "user_supplied" SET DEFAULT false;

ALTER TABLE "public"."atlas_emoticon" ADD CONSTRAINT "atlas_emoticon_shortcut_key" UNIQUE ("shortcut");

ALTER TABLE "public"."atlas_favorite" DROP CONSTRAINT "site_id_refs_id_2b6ed12e0328f78d";

ALTER TABLE "public"."atlas_favorite" DROP CONSTRAINT "user_id_refs_id_2aea420b287541ca";

ALTER TABLE "public"."atlas_favorite" ALTER COLUMN "object_type" SET DEFAULT 'chatroom'::character varying;

ALTER TABLE "public"."atlas_friendrelation" DROP CONSTRAINT "atlas_friendrelation_owner_id_5a169269d6e43a6c_uniq";

ALTER TABLE "public"."atlas_friendrelation" DROP CONSTRAINT "friend_id_refs_id_3240114d21340744";

ALTER TABLE "public"."atlas_friendrelation" DROP CONSTRAINT "owner_id_refs_id_3240114d21340744";

ALTER TABLE "public"."atlas_friendrelation" ALTER COLUMN "status" SET DEFAULT 'none'::character varying;

ALTER TABLE "public"."atlas_friendrelation" ALTER COLUMN "date" DROP DEFAULT;

ALTER TABLE "public"."atlas_friendrelation" ADD CONSTRAINT "atlas_friendrelation_owner_id_291bc594_uniq" UNIQUE ("owner_id", "friend_id");

ALTER TABLE "public"."atlas_language" ADD CONSTRAINT "atlas_language_iso2_key" UNIQUE ("iso2");

ALTER TABLE "public"."atlas_language" DROP CONSTRAINT "atlas_language_iso2_uniq";

ALTER TABLE "public"."atlas_note" DROP CONSTRAINT "site_id_refs_id_6340b987ac4a4df9";

ALTER TABLE "public"."atlas_note" DROP CONSTRAINT "user_id_refs_id_6f5a3267f8e7405e";

ALTER TABLE "public"."atlas_siteevent" DROP CONSTRAINT "user_id_refs_id_573d411a1bc956ac";

ALTER TABLE "public"."atlas_siteevent" DROP CONSTRAINT "subsite_id_refs_site_ptr_id_52f49984c1996ab9";

ALTER TABLE "public"."atlas_siteevent" DROP CONSTRAINT "event_main_site_id_refs_site_ptr_id_52f49984c1996ab9";

ALTER TABLE "public"."atlas_siteevent" ADD COLUMN "site_id" int4 NOT NULL;

ALTER TABLE "public"."atlas_siteevent" ALTER COLUMN "stamp" TYPE timestamptz(6);

ALTER TABLE "public"."atlas_siteevent" DROP COLUMN "event_main_site_id";

ALTER TABLE "public"."atlas_userblocklist" DROP CONSTRAINT "atlas_userblocklist_owner_id_6db27dea732bda1f_uniq";

ALTER TABLE "public"."atlas_userblocklist" DROP CONSTRAINT "owner_id_refs_id_1377325162620ebb";

ALTER TABLE "public"."atlas_userblocklist" DROP CONSTRAINT "blockeduser_id_refs_id_1377325162620ebb";

ALTER TABLE "public"."atlas_userblocklist" ALTER COLUMN "date" SET DEFAULT '2011-06-16 08:50:21.298566-04'::timestamp with time zone;

ALTER TABLE "public"."atlas_userblocklist" ADD CONSTRAINT "atlas_userblocklist_owner_id_732bda1f_uniq" UNIQUE ("owner_id", "blockeduser_id");

ALTER TABLE "public"."atlas_userplaylist" DROP CONSTRAINT "site_id_refs_id_df712445dfa3f10";

ALTER TABLE "public"."atlas_userplaylist" DROP CONSTRAINT "user_id_refs_id_7cbe7e4079874f99";

ALTER TABLE "public"."atlas_userplaylist" ALTER COLUMN "site_id" DROP DEFAULT;

ALTER TABLE "public"."atlas_userplaylistobject" DROP CONSTRAINT "playlist_object_id_refs_id_77f8b28593e4fad1";

ALTER TABLE "public"."atlas_userplaylistobject" DROP CONSTRAINT "user_playlist_id_refs_id_b2fc351e6ee2352";

ALTER TABLE "public"."atlas_userprivateinformation" DROP CONSTRAINT "userprofile_id_refs_id_1b253821dc800490";

ALTER TABLE "public"."atlas_userprivateinformation" DROP CONSTRAINT "country_id_refs_iso_3a400bd7ebf93c3c";

ALTER TABLE "public"."atlas_userprivateinformation" DROP COLUMN "messenger_type";

ALTER TABLE "public"."atlas_userprivateinformation" DROP COLUMN "messenger_id";

ALTER TABLE "public"."atlas_userprofile" ALTER COLUMN "chatuser_type" DROP DEFAULT;

ALTER TABLE "public"."atlas_userprofile" ALTER COLUMN "chatuser_application_status" DROP DEFAULT;

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "is_suspended";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "affiliate_code_ap";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "affiliate_code_aid";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "affiliate_code_tc";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "affiliate_code_pt";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "affiliate_code_art";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "chat_font_color";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "date_activated";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "never_logged_in";

ALTER TABLE "public"."atlas_userprofile" DROP COLUMN "join_ip";

ALTER TABLE "public"."atlas_userprofiledocument" DROP CONSTRAINT "object_id_refs_id_247c92dfb6d6c24e";

ALTER TABLE "public"."atlas_userprofilepersonalinformation" DROP CONSTRAINT "userprofile_id_refs_id_6f46173a4fa61ade";

ALTER TABLE "public"."atlas_userprofilepersonalinformation" DROP COLUMN "turns_ons";

ALTER TABLE "public"."atlas_userprofilepersonalinformation" DROP COLUMN "turns_offs";

ALTER TABLE "public"."atlas_userprofilesettings" DROP CONSTRAINT "country_id_refs_iso_370e30b188d64a02";

ALTER TABLE "public"."atlas_userprofilesettings" DROP CONSTRAINT "userprofile_id_refs_id_7aa6f584bf1da136";

ALTER TABLE "public"."atlas_userprofilesettings" ALTER COLUMN "marital_status" TYPE varchar(20);

ALTER TABLE "public"."atlas_userprofilesettings" DROP COLUMN "measurement_system";

ALTER TABLE "public"."atlas_userprofileuserinformation" DROP CONSTRAINT "userprofile_id_refs_id_35613d4f74359d7f";

ALTER TABLE "public"."atlas_userprofileuserinformation" DROP CONSTRAINT "country_id_refs_iso_7bcaab41d9c69cb3";
ALTER TABLE "public"."atlas_userprofileuserinformation" DROP COLUMN "state";
ALTER TABLE "public"."atlas_userprofileuserinformation" DROP COLUMN "city";
ALTER TABLE "public"."atlas_userprofileuserinformation" DROP COLUMN "profileimagefilecropped";
ALTER TABLE "public"."atlas_userprofileuserinformation" DROP COLUMN "profileimagefile_320x240";
ALTER TABLE "public"."atlas_userprofileuserinformation" DROP COLUMN "profileimagefile_150x150";
ALTER TABLE "public"."atlas_userprofileuserinformation_languages" DROP CONSTRAINT "userprofileuserinformation_id_refs_id_27d30c1c66ef6849";
ALTER TABLE "public"."atlas_userprofileuserinformation_languages" DROP CONSTRAINT "language_id_refs_id_71d3fbc314f539a4";
ALTER TABLE "public"."atlas_userprofileuserinformation_languages" ADD CONSTRAINT "atlas_userprofileus_userprofileuserinformation_id_187213f8_uniq" UNIQUE ("userprofileuserinformation_id", "language_id");
ALTER TABLE "public"."atlas_userprofileuserinformation_languages" DROP CONSTRAINT "atlas_userp_userprofileuserinformation_id_741cedfde78dec08_uniq";
ALTER TABLE "public"."atlas_wcomment" DROP CONSTRAINT "site_id_refs_id_3385968750625273";
ALTER TABLE "public"."atlas_wcomment" DROP CONSTRAINT "reference_id_refs_id_2c07b7b5b6ca9c95";
ALTER TABLE "public"."atlas_wcomment" DROP CONSTRAINT "user_id_refs_id_22a10c6e700bdc1c";
ALTER TABLE "public"."auth_user" DROP CONSTRAINT "authentication_group_id_refs_id_somestuff";
ALTER TABLE "public"."auth_user" DROP CONSTRAINT "auth_user_username_key";
ALTER TABLE "public"."auth_user" ADD CONSTRAINT "auth_user_username_key" UNIQUE ("username");
CREATE TABLE "public"."chatsite_camapilog" (
"id" int4 DEFAULT nextval('chatsite_camapilog_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"ip" inet NOT NULL,
"method" varchar(32) NOT NULL,
"user_id" varchar(32),
"chat_room_id" varchar(32),
"result" bool,
"raw_inputs" text,
"raw_outputs" text,
"meta" text,
CONSTRAINT "chatsite_camapilog_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatban" (
"id" int4 DEFAULT nextval('chatsite_chatban_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"host_id" int4 NOT NULL,
"user_type" varchar(10) DEFAULT 'user'::character varying NOT NULL,
"chat_name" varchar(32) NOT NULL,
"reason" varchar(250) NOT NULL,
"ban_date" timestamptz(6) NOT NULL,
"expire_date" timestamptz(6) NOT NULL,
CONSTRAINT "chatsite_chatban_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatlog" (
"id" int4 DEFAULT nextval('chatsite_chatlog_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4,
"user_name" varchar(32) NOT NULL,
"target_id" int4,
"target_name" varchar(32) NOT NULL,
"chat_room_id" int4 NOT NULL,
"chat_type" varchar(16) DEFAULT 'free'::character varying NOT NULL,
"action" varchar(20) DEFAULT ''::character varying NOT NULL,
"content" varchar(255) DEFAULT ''::character varying NOT NULL,
"parameters" text DEFAULT ''::text NOT NULL,
CONSTRAINT "chatsite_chatlog_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatrequest" (
"id" int4 DEFAULT nextval('chatsite_chatrequest_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"chat_room_id" int4 NOT NULL,
"user_id" int4 NOT NULL,
"chat_type" varchar(10) NOT NULL,
"status" varchar(10) DEFAULT 'pending'::character varying NOT NULL,
"user_message" varchar(250) NOT NULL,
"host_reply" varchar(250) NOT NULL,
CONSTRAINT "chatsite_chatrequest_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatroom" (
"id" int4 DEFAULT nextval('chatsite_chatroom_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"host_id" int4 NOT NULL,
"host_chat_session_id" int4,
"host_video_session_id" int4,
"client_id" int4,
"room_type" varchar(10) NOT NULL,
"video_server" int4,
"host_ip" inet NOT NULL,
"name" varchar(32) NOT NULL,
"topic" varchar(255) NOT NULL,
"status" varchar(10) NOT NULL,
"audio_enabled" bool DEFAULT true NOT NULL,
"video_enabled" bool DEFAULT true NOT NULL,
"video_quality" varchar(32) NOT NULL,
"tip_jar_amount" int4 DEFAULT 0 NOT NULL,
"guest_view_allowed" bool DEFAULT true NOT NULL,
"guest_chat_allowed" bool DEFAULT true NOT NULL,
"open_date" timestamptz(6) NOT NULL,
"last_date" timestamptz(6) NOT NULL,
"close_date" timestamptz(6),
"chat_server" int4,
"chat_log_server" int4,
"premium_spy_rate" int4 DEFAULT 0 NOT NULL,
"premium_chat_rate" int4 DEFAULT 0 NOT NULL,
"private_chat_rate" int4 DEFAULT 0 NOT NULL,
CONSTRAINT "chatsite_chatroom_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatsession" (
"id" int4 DEFAULT nextval('chatsite_chatsession_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4,
"chat_room_id" int4 NOT NULL,
"auth_key" varchar(32) NOT NULL,
"chat_name" varchar(32) NOT NULL,
"status" varchar(10) NOT NULL,
"read_only" bool DEFAULT false NOT NULL,
"open_date" timestamptz(6) NOT NULL,
"last_date" timestamptz(6) NOT NULL,
"close_date" timestamptz(6),
CONSTRAINT "chatsite_chatsession_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatsiteuser" (
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4 NOT NULL,
"status" varchar(32) DEFAULT 'pending'::character varying NOT NULL,
"studio_id" int4,
"is_host" bool DEFAULT true NOT NULL,
"is_studio" bool DEFAULT true NOT NULL,
"is_online" bool DEFAULT false NOT NULL,
"online_status" varchar(16) DEFAULT 'offline'::character varying NOT NULL,
"room_id" int4,
"last_online_date" timestamptz(6) DEFAULT '0001-01-01 00:03:58-04:56:02'::timestamp with time zone NOT NULL,
"premium_spy_rate" int4 DEFAULT 0 NOT NULL,
"premium_chat_rate" int4 DEFAULT 0 NOT NULL,
"private_chat_rate" int4 DEFAULT 0 NOT NULL,
"guest_view_allowed" bool DEFAULT true NOT NULL,
"guest_chat_allowed" bool DEFAULT true NOT NULL,
"commission_per_credit" numeric(5,3) DEFAULT 0 NOT NULL,
"studio_share" numeric(4,2) DEFAULT 0 NOT NULL,
"rating_votes" int4 DEFAULT 0 NOT NULL,
"rating_score" int4 DEFAULT 0 NOT NULL,
CONSTRAINT "chatsite_chatsiteuser_pkey" PRIMARY KEY ("user_id"),
CONSTRAINT "chatsite_chatsiteuser_rating_votes_check" CHECK (rating_votes >= 0)
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chattopiclog" (
"id" int4 DEFAULT nextval('chatsite_chattopiclog_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"host_id" int4 NOT NULL,
"topic" varchar(255) DEFAULT ''::character varying NOT NULL,
CONSTRAINT "chatsite_chattopiclog_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_chatuserdocuments" (
"id" int4 DEFAULT nextval('chatsite_chatuserdocuments_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"userprofile_id" int4 NOT NULL,
"name" varchar(255) DEFAULT ''::character varying NOT NULL,
"date_of_birth" date NOT NULL,
"is_primary" bool DEFAULT false NOT NULL,
"face" varchar(100) NOT NULL,
"id_doc" varchar(100) NOT NULL,
"face_id" varchar(100) NOT NULL,
"model_release" varchar(100) NOT NULL,
"approved_by_id" int4,
"approval_date" timestamptz(6),
CONSTRAINT "chatsite_chatuserdocuments_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_clientsession" (
"id" int4 DEFAULT nextval('chatsite_clientsession_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4,
"host_id" int4 NOT NULL,
"user_ip" inet NOT NULL,
"chat_room_id" int4 NOT NULL,
"chat_session_id" int4,
"video_session_id" int4,
"session_type" varchar(10) NOT NULL,
"status" varchar(10) NOT NULL,
"open_date" timestamptz(6) NOT NULL,
"close_date" timestamptz(6),
"billing_status" varchar(10) DEFAULT 'unbilled'::character varying NOT NULL,
"billing_rate" int4 DEFAULT 0 NOT NULL,
"billing_reservation_id" int4,
"billing_transaction_id" int4,
"commission_status" varchar(10) DEFAULT 'pending'::character varying NOT NULL,
"commission_rate" numeric(5,2) DEFAULT 0 NOT NULL,
CONSTRAINT "chatsite_clientsession_pkey" PRIMARY KEY ("id"),
CONSTRAINT "chatsite_clientsession_chat_session_id_key" UNIQUE ("chat_session_id"),
CONSTRAINT "chatsite_clientsession_video_session_id_key" UNIQUE ("video_session_id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_flaggedchatlog" (
"id" int4 DEFAULT nextval('chatsite_flaggedchatlog_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"chat_log_id" int4 NOT NULL,
"flag_string" varchar(255) DEFAULT ''::character varying NOT NULL,
"resolver_id" int4,
"resolver_comment" varchar(255) DEFAULT ''::character varying NOT NULL,
"resolve_date" timestamptz(6),
CONSTRAINT "chatsite_flaggedchatlog_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_tip" (
"id" int4 DEFAULT nextval('chatsite_tip_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4 NOT NULL,
"host_id" int4 NOT NULL,
"chat_room_id" int4 NOT NULL,
"client_session_id" int4 NOT NULL,
"message" varchar(250) NOT NULL,
"amount" int4 NOT NULL,
"tip_date" timestamptz(6) NOT NULL,
"billing_status" varchar(10) NOT NULL,
"billing_transaction_id" int4,
"commission_status" varchar(10) DEFAULT 'pending'::character varying NOT NULL,
"commission_rate" numeric(5,2) DEFAULT 0 NOT NULL,
CONSTRAINT "chatsite_tip_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."chatsite_videosession" (
"id" int4 DEFAULT nextval('chatsite_videosession_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4,
"chat_room_id" int4 NOT NULL,
"auth_key" varchar(32) NOT NULL,
"status" varchar(10) NOT NULL,
"open_date" timestamptz(6),
"last_date" timestamptz(6),
"close_date" timestamptz(6),
CONSTRAINT "chatsite_videosession_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."django_messages_message" (
"id" int4 DEFAULT nextval('django_messages_message_id_seq'::regclass) NOT NULL,
"subject" varchar(120) NOT NULL,
"body" text NOT NULL,
"sender_id" int4 NOT NULL,
"recipient_id" int4,
"parent_msg_id" int4,
"sent_at" timestamptz(6),
"read_at" timestamptz(6),
"replied_at" timestamptz(6),
"sender_deleted_at" timestamptz(6),
"recipient_deleted_at" timestamptz(6),
CONSTRAINT "django_messages_message_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
ALTER TABLE "public"."django_site" DROP CONSTRAINT "domain_unique";
ALTER TABLE "public"."djangoratings_vote" DROP CONSTRAINT "djangoratings_vote_content_type_id_69d497af3324806f_uniq";
ALTER TABLE "public"."djangoratings_vote" ALTER COLUMN "date_added" SET DEFAULT '2011-02-25 16:25:49.251474-05'::timestamp with time zone;
ALTER TABLE "public"."djangoratings_vote" ALTER COLUMN "date_changed" SET DEFAULT '2011-02-25 16:25:49.251828-05'::timestamp with time zone;
ALTER TABLE "public"."djangoratings_vote" DROP COLUMN "cookie";
ALTER TABLE "public"."djangoratings_vote" ADD CONSTRAINT "djangoratings_vote_content_type_id_27a743e2debc2644_uniq" UNIQUE ("content_type_id", "object_id", "key", "user_id", "ip_address");
ALTER TABLE "public"."payments_billingprovidermember" DROP CONSTRAINT "payments_billingprovidermember_member_id_uniq";
ALTER TABLE "public"."payments_billingprovidermember" ALTER COLUMN "fake" SET DEFAULT true;
ALTER TABLE "public"."payments_billingprovidermember" ADD CONSTRAINT "payments_billingprovidermember_pkey" PRIMARY KEY ("member_id");
ALTER TABLE "public"."payments_gnvbillingrequestlog" DROP CONSTRAINT "user_id_refs_id_73f2f79c01724e26";
ALTER TABLE "public"."payments_paymentuserprofile" DROP CONSTRAINT "user_id_refs_id_2ee1afbe5b9388f1";
ALTER TABLE "public"."payments_paymentuserprofile" ALTER COLUMN "join_method" SET DEFAULT 'free'::character varying;
ALTER TABLE "public"."payments_paymentuserprofile" DROP COLUMN "affiliate_record_type";
ALTER TABLE "public"."payments_paymentuserprofile" ADD CONSTRAINT "payments_paymentuserprofile_user_id_key" UNIQUE ("user_id");
ALTER TABLE "public"."payments_product" DROP CONSTRAINT "payments_product_company_id_4ab2b1497495aaf8_uniq";
ALTER TABLE "public"."payments_product" DROP CONSTRAINT "currency_id_refs_id_220a14dbd078bb1e";
ALTER TABLE "public"."payments_product" DROP CONSTRAINT "product_group_id_refs_id_495001a2ade6c4f5";
ALTER TABLE "public"."payments_product" DROP CONSTRAINT "company_id_refs_co_code_7a3730a03b6622f5";
ALTER TABLE "public"."payments_product" ALTER COLUMN "default" SET DEFAULT false;
ALTER TABLE "public"."payments_product" ALTER COLUMN "member_type" SET DEFAULT 'trial'::character varying;
ALTER TABLE "public"."payments_product" ALTER COLUMN "active" SET DEFAULT true;
ALTER TABLE "public"."payments_product" ADD CONSTRAINT "payments_product_company_id_7495aaf8_uniq" UNIQUE ("company_id", "pi_code");
ALTER TABLE "public"."payments_transactionlog" ALTER COLUMN "processed" SET DEFAULT false;
ALTER TABLE "public"."registration_registrationprofile" DROP COLUMN "activation_mail_date";
ALTER TABLE "public"."registration_registrationprofile" DROP COLUMN "activation_mail_counter";
ALTER TABLE "public"."reversion_revision" DROP CONSTRAINT "user_id_refs_id_167696070c59e12b";
ALTER TABLE "public"."reversion_version" DROP CONSTRAINT "revision_id_refs_id_636f2b7f6b631d85";
ALTER TABLE "public"."reversion_version" DROP CONSTRAINT "content_type_id_refs_id_238ce22813bc8849";
ALTER TABLE "public"."sentry_groupedmessage" ALTER COLUMN "last_seen" SET DEFAULT '2011-04-18 14:05:56.772909-04'::timestamp with time zone;
ALTER TABLE "public"."sentry_groupedmessage" ALTER COLUMN "first_seen" SET DEFAULT '2011-04-18 14:05:56.773226-04'::timestamp with time zone;
ALTER TABLE "public"."sentry_message" ALTER COLUMN "datetime" SET DEFAULT '2011-04-18 14:05:56.790687-04'::timestamp with time zone;
CREATE TABLE "public"."site_credit_membershipsitecreditdefinition" (
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"membership_def_id" int4 NOT NULL,
"signup_credit" int4 NOT NULL,
"early_convert_credit" int4 NOT NULL,
"convert_credit" int4 NOT NULL,
"rebill_credit" int4 NOT NULL,
CONSTRAINT "site_credit_membershipsitecreditdefinition_pkey" PRIMARY KEY ("membership_def_id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."site_credit_sitecreditpackage" (
"id" int4 DEFAULT nextval('site_credit_sitecreditpackage_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"billing_provider" varchar(10) NOT NULL,
"name" varchar(64) NOT NULL,
"description" varchar(255) NOT NULL,
"credit_amount" int4 NOT NULL,
"sequence" varchar(256),
"product_group_id" int4,
"default" bool DEFAULT false NOT NULL,
"active" bool DEFAULT true NOT NULL,
CONSTRAINT "site_credit_sitecreditpackage_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."site_credit_sitecreditpackagecost" (
"id" int4 DEFAULT nextval('site_credit_sitecreditpackagecost_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"package_id" int4 NOT NULL,
"currency_id" int4 NOT NULL,
"amount" numeric(8,2) NOT NULL,
CONSTRAINT "site_credit_sitecreditpackagecost_pkey" PRIMARY KEY ("id"),
CONSTRAINT "site_credit_sitecreditpackagecost_package_id_37d6b68a_uniq" UNIQUE ("package_id", "currency_id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."site_credit_sitecreditreservation" (
"id" int4 DEFAULT nextval('site_credit_sitecreditreservation_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"usc_id" int4 NOT NULL,
"status" varchar(16) NOT NULL,
"base_amount" int4 NOT NULL,
"rate_per_minute" int4 NOT NULL,
"start_date" timestamptz(6) NOT NULL,
"end_date" timestamptz(6),
"expire_date" timestamptz(6) NOT NULL,
CONSTRAINT "site_credit_sitecreditreservation_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."site_credit_sitecredittransaction" (
"id" int4 DEFAULT nextval('site_credit_sitecredittransaction_id_seq'::regclass) NOT NULL,
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4 NOT NULL,
"ip_addr" varchar(16) NOT NULL,
"amount" int4 NOT NULL,
"description" varchar(255) NOT NULL,
"transaction_class" varchar(16) NOT NULL,
"transaction_date" timestamptz(6) NOT NULL,
"ref_type" varchar(16) NOT NULL,
"ref_code" varchar(64) NOT NULL,
"ref_id" varchar(64) NOT NULL,
"meta" text,
CONSTRAINT "site_credit_sitecredittransaction_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE);
CREATE TABLE "public"."site_credit_usersitecredit" (
"created_date" timestamptz(6) NOT NULL,
"updated_date" timestamptz(6) NOT NULL,
"user_id" int4 NOT NULL,
"site_credit_balance" int4 DEFAULT 0 NOT NULL,
"purchase_limit_day" int4 DEFAULT 0 NOT NULL,
"purchase_limit_month" int4 DEFAULT 0 NOT NULL,
"site_credit_total_awarded" int4 DEFAULT 0 NOT NULL,
"site_credit_total_purchased" int4 DEFAULT 0 NOT NULL,
"site_credit_total_spent" int4 D