sharix-open-landing/dumpdb.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "django_migrations" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "applied" datetime NOT NULL);
INSERT INTO django_migrations VALUES(1,'contenttypes','0001_initial','2023-02-08 08:56:45.350868');
INSERT INTO django_migrations VALUES(2,'auth','0001_initial','2023-02-08 08:56:45.373939');
INSERT INTO django_migrations VALUES(3,'admin','0001_initial','2023-02-08 08:56:45.381486');
INSERT INTO django_migrations VALUES(4,'admin','0002_logentry_remove_auto_add','2023-02-08 08:56:45.390532');
INSERT INTO django_migrations VALUES(5,'admin','0003_logentry_add_action_flag_choices','2023-02-08 08:56:45.396081');
INSERT INTO django_migrations VALUES(6,'contenttypes','0002_remove_content_type_name','2023-02-08 08:56:45.410605');
INSERT INTO django_migrations VALUES(7,'auth','0002_alter_permission_name_max_length','2023-02-08 08:56:45.421235');
INSERT INTO django_migrations VALUES(8,'auth','0003_alter_user_email_max_length','2023-02-08 08:56:45.428955');
INSERT INTO django_migrations VALUES(9,'auth','0004_alter_user_username_opts','2023-02-08 08:56:45.434886');
INSERT INTO django_migrations VALUES(10,'auth','0005_alter_user_last_login_null','2023-02-08 08:56:45.443269');
INSERT INTO django_migrations VALUES(11,'auth','0006_require_contenttypes_0002','2023-02-08 08:56:45.445100');
INSERT INTO django_migrations VALUES(12,'auth','0007_alter_validators_add_error_messages','2023-02-08 08:56:45.451917');
INSERT INTO django_migrations VALUES(13,'auth','0008_alter_user_username_max_length','2023-02-08 08:56:45.460212');
INSERT INTO django_migrations VALUES(14,'auth','0009_alter_user_last_name_max_length','2023-02-08 08:56:45.479630');
INSERT INTO django_migrations VALUES(15,'auth','0010_alter_group_name_max_length','2023-02-08 08:56:45.492521');
INSERT INTO django_migrations VALUES(16,'auth','0011_update_proxy_permissions','2023-02-08 08:56:45.499180');
INSERT INTO django_migrations VALUES(17,'auth','0012_alter_user_first_name_max_length','2023-02-08 08:56:45.507275');
INSERT INTO django_migrations VALUES(18,'butler','0001_initial','2023-02-08 08:56:45.509709');
INSERT INTO django_migrations VALUES(19,'butler','0002_remove_butlerpages_title','2023-02-08 08:56:45.512859');
INSERT INTO django_migrations VALUES(20,'sessions','0001_initial','2023-02-08 08:56:45.517334');
CREATE TABLE IF NOT EXISTS "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "auth_user_groups" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "auth_user_user_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "django_admin_log" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "object_id" text NULL, "object_repr" varchar(200) NOT NULL, "action_flag" smallint unsigned NOT NULL CHECK ("action_flag" >= 0), "change_message" text NOT NULL, "content_type_id" integer NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "user_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "action_time" datetime NOT NULL);
CREATE TABLE IF NOT EXISTS "django_content_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL);
INSERT INTO django_content_type VALUES(1,'admin','logentry');
INSERT INTO django_content_type VALUES(2,'auth','permission');
INSERT INTO django_content_type VALUES(3,'auth','group');
INSERT INTO django_content_type VALUES(4,'auth','user');
INSERT INTO django_content_type VALUES(5,'contenttypes','contenttype');
INSERT INTO django_content_type VALUES(6,'sessions','session');
INSERT INTO django_content_type VALUES(7,'butler','butlerpages');
CREATE TABLE IF NOT EXISTS "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "codename" varchar(100) NOT NULL, "name" varchar(255) NOT NULL);
INSERT INTO auth_permission VALUES(1,1,'add_logentry','Can add log entry');
INSERT INTO auth_permission VALUES(2,1,'change_logentry','Can change log entry');
INSERT INTO auth_permission VALUES(3,1,'delete_logentry','Can delete log entry');
INSERT INTO auth_permission VALUES(4,1,'view_logentry','Can view log entry');
INSERT INTO auth_permission VALUES(5,2,'add_permission','Can add permission');
INSERT INTO auth_permission VALUES(6,2,'change_permission','Can change permission');
INSERT INTO auth_permission VALUES(7,2,'delete_permission','Can delete permission');
INSERT INTO auth_permission VALUES(8,2,'view_permission','Can view permission');
INSERT INTO auth_permission VALUES(9,3,'add_group','Can add group');
INSERT INTO auth_permission VALUES(10,3,'change_group','Can change group');
INSERT INTO auth_permission VALUES(11,3,'delete_group','Can delete group');
INSERT INTO auth_permission VALUES(12,3,'view_group','Can view group');
INSERT INTO auth_permission VALUES(13,4,'add_user','Can add user');
INSERT INTO auth_permission VALUES(14,4,'change_user','Can change user');
INSERT INTO auth_permission VALUES(15,4,'delete_user','Can delete user');
INSERT INTO auth_permission VALUES(16,4,'view_user','Can view user');
INSERT INTO auth_permission VALUES(17,5,'add_contenttype','Can add content type');
INSERT INTO auth_permission VALUES(18,5,'change_contenttype','Can change content type');
INSERT INTO auth_permission VALUES(19,5,'delete_contenttype','Can delete content type');
INSERT INTO auth_permission VALUES(20,5,'view_contenttype','Can view content type');
INSERT INTO auth_permission VALUES(21,6,'add_session','Can add session');
INSERT INTO auth_permission VALUES(22,6,'change_session','Can change session');
INSERT INTO auth_permission VALUES(23,6,'delete_session','Can delete session');
INSERT INTO auth_permission VALUES(24,6,'view_session','Can view session');
INSERT INTO auth_permission VALUES(25,7,'add_butlerpages','Can add butler pages');
INSERT INTO auth_permission VALUES(26,7,'change_butlerpages','Can change butler pages');
INSERT INTO auth_permission VALUES(27,7,'delete_butlerpages','Can delete butler pages');
INSERT INTO auth_permission VALUES(28,7,'view_butlerpages','Can view butler pages');
CREATE TABLE IF NOT EXISTS "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(150) NOT NULL UNIQUE);
CREATE TABLE IF NOT EXISTS "auth_user" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NULL, "is_superuser" bool NOT NULL, "username" varchar(150) NOT NULL UNIQUE, "last_name" varchar(150) NOT NULL, "email" varchar(254) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL, "first_name" varchar(150) NOT NULL);
CREATE TABLE IF NOT EXISTS "butler_butlerpages" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "content" text NOT NULL, "pagename" varchar(50) NOT NULL UNIQUE);
INSERT INTO butler_butlerpages VALUES(3,replace('\n            <p class="my-4 text-head-butler">О КОМПАНИИ</p>\n            <p class="text-paragraph-butler">Клининговая компания «Дворецкий» предоставляет полный спектр услуг по качественной и профессиональной уборке помещений: автосалонов, торговых центров, офисов, административных зданий, производственных помещений и прилегающих к ним территорий, а также частных объектов.</p>\n            <p class="my-4 text-head-butler">НАШИ ПРЕИМУЩЕСТВА</p>\n            <p class="text-paragraph-butler">Индивидуальный подход к каждому клиенту. За каждым объектом закрепляется персональный менеджер.</p>\n            <p class="text-paragraph-butler">Сотрудничество с нами - это залог спокойствия и удобства для наших клиентов.</p>\n            <p class="text-paragraph-butler">Основной принцип нашей работы – это клиентоориентированность.</p>\n            <p class="text-paragraph-butler">Мы применяем только новейшие, безопасные чистящие средства, нанимаем только высококвалифицированный персонал и проводим постоянный контроль качества выполнения работ.</p>\n            <p class="text-paragraph-butler">Все необходимые средства и оборудование, применяемые для уборки нашей компанией, имеют сертификаты качества.</p>\n            <p class="text-paragraph-butler">Мы несем ответственность за сохранность ценных вещей во время уборки.</p>\n            <p class="my-4 text-head-butler">ПАКЕТНОЕ ОБСЛУЖИВАНИЕ</p>\n            <p class="text-paragraph-butler">Мы предлагаем пакетное обслуживание на ежемесячной основе:</p>\n            <p class="text-paragraph-butler">Уборка проводится 4 раза в месяц по предварительному согласованию даты и времени проведения работ</p>\n            <p class="text-paragraph-butler">Если Вы приобрели пакет услуг и уехали в отпуск, компания предоставляет возможность «заморозки» неиспользованных уборок.</p>\n            ','\n',char(10)),'mainpage');
CREATE TABLE IF NOT EXISTS "django_session" ("session_key" varchar(40) NOT NULL PRIMARY KEY, "session_data" text NOT NULL, "expire_date" datetime NOT NULL);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('django_migrations',20);
INSERT INTO sqlite_sequence VALUES('django_admin_log',0);
INSERT INTO sqlite_sequence VALUES('django_content_type',7);
INSERT INTO sqlite_sequence VALUES('auth_permission',28);
INSERT INTO sqlite_sequence VALUES('auth_group',0);
INSERT INTO sqlite_sequence VALUES('auth_user',0);
INSERT INTO sqlite_sequence VALUES('butler_butlerpages',3);
CREATE UNIQUE INDEX "auth_group_permissions_group_id_permission_id_0cd325b0_uniq" ON "auth_group_permissions" ("group_id", "permission_id");
CREATE INDEX "auth_group_permissions_group_id_b120cbf9" ON "auth_group_permissions" ("group_id");
CREATE INDEX "auth_group_permissions_permission_id_84c5c92e" ON "auth_group_permissions" ("permission_id");
CREATE UNIQUE INDEX "auth_user_groups_user_id_group_id_94350c0c_uniq" ON "auth_user_groups" ("user_id", "group_id");
CREATE INDEX "auth_user_groups_user_id_6a12ed8b" ON "auth_user_groups" ("user_id");
CREATE INDEX "auth_user_groups_group_id_97559544" ON "auth_user_groups" ("group_id");
CREATE UNIQUE INDEX "auth_user_user_permissions_user_id_permission_id_14a6b632_uniq" ON "auth_user_user_permissions" ("user_id", "permission_id");
CREATE INDEX "auth_user_user_permissions_user_id_a95ead1b" ON "auth_user_user_permissions" ("user_id");
CREATE INDEX "auth_user_user_permissions_permission_id_1fbb5f2c" ON "auth_user_user_permissions" ("permission_id");
CREATE INDEX "django_admin_log_content_type_id_c4bce8eb" ON "django_admin_log" ("content_type_id");
CREATE INDEX "django_admin_log_user_id_c564eba6" ON "django_admin_log" ("user_id");
CREATE UNIQUE INDEX "django_content_type_app_label_model_76bd3d3b_uniq" ON "django_content_type" ("app_label", "model");
CREATE UNIQUE INDEX "auth_permission_content_type_id_codename_01ab375a_uniq" ON "auth_permission" ("content_type_id", "codename");
CREATE INDEX "auth_permission_content_type_id_2f476e4b" ON "auth_permission" ("content_type_id");
CREATE INDEX "django_session_expire_date_a5c62663" ON "django_session" ("expire_date");
COMMIT;