Repository navigation
Expand file tree
/
Copy pathcheck_sql.sql
More file actions
13 lines (8 loc) · 2.49 KB
/
Copy pathcheck_sql.sql
File metadata and controls
13 lines (8 loc) · 2.49 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
-- CREATE DATABASE `cloudmusic`;
--CREATE TABLE `cloudmusic`.`user_comment` ( `id` INT(20) NOT NULL , `name` TEXT NOT NULL , `comment` TEXT NOT NULL ) ENGINE = MyISAM;
--CREATE TABLE `cloudmusic`.`user_love_songs` ( `id` INT(20) NOT NULL , `name` TEXT NOT NULL , `1` TEXT NOT NULL , `2` TEXT NOT NULL , `3` TEXT NOT NULL , `4` TEXT NOT NULL , `5` TEXT NOT NULL , `6` TEXT NOT NULL , `7` TEXT NOT NULL , `8` TEXT NOT NULL , `9` TEXT NOT NULL , `10` TEXT NOT NULL , `11` TEXT NOT NULL , `12` TEXT NOT NULL , `13` TEXT NOT NULL , `14` TEXT NOT NULL , `15` TEXT NOT NULL , `16` TEXT NOT NULL , `17` TEXT NOT NULL , `18` TEXT NOT NULL , `19` TEXT NOT NULL , `20` TEXT NOT NULL , `21` TEXT NOT NULL , `22` TEXT NOT NULL , `23` TEXT NOT NULL , `24` TEXT NOT NULL , `25` TEXT NOT NULL , `26` TEXT NOT NULL , `27` TEXT NOT NULL , `28` TEXT NOT NULL , `29` TEXT NOT NULL , `30` TEXT NOT NULL , `31` TEXT NOT NULL , `32` TEXT NOT NULL , `33` TEXT NOT NULL , `34` TEXT NOT NULL , `35` TEXT NOT NULL , `36` TEXT NOT NULL , `37` TEXT NOT NULL , `38` TEXT NOT NULL , `39` TEXT NOT NULL , `40` TEXT NOT NULL , `41` TEXT NOT NULL , `42` TEXT NOT NULL , `43` TEXT NOT NULL , `44` TEXT NOT NULL , `45` TEXT NOT NULL , `46` TEXT NOT NULL , `47` TEXT NOT NULL , `48` TEXT NOT NULL , `49` TEXT NOT NULL , `50` TEXT NOT NULL , `51` TEXT NOT NULL , `52` TEXT NOT NULL , `53` TEXT NOT NULL , `54` TEXT NOT NULL , `55` TEXT NOT NULL , `56` TEXT NOT NULL , `57` TEXT NOT NULL , `58` TEXT NOT NULL , `59` TEXT NOT NULL , `60` TEXT NOT NULL , `61` TEXT NOT NULL , `62` TEXT NOT NULL , `63` TEXT NOT NULL , `64` TEXT NOT NULL , `65` TEXT NOT NULL , `66` TEXT NOT NULL , `67` TEXT NOT NULL , `68` TEXT NOT NULL , `69` TEXT NOT NULL , `70` TEXT NOT NULL , `71` TEXT NOT NULL , `72` TEXT NOT NULL , `73` TEXT NOT NULL , `74` TEXT NOT NULL , `75` TEXT NOT NULL , `76` TEXT NOT NULL , `77` TEXT NOT NULL , `78` TEXT NOT NULL , `79` TEXT NOT NULL , `80` TEXT NOT NULL , `81` TEXT NOT NULL , `82` TEXT NOT NULL , `83` TEXT NOT NULL , `84` TEXT NOT NULL , `85` TEXT NOT NULL , `86` TEXT NOT NULL , `87` TEXT NOT NULL , `88` TEXT NOT NULL , `89` TEXT NOT NULL , `90` TEXT NOT NULL , `91` TEXT NOT NULL , `92` TEXT NOT NULL , `93` TEXT NOT NULL , `94` TEXT NOT NULL , `95` TEXT NOT NULL , `96` TEXT NOT NULL , `97` TEXT NOT NULL , `98` TEXT NOT NULL , `99` TEXT NOT NULL , `100` TEXT NOT NULL ) ENGINE = MyISAM;
------------------------------
--若数据库存在则删除
--drop database if exists db;
--若数据库不存在,则创建数据库
--create database if not exists db;