527 lines
33 KiB
SQL
527 lines
33 KiB
SQL
-- PostgreSQL Database Backup
|
||
-- Database: server_dj_test
|
||
-- Date: 2025-12-24 17:53:53.003629
|
||
-- Created by Django Backup System using psycopg2
|
||
|
||
SET client_encoding = 'UTF8';
|
||
SET standard_conforming_strings = on;
|
||
SET check_function_bodies = false;
|
||
SET client_min_messages = warning;
|
||
|
||
|
||
-- Table: accounts_customuser
|
||
DROP TABLE IF EXISTS "accounts_customuser" CASCADE;
|
||
CREATE TABLE "accounts_customuser" (
|
||
"id" BIGINT NOT NULL,
|
||
"password" VARCHAR(128) NOT NULL,
|
||
"last_login" TIMESTAMP WITH TIME ZONE,
|
||
"is_superuser" BOOLEAN NOT NULL,
|
||
"email" VARCHAR(254) NOT NULL,
|
||
"first_name" VARCHAR(150) NOT NULL,
|
||
"last_name" VARCHAR(150) NOT NULL,
|
||
"is_staff" BOOLEAN NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL,
|
||
"date_joined" TIMESTAMP WITH TIME ZONE NOT NULL
|
||
);
|
||
|
||
-- Data for table: accounts_customuser
|
||
INSERT INTO "accounts_customuser" ("id", "password", "last_login", "is_superuser", "email", "first_name", "last_name", "is_staff", "is_active", "date_joined") VALUES (1, 'pbkdf2_sha256$1000000$u1P0iFbGOM2z5Cwk30yJNO$TPhvLzXuCeSWXc4cCpQIDYv8ZZGs0S1RbWuN2aefwCQ=', '2025-12-24T17:53:25.150388+00:00'::timestamptz, true, 'beyhan@beyhan.dev', '', '', true, true, '2025-12-24T17:53:11.303375+00:00'::timestamptz);
|
||
|
||
|
||
-- Table: accounts_customuser_groups
|
||
DROP TABLE IF EXISTS "accounts_customuser_groups" CASCADE;
|
||
CREATE TABLE "accounts_customuser_groups" (
|
||
"id" BIGINT NOT NULL,
|
||
"customuser_id" BIGINT NOT NULL,
|
||
"group_id" INTEGER NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: accounts_customuser_user_permissions
|
||
DROP TABLE IF EXISTS "accounts_customuser_user_permissions" CASCADE;
|
||
CREATE TABLE "accounts_customuser_user_permissions" (
|
||
"id" BIGINT NOT NULL,
|
||
"customuser_id" BIGINT NOT NULL,
|
||
"permission_id" INTEGER NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: auth_group
|
||
DROP TABLE IF EXISTS "auth_group" CASCADE;
|
||
CREATE TABLE "auth_group" (
|
||
"id" INTEGER NOT NULL,
|
||
"name" VARCHAR(150) NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: auth_group_permissions
|
||
DROP TABLE IF EXISTS "auth_group_permissions" CASCADE;
|
||
CREATE TABLE "auth_group_permissions" (
|
||
"id" BIGINT NOT NULL,
|
||
"group_id" INTEGER NOT NULL,
|
||
"permission_id" INTEGER NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: auth_permission
|
||
DROP TABLE IF EXISTS "auth_permission" CASCADE;
|
||
CREATE TABLE "auth_permission" (
|
||
"id" INTEGER NOT NULL,
|
||
"name" VARCHAR(255) NOT NULL,
|
||
"content_type_id" INTEGER NOT NULL,
|
||
"codename" VARCHAR(100) NOT NULL
|
||
);
|
||
|
||
-- Data for table: auth_permission
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (1, 'Can add log entry', 1, 'add_logentry');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (2, 'Can change log entry', 1, 'change_logentry');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (4, 'Can view log entry', 1, 'view_logentry');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (5, 'Can add permission', 2, 'add_permission');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (6, 'Can change permission', 2, 'change_permission');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (7, 'Can delete permission', 2, 'delete_permission');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (8, 'Can view permission', 2, 'view_permission');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (9, 'Can add group', 3, 'add_group');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (10, 'Can change group', 3, 'change_group');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (11, 'Can delete group', 3, 'delete_group');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (12, 'Can view group', 3, 'view_group');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (13, 'Can add content type', 4, 'add_contenttype');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (14, 'Can change content type', 4, 'change_contenttype');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (15, 'Can delete content type', 4, 'delete_contenttype');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (16, 'Can view content type', 4, 'view_contenttype');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (17, 'Can add session', 5, 'add_session');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (18, 'Can change session', 5, 'change_session');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (19, 'Can delete session', 5, 'delete_session');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (20, 'Can view session', 5, 'view_session');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (21, 'Can add association', 6, 'add_association');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (22, 'Can change association', 6, 'change_association');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (23, 'Can delete association', 6, 'delete_association');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (24, 'Can view association', 6, 'view_association');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (25, 'Can add code', 7, 'add_code');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (26, 'Can change code', 7, 'change_code');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (27, 'Can delete code', 7, 'delete_code');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (28, 'Can view code', 7, 'view_code');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (29, 'Can add nonce', 8, 'add_nonce');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (30, 'Can change nonce', 8, 'change_nonce');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (31, 'Can delete nonce', 8, 'delete_nonce');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (32, 'Can view nonce', 8, 'view_nonce');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (33, 'Can add user social auth', 9, 'add_usersocialauth');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (34, 'Can change user social auth', 9, 'change_usersocialauth');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (35, 'Can delete user social auth', 9, 'delete_usersocialauth');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (36, 'Can view user social auth', 9, 'view_usersocialauth');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (37, 'Can add partial', 10, 'add_partial');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (38, 'Can change partial', 10, 'change_partial');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (39, 'Can delete partial', 10, 'delete_partial');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (40, 'Can view partial', 10, 'view_partial');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (41, 'Can add site', 11, 'add_site');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (42, 'Can change site', 11, 'change_site');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (43, 'Can delete site', 11, 'delete_site');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (44, 'Can view site', 11, 'view_site');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (45, 'Can add user', 12, 'add_customuser');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (46, 'Can change user', 12, 'change_customuser');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (47, 'Can delete user', 12, 'delete_customuser');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (48, 'Can view user', 12, 'view_customuser');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (49, 'Can add Post Tagı', 13, 'add_tags');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (50, 'Can change Post Tagı', 13, 'change_tags');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (51, 'Can delete Post Tagı', 13, 'delete_tags');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (52, 'Can view Post Tagı', 13, 'view_tags');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (53, 'Can add Post Kategori', 14, 'add_category');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (54, 'Can change Post Kategori', 14, 'change_category');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (55, 'Can delete Post Kategori', 14, 'delete_category');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (56, 'Can view Post Kategori', 14, 'view_category');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (57, 'Can add Post', 15, 'add_post');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (58, 'Can change Post', 15, 'change_post');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (59, 'Can delete Post', 15, 'delete_post');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (60, 'Can view Post', 15, 'view_post');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (61, 'Can add Kategori Ziyareti', 16, 'add_categoryview');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (62, 'Can change Kategori Ziyareti', 16, 'change_categoryview');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (63, 'Can delete Kategori Ziyareti', 16, 'delete_categoryview');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (64, 'Can view Kategori Ziyareti', 16, 'view_categoryview');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (65, 'Can add Post Yorum', 17, 'add_comment');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (66, 'Can change Post Yorum', 17, 'change_comment');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (67, 'Can delete Post Yorum', 17, 'delete_comment');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (68, 'Can view Post Yorum', 17, 'view_comment');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (69, 'Can add Veritabanı Yedeği', 18, 'add_databasebackup');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (70, 'Can change Veritabanı Yedeği', 18, 'change_databasebackup');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (71, 'Can delete Veritabanı Yedeği', 18, 'delete_databasebackup');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (72, 'Can view Veritabanı Yedeği', 18, 'view_databasebackup');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (73, 'Can add Banner', 19, 'add_banner');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (74, 'Can change Banner', 19, 'change_banner');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (75, 'Can delete Banner', 19, 'delete_banner');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (76, 'Can view Banner', 19, 'view_banner');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (77, 'Can add Site Ayarı', 20, 'add_setting');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (78, 'Can change Site Ayarı', 20, 'change_setting');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (79, 'Can delete Site Ayarı', 20, 'delete_setting');
|
||
INSERT INTO "auth_permission" ("id", "name", "content_type_id", "codename") VALUES (80, 'Can view Site Ayarı', 20, 'view_setting');
|
||
|
||
|
||
-- Table: backup_databasebackup
|
||
DROP TABLE IF EXISTS "backup_databasebackup" CASCADE;
|
||
CREATE TABLE "backup_databasebackup" (
|
||
"id" BIGINT NOT NULL,
|
||
"name" VARCHAR(255) NOT NULL,
|
||
"file_path" VARCHAR(500),
|
||
"file_size" BIGINT,
|
||
"status" VARCHAR(20) NOT NULL,
|
||
"backup_type" VARCHAR(20) NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"completed_at" TIMESTAMP WITH TIME ZONE,
|
||
"error_message" TEXT,
|
||
"notes" TEXT,
|
||
"created_by_id" BIGINT
|
||
);
|
||
|
||
-- Data for table: backup_databasebackup
|
||
INSERT INTO "backup_databasebackup" ("id", "name", "file_path", "file_size", "status", "backup_type", "created_at", "completed_at", "error_message", "notes", "created_by_id") VALUES (1, 'Manuel Yedek - 2025-12-24 17:53:52', NULL, NULL, 'in_progress', 'manual', '2025-12-24T17:53:52.965869+00:00'::timestamptz, NULL, NULL, NULL, 1);
|
||
|
||
|
||
-- Table: banners
|
||
DROP TABLE IF EXISTS "banners" CASCADE;
|
||
CREATE TABLE "banners" (
|
||
"id" BIGINT NOT NULL,
|
||
"color" VARCHAR(25) NOT NULL,
|
||
"title" VARCHAR(254),
|
||
"text1" VARCHAR(254),
|
||
"text2" VARCHAR(254),
|
||
"text4" VARCHAR(254),
|
||
"text5" VARCHAR(254),
|
||
"image" VARCHAR(100) NOT NULL,
|
||
"image_k" VARCHAR(100),
|
||
"image_k_txt" VARCHAR(254),
|
||
"is_active" BOOLEAN NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: categories
|
||
DROP TABLE IF EXISTS "categories" CASCADE;
|
||
CREATE TABLE "categories" (
|
||
"id" BIGINT NOT NULL,
|
||
"title" VARCHAR(254) NOT NULL,
|
||
"keywords" VARCHAR(254) NOT NULL,
|
||
"description" VARCHAR(254) NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL,
|
||
"order" INTEGER NOT NULL,
|
||
"slug" VARCHAR(250) NOT NULL,
|
||
"image" VARCHAR(100),
|
||
"parent_id" BIGINT
|
||
);
|
||
|
||
|
||
-- Table: category_views
|
||
DROP TABLE IF EXISTS "category_views" CASCADE;
|
||
CREATE TABLE "category_views" (
|
||
"id" BIGINT NOT NULL,
|
||
"ip_address" INET NOT NULL,
|
||
"user_agent" TEXT,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"category_id" BIGINT NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: comments
|
||
DROP TABLE IF EXISTS "comments" CASCADE;
|
||
CREATE TABLE "comments" (
|
||
"id" BIGINT NOT NULL,
|
||
"title" VARCHAR(254) NOT NULL,
|
||
"body" TEXT NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL,
|
||
"slug" VARCHAR(50) NOT NULL,
|
||
"parent_id" BIGINT,
|
||
"user_id" BIGINT NOT NULL,
|
||
"product_id" BIGINT NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: django_admin_log
|
||
DROP TABLE IF EXISTS "django_admin_log" CASCADE;
|
||
CREATE TABLE "django_admin_log" (
|
||
"id" INTEGER NOT NULL,
|
||
"action_time" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"object_id" TEXT,
|
||
"object_repr" VARCHAR(200) NOT NULL,
|
||
"action_flag" SMALLINT NOT NULL,
|
||
"change_message" TEXT NOT NULL,
|
||
"content_type_id" INTEGER,
|
||
"user_id" BIGINT NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: django_content_type
|
||
DROP TABLE IF EXISTS "django_content_type" CASCADE;
|
||
CREATE TABLE "django_content_type" (
|
||
"id" INTEGER NOT NULL,
|
||
"app_label" VARCHAR(100) NOT NULL,
|
||
"model" VARCHAR(100) NOT NULL
|
||
);
|
||
|
||
-- Data for table: django_content_type
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (1, 'admin', 'logentry');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (2, 'auth', 'permission');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (3, 'auth', 'group');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (4, 'contenttypes', 'contenttype');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (5, 'sessions', 'session');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (6, 'social_django', 'association');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (7, 'social_django', 'code');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (8, 'social_django', 'nonce');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (9, 'social_django', 'usersocialauth');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (10, 'social_django', 'partial');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (11, 'sites', 'site');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (12, 'accounts', 'customuser');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (13, 'blog', 'tags');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (14, 'blog', 'category');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (15, 'blog', 'post');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (16, 'blog', 'categoryview');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (17, 'blog', 'comment');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (18, 'backup', 'databasebackup');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (19, 'settings', 'banner');
|
||
INSERT INTO "django_content_type" ("id", "app_label", "model") VALUES (20, 'settings', 'setting');
|
||
|
||
|
||
-- Table: django_migrations
|
||
DROP TABLE IF EXISTS "django_migrations" CASCADE;
|
||
CREATE TABLE "django_migrations" (
|
||
"id" BIGINT NOT NULL,
|
||
"app" VARCHAR(255) NOT NULL,
|
||
"name" VARCHAR(255) NOT NULL,
|
||
"applied" TIMESTAMP WITH TIME ZONE NOT NULL
|
||
);
|
||
|
||
-- Data for table: django_migrations
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (1, 'contenttypes', '0001_initial', '2025-12-24T17:52:43.845116+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (2, 'contenttypes', '0002_remove_content_type_name', '2025-12-24T17:52:43.863713+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (3, 'auth', '0001_initial', '2025-12-24T17:52:43.935604+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (4, 'auth', '0002_alter_permission_name_max_length', '2025-12-24T17:52:43.951365+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (5, 'auth', '0003_alter_user_email_max_length', '2025-12-24T17:52:43.964620+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (6, 'auth', '0004_alter_user_username_opts', '2025-12-24T17:52:43.977833+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (7, 'auth', '0005_alter_user_last_login_null', '2025-12-24T17:52:43.990016+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (8, 'auth', '0006_require_contenttypes_0002', '2025-12-24T17:52:43.998463+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (9, 'auth', '0007_alter_validators_add_error_messages', '2025-12-24T17:52:44.012382+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (10, 'auth', '0008_alter_user_username_max_length', '2025-12-24T17:52:44.026522+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (11, 'auth', '0009_alter_user_last_name_max_length', '2025-12-24T17:52:44.039605+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (12, 'auth', '0010_alter_group_name_max_length', '2025-12-24T17:52:44.069435+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (13, 'auth', '0011_update_proxy_permissions', '2025-12-24T17:52:44.081493+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (14, 'auth', '0012_alter_user_first_name_max_length', '2025-12-24T17:52:44.095286+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (15, 'accounts', '0001_initial', '2025-12-24T17:52:44.239074+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (16, 'admin', '0001_initial', '2025-12-24T17:52:44.304825+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (17, 'admin', '0002_logentry_remove_auto_add', '2025-12-24T17:52:44.318239+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (18, 'admin', '0003_logentry_add_action_flag_choices', '2025-12-24T17:52:44.335477+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (19, 'backup', '0001_initial', '2025-12-24T17:52:44.475575+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (20, 'blog', '0001_initial', '2025-12-24T17:52:44.799361+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (21, 'sessions', '0001_initial', '2025-12-24T17:52:44.831822+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (22, 'settings', '0001_initial', '2025-12-24T17:52:44.879705+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (23, 'sites', '0001_initial', '2025-12-24T17:52:44.903306+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (24, 'sites', '0002_alter_domain_unique', '2025-12-24T17:52:44.924515+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (25, 'default', '0001_initial', '2025-12-24T17:52:45.067098+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (26, 'social_auth', '0001_initial', '2025-12-24T17:52:45.072695+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (27, 'default', '0002_add_related_name', '2025-12-24T17:52:45.095480+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (28, 'social_auth', '0002_add_related_name', '2025-12-24T17:52:45.099517+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (29, 'default', '0003_alter_email_max_length', '2025-12-24T17:52:45.122647+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (30, 'social_auth', '0003_alter_email_max_length', '2025-12-24T17:52:45.125593+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (31, 'default', '0004_auto_20160423_0400', '2025-12-24T17:52:45.142991+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (32, 'social_auth', '0004_auto_20160423_0400', '2025-12-24T17:52:45.146933+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (33, 'social_auth', '0005_auto_20160727_2333', '2025-12-24T17:52:45.163032+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (34, 'social_django', '0006_partial', '2025-12-24T17:52:45.206595+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (35, 'social_django', '0007_code_timestamp', '2025-12-24T17:52:45.236352+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (36, 'social_django', '0008_partial_timestamp', '2025-12-24T17:52:45.263722+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (37, 'social_django', '0009_auto_20191118_0520', '2025-12-24T17:52:45.312704+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (38, 'social_django', '0010_uid_db_index', '2025-12-24T17:52:45.341894+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (39, 'social_django', '0011_alter_id_fields', '2025-12-24T17:52:45.443986+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (40, 'social_django', '0012_usersocialauth_extra_data_new', '2025-12-24T17:52:45.482091+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (41, 'social_django', '0013_migrate_extra_data', '2025-12-24T17:52:45.555931+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (42, 'social_django', '0014_remove_usersocialauth_extra_data', '2025-12-24T17:52:45.587466+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (43, 'social_django', '0015_rename_extra_data_new_usersocialauth_extra_data', '2025-12-24T17:52:45.615244+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (44, 'social_django', '0016_alter_usersocialauth_extra_data', '2025-12-24T17:52:45.632400+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (45, 'social_django', '0017_usersocialauth_user_social_auth_uid_required', '2025-12-24T17:52:45.659854+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (46, 'social_django', '0002_add_related_name', '2025-12-24T17:52:45.669891+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (47, 'social_django', '0003_alter_email_max_length', '2025-12-24T17:52:45.675697+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (48, 'social_django', '0004_auto_20160423_0400', '2025-12-24T17:52:45.680972+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (49, 'social_django', '0001_initial', '2025-12-24T17:52:45.686400+00:00'::timestamptz);
|
||
INSERT INTO "django_migrations" ("id", "app", "name", "applied") VALUES (50, 'social_django', '0005_auto_20160727_2333', '2025-12-24T17:52:45.691806+00:00'::timestamptz);
|
||
|
||
|
||
-- Table: django_session
|
||
DROP TABLE IF EXISTS "django_session" CASCADE;
|
||
CREATE TABLE "django_session" (
|
||
"session_key" VARCHAR(40) NOT NULL,
|
||
"session_data" TEXT NOT NULL,
|
||
"expire_date" TIMESTAMP WITH TIME ZONE NOT NULL
|
||
);
|
||
|
||
-- Data for table: django_session
|
||
INSERT INTO "django_session" ("session_key", "session_data", "expire_date") VALUES ('gfkfhw05oct7kit2ke5ajczqw87f149e', '.eJxVjEEOwiAQAP_C2RCgFMGjd99Alt1FqgaS0p6MfzckPeh1ZjJvEWHfStw7r3EhcRFanH5ZAnxyHYIeUO9NYqvbuiQ5EnnYLm-N-HU92r9BgV7GltA7RjNNGYMCRp-0mxw5AyoQOJ9xtqCs0mc0kMgzZafQZORZmWDF5wv8EjiA:1vYT37:QY5dFu5b3NpHb2pzPhSGQ_tdLH2bfEpdqH5vn1ycLiA', '2026-01-07T17:53:25.157543+00:00'::timestamptz);
|
||
|
||
|
||
-- Table: django_site
|
||
DROP TABLE IF EXISTS "django_site" CASCADE;
|
||
CREATE TABLE "django_site" (
|
||
"id" INTEGER NOT NULL,
|
||
"domain" VARCHAR(100) NOT NULL,
|
||
"name" VARCHAR(50) NOT NULL
|
||
);
|
||
|
||
-- Data for table: django_site
|
||
INSERT INTO "django_site" ("id", "domain", "name") VALUES (1, 'example.com', 'example.com');
|
||
|
||
|
||
-- Table: posts
|
||
DROP TABLE IF EXISTS "posts" CASCADE;
|
||
CREATE TABLE "posts" (
|
||
"id" BIGINT NOT NULL,
|
||
"title" VARCHAR(254) NOT NULL,
|
||
"content" TEXT,
|
||
"keywords" VARCHAR(254) NOT NULL,
|
||
"image" VARCHAR(100),
|
||
"video" VARCHAR(254),
|
||
"slug" VARCHAR(250) NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL,
|
||
"is_front" BOOLEAN NOT NULL,
|
||
"parent_id" BIGINT
|
||
);
|
||
|
||
|
||
-- Table: posts_categories
|
||
DROP TABLE IF EXISTS "posts_categories" CASCADE;
|
||
CREATE TABLE "posts_categories" (
|
||
"id" BIGINT NOT NULL,
|
||
"post_id" BIGINT NOT NULL,
|
||
"category_id" BIGINT NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: posts_tags
|
||
DROP TABLE IF EXISTS "posts_tags" CASCADE;
|
||
CREATE TABLE "posts_tags" (
|
||
"id" BIGINT NOT NULL,
|
||
"post_id" BIGINT NOT NULL,
|
||
"tags_id" BIGINT NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: settings
|
||
DROP TABLE IF EXISTS "settings" CASCADE;
|
||
CREATE TABLE "settings" (
|
||
"id" BIGINT NOT NULL,
|
||
"title" VARCHAR(254) NOT NULL,
|
||
"meta_title" VARCHAR(254) NOT NULL,
|
||
"meta_description" VARCHAR(254) NOT NULL,
|
||
"phone" VARCHAR(254) NOT NULL,
|
||
"url" VARCHAR(254),
|
||
"email" VARCHAR(254) NOT NULL,
|
||
"facebook" VARCHAR(254),
|
||
"x" VARCHAR(254),
|
||
"instagram" VARCHAR(254),
|
||
"whatsapp" VARCHAR(254),
|
||
"slogan" VARCHAR(254),
|
||
"w_logo" VARCHAR(100),
|
||
"b_logo" VARCHAR(100),
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: social_auth_association
|
||
DROP TABLE IF EXISTS "social_auth_association" CASCADE;
|
||
CREATE TABLE "social_auth_association" (
|
||
"id" BIGINT NOT NULL,
|
||
"server_url" VARCHAR(255) NOT NULL,
|
||
"handle" VARCHAR(255) NOT NULL,
|
||
"secret" VARCHAR(255) NOT NULL,
|
||
"issued" INTEGER NOT NULL,
|
||
"lifetime" INTEGER NOT NULL,
|
||
"assoc_type" VARCHAR(64) NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: social_auth_code
|
||
DROP TABLE IF EXISTS "social_auth_code" CASCADE;
|
||
CREATE TABLE "social_auth_code" (
|
||
"id" BIGINT NOT NULL,
|
||
"email" VARCHAR(254) NOT NULL,
|
||
"code" VARCHAR(32) NOT NULL,
|
||
"verified" BOOLEAN NOT NULL,
|
||
"timestamp" TIMESTAMP WITH TIME ZONE NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: social_auth_nonce
|
||
DROP TABLE IF EXISTS "social_auth_nonce" CASCADE;
|
||
CREATE TABLE "social_auth_nonce" (
|
||
"id" BIGINT NOT NULL,
|
||
"server_url" VARCHAR(255) NOT NULL,
|
||
"timestamp" INTEGER NOT NULL,
|
||
"salt" VARCHAR(65) NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: social_auth_partial
|
||
DROP TABLE IF EXISTS "social_auth_partial" CASCADE;
|
||
CREATE TABLE "social_auth_partial" (
|
||
"id" BIGINT NOT NULL,
|
||
"token" VARCHAR(32) NOT NULL,
|
||
"next_step" SMALLINT NOT NULL,
|
||
"backend" VARCHAR(32) NOT NULL,
|
||
"timestamp" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"data" JSONB NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: social_auth_usersocialauth
|
||
DROP TABLE IF EXISTS "social_auth_usersocialauth" CASCADE;
|
||
CREATE TABLE "social_auth_usersocialauth" (
|
||
"id" BIGINT NOT NULL,
|
||
"provider" VARCHAR(32) NOT NULL,
|
||
"uid" VARCHAR(255) NOT NULL,
|
||
"user_id" BIGINT NOT NULL,
|
||
"created" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"modified" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"extra_data" JSONB NOT NULL
|
||
);
|
||
|
||
|
||
-- Table: tags
|
||
DROP TABLE IF EXISTS "tags" CASCADE;
|
||
CREATE TABLE "tags" (
|
||
"id" BIGINT NOT NULL,
|
||
"tag" VARCHAR(254) NOT NULL,
|
||
"created_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"updated_at" TIMESTAMP WITH TIME ZONE NOT NULL,
|
||
"is_active" BOOLEAN NOT NULL
|
||
);
|
||
|
||
|
||
-- Reset sequences
|
||
SELECT setval('django_migrations_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "django_migrations"));
|
||
SELECT setval('django_content_type_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "django_content_type"));
|
||
SELECT setval('auth_permission_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "auth_permission"));
|
||
SELECT setval('auth_group_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "auth_group"));
|
||
SELECT setval('auth_group_permissions_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "auth_group_permissions"));
|
||
SELECT setval('accounts_customuser_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "accounts_customuser"));
|
||
SELECT setval('accounts_customuser_groups_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "accounts_customuser_groups"));
|
||
SELECT setval('accounts_customuser_user_permissions_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "accounts_customuser_user_permissions"));
|
||
SELECT setval('django_admin_log_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "django_admin_log"));
|
||
SELECT setval('backup_databasebackup_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "backup_databasebackup"));
|
||
SELECT setval('tags_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "tags"));
|
||
SELECT setval('categories_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "categories"));
|
||
SELECT setval('posts_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "posts"));
|
||
SELECT setval('posts_categories_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "posts_categories"));
|
||
SELECT setval('posts_tags_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "posts_tags"));
|
||
SELECT setval('category_views_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "category_views"));
|
||
SELECT setval('comments_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "comments"));
|
||
SELECT setval('banners_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "banners"));
|
||
SELECT setval('settings_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "settings"));
|
||
SELECT setval('django_site_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "django_site"));
|
||
SELECT setval('social_auth_association_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "social_auth_association"));
|
||
SELECT setval('social_auth_code_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "social_auth_code"));
|
||
SELECT setval('social_auth_nonce_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "social_auth_nonce"));
|
||
SELECT setval('social_auth_usersocialauth_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "social_auth_usersocialauth"));
|
||
SELECT setval('social_auth_partial_id_seq', (SELECT COALESCE(MAX("id"), 1) FROM "social_auth_partial"));
|