github.com/team-ide/go-dialect@v1.9.20/vitess/sqlparser/testdata/django_queries.txt (about)

     1  set autocommit=1
     2  SELECT @@SQL_AUTO_IS_NULL
     3  SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
     4  SELECT @@sql_mode
     5  SHOW FULL TABLES
     6  SHOW FULL TABLES
     7  SHOW FULL TABLES
     8  CREATE TABLE `django_migrations` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL)
     9  SELECT engine FROM information_schema.tables WHERE table_name = 'django_migrations'
    10  SELECT engine FROM information_schema.tables WHERE table_name = 'django_migrations'
    11  SELECT engine FROM information_schema.tables WHERE table_name = 'django_migrations'
    12  SELECT engine FROM information_schema.tables WHERE table_name = 'django_migrations'
    13  CREATE TABLE `accounts_userprofile` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `password` varchar(128) NOT NULL, `last_login` datetime(6) NULL, `email` varchar(255) NOT NULL UNIQUE, `first_name` varchar(255) NULL, `last_name` varchar(255) NULL, `active` bool NOT NULL, `staff` bool NOT NULL, `admin` bool NOT NULL, `timestamp` datetime(6) NOT NULL)
    14  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    15  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    16  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    17  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    18  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    19  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    20  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    21  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    22  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    23  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    24  SHOW FULL TABLES
    25  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('accounts', '0001_initial', '2019-09-11 20:08:24.240837')
    26  ALTER TABLE `accounts_userprofile` ADD COLUMN `uid` varchar(8) DEFAULT 'bfghjkl' NOT NULL UNIQUE
    27  ALTER TABLE `accounts_userprofile` ALTER COLUMN `uid` DROP DEFAULT
    28  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    29  SHOW FULL TABLES
    30  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('accounts', '0002_userprofile_uid', '2019-09-11 20:08:24.390839')
    31  ALTER TABLE `accounts_userprofile` ADD COLUMN `bio` varchar(255) NULL
    32  SELECT engine FROM information_schema.tables WHERE table_name = 'accounts_userprofile'
    33  SHOW FULL TABLES
    34  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('accounts', '0003_userprofile_bio', '2019-09-11 20:08:24.521784')
    35  CREATE TABLE `django_content_type` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(100) NOT NULL, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL)
    36  SELECT engine FROM information_schema.tables WHERE table_name = 'django_content_type'
    37  SELECT engine FROM information_schema.tables WHERE table_name = 'django_content_type'
    38  SELECT engine FROM information_schema.tables WHERE table_name = 'django_content_type'
    39  SELECT engine FROM information_schema.tables WHERE table_name = 'django_content_type'
    40  ALTER TABLE `django_content_type` ADD CONSTRAINT `django_content_type_app_label_model_76bd3d3b_uniq` UNIQUE (`app_label`, `model`)
    41  SHOW FULL TABLES
    42  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('contenttypes', '0001_initial', '2019-09-11 20:08:24.640638')
    43  CREATE TABLE `django_admin_log` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `action_time` datetime(6) NOT NULL, `object_id` longtext NULL, `object_repr` varchar(200) NOT NULL, `action_flag` smallint UNSIGNED NOT NULL, `change_message` longtext NOT NULL, `content_type_id` integer NULL, `user_id` integer NOT NULL)
    44  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    45  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    46  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    47  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    48  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    49  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    50  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    51  SELECT engine FROM information_schema.tables WHERE table_name = 'django_admin_log'
    52  SHOW FULL TABLES
    53  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('admin', '0001_initial', '2019-09-11 20:08:24.711570')
    54  ALTER TABLE `django_admin_log` ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
    55  ALTER TABLE `django_admin_log` ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_accounts_userprofile_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_userprofile` (`id`)
    56  SHOW FULL TABLES
    57  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('admin', '0002_logentry_remove_auto_add', '2019-09-11 20:08:24.993999')
    58  SHOW FULL TABLES
    59  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('admin', '0003_logentry_add_action_flag_choices', '2019-09-11 20:08:25.005500')
    60  ALTER TABLE `django_content_type` MODIFY `name` varchar(100) NULL
    61  set autocommit=0
    62  commit
    63  set autocommit=1
    64  ALTER TABLE `django_content_type` DROP COLUMN `name`
    65  SHOW FULL TABLES
    66  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('contenttypes', '0002_remove_content_type_name', '2019-09-11 20:08:25.195532')
    67  CREATE TABLE `auth_permission` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(50) NOT NULL, `content_type_id` integer NOT NULL, `codename` varchar(100) NOT NULL)
    68  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_permission'
    69  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_permission'
    70  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_permission'
    71  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_permission'
    72  CREATE TABLE `auth_group` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(80) NOT NULL UNIQUE)
    73  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_group'
    74  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_group'
    75  CREATE TABLE `auth_group_permissions` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `group_id` integer NOT NULL, `permission_id` integer NOT NULL)
    76  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_group_permissions'
    77  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_group_permissions'
    78  SELECT engine FROM information_schema.tables WHERE table_name = 'auth_group_permissions'
    79  SHOW FULL TABLES
    80  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0001_initial', '2019-09-11 20:08:25.380981')
    81  ALTER TABLE `auth_permission` ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
    82  ALTER TABLE `auth_permission` ADD CONSTRAINT `auth_permission_content_type_id_codename_01ab375a_uniq` UNIQUE (`content_type_id`, `codename`)
    83  ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
    84  ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
    85  ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` UNIQUE (`group_id`, `permission_id`)
    86  ALTER TABLE `auth_permission` MODIFY `name` varchar(255) NOT NULL
    87  SHOW FULL TABLES
    88  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0002_alter_permission_name_max_length', '2019-09-11 20:08:25.927116')
    89  SHOW FULL TABLES
    90  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0003_alter_user_email_max_length', '2019-09-11 20:08:25.944751')
    91  SHOW FULL TABLES
    92  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0004_alter_user_username_opts', '2019-09-11 20:08:25.954957')
    93  SHOW FULL TABLES
    94  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0005_alter_user_last_login_null', '2019-09-11 20:08:25.966743')
    95  SHOW FULL TABLES
    96  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0006_require_contenttypes_0002', '2019-09-11 20:08:25.970363')
    97  SHOW FULL TABLES
    98  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0007_alter_validators_add_error_messages', '2019-09-11 20:08:25.977706')
    99  SHOW FULL TABLES
   100  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0008_alter_user_username_max_length', '2019-09-11 20:08:25.988202')
   101  SHOW FULL TABLES
   102  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0009_alter_user_last_name_max_length', '2019-09-11 20:08:25.996464')
   103  ALTER TABLE `auth_group` MODIFY `name` varchar(150) NOT NULL
   104  SHOW FULL TABLES
   105  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0010_alter_group_name_max_length', '2019-09-11 20:08:26.006057')
   106  set autocommit=0
   107  commit
   108  set autocommit=1
   109  SHOW FULL TABLES
   110  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('auth', '0011_update_proxy_permissions', '2019-09-11 20:08:26.019693')
   111  CREATE TABLE `post_post` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `title` varchar(250) NOT NULL, `body` longtext NOT NULL, `slug` varchar(8) NOT NULL UNIQUE, `pub_date` datetime(6) NOT NULL, `thumbnail` varchar(100) NOT NULL, `author_id` integer NOT NULL)
   112  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   113  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   114  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   115  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   116  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   117  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   118  SELECT engine FROM information_schema.tables WHERE table_name = 'post_post'
   119  SHOW FULL TABLES
   120  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('post', '0001_initial', '2019-09-11 20:08:26.078601')
   121  ALTER TABLE `post_post` ADD CONSTRAINT `post_post_author_id_99d134d5_fk_accounts_userprofile_id` FOREIGN KEY (`author_id`) REFERENCES `accounts_userprofile` (`id`)
   122  SHOW FULL TABLES
   123  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('post', '0002_auto_20180225_1142', '2019-09-11 20:08:26.223293')
   124  SHOW FULL TABLES
   125  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('post', '0003_auto_20180225_1154', '2019-09-11 20:08:26.231490')
   126  SHOW FULL TABLES
   127  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('post', '0004_auto_20180225_1256', '2019-09-11 20:08:26.241872')
   128  CREATE TABLE `bookmark_post` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `obj_id` integer NOT NULL, `user_id` integer NOT NULL)
   129  SELECT engine FROM information_schema.tables WHERE table_name = 'bookmark_post'
   130  SELECT engine FROM information_schema.tables WHERE table_name = 'bookmark_post'
   131  SELECT engine FROM information_schema.tables WHERE table_name = 'bookmark_post'
   132  SHOW FULL TABLES
   133  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('bookmarks', '0001_initial', '2019-09-11 20:08:26.303419')
   134  ALTER TABLE `bookmark_post` ADD CONSTRAINT `bookmark_post_obj_id_cff442ed_fk_post_post_id` FOREIGN KEY (`obj_id`) REFERENCES `post_post` (`id`)
   135  ALTER TABLE `bookmark_post` ADD CONSTRAINT `bookmark_post_user_id_ecbdae36_fk_accounts_userprofile_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_userprofile` (`id`)
   136  SELECT kc.`constraint_name`, kc.`column_name`,                 kc.`referenced_table_name`, kc.`referenced_column_name`             FROM information_schema.key_column_usage AS kc             WHERE                 kc.table_schema = DATABASE() AND                 kc.table_name = 'bookmark_post'             ORDER BY kc.`ordinal_position`
   137  SELECT c.constraint_name, c.constraint_type             FROM information_schema.table_constraints AS c             WHERE                 c.table_schema = DATABASE() AND                 c.table_name = 'bookmark_post'
   138  SHOW INDEX FROM `bookmark_post`
   139  ALTER TABLE `bookmark_post` DROP FOREIGN KEY `bookmark_post_obj_id_cff442ed_fk_post_post_id`
   140  ALTER TABLE `bookmark_post` ADD CONSTRAINT `bookmark_post_obj_id_cff442ed_fk_post_post_id` FOREIGN KEY (`obj_id`) REFERENCES `post_post` (`id`)
   141  SHOW FULL TABLES
   142  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('bookmarks', '0002_auto_20180307_0102', '2019-09-11 20:08:26.751223')
   143  CREATE TABLE `comments_comment` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `object_id` integer UNSIGNED NOT NULL, `content` longtext NOT NULL, `timestamp` datetime(6) NOT NULL, `content_type_id` integer NOT NULL, `user_id` integer NOT NULL)
   144  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   145  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   146  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   147  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   148  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   149  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   150  SHOW FULL TABLES
   151  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('comments', '0001_initial', '2019-09-11 20:08:26.827533')
   152  ALTER TABLE `comments_comment` ADD CONSTRAINT `comments_comment_content_type_id_72fd5dbe_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
   153  ALTER TABLE `comments_comment` ADD CONSTRAINT `comments_comment_user_id_a1db4881_fk_accounts_userprofile_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_userprofile` (`id`)
   154  ALTER TABLE `comments_comment` ADD COLUMN `parent_comment_id` integer NULL
   155  SELECT engine FROM information_schema.tables WHERE table_name = 'comments_comment'
   156  SHOW FULL TABLES
   157  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('comments', '0002_comment_parent_comment', '2019-09-11 20:08:27.232388')
   158  ALTER TABLE `comments_comment` ADD CONSTRAINT `comments_comment_parent_comment_id_71289d4a_fk_comments_` FOREIGN KEY (`parent_comment_id`) REFERENCES `comments_comment` (`id`)
   159  SHOW FULL TABLES
   160  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('comments', '0003_auto_20180227_2159', '2019-09-11 20:08:27.408413')
   161  CREATE TABLE `likesdislikes_likedislike` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `vote` smallint NOT NULL, `object_id` integer UNSIGNED NOT NULL, `content_type_id` integer NOT NULL, `user_id` integer NOT NULL)
   162  SELECT engine FROM information_schema.tables WHERE table_name = 'likesdislikes_likedislike'
   163  SELECT engine FROM information_schema.tables WHERE table_name = 'likesdislikes_likedislike'
   164  SELECT engine FROM information_schema.tables WHERE table_name = 'likesdislikes_likedislike'
   165  SELECT engine FROM information_schema.tables WHERE table_name = 'likesdislikes_likedislike'
   166  SELECT engine FROM information_schema.tables WHERE table_name = 'likesdislikes_likedislike'
   167  SHOW FULL TABLES
   168  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('likesdislikes', '0001_initial', '2019-09-11 20:08:27.471337')
   169  ALTER TABLE `likesdislikes_likedislike` ADD CONSTRAINT `likesdislikes_likedi_content_type_id_1bd751d8_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
   170  ALTER TABLE `likesdislikes_likedislike` ADD CONSTRAINT `likesdislikes_likedi_user_id_fbedd04e_fk_accounts_` FOREIGN KEY (`user_id`) REFERENCES `accounts_userprofile` (`id`)
   171  CREATE TABLE `django_session` (`session_key` varchar(40) NOT NULL PRIMARY KEY, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL)
   172  SELECT engine FROM information_schema.tables WHERE table_name = 'django_session'
   173  SELECT engine FROM information_schema.tables WHERE table_name = 'django_session'
   174  SELECT engine FROM information_schema.tables WHERE table_name = 'django_session'
   175  SHOW FULL TABLES
   176  INSERT INTO `django_migrations` (`app`, `name`, `applied`) VALUES ('sessions', '0001_initial', '2019-09-11 20:08:27.790749')
   177  CREATE INDEX `django_session_expire_date_a5c62663` ON `django_session` (`expire_date`)
   178  SHOW FULL TABLES
   179  SELECT `django_migrations`.`app`, `django_migrations`.`name` FROM `django_migrations`
   180  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'admin'
   181  set autocommit=0
   182  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('admin', 'logentry')
   183  commit
   184  set autocommit=1
   185  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'admin' AND `django_content_type`.`model` = 'logentry')
   186  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (1) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   187  set autocommit=0
   188  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add log entry', 1, 'add_logentry'), ('Can change log entry', 1, 'change_logentry'), ('Can delete log entry', 1, 'delete_logentry'), ('Can view log entry', 1, 'view_logentry')
   189  commit
   190  set autocommit=1
   191  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'admin'
   192  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'auth'
   193  set autocommit=0
   194  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('auth', 'permission'), ('auth', 'group')
   195  commit
   196  set autocommit=1
   197  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'auth' AND `django_content_type`.`model` = 'permission')
   198  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'auth' AND `django_content_type`.`model` = 'group')
   199  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (2, 3) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   200  set autocommit=0
   201  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add permission', 2, 'add_permission'), ('Can change permission', 2, 'change_permission'), ('Can delete permission', 2, 'delete_permission'), ('Can view permission', 2, 'view_permission'), ('Can add group', 3, 'add_group'), ('Can change group', 3, 'change_group'), ('Can delete group', 3, 'delete_group'), ('Can view group', 3, 'view_group')
   202  commit
   203  set autocommit=1
   204  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'auth'
   205  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'contenttypes'
   206  set autocommit=0
   207  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('contenttypes', 'contenttype')
   208  commit
   209  set autocommit=1
   210  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'contenttypes' AND `django_content_type`.`model` = 'contenttype')
   211  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (4) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   212  set autocommit=0
   213  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add content type', 4, 'add_contenttype'), ('Can change content type', 4, 'change_contenttype'), ('Can delete content type', 4, 'delete_contenttype'), ('Can view content type', 4, 'view_contenttype')
   214  commit
   215  set autocommit=1
   216  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'contenttypes'
   217  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'sessions'
   218  set autocommit=0
   219  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('sessions', 'session')
   220  commit
   221  set autocommit=1
   222  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'sessions' AND `django_content_type`.`model` = 'session')
   223  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (5) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   224  set autocommit=0
   225  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add session', 5, 'add_session'), ('Can change session', 5, 'change_session'), ('Can delete session', 5, 'delete_session'), ('Can view session', 5, 'view_session')
   226  commit
   227  set autocommit=1
   228  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'sessions'
   229  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'post'
   230  set autocommit=0
   231  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('post', 'post')
   232  commit
   233  set autocommit=1
   234  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'post' AND `django_content_type`.`model` = 'post')
   235  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (6) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   236  set autocommit=0
   237  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add post', 6, 'add_post'), ('Can change post', 6, 'change_post'), ('Can delete post', 6, 'delete_post'), ('Can view post', 6, 'view_post')
   238  commit
   239  set autocommit=1
   240  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'post'
   241  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'accounts'
   242  set autocommit=0
   243  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('accounts', 'userprofile')
   244  commit
   245  set autocommit=1
   246  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'accounts' AND `django_content_type`.`model` = 'userprofile')
   247  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (7) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   248  set autocommit=0
   249  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add user profile', 7, 'add_userprofile'), ('Can change user profile', 7, 'change_userprofile'), ('Can delete user profile', 7, 'delete_userprofile'), ('Can view user profile', 7, 'view_userprofile')
   250  commit
   251  set autocommit=1
   252  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'accounts'
   253  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'comments'
   254  set autocommit=0
   255  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('comments', 'comment')
   256  commit
   257  set autocommit=1
   258  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'comments' AND `django_content_type`.`model` = 'comment')
   259  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (8) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   260  set autocommit=0
   261  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add comment', 8, 'add_comment'), ('Can change comment', 8, 'change_comment'), ('Can delete comment', 8, 'delete_comment'), ('Can view comment', 8, 'view_comment')
   262  commit
   263  set autocommit=1
   264  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'comments'
   265  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'likesdislikes'
   266  set autocommit=0
   267  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('likesdislikes', 'likedislike')
   268  commit
   269  set autocommit=1
   270  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'likesdislikes' AND `django_content_type`.`model` = 'likedislike')
   271  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (9) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   272  set autocommit=0
   273  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add like dislike', 9, 'add_likedislike'), ('Can change like dislike', 9, 'change_likedislike'), ('Can delete like dislike', 9, 'delete_likedislike'), ('Can view like dislike', 9, 'view_likedislike')
   274  commit
   275  set autocommit=1
   276  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'likesdislikes'
   277  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'bookmarks'
   278  set autocommit=0
   279  INSERT INTO `django_content_type` (`app_label`, `model`) VALUES ('bookmarks', 'bookmarkpost')
   280  commit
   281  set autocommit=1
   282  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`app_label` = 'bookmarks' AND `django_content_type`.`model` = 'bookmarkpost')
   283  SELECT `auth_permission`.`content_type_id`, `auth_permission`.`codename` FROM `auth_permission` INNER JOIN `django_content_type` ON (`auth_permission`.`content_type_id` = `django_content_type`.`id`) WHERE `auth_permission`.`content_type_id` IN (10) ORDER BY `django_content_type`.`app_label` ASC, `django_content_type`.`model` ASC, `auth_permission`.`codename` ASC
   284  set autocommit=0
   285  INSERT INTO `auth_permission` (`name`, `content_type_id`, `codename`) VALUES ('Can add bookmark post', 10, 'add_bookmarkpost'), ('Can change bookmark post', 10, 'change_bookmarkpost'), ('Can delete bookmark post', 10, 'delete_bookmarkpost'), ('Can view bookmark post', 10, 'view_bookmarkpost')
   286  commit
   287  set autocommit=1
   288  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'bookmarks'
   289  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'pagedown'
   290  SELECT `django_content_type`.`id`, `django_content_type`.`app_label`, `django_content_type`.`model` FROM `django_content_type` WHERE `django_content_type`.`app_label` = 'pagedown'