Skip to content

Instantly share code, notes, and snippets.

@aldarund

aldarund/pgcrash.json

Last active October 26, 2018 23:01
Show Gist options
  • Save aldarund/60c259a4011a5925b46bfcde47df7cb2 to your computer and use it in GitHub Desktop.
Save aldarund/60c259a4011a5925b46bfcde47df7cb2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgcrash.json
[
{
"sql": "SELECT t.oid, typarray FROM pg_type t JOIN pg_namespace ns ON typnamespace = ns.oid WHERE typname = 'hstore'",
"time": "0.002"
},
{
"sql": "SELECT typarray FROM pg_type WHERE typname = 'citext'",
"time": "0.000"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.002"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "CREATE TABLE \"django_migrations\" (\"id\" serial NOT NULL PRIMARY KEY, \"app\" varchar(255) NOT NULL, \"name\" varchar(255) NOT NULL, \"applied\" timestamp with time zone NOT NULL)",
"time": "0.011"
},
{
"sql": "CREATE TABLE \"django_content_type\" (\"id\" serial NOT NULL PRIMARY KEY, \"name\" varchar(100) NOT NULL, \"app_label\" varchar(100) NOT NULL, \"model\" varchar(100) NOT NULL)",
"time": "0.005"
},
{
"sql": "ALTER TABLE \"django_content_type\" ADD CONSTRAINT \"django_content_type_app_label_model_76bd3d3b_uniq\" UNIQUE (\"app_label\", \"model\")",
"time": "0.005"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('contenttypes', '0001_initial', '2018-10-26T23:01:14.906017+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"django_content_type\" ALTER COLUMN \"name\" DROP NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"django_content_type\" DROP COLUMN \"name\" CASCADE",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('contenttypes', '0002_remove_content_type_name', '2018-10-26T23:01:14.922018+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "CREATE TABLE \"auth_permission\" (\"id\" serial NOT NULL PRIMARY KEY, \"name\" varchar(50) NOT NULL, \"content_type_id\" integer NOT NULL, \"codename\" varchar(100) NOT NULL)",
"time": "0.006"
},
{
"sql": "CREATE TABLE \"auth_group\" (\"id\" serial NOT NULL PRIMARY KEY, \"name\" varchar(80) NOT NULL UNIQUE)",
"time": "0.009"
},
{
"sql": "CREATE TABLE \"auth_group_permissions\" (\"id\" serial NOT NULL PRIMARY KEY, \"group_id\" integer NOT NULL, \"permission_id\" integer NOT NULL)",
"time": "0.005"
},
{
"sql": "ALTER TABLE \"auth_permission\" ADD CONSTRAINT \"auth_permission_content_type_id_2f476e4b_fk_django_co\" FOREIGN KEY (\"content_type_id\") REFERENCES \"django_content_type\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.002"
},
{
"sql": "ALTER TABLE \"auth_permission\" ADD CONSTRAINT \"auth_permission_content_type_id_codename_01ab375a_uniq\" UNIQUE (\"content_type_id\", \"codename\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"auth_permission_content_type_id_2f476e4b\" ON \"auth_permission\" (\"content_type_id\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"auth_group_name_a6ea08ec_like\" ON \"auth_group\" (\"name\" varchar_pattern_ops)",
"time": "0.005"
},
{
"sql": "ALTER TABLE \"auth_group_permissions\" ADD CONSTRAINT \"auth_group_permissions_group_id_b120cbf9_fk_auth_group_id\" FOREIGN KEY (\"group_id\") REFERENCES \"auth_group\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"auth_group_permissions\" ADD CONSTRAINT \"auth_group_permissio_permission_id_84c5c92e_fk_auth_perm\" FOREIGN KEY (\"permission_id\") REFERENCES \"auth_permission\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"auth_group_permissions\" ADD CONSTRAINT \"auth_group_permissions_group_id_permission_id_0cd325b0_uniq\" UNIQUE (\"group_id\", \"permission_id\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"auth_group_permissions_group_id_b120cbf9\" ON \"auth_group_permissions\" (\"group_id\")",
"time": "0.005"
},
{
"sql": "CREATE INDEX \"auth_group_permissions_permission_id_84c5c92e\" ON \"auth_group_permissions\" (\"permission_id\")",
"time": "0.004"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0001_initial', '2018-10-26T23:01:14.993018+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"auth_permission\" ALTER COLUMN \"name\" TYPE varchar(255) USING \"name\"::varchar(255)",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0002_alter_permission_name_max_length', '2018-10-26T23:01:15.004021+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0003_alter_user_email_max_length', '2018-10-26T23:01:15.013017+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0004_alter_user_username_opts', '2018-10-26T23:01:15.022017+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0005_alter_user_last_login_null', '2018-10-26T23:01:15.037017+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0006_require_contenttypes_0002', '2018-10-26T23:01:15.046018+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0007_alter_validators_add_error_messages', '2018-10-26T23:01:15.055021+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0008_alter_user_username_max_length', '2018-10-26T23:01:15.064018+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('auth', '0009_alter_user_last_name_max_length', '2018-10-26T23:01:15.074020+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "CREATE TABLE \"users_hamachiuser\" (\"password\" varchar(128) NOT NULL, \"last_login\" timestamp with time zone NULL, \"is_superuser\" boolean NOT NULL, \"username\" varchar(150) NOT NULL UNIQUE, \"first_name\" varchar(30) NOT NULL, \"last_name\" varchar(150) NOT NULL, \"email\" varchar(254) NOT NULL, \"is_staff\" boolean NOT NULL, \"is_active\" boolean NOT NULL, \"date_joined\" timestamp with time zone NOT NULL, \"id\" uuid NOT NULL PRIMARY KEY)",
"time": "0.013"
},
{
"sql": "CREATE TABLE \"users_hamachiuser_groups\" (\"id\" serial NOT NULL PRIMARY KEY, \"hamachiuser_id\" uuid NOT NULL, \"group_id\" integer NOT NULL)",
"time": "0.005"
},
{
"sql": "CREATE TABLE \"users_hamachiuser_user_permissions\" (\"id\" serial NOT NULL PRIMARY KEY, \"hamachiuser_id\" uuid NOT NULL, \"permission_id\" integer NOT NULL)",
"time": "0.005"
},
{
"sql": "CREATE TABLE \"users_applicant\" (\"created\" timestamp with time zone NOT NULL, \"modified\" timestamp with time zone NOT NULL, \"status\" integer NOT NULL, \"activate_date\" timestamp with time zone NULL, \"deactivate_date\" timestamp with time zone NULL, \"id\" uuid NOT NULL PRIMARY KEY, \"first_name\" varchar(50) NOT NULL, \"last_name\" varchar(50) NOT NULL, \"email\" varchar(254) NOT NULL, \"smartmove_renter_created\" boolean NOT NULL, \"user_id\" uuid NULL UNIQUE)",
"time": "0.010"
},
{
"sql": "CREATE TABLE \"users_landlord\" (\"created\" timestamp with time zone NOT NULL, \"modified\" timestamp with time zone NOT NULL, \"status\" integer NOT NULL, \"activate_date\" timestamp with time zone NULL, \"deactivate_date\" timestamp with time zone NULL, \"id\" uuid NOT NULL PRIMARY KEY, \"landlord_type\" varchar(50) NOT NULL, \"first_name\" varchar(50) NULL, \"last_name\" varchar(50) NULL, \"email\" varchar(254) NOT NULL, \"street1\" varchar(100) NULL, \"street2\" varchar(100) NULL, \"city\" varchar(100) NULL, \"state\" varchar(20) NULL, \"zip\" varchar(6) NULL, \"phone\" varchar(20) NULL, \"user_id\" uuid NOT NULL UNIQUE)",
"time": "0.013"
},
{
"sql": "CREATE INDEX \"users_hamachiuser_username_b58b1e80_like\" ON \"users_hamachiuser\" (\"username\" varchar_pattern_ops)",
"time": "0.004"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_groups\" ADD CONSTRAINT \"users_hamachiuser_gr_hamachiuser_id_be9092c7_fk_users_ham\" FOREIGN KEY (\"hamachiuser_id\") REFERENCES \"users_hamachiuser\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.002"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_groups\" ADD CONSTRAINT \"users_hamachiuser_groups_group_id_4af1b872_fk_auth_group_id\" FOREIGN KEY (\"group_id\") REFERENCES \"auth_group\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_groups\" ADD CONSTRAINT \"users_hamachiuser_groups_hamachiuser_id_group_id_1671411b_uniq\" UNIQUE (\"hamachiuser_id\", \"group_id\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"users_hamachiuser_groups_hamachiuser_id_be9092c7\" ON \"users_hamachiuser_groups\" (\"hamachiuser_id\")",
"time": "0.005"
},
{
"sql": "CREATE INDEX \"users_hamachiuser_groups_group_id_4af1b872\" ON \"users_hamachiuser_groups\" (\"group_id\")",
"time": "0.004"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_user_permissions\" ADD CONSTRAINT \"users_hamachiuser_us_hamachiuser_id_34fc624c_fk_users_ham\" FOREIGN KEY (\"hamachiuser_id\") REFERENCES \"users_hamachiuser\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.002"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_user_permissions\" ADD CONSTRAINT \"users_hamachiuser_us_permission_id_9165fc3b_fk_auth_perm\" FOREIGN KEY (\"permission_id\") REFERENCES \"auth_permission\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"users_hamachiuser_user_permissions\" ADD CONSTRAINT \"users_hamachiuser_user_p_hamachiuser_id_permissio_04db0330_uniq\" UNIQUE (\"hamachiuser_id\", \"permission_id\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"users_hamachiuser_user_permissions_hamachiuser_id_34fc624c\" ON \"users_hamachiuser_user_permissions\" (\"hamachiuser_id\")",
"time": "0.005"
},
{
"sql": "CREATE INDEX \"users_hamachiuser_user_permissions_permission_id_9165fc3b\" ON \"users_hamachiuser_user_permissions\" (\"permission_id\")",
"time": "0.009"
},
{
"sql": "ALTER TABLE \"users_applicant\" ADD CONSTRAINT \"users_applicant_user_id_9c357d23_fk_users_hamachiuser_id\" FOREIGN KEY (\"user_id\") REFERENCES \"users_hamachiuser\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"users_landlord\" ADD CONSTRAINT \"users_landlord_user_id_c1e68e4f_fk_users_hamachiuser_id\" FOREIGN KEY (\"user_id\") REFERENCES \"users_hamachiuser\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('users', '0001_initial', '2018-10-26T23:01:15.203149+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.002"
},
{
"sql": "CREATE TABLE \"django_admin_log\" (\"id\" serial NOT NULL PRIMARY KEY, \"action_time\" timestamp with time zone NOT NULL, \"object_id\" text NULL, \"object_repr\" varchar(200) NOT NULL, \"action_flag\" smallint NOT NULL CHECK (\"action_flag\" >= 0), \"change_message\" text NOT NULL, \"content_type_id\" integer NULL, \"user_id\" uuid NOT NULL)",
"time": "0.023"
},
{
"sql": "ALTER TABLE \"django_admin_log\" ADD CONSTRAINT \"django_admin_log_content_type_id_c4bce8eb_fk_django_co\" FOREIGN KEY (\"content_type_id\") REFERENCES \"django_content_type\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"django_admin_log\" ADD CONSTRAINT \"django_admin_log_user_id_c564eba6_fk_users_hamachiuser_id\" FOREIGN KEY (\"user_id\") REFERENCES \"users_hamachiuser\" (\"id\") DEFERRABLE INITIALLY DEFERRED",
"time": "0.001"
},
{
"sql": "CREATE INDEX \"django_admin_log_content_type_id_c4bce8eb\" ON \"django_admin_log\" (\"content_type_id\")",
"time": "0.004"
},
{
"sql": "CREATE INDEX \"django_admin_log_user_id_c564eba6\" ON \"django_admin_log\" (\"user_id\")",
"time": "0.005"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin', '0001_initial', '2018-10-26T23:01:15.255150+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.002"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin', '0002_logentry_remove_auto_add', '2018-10-26T23:01:15.268149+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin', '0003_logentry_add_action_flag_choices', '2018-10-26T23:01:15.280151+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "CREATE TABLE \"admin_interface_theme\" (\"id\" serial NOT NULL PRIMARY KEY, \"name\" varchar(50) NOT NULL, \"active\" boolean NOT NULL, \"title\" varchar(50) NOT NULL, \"title_visible\" boolean NOT NULL, \"logo\" varchar(100) NOT NULL, \"logo_visible\" boolean NOT NULL, \"css_header_background_color\" varchar(18) NOT NULL, \"css_header_title_color\" varchar(18) NOT NULL, \"css_header_text_color\" varchar(18) NOT NULL, \"css_header_link_color\" varchar(18) NOT NULL, \"css_header_link_hover_color\" varchar(18) NOT NULL, \"css_module_background_color\" varchar(18) NOT NULL, \"css_module_text_color\" varchar(18) NOT NULL, \"css_module_link_color\" varchar(18) NOT NULL, \"css_module_link_hover_color\" varchar(18) NOT NULL, \"css_module_rounded_corners\" boolean NOT NULL, \"css_generic_link_color\" varchar(18) NOT NULL, \"css_generic_link_hover_color\" varchar(18) NOT NULL, \"css_save_button_background_color\" varchar(18) NOT NULL, \"css_save_button_background_hover_color\" varchar(18) NOT NULL, \"css_save_button_text_color\" varchar(18) NOT NULL, \"css_delete_button_background_color\" varchar(18) NOT NULL, \"css_delete_button_background_hover_color\" varchar(18) NOT NULL, \"css_delete_button_text_color\" varchar(18) NOT NULL, \"css\" text NOT NULL, \"list_filter_dropdown\" boolean NOT NULL)",
"time": "0.011"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0001_initial', '2018-10-26T23:01:15.302150+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"related_modal_active\" boolean DEFAULT true NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"related_modal_active\" DROP DEFAULT",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"related_modal_background_color\" varchar(18) DEFAULT 'b''#000000''' NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"related_modal_background_color\" DROP DEFAULT",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"related_modal_background_opacity\" double precision DEFAULT 0.2 NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"related_modal_background_opacity\" DROP DEFAULT",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"related_modal_rounded_corners\" boolean DEFAULT true NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"related_modal_rounded_corners\" DROP DEFAULT",
"time": "0.000"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.000"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0002_add_related_modal', '2018-10-26T23:01:15.329150+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.000"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"logo_color\" varchar(18) DEFAULT '#FFFFFF' NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"logo_color\" DROP DEFAULT",
"time": "0.000"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0003_add_logo_color', '2018-10-26T23:01:15.343149+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.000"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" RENAME COLUMN \"css_header_title_color\" TO \"title_color\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0004_rename_title_color', '2018-10-26T23:01:15.354153+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"recent_actions_visible\" boolean DEFAULT true NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"recent_actions_visible\" DROP DEFAULT",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0005_add_recent_actions_visible', '2018-10-26T23:01:15.365150+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0006_bytes_to_str', '2018-10-26T23:01:15.446149+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ADD COLUMN \"favicon\" varchar(100) DEFAULT '' NOT NULL",
"time": "0.001"
},
{
"sql": "ALTER TABLE \"admin_interface_theme\" ALTER COLUMN \"favicon\" DROP DEFAULT",
"time": "0.001"
},
{
"sql": "\n SELECT c.relname, c.relkind\n FROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n WHERE c.relkind IN ('r', 'v')\n AND n.nspname NOT IN ('pg_catalog', 'pg_toast')\n AND pg_catalog.pg_table_is_visible(c.oid)",
"time": "0.001"
},
{
"sql": "INSERT INTO \"django_migrations\" (\"app\", \"name\", \"applied\") VALUES ('admin_interface', '0007_add_favicon', '2018-10-26T23:01:15.459149+00:00'::timestamptz) RETURNING \"django_migrations\".\"id\"",
"time": "0.001"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment