structure-only.sql

我的图书馆或资料库

# structure-only.sql - a set of SQL statements that create
#                      a database compatible with MyLibrary.pm
#                      version 2.60. These statements only
#                      create an empty database with the
#                      exception of content for the simple help
#                      texts, colors, and ranks. Put another way,
#                      this script is for institutions who want
#                      to use MyLibrary, but who also
#                      want to start out with a clean slate.
#                      (This is not a recommended approach since
#                      it is easy enough to delete sample data
#                      items using the administrative interface,
#                      but to each his own.)
#
# Sample usage from the Unix command line:
#
#    mysql -umylibrary -p mylibrary < structure-only.sql
#
# For more information about MyLibrary see:
#
#   http://dewey.library.nd.edu/mylibrary/
#
# Eric Lease Morgan <[e-mail]>
# University Libraries of Notre Dame
#
# December 23, 2002

# MySQL dump 8.14
#
# Host: localhost    Database: sandbox
#--------------------------------------------------------
# Server version	3.23.41-log

#
# Table structure for table 'bib_databases'
#

CREATE TABLE bib_databases (
  bib_database_id int(6) NOT NULL default '0',
  bib_database_name varchar(255) default NULL,
  bib_database_url varchar(255) default NULL,
  bib_database_note varchar(255) default NULL,
  bib_database_fkey varchar(255) NOT NULL default '',
  bib_database_date date NOT NULL default '0000-00-00',
  bib_database_lcd int(1) NOT NULL default '0',
  PRIMARY KEY  (bib_database_id)
) TYPE=MyISAM;

#
# Table structure for table 'colors'
#

CREATE TABLE colors (
  color_id int(6) NOT NULL default '0',
  color_code varchar(7) default NULL,
  color_name varchar(255) default NULL,
  PRIMARY KEY  (color_id)
) TYPE=MyISAM;

#
# Data for table 'colors'
#

INSERT INTO colors VALUES (2,'#000000','Black');
INSERT INTO colors VALUES (28,'#0000FF','Blue');
INSERT INTO colors VALUES (38,'#8A2BE2','Blue Violet');
INSERT INTO colors VALUES (33,'#5F9EA0','Cadet Blue');
INSERT INTO colors VALUES (10,'#D2691E','Chocolate');
INSERT INTO colors VALUES (15,'#FF7F50','Coral');
INSERT INTO colors VALUES (34,'#6495ED','Corn Flower Blue');
INSERT INTO colors VALUES (48,'#DC143C','Crimson');
INSERT INTO colors VALUES (8,'#B8860B','Dark Goldenrod');
INSERT INTO colors VALUES (17,'#006400','Dark Green');
INSERT INTO colors VALUES (44,'#8B008B','Dark Magenta');
INSERT INTO colors VALUES (21,'#556B2F','Dark Olive Green');
INSERT INTO colors VALUES (6,'#FF8C00','Dark Orange');
INSERT INTO colors VALUES (39,'#932CC','Dark Orchid');
INSERT INTO colors VALUES (40,'#483D8B','Dark Slate Blue');
INSERT INTO colors VALUES (30,'#2F4F4F','Dark Slate Gray');
INSERT INTO colors VALUES (37,'#9400D3','Dark Violet');
INSERT INTO colors VALUES (47,'#FF1493','Deep Pink');