structure-only.sql

我的图书馆或资料库

  discipline_id int(6) default NULL,
  qsearch_id int(6) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'defaultReferences'
#

CREATE TABLE defaultReferences (
  discipline_id int(6) default NULL,
  reference_id int(6) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'defaultUniversity'
#

CREATE TABLE defaultUniversity (
  discipline_id int(6) default NULL,
  university_id int(6) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'disciplines'
#

CREATE TABLE disciplines (
  discipline_id int(6) NOT NULL default '0',
  discipline_name varchar(255) default NULL,
  motd_text blob,
  PRIMARY KEY  (discipline_id)
) TYPE=MyISAM;

#
# Table structure for table 'etexts'
#

CREATE TABLE etexts (
  etext_id int(6) NOT NULL default '0',
  etext_name varchar(255) default NULL,
  etext_url varchar(255) default NULL,
  etext_note varchar(255) default NULL,
  etext_fkey varchar(255) NOT NULL default '',
  etext_date date NOT NULL default '0000-00-00',
  etext_lcd int(1) NOT NULL default '0',
  PRIMARY KEY  (etext_id)
) TYPE=MyISAM;

#
# Table structure for table 'guestbook'
#

CREATE TABLE guestbook (
  name varchar(255) default NULL,
  email varchar(255) default NULL,
  can_contact int(1) default NULL,
  date_visited varchar(10) default NULL
) TYPE=MyISAM;

#
# Table structure for table 'help_simple'
#

CREATE TABLE help_simple (
  help_id int(6) NOT NULL default '0',
  help_title varchar(255) default NULL,
  help_text blob,
  PRIMARY KEY  (help_id)
) TYPE=MyISAM;

#
# Data for table 'help_simple'
#

INSERT INTO help_simple VALUES (1,'Customize Quick Searches','<!--USER-->\n\n<blockquote>\n\n<big>\n\n<p>\n\nYou may select the resources you would like to be able to search from your MyLibrary page. They will appear as resources in your Quick Searches drop-down menu of resources.\n\n</p>\n\n</big>\n\n</blockquote>');
INSERT INTO help_simple VALUES (2,'Customize bibliographic databases','<!--USER-->\n\n<blockquote>\n\nUse this page to customize your database selections.<p>\n\nThese are your current selections. You may remove  items by clicking to eliminate the check mark, then select \'Customize\' to activate your change.\n\n</blockquote>');
INSERT INTO help_simple VALUES (3,'Customize University links','<!--USER-->\n\n<blockquote>\n\n<big>\n\n<p>\n\nThe MyLibrary system allows you to personally customize the university links which appear on your page.  Use the check boxes on the left to select or remove items.\n\n</p>\n\n<p>\n\nThis is a select group of University links. If the one you need is not here then you may either add it using the Personal Links option or send a message to your librarian asking that the link be considered.\n\n</p>\n\n</big>\n\n</blockquote>');
INSERT INTO help_simple VALUES (4,'Customize electronic journals','<!--USER-->\n\n<blockquote>\n\n<big>\n\n<p>\n\nUse this page to edit your\n\nelectronic journal selections.\n\nRemember, a journal may appear\n\nin more than one subject area.\n\n</p>\n\n</big>\n\n</blockquote>');
INSERT INTO help_simple VALUES (5,'Customize reference shelf','<!--USER-->\n\n<blockquote>\n\n<big>\n\n<p>\n\nTo remove items from your Reference Shelf, unselect any of the checkboxed items below.\n\n</p>\n\n</big>\n\n</blockquote>');
INSERT INTO help_simple VALUES (6,'Customize personal links','<!--USER-->\n\n<blockquote>\n\n<big>\n\nUse this page to edit your\n\nyour personal selection of \n\ninternet resources.</big>\n\n</blockquote>');
INSERT INTO help_simple VALUES (7,'Customize NCSU Libraries','<!--USER-->\n\n<blockquote>\n\n<big>\n\n<p>\n\nUse this page to edit your selection of NCSU Library links.\n\n<p>\n\n</big>\n\n</blockquote>');