⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 db.sql

📁 QT KTV 源码,QT designer
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
PRAGMA encoding = "UTF-8";
DROP TABLE Singer;
DROP TABLE Song;
DROP TABLE Dic;
DROP TABLE User;
DROP TABLE PrivateSong;
DROP TABLE OrderList;

CREATE TABLE Singer(
singerId INTEGER PRIMARY KEY,
singerName VARCHAR(20),
singerCategory VARCHAR(20),
singerGender VARCHAR(2),
singerPic VARCHAR(100)
);
CREATE TABLE Song(
songId INTEGER PRIMARY KEY,
songName VARCHAR(100),
songPath VARCHAR(100),
songCategory VARCHAR(20),
singerId INT,
songLanguage VARCHAR(20),
songPlayCount INT DEFAULT 0,
pinyin VARCHAR(50) DEFAULT NULL,
songRegTime DATETIME
);
CREATE TABLE Dic(
word VARCHAR(4),
pinyin VARCHAR(2)
);
CREATE TABLE User(
userId INTEGER PRIMARY KEY,
account VARCHAR(20),
pwd VARCHAR(20)
);
CREATE TABLE PrivateSong(
psongId INTEGER PRIMARY KEY,
userId INT,
songId INT,
songSaveTime DATETIME
);
CREATE TABLE OrderList(
orderId INTEGER PRIMARY KEY,
songId INT,
priority TINYINT DEFAULT 0,
finished TINYINT DEFAULT 0
);
CREATE INDEX dic_index ON Dic(word);

INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('蔡依林','港台女星','女','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('周杰伦','港台男星','男','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('韩红','大陆女星','女','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('刀郎','大陆男星','男','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('SHE','演唱组合','女','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('小虎队','演唱组合','男','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('West Life','欧美组合','男','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('宋祖英','大陆女星','女','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('周迅','大陆女星','女','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('潘玮柏','港台男星','男','znl.jpg');
INSERT INTO Singer(singerName,singerCategory,singerGender,singerPic) VALUES ('陶喆','港台男星','男','znl.jpg');

INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('布拉格广场','blggc.rmvb','DISCO',1,'国语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('彩虹','blggc.rmvb','怀旧',2,'闽南歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('天路','blggc.rmvb','舞蹈',3,'粤语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('冲动的惩罚','blggc.rmvb','戏剧',4,'韩语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('Supper Star','blggc.rmvb','革命',5,'日语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('忘了他们有什么歌','blggc.rmvb','民歌',6,'英文歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('My Love','blggc.rmvb','儿童',7,'英文歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('茉莉花','blggc.rmvb','祝福',8,'国语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('不知道她有什么歌','blggc.rmvb','儿童',9,'国语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('不得不爱','blggc.rmvb','DISCO',10,'国语歌曲',date("%Y-%m-%d %H:%M:%S"));
INSERT INTO Song(songName,songPath,songCategory,singerId,songLanguage,songRegTime) VALUES('今天你要嫁给我','blggc.rmvb','怀旧',11,'国语歌曲',date("%Y-%m-%d %H:%M:%S"));

INSERT INTO User(account,pwd) VALUES('001','123456');

INSERT INTO PrivateSong(userId,songId,songSaveTime) VALUES(1,1,date("%Y-%m-%d %H:%M:%S"));

INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('一', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丁', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丁', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('七', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('万', 'm');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('万', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丈', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('三', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('上', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('下', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丌', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丌', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('不', 'b');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('不', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('不', 'f');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('与', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丐', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丑', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('专', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('且', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('且', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('且', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丕', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('世', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丘', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丙', 'b');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('业', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丛', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('东', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丝', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丞', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丞', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丞', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丢', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('两', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('严', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丧', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丨', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丨', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('个', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丫', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丬', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丬', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('中', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丰', 'f');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('串', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('串', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('临', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丶', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丶', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丸', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丹', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('为', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('主', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丽', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('举', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丿', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('丿', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乃', 'a');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乃', 'n');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('久', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乇', 't');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乇', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('么', 'm');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('么', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('义', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('义', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('之', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乌', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乍', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乎', 'h');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乏', 'f');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乐', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乐', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乒', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乓', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乔', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乔', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乖', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乘', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乘', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乙', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乙', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乜', 'm');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乜', 'n');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('九', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乞', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('也', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('习', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乡', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('书', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乩', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('买', 'm');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乱', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乳', 'r');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乾', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('乾', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('了', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('予', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('予', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('争', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('事', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('事', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('二', 'e');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亍', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('于', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('于', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亏', 'k');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亏', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('云', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('互', 'h');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亓', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('五', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('井', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亘', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亘', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亚', 'e');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亚', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('些', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('些', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亟', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亟', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亠', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亠', 't');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亡', 'w');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亢', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亢', 'k');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('交', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亥', 'h');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亥', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亦', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('产', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亨', 'h');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亨', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亨', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亩', 'm');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('享', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('京', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亭', 't');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亮', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亲', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亳', 'b');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亵', 'x');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('人', 'r');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亻', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亻', 'r');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('亿', 'y');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('什', 's');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仁', 'r');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仂', 'l');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仃', 'd');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仄', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仅', 'f');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仅', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仅', 'n');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仆', 'p');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仇', 'c');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仇', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仇', 'q');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('仉', 'z');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('今', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('介', 'g');
INSERT INTO `dic` (`word`, `pinyin`) VALUES 
  ('介', 'j');
INSERT INTO `dic` (`word`, `pinyin`) VALUES
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -