structure-only.sql

我的图书馆或资料库

INSERT INTO colors VALUES (11,'#B22222','Fire Brick');
INSERT INTO colors VALUES (19,'#228B22','Forest Green');
INSERT INTO colors VALUES (46,'#FF00FF','Fuchsia');
INSERT INTO colors VALUES (18,'#008000','Green');
INSERT INTO colors VALUES (16,'#CD5C5C','Indian Red');
INSERT INTO colors VALUES (36,'#4B0082','Indigo');
INSERT INTO colors VALUES (22,'#20B2AA','Light Sea Green');
INSERT INTO colors VALUES (45,'#FF00FF','Magenta');
INSERT INTO colors VALUES (3,'#800000','Maroon');
INSERT INTO colors VALUES (27,'#0000CD','Medium Blue');
INSERT INTO colors VALUES (42,'#9370DB','Medium Purple');
INSERT INTO colors VALUES (24,'#3CB371','Medium Sea Green');
INSERT INTO colors VALUES (49,'#C71585','Medium Violet Red');
INSERT INTO colors VALUES (29,'#191970','Midnight Blue');
INSERT INTO colors VALUES (26,'#000080','Navy');
INSERT INTO colors VALUES (7,'#808000','Olive');
INSERT INTO colors VALUES (20,'#6B8E23','Olive Drab');
INSERT INTO colors VALUES (5,'#FF4500','Orange Red');
INSERT INTO colors VALUES (13,'#CD853F','Peru');
INSERT INTO colors VALUES (43,'#800080','Purple');
INSERT INTO colors VALUES (4,'#FF0000','Red');
INSERT INTO colors VALUES (31,'#4169E1','Royal Blue');
INSERT INTO colors VALUES (9,'#8B4513','Saddle Brown');
INSERT INTO colors VALUES (23,'#2E8B57','Sea Green');
INSERT INTO colors VALUES (12,'#A0522D','Sienna');
INSERT INTO colors VALUES (35,'#708090','Slate Gray');
INSERT INTO colors VALUES (41,'#6A5ACD','SlateBlue');
INSERT INTO colors VALUES (32,'#4682B4','Steel Blue');
INSERT INTO colors VALUES (25,'#008080','Teal');
INSERT INTO colors VALUES (14,'#FF6347','Tomato');
INSERT INTO colors VALUES (50,'#00FFFF','Aqua');
INSERT INTO colors VALUES (51,'#808080','Gray');
INSERT INTO colors VALUES (52,'#00FF00','Lime');
INSERT INTO colors VALUES (53,'#C0C0C0','Silver');
INSERT INTO colors VALUES (54,'#FFFF00','Yellow');
INSERT INTO colors VALUES (55,'#FFFFFF','White');


#
# Table structure for table 'defaultBibdatabases'
#

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

#
# Table structure for table 'defaultEtexts'
#

CREATE TABLE defaultEtexts (
  discipline_id int(6) default NULL,
  etext_id int(6) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'defaultLibraries'
#

CREATE TABLE defaultLibraries (
  discipline_id int(6) default NULL,
  libraries_id int(6) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'defaultProfiles'
#

CREATE TABLE defaultProfiles (
  defaultProfile_id int(6) NOT NULL default '0',
  discipline_id int(6) NOT NULL default '0',
  lower_bounds varchar(255) NOT NULL default '',
  upper_bounds varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Table structure for table 'defaultQseaches'
#

CREATE TABLE defaultQseaches (