赞
踩
- USE `MusicPlayer`;
-
- DROP TABLE IF EXISTS `music`;
- CREATE TABLE `music` (
- `music_id` int(5) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `author` varchar(50) NOT NULL,
- `address` varchar(50) NOT NULL,
- `img` varchar(50) NOT NULL,
- `create_time` datetime NOT NULL,
- `change_time` datetime,
- `remark` text,
- PRIMARY KEY (`music_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
- CREATE TABLE `user` (
- `userid` int(5) NOT NULL AUTO_INCREMENT,
- `account` varchar(20) NOT NULL,
- `password` varchar(20) NOT NULL,
- `music_id` int(5) NOT NULL DEFAULT '0',
- `pattern` int(5) NOT NULL DEFAULT '0',
- `create_time` datetime NOT NULL,
- `change_time` datetime,
- `remark` text,
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
- insert into music(name,author,address,img,create_time)
- values ('Strongest','Ina Wroldsen,Alan Walker','Strongest.mp3','Strongest.jpg',now());
-
- insert into music(name,author,address,img,create_time)
- values ('Forgettable','Olivia','Forgettable.mp3','Forgettable.jpg',now());
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。