-- PostgreSQL Database Backup
-- Database: server_dj
-- Date: 2025-12-22 17:09:20.281699
-- 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$1200000$93xPBCOPbW1XXQzUIvHCOc$gO1/rPxbbMoz0kHfYfhBibSEaW4OvXTw/Mf+QEcCCrY=', '2025-12-22 17:00:30.489489+00:00', True, 'beyhan@beyhan.dev', '', '', True, True, '2025-12-22 17:00:19.382231+00:00');


-- 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', 3, 'add_permission');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (6, 'Can change permission', 3, 'change_permission');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (7, 'Can delete permission', 3, 'delete_permission');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (8, 'Can view permission', 3, 'view_permission');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (9, 'Can add group', 2, 'add_group');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (10, 'Can change group', 2, 'change_group');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (11, 'Can delete group', 2, 'delete_group');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (12, 'Can view group', 2, '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', 10, 'add_usersocialauth');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (34, 'Can change user social auth', 10, 'change_usersocialauth');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (35, 'Can delete user social auth', 10, 'delete_usersocialauth');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (36, 'Can view user social auth', 10, 'view_usersocialauth');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (37, 'Can add partial', 9, 'add_partial');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (38, 'Can change partial', 9, 'change_partial');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (39, 'Can delete partial', 9, 'delete_partial');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (40, 'Can view partial', 9, '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 Banner', 13, 'add_banner');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (50, 'Can change Banner', 13, 'change_banner');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (51, 'Can delete Banner', 13, 'delete_banner');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (52, 'Can view Banner', 13, 'view_banner');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (53, 'Can add Site Ayarı', 14, 'add_setting');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (54, 'Can change Site Ayarı', 14, 'change_setting');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (55, 'Can delete Site Ayarı', 14, 'delete_setting');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (56, 'Can view Site Ayarı', 14, 'view_setting');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (57, 'Can add Post Tagı', 19, 'add_tags');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (58, 'Can change Post Tagı', 19, 'change_tags');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (59, 'Can delete Post Tagı', 19, 'delete_tags');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (60, 'Can view Post Tagı', 19, 'view_tags');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (61, 'Can add Post Kategori', 15, 'add_category');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (62, 'Can change Post Kategori', 15, 'change_category');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (63, 'Can delete Post Kategori', 15, 'delete_category');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (64, 'Can view Post Kategori', 15, 'view_category');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (65, 'Can add Post', 18, 'add_post');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (66, 'Can change Post', 18, 'change_post');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (67, 'Can delete Post', 18, 'delete_post');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (68, 'Can view Post', 18, 'view_post');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (69, 'Can add Kategori Ziyareti', 16, 'add_categoryview');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (70, 'Can change Kategori Ziyareti', 16, 'change_categoryview');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (71, 'Can delete Kategori Ziyareti', 16, 'delete_categoryview');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (72, 'Can view Kategori Ziyareti', 16, 'view_categoryview');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (73, 'Can add Post Yorum', 17, 'add_comment');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (74, 'Can change Post Yorum', 17, 'change_comment');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (75, 'Can delete Post Yorum', 17, 'delete_comment');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (76, 'Can view Post Yorum', 17, 'view_comment');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (77, 'Can add Veritabanı Yedeği', 20, 'add_databasebackup');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (78, 'Can change Veritabanı Yedeği', 20, 'change_databasebackup');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (79, 'Can delete Veritabanı Yedeği', 20, 'delete_databasebackup');
INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (80, 'Can view Veritabanı Yedeği', 20, 'view_databasebackup');


-- 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, 'Yedek 1', NULL, NULL, 'pending', 'manual', '2025-12-22 17:00:54.955082+00:00', NULL, NULL, '', 1);
INSERT INTO backup_databasebackup (id, name, file_path, file_size, status, backup_type, created_at, completed_at, error_message, notes, created_by_id) VALUES (6, 'Manuel Yedek - 2025-12-22 17:09:20', NULL, NULL, 'in_progress', 'manual', '2025-12-22 17:09:20.245933+00:00', 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
);

-- Data for table: django_admin_log
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (1, '2025-12-22 17:00:54.961166+00:00', '1', 'Yedek 1 - Bekliyor', 1, '[{"added": {}}]', 20, 1);
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (2, '2025-12-22 17:01:10.019183+00:00', '1', 'Yedek 1 - Bekliyor', 2, '[]', 20, 1);
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (3, '2025-12-22 17:08:18.352881+00:00', '2', 'Manuel Yedek - 2025-12-22 17:01:15 - Başarısız', 3, '', 20, 1);
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (4, '2025-12-22 17:08:25.284922+00:00', '4', 'Manuel Yedek - 2025-12-22 17:05:18 - Başarısız', 3, '', 20, 1);
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (5, '2025-12-22 17:08:30.992298+00:00', '3', 'Manuel Yedek - 2025-12-22 17:03:41 - Başarısız', 3, '', 20, 1);
INSERT INTO django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) VALUES (6, '2025-12-22 17:08:56.836202+00:00', '5', 'Manuel Yedek - 2025-12-22 17:06:15 - Tamamlandı', 3, '', 20, 1);


-- 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', 'group');
INSERT INTO django_content_type (id, app_label, model) VALUES (3, 'auth', 'permission');
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', 'partial');
INSERT INTO django_content_type (id, app_label, model) VALUES (10, 'social_django', 'usersocialauth');
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, 'settings', 'banner');
INSERT INTO django_content_type (id, app_label, model) VALUES (14, 'settings', 'setting');
INSERT INTO django_content_type (id, app_label, model) VALUES (15, 'blog', 'category');
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, 'blog', 'post');
INSERT INTO django_content_type (id, app_label, model) VALUES (19, 'blog', 'tags');
INSERT INTO django_content_type (id, app_label, model) VALUES (20, 'backup', 'databasebackup');


-- 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-22 16:57:19.217932+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (2, 'contenttypes', '0002_remove_content_type_name', '2025-12-22 16:57:19.234555+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (3, 'auth', '0001_initial', '2025-12-22 16:57:19.434147+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (4, 'auth', '0002_alter_permission_name_max_length', '2025-12-22 16:57:19.446206+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (5, 'auth', '0003_alter_user_email_max_length', '2025-12-22 16:57:19.455809+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (6, 'auth', '0004_alter_user_username_opts', '2025-12-22 16:57:19.465593+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (7, 'auth', '0005_alter_user_last_login_null', '2025-12-22 16:57:19.475691+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (8, 'auth', '0006_require_contenttypes_0002', '2025-12-22 16:57:19.481434+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (9, 'auth', '0007_alter_validators_add_error_messages', '2025-12-22 16:57:19.565856+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (10, 'auth', '0008_alter_user_username_max_length', '2025-12-22 16:57:19.592172+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (11, 'auth', '0009_alter_user_last_name_max_length', '2025-12-22 16:57:19.603096+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (12, 'auth', '0010_alter_group_name_max_length', '2025-12-22 16:57:19.625591+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (13, 'auth', '0011_update_proxy_permissions', '2025-12-22 16:57:19.634914+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (14, 'auth', '0012_alter_user_first_name_max_length', '2025-12-22 16:57:19.645268+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (15, 'accounts', '0001_initial', '2025-12-22 16:57:19.898703+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (16, 'admin', '0001_initial', '2025-12-22 16:57:19.967758+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (17, 'admin', '0002_logentry_remove_auto_add', '2025-12-22 16:57:19.980668+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (18, 'admin', '0003_logentry_add_action_flag_choices', '2025-12-22 16:57:19.994932+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (19, 'backup', '0001_initial', '2025-12-22 16:57:20.047172+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (20, 'blog', '0001_initial', '2025-12-22 16:57:20.451373+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (21, 'sessions', '0001_initial', '2025-12-22 16:57:20.596961+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (22, 'settings', '0001_initial', '2025-12-22 16:57:20.623314+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (23, 'sites', '0001_initial', '2025-12-22 16:57:20.634939+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (24, 'sites', '0002_alter_domain_unique', '2025-12-22 16:57:20.648215+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (25, 'default', '0001_initial', '2025-12-22 16:57:20.743912+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (26, 'social_auth', '0001_initial', '2025-12-22 16:57:20.747238+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (27, 'social_django', '0001_initial', '2025-12-22 16:57:20.750337+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (28, 'default', '0002_add_related_name', '2025-12-22 16:57:20.772416+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (29, 'social_auth', '0002_add_related_name', '2025-12-22 16:57:20.776564+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (30, 'social_django', '0002_add_related_name', '2025-12-22 16:57:20.778681+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (31, 'default', '0003_alter_email_max_length', '2025-12-22 16:57:20.797950+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (32, 'social_auth', '0003_alter_email_max_length', '2025-12-22 16:57:20.800526+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (33, 'social_django', '0003_alter_email_max_length', '2025-12-22 16:57:20.802697+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (34, 'default', '0004_auto_20160423_0400', '2025-12-22 16:57:20.818189+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (35, 'social_auth', '0004_auto_20160423_0400', '2025-12-22 16:57:20.821978+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (36, 'social_django', '0004_auto_20160423_0400', '2025-12-22 16:57:20.824686+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (37, 'social_auth', '0005_auto_20160727_2333', '2025-12-22 16:57:20.838781+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (38, 'social_django', '0005_auto_20160727_2333', '2025-12-22 16:57:20.842005+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (39, 'social_django', '0006_partial', '2025-12-22 16:57:20.882162+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (40, 'social_django', '0007_code_timestamp', '2025-12-22 16:57:21.016558+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (41, 'social_django', '0008_partial_timestamp', '2025-12-22 16:57:21.036847+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (42, 'social_django', '0009_auto_20191118_0520', '2025-12-22 16:57:21.078912+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (43, 'social_django', '0010_uid_db_index', '2025-12-22 16:57:21.103380+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (44, 'social_django', '0011_alter_id_fields', '2025-12-22 16:57:21.271476+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (45, 'social_django', '0012_usersocialauth_extra_data_new', '2025-12-22 16:57:21.315237+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (46, 'social_django', '0013_migrate_extra_data', '2025-12-22 16:57:21.359048+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (47, 'social_django', '0014_remove_usersocialauth_extra_data', '2025-12-22 16:57:21.387186+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (48, 'social_django', '0015_rename_extra_data_new_usersocialauth_extra_data', '2025-12-22 16:57:21.411254+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (49, 'social_django', '0016_alter_usersocialauth_extra_data', '2025-12-22 16:57:21.425493+00:00');
INSERT INTO django_migrations (id, app, name, applied) VALUES (50, 'social_django', '0017_usersocialauth_user_social_auth_uid_required', '2025-12-22 16:57:21.447520+00:00');


-- 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 ('e7jyr13wedmqdkjukqb35t2pyylkbvwz', '.eJxVjEEOwiAQRe_C2hBgpKBL9z0DmWFGqRpISrsy3l2bdKHb_977L5VwXUpau8xpYnVWVh1-N8L8kLoBvmO9NZ1bXeaJ9KbonXY9NpbnZXf_Dgr28q0F0bKTEGNG70Uie8vgLbGBYxQbwBHlwQ0szoILOQsDwMmZeKVgvHp_APiKN_E:1vXjGo:c9NPOwqzmQXV6RsDHkclP-w4ogI8VDPbV0KQilsiW6Y', '2026-01-05 17:00:30.494599+00:00');


-- 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));