ch18data.sql

python web programming 部分

# MySQL dump 8.16
#
# Host: localhost    Database: test
#--------------------------------------------------------
# Server version	3.23.43

#
# Table structure for table 'canteach'
#

CREATE TABLE canteach (
  CrsNum int(11) NOT NULL default '0',
  InsNum int(11) NOT NULL default '0',
  PRIMARY KEY  (InsNum,CrsNum)
) TYPE=MyISAM;

#
# Dumping data for table 'canteach'
#

INSERT INTO canteach VALUES (101,1);
INSERT INTO canteach VALUES (201,1);
INSERT INTO canteach VALUES (301,1);
INSERT INTO canteach VALUES (401,1);
INSERT INTO canteach VALUES (101,2);
INSERT INTO canteach VALUES (201,2);
INSERT INTO canteach VALUES (101,3);
INSERT INTO canteach VALUES (301,3);

#
# Table structure for table 'city'
#

CREATE TABLE city (
  CtyNum int(11) NOT NULL default '0',
  CtyName char(50) NOT NULL default '',
  PRIMARY KEY  (CtyNum)
) TYPE=MyISAM;

#
# Dumping data for table 'city'
#

INSERT INTO city VALUES (1,'Washington DC');
INSERT INTO city VALUES (2,'New York');
INSERT INTO city VALUES (3,'Boston');
INSERT INTO city VALUES (4,'San Francisco');
INSERT INTO city VALUES (5,'Dallas, Texas');
INSERT INTO city VALUES (6,'Seattle');

#
# Table structure for table 'class'
#

CREATE TABLE class (
  ClsNum int(11) NOT NULL default '0',
  LocNum int(11) NOT NULL default '0',
  CrsNum int(11) NOT NULL default '0',
  ClsDate datetime NOT NULL default '0000-00-00 00:00:00',
  InsNum int(11) default '0',
  ClsPublic tinyint(1) default '0',
  PRIMARY KEY  (ClsNum)
) TYPE=MyISAM;

#
# Dumping data for table 'class'
#

INSERT INTO class VALUES (2000001,1,101,'2002-01-07 00:00:00',1,1);
INSERT INTO class VALUES (2000002,2,101,'2002-01-09 00:00:00',1,1);
INSERT INTO class VALUES (2000003,1,201,'2002-01-15 00:00:00',2,1);
INSERT INTO class VALUES (2000004,1,301,'2002-01-16 00:00:00',2,1);
INSERT INTO class VALUES (2000005,2,401,'2002-01-17 00:00:00',1,1);
INSERT INTO class VALUES (2000006,3,101,'2002-01-15 00:00:00',3,1);
INSERT INTO class VALUES (2000007,3,201,'2002-01-16 00:00:00',3,1);
INSERT INTO class VALUES (2000008,3,301,'2002-01-17 00:00:00',2,1);
INSERT INTO class VALUES (2000009,4,101,'2002-01-22 00:00:00',1,1);
INSERT INTO class VALUES (2000010,4,201,'2002-01-23 00:00:00',2,1);
INSERT INTO class VALUES (2000011,4,301,'2002-01-24 00:00:00',2,1);
INSERT INTO class VALUES (2000012,5,101,'2002-01-29 00:00:00',3,1);
INSERT INTO class VALUES (2000013,5,201,'2002-01-30 00:00:00',3,1);
INSERT INTO class VALUES (2000014,5,301,'2002-01-31 00:00:00',3,1);
INSERT INTO class VALUES (2000015,5,401,'2002-02-01 00:00:00',1,1);
INSERT INTO class VALUES (2000016,6,101,'2002-02-05 00:00:00',2,1);
INSERT INTO class VALUES (2000017,6,201,'2002-02-06 00:00:00',2,1);
INSERT INTO class VALUES (2000018,6,101,'2002-02-07 00:00:00',2,1);
INSERT INTO class VALUES (2000019,6,201,'2002-02-08 00:00:00',2,1);
INSERT INTO class VALUES (2000020,7,101,'2002-02-12 00:00:00',3,1);
INSERT INTO class VALUES (2000021,7,201,'2002-02-13 00:00:00',3,1);
INSERT INTO class VALUES (2000022,7,301,'2002-02-14 00:00:00',3,1);
INSERT INTO class VALUES (2000023,7,401,'2002-02-15 00:00:00',1,1);
INSERT INTO class VALUES (2000024,2,101,'2002-02-19 00:00:00',2,1);
INSERT INTO class VALUES (2000025,2,201,'2002-02-20 00:00:00',2,1);
INSERT INTO class VALUES (2000026,2,301,'2002-02-21 00:00:00',3,1);
INSERT INTO class VALUES (2000027,2,401,'2002-02-22 00:00:00',1,1);

#
# Table structure for table 'control'
#

CREATE TABLE control (
  CtlVersion int(11) NOT NULL default '0',
  CrDT datetime default NULL,
  MoDT datetime default NULL,
  CtlNxtNews int(11) NOT NULL default '0',
  CtlNxtLink int(11) default NULL,
  PRIMARY KEY  (CtlVersion)
) TYPE=MyISAM;

#
# Dumping data for table 'control'
#


#
# Table structure for table 'course'
#

CREATE TABLE course (
  CrsNum int(11) NOT NULL default '0',
  CrsTitle varchar(50) NOT NULL default '',
  CrsAuthor int(11) NOT NULL default '0',
  CrsDescription longtext NOT NULL,
  CrsPlaces int(11) default '0',
  CrsPrice int(11) default '0',
  PRIMARY KEY  (CrsNum)
) TYPE=MyISAM;

#
# Dumping data for table 'course'
#

INSERT INTO course VALUES (101,'Introduction to Python',1,'A basic introduction to all aspects of Python programming.',12,395);
INSERT INTO course VALUES (201,'Python Network Programming',2,'The basics of programming network-based systems.',12,495);
INSERT INTO course VALUES (301,'Python Database Programming',3,'Describes the fundamentals of the Python DB API and how to use the various modules which conform to it.',12,495);
INSERT INTO course VALUES (401,'Python Web Programming',1,'Describes all aspects of Python web integration.',8,595);

#
# Table structure for table 'department'
#

CREATE TABLE department (
  DptCode varchar(8) NOT NULL default '',
  CrDT datetime default NULL,
  MoDT datetime default NULL,
  DptName varchar(50) NOT NULL default '',
  DptWelcome longtext,
  DptLnksTxt longtext NOT NULL,
  DptExOff varchar(50) default NULL,
  DptRegOn varchar(50) default NULL,
  DptRegOff varchar(50) default NULL,
  DptFndTrn varchar(50) default NULL,
  DptTstPrp varchar(50) default NULL,
  DptTrnFnd varchar(50) default NULL,
  DptVrtTr tinyint(1) NOT NULL default '0',
  DptCrtNws tinyint(1) NOT NULL default '0',
  DptGetCrt tinyint(1) NOT NULL default '0',
  DptDiscuss tinyint(1) NOT NULL default '0',
  DptJobPst tinyint(1) NOT NULL default '0',
  DptLinks tinyint(1) NOT NULL default '0',
  DptTfGroup varchar(15) default NULL,
  PRIMARY KEY  (DptCode)
) TYPE=MyISAM;

#
# Dumping data for table 'department'
#

INSERT INTO department VALUES ('colophon',NULL,NULL,'Colophon','<B><I>The Object-Oriented Web</I></B><BR>\r\nWould you like some <a HREF=\"/DeptPgPage/colophon/objmodel/1\">background information</A> on the  technologies this web uses.<BR><BR>\r\n<B>Test Links</B><BR>\r\n<A HREF=\"/Auth/Secret/\">Authenticated Dynamic Page</A>: username <I>[e-mail]</I>, password <I>dorothy</I><BR>\r\n<A HREF=\"/Text/Windows.htm\">Authenticated HTML</A><BR>\r\n<A HREF=\"/Auth/Secret2/\">Authenticated Dynamic Page</A>: Both these\r\npages use username <I>steve</I> and password <I>dapple</I>.','<AHREF=\"mailto:[e-mail]\">Contact us</A> to suggest OO reading material to add to this site.',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL);
INSERT INTO department VALUES ('compend',NULL,NULL,'Compendium','<P><FONT SIZE=\"-2\">September, 2000</FONT><BR>\r\n<B>The measure</B> of the integrity of any &quot;government&quot;  is the degree it\r\nreflects the volition of it抯 empowering body. The\r\npeople. What is the difference between\r\nwhat is said and what our government does? On deeper reflection, this question\r\nbecomes unpalatable. For it measures\r\nthe integrity of the empowering entity itself.\r\nThe people.</p>\r\n\r\n<p>None\r\nof <b>US</b> wants to face the harsh\r\nshortcoming of the 慶hasm