[BLOB], '2013-02-08 10:27:33', 'c5c2d042.jpg', 'sdergzedr', '1005840', 'c5c2d042.jpg', '', '');
INSERT INTO `image` (`id`, `thumbnail`, `big`, `created`, `name`, `description`, `size`, `alias`, `type`, `title`) VALUES
(7, 0x[BLOB], 0x[BLOB], '2013-02-08 13:25:47', '229.jpg', 'battleship', '66254', '229.jpg', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `alias` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `parent` bigint(255) NOT NULL,
  `sort` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `navigation` int(11) NOT NULL,
  `inherit` int(11) NOT NULL,
  `content` text NOT NULL,
  `custom` varchar(255) NOT NULL,
  `section` int(11) NOT NULL,
  `accessfrom` datetime NOT NULL,
  `accessto` datetime NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime DEFAULT NULL,
  `layer` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`,`section`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=74 ;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `alias`, `name`, `parent`, `sort`, `status`, `navigation`, `inherit`, `content`, `custom`, `section`, `accessfrom`, `accessto`, `created`, `modified`, `layer`) VALUES
(1, 'adminpage', 'Admin Page', 0, 2, 1, 1, 0, '', 'adminpage', 1, '1970-01-01 10:00:00', '2020-01-23 00:00:00', '0000-00-00 00:00:00', '2013-02-06 13:34:36', 0),
(2, 'adminuser', 'Admin User', 0, 3, 1, 1, 0, '<p>drfgsgr</p>\r\n', 'adminuser', 1, '2013-01-01 00:00:00', '2030-01-24 00:00:00', '0000-00-00 00:00:00', '2013-02-06 13:34:36', 0),
(3, 'error', 'Error', 0, 0, 1, 0, 0, '', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-01-14 00:00:00', '0000-00-00 00:00:00', 1),
(4, 'index', 'adminhome', 0, 1, 1, 0, 0, '<p>aefawefawefaweawefawef</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>thsfrhrt</p>\r\n\r\n<p>rtgbhrthrt</p>\r\n\r\n<table border="1" cellpadding="1" cellspacing="1" style="width: 500px;">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n', '', 1, '1970-01-01 10:00:00', '2020-01-23 00:00:00', '0000-00-00 00:00:00', '2013-02-06 13:34:36', 0),
(5, 'index', 'Home', 0, 1, 1, 1, 0, '<ol>\r\n	<li>ewawefae</li>\r\n	<li>waefawefwf</li>\r\n	<li>awefaweawfawf</li>\r\n</ol>\r\n\r\n<p><strong>1111111111111111</strong></p>\r\n', 'adminhome', 2, '1970-01-01 10:00:00', '2032-11-30 00:00:00', '0000-00-00 00:00:00', '2013-02-06 13:34:37', 0),
(6, 'TermsandConditions', 'Terms and Conditions', 31, 4, 1, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '0000-00-00 00:00:00', '2013-01-25 10:05:44', 0),
(7, 'site2', 'Site2', 5, 1, 1, 0, 0, '', '', 2, '2013-01-23 00:00:00', '2013-01-25 00:00:00', '0000-00-00 00:00:00', NULL, 0),
(8, 'TeacherGuide', 'Teacher Guide', 31, 5, 1, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '0000-00-00 00:00:00', '2013-01-25 10:05:44', 0),
(9, 'site4', 'Site 4', 7, 2, 1, 0, 0, '', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 0),
(30, 'test1', 'test1', 0, 2, 1, 0, 0, 'q', '', 2, '2013-01-24 00:00:00', '2013-04-25 09:35:00', '0000-00-00 00:00:00', '2013-02-06 13:34:36', 0),
(31, 'Registration', 'Registration', 5, 5, 1, 0, 0, '<p>&nbsp;\n<p>This is where the registration form will be...</p>\n</p>\n', '', 2, '2013-01-24 00:00:00', '2033-01-24 00:00:00', '0000-00-00 00:00:00', '2013-02-05 11:46:43', 0),
(32, 'GWRInformation', 'GWR information', 31, 3, 1, 0, 0, '<p>Gunniess&nbsp; Book of Records. Is here...</p>\n', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '0000-00-00 00:00:00', '2013-02-05 11:53:38', 0),
(33, 'VolunteersStewards', 'Volunteers & Stewards', 5, 6, 1, 0, 0, '<p>e</p>\n', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '0000-00-00 00:00:00', '2013-02-05 11:39:44', 0),
(34, 'test5', 'test5', 7, 1, 0, 0, 0, '', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 0),
(36, 'EventInfo', 'Event Information', 5, 1, 1, 0, 0, '<p>Welcome to the QMF...</p>\r\n\r\n<p>Here we go&trade;tttdfg dfgsdfg sfdgt</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>sergsgres</p>\r\n\r\n<p>rsgsergseg</p>\r\n', '', 2, '2013-01-01 00:00:00', '2033-01-31 00:00:00', '0000-00-00 00:00:00', '2013-02-06 11:48:47', 0),
(37, 'Music', 'Music', 31, 2, 1, 0, 0, '<p>Music</p>\n', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '2013-01-22 17:27:11', '2013-02-05 11:49:38', 0),
(39, 'SuncorpStadium', 'Suncorp Stadium', 5, 3, 1, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2030-09-01 00:00:00', '2013-01-24 11:53:02', '2013-02-05 11:46:18', 0),
(41, 'MarchRouteMaps', 'March route & maps', 5, 2, 1, 0, 0, '<p><big>hello world</big>...</p>\n\n<p>sdgflihdfgl dglijfg ;oisdffdgdf dfg dh fgh fsgh sh.. yj yj yk,,,,</p>\n\n<p>Hello</p>\n', '', 2, '2013-01-24 00:00:00', '2033-01-24 00:00:00', '2013-01-24 11:56:23', '2013-02-05 12:44:11', 0),
(42, 'Suncorp1', 'Suncorp1', 0, 0, 0, 0, 0, '', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-01-24 11:56:34', NULL, 0),
(43, 'FAQ', 'FAQ', 5, 4, 1, 0, 0, '<p>FAQ INformationdf&#39;</p>\n\n<p>Hello</p>\n', '', 2, '1970-01-01 10:00:00', '2033-04-01 00:00:00', '2013-01-24 12:00:28', '2013-02-05 12:43:48', 0),
(49, 'uniform', 'uniform', 30, 4, 0, 0, 0, '', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-01-24 12:22:18', '2013-01-24 14:17:03', 0),
(50, 'uniform123', 'Mermaids', 30, 1, 1, 0, 0, '<p>Thumbnail Image</p>\r\n\r\n<p><img alt="Name" src="http://localhost/JMSP/application/layouts/scripts/public/_assets/images/th-two.jpg" style="opacity: 0.9; width: 208px; height: 138px;" /></p>\r\n\r\n<p>Name</p>\r\n\r\n<p>Popup image name</p>\r\n\r\n<p>Description</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp; &nbsp;&nbsp;&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '', 2, '2013-01-24 00:00:00', '2013-01-24 00:00:00', '2013-01-24 12:22:38', '2013-02-06 11:17:29', 0),
(51, 'rrr', 'sertgrt', 30, 2, 0, 0, 0, '', '', 2, '1970-01-01 10:00:00', '1970-01-01 10:00:00', '2013-01-24 12:23:32', '2013-01-24 12:23:51', 0),
(52, 'r', 'r', 0, 0, 0, 0, 0, '<p><strong>hot dog</strong></p>\r\n', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-01-24 12:42:05', '2013-01-24 12:43:12', 0),
(53, 'New alias', '', 0, 0, 0, 0, 0, '', '', 0, '1970-01-01 10:00:00', '1970-01-01 10:00:00', '2013-01-24 12:59:38', NULL, 0),
(55, 'newer alias', '', 0, 6, 0, 0, 0, '<p>ertherthert</p>\r\n', '', 1, '1970-01-01 10:00:00', '1970-01-01 10:00:00', '2013-01-24 13:03:08', '2013-02-06 13:34:35', 0),
(56, 'www', 'ww', 30, 3, 0, 0, 0, '', '', 2, '1970-01-01 10:00:00', '1970-01-01 10:00:00', '2013-01-24 13:06:07', '2013-01-24 14:17:03', 0),
(58, 'admingroup', 'admingroup', 0, 4, 1, 1, 0, '', 'admingroup', 1, '2013-01-01 00:00:00', '2030-01-24 00:00:00', '2013-01-24 14:49:02', '2013-02-06 13:34:36', 0),
(59, 'Tutorials', 'Tutorials', 31, 1, 1, 0, 0, '<p>This is where the tutorials will be...</p>\n', '', 2, '1970-01-01 10:00:00', '2032-11-30 00:00:00', '2013-01-25 09:41:26', '2013-02-05 11:47:18', 0),
(60, 'Transport', 'Transport', 31, 6, 1, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2032-11-30 00:00:00', '2013-01-25 10:03:28', '2013-01-25 10:05:44', 0),
(61, 'Entertainment', 'Entertainment', 5, 7, 1, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2032-11-30 00:00:00', '2013-02-01 11:09:04', '2013-02-01 11:09:20', 0),
(62, 'Shift', 'shift', 0, 3, 0, 0, 0, '', '', 2, '1970-01-01 10:00:00', '2033-01-01 10:00:00', '2013-02-06 09:51:24', '2013-02-06 13:34:36', 0),
(63, 'Mermaids Pics', 'mermaids_Pics', 0, 0, 0, 0, 0, '<p><img alt="Description" src="http://localhost/JMSP/application/layouts/scripts/public/_assets/images/th-five.jpg" style="width: 208px; height: 138px; border-width: 10px; border-style: solid;" /></p>\r\n\r\n<p>Mermaids Pic 01</p>\r\n\r\n<p>Description</p>\r\n', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-02-06 11:07:29', '2013-02-06 11:11:09', 0),
(69, 'Mermaids Pics1', 'mermaids_Pics1', 0, 0, 0, 0, 0, '', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-02-06 11:17:53', NULL, 0),
(70, 'Mermaids Pics2', 'mermaids_Pics2', 0, 0, 0, 0, 0, '', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-02-06 11:18:05', NULL, 0),
(71, 'Mermaids Pics3', 'mermaids_Pics3', 0, 0, 0, 0, 0, '', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-02-06 11:22:07', NULL, 0),
(72, 'adminimage', 'adminImage', 0, 5, 1, 1, 0, '', 'adminimage', 1, '2013-02-06 00:00:00', '2033-03-08 00:00:00', '2013-02-06 13:34:28', '2013-02-06 13:34:35', 0),
(73, 'adminyoutube', 'adminyoutube', 0, 6, 1, 1, 0, '', 'adminyoutube', 1, '1970-01-01 10:00:00', '2032-11-30 00:00:00', '2013-02-08 10:53:41', NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `pageimage`
--

CREATE TABLE IF NOT EXISTS `pageimage` (
  `pageId` bigint(255) NOT NULL,
  `imageId` int(255) NOT NULL,
  PRIMARY KEY (`pageId`,`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pageimage`
--

INSERT INTO `pageimage` (`pageId`, `imageId`) VALUES
(41, 4),
(62, 1),
(73, 3);

-- --------------------------------------------------------

--
-- Table structure for table `pageyoutube`
--

CREATE TABLE IF NOT EXISTS `pageyoutube` (
  `pageId` int(255) NOT NULL,
  `youtubeId` int(255) NOT NULL,
  PRIMARY KEY (`pageId`,`youtubeId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pageyoutube`
--

INSERT INTO `pageyoutube` (`pageId`, `youtubeId`) VALUES
(62, 5);

-- --------------------------------------------------------

--
-- Table structure for table `ppath`
--

CREATE TABLE IF NOT EXISTS `ppath` (
  `pageID` bigint(255) NOT NULL,
  `pagePath` bigint(255) NOT NULL,
  PRIMARY KEY (`pageID`,`pagePath`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ppath`
--


-- --------------------------------------------------------

--
-- Table structure for table `section`
--

CREATE TABLE IF NOT EXISTS `section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alias` varchar(30) NOT NULL,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `section`
--

INSERT INTO `section` (`id`, `alias`, `name`) VALUES
(1, 'admin', 'Admin'),
(2, 'site', 'Site');

-- --------------------------------------------------------

--
-- Table structure for table `ug`
--

CREATE TABLE IF NOT EXISTS `ug` (
  `userID` bigint(255) NOT NULL,
  `groupID` bigint(255) NOT NULL,
  PRIMARY KEY (`userID`,`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ug`
--

INSERT INTO `ug` (`userID`, `groupID`) VALUES
(0, 1),
(1, 1),
(1, 2),
(2, 1),
(23, 1),
(24, 2),
(25, 1),
(26, 1);

-- --------------------------------------------------------

--
-- Table structure for table `youtube`
--

CREATE TABLE IF NOT EXISTS `youtube` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `thumbnail` mediumblob NOT NULL,
  `name` varchar(255) NOT NULL,
  `size` int(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `youtube`
--

INSERT INTO `youtube` (`id`, `url`, `thumbnail`, `name`, `size`, `type`, `created`, `description`) VALUES
(2, 'http://www.youtube.com/watch?v=YPjXxKpM4DM', 0x[BLOB], 'images (1).jpg', 6494, 'image/jpeg', '0000-00-00 00:00:00', '																			eee																	'),
(4, 'http://www.youtube.com/watch?v=YPjXxKpM4DM', 0x[BLOB], 'SANY0333.JPG', 369345, 'image/jpeg', '0000-00-00 00:00:00', '											weawfawfawefawefawef					'),
(5, 'www.youtube.com/watch?v=YPjXxKpM4DM', 0x[BLOB], 'Uss_maine_color.jpg', 1597845, 'image/jpeg', '0000-00-00 00:00:00', '																');
