sample-data.sql

我的图书馆或资料库

INSERT INTO colors VALUES (2,'#000000','黑色');
INSERT INTO colors VALUES (28,'#0000FF','蓝色');
INSERT INTO colors VALUES (38,'#8A2BE2','蓝紫色');
INSERT INTO colors VALUES (33,'#5F9EA0','灰蓝色');
INSERT INTO colors VALUES (10,'#D2691E','巧克力色');
INSERT INTO colors VALUES (15,'#FF7F50','珊瑚色');
INSERT INTO colors VALUES (34,'#6495ED','瞿麦蓝');
INSERT INTO colors VALUES (48,'#DC143C','绯红色');
INSERT INTO colors VALUES (8,'#B8860B','深秋麒麟草');
INSERT INTO colors VALUES (17,'#006400','深绿色');
INSERT INTO colors VALUES (44,'#8B008B','深桃红色');
INSERT INTO colors VALUES (21,'#556B2F','深橄榄绿');
INSERT INTO colors VALUES (6,'#FF8C00','深橙色');
INSERT INTO colors VALUES (39,'#932CC','淡紫色');
INSERT INTO colors VALUES (40,'#483D8B','深灰蓝色');
INSERT INTO colors VALUES (30,'#2F4F4F','深岩灰色');
INSERT INTO colors VALUES (37,'#9400D3','暗紫色');
INSERT INTO colors VALUES (47,'#FF1493','深粉红色');
INSERT INTO colors VALUES (11,'#B22222','红砖色');
INSERT INTO colors VALUES (19,'#228B22','森林绿');
INSERT INTO colors VALUES (46,'#FF00FF','吊钟海棠色');
INSERT INTO colors VALUES (18,'#008000','绿色');
INSERT INTO colors VALUES (16,'#CD5C5C','印度红色');
INSERT INTO colors VALUES (36,'#4B0082','靛蓝色');
INSERT INTO colors VALUES (22,'#20B2AA','淡海绿色');
INSERT INTO colors VALUES (45,'#FF00FF','桃红色');
INSERT INTO colors VALUES (3,'#800000','褐紫红色');
INSERT INTO colors VALUES (27,'#0000CD','中度蓝色');
INSERT INTO colors VALUES (42,'#9370DB','中度紫色');
INSERT INTO colors VALUES (24,'#3CB371','中度海绿色');
INSERT INTO colors VALUES (49,'#C71585','紫红色');
INSERT INTO colors VALUES (29,'#191970','午夜蓝');
INSERT INTO colors VALUES (26,'#000080','海军蓝');
INSERT INTO colors VALUES (7,'#808000','橄榄色');
INSERT INTO colors VALUES (20,'#6B8E23','橄榄黄');
INSERT INTO colors VALUES (5,'#FF4500','橙红色');
INSERT INTO colors VALUES (13,'#CD853F','浅蓝色');
INSERT INTO colors VALUES (43,'#800080','紫色');
INSERT INTO colors VALUES (4,'#FF0000','红色');
INSERT INTO colors VALUES (31,'#4169E1','纯蓝色');
INSERT INTO colors VALUES (9,'#8B4513','马粽色');
INSERT INTO colors VALUES (23,'#2E8B57','海绿色');
INSERT INTO colors VALUES (12,'#A0522D','黄褐色');
INSERT INTO colors VALUES (35,'#708090','蓝灰色');
INSERT INTO colors VALUES (41,'#6A5ACD','灰蓝色');
INSERT INTO colors VALUES (32,'#4682B4','钢蓝色');
INSERT INTO colors VALUES (25,'#008080','蓝绿色');
INSERT INTO colors VALUES (14,'#FF6347','番茄红');
INSERT INTO colors VALUES (50,'#00FFFF','浅绿色');
INSERT INTO colors VALUES (51,'#808080','灰色');
INSERT INTO colors VALUES (52,'#00FF00','石灰色');
INSERT INTO colors VALUES (53,'#C0C0C0','银色');
INSERT INTO colors VALUES (54,'#FFFF00','黄色');
INSERT INTO colors VALUES (55,'#FFFFFF','白色');

--
-- Table structure for table 'defaultBibdatabases'
--

CREATE TABLE defaultBibdatabases (
  discipline_id int(6) default NULL,
  bib_database_id int(6) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'defaultBibdatabases'
--


INSERT INTO defaultBibdatabases VALUES (1,335);
INSERT INTO defaultBibdatabases VALUES (1,334);
INSERT INTO defaultBibdatabases VALUES (1,333);
INSERT INTO defaultBibdatabases VALUES (3,788);
INSERT INTO defaultBibdatabases VALUES (3,845);
INSERT INTO defaultBibdatabases VALUES (3,795);
INSERT INTO defaultBibdatabases VALUES (4,773);
INSERT INTO defaultBibdatabases VALUES (4,842);
INSERT INTO defaultBibdatabases VALUES (4,864);
INSERT INTO defaultBibdatabases VALUES (2,749);
INSERT INTO defaultBibdatabases VALUES (2,845);
INSERT INTO defaultBibdatabases VALUES (2,795);
INSERT INTO defaultBibdatabases VALUES (671,805);
INSERT INTO defaultBibdatabases VALUES (1,336);
INSERT INTO defaultBibdatabases VALUES (4,819);
INSERT INTO defaultBibdatabases VALUES (2,1741);
INSERT INTO defaultBibdatabases VALUES (677,768);
INSERT INTO defaultBibdatabases VALUES (677,828);
INSERT INTO defaultBibdatabases VALUES (677,1741);
INSERT INTO defaultBibdatabases VALUES (677,805);
INSERT INTO defaultBibdatabases VALUES (677,1740);
INSERT INTO defaultBibdatabases VALUES (610,347);
INSERT INTO defaultBibdatabases VALUES (3,820);
INSERT INTO defaultBibdatabases VALUES (3,1740);
INSERT INTO defaultBibdatabases VALUES (3,887);
INSERT INTO defaultBibdatabases VALUES (3,728);
INSERT INTO defaultBibdatabases VALUES (671,1740);
INSERT INTO defaultBibdatabases VALUES (671,956);
INSERT INTO defaultBibdatabases VALUES (671,896);
INSERT INTO defaultBibdatabases VALUES (671,883);
INSERT INTO defaultBibdatabases VALUES (673,836);
INSERT INTO defaultBibdatabases VALUES (673,885);
INSERT INTO defaultBibdatabases VALUES (673,884);
INSERT INTO defaultBibdatabases VALUES (673,793);
INSERT INTO defaultBibdatabases VALUES (673,905);
INSERT INTO defaultBibdatabases VALUES (673,823);
INSERT INTO defaultBibdatabases VALUES (673,904);
INSERT INTO defaultBibdatabases VALUES (673,1722);
INSERT INTO defaultBibdatabases VALUES (673,906);
INSERT INTO defaultBibdatabases VALUES (741,1004);
INSERT INTO defaultBibdatabases VALUES (741,1002);
INSERT INTO defaultBibdatabases VALUES (741,845);
INSERT INTO defaultBibdatabases VALUES (741,795);
INSERT INTO defaultBibdatabases VALUES (741,821);
INSERT INTO defaultBibdatabases VALUES (741,728);
INSERT INTO defaultBibdatabases VALUES (741,860);
INSERT INTO defaultBibdatabases VALUES (741,868);
INSERT INTO defaultBibdatabases VALUES (2,805);