videorentalsystem.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : videorentalsystem

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-01-15 15:39:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_account
-- ----------------------------
DROP TABLE IF EXISTS `admin_account`;
CREATE TABLE `admin_account` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_account
-- ----------------------------
INSERT INTO `admin_account` VALUES ('1', 'a', 'b');
INSERT INTO `admin_account` VALUES ('2', 'c', 'd');

-- ----------------------------
-- Table structure for compact_disk
-- ----------------------------
DROP TABLE IF EXISTS `compact_disk`;
CREATE TABLE `compact_disk` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `position` varchar(255) DEFAULT NULL COMMENT '影碟位置',
  `price` double(10,2) DEFAULT NULL COMMENT '价格',
  `video_name` varchar(255) DEFAULT NULL COMMENT '影碟名称',
  `lead_actor` varchar(255) DEFAULT NULL COMMENT '主演',
  `stock` int(5) DEFAULT NULL COMMENT '现存张数',
  `input_goods` int(5) DEFAULT NULL COMMENT '进货张数',
  `serial_number` varchar(255) DEFAULT NULL COMMENT '影碟编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of compact_disk
-- ----------------------------
INSERT INTO `compact_disk` VALUES ('4', 'w', '23.00', '421', '422', '2', '124', '321');

-- ----------------------------
-- Table structure for the_order
-- ----------------------------
DROP TABLE IF EXISTS `the_order`;
CREATE TABLE `the_order` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `deposit` double(10,2) DEFAULT NULL COMMENT '押金',
  `user_id` int(5) DEFAULT NULL COMMENT '用户表中的id',
  `compact_disk_id` int(5) DEFAULT NULL COMMENT '影碟表中的id',
  `receipt_id` varchar(255) DEFAULT NULL COMMENT '发票号',
  `state` int(1) DEFAULT NULL COMMENT '0-未归还;1-已归还',
  `rental` double(10,2) DEFAULT NULL COMMENT '租金',
  `rental_date` datetime DEFAULT NULL COMMENT '出租日期',
  `return_date` datetime DEFAULT NULL COMMENT '归还日期',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of the_order
-- ----------------------------
INSERT INTO `the_order` VALUES ('1', '115.00', '3', '4', '112', '1', '10.20', '2018-05-12 00:00:00', '2018-05-16 00:00:00');
INSERT INTO `the_order` VALUES ('2', '115.00', '3', '4', '112', '0', '10.20', '2018-05-12 00:00:00', '2018-05-16 00:00:00');

-- ----------------------------
-- Table structure for user_account
-- ----------------------------
DROP TABLE IF EXISTS `user_account`;
CREATE TABLE `user_account` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_account
-- ----------------------------
INSERT INTO `user_account` VALUES ('1', '1', '1');
INSERT INTO `user_account` VALUES ('2', '2', '1');
INSERT INTO `user_account` VALUES ('3', '2', '3332');