File size: 32,682 Bytes
3826b3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
��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','2024-01-18 23:21:14.746041');

INSERT INTO django_migrations VALUES(2,'auth','0001_initial','2024-01-18 23:21:14.764387');

INSERT INTO django_migrations VALUES(3,'admin','0001_initial','2024-01-18 23:21:14.773882');

INSERT INTO django_migrations VALUES(4,'admin','0002_logentry_remove_auto_add','2024-01-18 23:21:14.783379');

INSERT INTO django_migrations VALUES(5,'admin','0003_logentry_add_action_flag_choices','2024-01-18 23:21:14.789869');

INSERT INTO django_migrations VALUES(6,'contenttypes','0002_remove_content_type_name','2024-01-18 23:21:14.802870');

INSERT INTO django_migrations VALUES(7,'auth','0002_alter_permission_name_max_length','2024-01-18 23:21:14.820852');

INSERT INTO django_migrations VALUES(8,'auth','0003_alter_user_email_max_length','2024-01-18 23:21:14.829262');

INSERT INTO django_migrations VALUES(9,'auth','0004_alter_user_username_opts','2024-01-18 23:21:14.836265');

INSERT INTO django_migrations VALUES(10,'auth','0005_alter_user_last_login_null','2024-01-18 23:21:14.844749');

INSERT INTO django_migrations VALUES(11,'auth','0006_require_contenttypes_0002','2024-01-18 23:21:14.847250');

INSERT INTO django_migrations VALUES(12,'auth','0007_alter_validators_add_error_messages','2024-01-18 23:21:14.853741');

INSERT INTO django_migrations VALUES(13,'auth','0008_alter_user_username_max_length','2024-01-18 23:21:14.861241');

INSERT INTO django_migrations VALUES(14,'auth','0009_alter_user_last_name_max_length','2024-01-18 23:21:14.869201');

INSERT INTO django_migrations VALUES(15,'auth','0010_alter_group_name_max_length','2024-01-18 23:21:14.878184');

INSERT INTO django_migrations VALUES(16,'auth','0011_update_proxy_permissions','2024-01-18 23:21:14.884187');

INSERT INTO django_migrations VALUES(17,'auth','0012_alter_user_first_name_max_length','2024-01-18 23:21:14.893046');

INSERT INTO django_migrations VALUES(18,'sessions','0001_initial','2024-01-18 23:21:14.900039');

INSERT INTO django_migrations VALUES(19,'posts','0001_initial','2024-01-18 23:22:56.328630');

INSERT INTO django_migrations VALUES(20,'posts','0002_post_banner','2024-02-15 19:42:10.946828');

INSERT INTO django_migrations VALUES(21,'posts','0003_post_author','2024-03-20 22:28:31.868991');

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

INSERT INTO django_admin_log VALUES(1,'1','My First Post!',2,'[{"changed": {"fields": ["Body", "Slug"]}}]',7,1,'2024-01-25 21:47:17.684730');

INSERT INTO django_admin_log VALUES(2,'3','My Elusive 3rd post',1,'[{"added": {}}]',7,1,'2024-01-25 21:47:45.710404');

INSERT INTO django_admin_log VALUES(3,'1','My First Post!',2,'[{"changed": {"fields": ["Slug"]}}]',7,1,'2024-02-08 15:20:09.380159');

INSERT INTO django_admin_log VALUES(4,'2','My 2nd Post',2,'[{"changed": {"fields": ["Body", "Slug"]}}]',7,1,'2024-02-08 15:20:26.791115');

INSERT INTO django_admin_log VALUES(5,'3','My Elusive 3rd post',2,'[{"changed": {"fields": ["Slug"]}}]',7,1,'2024-02-08 15:20:38.830304');

INSERT INTO django_admin_log VALUES(6,'1','My First Post!',2,'[{"changed": {"fields": ["Banner"]}}]',7,1,'2024-02-15 19:44:50.896276');

INSERT INTO django_admin_log VALUES(7,'2','My 2nd Post',2,'[{"changed": {"fields": ["Banner"]}}]',7,1,'2024-02-15 19:44:58.549734');

INSERT INTO django_admin_log VALUES(8,'3','My Elusive 3rd post',2,'[]',7,1,'2024-02-15 19:45:04.274735');

INSERT INTO django_admin_log VALUES(9,'4','Ready for Vacation!',1,'[{"added": {}}]',7,1,'2024-02-15 19:45:28.670450');

INSERT INTO django_admin_log VALUES(10,'4','Ready for Vacation!',3,'',7,1,'2024-03-20 22:24:15.463489');

INSERT INTO django_admin_log VALUES(11,'3','My Elusive 3rd post',3,'',7,1,'2024-03-20 22:24:15.467486');

INSERT INTO django_admin_log VALUES(12,'2','My 2nd Post',3,'',7,1,'2024-03-20 22:24:15.472002');

INSERT INTO django_admin_log VALUES(13,'1','My First Post!',3,'',7,1,'2024-03-20 22:24:15.474514');

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,'posts','post');

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_post','Can add post');

INSERT INTO auth_permission VALUES(26,7,'change_post','Can change post');

INSERT INTO auth_permission VALUES(27,7,'delete_post','Can delete post');

INSERT INTO auth_permission VALUES(28,7,'view_post','Can view post');

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

INSERT INTO auth_user VALUES(1,'pbkdf2_sha256$720000$FzaDVnWKPSJdRQ2rGZBOmw$BGUvLhn02dhNiY+RsDxETu+fNaVihQ/W4r1+G2W6glk=','2024-03-20 22:17:11.587533',1,'dave','','',1,1,'2024-01-25 21:41:56.898813','');

INSERT INTO auth_user VALUES(2,'pbkdf2_sha256$720000$r6Gfmqgh0Vx413qxTwmYev$LxHxjwnW7uuUQiVPeyDtxmbps1hXZtqQ5Yn1lw94Zus=',NULL,0,'Tony','','',0,1,'2024-02-25 16:40:33.983376','');

INSERT INTO auth_user VALUES(3,'pbkdf2_sha256$720000$QrIOWY8Uei1wOr1UBIu9hJ$pB96IaQVwnUnPcqkJp9gyetp5aV78shyTG3HS1eMW3s=','2024-03-07 23:55:13.922109',0,'Jim','','',0,1,'2024-03-07 23:55:13.451412','');

INSERT INTO auth_user VALUES(4,'pbkdf2_sha256$720000$b839hJRFjQWINzaRXy9CSo$9N4CO3wPiiSsn/fkS1LESmUKCLQ9bXkg+pWApFim+18=','2024-03-20 22:33:17.631221',0,'mike','','',0,1,'2024-03-20 22:33:17.163821','');

INSERT INTO auth_user VALUES(5,'pbkdf2_sha256$720000$C8HbUUrNxTYxOCRPAm9X7K$UZc/bZG92BITA+jXLKkjE/fP/7i+zcB6N1M/QMRJsq8=','2024-05-19 10:21:11.930046',0,'Anh','','',0,1,'2024-05-19 03:20:31.316956','');

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

INSERT INTO django_session VALUES('woyrclh64fbnw15dab4zfqha2ufpthya','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1rT7Uo:YFwUq7uwfl0hbY-FPQ3kROJBuwEOpcHc1B8YRQfGLng','2024-02-08 21:42:50.536470');

INSERT INTO django_session VALUES('a6xhz1jp8gqaa2uwv01xesjh5qgmo90u','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1rY6Bb:gX8mlMSJ5epkQahr5tFHHvg7nwdX-JcW4vee32_JPVw','2024-02-22 15:19:35.399600');

INSERT INTO django_session VALUES('p46sfjxc2rv6rudzmycaxg0sb5lkqkii','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1raheV:ksEN9oJbEIw0cS0C5BCfBosUmz5eXS6gPzw4s3Ysvag','2024-02-29 19:44:11.537439');

INSERT INTO django_session VALUES('mp27jk0mpm9majffupauy24x86fvm0p0','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1reHZn:GTPq7EoEeyKTeKeIQq885xiEAw9unZasK32T8-B8N38','2024-03-10 16:42:07.672073');

INSERT INTO django_session VALUES('3xpw9kgh23oi6wcukfnsg4xygxov9xxy','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1riNaR:YHV3S4TbJYY0yplh2t6iBSw3BcRP7-mL1irh03kwah8','2024-03-21 23:55:43.605491');

INSERT INTO django_session VALUES('srslnzwxor183m4a7eipaslk76c8l5ob','.eJxVjDEOwjAMRe-SGUUpxLHDyM4ZKsdxSAG1UtNOiLtDpQ6w_vfef5me16X2a9O5H7I5m84cfrfE8tBxA_nO422yMo3LPCS7KXanzV6nrM_L7v4dVG71W1MswJEERDyxeFEhIKcphJLRdYoYFIF8pBMcM7sSCAE9SUSv4Mz7A-yZN3w:1rkOEu:CQhEuRnWNyR0AJeP40D1bw-Eoev-LnqSno2ADpy6vZc','2024-03-27 13:01:48.809252');

INSERT INTO django_session VALUES('ba31j99jvwkseua9wvbok8q6i0x226xm','.eJxVjEEOwiAQRe_C2hCklAGX7nsGMsCMVA0kpV0Z765NutDtf-_9lwi4rSVsnZYwZ3ERRpx-t4jpQXUH-Y711mRqdV3mKHdFHrTLqWV6Xg_376BgL9_akrZoXdTIHtgoQ2zIQxyUJccpAoHjYaTR66TOANZYT2Qcotd6YBLvD-z5N_4:1rn4Un:Kh1gLgnQOllrXatjTWi2VArEO6QGOuJx4EdyLcjd3UY','2024-04-03 22:33:17.633732');

INSERT INTO django_session VALUES('lsy9nixxa7gtth98omzs40wuxanenlg8','e30:1s8dVI:5RFrEmpj_TwNvrzFwGqS2GqLKi6ePhEbJ5cjl3RB2B8','2024-06-02 10:10:56.520032');

INSERT INTO django_session VALUES('pehwqi5gqr1fbkxmnimyzkk7fxlyivdo','e30:1s8dWK:XKn1BMWt73k6eh0B32Vx0fAQDEhO0Zu_5smDvPlfa08','2024-06-02 10:12:00.914938');

INSERT INTO django_session VALUES('zkwox5onplo6a68h5ubj9xiswekjoirh','e30:1s8daw:mTPttHi18XNcKEBoU0n4c99vIbiEqjTBdbv8pfX9QWc','2024-06-02 10:16:46.745901');

INSERT INTO django_session VALUES('bi58c60t86snikgsyuip9ugrbwi3lutm','.eJxVjEEOwiAQRe_C2hCgQKlL956BDDOMVA0kpV0Z765NutDtf-_9l4iwrSVuPS9xJnEWTpx-twT4yHUHdId6axJbXZc5yV2RB-3y2ig_L4f7d1Cgl2-NmsPAyDTQ4DmEcbTglFMJEivCyQOTZmM1M6gJbSZDxqLXPiSwXon3Bw4FOL0:1s8dfD:z2mY_JnhSuYZK9f1eywOgnwSclnNG87MFmtUpYU78fU','2024-06-02 10:21:11.934058');

CREATE TABLE IF NOT EXISTS "posts_post" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(75) NOT NULL, "body" text NOT NULL, "slug" varchar(50) NOT NULL, "date" datetime NOT NULL, "banner" varchar(100) NOT NULL, "author_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED);

INSERT INTO posts_post VALUES(1,'test post','test post','test-post','2024-03-20 22:32:51.872976','beach-chair_N8vOAhO.png',1);

INSERT INTO posts_post VALUES(2,'Mike''s post','Mike made a post','mike-post','2024-03-20 22:33:38.693723','fallback.png',4);

CREATE TABLE chat(chat_id int PRIMARY KEY,username varchar(150),user_chat varchar(2000),bot_chat varchar(2000),CONSTRAINT fk_column FOREIGN KEY (username) REFERENCES auth_user(username));

DELETE FROM sqlite_sequence;

INSERT INTO sqlite_sequence VALUES('django_migrations',21);

INSERT INTO sqlite_sequence VALUES('django_admin_log',13);

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',5);

INSERT INTO sqlite_sequence VALUES('posts_post',2);

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

CREATE INDEX "posts_post_slug_6e9097e5" ON "posts_post" ("slug");

CREATE INDEX "posts_post_author_id_fe5487bf" ON "posts_post" ("author_id");

COMMIT;