wage_manage.sql

-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2017-05-31 17:17:54
-- 服务器版本： 5.7.18-0ubuntu0.16.04.1
-- PHP Version: 7.0.15-0ubuntu0.16.04.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `wage_manage`
--

-- --------------------------------------------------------

--
-- 表的结构 `course`
--

CREATE TABLE `course` (
  `course_number` varchar(6) CHARACTER SET latin1 NOT NULL,
  `course_name` varchar(90) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lesson_number` int(11) NOT NULL,
  `class_size` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 转存表中的数据 `course`
--

INSERT INTO `course` (`course_number`, `course_name`, `lesson_number`, `class_size`) VALUES
('000001', '大学语文', 15, 55),
('000002', '大学英语', 13, 35),
('000003', '高等数学', 12, 56),
('000004', '大学语文', 12, 25),
('000006', '大学英语', 17, 80),
('000007', '数据库原理', 23, 124),
('000005', '计算机网络', 10, 65),
('000008', '工科数学分析', 12, 78),
('000009', '数理逻辑和集合论', 18, 86),
('000010', '微观经济学', 6, 60),
('000011', '宏观经济学', 7, 30),
('000012', '计量经济学', 15, 78),
('000013', '金融理论', 6, 88),
('000014', '发展经济学', 16, 51),
('000015', '制度经济学', 18, 47),
('000016', 'WTO专题', 9, 62),
('000017', '国际贸易实务', 7, 50),
('000018', '国际企业管理', 11, 81),
('000019', '人力资源管理', 15, 94),
('000020', '西方经济学', 19, 75),
('000021', '国际经济学', 16, 76),
('000022', '电子商务概论', 9, 85),
('000023', '网络营销', 6, 82),
('000024', '信息系统概论', 16, 35),
('000025', '保险学', 14, 49),
('000026', '金融学', 19, 48),
('000027', '国际金融学', 8, 28),
('000028', '证券投资学', 12, 50),
('000029', '会计学', 14, 95),
('000030', '财务管理', 9, 62),
('000031', '审计学', 13, 70),
('000032', '艺术设计概论', 8, 90),
('000033', '中国艺术设计史', 7, 29),
('000034', '外国艺术设计史', 9, 55),
('000035', '艺术考古学', 9, 29),
('000036', '文化史迹考察', 14, 99),
('000037', '设计素描', 12, 34),
('000038', '设计表达技法', 6, 87),
('000039', '平面构成与设计', 12, 89),
('000040', '立体构成与设计', 19, 69),
('000041', '工业设计导论', 16, 35),
('000042', '工业设计史', 8, 43),
('000043', '工程制图', 18, 84),
('000044', '机械设计基础', 18, 78),
('000045', '技术美学', 19, 48),
('000046', '动画艺术概论', 18, 85),
('000047', '电影视听语言', 18, 44),
('000048', '分镜头剧本设计', 5, 85),
('000049', '导演基础', 16, 51),
('000050', '动画片创作', 14, 39),
('000051', '产品设计原理', 20, 38),
('000052', '产品创新设计', 6, 84),
('000053', '结构力学', 20, 47),
('000054', '材料力学', 10, 48),
('000055', '建筑材料', 8, 100),
('000056', '流体力学', 20, 93),
('000057', '荷载与结构设计原理', 9, 40),
('000058', '钢筋混凝土结构', 18, 35),
('000059', '地基基础', 18, 80),
('000060', '高层建筑结构', 18, 87),
('000061', '地下工程', 9, 73),
('000062', '建筑结构抗震 ', 5, 49),
('000063', '工程经济', 11, 64),
('000064', '建设项目管理', 15, 59),
('000065', 'C语言程序设计', 17, 45),
('000066', '计算机组成原理', 17, 75),
('000067', '数据结构', 11, 69),
('000068', '操作系统', 6, 81),
('000069', '微机原理', 19, 47),
('000070', '计算机网络', 14, 87),
('000071', '计算机系统结构', 19, 60),
('000072', '软件工程', 15, 80),
('000073', '面向对象程序设计', 7, 50),
('000074', '分布式系统', 8, 74),
('000075', '软件工程', 7, 72),
('000076', 'Oracle数据库系统', 13, 50),
('000077', '电子商务', 19, 89),
('000078', '物流管理', 7, 32),
('000079', '商务网站建设', 15, 66),
('000080', '计算机图形学', 17, 71),
('000081', '人工智能', 5, 96),
('000082', '数字信号处理', 7, 66),
('000083', '信息对抗', 15, 39),
('000084', '移动计算', 6, 93),
('000085', '微机系统', 6, 46),
('000086', '人机界面设计', 13, 80),
('000087', '计算机网络', 5, 63),
('000088', '信息安全', 15, 48),
('000089', '电子技术', 12, 67),
('000090', '程序设计', 5, 83),
('000091', '商务网站建设', 16, 28),
('000092', '供应链管理', 11, 99),
('000093', '国际商务管理', 12, 49),
('000094', '物流管理', 13, 39),
('000095', '编译原理', 15, 32),
('000096', '管理学原理', 11, 51),
('000097', '电子商务', 13, 32),
('000098', '应用密码学基础', 18, 33),
('000099', '计算机通讯原理', 17, 100),
('000100', '数论与有限域基础', 18, 29),
('000101', '计算机系统结构', 10, 95),
('000102', '数字图像处理', 8, 33),
('000103', '多媒体信息处理技术', 9, 49),
('000104', '算法设计与分析', 18, 55),
('000105', '汇编语言', 14, 95),
('000106', '计算机电路基础', 19, 82),
('000107', '信息隐藏技术', 10, 86),
('000108', '网络安全编程', 17, 56),
('000109', '网络安全风险评估', 17, 64),
('000110', '信息安全数学基础', 10, 98),
('000111', '现代艺术', 12, 35);

-- --------------------------------------------------------

--
-- 表的结构 `professional_title`
--

CREATE TABLE `professional_title` (
  `title_code` int(1) NOT NULL,
  `title_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wage` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 转存表中的数据 `professional_title`
--

INSERT INTO `professional_title` (`title_code`, `title_name`, `wage`) VALUES
(1, '教授', 6000),
(2, '副教授', 5000),
(3, '讲师', 4000),
(4, '助教', 3000),
(0, '无', 0);

-- --------------------------------------------------------

--
-- 表的结构 `staff_position`
--

CREATE TABLE `staff_position` (
  `position_code` int(11) NOT NULL,
  `position_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wage` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 转存表中的数据 `staff_position`
--

INSERT INTO `staff_position` (`position_code`, `position_name`, `wage`) VALUES
(1, '校长', 8000),
(2, '副校长', 7500),
(3, '处长', 7000),
(4, '副处长', 6500),
(5, '科长', 6000),
(6, '副科长', 5500),
(7, '主管', 5000),
(8, '职员', 4500),
(0, '无', 0);

-- --------------------------------------------------------

--
-- 表的结构 `teaching_arrangement`
--

CREATE TABLE `teaching_arrangement` (
  `staff_number` varchar(6) CHARACTER SET latin1 NOT NULL,
  `course_number` varchar(6) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 转存表中的数据 `teaching_arrangement`
--

INSERT INTO `teaching_arrangement` (`staff_number`, `course_number`) VALUES
('000001', '000002'),
('000001', '000004'),
('000001', '000005'),
('000003', '000008'),
('000003', '000009'),
('000003', '000010'),
('000003', '000011'),
('000003', '000012'),
('000004', '000013'),
('000003', '000014'),
('000003', '000015'),
('000003', '000016'),
('000003', '000017'),
('000003', '000018'),
('000003', '000019'),
('000003', '000020'),
('000005', '000021'),
('000003', '000022'),
('000003', '000023'),
('000003', '000024'),
('000003', '000025'),
('000003', '000026'),
('000003', '000027'),
('000003', '000028'),
('000003', '000029'),
('000004', '000030'),
('000004', '000031'),
('000004', '000032'),
('000004', '000033'),
('000004', '000034'),
('000004', '000035'),
('000004', '000036'),
('000004', '000037'),
('000004', '000038'),
('000004', '000039'),
('000004', '000040'),
('000004', '000041'),
('000004', '000042'),
('000004', '000043'),
('000003', '000044'),
('000004', '000045'),
('000004', '000046'),
('000004', '000047'),
('000004', '000048'),
('000005', '000049'),
('000005', '000050'),
('000005', '000051'),
('000005', '000052'),
('000005', '000053'),
('000005', '000054'),
('000005', '000055'),
('000005', '000056'),
('000005', '000057'),
('000005', '000058'),
('000005', '000059'),
('000005', '000060'),
('000005', '000061'),
('000005', '000062'),
('000005', '000063'),
('000005', '000064'),
('000003', '000065'),
('000005', '000066'),
('000005', '000067'),
('000005', '000068'),
('000005', '000069'),
('000005', '000070'),
('000005', '000071'),
('000005', '000072'),
('000005', '000073'),
('000005', '000074'),
('000005', '000075'),
('000005', '000076'),
('000005', '000077'),
('000005', '000078'),
('000005', '000079'),
('000005', '000080'),
('000005', '000081'),
('000005', '000082'),
('000005', '000083'),
('000005', '000084'),
('000006', '000085'),
('000006', '000086'),
('000006', '000087'),
('000006', '000088'),
('000006', '000089'),
('000006', '000090'),
('000006', '000091'),
('000006', '000092'),
('000006', '000093'),
('000006', '000094'),
('000006', '000095'),
('000006', '000096'),
('000006', '000097'),
('000006', '000098'),
('000006', '000099'),
('000006', '000100'),
('000006', '000101'),
('000006', '000102'),
('000006', '000103'),
('000006', '000104'),
('000006', '000105'),
('000006', '000106'),
('000006', '000107'),
('000006', '000108'),
('000006', '000109'),
('000006', '000110'),
('000006', '000111');

-- --------------------------------------------------------

--
-- 表的结构 `user`
--

CREATE TABLE `user` (
  `staff_number` char(6) CHARACTER SET latin1 NOT NULL,
  `staff_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modify_right` int(11) DEFAULT '0',
  `staff_position` int(11) NOT NULL DEFAULT '0',
  `professional_title` int(11) NOT NULL DEFAULT '0',
  `password` varchar(20) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 转存表中的数据 `user`
--

INSERT INTO `user` (`staff_number`, `staff_name`, `modify_right`, `staff_position`, `professional_title`, `password`) VALUES
('000000', '管理员', 1, 0, 0, '123456'),
('000001', '赵四', 0, 6, 1, '123456'),
('000002', '张全', 1, 1, 1, '123456'),
('000003', '李四', 0, 0, 3, '123456'),
('000004', '赵红', 0, 8, 1, '123456'),
('000006', '赵红', 0, 2, 2, '123456'),
('000005', '李四', 0, 0, 1, '123456'),
('000013', '赵爱国', 0, 1, 3, '123456'),
('000012', '陈坤', 0, 4, 3, '123456'),
('000011', '李红', 0, 4, 4, '123456'),
('000010', '王兑', 0, 6, 2, '123456'),
('000009', '李勇', 0, 3, 4, '123456'),
('000007', '王万', 0, 3, 4, '123456'),
('000008', '大江', 1, 6, 1, '123456'),
('000021', '储清淑', 0, 5, 2, '123456'),
('000018', '蚁芷蝶', 0, 4, 4, '123456'),
('000019', '官兴邦', 0, 8, 2, '123456'),
('000020', '甄代桃', 0, 0, 3, '123456'),
('000017', '过媛女', 0, 6, 4, '123456'),
('000016', '卞芊丽', 0, 2, 3, '123456'),
('000015', '僪琳瑜', 0, 6, 2, '123456'),
('000014', '李白', 0, 8, 3, '123456'),
('000022', '卯浩荡', 1, 4, 4, '123456'),
('000037', '竭君博', 0, 3, 2, '123456'),
('000036', '勇清晖', 0, 8, 3, '123456'),
('000035', '鲜于梦菲', 0, 4, 2, '123456'),
('000034', '频元彤', 0, 1, 2, '123456'),
('000033', '曹叶彤', 0, 2, 3, '123456'),
('000032', '花醉柳', 0, 3, 4, '123456'),
('000031', '檀英哲', 0, 3, 4, '123456'),
('000030', '哀涵衍', 0, 0, 2, '123456'),
('000029', '洛和怡', 0, 3, 2, '123456'),
('000028', '邗思凡', 0, 6, 1, '123456'),
('000027', '孛语心', 0, 6, 2, '123456'),
('000026', '惠姣妍', 0, 6, 2, '123456'),
('000025', '貊春竹', 0, 7, 4, '123456'),
('000023', '纳喇寄文', 0, 7, 2, '123456'),
('000024', '闾夏旋', 0, 1, 2, '123456'),
('000038', '雪半双', 0, 8, 2, '123456'),
('000039', '冷建业', 0, 0, 4, '123456'),
('000040', '士玟丽', 0, 3, 2, '123456'),
('000041', '行清秋', 0, 0, 1, '123456'),
('000042', '史雨安', 0, 1, 1, '123456'),
('000043', '司璞玉', 0, 1, 1, '123456'),
('000044', '马佳侠骞', 0, 0, 2, '123456'),
('000045', '析璞玉', 0, 6, 3, '123456'),
('000046', '崔雅达', 0, 2, 3, '123456'),
('000047', '都曼冬', 0, 7, 2, '123456'),
('000048', '子车星星', 0, 8, 3, '123456'),
('000049', '繁曾琪', 0, 1, 3, '123456'),
('000050', '游小宸', 0, 2, 2, '123456'),
('000051', '邝奇邃', 0, 8, 3, '123456'),
('000052', '苍成龙', 0, 4, 3, '123456'),
('000053', '湛清晖', 0, 3, 2, '123456');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `course`
--
ALTER TABLE `course`
  ADD PRIMARY KEY (`course_number`);

--
-- Indexes for table `professional_title`
--
ALTER TABLE `professional_title`
  ADD PRIMARY KEY (`title_code`);

--
-- Indexes for table `staff_position`
--
ALTER TABLE `staff_position`
  ADD PRIMARY KEY (`position_code`);

--
-- Indexes for table `teaching_arrangement`
--
ALTER TABLE `teaching_arrangement`
  ADD PRIMARY KEY (`course_number`,`staff_number`),
  ADD KEY `staff_number` (`staff_number`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`staff_number`),
  ADD KEY `staff_position` (`staff_position`),
  ADD KEY `professional_title` (`professional_title`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;