API tools faq
paste
Guest User

Untitled

a guest
May 16th, 2018
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.35 KB | None | 0 0
raw download clone embed print report
  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;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!