[Strandmapservic-developers] smsServer/WEB-INF/Database strandmap.sql, 1.2, 1.3

[John W. <jwe...@us...>]

Update of /cvsroot/strandmapservic/smsServer/WEB-INF/Database
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv3780/WEB-INF/Database

Modified Files:
	strandmap.sql 
Log Message:
-added new maps from Atlas II

Index: strandmap.sql
===================================================================
RCS file: /cvsroot/strandmapservic/smsServer/WEB-INF/Database/strandmap.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** strandmap.sql	12 Nov 2007 22:36:49 -0000	1.2
--- strandmap.sql	11 Mar 2008 22:37:00 -0000	1.3
***************
*** 1,5886 ****
! DROP TABLE IF EXISTS `objects`;
! CREATE TABLE objects (`ExternalResources` longtext NULL,`Standards` longtext NULL,`object_type` varchar (255) NOT NULL ,`object_ID` varchar (255) NOT NULL ,`Name` text NOT NULL ,`source` varchar (255) NULL,`primary_grade` varchar (255) NULL,`second_grade` varchar (255) NULL,`record_status` varchar (255) NULL,`full_text` text NULL,`description` text NULL,`subjects` varchar (255) NULL,`keywords` text NULL,`metadata_code` varchar (255) NULL,`metadata_lan` varchar (255) NULL,`date_created` date NULL,`clarification` longtext NULL,`student_conceptions` longtext NULL,`examples` longtext NULL,`assessments` longtext NULL,`instructional_information` longtext NULL,`serial` varchar (255) NULL,`aaas_code` varchar (255) NULL,`code_plus` varchar (255) NULL, PRIMARY KEY  (object_ID));
! DROP TABLE IF EXISTS `registeredqueries`;
! CREATE TABLE registeredqueries (`PublishedName` varchar (255) NOT NULL ,`QueryHost` longtext NULL,`QueryString` longtext NOT NULL ,`AuthenticationCode` varchar (255) NULL,`Encoding` enum ('UTF-8','ASCII','Cp1252','ISO8859_1','UnicodeBig','UnicodeBigUnmarked','UnicodeLittle','UnicodeLittleUnmarked','UTF8','UTF-16','MIN-URL','None') NOT NULL ,`Status` enum ('Enable','Disable') NOT NULL ,`ObjectName` varchar (100) NOT NULL , PRIMARY KEY  (ObjectName, PublishedName));
! DROP TABLE IF EXISTS `relation`;
! CREATE TABLE relation (`ItemID1` varchar (255) NOT NULL ,`ItemID2` varchar (255) NOT NULL ,`RelationType` varchar (255) NOT NULL , PRIMARY KEY  (ItemID1, ItemID2));
! DROP TABLE IF EXISTS `strandpos`;
! CREATE TABLE strandpos (`object_ID` varchar (100) NOT NULL ,`Pos` varchar (100) NOT NULL , PRIMARY KEY  (object_ID));
! 
! LOCK TABLES `objects` WRITE;
[...23262 lines suppressed...]
! INSERT INTO strandpos VALUES ('SMS-STD-2519', '4');
! INSERT INTO strandpos VALUES ('SMS-STD-2520', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-2521', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-2522', '1');
! INSERT INTO strandpos VALUES ('SMS-STD-2523', '3');
! INSERT INTO strandpos VALUES ('SMS-STD-2532', '1');
! INSERT INTO strandpos VALUES ('SMS-STD-2533', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-2534', '3');
! INSERT INTO strandpos VALUES ('SMS-STD-2562', '1');
! INSERT INTO strandpos VALUES ('SMS-STD-2563', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-2564', '3');
! INSERT INTO strandpos VALUES ('SMS-STD-2565', '4');
! INSERT INTO strandpos VALUES ('SMS-STD-9002', '1');
! INSERT INTO strandpos VALUES ('SMS-STD-9003', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-9004', '3');
! INSERT INTO strandpos VALUES ('SMS-STD-9031', '1');
! INSERT INTO strandpos VALUES ('SMS-STD-9032', '2');
! INSERT INTO strandpos VALUES ('SMS-STD-9033', '3');
! INSERT INTO strandpos VALUES ('SMS-STD-9034', '4');
! UNLOCK TABLES;