Hi, for anyone who has tried the scripted demo and found this file missing, here it is. Cheers, Peter
-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.51b-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema utilitymap -- CREATE DATABASE IF NOT EXISTS utilitymap; USE utilitymap; -- -- Definition of table `workorder` -- DROP TABLE IF EXISTS `workorder`; CREATE TABLE `workorder` ( `ID` int(10) unsigned NOT NULL auto_increment, `WODesc` varchar(255) default NULL, `WOType` varchar(255) default NULL, `X` double NOT NULL, `Y` double NOT NULL, `WODate` datetime default NULL, `WODateComplete` datetime default NULL, `WOAssignedTo` varchar(255) default NULL, `WOComplete` tinyint(1) default '0', PRIMARY KEY (`ID`), KEY `XY` (`X`,`Y`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `workorder` -- /*!40000 ALTER TABLE `workorder` DISABLE KEYS */; INSERT INTO `workorder` (`ID`,`WODesc`,`WOType`,`X`,`Y`,`WODate`,`WODateComplete`,`WOAssignedTo`,`WOComplete`) VALUES (1,'Fri Feb 20 2009 10:32:55 GMT-0800 (Pacific Standard Time)','Repair',1903390.4583197,452302.861846785,'2009-02-20 00:00:00',NULL,'Arnab',0), (2,'Fri Feb 20 2009 10:34:20 GMT-0800 (Pacific Standard Time)','Sched Maint',1903207.17855498,447537.58796392,'2009-02-20 00:00:00',NULL,'Arnab',1), (3,'Fri Feb 20 2009 11:18:27 GMT-0800 (Pacific Standard Time)','Repair',1886162.1604355,449370.385611176,'2009-02-20 00:00:00',NULL,'',0); /*!40000 ALTER TABLE `workorder` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -- View this message in context: http://osgeo-org.1560.n6.nabble.com/utility-map-backup-sql-file-tp5008604p5009994.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
