python基于django图书管理系统课程设计项目源码

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50721 Source Host : localhost:3306 Source Database : tesss1 Target Server Type : MYSQL Target Server Version : 50721 File Encoding : 65001 Date: 2023-06-26 21:40:27 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `auth_group` -- ---------------------------- DROP TABLE IF EXISTS `auth_group`; CREATE TABLE `auth_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group -- ---------------------------- -- ---------------------------- -- Table structure for `auth_group_permissions` -- ---------------------------- DROP TABLE IF EXISTS `auth_group_permissions`; CREATE TABLE `auth_group_permissions` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group_permissions -- ---------------------------- -- ---------------------------- -- Table structure for `auth_permission` -- ---------------------------- DROP TABLE IF EXISTS `auth_permission`; CREATE TABLE `auth_permission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `content_type_id` int(11) NOT NULL, `codename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`), CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_permission -- ---------------------------- INSERT INTO `auth_permission` VALUES ('1', 'Can add log entry', '1', 'add_logentry'); INSERT INTO `auth_permission` VALUES ('2', 'Can change log entry', '1', 'change_logentry'); INSERT INTO `auth_permission` VALUES ('3', 'Can delete log entry', '1', 'delete_logentry'); INSERT INTO `auth_permission` VALUES ('4', 'Can view log entry', '1', 'view_logentry'); INSERT INTO `auth_permission` VALUES ('5', 'Can add permission', '2', 'add_permission'); INSERT INTO `auth_permission` VALUES ('6', 'Can change permission', '2', 'change_permission'); INSERT INTO `auth_permission` VALUES ('7', 'Can delete permission', '2', 'delete_permission'); INSERT INTO `auth_permission` VALUES ('8', 'Can view permission', '2', 'view_permission'); INSERT INTO `auth_permission` VALUES ('9', 'Can add group', '3', 'add_group'); INSERT INTO `auth_permission` VALUES ('10', 'Can change group', '3', 'change_group'); INSERT INTO `auth_permission` VALUES ('11', 'Can delete group', '3', 'delete_group'); INSERT INTO `auth_permission` VALUES ('12', 'Can view group', '3', 'view_group'); INSERT INTO `auth_permission` VALUES ('13', 'Can add user', '4', 'add_user'); INSERT INTO `auth_permission` VALUES ('14', 'Can change user', '4', 'change_user'); INSERT INTO `auth_permission` VALUES ('15', 'Can delete user', '4', 'delete_user'); INSERT INTO `auth_permission` VALUES ('16', 'Can view user', '4', 'view_user'); INSERT INTO `auth_permission` VALUES ('17', 'Can add content type', '5', 'add_contenttype'); INSERT INTO `auth_permission` VALUES ('18', 'Can change content type', '5', 'change_contenttype'); INSERT INTO `auth_permission` VALUES ('19', 'Can delete content type', '5', 'delete_contenttype'); INSERT INTO `auth_permission` VALUES ('20', 'Can view content type', '5', 'view_contenttype'); INSERT INTO `auth_permission` VALUES ('21', 'Can add session', '6', 'add_session'); INSERT INTO `auth_permission` VALUES ('22', 'Can change session', '6', 'change_session'); INSERT INTO `auth_permission` VALUES ('23', 'Can delete session', '6', 'delete_session'); INSERT INTO `auth_permission` VALUES ('24', 'Can view session', '6', 'view_session'); INSERT INTO `auth_permission` VALUES ('25', 'Can add admin', '7', 'add_admin'); INSERT INTO `auth_permission` VALUES ('26', 'Can change admin', '7', 'change_admin'); INSERT INTO `auth_permission` VALUES ('27', 'Can delete admin', '7', 'delete_admin'); INSERT INTO `auth_permission` VALUES ('28', 'Can view admin', '7', 'view_admin'); INSERT INTO `auth_permission` VALUES ('29', 'Can add ele products', '8', 'add_eleproducts'); INSERT INTO `auth_permission` VALUES ('30', 'Can change ele products', '8', 'change_eleproducts'); INSERT INTO `auth_permission` VALUES ('31', 'Can delete ele products', '8', 'delete_eleproducts'); INSERT INTO `auth_permission` VALUES ('32', 'Can view ele products', '8', 'view_eleproducts'); INSERT INTO `auth_permission` VALUES ('33', 'Can add classname', '9', 'add_classname'); INSERT INTO `auth_permission` VALUES ('34', 'Can change classname', '9', 'change_classname'); INSERT INTO `auth_permission` VALUES ('35', 'Can delete classname', '9', 'delete_classname'); INSERT INTO `auth_permission` VALUES ('36', 'Can view classname', '9', 'view_classname'); INSERT INTO `auth_permission` VALUES ('37', 'Can add pinpai', '10', 'add_pinpai'); INSERT INTO `auth_permission` VALUES ('38', 'Can change pinpai', '10', 'change_pinpai'); INSERT INTO `auth_permission` VALUES ('39', 'Can delete pinpai', '10', 'delete_pinpai'); INSERT INTO `auth_permission` VALUES ('40', 'Can view pinpai', '10', 'view_pinpai'); INSERT INTO `auth_permission` VALUES ('41', 'Can add shop cart', '11', 'add_shopcart'); INSERT INTO `auth_permission` VALUES ('42', 'Can change shop cart', '11', 'change_shopcart'); INSERT INTO `auth_permission` VALUES ('43', 'Can delete shop cart', '11', 'delete_shopcart'); INSERT INTO `auth_permission` VALUES ('44', 'Can view shop cart', '11', 'view_shopcart'); INSERT INTO `auth_permission` VALUES ('45', 'Can add order info', '12', 'add_orderinfo'); INSERT INTO `auth_permission` VALUES ('46', 'Can change order info', '12', 'change_orderinfo'); INSERT INTO `auth_permission` VALUES ('47', 'Can delete order info', '12', 'delete_orderinfo'); INSERT INTO `auth_permission` VALUES ('48', 'Can view order info', '12', 'view_orderinfo'); INSERT INTO `auth_permission` VALUES ('49', 'Can add order detail', '13', 'add_orderdetail'); INSERT INTO `auth_permission` VALUES ('50', 'Can change order detail', '13', 'change_orderdetail'); INSERT INTO `auth_permission` VALUES ('51', 'Can delete order detail', '13', 'delete_orderdetail'); INSERT INTO `auth_permission` VALUES ('52', 'Can view order detail', '13', 'view_orderdetail'); INSERT INTO `auth_permission` VALUES ('53', 'Can add 轮播图', '14', 'add_banner'); INSERT INTO `auth_permission` VALUES ('54', 'Can change 轮播图', '14', 'change_banner'); INSERT INTO `auth_permission` VALUES ('55', 'Can delete 轮播图', '14', 'delete_banner'); INSERT INTO `auth_permission` VALUES ('56', 'Can view 轮播图', '14', 'view_banner'); INSERT INTO `auth_permission` VALUES ('57', 'Can add address', '15', 'add_address'); INSERT INTO `auth_permission` VALUES ('58', 'Can change address', '15', 'change_address'); INSERT INTO `auth_permission` VALUES ('59', 'Can delete address', '15', 'delete_address'); INSERT INTO `auth_permission` VALUES ('60', 'Can view address', '15', 'view_address'); INSERT INTO `auth_permission` VALUES ('61', 'Can add log', '16', 'add_lo