[mapguide-users] utility map backup.sql file

[sidecar5]

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.