daily pastebin goal
20%
SHARE
TWEET

Untitled

a guest May 16th, 2018 95 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN TRANSACTION;
  2. CREATE TABLE IF NOT EXISTS `django_session` (
  3.     `session_key`   varchar ( 40 ) NOT NULL,
  4.     `session_data`  text NOT NULL,
  5.     `expire_date`   datetime NOT NULL,
  6.     PRIMARY KEY(`session_key`)
  7. );
  8. INSERT INTO `django_session` (session_key,session_data,expire_date) VALUES ('z8eecz2ixi49tukpubi32d08r15kgdi3','OTRlY2JlYTc4YjIyZTIyYjhmZWI5MjAzOTFiMDQ2N2U3ZjJmOTZkMTp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiI4NjQ3YTYxNTIyY2NiNzA3NzRmZDBkZjIxODE4MWI0ZDM1OTBkZjYxIn0=','2018-02-23 01:21:38.484591');
  9. CREATE TABLE IF NOT EXISTS `django_migrations` (
  10.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  11.     `app`   varchar ( 255 ) NOT NULL,
  12.     `name`  varchar ( 255 ) NOT NULL,
  13.     `applied`   datetime NOT NULL
  14. );
  15. INSERT INTO `django_migrations` (id,app,name,applied) VALUES (1,'contenttypes','0001_initial','2018-02-08 14:15:18.395097'),
  16.  (2,'auth','0001_initial','2018-02-08 14:15:18.417962'),
  17.  (3,'admin','0001_initial','2018-02-08 14:15:18.439607'),
  18.  (4,'admin','0002_logentry_remove_auto_add','2018-02-08 14:15:18.457078'),
  19.  (5,'contenttypes','0002_remove_content_type_name','2018-02-08 14:15:18.500014'),
  20.  (6,'auth','0002_alter_permission_name_max_length','2018-02-08 14:15:18.506723'),
  21.  (7,'auth','0003_alter_user_email_max_length','2018-02-08 14:15:18.525891'),
  22.  (8,'auth','0004_alter_user_username_opts','2018-02-08 14:15:18.559332'),
  23.  (9,'auth','0005_alter_user_last_login_null','2018-02-08 14:15:18.606067'),
  24.  (10,'auth','0006_require_contenttypes_0002','2018-02-08 14:15:18.621753'),
  25.  (11,'auth','0007_alter_validators_add_error_messages','2018-02-08 14:15:18.661542'),
  26.  (12,'auth','0008_alter_user_username_max_length','2018-02-08 14:15:18.706357'),
  27.  (13,'auth','0009_alter_user_last_name_max_length','2018-02-08 14:15:18.719405'),
  28.  (14,'sessions','0001_initial','2018-02-08 14:15:18.724775'),
  29.  (15,'api','0001_initial','2018-02-09 01:56:03.826075');
  30. CREATE TABLE IF NOT EXISTS `django_content_type` (
  31.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  32.     `app_label` varchar ( 100 ) NOT NULL,
  33.     `model` varchar ( 100 ) NOT NULL
  34. );
  35. INSERT INTO `django_content_type` (id,app_label,model) VALUES (1,'admin','logentry'),
  36.  (2,'auth','permission'),
  37.  (3,'auth','group'),
  38.  (4,'auth','user'),
  39.  (5,'contenttypes','contenttype'),
  40.  (6,'sessions','session'),
  41.  (7,'api','bucketlist');
  42. CREATE TABLE IF NOT EXISTS `django_admin_log` (
  43.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  44.     `object_id` text,
  45.     `object_repr`   varchar ( 200 ) NOT NULL,
  46.     `action_flag`   smallint unsigned NOT NULL,
  47.     `change_message`    text NOT NULL,
  48.     `content_type_id`   integer,
  49.     `user_id`   integer NOT NULL,
  50.     `action_time`   datetime NOT NULL,
  51.     FOREIGN KEY(`content_type_id`) REFERENCES `django_content_type`(`id`) DEFERRABLE INITIALLY DEFERRED,
  52.     FOREIGN KEY(`user_id`) REFERENCES `auth_user`(`id`) DEFERRABLE INITIALLY DEFERRED
  53. );
  54. CREATE TABLE IF NOT EXISTS `auth_user_user_permissions` (
  55.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  56.     `user_id`   integer NOT NULL,
  57.     `permission_id` integer NOT NULL,
  58.     FOREIGN KEY(`permission_id`) REFERENCES `auth_permission`(`id`) DEFERRABLE INITIALLY DEFERRED,
  59.     FOREIGN KEY(`user_id`) REFERENCES `auth_user`(`id`) DEFERRABLE INITIALLY DEFERRED
  60. );
  61. CREATE TABLE IF NOT EXISTS `auth_user_groups` (
  62.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  63.     `user_id`   integer NOT NULL,
  64.     `group_id`  integer NOT NULL,
  65.     FOREIGN KEY(`user_id`) REFERENCES `auth_user`(`id`) DEFERRABLE INITIALLY DEFERRED,
  66.     FOREIGN KEY(`group_id`) REFERENCES `auth_group`(`id`) DEFERRABLE INITIALLY DEFERRED
  67. );
  68. CREATE TABLE IF NOT EXISTS `auth_user` (
  69.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  70.     `password`  varchar ( 128 ) NOT NULL,
  71.     `last_login`    datetime,
  72.     `is_superuser`  bool NOT NULL,
  73.     `username`  varchar ( 150 ) NOT NULL UNIQUE,
  74.     `first_name`    varchar ( 30 ) NOT NULL,
  75.     `email` varchar ( 254 ) NOT NULL,
  76.     `is_staff`  bool NOT NULL,
  77.     `is_active` bool NOT NULL,
  78.     `date_joined`   datetime NOT NULL,
  79.     `last_name` varchar ( 150 ) NOT NULL
  80. );
  81. INSERT INTO `auth_user` (id,password,last_login,is_superuser,username,first_name,email,is_staff,is_active,date_joined,last_name) VALUES (1,'pbkdf2_sha256$100000$wcn27Rndxv3W$N/RU/iGlhn2rJVLOuyIPA/K2Nb5ZqhYbQH6Tw5Do2JM=','2018-02-09 01:21:38.482265',1,'prongbang','','prongbang@gmail.com',1,1,'2018-02-09 01:20:44.577578','');
  82. CREATE TABLE IF NOT EXISTS `auth_permission` (
  83.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  84.     `content_type_id`   integer NOT NULL,
  85.     `codename`  varchar ( 100 ) NOT NULL,
  86.     `name`  varchar ( 255 ) NOT NULL,
  87.     FOREIGN KEY(`content_type_id`) REFERENCES `django_content_type`(`id`) DEFERRABLE INITIALLY DEFERRED
  88. );
  89. INSERT INTO `auth_permission` (id,content_type_id,codename,name) VALUES (1,1,'add_logentry','Can add log entry'),
  90.  (2,1,'change_logentry','Can change log entry'),
  91.  (3,1,'delete_logentry','Can delete log entry'),
  92.  (4,2,'add_permission','Can add permission'),
  93.  (5,2,'change_permission','Can change permission'),
  94.  (6,2,'delete_permission','Can delete permission'),
  95.  (7,3,'add_group','Can add group'),
  96.  (8,3,'change_group','Can change group'),
  97.  (9,3,'delete_group','Can delete group'),
  98.  (10,4,'add_user','Can add user'),
  99.  (11,4,'change_user','Can change user'),
  100.  (12,4,'delete_user','Can delete user'),
  101.  (13,5,'add_contenttype','Can add content type'),
  102.  (14,5,'change_contenttype','Can change content type'),
  103.  (15,5,'delete_contenttype','Can delete content type'),
  104.  (16,6,'add_session','Can add session'),
  105.  (17,6,'change_session','Can change session'),
  106.  (18,6,'delete_session','Can delete session'),
  107.  (19,7,'add_bucketlist','Can add bucketlist'),
  108.  (20,7,'change_bucketlist','Can change bucketlist'),
  109.  (21,7,'delete_bucketlist','Can delete bucketlist');
  110. CREATE TABLE IF NOT EXISTS `auth_group_permissions` (
  111.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  112.     `group_id`  integer NOT NULL,
  113.     `permission_id` integer NOT NULL,
  114.     FOREIGN KEY(`permission_id`) REFERENCES `auth_permission`(`id`) DEFERRABLE INITIALLY DEFERRED,
  115.     FOREIGN KEY(`group_id`) REFERENCES `auth_group`(`id`) DEFERRABLE INITIALLY DEFERRED
  116. );
  117. CREATE TABLE IF NOT EXISTS `auth_group` (
  118.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  119.     `name`  varchar ( 80 ) NOT NULL UNIQUE
  120. );
  121. CREATE TABLE IF NOT EXISTS `api_bucketlist` (
  122.     `id`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  123.     `name`  varchar ( 255 ) NOT NULL UNIQUE,
  124.     `date_created`  datetime NOT NULL,
  125.     `date_modified` datetime NOT NULL
  126. );
  127. INSERT INTO `api_bucketlist` (id,name,date_created,date_modified) VALUES (1,'ddd','2018-02-09 01:56:48.190269','2018-02-09 01:56:48.190331'),
  128.  (2,'ThaiHalal','2018-02-09 02:21:45.961327','2018-02-09 02:21:45.961391'),
  129.  (3,'Test','2018-02-09 02:22:14.049211','2018-02-09 02:22:14.049252');
  130. CREATE INDEX IF NOT EXISTS `django_session_expire_date_a5c62663` ON `django_session` (
  131.     `expire_date`
  132. );
  133. CREATE UNIQUE INDEX IF NOT EXISTS `django_content_type_app_label_model_76bd3d3b_uniq` ON `django_content_type` (
  134.     `app_label`,
  135.     `model`
  136. );
  137. CREATE INDEX IF NOT EXISTS `django_admin_log_user_id_c564eba6` ON `django_admin_log` (
  138.     `user_id`
  139. );
  140. CREATE INDEX IF NOT EXISTS `django_admin_log_content_type_id_c4bce8eb` ON `django_admin_log` (
  141.     `content_type_id`
  142. );
  143. CREATE UNIQUE INDEX IF NOT EXISTS `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` ON `auth_user_user_permissions` (
  144.     `user_id`,
  145.     `permission_id`
  146. );
  147. CREATE INDEX IF NOT EXISTS `auth_user_user_permissions_user_id_a95ead1b` ON `auth_user_user_permissions` (
  148.     `user_id`
  149. );
  150. CREATE INDEX IF NOT EXISTS `auth_user_user_permissions_permission_id_1fbb5f2c` ON `auth_user_user_permissions` (
  151.     `permission_id`
  152. );
  153. CREATE UNIQUE INDEX IF NOT EXISTS `auth_user_groups_user_id_group_id_94350c0c_uniq` ON `auth_user_groups` (
  154.     `user_id`,
  155.     `group_id`
  156. );
  157. CREATE INDEX IF NOT EXISTS `auth_user_groups_user_id_6a12ed8b` ON `auth_user_groups` (
  158.     `user_id`
  159. );
  160. CREATE INDEX IF NOT EXISTS `auth_user_groups_group_id_97559544` ON `auth_user_groups` (
  161.     `group_id`
  162. );
  163. CREATE UNIQUE INDEX IF NOT EXISTS `auth_permission_content_type_id_codename_01ab375a_uniq` ON `auth_permission` (
  164.     `content_type_id`,
  165.     `codename`
  166. );
  167. CREATE INDEX IF NOT EXISTS `auth_permission_content_type_id_2f476e4b` ON `auth_permission` (
  168.     `content_type_id`
  169. );
  170. CREATE INDEX IF NOT EXISTS `auth_group_permissions_permission_id_84c5c92e` ON `auth_group_permissions` (
  171.     `permission_id`
  172. );
  173. CREATE UNIQUE INDEX IF NOT EXISTS `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` ON `auth_group_permissions` (
  174.     `group_id`,
  175.     `permission_id`
  176. );
  177. CREATE INDEX IF NOT EXISTS `auth_group_permissions_group_id_b120cbf9` ON `auth_group_permissions` (
  178.     `group_id`
  179. );
  180. COMMIT;
RAW Paste Data
Top