/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : springboot

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

Date: 2018-04-07 20:54:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sequence
-- ----------------------------
DROP TABLE IF EXISTS `sequence`;
CREATE TABLE `sequence` (
  `NAME` varchar(50) CHARACTER SET latin1 NOT NULL,
  `CURRENT_VALUE` bigint(20) NOT NULL DEFAULT '0',
  `INCREMENT` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sequence
-- ----------------------------
INSERT INTO `sequence` VALUES ('nextVal', '14', '1');

-- ----------------------------
-- Table structure for singer
-- ----------------------------
DROP TABLE IF EXISTS `singer`;
CREATE TABLE `singer` (
  `singer_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `english_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`singer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of singer
-- ----------------------------
INSERT INTO `singer` VALUES ('11', '张三', '12', 'zhangsan ');
INSERT INTO `singer` VALUES ('22', '李四', '24', 'lisi');
INSERT INTO `singer` VALUES ('33', '王五', '23', 'wangwu');

-- ----------------------------
-- Table structure for song
-- ----------------------------
DROP TABLE IF EXISTS `song`;
CREATE TABLE `song` (
  `song_id` int(11) NOT NULL AUTO_INCREMENT,
  `singer_id` int(11) NOT NULL,
  `song_name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`song_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of song
-- ----------------------------
INSERT INTO `song` VALUES ('1', '11', '张三的歌1', '张三的歌1', '', '2018-04-07 19:12:14');
INSERT INTO `song` VALUES ('2', '11', '张三的歌2', '张三的歌2', '', '2018-04-03 19:12:16');
INSERT INTO `song` VALUES ('3', '11', '张三的歌3', '张三的歌3', '', '2018-04-02 19:12:18');
INSERT INTO `song` VALUES ('4', '22', '李四的歌1', '李四的歌1', null, '2018-04-01 19:12:20');
INSERT INTO `song` VALUES ('5', '22', '李四的歌2', '李四的歌2', null, '2018-03-07 19:12:23');
INSERT INTO `song` VALUES ('6', '33', '王五的歌1', '王五的歌1', null, '2018-03-13 19:12:27');
INSERT INTO `song` VALUES ('7', '33', '王五的歌2', '王五的歌2', null, '2018-03-02 19:12:31');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(32) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('12', 'tangsir', '565258252@qq.com');
INSERT INTO `user` VALUES ('14', 'string', 'string');

-- ----------------------------
-- Function structure for currval
-- ----------------------------
DROP FUNCTION IF EXISTS `currval`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` FUNCTION `currval`(seq_name VARCHAR(50)) RETURNS bigint(20)
BEGIN
DECLARE VALUE INTEGER;
SET VALUE=0;
SELECT current_value INTO VALUE
FROM sequence
WHERE NAME=seq_name;
RETURN VALUE;
END
;;
DELIMITER ;

-- ----------------------------
-- Function structure for nextval
-- ----------------------------
DROP FUNCTION IF EXISTS `nextval`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` FUNCTION `nextval`(seq_name VARCHAR(50)) RETURNS bigint(20)
BEGIN
UPDATE sequence
SET CURRENT_VALUE = CURRENT_VALUE + INCREMENT
WHERE NAME=seq_name;
RETURN currval(seq_name);
END
;;
DELIMITER ;