1 Star 0 Fork 1

Li Shi/django curd

forked from yanpeng1535/django curd 
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
school.sql 17.19 KB
一键复制 编辑 原始数据 按行查看 历史
yanpeng1535 提交于 2020-11-11 22:45 +08:00 . add
/*
Navicat MySQL Data Transfer
Source Server : mysql5.7
Source Server Version : 50726
Source Host : localhost:3306
Source Database : school
Target Server Type : MYSQL
Target Server Version : 50726
File Encoding : 65001
Date: 2020-11-11 22:45:31
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for access
-- ----------------------------
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`access_token` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`curr_time` int(11) DEFAULT NULL,
`flag` int(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of access
-- ----------------------------
-- ----------------------------
-- Table structure for app_article
-- ----------------------------
DROP TABLE IF EXISTS `app_article`;
CREATE TABLE `app_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
`author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`body` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of app_article
-- ----------------------------
INSERT INTO `app_article` VALUES ('1', '测试标题一', '燕鹏', '开始新的学习之旅了,朋友们准备好了吗?下面的一段时间笔者将和大家一起复习以下数据结构这门基础的课程。\r\n\r\n不知道大家有没有跟笔者一样的情况,一直在说数据结构,数据结构,那什么是数据结构呢?\r\n\r\n一 概念\r\n\r\n先卖个关子,我们来看一个开发中常见的场景:\r\n\r\n一个用户在使用我们系统的时候,注册了一个账号,我们在业务处理中根据注册信息,通过一系列处理生成一个User对象。\r\n\r\n然后通过save方法保存到数据库中,这样以后我们就可以直接从这个表中读取用户信息了。');
INSERT INTO `app_article` VALUES ('2', '测试标题2', '飞扬', '这是一门专门处理数据的学科,数据元素相互之间的关联称为结构,描述的是存储和组织数据的方式。\r\n\r\n按照书中的说法,数据结构是指相互之间存在一种或多种特定关系的数据元素的集合。\r\n\r\n下面我们就继续明确几个概念。\r\n\r\n2. 数据:对客观事物的符号表示,指所有能输入到计算机中并被计算机程序处理的符号的总称。\r\n\r\n上面场景中的注册信息,就是数据。数据库中存储的用户记录,那也是数据没跑了。\r\n\r\n3. 数据项:数据项是数据的不可分割的最小单位。\r\n\r\n这个不用太困惑,如上图所示的用户表中的id,accont,password等每一个字段,都是一个数据项。');
INSERT INTO `app_article` VALUES ('4', '测试标题3', '飞扬', '竞赛具体情况如下:\r\n\r\n一、报名时间:2020年10月16日至2020年10月20日晚24点。\r\n\r\n比赛时间:2020年10月22日下午18:00-22:00。\r\n\r\n二、比赛要求:\r\n\r\n参赛人员需自带电脑、网线、笔、草稿纸等考试用品。\r\n\r\n考试允许携带纸质材料。\r\n\r\n如有意向参赛,请加入QQ群:512921915\r\n\r\n三、奖励机制:\r\n\r\n一等奖:1人,奖励1800元;\r\n\r\n二等奖:3人,每人奖励1300元;\r\n\r\n三等奖:5人,每人奖励900元;\r\n\r\n最具潜力奖:10人,每人奖励500元。');
INSERT INTO `app_article` VALUES ('5', '今天是双十一', '飞扬111', '双十一双十一双十一双十一双十一双十一双十一双十一双十一双十一双十一双十一双十一双十一');
INSERT INTO `app_article` VALUES ('11', '甘肃永昌111111', '燕鹏2222', '永昌一中3333');
INSERT INTO `app_article` VALUES ('6', '测试标题888', '飞扬888', '这是第八个内容这是第八个内容这是第八个内容这是第八个内容');
INSERT INTO `app_article` VALUES ('7', '标题你好99', '燕鹏', '今天是双十一今天是双十一今天是双十一');
-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of auth_group
-- ----------------------------
-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
`id` int(11) 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_permissions_group_id_b120cbf9` (`group_id`),
KEY `auth_group_permissions_permission_id_84c5c92e` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- 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) COLLATE utf8_unicode_ci NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
KEY `auth_permission_content_type_id_2f476e4b` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- 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 add permission', '2', 'add_permission');
INSERT INTO `auth_permission` VALUES ('5', 'Can change permission', '2', 'change_permission');
INSERT INTO `auth_permission` VALUES ('6', 'Can delete permission', '2', 'delete_permission');
INSERT INTO `auth_permission` VALUES ('7', 'Can add group', '3', 'add_group');
INSERT INTO `auth_permission` VALUES ('8', 'Can change group', '3', 'change_group');
INSERT INTO `auth_permission` VALUES ('9', 'Can delete group', '3', 'delete_group');
INSERT INTO `auth_permission` VALUES ('10', 'Can add user', '4', 'add_user');
INSERT INTO `auth_permission` VALUES ('11', 'Can change user', '4', 'change_user');
INSERT INTO `auth_permission` VALUES ('12', 'Can delete user', '4', 'delete_user');
INSERT INTO `auth_permission` VALUES ('13', 'Can add content type', '5', 'add_contenttype');
INSERT INTO `auth_permission` VALUES ('14', 'Can change content type', '5', 'change_contenttype');
INSERT INTO `auth_permission` VALUES ('15', 'Can delete content type', '5', 'delete_contenttype');
INSERT INTO `auth_permission` VALUES ('16', 'Can add session', '6', 'add_session');
INSERT INTO `auth_permission` VALUES ('17', 'Can change session', '6', 'change_session');
INSERT INTO `auth_permission` VALUES ('18', 'Can delete session', '6', 'delete_session');
INSERT INTO `auth_permission` VALUES ('19', 'Can add article', '7', 'add_article');
INSERT INTO `auth_permission` VALUES ('20', 'Can change article', '7', 'change_article');
INSERT INTO `auth_permission` VALUES ('21', 'Can delete article', '7', 'delete_article');
-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
`first_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(254) COLLATE utf8_unicode_ci NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of auth_user
-- ----------------------------
-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
KEY `auth_user_groups_user_id_6a12ed8b` (`user_id`),
KEY `auth_user_groups_group_id_97559544` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
KEY `auth_user_user_permissions_user_id_a95ead1b` (`user_id`),
KEY `auth_user_user_permissions_permission_id_1fbb5f2c` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action_time` datetime(6) NOT NULL,
`object_id` longtext COLLATE utf8_unicode_ci,
`object_repr` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`action_flag` smallint(5) unsigned NOT NULL,
`change_message` longtext COLLATE utf8_unicode_ci NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `django_admin_log_content_type_id_c4bce8eb` (`content_type_id`),
KEY `django_admin_log_user_id_c564eba6` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`model` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of django_content_type
-- ----------------------------
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', 'app', 'article');
-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`applied` datetime(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of django_migrations
-- ----------------------------
INSERT INTO `django_migrations` VALUES ('1', 'contenttypes', '0001_initial', '2020-11-11 12:19:06.602699');
INSERT INTO `django_migrations` VALUES ('2', 'auth', '0001_initial', '2020-11-11 12:19:07.783712');
INSERT INTO `django_migrations` VALUES ('3', 'admin', '0001_initial', '2020-11-11 12:19:08.118694');
INSERT INTO `django_migrations` VALUES ('4', 'admin', '0002_logentry_remove_auto_add', '2020-11-11 12:19:08.148708');
INSERT INTO `django_migrations` VALUES ('5', 'app', '0001_initial', '2020-11-11 12:19:08.209696');
INSERT INTO `django_migrations` VALUES ('6', 'contenttypes', '0002_remove_content_type_name', '2020-11-11 12:19:08.359708');
INSERT INTO `django_migrations` VALUES ('7', 'auth', '0002_alter_permission_name_max_length', '2020-11-11 12:19:08.442708');
INSERT INTO `django_migrations` VALUES ('8', 'auth', '0003_alter_user_email_max_length', '2020-11-11 12:19:08.554711');
INSERT INTO `django_migrations` VALUES ('9', 'auth', '0004_alter_user_username_opts', '2020-11-11 12:19:08.580710');
INSERT INTO `django_migrations` VALUES ('10', 'auth', '0005_alter_user_last_login_null', '2020-11-11 12:19:08.665696');
INSERT INTO `django_migrations` VALUES ('11', 'auth', '0006_require_contenttypes_0002', '2020-11-11 12:19:08.675697');
INSERT INTO `django_migrations` VALUES ('12', 'auth', '0007_alter_validators_add_error_messages', '2020-11-11 12:19:08.705702');
INSERT INTO `django_migrations` VALUES ('13', 'auth', '0008_alter_user_username_max_length', '2020-11-11 12:19:08.799707');
INSERT INTO `django_migrations` VALUES ('14', 'sessions', '0001_initial', '2020-11-11 12:19:08.912710');
-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
`session_key` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`session_data` longtext COLLATE utf8_unicode_ci NOT NULL,
`expire_date` datetime(6) NOT NULL,
PRIMARY KEY (`session_key`),
KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of django_session
-- ----------------------------
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stuno` varchar(20) NOT NULL,
`stuname` varchar(10) DEFAULT NULL,
`jg` varchar(30) DEFAULT NULL,
`department` varchar(100) DEFAULT NULL,
`hobby` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('2', '19041010002', '秦敏泽', '汕头南澳', '艺术学院', '跳舞,学习,画画,音乐');
INSERT INTO `student` VALUES ('3', '19041010003', '田河', '佛山江门', '医学院', '打篮球,计算机编程');
INSERT INTO `student` VALUES ('4', '19041010004', '张居平', '湛江遂溪', '护理学院', '编程');
INSERT INTO `student` VALUES ('5', '19041010005', '柴雅丽', '茂名电白', '美术学院', '绘画');
INSERT INTO `student` VALUES ('6', '19041010007', '刘年', '肇庆广宁', '文学院', '音乐');
INSERT INTO `student` VALUES ('7', '19041010008', '张希舟', '惠州博罗', '理工学院', '看书');
INSERT INTO `student` VALUES ('8', '19041010009', '杨雁泽', '梅州梅县', '师范学院', '读小说');
INSERT INTO `student` VALUES ('9', '19041010010', '李延潮', '汕尾海丰', '人工智能学院', '兵乓球');
INSERT INTO `student` VALUES ('10', '19041010011', '潘岳', '河源紫金', '软件学院', '足球,篮球,旅游,打游戏');
INSERT INTO `student` VALUES ('11', '19041010012', '曹泽庆', '阳江阳西', '教育技术学院', '跑步');
INSERT INTO `student` VALUES ('12', '19041010013', '吕佰旭', '清远佛冈', '哲学院', '看电影');
INSERT INTO `student` VALUES ('13', '19041010014', '李金泉', '潮州潮安', '马克思主义学院', '写小说,读书,看报纸');
INSERT INTO `student` VALUES ('16', '19041010001', '柯发平', '深圳', '人工智能学院', '学习');
INSERT INTO `student` VALUES ('17', '19041010015', '李晶', '广西桂林', '软件学院', '学习计算机技术');
INSERT INTO `student` VALUES ('18', '19041010015', '王海元', '广西', '软件学院', '打篮球');
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Python
1
https://gitee.com/li-shimarble/django-curd.git
git@gitee.com:li-shimarble/django-curd.git
li-shimarble
django-curd
django curd
master

搜索帮助