-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2011 年 10 月 12 日 02:36
-- 服务器版本: 5.1.58
-- PHP 版本: 5.2.9




--
-- 数据库: `topofor1_cnc1`
--

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

--
-- 表的结构 `AreaGroupBlockTypes`
--

CREATE TABLE IF NOT EXISTS `AreaGroupBlockTypes` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `btID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`arHandle`,`gID`,`uID`,`btID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `AreaGroups`
--

CREATE TABLE IF NOT EXISTS `AreaGroups` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `agPermissions` varchar(64) NOT NULL,
  PRIMARY KEY (`cID`,`arHandle`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `Areas`
--

CREATE TABLE IF NOT EXISTS `Areas` (
  `arID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `arOverrideCollectionPermissions` tinyint(1) NOT NULL DEFAULT '0',
  `arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`arID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

--
-- 转存表中的数据 `Areas`
--

INSERT INTO `Areas` (`arID`, `cID`, `arHandle`, `arOverrideCollectionPermissions`, `arInheritPermissionsFromAreaOnCID`) VALUES
(1, 1, 'Header Nav', 0, 0),
(2, 1, 'Header', 0, 0),
(3, 1, 'Sidebar', 0, 0),
(4, 1, 'Main', 0, 0),
(5, 2, 'Header Nav', 0, 0),
(6, 2, 'Header', 0, 0),
(7, 2, 'Sidebar', 0, 0),
(8, 2, 'Main', 0, 0),
(9, 64, 'Header Nav', 0, 0),
(10, 64, 'Header', 0, 0),
(11, 64, 'Sidebar', 0, 0),
(12, 64, 'Main', 0, 0),
(13, 65, 'Header Nav', 0, 0),
(14, 65, 'Header', 0, 0),
(15, 65, 'Main', 0, 0),
(16, 66, 'Blog Post Header', 0, 0),
(17, 66, 'Main', 0, 0),
(18, 66, 'Blog Post More', 0, 0),
(19, 66, 'Blog Post Footer', 0, 0),
(20, 66, 'Header Nav', 0, 0),
(21, 66, 'Header', 0, 0),
(22, 66, 'Sidebar', 0, 0),
(23, 67, 'Header Nav', 0, 0),
(24, 67, 'Header', 0, 0),
(25, 67, 'Sidebar', 0, 0),
(26, 67, 'Main', 0, 0),
(27, 68, 'Header Nav', 0, 0),
(28, 68, 'Header', 0, 0),
(29, 68, 'Sidebar', 0, 0),
(30, 68, 'Main', 0, 0),
(31, 69, 'Header Nav', 0, 0),
(32, 69, 'Header', 0, 0),
(33, 69, 'Sidebar', 0, 0),
(34, 69, 'Main', 0, 0),
(35, 70, 'Header Nav', 0, 0),
(36, 70, 'Header', 0, 0),
(37, 70, 'Sidebar', 0, 0),
(38, 70, 'Main', 0, 0),
(39, 71, 'Header Nav', 0, 0),
(40, 71, 'Header', 0, 0),
(41, 71, 'Sidebar', 0, 0),
(42, 71, 'Main', 0, 0),
(43, 72, 'Header Nav', 0, 0),
(44, 72, 'Header', 0, 0),
(45, 72, 'Blog Post Header', 0, 0),
(46, 72, 'Main', 0, 0),
(47, 72, 'Blog Post More', 0, 0),
(48, 72, 'Blog Post Footer', 0, 0),
(49, 72, 'Sidebar', 0, 0),
(50, 13, 'Main', 0, 0),
(51, 73, 'Header Nav', 0, 0),
(52, 73, 'Header', 0, 0),
(53, 73, 'Blog Post Header', 0, 0),
(54, 73, 'Main', 0, 0),
(55, 73, 'Blog Post More', 0, 0),
(56, 73, 'Blog Post Footer', 0, 0),
(57, 73, 'Sidebar', 0, 0),
(58, 36, 'Global', 0, 0);

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

--
-- 表的结构 `atAddress`
--

CREATE TABLE IF NOT EXISTS `atAddress` (
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_province` varchar(255) DEFAULT NULL,
  `country` varchar(4) DEFAULT NULL,
  `postal_code` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atAddressCustomCountries`
--

CREATE TABLE IF NOT EXISTS `atAddressCustomCountries` (
  `atAddressCustomCountryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `country` varchar(5) NOT NULL,
  PRIMARY KEY (`atAddressCustomCountryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `atAddressSettings`
--

CREATE TABLE IF NOT EXISTS `atAddressSettings` (
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `akHasCustomCountries` int(1) NOT NULL DEFAULT '0',
  `akDefaultCountry` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atBoolean`
--

CREATE TABLE IF NOT EXISTS `atBoolean` (
  `avID` int(10) unsigned NOT NULL,
  `value` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `atBoolean`
--

INSERT INTO `atBoolean` (`avID`, `value`) VALUES
(14, 0),
(18, 1),
(23, 0),
(27, 0),
(31, 0),
(35, 0),
(39, 0),
(44, 0);

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

--
-- 表的结构 `atBooleanSettings`
--

CREATE TABLE IF NOT EXISTS `atBooleanSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akCheckedByDefault` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atDateTime`
--

CREATE TABLE IF NOT EXISTS `atDateTime` (
  `avID` int(10) unsigned NOT NULL,
  `value` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atDateTimeSettings`
--

CREATE TABLE IF NOT EXISTS `atDateTimeSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akDateDisplayMode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atDefault`
--

CREATE TABLE IF NOT EXISTS `atDefault` (
  `avID` int(10) unsigned NOT NULL,
  `value` longtext,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `atDefault`
--

INSERT INTO `atDefault` (`avID`, `value`) VALUES
(11, ''),
(12, ''),
(13, ''),
(15, ''),
(16, ''),
(17, ''),
(20, ''),
(21, ''),
(22, ''),
(24, ''),
(25, ''),
(26, ''),
(28, ''),
(29, ''),
(30, ''),
(32, ''),
(33, ''),
(34, ''),
(36, ''),
(37, ''),
(38, ''),
(41, ''),
(42, ''),
(43, '');

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

--
-- 表的结构 `atFile`
--

CREATE TABLE IF NOT EXISTS `atFile` (
  `avID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `atNumber`
--

CREATE TABLE IF NOT EXISTS `atNumber` (
  `avID` int(10) unsigned NOT NULL,
  `value` decimal(14,4) DEFAULT '0.0000',
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `atNumber`
--

INSERT INTO `atNumber` (`avID`, `value`) VALUES
(1, 800.0000),
(2, 192.0000),
(3, 800.0000),
(4, 192.0000),
(5, 800.0000),
(6, 192.0000),
(7, 800.0000),
(8, 215.0000),
(9, 800.0000),
(10, 192.0000);

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

--
-- 表的结构 `atSelectOptions`
--

CREATE TABLE IF NOT EXISTS `atSelectOptions` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akID` int(10) unsigned DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `displayOrder` int(10) unsigned DEFAULT NULL,
  `isEndUserAdded` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 转存表中的数据 `atSelectOptions`
--

INSERT INTO `atSelectOptions` (`ID`, `akID`, `value`, `displayOrder`, `isEndUserAdded`) VALUES
(1, 11, 'sample', 0, 1),
(2, 11, 'Hello World', 1, 1);

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

--
-- 表的结构 `atSelectOptionsSelected`
--

CREATE TABLE IF NOT EXISTS `atSelectOptionsSelected` (
  `avID` int(10) unsigned NOT NULL,
  `atSelectOptionID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`avID`,`atSelectOptionID`),
  KEY `atSelectOptionID` (`atSelectOptionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `atSelectOptionsSelected`
--

INSERT INTO `atSelectOptionsSelected` (`avID`, `atSelectOptionID`) VALUES
(40, 1),
(40, 2),
(45, 1);

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

--
-- 表的结构 `atSelectSettings`
--

CREATE TABLE IF NOT EXISTS `atSelectSettings` (
  `akID` int(10) unsigned NOT NULL,
  `akSelectAllowMultipleValues` tinyint(1) NOT NULL DEFAULT '0',
  `akSelectOptionDisplayOrder` varchar(255) NOT NULL DEFAULT 'display_asc',
  `akSelectAllowOtherValues` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `atSelectSettings`
--

INSERT INTO `atSelectSettings` (`akID`, `akSelectAllowMultipleValues`, `akSelectOptionDisplayOrder`, `akSelectAllowOtherValues`) VALUES
(11, 1, 'display_asc', 1);

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

--
-- 表的结构 `atTextareaSettings`
--

CREATE TABLE IF NOT EXISTS `atTextareaSettings` (
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `akTextareaDisplayMode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `AttributeKeyCategories`
--

CREATE TABLE IF NOT EXISTS `AttributeKeyCategories` (
  `akCategoryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akCategoryHandle` varchar(255) NOT NULL,
  `akCategoryAllowSets` smallint(4) NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`akCategoryID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `AttributeKeyCategories`
--

INSERT INTO `AttributeKeyCategories` (`akCategoryID`, `akCategoryHandle`, `akCategoryAllowSets`, `pkgID`) VALUES
(1, 'collection', 0, NULL),
(2, 'user', 0, NULL),
(3, 'file', 0, NULL);

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

--
-- 表的结构 `AttributeKeys`
--

CREATE TABLE IF NOT EXISTS `AttributeKeys` (
  `akID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akHandle` varchar(255) NOT NULL,
  `akName` varchar(255) NOT NULL,
  `akIsSearchable` tinyint(1) NOT NULL DEFAULT '0',
  `akIsSearchableIndexed` tinyint(1) NOT NULL DEFAULT '0',
  `akIsAutoCreated` tinyint(1) NOT NULL DEFAULT '0',
  `akIsColumnHeader` tinyint(1) NOT NULL DEFAULT '0',
  `akIsEditable` tinyint(1) NOT NULL DEFAULT '0',
  `atID` int(10) unsigned DEFAULT NULL,
  `akCategoryID` int(10) unsigned DEFAULT NULL,
  `pkgID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`akID`),
  UNIQUE KEY `akHandle` (`akHandle`,`akCategoryID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- 转存表中的数据 `AttributeKeys`
--

INSERT INTO `AttributeKeys` (`akID`, `akHandle`, `akName`, `akIsSearchable`, `akIsSearchableIndexed`, `akIsAutoCreated`, `akIsColumnHeader`, `akIsEditable`, `atID`, `akCategoryID`, `pkgID`) VALUES
(1, 'meta_title', 'Meta Title', 1, 0, 0, 0, 1, 1, 1, 0),
(2, 'meta_description', 'Meta Description', 1, 0, 0, 0, 1, 2, 1, 0),
(3, 'meta_keywords', 'Meta Keywords', 1, 0, 0, 0, 1, 2, 1, 0),
(4, 'exclude_nav', 'Exclude From Nav', 1, 0, 0, 0, 1, 3, 1, 0),
(5, 'exclude_page_list', 'Exclude From Page List', 1, 0, 0, 0, 1, 3, 1, 0),
(6, 'header_extra_content', 'Header Extra Content', 1, 0, 0, 0, 1, 2, 1, 0),
(7, 'exclude_search_index', 'Exclude From Search Index', 1, 0, 0, 0, 1, 3, 1, 0),
(8, 'exclude_sitemapxml', 'Exclude From sitemap.xml', 1, 0, 0, 0, 1, 3, 1, 0),
(11, 'tags', 'Tags', 0, 0, 0, 0, 1, 8, 1, 0);

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

--
-- 表的结构 `AttributeSetKeys`
--

CREATE TABLE IF NOT EXISTS `AttributeSetKeys` (
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `asID` int(10) unsigned NOT NULL DEFAULT '0',
  `displayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`akID`,`asID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `AttributeSets`
--

CREATE TABLE IF NOT EXISTS `AttributeSets` (
  `asID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asName` varchar(255) DEFAULT NULL,
  `asHandle` varchar(255) NOT NULL,
  `akCategoryID` int(10) unsigned NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`asID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `AttributeTypeCategories`
--

CREATE TABLE IF NOT EXISTS `AttributeTypeCategories` (
  `atID` int(10) unsigned NOT NULL DEFAULT '0',
  `akCategoryID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`atID`,`akCategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `AttributeTypeCategories`
--

INSERT INTO `AttributeTypeCategories` (`atID`, `akCategoryID`) VALUES
(1, 1),
(1, 2),
(1, 3),
(2, 1),
(2, 2),
(2, 3),
(3, 1),
(3, 2),
(3, 3),
(4, 1),
(4, 2),
(4, 3),
(5, 1),
(6, 1),
(6, 2),
(6, 3),
(7, 1),
(7, 3),
(8, 1),
(8, 2),
(8, 3),
(9, 2);

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

--
-- 表的结构 `AttributeTypes`
--

CREATE TABLE IF NOT EXISTS `AttributeTypes` (
  `atID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `atHandle` varchar(255) NOT NULL,
  `atName` varchar(255) NOT NULL,
  `pkgID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`atID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 转存表中的数据 `AttributeTypes`
--

INSERT INTO `AttributeTypes` (`atID`, `atHandle`, `atName`, `pkgID`) VALUES
(1, 'text', 'Text', 0),
(2, 'textarea', 'Text Area', 0),
(3, 'boolean', 'Checkbox', 0),
(4, 'date_time', 'Date/Time', 0),
(5, 'image_file', 'Image/File', 0),
(6, 'number', 'Number', 0),
(7, 'rating', 'Rating', 0),
(8, 'select', 'Select', 0),
(9, 'address', 'Address', 0);

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

--
-- 表的结构 `AttributeValues`
--

CREATE TABLE IF NOT EXISTS `AttributeValues` (
  `avID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `akID` int(10) unsigned DEFAULT NULL,
  `avDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `uID` int(10) unsigned DEFAULT NULL,
  `atID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`avID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

--
-- 转存表中的数据 `AttributeValues`
--

INSERT INTO `AttributeValues` (`avID`, `akID`, `avDateAdded`, `uID`, `atID`) VALUES
(1, 9, '2011-04-19 11:21:12', 1, 6),
(2, 10, '2011-04-19 11:21:12', 1, 6),
(3, 9, '2011-04-19 11:21:12', 1, 6),
(4, 10, '2011-04-19 11:21:12', 1, 6),
(5, 9, '2011-04-19 11:21:12', 1, 6),
(6, 10, '2011-04-19 11:21:12', 1, 6),
(7, 9, '2011-04-19 11:21:12', 1, 6),
(8, 10, '2011-04-19 11:21:12', 1, 6),
(9, 9, '2011-04-19 11:21:12', 1, 6),
(10, 10, '2011-04-19 11:21:12', 1, 6),
(11, 1, '2011-04-19 11:21:12', 1, 1),
(12, 2, '2011-04-19 11:21:12', 1, 2),
(13, 3, '2011-04-19 11:21:12', 1, 2),
(14, 4, '2011-04-19 11:21:12', 1, 3),
(15, 1, '2011-04-19 11:21:12', 1, 1),
(16, 2, '2011-04-19 11:21:12', 1, 2),
(17, 3, '2011-04-19 11:21:12', 1, 2),
(18, 4, '2011-04-19 11:21:12', 1, 3),
(19, 11, '2011-04-19 11:21:12', 1, 8),
(20, 1, '2011-04-19 11:21:12', 1, 1),
(21, 2, '2011-04-19 11:21:12', 1, 2),
(22, 3, '2011-04-19 11:21:12', 1, 2),
(23, 4, '2011-04-19 11:21:12', 1, 3),
(24, 1, '2011-04-19 11:21:12', 1, 1),
(25, 2, '2011-04-19 11:21:12', 1, 2),
(26, 3, '2011-04-19 11:21:12', 1, 2),
(27, 4, '2011-04-19 11:21:12', 1, 3),
(28, 1, '2011-04-19 11:21:12', 1, 1),
(29, 2, '2011-04-19 11:21:12', 1, 2),
(30, 3, '2011-04-19 11:21:12', 1, 2),
(31, 4, '2011-04-19 11:21:12', 1, 3),
(32, 1, '2011-04-19 11:21:12', 1, 1),
(33, 2, '2011-04-19 11:21:12', 1, 2),
(34, 3, '2011-04-19 11:21:12', 1, 2),
(35, 4, '2011-04-19 11:21:12', 1, 3),
(36, 1, '2011-04-19 11:21:12', 1, 1),
(37, 2, '2011-04-19 11:21:12', 1, 2),
(38, 3, '2011-04-19 11:21:12', 1, 2),
(39, 4, '2011-04-19 11:21:12', 1, 3),
(40, 11, '2011-04-19 11:21:12', 1, 8),
(41, 1, '2011-04-19 11:21:12', 1, 1),
(42, 2, '2011-04-19 11:21:12', 1, 2),
(43, 3, '2011-04-19 11:21:12', 1, 2),
(44, 4, '2011-04-19 11:21:12', 1, 3),
(45, 11, '2011-04-19 11:21:12', 1, 8);

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

--
-- 表的结构 `BlockRelations`
--

CREATE TABLE IF NOT EXISTS `BlockRelations` (
  `brID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(10) unsigned NOT NULL DEFAULT '0',
  `originalBID` int(10) unsigned NOT NULL DEFAULT '0',
  `relationType` varchar(50) NOT NULL,
  PRIMARY KEY (`brID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- 转存表中的数据 `BlockRelations`
--

INSERT INTO `BlockRelations` (`brID`, `bID`, `originalBID`, `relationType`) VALUES
(1, 31, 15, 'DUPLICATE'),
(2, 32, 16, 'DUPLICATE'),
(3, 33, 23, 'DUPLICATE'),
(4, 34, 31, 'DUPLICATE'),
(5, 35, 32, 'DUPLICATE'),
(6, 36, 15, 'DUPLICATE'),
(7, 39, 23, 'DUPLICATE'),
(9, 43, 1, 'DUPLICATE'),
(11, 48, 44, 'DUPLICATE');

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

--
-- 表的结构 `Blocks`
--

CREATE TABLE IF NOT EXISTS `Blocks` (
  `bID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bName` varchar(60) DEFAULT NULL,
  `bDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bDateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bFilename` varchar(32) DEFAULT NULL,
  `bIsActive` varchar(1) NOT NULL DEFAULT '1',
  `btID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

--
-- 转存表中的数据 `Blocks`
--

INSERT INTO `Blocks` (`bID`, `bName`, `bDateAdded`, `bDateModified`, `bFilename`, `bIsActive`, `btID`, `uID`) VALUES
(1, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'header_menu.php', '1', 3, 1),
(2, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 11, 1),
(3, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 3, 1),
(46, NULL, '2011-04-19 11:37:38', '2011-04-19 11:37:38', NULL, '1', 1, 1),
(45, NULL, '2011-04-19 11:35:03', '2011-04-19 11:35:03', NULL, '1', 1, 1),
(44, NULL, '2011-04-19 11:31:52', '2011-04-19 11:33:37', NULL, '1', 1, 1),
(7, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'header_menu.php', '1', 3, 1),
(8, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 8, 1),
(9, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 3, 1),
(10, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'header_menu.php', '1', 3, 1),
(11, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 8, 1),
(12, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'header_menu.php', '1', 3, 1),
(13, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 8, 1),
(14, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'breadcrumb.php', '1', 3, 1),
(15, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(16, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(17, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 10, 1),
(18, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 18, 1),
(19, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 12, 1),
(20, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 3, 1),
(21, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(22, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 12, 1),
(23, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 20, 1),
(24, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(25, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(26, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(27, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 10, 1),
(28, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 18, 1),
(29, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'tag_cloud', '1', 12, 1),
(30, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', 'blog_index.php', '1', 6, 1),
(31, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(32, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(33, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 20, 1),
(34, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(35, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(36, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(37, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 17, 1),
(38, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(39, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 20, 1),
(40, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 19, 1),
(41, 'My_Site_Name', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL, '1', 1, 1),
(43, NULL, '2011-04-19 11:29:12', '2011-04-19 11:29:12', 'header_menu.php', '1', 3, 1),
(48, NULL, '2011-10-11 20:22:46', '2011-10-11 20:27:40', NULL, '1', 1, 1);

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

--
-- 表的结构 `BlockTypes`
--

CREATE TABLE IF NOT EXISTS `BlockTypes` (
  `btID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `btHandle` varchar(32) NOT NULL,
  `btName` varchar(128) NOT NULL,
  `btDescription` text,
  `btActiveWhenAdded` tinyint(1) NOT NULL DEFAULT '1',
  `btCopyWhenPropagate` tinyint(1) NOT NULL DEFAULT '0',
  `btIncludeAll` tinyint(1) NOT NULL DEFAULT '0',
  `btIsInternal` tinyint(1) NOT NULL DEFAULT '0',
  `btInterfaceWidth` int(10) unsigned NOT NULL DEFAULT '400',
  `btInterfaceHeight` int(10) unsigned NOT NULL DEFAULT '400',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`btID`),
  UNIQUE KEY `btHandle` (`btHandle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- 转存表中的数据 `BlockTypes`
--

INSERT INTO `BlockTypes` (`btID`, `btHandle`, `btName`, `btDescription`, `btActiveWhenAdded`, `btCopyWhenPropagate`, `btIncludeAll`, `btIsInternal`, `btInterfaceWidth`, `btInterfaceHeight`, `pkgID`) VALUES
(1, 'content', 'Content', 'HTML/WYSIWYG Editor Content.', 1, 0, 0, 0, 600, 465, 0),
(2, 'html', 'HTML', 'For adding HTML by hand.', 1, 0, 0, 0, 600, 465, 0),
(3, 'autonav', 'Auto-Nav', 'Creates navigation trees and sitemaps.', 1, 0, 0, 0, 500, 350, 0),
(4, 'external_form', 'External Form', 'Include external forms in the filesystem and place them on pages.', 1, 0, 0, 0, 300, 200, 0),
(5, 'form', 'Form', 'Build simple forms and surveys.', 1, 0, 0, 0, 420, 430, 0),
(6, 'page_list', 'Page List', 'List pages based on type, area.', 1, 0, 0, 0, 500, 350, 0),
(7, 'file', 'File', 'Link to files stored in the asset library.', 1, 0, 0, 0, 300, 250, 0),
(8, 'image', 'Image', 'Adds images and onstates from the library to pages.', 1, 0, 0, 0, 300, 440, 0),
(9, 'flash_content', 'Flash Content', 'Embeds SWF files, including flash detection.', 1, 0, 0, 0, 300, 240, 0),
(10, 'guestbook', 'Guestbook', 'Adds blog-style comments (a guestbook) to your page.', 1, 0, 1, 0, 300, 260, 0),
(11, 'slideshow', 'Slideshow', 'Display a running loop of images.', 1, 0, 0, 0, 550, 400, 0),
(12, 'search', 'Search', 'Add a search box to your site.', 1, 0, 0, 0, 400, 170, 0),
(13, 'google_map', 'Google Map', 'Enter an address and a Google Map of that location will be placed in your page.', 1, 0, 0, 0, 400, 220, 0),
(14, 'video', 'Video Player', 'Embeds uploaded video into a web page. Supports AVI, WMV, Quicktime/MPEG4 and FLV formats.', 1, 0, 0, 0, 300, 200, 0),
(15, 'rss_displayer', 'RSS Displayer', 'Fetch, parse and display the contents of an RSS or Atom feed.', 1, 0, 0, 0, 400, 170, 0),
(16, 'youtube', 'Youtube Video', 'Embeds a Youtube Video in your web page.', 1, 0, 0, 0, 400, 170, 0),
(17, 'survey', 'Survey', 'Provide a simple survey, along with results in a pie chart format.', 1, 0, 1, 0, 420, 300, 0),
(18, 'date_nav', 'Date Navigation', 'A collapsible date based navigation tree', 1, 0, 0, 0, 500, 350, 0),
(19, 'next_previous', 'Next & Previous Nav', 'Navigate through sibling pages.', 1, 0, 0, 0, 430, 300, 0),
(20, 'tags', 'Tags', 'List pages based on type, area.', 1, 0, 0, 0, 500, 350, 0);

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

--
-- 表的结构 `btContentFile`
--

CREATE TABLE IF NOT EXISTS `btContentFile` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `fileLinkText` varchar(255) DEFAULT NULL,
  `filePassword` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btContentImage`
--

CREATE TABLE IF NOT EXISTS `btContentImage` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT '0',
  `fOnstateID` int(10) unsigned DEFAULT '0',
  `maxWidth` int(10) unsigned DEFAULT '0',
  `maxHeight` int(10) unsigned DEFAULT '0',
  `externalLink` varchar(255) DEFAULT NULL,
  `altText` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btContentImage`
--

INSERT INTO `btContentImage` (`bID`, `fID`, `fOnstateID`, `maxWidth`, `maxHeight`, `externalLink`, `altText`) VALUES
(8, 4, 0, 0, 0, '', ''),
(11, 2, 0, 0, 0, '', ''),
(13, 1, 0, 0, 0, '', '');

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

--
-- 表的结构 `btContentLocal`
--

CREATE TABLE IF NOT EXISTS `btContentLocal` (
  `bID` int(10) unsigned NOT NULL,
  `content` longtext,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btContentLocal`
--

INSERT INTO `btContentLocal` (`bID`, `content`) VALUES
(44, '<p><span style="color: #000000;">for all inquiries, please email us at <a href="mailto:info@topoforms.com">info@topoforms.com</a></span></p>'),
(45, '<p><span style="color: #000000;">l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e<strong>&nbsp; .&nbsp; </strong>u r b a n &nbsp;&nbsp; d e s i g n<strong>&nbsp; .&nbsp; </strong>p l a n n i n g</span></p>'),
(46, ''),
(15, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum vel tellus lectus, scelerisque faucibus nunc. Curabitur lacus nibh, eleifend vel porttitor in, bibendum quis tortor. Curabitur eros ligula, scelerisque ac ultricies a, dictum ac tellus. Mauris id tellus tortor. Proin a sollicitudin libero. Nam pellentesque commodo magna, nec mattis elit pulvinar id. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris orci dui, adipiscing sit amet bibendum vel, sodales sed purus. Donec fringilla odio vel enim cursus luctus quis semper leo. Donec rhoncus odio ac elit dignissim lobortis.</p>\r\n<p>&nbsp;</p>'),
(16, '<p>Duis dapibus nibh eu arcu viverra tempor. Fusce auctor sapien eu mauris malesuada vel euismod orci vulputate. Curabitur at orci id quam mollis rhoncus vitae volutpat urna. Nam eget sapien at neque mollis varius sed vitae ipsum. Vestibulum commodo, eros sit amet sagittis cursus, massa mi lacinia lorem, vel pellentesque sapien purus eu lacus. Pellentesque mollis gravida enim. Fusce mi odio, elementum ut fermentum a, pharetra in quam. Mauris sed vestibulum sapien. In sit amet faucibus diam. Proin lectus quam, sodales ut posuere non, viverra a nibh. Aenean sollicitudin, diam eu elementum rutrum, nisi ante pretium mi, ut tristique ante tellus non ligula. Nam diam turpis, viverra non volutpat vel, scelerisque vel neque. In pretium, libero et vulputate varius, libero nulla blandit ligula, tincidunt egestas leo mi eu nisi. Mauris nunc augue, cursus vel viverra non, feugiat in enim. In eget dignissim est. Donec dictum leo in libero tincidunt sollicitudin hendrerit elit placerat. Aliquam vitae nunc diam, non vulputate nibh. Quisque tincidunt, dui ut rutrum feugiat, libero lorem interdum sapien, eget pharetra mi ligula ut lectus. Pellentesque consequat mollis est viverra malesuada.</p>\r\n<p>Curabitur eget quam vitae tellus blandit congue a sed lectus. Nunc ultrices lacus dignissim felis venenatis varius placerat eros dapibus. Nulla facilisi. Vivamus sodales accumsan convallis. Mauris congue tempus feugiat. Proin elementum fringilla leo, sit amet pretium nisl imperdiet interdum. Suspendisse volutpat cursus eros, nec porta est laoreet at. Sed porttitor suscipit augue, eu molestie justo faucibus et. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus faucibus mi vel tortor consequat eget rutrum nisl ultrices. Praesent et lacinia augue. Phasellus id est id enim ultricies placerat. Etiam porta enim eu enim convallis sed eleifend metus faucibus. In ac lobortis eros. Pellentesque felis turpis, cursus sed imperdiet non, viverra vel diam. Donec vel orci mi, placerat egestas purus. Vestibulum vel diam id magna suscipit accumsan. Quisque risus felis, sagittis non iaculis id, tempus in arcu. Donec tempus metus neque. Proin malesuada dui a tortor pretium tincidunt quis at ligula.</p>\r\n<p>Nam laoreet faucibus purus ac pretium. Aenean euismod diam adipiscing erat semper quis sodales elit tristique. Vestibulum vel tellus eu lorem porttitor aliquet. Vestibulum bibendum viverra cursus. Aenean sit amet magna odio, convallis imperdiet metus. Duis condimentum posuere vulputate. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed vitae elit ut sapien vestibulum tempor sit amet ac tortor. Donec ligula nulla, varius id ornare id, vestibulum non felis. Nullam neque erat, tristique a eleifend pellentesque, eleifend sit amet ipsum. In eget urna nibh. Phasellus scelerisque, magna ac feugiat ultricies, risus dolor volutpat quam, in rutrum nunc ante id sem. Fusce interdum scelerisque fermentum.</p>\r\n<p>&nbsp;</p>'),
(21, '<h1>Site Map</h1>'),
(24, '<h1>Learn More</h1>\r\n<p>Visit&nbsp;<a title="concrete5 Content Management System" href="{CCM:BASE_URL}.org" target="_blank">concrete5.org</a>&nbsp;to learn more from the&nbsp;<a title="open source content management system" href="{CCM:BASE_URL}.org/community" target="_blank">community</a>&nbsp;and the&nbsp;<a title="concrete5 documentation" href="http://www.concrete5.org/documentation/" target="_blank">documentation</a>. You can also browse our&nbsp;<a title="concrete5 marketplace" href="http://www.concrete5.org/marketplace/" target="_blank">marketplace</a>&nbsp;for more&nbsp;<a title="Add-ons for concrete5" href="http://www.concrete5.org/marketplace/addons/" target="_blank">add-ons</a>&nbsp;and&nbsp;<a title="Themes for concrete5" href="http://www.concrete5.org/marketplace/themes/" target="_blank">themes</a>&nbsp;to quickly build the site you really need.&nbsp;</p>\r\n<p>&nbsp;</p>'),
(25, '<h2>Common Tips</h2>\r\n<p>Want to&nbsp;<a title="change your site name in concrete5" href="http://www.concrete5.org/help/faq/how_do_i_get_rid_of_my_sitename_/" target="_blank">change your site name</a>&nbsp;up top?</p>\r\n<p>Need to sell stuff on your website? Check out our&nbsp;<a title="eCommerce and concrete5" href="http://www.concrete5.org/marketplace/addons/ecommerce/" target="_blank">eCommerce add-on</a>.</p>\r\n<p>Help,&nbsp;<a title="Reset your admin password in concrete5" href="http://www.concrete5.org/help/faq/i-can-t-login/" target="_blank">I can''t login</a>&nbsp;anymore!</p>\r\n<p>&nbsp;</p>'),
(26, '<h1>Say Hi!</h1>\r\n<p>Here''s a simple guestbook you can add to any page on your website to allow comments. Why not put the guestbook block in edit mode and play with the options?</p>\r\n<p>We also have a fully featured&nbsp;<a title="Forums for concrete5" href="http://www.concrete5.org/marketplace/addons/discussion/" target="_blank">Discussions Forum Add-on</a>&nbsp;if you need it.&nbsp;</p>\r\n<p>&nbsp;</p>'),
(31, '<p>This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;<a title="Blog" href="{CCM:CID_71}">blog list page</a>.</p>\r\n<p>&nbsp;</p>'),
(32, '<p>If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post''s title or more link to read the full post.&nbsp;</p>\r\n<p>Keep your long posts in here and just a short synopsis up top if you''d like a nice scannable blog.</p>\r\n<p>&nbsp;</p>'),
(34, '<p>This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;<a title="Blog" href="{CCM:CID_71}">blog list page</a>.</p>'),
(35, '<p>If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post''s title or more link to read the full post.&nbsp;</p>\r\n<p>Keep your long posts in here and just a short synopsis up top if you''d like a nice scannable blog.</p>'),
(36, '<p>In-context editing is pretty cool cool!</p>'),
(38, '<p>By now you''ve probably watched through the basics at concrete5.org, so you''re getting a good sense of how you can add pages around your site. To make a new blog post...</p>\r\n<ol>\r\n<li>Goto the blog list page, this is the holder page for all your posts in the site tree.&nbsp;</li>\r\n<li>Click Add Page, on the upper left.&nbsp;</li>\r\n<li>Pick Blog Entry as a page type.&nbsp;</li>\r\n<li>Give it a name and hit return, or click the add page button at the bottom of the drop down. (You don''t need to worry about all these other fields yet, you can always change them later through Edit Page &gt; Properties</li>\r\n<li>You''re now on your new blog post page, in edit mode. Start making blocks and get things looking right.&nbsp;</li>\r\n<li>Exit Edit Mode and Publish your changes.&nbsp;</li>\r\n</ol>'),
(41, '<p>{[CCM:SITE]}</p>'),
(48, '<p style="text-align: right;"><span style="color: #000000;">l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e<strong>&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; </strong>u r b a n&nbsp;&nbsp;&nbsp; d e s i g n<strong>&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; </strong>p l a n n i n g</span></p>\r\n<p><span style="color: #000000;">&nbsp;</span></p>\r\n<p><span style="color: #000000;">&nbsp;</span></p>\r\n<p><span style="color: #000000;">for all inquiries, please email us at <a href="mailto:info@topoforms.com">info@topoforms.com</a></span></p>');

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

--
-- 表的结构 `btDateNav`
--

CREATE TABLE IF NOT EXISTS `btDateNav` (
  `bID` int(10) unsigned NOT NULL,
  `num` smallint(5) unsigned NOT NULL,
  `cParentID` int(10) unsigned NOT NULL DEFAULT '1',
  `cThis` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ctID` smallint(5) unsigned DEFAULT NULL,
  `flatDisplay` int(11) DEFAULT '0',
  `defaultNode` varchar(64) DEFAULT 'current_page',
  `truncateTitles` int(11) DEFAULT '0',
  `truncateSummaries` int(11) DEFAULT '0',
  `displayFeaturedOnly` int(11) DEFAULT '0',
  `truncateChars` int(11) DEFAULT '128',
  `truncateTitleChars` int(11) DEFAULT '128',
  `showDescriptions` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btDateNav`
--

INSERT INTO `btDateNav` (`bID`, `num`, `cParentID`, `cThis`, `ctID`, `flatDisplay`, `defaultNode`, `truncateTitles`, `truncateSummaries`, `displayFeaturedOnly`, `truncateChars`, `truncateTitleChars`, `showDescriptions`) VALUES
(18, 0, 0, 0, 4, 0, 'current_page', 0, 0, 0, 0, 0, 0),
(28, 0, 71, 1, 0, 0, 'current_month', 0, 0, 0, 0, 0, 0);

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

--
-- 表的结构 `btExternalForm`
--

CREATE TABLE IF NOT EXISTS `btExternalForm` (
  `bID` int(10) unsigned NOT NULL,
  `filename` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btFile`
--

CREATE TABLE IF NOT EXISTS `btFile` (
  `bID` int(10) unsigned NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `origfilename` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `type` varchar(32) DEFAULT NULL,
  `generictype` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btFlashContent`
--

CREATE TABLE IF NOT EXISTS `btFlashContent` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `quality` varchar(255) DEFAULT NULL,
  `minVersion` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btForm`
--

CREATE TABLE IF NOT EXISTS `btForm` (
  `bID` int(10) unsigned NOT NULL,
  `questionSetId` int(10) unsigned DEFAULT '0',
  `surveyName` varchar(255) DEFAULT NULL,
  `thankyouMsg` text,
  `notifyMeOnSubmission` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `recipientEmail` varchar(255) DEFAULT NULL,
  `displayCaptcha` int(11) DEFAULT '1',
  `redirectCID` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`),
  KEY `questionSetIdForeign` (`questionSetId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btFormAnswers`
--

CREATE TABLE IF NOT EXISTS `btFormAnswers` (
  `aID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asID` int(10) unsigned DEFAULT '0',
  `msqID` int(10) unsigned DEFAULT '0',
  `answer` varchar(255) DEFAULT NULL,
  `answerLong` text,
  PRIMARY KEY (`aID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `btFormAnswerSet`
--

CREATE TABLE IF NOT EXISTS `btFormAnswerSet` (
  `asID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `questionSetId` int(10) unsigned DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uID` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`asID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `btFormQuestions`
--

CREATE TABLE IF NOT EXISTS `btFormQuestions` (
  `qID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msqID` int(10) unsigned DEFAULT '0',
  `bID` int(10) unsigned DEFAULT '0',
  `questionSetId` int(10) unsigned DEFAULT '0',
  `question` varchar(255) DEFAULT NULL,
  `inputType` varchar(255) DEFAULT NULL,
  `options` text,
  `position` int(10) unsigned DEFAULT '1000',
  `width` int(10) unsigned DEFAULT '50',
  `height` int(10) unsigned DEFAULT '3',
  `required` int(11) DEFAULT '0',
  PRIMARY KEY (`qID`),
  KEY `questionSetId` (`questionSetId`),
  KEY `msqID` (`msqID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `btGoogleMap`
--

CREATE TABLE IF NOT EXISTS `btGoogleMap` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `zoom` int(8) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btGuestBook`
--

CREATE TABLE IF NOT EXISTS `btGuestBook` (
  `bID` int(10) unsigned NOT NULL,
  `requireApproval` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT 'Comments',
  `dateFormat` varchar(100) DEFAULT NULL,
  `displayGuestBookForm` int(11) DEFAULT '1',
  `displayCaptcha` int(11) DEFAULT '1',
  `authenticationRequired` int(11) DEFAULT '0',
  `notifyEmail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btGuestBook`
--

INSERT INTO `btGuestBook` (`bID`, `requireApproval`, `title`, `dateFormat`, `displayGuestBookForm`, `displayCaptcha`, `authenticationRequired`, `notifyEmail`) VALUES
(17, 0, 'Comments:', 'M jS, Y', 1, 1, 0, ''),
(27, 0, 'Comments:', 'M jS, Y', 1, 1, 0, '');

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

--
-- 表的结构 `btGuestBookEntries`
--

CREATE TABLE IF NOT EXISTS `btGuestBookEntries` (
  `bID` int(11) DEFAULT NULL,
  `cID` int(11) DEFAULT '1',
  `entryID` int(11) NOT NULL AUTO_INCREMENT,
  `uID` int(11) DEFAULT '0',
  `commentText` longtext,
  `user_name` varchar(100) DEFAULT NULL,
  `user_email` varchar(100) DEFAULT NULL,
  `entryDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved` int(11) DEFAULT '1',
  PRIMARY KEY (`entryID`),
  KEY `cID` (`cID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `btNavigation`
--

CREATE TABLE IF NOT EXISTS `btNavigation` (
  `bID` int(10) unsigned NOT NULL,
  `orderBy` varchar(255) DEFAULT 'alpha_asc',
  `displayPages` varchar(255) DEFAULT 'top',
  `displayPagesCID` int(10) unsigned NOT NULL DEFAULT '1',
  `displayPagesIncludeSelf` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `displaySubPages` varchar(255) DEFAULT 'none',
  `displaySubPageLevels` varchar(255) DEFAULT 'none',
  `displaySubPageLevelsNum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayUnavailablePages` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btNavigation`
--

INSERT INTO `btNavigation` (`bID`, `orderBy`, `displayPages`, `displayPagesCID`, `displayPagesIncludeSelf`, `displaySubPages`, `displaySubPageLevels`, `displaySubPageLevelsNum`, `displayUnavailablePages`) VALUES
(1, 'display_asc', 'top', 0, 0, 'none', 'enough', 0, 0),
(3, 'display_asc', 'second_level', 0, 0, 'relevant', 'enough', 0, 0),
(7, 'display_asc', 'top', 0, 0, 'none', 'enough', 0, 0),
(9, 'display_asc', 'second_level', 0, 0, 'relevant', 'enough', 0, 0),
(10, 'display_asc', 'top', 0, 0, 'none', 'enough', 0, 0),
(12, 'display_asc', 'top', 0, 0, 'none', 'enough', 0, 0),
(14, 'display_asc', 'top', 0, 0, 'relevant_breadcrumb', 'enough', 0, 0),
(20, 'display_asc', 'top', 0, 0, 'all', 'all', 0, 0),
(43, 'display_asc', 'top', 0, 0, 'relevant', 'enough', 0, 0);

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

--
-- 表的结构 `btNextPrevious`
--

CREATE TABLE IF NOT EXISTS `btNextPrevious` (
  `bID` int(10) unsigned NOT NULL,
  `linkStyle` varchar(32) DEFAULT NULL,
  `nextLabel` varchar(128) DEFAULT NULL,
  `previousLabel` varchar(128) DEFAULT NULL,
  `showArrows` int(11) DEFAULT '1',
  `loopSequence` int(11) DEFAULT '1',
  `excludeSystemPages` int(11) DEFAULT '1',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btNextPrevious`
--

INSERT INTO `btNextPrevious` (`bID`, `linkStyle`, `nextLabel`, `previousLabel`, `showArrows`, `loopSequence`, `excludeSystemPages`) VALUES
(40, 'next_previous', 'Next', 'Previous', 1, 1, 1);

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

--
-- 表的结构 `btPageList`
--

CREATE TABLE IF NOT EXISTS `btPageList` (
  `bID` int(10) unsigned NOT NULL,
  `num` smallint(5) unsigned NOT NULL,
  `orderBy` varchar(32) DEFAULT NULL,
  `cParentID` int(10) unsigned NOT NULL DEFAULT '1',
  `cThis` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `paginate` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `displayAliases` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `ctID` smallint(5) unsigned DEFAULT NULL,
  `rss` int(11) DEFAULT '0',
  `rssTitle` varchar(255) DEFAULT NULL,
  `rssDescription` longtext,
  `truncateSummaries` int(11) DEFAULT '0',
  `displayFeaturedOnly` int(11) DEFAULT '0',
  `truncateChars` int(11) DEFAULT '128',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btPageList`
--

INSERT INTO `btPageList` (`bID`, `num`, `orderBy`, `cParentID`, `cThis`, `paginate`, `displayAliases`, `ctID`, `rss`, `rssTitle`, `rssDescription`, `truncateSummaries`, `displayFeaturedOnly`, `truncateChars`) VALUES
(30, 10, 'chrono_desc', 0, 0, 1, 1, 4, 1, 'Blog', '', 0, 0, 0);

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

--
-- 表的结构 `btRssDisplay`
--

CREATE TABLE IF NOT EXISTS `btRssDisplay` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `dateFormat` varchar(100) DEFAULT NULL,
  `itemsToDisplay` int(10) unsigned DEFAULT '5',
  `showSummary` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `launchInNewWindow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btSearch`
--

CREATE TABLE IF NOT EXISTS `btSearch` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `buttonText` varchar(128) DEFAULT NULL,
  `baseSearchPath` varchar(255) DEFAULT NULL,
  `resultsURL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btSearch`
--

INSERT INTO `btSearch` (`bID`, `title`, `buttonText`, `baseSearchPath`, `resultsURL`) VALUES
(19, 'Search Results', 'Search', '', ''),
(22, 'Search Your Site', 'Go', '', '/search/search-results'),
(29, 'Tags', '', '', '/search/search-results');

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

--
-- 表的结构 `btSlideshow`
--

CREATE TABLE IF NOT EXISTS `btSlideshow` (
  `bID` int(10) unsigned NOT NULL,
  `fsID` int(10) unsigned DEFAULT NULL,
  `playback` varchar(50) DEFAULT NULL,
  `duration` int(10) unsigned DEFAULT NULL,
  `fadeDuration` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btSlideshow`
--

INSERT INTO `btSlideshow` (`bID`, `fsID`, `playback`, `duration`, `fadeDuration`) VALUES
(2, 0, 'ORDER', NULL, NULL);

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

--
-- 表的结构 `btSlideshowImg`
--

CREATE TABLE IF NOT EXISTS `btSlideshowImg` (
  `slideshowImgId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(10) unsigned DEFAULT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `duration` int(10) unsigned DEFAULT NULL,
  `fadeDuration` int(10) unsigned DEFAULT NULL,
  `groupSet` int(10) unsigned DEFAULT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `imgHeight` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`slideshowImgId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- 转存表中的数据 `btSlideshowImg`
--

INSERT INTO `btSlideshowImg` (`slideshowImgId`, `bID`, `fID`, `url`, `duration`, `fadeDuration`, `groupSet`, `position`, `imgHeight`) VALUES
(1, 2, 5, '', 5, 2, 0, 0, 192),
(2, 2, 4, '', 5, 2, 0, 1, 215),
(3, 2, 2, '', 5, 2, 0, 2, 192),
(4, 2, 3, '', 5, 2, 0, 3, 192);

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

--
-- 表的结构 `btSurvey`
--

CREATE TABLE IF NOT EXISTS `btSurvey` (
  `bID` int(10) unsigned NOT NULL,
  `question` varchar(255) DEFAULT '',
  `requiresRegistration` int(11) DEFAULT '0',
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btSurvey`
--

INSERT INTO `btSurvey` (`bID`, `question`, `requiresRegistration`) VALUES
(37, 'What''s easiest?', 0);

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

--
-- 表的结构 `btSurveyOptions`
--

CREATE TABLE IF NOT EXISTS `btSurveyOptions` (
  `optionID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bID` int(11) DEFAULT NULL,
  `optionName` varchar(255) DEFAULT NULL,
  `displayOrder` int(11) DEFAULT '0',
  PRIMARY KEY (`optionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `btSurveyOptions`
--

INSERT INTO `btSurveyOptions` (`optionID`, `bID`, `optionName`, `displayOrder`) VALUES
(1, 37, 'Fixing a typo when I see it.', 0),
(2, 37, 'Adding a form as easily as content.', 1),
(3, 37, 'Block area layouts are pretty cool.', 2);

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

--
-- 表的结构 `btSurveyResults`
--

CREATE TABLE IF NOT EXISTS `btSurveyResults` (
  `resultID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `optionID` int(10) unsigned DEFAULT '0',
  `uID` int(10) unsigned DEFAULT '0',
  `bID` int(11) DEFAULT NULL,
  `cID` int(11) DEFAULT NULL,
  `ipAddress` varchar(128) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`resultID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `btTags`
--

CREATE TABLE IF NOT EXISTS `btTags` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `targetCID` int(11) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `btTags`
--

INSERT INTO `btTags` (`bID`, `title`, `targetCID`) VALUES
(23, 'Tags', 68),
(33, 'Tags', 68),
(39, 'Tags', 68);

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

--
-- 表的结构 `btVideo`
--

CREATE TABLE IF NOT EXISTS `btVideo` (
  `bID` int(10) unsigned NOT NULL,
  `fID` int(10) unsigned DEFAULT NULL,
  `width` int(10) unsigned DEFAULT NULL,
  `height` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `btYouTube`
--

CREATE TABLE IF NOT EXISTS `btYouTube` (
  `bID` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `videoURL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `CollectionAttributeValues`
--

CREATE TABLE IF NOT EXISTS `CollectionAttributeValues` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`cvID`,`akID`,`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `CollectionAttributeValues`
--

INSERT INTO `CollectionAttributeValues` (`cID`, `cvID`, `akID`, `avID`) VALUES
(66, 1, 11, 19),
(67, 2, 1, 11),
(67, 2, 2, 12),
(67, 2, 3, 13),
(67, 2, 4, 14),
(67, 3, 1, 11),
(67, 3, 2, 12),
(67, 3, 3, 13),
(67, 3, 4, 14),
(68, 2, 1, 15),
(68, 2, 2, 16),
(68, 2, 3, 17),
(68, 2, 4, 18),
(69, 2, 1, 20),
(69, 2, 2, 21),
(69, 2, 3, 22),
(69, 2, 4, 23),
(69, 3, 1, 20),
(69, 3, 2, 21),
(69, 3, 3, 22),
(69, 3, 4, 23),
(70, 2, 1, 24),
(70, 2, 2, 25),
(70, 2, 3, 26),
(70, 2, 4, 27),
(70, 3, 1, 28),
(70, 3, 2, 29),
(70, 3, 3, 30),
(70, 3, 4, 31),
(71, 2, 1, 32),
(71, 2, 2, 33),
(71, 2, 3, 34),
(71, 2, 4, 35),
(72, 2, 1, 36),
(72, 2, 2, 37),
(72, 2, 3, 38),
(72, 2, 4, 39),
(72, 2, 11, 40),
(72, 3, 1, 36),
(72, 3, 2, 37),
(72, 3, 3, 38),
(72, 3, 4, 39),
(72, 3, 11, 40),
(72, 4, 1, 36),
(72, 4, 2, 37),
(72, 4, 3, 38),
(72, 4, 4, 39),
(72, 4, 11, 40),
(73, 2, 1, 41),
(73, 2, 2, 42),
(73, 2, 3, 43),
(73, 2, 4, 44),
(73, 3, 1, 41),
(73, 3, 2, 42),
(73, 3, 3, 43),
(73, 3, 4, 44),
(73, 3, 11, 45),
(73, 4, 1, 41),
(73, 4, 2, 42),
(73, 4, 3, 43),
(73, 4, 4, 44),
(73, 4, 11, 45);

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

--
-- 表的结构 `Collections`
--

CREATE TABLE IF NOT EXISTS `Collections` (
  `cID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cDateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cHandle` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cID`),
  KEY `cDateModified` (`cDateModified`),
  KEY `cDateAdded` (`cDateAdded`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=65 ;

--
-- 转存表中的数据 `Collections`
--

INSERT INTO `Collections` (`cID`, `cDateAdded`, `cDateModified`, `cHandle`) VALUES
(1, '2011-04-19 11:21:09', '2011-10-11 20:31:40', 'home'),
(2, '2011-04-19 11:21:09', '2011-04-19 11:21:09', NULL),
(5, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'login'),
(6, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'register'),
(7, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'profile'),
(8, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'edit'),
(10, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'avatar'),
(11, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'messages'),
(12, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'friends'),
(13, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'page_not_found'),
(14, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'page_forbidden'),
(15, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'dashboard'),
(16, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'sitemap'),
(17, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'full'),
(18, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'explore'),
(19, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'search'),
(20, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'access'),
(21, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'files'),
(22, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'search'),
(23, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'attributes'),
(24, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'sets'),
(25, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'access'),
(26, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'reports'),
(27, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'forms'),
(28, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'surveys'),
(29, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'logs'),
(30, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'users'),
(31, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'search'),
(32, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'add'),
(33, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'groups'),
(34, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'attributes'),
(35, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'registration'),
(36, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'scrapbook'),
(37, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'pages'),
(38, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'themes'),
(39, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'add'),
(40, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'inspect'),
(41, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'customize'),
(43, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'types'),
(44, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'attributes'),
(45, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'single'),
(46, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'install'),
(47, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'system'),
(48, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'jobs'),
(49, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'backup'),
(50, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'update'),
(51, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'notifications'),
(52, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'settings'),
(53, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'mail'),
(54, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'marketplace'),
(55, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'download_file'),
(63, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'uID=1'),
(64, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'members');

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

--
-- 表的结构 `CollectionSearchIndexAttributes`
--

CREATE TABLE IF NOT EXISTS `CollectionSearchIndexAttributes` (
  `cID` int(11) unsigned NOT NULL DEFAULT '0',
  `ak_meta_title` text,
  `ak_meta_description` text,
  `ak_meta_keywords` text,
  `ak_exclude_nav` tinyint(4) DEFAULT '0',
  `ak_exclude_page_list` tinyint(4) DEFAULT '0',
  `ak_header_extra_content` text,
  `ak_exclude_search_index` tinyint(4) DEFAULT '0',
  `ak_exclude_sitemapxml` tinyint(4) DEFAULT '0',
  `ak_tags` text,
  PRIMARY KEY (`cID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 转存表中的数据 `CollectionSearchIndexAttributes`
--

INSERT INTO `CollectionSearchIndexAttributes` (`cID`, `ak_meta_title`, `ak_meta_description`, `ak_meta_keywords`, `ak_exclude_nav`, `ak_exclude_page_list`, `ak_header_extra_content`, `ak_exclude_search_index`, `ak_exclude_sitemapxml`, `ak_tags`) VALUES
(2, NULL, NULL, NULL, 0, 0, NULL, 0, 0, NULL),
(1, NULL, NULL, NULL, 0, 0, NULL, 0, 0, NULL),
(65, NULL, NULL, NULL, 0, 0, NULL, 0, 0, NULL),
(42, NULL, NULL, NULL, 0, 0, NULL, 0, 0, NULL),
(67, '', '', '', 0, 0, NULL, 0, 0, NULL),
(68, '', '', '', 1, 0, NULL, 0, 0, NULL),
(66, NULL, NULL, NULL, 0, 0, NULL, 0, 0, '\n'),
(69, '', '', '', 0, 0, NULL, 0, 0, NULL),
(70, '', '', '', 0, 0, NULL, 0, 0, NULL),
(71, '', '', '', 0, 0, NULL, 0, 0, NULL),
(72, '', '', '', 0, 0, NULL, 0, 0, '\nsample\nHello World\n'),
(73, '', '', '', 0, 0, NULL, 0, 0, '\nsample\n');

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

--
-- 表的结构 `CollectionVersionAreaLayouts`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionAreaLayouts` (
  `cvalID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cID` int(10) unsigned DEFAULT '0',
  `cvID` int(10) unsigned DEFAULT '0',
  `arHandle` varchar(255) DEFAULT NULL,
  `layoutID` int(10) unsigned NOT NULL DEFAULT '0',
  `position` int(10) DEFAULT '1000',
  `areaNameNumber` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`cvalID`),
  KEY `areaLayoutsIndex` (`cID`,`cvID`,`arHandle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `CollectionVersionAreaStyles`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionAreaStyles` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `csrID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`cvID`,`arHandle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `CollectionVersionBlockPermissions`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionBlockPermissions` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '1',
  `bID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `cbgPermissions` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`cID`,`cvID`,`bID`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `CollectionVersionBlocks`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionBlocks` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '1',
  `bID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `cbDisplayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  `isOriginal` varchar(1) NOT NULL DEFAULT '0',
  `cbOverrideAreaPermissions` tinyint(1) NOT NULL DEFAULT '0',
  `cbIncludeAll` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`cvID`,`bID`,`arHandle`),
  KEY `cbIncludeAll` (`cbIncludeAll`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `CollectionVersionBlocks`
--

INSERT INTO `CollectionVersionBlocks` (`cID`, `cvID`, `bID`, `arHandle`, `cbDisplayOrder`, `isOriginal`, `cbOverrideAreaPermissions`, `cbIncludeAll`) VALUES
(2, 1, 1, 'Header Nav', 0, '1', 0, 0),
(2, 1, 2, 'Header', 0, '1', 0, 0),
(2, 1, 3, 'Sidebar', 0, '1', 0, 0),
(1, 2, 1, 'Header Nav', 0, '0', 0, 0),
(1, 2, 2, 'Header', 0, '0', 0, 0),
(1, 4, 43, 'Header Nav', 0, '0', 0, 0),
(1, 3, 43, 'Header Nav', 0, '1', 0, 0),
(1, 3, 2, 'Header', 0, '0', 0, 0),
(64, 1, 7, 'Header Nav', 0, '1', 0, 0),
(64, 1, 8, 'Header', 0, '1', 0, 0),
(64, 1, 9, 'Sidebar', 0, '1', 0, 0),
(65, 1, 10, 'Header Nav', 0, '1', 0, 0),
(65, 1, 11, 'Header', 0, '1', 0, 0),
(66, 1, 12, 'Header Nav', 0, '1', 0, 0),
(66, 1, 13, 'Header', 0, '1', 0, 0),
(66, 1, 14, 'Blog Post Header', 0, '1', 0, 0),
(66, 1, 15, 'Main', 0, '1', 0, 0),
(66, 1, 16, 'Blog Post More', 0, '1', 0, 0),
(66, 1, 17, 'Blog Post Footer', 1, '1', 0, 1),
(66, 1, 18, 'Sidebar', 0, '1', 0, 0),
(67, 1, 7, 'Header Nav', 0, '0', 0, 0),
(67, 1, 8, 'Header', 0, '0', 0, 0),
(67, 1, 9, 'Sidebar', 0, '0', 0, 0),
(67, 2, 7, 'Header Nav', 0, '0', 0, 0),
(67, 2, 8, 'Header', 0, '0', 0, 0),
(67, 2, 9, 'Sidebar', 0, '0', 0, 0),
(68, 1, 7, 'Header Nav', 0, '0', 0, 0),
(68, 1, 8, 'Header', 0, '0', 0, 0),
(68, 1, 9, 'Sidebar', 0, '0', 0, 0),
(68, 2, 7, 'Header Nav', 0, '0', 0, 0),
(68, 2, 8, 'Header', 0, '0', 0, 0),
(68, 2, 9, 'Sidebar', 0, '0', 0, 0),
(68, 2, 19, 'Main', 0, '1', 0, 0),
(67, 3, 7, 'Header Nav', 0, '0', 0, 0),
(67, 3, 8, 'Header', 0, '0', 0, 0),
(67, 3, 22, 'Sidebar', 0, '1', 0, 0),
(67, 3, 20, 'Main', 1, '1', 0, 0),
(67, 3, 21, 'Main', 0, '1', 0, 0),
(66, 1, 23, 'Sidebar', 1, '1', 0, 0),
(69, 1, 7, 'Header Nav', 0, '0', 0, 0),
(69, 1, 8, 'Header', 0, '0', 0, 0),
(69, 1, 9, 'Sidebar', 0, '0', 0, 0),
(69, 2, 7, 'Header Nav', 0, '0', 0, 0),
(69, 2, 8, 'Header', 0, '0', 0, 0),
(69, 2, 9, 'Sidebar', 0, '0', 0, 0),
(69, 2, 24, 'Main', 0, '1', 0, 0),
(69, 3, 7, 'Header Nav', 0, '0', 0, 0),
(69, 3, 8, 'Header', 0, '0', 0, 0),
(69, 3, 9, 'Sidebar', 0, '0', 0, 0),
(69, 3, 24, 'Main', 0, '0', 0, 0),
(69, 3, 25, 'Main', 1, '1', 0, 0),
(70, 1, 7, 'Header Nav', 0, '0', 0, 0),
(70, 1, 8, 'Header', 0, '0', 0, 0),
(70, 1, 9, 'Sidebar', 0, '0', 0, 0),
(70, 2, 7, 'Header Nav', 0, '0', 0, 0),
(70, 2, 8, 'Header', 0, '0', 0, 0),
(70, 2, 9, 'Sidebar', 0, '0', 0, 0),
(70, 2, 26, 'Main', 0, '1', 0, 0),
(70, 2, 27, 'Main', 1, '1', 0, 1),
(70, 3, 7, 'Header Nav', 0, '0', 0, 0),
(70, 3, 8, 'Header', 0, '0', 0, 0),
(70, 3, 9, 'Sidebar', 0, '0', 0, 0),
(70, 3, 26, 'Main', 0, '0', 0, 0),
(71, 1, 1, 'Header Nav', 0, '0', 0, 0),
(71, 1, 2, 'Header', 0, '0', 0, 0),
(71, 1, 3, 'Sidebar', 0, '0', 0, 0),
(71, 2, 1, 'Header Nav', 0, '0', 0, 0),
(71, 2, 2, 'Header', 0, '0', 0, 0),
(71, 2, 28, 'Sidebar', 0, '1', 0, 0),
(71, 2, 29, 'Sidebar', 1, '1', 0, 0),
(71, 2, 30, 'Main', 0, '1', 0, 0),
(72, 1, 12, 'Header Nav', 0, '0', 0, 0),
(72, 1, 13, 'Header', 0, '0', 0, 0),
(72, 1, 14, 'Blog Post Header', 0, '0', 0, 0),
(72, 1, 15, 'Main', 0, '0', 0, 0),
(72, 1, 16, 'Blog Post More', 0, '0', 0, 0),
(72, 1, 17, 'Blog Post Footer', 0, '0', 0, 0),
(72, 1, 18, 'Sidebar', 0, '0', 0, 0),
(72, 1, 23, 'Sidebar', 1, '0', 0, 0),
(72, 2, 12, 'Header Nav', 0, '0', 0, 0),
(72, 2, 13, 'Header', 0, '0', 0, 0),
(72, 2, 14, 'Blog Post Header', 0, '0', 0, 0),
(72, 2, 32, 'Blog Post More', 0, '1', 0, 0),
(72, 2, 33, 'Sidebar', 1, '1', 0, 0),
(72, 2, 17, 'Blog Post Footer', 0, '0', 0, 0),
(72, 2, 18, 'Sidebar', 0, '0', 0, 0),
(72, 3, 12, 'Header Nav', 0, '0', 0, 0),
(72, 2, 31, 'Main', 0, '1', 0, 0),
(72, 3, 13, 'Header', 0, '0', 0, 0),
(72, 3, 14, 'Blog Post Header', 0, '0', 0, 0),
(72, 3, 17, 'Blog Post Footer', 0, '0', 0, 0),
(72, 3, 18, 'Sidebar', 0, '0', 0, 0),
(72, 3, 35, 'Blog Post More', 0, '1', 0, 0),
(73, 1, 12, 'Header Nav', 0, '0', 0, 0),
(72, 3, 33, 'Sidebar', 1, '0', 0, 0),
(72, 3, 34, 'Main', 0, '1', 0, 0),
(73, 1, 13, 'Header', 0, '0', 0, 0),
(73, 1, 14, 'Blog Post Header', 0, '0', 0, 0),
(73, 1, 15, 'Main', 0, '0', 0, 0),
(73, 1, 16, 'Blog Post More', 0, '0', 0, 0),
(73, 1, 17, 'Blog Post Footer', 0, '0', 0, 0),
(73, 1, 18, 'Sidebar', 0, '0', 0, 0),
(73, 1, 23, 'Sidebar', 1, '0', 0, 0),
(73, 2, 12, 'Header Nav', 0, '0', 0, 0),
(73, 2, 13, 'Header', 0, '0', 0, 0),
(73, 2, 14, 'Blog Post Header', 0, '0', 0, 0),
(73, 2, 38, 'Blog Post More', 0, '1', 0, 0),
(73, 2, 37, 'Main', 1, '1', 0, 1),
(73, 2, 17, 'Blog Post Footer', 0, '0', 0, 0),
(73, 2, 18, 'Sidebar', 0, '0', 0, 0),
(73, 2, 23, 'Sidebar', 1, '0', 0, 0),
(73, 2, 36, 'Main', 0, '1', 0, 0),
(73, 3, 12, 'Header Nav', 0, '0', 0, 0),
(73, 3, 13, 'Header', 0, '0', 0, 0),
(73, 3, 14, 'Blog Post Header', 0, '0', 0, 0),
(73, 3, 17, 'Blog Post Footer', 0, '0', 0, 0),
(73, 3, 18, 'Sidebar', 0, '0', 0, 0),
(73, 3, 36, 'Main', 0, '0', 0, 0),
(73, 3, 38, 'Blog Post More', 0, '0', 0, 0),
(73, 3, 39, 'Sidebar', 1, '1', 0, 0),
(66, 1, 40, 'Blog Post Footer', 0, '1', 0, 0),
(73, 3, 40, 'Blog Post Footer', 1, '0', 0, 0),
(72, 3, 40, 'Blog Post Footer', 1, '0', 0, 0),
(72, 4, 12, 'Header Nav', 0, '0', 0, 0),
(72, 4, 13, 'Header', 0, '0', 0, 0),
(72, 4, 14, 'Blog Post Header', 0, '0', 0, 0),
(72, 4, 17, 'Blog Post Footer', 1, '0', 0, 0),
(72, 4, 18, 'Sidebar', 0, '0', 0, 0),
(72, 4, 34, 'Main', 0, '0', 0, 0),
(72, 4, 35, 'Blog Post More', 0, '0', 0, 0),
(72, 4, 33, 'Sidebar', 1, '0', 0, 0),
(72, 4, 40, 'Blog Post Footer', 0, '0', 0, 0),
(73, 4, 12, 'Header Nav', 0, '0', 0, 0),
(73, 4, 13, 'Header', 0, '0', 0, 0),
(73, 4, 14, 'Blog Post Header', 0, '0', 0, 0),
(73, 4, 17, 'Blog Post Footer', 1, '0', 0, 0),
(73, 4, 18, 'Sidebar', 0, '0', 0, 0),
(73, 4, 36, 'Main', 0, '0', 0, 0),
(73, 4, 38, 'Blog Post More', 0, '0', 0, 0),
(73, 4, 39, 'Sidebar', 1, '0', 0, 0),
(73, 4, 40, 'Blog Post Footer', 0, '0', 0, 0),
(36, 2, 41, 'Global', 0, '1', 0, 0),
(1, 4, 2, 'Header', 0, '0', 0, 0),
(1, 4, 44, 'Header', 1, '1', 0, 0),
(1, 4, 45, 'Header Nav', 1, '1', 0, 0),
(1, 4, 46, 'Header Nav', 2, '1', 0, 0),
(1, 5, 2, 'Header', 0, '0', 0, 0),
(1, 5, 48, 'Header', 1, '1', 0, 0);

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

--
-- 表的结构 `CollectionVersionBlockStyles`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionBlockStyles` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '0',
  `bID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) NOT NULL,
  `csrID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`cvID`,`bID`,`arHandle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `CollectionVersionBlockStyles`
--

INSERT INTO `CollectionVersionBlockStyles` (`cID`, `cvID`, `bID`, `arHandle`, `csrID`) VALUES
(1, 2, 1, 'Header Nav', 0),
(1, 2, 2, 'Header', 0),
(1, 3, 43, 'Header Nav', 0),
(1, 3, 2, 'Header', 0),
(67, 1, 7, 'Header Nav', 0),
(67, 1, 8, 'Header', 0),
(67, 1, 9, 'Sidebar', 0),
(67, 2, 7, 'Header Nav', 0),
(67, 2, 8, 'Header', 0),
(67, 2, 9, 'Sidebar', 0),
(68, 1, 7, 'Header Nav', 0),
(68, 1, 8, 'Header', 0),
(68, 1, 9, 'Sidebar', 0),
(68, 2, 7, 'Header Nav', 0),
(68, 2, 8, 'Header', 0),
(68, 2, 9, 'Sidebar', 0),
(69, 1, 8, 'Header', 0),
(69, 1, 7, 'Header Nav', 0),
(69, 1, 9, 'Sidebar', 0),
(69, 2, 7, 'Header Nav', 0),
(69, 2, 8, 'Header', 0),
(69, 2, 9, 'Sidebar', 0),
(69, 3, 7, 'Header Nav', 0),
(69, 3, 8, 'Header', 0),
(69, 3, 9, 'Sidebar', 0),
(69, 3, 24, 'Main', 0),
(70, 1, 7, 'Header Nav', 0),
(70, 1, 8, 'Header', 0),
(70, 1, 9, 'Sidebar', 0),
(70, 2, 7, 'Header Nav', 0),
(70, 2, 8, 'Header', 0),
(70, 2, 9, 'Sidebar', 0),
(70, 3, 7, 'Header Nav', 0),
(70, 3, 8, 'Header', 0),
(70, 3, 9, 'Sidebar', 0),
(70, 3, 26, 'Main', 0),
(71, 1, 1, 'Header Nav', 0),
(71, 1, 2, 'Header', 0),
(71, 1, 3, 'Sidebar', 0),
(71, 2, 1, 'Header Nav', 0),
(71, 2, 2, 'Header', 0),
(72, 1, 12, 'Header Nav', 0),
(72, 1, 13, 'Header', 0),
(72, 1, 14, 'Blog Post Header', 0),
(72, 1, 15, 'Main', 0),
(72, 1, 16, 'Blog Post More', 0),
(72, 1, 17, 'Blog Post Footer', 0),
(72, 1, 18, 'Sidebar', 0),
(72, 1, 23, 'Sidebar', 0),
(72, 2, 12, 'Header Nav', 0),
(72, 2, 13, 'Header', 0),
(72, 2, 14, 'Blog Post Header', 0),
(72, 2, 32, 'Blog Post More', 0),
(72, 2, 33, 'Sidebar', 0),
(72, 2, 17, 'Blog Post Footer', 0),
(72, 2, 18, 'Sidebar', 0),
(72, 3, 12, 'Header Nav', 0),
(72, 2, 31, 'Main', 0),
(72, 3, 13, 'Header', 0),
(72, 3, 14, 'Blog Post Header', 0),
(72, 3, 17, 'Blog Post Footer', 0),
(72, 3, 18, 'Sidebar', 0),
(72, 3, 35, 'Blog Post More', 0),
(73, 1, 12, 'Header Nav', 0),
(72, 3, 33, 'Sidebar', 0),
(72, 3, 34, 'Main', 0),
(73, 1, 13, 'Header', 0),
(73, 1, 14, 'Blog Post Header', 0),
(73, 1, 15, 'Main', 0),
(73, 1, 16, 'Blog Post More', 0),
(73, 1, 17, 'Blog Post Footer', 0),
(73, 1, 18, 'Sidebar', 0),
(73, 1, 23, 'Sidebar', 0),
(73, 2, 12, 'Header Nav', 0),
(73, 2, 13, 'Header', 0),
(73, 2, 14, 'Blog Post Header', 0),
(73, 3, 13, 'Header', 0),
(73, 3, 12, 'Header Nav', 0),
(73, 2, 17, 'Blog Post Footer', 0),
(73, 2, 18, 'Sidebar', 0),
(73, 2, 23, 'Sidebar', 0),
(73, 2, 36, 'Main', 0),
(73, 3, 14, 'Blog Post Header', 0),
(73, 3, 17, 'Blog Post Footer', 0),
(73, 3, 18, 'Sidebar', 0),
(73, 3, 36, 'Main', 0),
(73, 3, 38, 'Blog Post More', 0),
(73, 3, 39, 'Sidebar', 0),
(73, 3, 40, 'Blog Post Footer', 0),
(72, 3, 40, 'Blog Post Footer', 0),
(1, 4, 2, 'Header', 0),
(1, 4, 43, 'Header Nav', 0),
(1, 5, 2, 'Header', 0),
(1, 5, 48, 'Header', 0);

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

--
-- 表的结构 `CollectionVersions`
--

CREATE TABLE IF NOT EXISTS `CollectionVersions` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `cvID` int(10) unsigned NOT NULL DEFAULT '1',
  `cvName` text,
  `cvHandle` varchar(64) DEFAULT NULL,
  `cvDescription` text,
  `cvDatePublic` datetime DEFAULT NULL,
  `cvDateCreated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cvComments` varchar(255) DEFAULT NULL,
  `cvIsApproved` tinyint(1) NOT NULL DEFAULT '0',
  `cvIsNew` tinyint(1) NOT NULL DEFAULT '0',
  `cvAuthorUID` int(10) unsigned DEFAULT NULL,
  `cvApproverUID` int(10) unsigned DEFAULT NULL,
  `cvActivateDatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`cID`,`cvID`),
  KEY `cvIsApproved` (`cvIsApproved`),
  KEY `cvName` (`cvName`(128))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `CollectionVersions`
--

INSERT INTO `CollectionVersions` (`cID`, `cvID`, `cvName`, `cvHandle`, `cvDescription`, `cvDatePublic`, `cvDateCreated`, `cvComments`, `cvIsApproved`, `cvIsNew`, `cvAuthorUID`, `cvApproverUID`, `cvActivateDatetime`) VALUES
(2, 1, NULL, NULL, NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(1, 2, 'Home', 'home', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'New Version 2', 0, 0, 1, 1, NULL),
(5, 1, 'Login', 'login', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(6, 1, 'Register', 'register', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(7, 1, 'Profile', 'profile', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(8, 1, 'Edit', 'edit', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(10, 1, 'Avatar', 'avatar', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(11, 1, 'Messages', 'messages', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(12, 1, 'Friends', 'friends', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(13, 1, 'Page Not Found', 'page_not_found', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(14, 1, 'Page Forbidden', 'page_forbidden', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(15, 1, 'Dashboard', 'dashboard', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(16, 1, 'Sitemap', 'sitemap', 'Whole world at a glance.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(17, 1, 'Full Sitemap', 'full', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(18, 1, 'Flat View', 'explore', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(19, 1, 'Page Search', 'search', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(20, 1, 'Access', 'access', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(21, 1, 'File Manager', 'files', 'All documents and images.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(22, 1, 'Search', 'search', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(23, 1, 'Attributes', 'attributes', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(24, 1, 'Sets', 'sets', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(25, 1, 'Access', 'access', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(26, 1, 'Reports', 'reports', 'Get data from forms and logs.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(27, 1, 'Form Results', 'forms', 'Get submission data.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(28, 1, 'Surveys', 'surveys', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(29, 1, 'Logs', 'logs', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(30, 1, 'Users and Groups', 'users', 'Add and manage people.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(31, 1, 'Find Users', 'search', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(32, 1, 'Add User', 'add', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(33, 1, 'Groups', 'groups', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(34, 1, 'User Attributes', 'attributes', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(35, 1, 'Login & Registration', 'registration', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(36, 1, 'Scrapbook', 'scrapbook', 'Share content across your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(37, 1, 'Pages and Themes', 'pages', 'Reskin your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(38, 1, 'Themes', 'themes', 'Reskin your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(39, 1, 'Add', 'add', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(40, 1, 'Inspect', 'inspect', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(41, 1, 'Customize', 'customize', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(43, 1, 'Page Types', 'types', 'What goes in your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(44, 1, 'Attributes', 'attributes', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(45, 1, 'Single Pages', 'single', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(46, 1, 'Add Functionality', 'install', 'Install addons & themes.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(47, 1, 'System & Maintenance', 'system', 'Backup, cleanup and update.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(48, 1, 'Jobs', 'jobs', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(49, 1, 'Backup & Restore', 'backup', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(50, 1, 'Update', 'update', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(51, 1, 'Notifications', 'notifications', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(52, 1, 'Sitewide Settings', 'settings', 'Secure and setup your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(53, 1, 'Email', 'mail', 'Enable post via email and other settings.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(54, 1, 'Marketplace', 'marketplace', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(55, 1, 'Download File', 'download_file', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, 1, NULL, NULL),
(63, 1, NULL, 'uID=1', NULL, '2011-04-19 11:21:09', '2011-04-19 11:21:09', 'Initial Version', 1, 0, NULL, NULL, NULL),
(64, 1, 'Members', 'members', NULL, '2010-10-01 16:04:12', '2010-10-01 16:04:12', 'Initial Version', 1, 0, 1, NULL, NULL),
(1, 3, 'Home', 'home', NULL, '2011-04-19 11:21:09', '2011-04-19 11:29:12', 'New Version 3', 0, 0, 1, 1, NULL),
(1, 4, 'Home', 'home', NULL, '2011-04-19 11:21:09', '2011-04-19 11:31:52', 'Version 4', 0, 0, 1, 1, NULL),
(1, 5, 'Home', 'home', NULL, '2011-04-19 11:21:09', '2011-10-11 20:16:12', 'New Version 5', 1, 0, 1, 1, NULL);

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

--
-- 表的结构 `Config`
--

CREATE TABLE IF NOT EXISTS `Config` (
  `cfKey` varchar(64) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cfValue` longtext,
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cfKey`,`uID`),
  KEY `uID` (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `Config`
--

INSERT INTO `Config` (`cfKey`, `timestamp`, `cfValue`, `uID`, `pkgID`) VALUES
('SITE', '2011-04-19 17:36:12', 'T O P O F O R M S', 0, 0),
('SITE_APP_VERSION', '2011-04-19 17:21:09', '5.4.1.1', 0, 0),
('SITE_DEBUG_LEVEL', '2011-04-19 17:21:09', '1', 0, 0),
('ENABLE_LOG_EMAILS', '2011-04-19 17:21:09', '1', 0, 0),
('ENABLE_LOG_ERRORS', '2011-04-19 17:21:09', '1', 0, 0),
('FULL_PAGE_CACHE_GLOBAL', '2011-04-19 17:21:09', '0', 0, 0),
('ENABLE_MARKETPLACE_SUPPORT', '2011-04-19 17:21:55', '1', 0, 0),
('APP_VERSION_LATEST', '2011-10-08 14:07:44', '5.4.2.1', 0, 0);

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

--
-- 表的结构 `CustomStylePresets`
--

CREATE TABLE IF NOT EXISTS `CustomStylePresets` (
  `cspID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cspName` varchar(255) NOT NULL,
  `csrID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cspID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `CustomStyleRules`
--

CREATE TABLE IF NOT EXISTS `CustomStyleRules` (
  `csrID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `css_id` varchar(128) DEFAULT NULL,
  `css_class` varchar(128) DEFAULT NULL,
  `css_serialized` text,
  `css_custom` text,
  PRIMARY KEY (`csrID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `DashboardHomepage`
--

CREATE TABLE IF NOT EXISTS `DashboardHomepage` (
  `dbhID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dbhModule` varchar(255) NOT NULL,
  `dbhDisplayName` varchar(255) DEFAULT NULL,
  `dbhDisplayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`dbhID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- 转存表中的数据 `DashboardHomepage`
--

INSERT INTO `DashboardHomepage` (`dbhID`, `dbhModule`, `dbhDisplayName`, `dbhDisplayOrder`, `pkgID`) VALUES
(1, 'activity', 'Site Activity', 0, 0),
(2, 'reports', 'Statistics', 0, 0),
(3, 'help', 'Help', 0, 0),
(4, 'news', 'Latest News', 0, 0),
(5, 'notes', 'Notes', 0, 0);

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

--
-- 表的结构 `DownloadStatistics`
--

CREATE TABLE IF NOT EXISTS `DownloadStatistics` (
  `dsID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fID` int(10) unsigned NOT NULL,
  `fvID` int(10) unsigned NOT NULL,
  `uID` int(10) unsigned NOT NULL,
  `rcID` int(10) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `FileAttributeValues`
--

CREATE TABLE IF NOT EXISTS `FileAttributeValues` (
  `fID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fID`,`fvID`,`akID`,`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `FileAttributeValues`
--

INSERT INTO `FileAttributeValues` (`fID`, `fvID`, `akID`, `avID`) VALUES
(1, 1, 9, 1),
(1, 1, 10, 2),
(2, 1, 9, 3),
(2, 1, 10, 4),
(3, 1, 9, 5),
(3, 1, 10, 6),
(4, 1, 9, 7),
(4, 1, 10, 8),
(5, 1, 9, 9),
(5, 1, 10, 10);

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

--
-- 表的结构 `FilePermissionFileTypes`
--

CREATE TABLE IF NOT EXISTS `FilePermissionFileTypes` (
  `fsID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `extension` varchar(32) NOT NULL,
  PRIMARY KEY (`fsID`,`gID`,`uID`,`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `FilePermissions`
--

CREATE TABLE IF NOT EXISTS `FilePermissions` (
  `fID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `canRead` int(4) NOT NULL DEFAULT '0',
  `canWrite` int(4) NOT NULL DEFAULT '0',
  `canAdmin` int(4) NOT NULL DEFAULT '0',
  `canSearch` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fID`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `FileSearchIndexAttributes`
--

CREATE TABLE IF NOT EXISTS `FileSearchIndexAttributes` (
  `fID` int(11) unsigned NOT NULL DEFAULT '0',
  `ak_width` decimal(14,4) DEFAULT '0.0000',
  `ak_height` decimal(14,4) DEFAULT '0.0000',
  PRIMARY KEY (`fID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 转存表中的数据 `FileSearchIndexAttributes`
--

INSERT INTO `FileSearchIndexAttributes` (`fID`, `ak_width`, `ak_height`) VALUES
(1, 800.0000, 192.0000),
(2, 800.0000, 192.0000),
(3, 800.0000, 192.0000),
(4, 800.0000, 215.0000),
(5, 800.0000, 192.0000);

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

--
-- 表的结构 `FileSetFiles`
--

CREATE TABLE IF NOT EXISTS `FileSetFiles` (
  `fsfID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fID` int(10) unsigned NOT NULL,
  `fsID` int(10) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fsDisplayOrder` int(10) unsigned NOT NULL,
  PRIMARY KEY (`fsfID`),
  KEY `fID` (`fID`),
  KEY `fsID` (`fsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `FileSetPermissions`
--

CREATE TABLE IF NOT EXISTS `FileSetPermissions` (
  `fsID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `canRead` int(4) DEFAULT NULL,
  `canWrite` int(4) DEFAULT NULL,
  `canAdmin` int(4) DEFAULT NULL,
  `canAdd` int(4) DEFAULT NULL,
  `canSearch` int(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`fsID`,`gID`,`uID`),
  KEY `canRead` (`canRead`),
  KEY `canWrite` (`canWrite`),
  KEY `canAdmin` (`canAdmin`),
  KEY `canSearch` (`canSearch`),
  KEY `canAdd` (`canAdd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `FileSetPermissions`
--

INSERT INTO `FileSetPermissions` (`fsID`, `gID`, `uID`, `canRead`, `canWrite`, `canAdmin`, `canAdd`, `canSearch`) VALUES
(0, 1, 0, 10, 0, 0, 0, 0),
(0, 2, 0, 10, 0, 0, 0, 0),
(0, 3, 0, 10, 10, 10, 10, 10);

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

--
-- 表的结构 `FileSets`
--

CREATE TABLE IF NOT EXISTS `FileSets` (
  `fsID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fsName` varchar(64) NOT NULL,
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `fsType` int(4) NOT NULL,
  `fsOverrideGlobalPermissions` int(4) DEFAULT NULL,
  PRIMARY KEY (`fsID`),
  KEY `fsOverrideGlobalPermissions` (`fsOverrideGlobalPermissions`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `FileSetSavedSearches`
--

CREATE TABLE IF NOT EXISTS `FileSetSavedSearches` (
  `fsID` int(10) unsigned NOT NULL DEFAULT '0',
  `fsSearchRequest` text,
  `fsResultColumns` text,
  PRIMARY KEY (`fsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `FileStorageLocations`
--

CREATE TABLE IF NOT EXISTS `FileStorageLocations` (
  `fslID` int(10) unsigned NOT NULL DEFAULT '0',
  `fslName` varchar(255) NOT NULL,
  `fslDirectory` varchar(255) NOT NULL,
  PRIMARY KEY (`fslID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `FileVersionLog`
--

CREATE TABLE IF NOT EXISTS `FileVersionLog` (
  `fvlID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvUpdateTypeID` int(3) unsigned NOT NULL DEFAULT '0',
  `fvUpdateTypeAttributeID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fvlID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- 转存表中的数据 `FileVersionLog`
--

INSERT INTO `FileVersionLog` (`fvlID`, `fID`, `fvID`, `fvUpdateTypeID`, `fvUpdateTypeAttributeID`) VALUES
(1, 1, 1, 5, 9),
(2, 1, 1, 5, 10),
(3, 2, 1, 5, 9),
(4, 2, 1, 5, 10),
(5, 3, 1, 5, 9),
(6, 3, 1, 5, 10),
(7, 4, 1, 5, 9),
(8, 4, 1, 5, 10),
(9, 5, 1, 5, 9),
(10, 5, 1, 5, 10),
(11, 1, 1, 3, 0),
(12, 1, 1, 4, 0),
(13, 2, 1, 3, 0),
(14, 2, 1, 4, 0),
(15, 3, 1, 3, 0),
(16, 3, 1, 4, 0),
(17, 4, 1, 3, 0),
(18, 4, 1, 4, 0),
(19, 5, 1, 3, 0),
(20, 5, 1, 4, 0);

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

--
-- 表的结构 `FileVersions`
--

CREATE TABLE IF NOT EXISTS `FileVersions` (
  `fID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvFilename` varchar(255) NOT NULL,
  `fvPrefix` varchar(12) DEFAULT NULL,
  `fvGenericType` int(3) unsigned NOT NULL DEFAULT '0',
  `fvSize` int(20) unsigned NOT NULL DEFAULT '0',
  `fvTitle` varchar(255) DEFAULT NULL,
  `fvDescription` text,
  `fvTags` varchar(255) DEFAULT NULL,
  `fvIsApproved` int(10) unsigned NOT NULL DEFAULT '1',
  `fvDateAdded` datetime DEFAULT NULL,
  `fvApproverUID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvAuthorUID` int(10) unsigned NOT NULL DEFAULT '0',
  `fvActivateDatetime` datetime DEFAULT NULL,
  `fvHasThumbnail1` int(1) NOT NULL DEFAULT '0',
  `fvHasThumbnail2` int(1) NOT NULL DEFAULT '0',
  `fvHasThumbnail3` int(1) NOT NULL DEFAULT '0',
  `fvExtension` varchar(32) DEFAULT NULL,
  `fvType` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fID`,`fvID`),
  KEY `fvExtension` (`fvType`),
  KEY `fvTitle` (`fvTitle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `FileVersions`
--

INSERT INTO `FileVersions` (`fID`, `fvID`, `fvFilename`, `fvPrefix`, `fvGenericType`, `fvSize`, `fvTitle`, `fvDescription`, `fvTags`, `fvIsApproved`, `fvDateAdded`, `fvApproverUID`, `fvAuthorUID`, `fvActivateDatetime`, `fvHasThumbnail1`, `fvHasThumbnail2`, `fvHasThumbnail3`, `fvExtension`, `fvType`) VALUES
(1, 1, 'inneroptics_dot_net_aspens.jpg', '371285369023', 1, 108199, 'inneroptics_dot_net_aspens.jpg', '', '\n\n', 1, '2011-04-19 11:21:12', 1, 1, '2011-04-19 11:21:12', 1, 1, 0, 'jpg', 1),
(2, 1, 'inneroptics_dot_net_canyonlands.jpg', '911285369025', 1, 54531, 'inneroptics_dot_net_canyonlands.jpg', '', '\n\n', 1, '2011-04-19 11:21:12', 1, 1, '2011-04-19 11:21:12', 1, 1, 0, 'jpg', 1),
(3, 1, 'inneroptics_dot_net_new_zealand_sheep.jpg', '851285369025', 1, 80735, 'inneroptics_dot_net_new_zealand_sheep.jpg', '', '\n\n', 1, '2011-04-19 11:21:12', 1, 1, '2011-04-19 11:21:12', 1, 1, 0, 'jpg', 1),
(4, 1, 'inneroptics_dot_net_portland.jpg', '711285369026', 1, 55737, 'inneroptics_dot_net_portland.jpg', '', '\n\n', 1, '2011-04-19 11:21:12', 1, 1, '2011-04-19 11:21:12', 1, 1, 0, 'jpg', 1),
(5, 1, 'inneroptics_dot_net_starfish.jpg', '701285369026', 1, 88621, 'inneroptics_dot_net_starfish.jpg', '', '\n\n', 1, '2011-04-19 11:21:12', 1, 1, '2011-04-19 11:21:12', 1, 1, 0, 'jpg', 1);

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

--
-- 表的结构 `Groups`
--

CREATE TABLE IF NOT EXISTS `Groups` (
  `gID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gName` varchar(128) NOT NULL,
  `gDescription` varchar(255) NOT NULL,
  `gUserExpirationIsEnabled` int(1) NOT NULL DEFAULT '0',
  `gUserExpirationMethod` varchar(12) DEFAULT NULL,
  `gUserExpirationSetDateTime` datetime DEFAULT NULL,
  `gUserExpirationInterval` int(10) unsigned NOT NULL DEFAULT '0',
  `gUserExpirationAction` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`gID`),
  UNIQUE KEY `gName` (`gName`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `Groups`
--

INSERT INTO `Groups` (`gID`, `gName`, `gDescription`, `gUserExpirationIsEnabled`, `gUserExpirationMethod`, `gUserExpirationSetDateTime`, `gUserExpirationInterval`, `gUserExpirationAction`) VALUES
(1, 'Guest', 'The guest group represents unregistered visitors to your site.', 0, NULL, NULL, 0, NULL),
(2, 'Registered Users', 'The registered users group represents all user accounts.', 0, NULL, NULL, 0, NULL),
(3, 'Administrators', '', 0, NULL, NULL, 0, NULL);

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

--
-- 表的结构 `Jobs`
--

CREATE TABLE IF NOT EXISTS `Jobs` (
  `jID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jName` varchar(100) NOT NULL,
  `jDescription` varchar(255) NOT NULL,
  `jDateInstalled` datetime DEFAULT NULL,
  `jDateLastRun` datetime DEFAULT NULL,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  `jLastStatusText` varchar(255) DEFAULT NULL,
  `jLastStatusCode` smallint(4) NOT NULL DEFAULT '0',
  `jStatus` varchar(14) NOT NULL DEFAULT 'ENABLED',
  `jHandle` varchar(255) NOT NULL,
  `jNotUninstallable` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`jID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `Jobs`
--

INSERT INTO `Jobs` (`jID`, `jName`, `jDescription`, `jDateInstalled`, `jDateLastRun`, `pkgID`, `jLastStatusText`, `jLastStatusCode`, `jStatus`, `jHandle`, `jNotUninstallable`) VALUES
(1, 'Index Search Engine', 'Index the site to allow searching to work quickly and accurately.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 0, 'Index updated. 6 pages required reindexing.', 0, 'ENABLED', 'index_search', 1),
(2, 'Generate Sitemap File', 'Generate the sitemap.xml file that search engines use to crawl your site.', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 0, 'Sitemap XML File Saved.', 0, 'ENABLED', 'generate_sitemap', 0),
(3, 'Process Email Posts', 'Polls an email account and grabs private messages/postings that are sent there..', '2011-04-19 11:21:09', '2011-04-19 11:21:09', 0, 'The Job was run successfully.', 0, 'ENABLED', 'process_email', 0);

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

--
-- 表的结构 `JobsLog`
--

CREATE TABLE IF NOT EXISTS `JobsLog` (
  `jlID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jID` int(10) unsigned NOT NULL,
  `jlMessage` varchar(255) NOT NULL,
  `jlTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `jlError` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`jlID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `JobsLog`
--

INSERT INTO `JobsLog` (`jlID`, `jID`, `jlMessage`, `jlTimestamp`, `jlError`) VALUES
(1, 0, 'Index updated. 6 pages required reindexing.', '2011-04-19 17:21:09', 0),
(2, 0, 'Sitemap XML File Saved.', '2011-04-19 17:21:09', 0),
(3, 0, 'The Job was run successfully.', '2011-04-19 17:21:09', 0);

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

--
-- 表的结构 `LayoutPresets`
--

CREATE TABLE IF NOT EXISTS `LayoutPresets` (
  `lpID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lpName` varchar(128) NOT NULL,
  `layoutID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`lpID`),
  UNIQUE KEY `layoutID` (`layoutID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `Layouts`
--

CREATE TABLE IF NOT EXISTS `Layouts` (
  `layoutID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `layout_rows` int(5) NOT NULL DEFAULT '3',
  `layout_columns` int(3) NOT NULL DEFAULT '3',
  `spacing` int(3) NOT NULL DEFAULT '3',
  `breakpoints` varchar(255) NOT NULL DEFAULT '',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`layoutID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `Logs`
--

CREATE TABLE IF NOT EXISTS `Logs` (
  `logID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `logType` varchar(64) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `logText` longtext,
  `logIsInternal` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`logID`),
  KEY `logType` (`logType`),
  KEY `logIsInternal` (`logIsInternal`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 转存表中的数据 `Logs`
--

INSERT INTO `Logs` (`logID`, `logType`, `timestamp`, `logText`, `logIsInternal`) VALUES
(1, 'sent_emails', '2011-10-08 14:06:36', '**EMAILS ARE ENABLED. THIS EMAIL WAS SENT TO mail()**\nTemplate Used: forgot_password\nTo: royizhu@gmail.com\nFrom: &quot;Forgot Password&quot; &lt;royizhu@gmail.com&gt;\nSubject: Forgot Password\nBody: \n\nDear admin,\n\nYou have requested a new password for the site T O P O F O R M S \n\nYour username is: admin\n\nYou may change your password at the following address:\n\nhttp://www.topoforms.com/index.php/login/change_password/RS2ZSs30lmzq/\n\nThanks for browsing the site!\n\n\n', 1),
(2, 'sent_emails', '2011-10-12 02:13:59', '**EMAILS ARE ENABLED. THIS EMAIL WAS SENT TO mail()**\nTemplate Used: forgot_password\nTo: royizhu@gmail.com\nFrom: &quot;Forgot Password&quot; &lt;royizhu@gmail.com&gt;\nSubject: Forgot Password\nBody: \n\nDear admin,\n\nYou have requested a new password for the site T O P O F O R M S \n\nYour username is: admin\n\nYou may change your password at the following address:\n\nhttp://www.topoforms.com/index.php/login/change_password/NWPCh7EJvzUV/\n\nThanks for browsing the site!\n\n\n', 1);

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

--
-- 表的结构 `MailValidationHashes`
--

CREATE TABLE IF NOT EXISTS `MailValidationHashes` (
  `mvhID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `miID` int(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL,
  `mHash` varchar(128) NOT NULL,
  `mDateGenerated` int(10) unsigned NOT NULL DEFAULT '0',
  `mDateRedeemed` int(10) unsigned NOT NULL DEFAULT '0',
  `data` text,
  PRIMARY KEY (`mvhID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `Packages`
--

CREATE TABLE IF NOT EXISTS `Packages` (
  `pkgID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pkgName` varchar(255) NOT NULL,
  `pkgHandle` varchar(64) NOT NULL,
  `pkgDescription` text,
  `pkgDateInstalled` datetime NOT NULL,
  `pkgIsInstalled` tinyint(1) NOT NULL DEFAULT '1',
  `pkgVersion` varchar(32) DEFAULT NULL,
  `pkgAvailableVersion` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`pkgID`),
  UNIQUE KEY `pkgHandle` (`pkgHandle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `PagePaths`
--

CREATE TABLE IF NOT EXISTS `PagePaths` (
  `ppID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cID` int(10) unsigned DEFAULT '0',
  `cPath` text,
  `ppIsCanonical` varchar(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ppID`),
  KEY `cID` (`cID`),
  KEY `ppIsCanonical` (`ppIsCanonical`),
  KEY `cPath` (`cPath`(128))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

--
-- 转存表中的数据 `PagePaths`
--

INSERT INTO `PagePaths` (`ppID`, `cID`, `cPath`, `ppIsCanonical`) VALUES
(1, 5, '/login', '1'),
(2, 6, '/register', '1'),
(3, 7, '/profile', '1'),
(4, 8, '/profile/edit', '1'),
(6, 10, '/profile/avatar', '1'),
(7, 11, '/profile/messages', '1'),
(8, 12, '/profile/friends', '1'),
(9, 13, '/page_not_found', '1'),
(10, 14, '/page_forbidden', '1'),
(11, 15, '/dashboard', '1'),
(12, 16, '/dashboard/sitemap', '1'),
(13, 17, '/dashboard/sitemap/full', '1'),
(14, 18, '/dashboard/sitemap/explore', '1'),
(15, 19, '/dashboard/sitemap/search', '1'),
(16, 20, '/dashboard/sitemap/access', '1'),
(17, 21, '/dashboard/files', '1'),
(18, 22, '/dashboard/files/search', '1'),
(19, 23, '/dashboard/files/attributes', '1'),
(20, 24, '/dashboard/files/sets', '1'),
(21, 25, '/dashboard/files/access', '1'),
(22, 26, '/dashboard/reports', '1'),
(23, 27, '/dashboard/reports/forms', '1'),
(24, 28, '/dashboard/reports/surveys', '1'),
(25, 29, '/dashboard/reports/logs', '1'),
(26, 30, '/dashboard/users', '1'),
(27, 31, '/dashboard/users/search', '1'),
(28, 32, '/dashboard/users/add', '1'),
(29, 33, '/dashboard/users/groups', '1'),
(30, 34, '/dashboard/users/attributes', '1'),
(31, 35, '/dashboard/users/registration', '1'),
(32, 36, '/dashboard/scrapbook', '1'),
(33, 37, '/dashboard/pages', '1'),
(34, 38, '/dashboard/pages/themes', '1'),
(35, 39, '/dashboard/pages/themes/add', '1'),
(36, 40, '/dashboard/pages/themes/inspect', '1'),
(37, 41, '/dashboard/pages/themes/customize', '1'),
(39, 43, '/dashboard/pages/types', '1'),
(40, 44, '/dashboard/pages/attributes', '1'),
(41, 45, '/dashboard/pages/single', '1'),
(42, 46, '/dashboard/install', '1'),
(43, 47, '/dashboard/system', '1'),
(44, 48, '/dashboard/system/jobs', '1'),
(45, 49, '/dashboard/system/backup', '1'),
(46, 50, '/dashboard/system/update', '1'),
(47, 51, '/dashboard/system/notifications', '1'),
(48, 52, '/dashboard/settings', '1'),
(49, 53, '/dashboard/settings/mail', '1'),
(50, 54, '/dashboard/settings/marketplace', '1'),
(51, 55, '/download_file', '1'),
(52, 64, '/members', '1');

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

--
-- 表的结构 `PagePermissionPageTypes`
--

CREATE TABLE IF NOT EXISTS `PagePermissionPageTypes` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `ctID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`,`gID`,`uID`,`ctID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `PagePermissions`
--

CREATE TABLE IF NOT EXISTS `PagePermissions` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `cgPermissions` varchar(32) DEFAULT NULL,
  `cgStartDate` datetime DEFAULT NULL,
  `cgEndDate` datetime DEFAULT NULL,
  PRIMARY KEY (`cID`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `PagePermissions`
--

INSERT INTO `PagePermissions` (`cID`, `gID`, `uID`, `cgPermissions`, `cgStartDate`, `cgEndDate`) VALUES
(5, 1, 0, 'r', NULL, NULL),
(5, 2, 0, 'r', NULL, NULL),
(6, 1, 0, 'r', NULL, NULL),
(15, 3, 0, 'r:wa:adm', NULL, NULL),
(1, 1, 0, 'r', NULL, NULL),
(1, 3, 0, 'r:rv:wa:db:av:dc:adm', NULL, NULL);

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

--
-- 表的结构 `Pages`
--

CREATE TABLE IF NOT EXISTS `Pages` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `ctID` int(10) unsigned NOT NULL DEFAULT '0',
  `cIsTemplate` varchar(1) NOT NULL DEFAULT '0',
  `uID` int(10) unsigned DEFAULT NULL,
  `cIsCheckedOut` tinyint(1) NOT NULL DEFAULT '0',
  `cCheckedOutUID` int(10) unsigned DEFAULT NULL,
  `cCheckedOutDatetime` datetime DEFAULT NULL,
  `cCheckedOutDatetimeLastEdit` datetime DEFAULT NULL,
  `cPendingAction` varchar(6) DEFAULT NULL,
  `cPendingActionDatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cPendingActionUID` int(10) unsigned DEFAULT NULL,
  `cPendingActionTargetCID` int(10) unsigned DEFAULT NULL,
  `cOverrideTemplatePermissions` tinyint(1) NOT NULL DEFAULT '1',
  `cInheritPermissionsFromCID` int(10) unsigned NOT NULL DEFAULT '0',
  `cInheritPermissionsFrom` varchar(8) NOT NULL DEFAULT 'PARENT',
  `cFilename` varchar(255) DEFAULT NULL,
  `cPointerID` int(10) unsigned NOT NULL DEFAULT '0',
  `cPointerExternalLink` varchar(255) DEFAULT NULL,
  `cPointerExternalLinkNewWindow` tinyint(1) NOT NULL DEFAULT '0',
  `cChildren` int(10) unsigned NOT NULL DEFAULT '0',
  `cDisplayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  `cParentID` int(10) unsigned NOT NULL DEFAULT '0',
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  `ptID` int(10) unsigned NOT NULL DEFAULT '0',
  `cCacheFullPageContent` int(4) NOT NULL DEFAULT '-1',
  `cCacheFullPageContentOverrideLifetime` varchar(32) NOT NULL DEFAULT '0',
  `cCacheFullPageContentLifetimeCustom` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cID`),
  KEY `cParentID` (`cParentID`),
  KEY `cCheckedOutUID` (`cCheckedOutUID`),
  KEY `cPointerID` (`cPointerID`),
  KEY `uID` (`uID`),
  KEY `ctID` (`ctID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `Pages`
--

INSERT INTO `Pages` (`cID`, `ctID`, `cIsTemplate`, `uID`, `cIsCheckedOut`, `cCheckedOutUID`, `cCheckedOutDatetime`, `cCheckedOutDatetimeLastEdit`, `cPendingAction`, `cPendingActionDatetime`, `cPendingActionUID`, `cPendingActionTargetCID`, `cOverrideTemplatePermissions`, `cInheritPermissionsFromCID`, `cInheritPermissionsFrom`, `cFilename`, `cPointerID`, `cPointerExternalLink`, `cPointerExternalLinkNewWindow`, `cChildren`, `cDisplayOrder`, `cParentID`, `pkgID`, `ptID`, `cCacheFullPageContent`, `cCacheFullPageContentOverrideLifetime`, `cCacheFullPageContentLifetimeCustom`) VALUES
(1, 1, '0', 1, 1, 1, '2011-10-11 21:37:37', '2011-10-11 21:37:37', NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'OVERRIDE', NULL, 0, NULL, 0, 7, 0, 0, 0, 1, -1, '0', 0),
(2, 1, '1', NULL, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 0, 'PARENT', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, -1, '0', 0),
(5, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 5, 'OVERRIDE', '/login.php', 0, NULL, 0, 0, 0, 1, 0, 1, -1, '0', 0),
(6, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 6, 'OVERRIDE', '/register.php', 0, NULL, 0, 0, 1, 1, 0, 1, -1, '0', 0),
(7, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/profile/view.php', 0, NULL, 0, 4, 2, 1, 0, 1, -1, '0', 0),
(8, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/profile/edit.php', 0, NULL, 0, 0, 0, 7, 0, 1, -1, '0', 0),
(10, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/profile/avatar.php', 0, NULL, 0, 0, 1, 7, 0, 1, -1, '0', 0),
(11, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/profile/messages.php', 0, NULL, 0, 0, 2, 7, 0, 1, -1, '0', 0),
(12, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/profile/friends.php', 0, NULL, 0, 0, 3, 7, 0, 1, -1, '0', 0),
(13, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/page_not_found.php', 0, NULL, 0, 0, 4, 1, 0, 1, -1, '0', 0),
(14, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/page_forbidden.php', 0, NULL, 0, 0, 5, 1, 0, 1, -1, '0', 0),
(15, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'OVERRIDE', '/dashboard/view.php', 0, NULL, 0, 9, 6, 1, 0, 0, -1, '0', 0),
(16, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/sitemap/view.php', 0, NULL, 0, 4, 0, 15, 0, 0, -1, '0', 0),
(17, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/sitemap/full.php', 0, NULL, 0, 0, 0, 16, 0, 0, -1, '0', 0),
(18, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/sitemap/explore.php', 0, NULL, 0, 0, 1, 16, 0, 0, -1, '0', 0),
(19, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/sitemap/search.php', 0, NULL, 0, 0, 2, 16, 0, 0, -1, '0', 0),
(20, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/sitemap/access.php', 0, NULL, 0, 0, 3, 16, 0, 0, -1, '0', 0),
(21, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/files/view.php', 0, NULL, 0, 4, 1, 15, 0, 0, -1, '0', 0),
(22, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/files/search.php', 0, NULL, 0, 0, 0, 21, 0, 0, -1, '0', 0),
(23, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/files/attributes.php', 0, NULL, 0, 0, 1, 21, 0, 0, -1, '0', 0),
(24, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/files/sets.php', 0, NULL, 0, 0, 2, 21, 0, 0, -1, '0', 0),
(25, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/files/access.php', 0, NULL, 0, 0, 3, 21, 0, 0, -1, '0', 0),
(26, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/reports.php', 0, NULL, 0, 3, 2, 15, 0, 0, -1, '0', 0),
(27, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/reports/forms.php', 0, NULL, 0, 0, 0, 26, 0, 0, -1, '0', 0),
(28, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/reports/surveys.php', 0, NULL, 0, 0, 1, 26, 0, 0, -1, '0', 0),
(29, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/reports/logs.php', 0, NULL, 0, 0, 2, 26, 0, 0, -1, '0', 0),
(30, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/view.php', 0, NULL, 0, 5, 3, 15, 0, 0, -1, '0', 0),
(31, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/search.php', 0, NULL, 0, 0, 0, 30, 0, 0, -1, '0', 0),
(32, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/add.php', 0, NULL, 0, 0, 1, 30, 0, 0, -1, '0', 0),
(33, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/groups.php', 0, NULL, 0, 0, 2, 30, 0, 0, -1, '0', 0),
(34, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/attributes.php', 0, NULL, 0, 0, 3, 30, 0, 0, -1, '0', 0),
(35, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/users/registration.php', 0, NULL, 0, 0, 4, 30, 0, 0, -1, '0', 0),
(36, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/scrapbook/view.php', 0, NULL, 0, 0, 4, 15, 0, 0, -1, '0', 0),
(37, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/view.php', 0, NULL, 0, 4, 5, 15, 0, 0, -1, '0', 0),
(38, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/themes/view.php', 0, NULL, 0, 4, 0, 37, 0, 0, -1, '0', 0),
(39, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/themes/add.php', 0, NULL, 0, 0, 0, 38, 0, 0, -1, '0', 0),
(40, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/themes/inspect.php', 0, NULL, 0, 0, 1, 38, 0, 0, -1, '0', 0),
(41, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/themes/customize.php', 0, NULL, 0, 0, 2, 38, 0, 0, -1, '0', 0),
(43, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/types/view.php', 0, NULL, 0, 0, 1, 37, 0, 0, -1, '0', 0),
(44, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/attributes.php', 0, NULL, 0, 0, 2, 37, 0, 0, -1, '0', 0),
(45, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/pages/single.php', 0, NULL, 0, 0, 3, 37, 0, 0, -1, '0', 0),
(46, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/install.php', 0, NULL, 0, 0, 6, 15, 0, 0, -1, '0', 0),
(47, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/system/view.php', 0, NULL, 0, 4, 7, 15, 0, 0, -1, '0', 0),
(48, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/system/jobs.php', 0, NULL, 0, 0, 0, 47, 0, 0, -1, '0', 0),
(49, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/system/backup.php', 0, NULL, 0, 0, 1, 47, 0, 0, -1, '0', 0),
(50, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/system/update.php', 0, NULL, 0, 0, 2, 47, 0, 0, -1, '0', 0),
(51, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/system/notifications.php', 0, NULL, 0, 0, 3, 47, 0, 0, -1, '0', 0),
(52, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/settings/view.php', 0, NULL, 0, 2, 8, 15, 0, 0, -1, '0', 0),
(53, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/settings/mail/view.php', 0, NULL, 0, 0, 0, 52, 0, 0, -1, '0', 0),
(54, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 15, 'PARENT', '/dashboard/settings/marketplace.php', 0, NULL, 0, 0, 1, 52, 0, 0, -1, '0', 0),
(55, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/download_file.php', 0, NULL, 0, 0, 7, 1, 0, 0, -1, '0', 0),
(64, 0, '0', 1, 0, NULL, NULL, NULL, NULL, '2011-04-19 11:21:10', NULL, NULL, 1, 1, 'PARENT', '/members.php', 0, NULL, 0, 0, 7, 1, 0, 0, -1, '0', 0);

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

--
-- 表的结构 `PageSearchIndex`
--

CREATE TABLE IF NOT EXISTS `PageSearchIndex` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `content` text,
  `cName` varchar(255) DEFAULT NULL,
  `cDescription` text,
  `cPath` text,
  `cDatePublic` datetime DEFAULT NULL,
  `cDateLastIndexed` datetime DEFAULT NULL,
  `cDateLastSitemapped` datetime DEFAULT NULL,
  PRIMARY KEY (`cID`),
  KEY `cDateLastIndexed` (`cDateLastIndexed`),
  KEY `cDateLastSitemapped` (`cDateLastSitemapped`),
  FULLTEXT KEY `cName` (`cName`),
  FULLTEXT KEY `cDescription` (`cDescription`),
  FULLTEXT KEY `content` (`content`),
  FULLTEXT KEY `content2` (`cName`,`cDescription`,`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `PageSearchIndex`
--

INSERT INTO `PageSearchIndex` (`cID`, `content`, `cName`, `cDescription`, `cPath`, `cDatePublic`, `cDateLastIndexed`, `cDateLastSitemapped`) VALUES
(1, 'l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; u r b a n&nbsp;&nbsp;&nbsp; d e s i g n&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; p l a n n i n g \r\n &nbsp; \r\n &nbsp; \r\n for all inquiries, please email us at info@topoforms.com  ', 'Home', NULL, NULL, '2011-04-19 11:21:09', '2011-10-11 20:31:40', NULL),
(67, 'Site Map ', 'Search', '', '/search', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(68, '', 'Search Results', '', '/search/search-results', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(66, ' Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum vel tellus lectus, scelerisque faucibus nunc. Curabitur lacus nibh, eleifend vel porttitor in, bibendum quis tortor. Curabitur eros ligula, scelerisque ac ultricies a, dictum ac tellus. Mauris id tellus tortor. Proin a sollicitudin libero. Nam pellentesque commodo magna, nec mattis elit pulvinar id. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris orci dui, adipiscing sit amet bibendum vel, sodales sed purus. Donec fringilla odio vel enim cursus luctus quis semper leo. Donec rhoncus odio ac elit dignissim lobortis. \r\n &nbsp;   Duis dapibus nibh eu arcu viverra tempor. Fusce auctor sapien eu mauris malesuada vel euismod orci vulputate. Curabitur at orci id quam mollis rhoncus vitae volutpat urna. Nam eget sapien at neque mollis varius sed vitae ipsum. Vestibulum commodo, eros sit amet sagittis cursus, massa mi lacinia lorem, vel pellentesque sapien purus eu lacus. Pellentesque mollis gravida enim. Fusce mi odio, elementum ut fermentum a, pharetra in quam. Mauris sed vestibulum sapien. In sit amet faucibus diam. Proin lectus quam, sodales ut posuere non, viverra a nibh. Aenean sollicitudin, diam eu elementum rutrum, nisi ante pretium mi, ut tristique ante tellus non ligula. Nam diam turpis, viverra non volutpat vel, scelerisque vel neque. In pretium, libero et vulputate varius, libero nulla blandit ligula, tincidunt egestas leo mi eu nisi. Mauris nunc augue, cursus vel viverra non, feugiat in enim. In eget dignissim est. Donec dictum leo in libero tincidunt sollicitudin hendrerit elit placerat. Aliquam vitae nunc diam, non vulputate nibh. Quisque tincidunt, dui ut rutrum feugiat, libero lorem interdum sapien, eget pharetra mi ligula ut lectus. Pellentesque consequat mollis est viverra malesuada. \r\n Curabitur eget quam vitae tellus blandit congue a sed lectus. Nunc ultrices lacus dignissim felis venenatis varius placerat eros dapibus. Nulla facilisi. Vivamus sodales accumsan convallis. Mauris congue tempus feugiat. Proin elementum fringilla leo, sit amet pretium nisl imperdiet interdum. Suspendisse volutpat cursus eros, nec porta est laoreet at. Sed porttitor suscipit augue, eu molestie justo faucibus et. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus faucibus mi vel tortor consequat eget rutrum nisl ultrices. Praesent et lacinia augue. Phasellus id est id enim ultricies placerat. Etiam porta enim eu enim convallis sed eleifend metus faucibus. In ac lobortis eros. Pellentesque felis turpis, cursus sed imperdiet non, viverra vel diam. Donec vel orci mi, placerat egestas purus. Vestibulum vel diam id magna suscipit accumsan. Quisque risus felis, sagittis non iaculis id, tempus in arcu. Donec tempus metus neque. Proin malesuada dui a tortor pretium tincidunt quis at ligula. \r\n Nam laoreet faucibus purus ac pretium. Aenean euismod diam adipiscing erat semper quis sodales elit tristique. Vestibulum vel tellus eu lorem porttitor aliquet. Vestibulum bibendum viverra cursus. Aenean sit amet magna odio, convallis imperdiet metus. Duis condimentum posuere vulputate. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed vitae elit ut sapien vestibulum tempor sit amet ac tortor. Donec ligula nulla, varius id ornare id, vestibulum non felis. Nullam neque erat, tristique a eleifend pellentesque, eleifend sit amet ipsum. In eget urna nibh. Phasellus scelerisque, magna ac feugiat ultricies, risus dolor volutpat quam, in rutrum nunc ante id sem. Fusce interdum scelerisque fermentum. \r\n &nbsp;  ', '', NULL, NULL, '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(69, 'Learn More\r\n Visit&nbsp;concrete5.org&nbsp;to learn more from the&nbsp;community&nbsp;and the&nbsp;documentation. You can also browse our&nbsp;marketplace&nbsp;for more&nbsp;add-ons&nbsp;and&nbsp;themes&nbsp;to quickly build the site you really need.&nbsp; \r\n &nbsp;  Common Tips\r\n Want to&nbsp;change your site name&nbsp;up top? \r\n Need to sell stuff on your website? Check out our&nbsp;eCommerce add-on. \r\n Help,&nbsp;I can''t login&nbsp;anymore! \r\n &nbsp;  ', 'About', '', '/about', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(70, 'Say Hi!\r\n Here''s a simple guestbook you can add to any page on your website to allow comments. Why not put the guestbook block in edit mode and play with the options? \r\n We also have a fully featured&nbsp;Discussions Forum Add-on&nbsp;if you need it.&nbsp; \r\n &nbsp;  ', 'Guestbook', '', '/about/guest-book', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(71, '', 'Blog', '', '/about/guest-book/blog', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(72, ' This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;blog list page.   If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post''s title or more link to read the full post.&nbsp; \r\n Keep your long posts in here and just a short synopsis up top if you''d like a nice scannable blog.  ', 'My First Blog Post', '', '/blog/my-first-blog-post', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL),
(73, ' In-context editing is pretty cool cool!   By now you''ve probably watched through the basics at concrete5.org, so you''re getting a good sense of how you can add pages around your site. To make a new blog post... \r\n\r\nGoto the blog list page, this is the holder page for all your posts in the site tree.&nbsp;\r\nClick Add Page, on the upper left.&nbsp;\r\nPick Blog Entry as a page type.&nbsp;\r\nGive it a name and hit return, or click the add page button at the bottom of the drop down. (You don''t need to worry about all these other fields yet, you can always change them later through Edit Page &gt; Properties\r\nYou''re now on your new blog post page, in edit mode. Start making blocks and get things looking right.&nbsp;\r\nExit Edit Mode and Publish your changes.&nbsp;\r\n ', 'Adding a New Post', '', '/blog/adding-a-new-post', '2011-04-19 11:21:12', '2011-04-19 11:21:12', NULL);

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

--
-- 表的结构 `PageStatistics`
--

CREATE TABLE IF NOT EXISTS `PageStatistics` (
  `pstID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pstID`),
  KEY `cID` (`cID`),
  KEY `date` (`date`),
  KEY `uID` (`uID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=937 ;

--
-- 转存表中的数据 `PageStatistics`
--

INSERT INTO `PageStatistics` (`pstID`, `cID`, `date`, `timestamp`, `uID`) VALUES
(1, 1, '2011-04-19', '2011-04-19 17:21:55', 0),
(2, 1, '2011-04-19', '2011-04-19 17:22:05', 0),
(3, 5, '2011-04-19', '2011-04-19 17:22:11', 0),
(4, 5, '2011-04-19', '2011-04-19 17:22:26', 0),
(5, 1, '2011-04-19', '2011-04-19 17:22:27', 1),
(6, 5, '2011-04-19', '2011-04-19 17:24:08', 1),
(7, 1, '2011-04-19', '2011-04-19 17:24:09', 1),
(8, 1, '2011-04-19', '2011-04-19 17:26:04', 1),
(9, 1, '2011-04-19', '2011-04-19 17:26:18', 1),
(10, 1, '2011-04-19', '2011-04-19 17:28:33', 1),
(11, 1, '2011-04-19', '2011-04-19 17:28:43', 1),
(12, 1, '2011-04-19', '2011-04-19 17:28:48', 1),
(13, 1, '2011-04-19', '2011-04-19 17:29:35', 1),
(14, 1, '2011-04-19', '2011-04-19 17:29:41', 1),
(15, 1, '2011-04-19', '2011-04-19 17:29:47', 1),
(16, 1, '2011-04-19', '2011-04-19 17:29:52', 1),
(17, 1, '2011-04-19', '2011-04-19 17:30:32', 1),
(18, 1, '2011-04-19', '2011-04-19 17:35:24', 1),
(19, 52, '2011-04-19', '2011-04-19 17:35:53', 1),
(20, 52, '2011-04-19', '2011-04-19 17:36:12', 1),
(21, 52, '2011-04-19', '2011-04-19 17:36:13', 1),
(22, 53, '2011-04-19', '2011-04-19 17:36:19', 1),
(23, 52, '2011-04-19', '2011-04-19 17:36:34', 1),
(24, 1, '2011-04-19', '2011-04-19 17:36:37', 1),
(25, 1, '2011-04-19', '2011-04-19 17:36:50', 1),
(26, 1, '2011-04-19', '2011-04-19 17:37:02', 1),
(27, 1, '2011-04-19', '2011-04-19 17:37:52', 1),
(28, 5, '2011-04-19', '2011-04-19 17:38:04', 1),
(29, 1, '2011-04-19', '2011-04-19 17:38:05', 0),
(30, 1, '2011-04-19', '2011-04-20 00:16:52', 0),
(31, 5, '2011-04-19', '2011-04-20 00:18:07', 0),
(32, 5, '2011-04-19', '2011-04-20 00:18:25', 0),
(33, 5, '2011-04-19', '2011-04-20 00:18:38', 0),
(34, 1, '2011-04-19', '2011-04-20 00:18:39', 1),
(35, 15, '2011-04-19', '2011-04-20 00:19:16', 1),
(36, 37, '2011-04-19', '2011-04-20 00:19:23', 1),
(37, 38, '2011-04-19', '2011-04-20 00:19:24', 1),
(38, 45, '2011-04-19', '2011-04-20 00:19:45', 1),
(39, 1, '2011-04-19', '2011-04-20 00:19:56', 1),
(40, 1, '2011-04-19', '2011-04-20 00:20:11', 1),
(41, 1, '2011-04-19', '2011-04-20 00:20:18', 1),
(42, 5, '2011-04-19', '2011-04-20 00:20:27', 1),
(43, 5, '2011-04-19', '2011-04-20 00:20:27', 0),
(44, 1, '2011-04-19', '2011-04-20 00:20:27', 0),
(45, 1, '2011-04-19', '2011-04-20 00:21:00', 0),
(46, 5, '2011-04-19', '2011-04-20 00:22:19', 0),
(47, 5, '2011-04-19', '2011-04-20 00:22:32', 0),
(48, 5, '2011-04-19', '2011-04-20 00:22:45', 0),
(49, 5, '2011-04-19', '2011-04-20 00:23:00', 0),
(50, 1, '2011-04-19', '2011-04-20 00:23:01', 1),
(51, 1, '2011-04-19', '2011-04-20 00:23:16', 1),
(52, 1, '2011-04-19', '2011-04-20 00:23:25', 1),
(53, 1, '2011-04-19', '2011-04-20 00:23:40', 1),
(54, 15, '2011-04-19', '2011-04-20 00:24:48', 1),
(55, 30, '2011-04-19', '2011-04-20 00:24:53', 1),
(56, 31, '2011-04-19', '2011-04-20 00:24:54', 1),
(57, 32, '2011-04-19', '2011-04-20 00:25:24', 1),
(58, 35, '2011-04-19', '2011-04-20 00:25:38', 1),
(59, 1, '2011-04-19', '2011-04-20 00:31:44', 0),
(60, 1, '2011-04-19', '2011-04-20 00:32:58', 0),
(61, 1, '2011-04-19', '2011-04-20 00:33:13', 0),
(62, 1, '2011-04-19', '2011-04-20 00:35:24', 0),
(63, 1, '2011-04-19', '2011-04-20 02:39:17', 0),
(64, 5, '2011-04-19', '2011-04-20 02:39:41', 0),
(65, 5, '2011-04-19', '2011-04-20 02:39:55', 0),
(66, 1, '2011-04-19', '2011-04-20 02:39:56', 1),
(67, 1, '2011-04-19', '2011-04-20 02:41:03', 1),
(68, 1, '2011-04-19', '2011-04-20 02:43:30', 0),
(69, 1, '2011-04-19', '2011-04-20 02:50:23', 0),
(70, 1, '2011-04-19', '2011-04-20 02:50:33', 0),
(71, 1, '2011-04-19', '2011-04-20 02:52:09', 0),
(72, 1, '2011-04-19', '2011-04-20 03:06:26', 0),
(73, 1, '2011-04-19', '2011-04-20 03:23:18', 0),
(74, 1, '2011-04-20', '2011-04-20 06:14:08', 0),
(75, 1, '2011-04-20', '2011-04-20 06:26:39', 0),
(76, 1, '2011-04-20', '2011-04-20 08:12:34', 0),
(77, 1, '2011-04-20', '2011-04-20 08:24:16', 0),
(78, 1, '2011-04-20', '2011-04-20 08:24:29', 0),
(79, 5, '2011-04-20', '2011-04-20 08:24:32', 0),
(80, 5, '2011-04-20', '2011-04-20 08:24:42', 0),
(81, 1, '2011-04-20', '2011-04-20 08:24:43', 1),
(82, 1, '2011-04-20', '2011-04-20 08:25:51', 1),
(83, 1, '2011-04-20', '2011-04-20 08:25:55', 1),
(84, 1, '2011-04-20', '2011-04-20 08:26:31', 1),
(85, 1, '2011-04-20', '2011-04-20 08:26:54', 1),
(86, 1, '2011-04-20', '2011-04-20 08:27:04', 1),
(87, 1, '2011-04-20', '2011-04-20 15:33:38', 0),
(88, 5, '2011-04-20', '2011-04-20 15:34:19', 0),
(89, 5, '2011-04-20', '2011-04-20 15:34:35', 0),
(90, 1, '2011-04-20', '2011-04-20 15:34:36', 1),
(91, 1, '2011-04-20', '2011-04-20 15:35:06', 1),
(92, 1, '2011-04-20', '2011-04-20 15:36:13', 1),
(93, 15, '2011-04-20', '2011-04-20 15:36:20', 1),
(94, 30, '2011-04-20', '2011-04-20 15:36:29', 1),
(95, 31, '2011-04-20', '2011-04-20 15:36:29', 1),
(96, 30, '2011-04-20', '2011-04-20 15:36:42', 1),
(97, 31, '2011-04-20', '2011-04-20 15:36:42', 1),
(98, 32, '2011-04-20', '2011-04-20 15:36:50', 1),
(99, 52, '2011-04-20', '2011-04-20 15:37:16', 1),
(100, 30, '2011-04-20', '2011-04-20 15:38:17', 1),
(101, 31, '2011-04-20', '2011-04-20 15:38:18', 1),
(102, 16, '2011-04-20', '2011-04-20 15:38:23', 1),
(103, 17, '2011-04-20', '2011-04-20 15:38:24', 1),
(104, 30, '2011-04-20', '2011-04-20 15:38:39', 1),
(105, 31, '2011-04-20', '2011-04-20 15:38:41', 1),
(106, 33, '2011-04-20', '2011-04-20 15:38:55', 1),
(107, 34, '2011-04-20', '2011-04-20 15:38:56', 1),
(108, 32, '2011-04-20', '2011-04-20 15:39:02', 1),
(109, 35, '2011-04-20', '2011-04-20 15:39:06', 1),
(110, 32, '2011-04-20', '2011-04-20 15:39:24', 1),
(111, 1, '2011-04-20', '2011-04-20 15:40:21', 0),
(112, 1, '2011-04-20', '2011-04-20 17:11:34', 0),
(113, 1, '2011-04-20', '2011-04-20 17:12:22', 0),
(114, 1, '2011-04-20', '2011-04-20 17:12:33', 0),
(115, 1, '2011-04-20', '2011-04-20 17:12:47', 0),
(116, 1, '2011-04-20', '2011-04-20 17:16:55', 0),
(117, 1, '2011-04-20', '2011-04-20 17:17:22', 0),
(118, 1, '2011-04-20', '2011-04-20 17:18:19', 0),
(119, 1, '2011-04-20', '2011-04-20 17:22:18', 0),
(120, 5, '2011-04-20', '2011-04-20 17:22:31', 0),
(121, 1, '2011-04-20', '2011-04-20 17:38:28', 0),
(122, 5, '2011-04-20', '2011-04-20 17:38:31', 0),
(123, 5, '2011-04-20', '2011-04-20 17:38:44', 0),
(124, 1, '2011-04-20', '2011-04-20 18:02:06', 0),
(125, 5, '2011-04-20', '2011-04-20 22:15:00', 0),
(126, 1, '2011-04-20', '2011-04-21 02:23:48', 0),
(127, 1, '2011-04-21', '2011-04-21 07:25:05', 0),
(128, 1, '2011-04-21', '2011-04-21 13:33:34', 0),
(129, 1, '2011-04-21', '2011-04-21 13:48:17', 0),
(130, 1, '2011-04-21', '2011-04-21 16:01:39', 0),
(131, 1, '2011-04-21', '2011-04-21 23:34:50', 0),
(132, 1, '2011-04-21', '2011-04-21 23:35:54', 0),
(133, 1, '2011-04-21', '2011-04-22 02:23:26', 0),
(134, 1, '2011-04-21', '2011-04-22 04:05:54', 0),
(135, 1, '2011-04-21', '2011-04-22 05:32:22', 0),
(136, 5, '2011-04-21', '2011-04-22 05:43:14', 0),
(137, 1, '2011-04-22', '2011-04-22 11:57:25', 0),
(138, 1, '2011-04-22', '2011-04-22 22:56:09', 0),
(139, 1, '2011-04-22', '2011-04-23 01:06:17', 0),
(140, 1, '2011-04-22', '2011-04-23 02:30:58', 0),
(141, 1, '2011-04-23', '2011-04-23 07:32:58', 0),
(142, 1, '2011-04-23', '2011-04-23 11:37:45', 0),
(143, 1, '2011-04-23', '2011-04-23 16:50:05', 0),
(144, 5, '2011-04-23', '2011-04-23 16:50:07', 0),
(145, 1, '2011-04-23', '2011-04-23 16:57:34', 0),
(146, 1, '2011-04-23', '2011-04-24 02:15:22', 0),
(147, 1, '2011-04-23', '2011-04-24 02:37:17', 0),
(148, 1, '2011-04-24', '2011-04-24 15:36:00', 0),
(149, 1, '2011-04-25', '2011-04-25 19:51:26', 0),
(150, 1, '2011-04-25', '2011-04-25 22:46:04', 0),
(151, 1, '2011-04-26', '2011-04-26 07:23:41', 0),
(152, 1, '2011-04-26', '2011-04-26 07:23:48', 0),
(153, 1, '2011-04-26', '2011-04-26 20:43:45', 0),
(154, 1, '2011-04-26', '2011-04-27 02:45:05', 0),
(155, 1, '2011-04-27', '2011-04-27 08:19:34', 0),
(156, 1, '2011-04-27', '2011-04-27 21:20:53', 0),
(157, 1, '2011-04-27', '2011-04-28 03:18:37', 0),
(158, 1, '2011-04-27', '2011-04-28 03:54:42', 0),
(159, 1, '2011-04-28', '2011-04-28 12:50:26', 0),
(160, 1, '2011-04-28', '2011-04-28 12:52:25', 0),
(161, 1, '2011-04-28', '2011-04-29 03:46:02', 0),
(162, 1, '2011-04-29', '2011-04-29 10:49:00', 0),
(163, 1, '2011-04-29', '2011-04-29 14:09:23', 0),
(164, 1, '2011-04-29', '2011-04-29 16:10:21', 0),
(165, 1, '2011-04-29', '2011-04-29 16:10:22', 0),
(166, 1, '2011-04-29', '2011-04-29 16:10:36', 0),
(167, 1, '2011-04-29', '2011-04-29 16:30:26', 0),
(168, 1, '2011-04-29', '2011-04-29 17:23:04', 0),
(169, 1, '2011-04-29', '2011-04-30 05:22:22', 0),
(170, 1, '2011-04-29', '2011-04-30 05:22:40', 0),
(171, 1, '2011-04-30', '2011-04-30 06:25:19', 0),
(172, 1, '2011-04-30', '2011-04-30 06:25:25', 0),
(173, 1, '2011-04-30', '2011-04-30 08:22:22', 0),
(174, 1, '2011-04-30', '2011-04-30 12:07:11', 0),
(175, 1, '2011-04-30', '2011-04-30 21:32:41', 0),
(176, 1, '2011-04-30', '2011-05-01 05:51:53', 0),
(177, 1, '2011-05-01', '2011-05-01 09:39:23', 0),
(178, 1, '2011-05-01', '2011-05-01 09:39:28', 0),
(179, 5, '2011-05-01', '2011-05-01 09:39:31', 0),
(180, 1, '2011-05-01', '2011-05-01 14:03:15', 0),
(181, 1, '2011-05-01', '2011-05-01 14:13:46', 0),
(182, 1, '2011-05-01', '2011-05-01 14:14:34', 0),
(183, 1, '2011-05-02', '2011-05-02 17:07:36', 0),
(184, 1, '2011-05-02', '2011-05-03 04:40:12', 0),
(185, 1, '2011-05-03', '2011-05-03 19:40:27', 0),
(186, 1, '2011-05-04', '2011-05-04 08:11:55', 0),
(187, 1, '2011-05-04', '2011-05-04 08:12:00', 0),
(188, 1, '2011-05-04', '2011-05-04 09:11:11', 0),
(189, 1, '2011-05-04', '2011-05-04 09:11:12', 0),
(190, 1, '2011-05-04', '2011-05-04 16:20:10', 0),
(191, 5, '2011-05-04', '2011-05-04 19:04:32', 0),
(192, 1, '2011-05-04', '2011-05-04 21:33:47', 0),
(193, 1, '2011-05-04', '2011-05-04 23:58:56', 0),
(194, 1, '2011-05-04', '2011-05-05 00:52:51', 0),
(195, 1, '2011-05-04', '2011-05-05 00:52:53', 0),
(196, 5, '2011-05-04', '2011-05-05 00:52:55', 0),
(197, 1, '2011-05-05', '2011-05-06 00:15:43', 0),
(198, 1, '2011-05-05', '2011-05-06 05:55:55', 0),
(199, 1, '2011-05-06', '2011-05-06 10:27:33', 0),
(200, 1, '2011-05-06', '2011-05-06 17:07:13', 0),
(201, 1, '2011-05-06', '2011-05-07 05:20:02', 0),
(202, 5, '2011-05-07', '2011-05-07 15:53:25', 0),
(203, 5, '2011-05-07', '2011-05-07 15:53:26', 0),
(204, 1, '2011-05-07', '2011-05-08 04:05:16', 0),
(205, 1, '2011-05-09', '2011-05-09 08:52:28', 0),
(206, 5, '2011-05-09', '2011-05-09 11:23:52', 0),
(207, 5, '2011-05-09', '2011-05-09 11:23:53', 0),
(208, 1, '2011-05-09', '2011-05-09 22:21:24', 0),
(209, 5, '2011-05-09', '2011-05-09 22:40:46', 0),
(210, 5, '2011-05-09', '2011-05-09 22:40:47', 0),
(211, 1, '2011-05-10', '2011-05-10 15:59:13', 0),
(212, 5, '2011-05-10', '2011-05-10 20:30:24', 0),
(213, 5, '2011-05-10', '2011-05-10 20:30:25', 0),
(214, 1, '2011-05-11', '2011-05-11 23:01:25', 0),
(215, 1, '2011-05-11', '2011-05-12 04:22:24', 0),
(216, 1, '2011-05-11', '2011-05-12 04:22:27', 0),
(217, 1, '2011-05-13', '2011-05-13 14:03:28', 0),
(218, 5, '2011-05-13', '2011-05-13 14:26:58', 0),
(219, 1, '2011-05-16', '2011-05-17 00:42:00', 0),
(220, 1, '2011-05-16', '2011-05-17 00:42:02', 0),
(221, 1, '2011-05-16', '2011-05-17 04:11:05', 0),
(222, 1, '2011-05-17', '2011-05-18 00:01:45', 0),
(223, 1, '2011-05-18', '2011-05-19 05:20:09', 0),
(224, 1, '2011-05-19', '2011-05-19 06:20:21', 0),
(225, 1, '2011-05-19', '2011-05-19 11:03:57', 0),
(226, 1, '2011-05-21', '2011-05-21 19:57:45', 0),
(227, 1, '2011-05-21', '2011-05-21 19:57:47', 0),
(228, 1, '2011-05-22', '2011-05-22 10:00:17', 0),
(229, 5, '2011-05-22', '2011-05-22 17:18:46', 0),
(230, 5, '2011-05-22', '2011-05-22 17:18:51', 0),
(231, 1, '2011-05-23', '2011-05-23 07:25:10', 0),
(232, 1, '2011-05-23', '2011-05-23 10:33:39', 0),
(233, 1, '2011-05-23', '2011-05-23 16:19:56', 0),
(234, 5, '2011-05-23', '2011-05-23 16:20:37', 0),
(235, 1, '2011-05-23', '2011-05-24 02:12:35', 0),
(236, 1, '2011-05-23', '2011-05-24 02:13:02', 0),
(237, 1, '2011-05-23', '2011-05-24 02:13:07', 0),
(238, 1, '2011-05-23', '2011-05-24 02:18:04', 0),
(239, 1, '2011-05-23', '2011-05-24 02:18:05', 0),
(240, 1, '2011-05-23', '2011-05-24 03:24:53', 0),
(241, 1, '2011-05-24', '2011-05-25 02:31:57', 0),
(242, 1, '2011-05-24', '2011-05-25 04:36:23', 0),
(243, 1, '2011-05-25', '2011-05-25 19:30:35', 0),
(244, 1, '2011-05-25', '2011-05-25 19:30:36', 0),
(245, 1, '2011-05-26', '2011-05-26 13:41:01', 0),
(246, 1, '2011-05-26', '2011-05-27 03:51:14', 0),
(247, 1, '2011-05-27', '2011-05-27 12:59:46', 0),
(248, 1, '2011-05-27', '2011-05-27 23:20:11', 0),
(249, 1, '2011-05-27', '2011-05-27 23:20:12', 0),
(250, 1, '2011-05-27', '2011-05-28 00:43:06', 0),
(251, 1, '2011-05-27', '2011-05-28 05:48:35', 0),
(252, 1, '2011-05-28', '2011-05-28 18:19:15', 0),
(253, 1, '2011-05-28', '2011-05-28 23:05:31', 0),
(254, 1, '2011-05-29', '2011-05-29 22:55:54', 0),
(255, 1, '2011-05-29', '2011-05-29 22:55:58', 0),
(256, 1, '2011-05-29', '2011-05-29 23:52:01', 0),
(257, 1, '2011-05-29', '2011-05-29 23:52:02', 0),
(258, 1, '2011-05-29', '2011-05-30 05:39:49', 0),
(259, 1, '2011-05-29', '2011-05-30 05:39:56', 0),
(260, 1, '2011-05-30', '2011-05-30 13:08:28', 0),
(261, 1, '2011-05-30', '2011-05-30 13:08:35', 0),
(262, 1, '2011-05-30', '2011-05-30 18:55:17', 0),
(263, 1, '2011-05-30', '2011-05-30 20:39:19', 0),
(264, 5, '2011-05-30', '2011-05-30 21:39:40', 0),
(265, 1, '2011-05-31', '2011-05-31 16:09:24', 0),
(266, 1, '2011-05-31', '2011-05-31 16:10:04', 0),
(267, 1, '2011-05-31', '2011-05-31 16:13:38', 0),
(268, 1, '2011-05-31', '2011-05-31 16:17:37', 0),
(269, 1, '2011-05-31', '2011-05-31 16:19:13', 0),
(270, 1, '2011-05-31', '2011-06-01 00:24:10', 0),
(271, 1, '2011-05-31', '2011-06-01 00:24:11', 0),
(272, 1, '2011-05-31', '2011-06-01 02:41:27', 0),
(273, 1, '2011-05-31', '2011-06-01 02:41:28', 0),
(274, 1, '2011-05-31', '2011-06-01 03:30:35', 0),
(275, 1, '2011-05-31', '2011-06-01 03:59:58', 0),
(276, 1, '2011-05-31', '2011-06-01 04:00:04', 0),
(277, 1, '2011-06-01', '2011-06-01 18:19:37', 0),
(278, 1, '2011-06-01', '2011-06-01 19:17:07', 0),
(279, 1, '2011-06-01', '2011-06-01 23:51:23', 0),
(280, 1, '2011-06-01', '2011-06-02 03:46:39', 0),
(281, 1, '2011-06-01', '2011-06-02 03:46:40', 0),
(282, 1, '2011-06-02', '2011-06-02 11:24:36', 0),
(283, 1, '2011-06-02', '2011-06-03 00:27:51', 0),
(284, 1, '2011-06-03', '2011-06-03 20:53:18', 0),
(285, 1, '2011-06-04', '2011-06-04 10:57:23', 0),
(286, 1, '2011-06-04', '2011-06-04 18:08:21', 0),
(287, 1, '2011-06-04', '2011-06-04 18:08:33', 0),
(288, 1, '2011-06-05', '2011-06-05 07:41:50', 0),
(289, 1, '2011-06-05', '2011-06-05 22:46:08', 0),
(290, 1, '2011-06-05', '2011-06-05 22:46:10', 0),
(291, 1, '2011-06-06', '2011-06-06 10:30:42', 0),
(292, 1, '2011-06-06', '2011-06-06 10:33:11', 0),
(293, 5, '2011-06-06', '2011-06-06 10:33:13', 0),
(294, 1, '2011-06-06', '2011-06-06 13:34:37', 0),
(295, 1, '2011-06-06', '2011-06-06 14:24:08', 0),
(296, 1, '2011-06-07', '2011-06-07 09:00:46', 0),
(297, 1, '2011-06-07', '2011-06-08 03:41:31', 0),
(298, 1, '2011-06-08', '2011-06-08 09:56:53', 0),
(299, 1, '2011-06-08', '2011-06-08 09:56:55', 0),
(300, 5, '2011-06-08', '2011-06-08 10:21:29', 0),
(301, 5, '2011-06-08', '2011-06-08 10:21:30', 0),
(302, 1, '2011-06-08', '2011-06-08 14:48:05', 0),
(303, 1, '2011-06-08', '2011-06-08 17:30:08', 0),
(304, 1, '2011-06-08', '2011-06-08 20:15:58', 0),
(305, 1, '2011-06-09', '2011-06-09 15:06:47', 0),
(306, 1, '2011-06-09', '2011-06-10 03:31:25', 0),
(307, 1, '2011-06-09', '2011-06-10 03:31:26', 0),
(308, 1, '2011-06-10', '2011-06-10 10:36:47', 0),
(309, 1, '2011-06-10', '2011-06-10 16:03:49', 0),
(310, 5, '2011-06-10', '2011-06-10 16:03:52', 0),
(311, 1, '2011-06-10', '2011-06-10 20:00:40', 0),
(312, 5, '2011-06-10', '2011-06-11 02:43:13', 0),
(313, 5, '2011-06-10', '2011-06-11 02:43:14', 0),
(314, 5, '2011-06-11', '2011-06-11 09:05:12', 0),
(315, 5, '2011-06-11', '2011-06-11 09:05:13', 0),
(316, 5, '2011-06-11', '2011-06-11 09:19:31', 0),
(317, 5, '2011-06-11', '2011-06-11 09:19:32', 0),
(318, 1, '2011-06-11', '2011-06-11 13:11:23', 0),
(319, 1, '2011-06-11', '2011-06-11 13:11:32', 0),
(320, 1, '2011-06-11', '2011-06-11 18:45:47', 0),
(321, 1, '2011-06-11', '2011-06-11 19:51:13', 0),
(322, 1, '2011-06-11', '2011-06-12 02:34:20', 0),
(323, 1, '2011-06-11', '2011-06-12 02:34:29', 0),
(324, 1, '2011-06-12', '2011-06-12 20:27:22', 0),
(325, 5, '2011-06-12', '2011-06-12 22:22:05', 0),
(326, 1, '2011-06-12', '2011-06-13 03:06:05', 0),
(327, 1, '2011-06-13', '2011-06-13 08:47:58', 0),
(328, 1, '2011-06-13', '2011-06-13 11:32:44', 0),
(329, 1, '2011-06-13', '2011-06-13 20:48:06', 0),
(330, 1, '2011-06-13', '2011-06-13 22:51:32', 0),
(331, 1, '2011-06-13', '2011-06-13 23:41:49', 0),
(332, 1, '2011-06-13', '2011-06-14 01:11:51', 0),
(333, 1, '2011-06-13', '2011-06-14 01:11:52', 0),
(334, 1, '2011-06-15', '2011-06-16 05:39:59', 0),
(335, 1, '2011-06-15', '2011-06-16 05:40:09', 0),
(336, 1, '2011-06-16', '2011-06-16 12:59:47', 0),
(337, 1, '2011-06-16', '2011-06-17 05:18:59', 0),
(338, 1, '2011-06-16', '2011-06-17 05:39:54', 0),
(339, 1, '2011-06-17', '2011-06-17 06:45:10', 0),
(340, 1, '2011-06-17', '2011-06-17 13:13:08', 0),
(341, 1, '2011-06-17', '2011-06-17 13:13:10', 0),
(342, 1, '2011-06-17', '2011-06-17 16:16:27', 0),
(343, 1, '2011-06-17', '2011-06-17 17:44:35', 0),
(344, 1, '2011-06-17', '2011-06-18 00:48:03', 0),
(345, 1, '2011-06-17', '2011-06-18 00:48:05', 0),
(346, 5, '2011-06-17', '2011-06-18 05:31:35', 0),
(347, 1, '2011-06-18', '2011-06-18 06:05:03', 0),
(348, 1, '2011-06-18', '2011-06-18 08:30:09', 0),
(349, 1, '2011-06-18', '2011-06-18 21:06:05', 0),
(350, 1, '2011-06-18', '2011-06-19 02:37:05', 0),
(351, 1, '2011-06-18', '2011-06-19 04:17:45', 0),
(352, 1, '2011-06-18', '2011-06-19 04:17:56', 0),
(353, 5, '2011-06-19', '2011-06-19 07:07:15', 0),
(354, 1, '2011-06-19', '2011-06-19 11:47:17', 0),
(355, 1, '2011-06-19', '2011-06-19 16:00:42', 0),
(356, 5, '2011-06-19', '2011-06-20 00:33:30', 0),
(357, 1, '2011-06-19', '2011-06-20 01:41:18', 0),
(358, 1, '2011-06-19', '2011-06-20 01:41:19', 0),
(359, 1, '2011-06-21', '2011-06-21 08:36:46', 0),
(360, 1, '2011-06-21', '2011-06-21 09:12:40', 0),
(361, 5, '2011-06-21', '2011-06-22 04:36:13', 0),
(362, 5, '2011-06-21', '2011-06-22 04:36:15', 0),
(363, 1, '2011-06-22', '2011-06-22 08:30:39', 0),
(364, 1, '2011-06-22', '2011-06-22 08:30:42', 0),
(365, 1, '2011-06-22', '2011-06-22 18:04:00', 0),
(366, 1, '2011-06-23', '2011-06-24 00:28:13', 0),
(367, 1, '2011-06-23', '2011-06-24 00:28:16', 0),
(368, 1, '2011-06-23', '2011-06-24 03:29:44', 0),
(369, 1, '2011-06-24', '2011-06-24 06:22:35', 0),
(370, 1, '2011-06-24', '2011-06-24 07:34:59', 0),
(371, 1, '2011-06-25', '2011-06-25 08:08:51', 0),
(372, 1, '2011-06-25', '2011-06-25 19:30:03', 0),
(373, 1, '2011-06-25', '2011-06-25 21:19:09', 0),
(374, 1, '2011-06-25', '2011-06-26 03:34:38', 0),
(375, 1, '2011-06-25', '2011-06-26 03:34:39', 0),
(376, 1, '2011-06-26', '2011-06-26 09:56:06', 0),
(377, 1, '2011-06-27', '2011-06-27 06:19:32', 0),
(378, 1, '2011-06-27', '2011-06-27 08:45:29', 0),
(379, 1, '2011-06-27', '2011-06-27 08:49:07', 0),
(380, 1, '2011-06-27', '2011-06-27 19:46:53', 0),
(381, 1, '2011-06-27', '2011-06-27 19:46:54', 0),
(382, 1, '2011-06-27', '2011-06-28 02:45:28', 0),
(383, 1, '2011-06-27', '2011-06-28 02:45:29', 0),
(384, 1, '2011-06-28', '2011-06-28 18:55:50', 0),
(385, 1, '2011-06-28', '2011-06-28 19:48:43', 0),
(386, 1, '2011-06-28', '2011-06-29 00:42:57', 0),
(387, 1, '2011-06-28', '2011-06-29 01:44:29', 0),
(388, 1, '2011-06-28', '2011-06-29 02:46:13', 0),
(389, 5, '2011-06-29', '2011-06-29 08:17:14', 0),
(390, 1, '2011-06-29', '2011-06-29 20:42:26', 0),
(391, 1, '2011-06-29', '2011-06-30 00:13:03', 0),
(392, 1, '2011-06-29', '2011-06-30 00:13:05', 0),
(393, 1, '2011-06-30', '2011-07-01 02:12:30', 0),
(394, 1, '2011-06-30', '2011-07-01 03:10:08', 0),
(395, 1, '2011-07-01', '2011-07-01 21:43:11', 0),
(396, 1, '2011-07-01', '2011-07-02 01:25:55', 0),
(397, 1, '2011-07-01', '2011-07-02 01:25:56', 0),
(398, 1, '2011-07-02', '2011-07-02 21:29:40', 0),
(399, 1, '2011-07-03', '2011-07-03 07:36:33', 0),
(400, 1, '2011-07-03', '2011-07-03 07:37:14', 0),
(401, 1, '2011-07-03', '2011-07-03 07:37:18', 0),
(402, 1, '2011-07-03', '2011-07-03 07:37:27', 0),
(403, 1, '2011-07-03', '2011-07-03 08:30:49', 0),
(404, 1, '2011-07-03', '2011-07-03 09:13:50', 0),
(405, 1, '2011-07-03', '2011-07-04 03:23:41', 0),
(406, 1, '2011-07-03', '2011-07-04 05:11:08', 0),
(407, 1, '2011-07-03', '2011-07-04 05:11:10', 0),
(408, 1, '2011-07-04', '2011-07-04 08:46:41', 0),
(409, 1, '2011-07-04', '2011-07-04 21:14:28', 0),
(410, 1, '2011-07-04', '2011-07-04 21:23:38', 0),
(411, 1, '2011-07-04', '2011-07-04 22:45:04', 0),
(412, 1, '2011-07-04', '2011-07-04 22:45:06', 0),
(413, 1, '2011-07-05', '2011-07-05 20:36:59', 0),
(414, 1, '2011-07-06', '2011-07-06 06:52:51', 0),
(415, 1, '2011-07-06', '2011-07-06 07:28:42', 0),
(416, 1, '2011-07-07', '2011-07-07 22:17:45', 0),
(417, 1, '2011-07-07', '2011-07-08 00:37:10', 0),
(418, 1, '2011-07-07', '2011-07-08 00:37:23', 0),
(419, 1, '2011-07-08', '2011-07-08 08:27:24', 0),
(420, 1, '2011-07-08', '2011-07-09 05:48:45', 0),
(421, 1, '2011-07-09', '2011-07-09 06:37:35', 0),
(422, 5, '2011-07-09', '2011-07-09 06:37:42', 0),
(423, 1, '2011-07-09', '2011-07-09 10:32:12', 0),
(424, 1, '2011-07-09', '2011-07-09 20:02:19', 0),
(425, 1, '2011-07-09', '2011-07-09 20:02:20', 0),
(426, 1, '2011-07-09', '2011-07-09 21:31:35', 0),
(427, 1, '2011-07-10', '2011-07-10 07:43:21', 0),
(428, 1, '2011-07-10', '2011-07-11 00:04:03', 0),
(429, 1, '2011-07-10', '2011-07-11 05:36:53', 0),
(430, 1, '2011-07-11', '2011-07-11 07:10:14', 0),
(431, 5, '2011-07-11', '2011-07-11 12:50:42', 0),
(432, 1, '2011-07-11', '2011-07-12 00:20:43', 0),
(433, 1, '2011-07-11', '2011-07-12 00:25:33', 0),
(434, 1, '2011-07-11', '2011-07-12 00:25:34', 0),
(435, 1, '2011-07-11', '2011-07-12 04:09:03', 0),
(436, 1, '2011-07-11', '2011-07-12 05:01:36', 0),
(437, 1, '2011-07-12', '2011-07-12 09:33:04', 0),
(438, 5, '2011-07-12', '2011-07-12 12:14:40', 0),
(439, 1, '2011-07-12', '2011-07-12 22:56:46', 0),
(440, 1, '2011-07-12', '2011-07-12 22:56:50', 0),
(441, 5, '2011-07-12', '2011-07-12 22:56:52', 0),
(442, 1, '2011-07-12', '2011-07-13 02:23:33', 0),
(443, 1, '2011-07-12', '2011-07-13 04:32:04', 0),
(444, 5, '2011-07-13', '2011-07-13 11:25:44', 0),
(445, 1, '2011-07-13', '2011-07-13 17:05:42', 0),
(446, 1, '2011-07-13', '2011-07-13 22:45:36', 0),
(447, 1, '2011-07-13', '2011-07-14 02:13:04', 0),
(448, 1, '2011-07-13', '2011-07-14 02:59:30', 0),
(449, 1, '2011-07-13', '2011-07-14 03:41:13', 0),
(450, 1, '2011-07-13', '2011-07-14 04:13:43', 0),
(451, 1, '2011-07-13', '2011-07-14 04:13:44', 0),
(452, 1, '2011-07-14', '2011-07-15 00:36:32', 0),
(453, 1, '2011-07-14', '2011-07-15 01:17:43', 0),
(454, 1, '2011-07-14', '2011-07-15 03:12:26', 0),
(455, 5, '2011-07-15', '2011-07-15 09:05:08', 0),
(456, 5, '2011-07-15', '2011-07-15 13:51:08', 0),
(457, 1, '2011-07-15', '2011-07-16 03:24:37', 0),
(458, 1, '2011-07-16', '2011-07-16 08:15:14', 0),
(459, 1, '2011-07-16', '2011-07-16 08:15:15', 0),
(460, 1, '2011-07-16', '2011-07-16 21:33:03', 0),
(461, 1, '2011-07-17', '2011-07-17 07:44:52', 0),
(462, 1, '2011-07-17', '2011-07-18 02:34:04', 0),
(463, 1, '2011-07-17', '2011-07-18 03:58:53', 0),
(464, 1, '2011-07-17', '2011-07-18 03:58:53', 0),
(465, 1, '2011-07-17', '2011-07-18 04:09:29', 0),
(466, 1, '2011-07-18', '2011-07-18 11:02:47', 0),
(467, 1, '2011-07-18', '2011-07-18 11:03:00', 0),
(468, 1, '2011-07-18', '2011-07-18 19:28:52', 0),
(469, 5, '2011-07-19', '2011-07-19 08:48:30', 0),
(470, 1, '2011-07-19', '2011-07-20 05:15:00', 0),
(471, 1, '2011-07-20', '2011-07-20 06:12:23', 0),
(472, 1, '2011-07-20', '2011-07-20 06:36:24', 0),
(473, 1, '2011-07-20', '2011-07-20 06:36:25', 0),
(474, 1, '2011-07-21', '2011-07-21 13:05:15', 0),
(475, 1, '2011-07-21', '2011-07-21 16:41:04', 0),
(476, 1, '2011-07-22', '2011-07-22 06:12:14', 0),
(477, 1, '2011-07-22', '2011-07-22 06:16:29', 0),
(478, 1, '2011-07-22', '2011-07-22 07:06:50', 0),
(479, 1, '2011-07-22', '2011-07-22 08:23:27', 0),
(480, 1, '2011-07-22', '2011-07-22 08:23:28', 0),
(481, 5, '2011-07-22', '2011-07-22 15:51:12', 0),
(482, 5, '2011-07-22', '2011-07-22 15:51:17', 0),
(483, 1, '2011-07-23', '2011-07-23 23:25:40', 0),
(484, 1, '2011-07-23', '2011-07-24 03:08:47', 0),
(485, 1, '2011-07-23', '2011-07-24 03:08:48', 0),
(486, 1, '2011-07-24', '2011-07-24 10:35:38', 0),
(487, 1, '2011-07-24', '2011-07-24 11:40:14', 0),
(488, 1, '2011-07-24', '2011-07-24 14:46:08', 0),
(489, 1, '2011-07-24', '2011-07-24 16:39:50', 0),
(490, 1, '2011-07-24', '2011-07-24 18:33:14', 0),
(491, 1, '2011-07-25', '2011-07-25 12:57:06', 0),
(492, 1, '2011-07-25', '2011-07-25 12:57:08', 0),
(493, 1, '2011-07-26', '2011-07-26 07:47:28', 0),
(494, 5, '2011-07-26', '2011-07-26 18:35:04', 0),
(495, 1, '2011-07-26', '2011-07-27 02:52:39', 0),
(496, 1, '2011-07-26', '2011-07-27 04:09:21', 0),
(497, 5, '2011-07-26', '2011-07-27 05:34:01', 0),
(498, 5, '2011-07-26', '2011-07-27 05:34:07', 0),
(499, 1, '2011-07-26', '2011-07-27 05:35:34', 0),
(500, 1, '2011-07-27', '2011-07-27 06:54:51', 0),
(501, 1, '2011-07-27', '2011-07-27 06:55:03', 0),
(502, 1, '2011-07-27', '2011-07-27 20:49:09', 0),
(503, 1, '2011-07-27', '2011-07-27 23:57:20', 0),
(504, 1, '2011-07-27', '2011-07-27 23:57:21', 0),
(505, 1, '2011-07-27', '2011-07-28 01:16:30', 0),
(506, 1, '2011-07-27', '2011-07-28 01:16:59', 0),
(507, 5, '2011-07-27', '2011-07-28 01:17:10', 0),
(508, 1, '2011-07-27', '2011-07-28 01:17:13', 0),
(509, 1, '2011-07-27', '2011-07-28 01:17:35', 0),
(510, 1, '2011-07-27', '2011-07-28 01:17:59', 0),
(511, 1, '2011-07-27', '2011-07-28 01:23:33', 0),
(512, 1, '2011-07-28', '2011-07-28 07:45:22', 0),
(513, 1, '2011-07-29', '2011-07-29 06:20:55', 0),
(514, 1, '2011-07-29', '2011-07-29 07:47:04', 0),
(515, 1, '2011-07-29', '2011-07-29 08:07:18', 0),
(516, 1, '2011-07-29', '2011-07-29 10:00:49', 0),
(517, 1, '2011-07-29', '2011-07-29 10:00:55', 0),
(518, 1, '2011-07-30', '2011-07-30 10:54:51', 0),
(519, 1, '2011-07-30', '2011-07-30 10:54:54', 0),
(520, 1, '2011-07-30', '2011-07-30 12:01:23', 0),
(521, 1, '2011-07-31', '2011-07-31 08:05:03', 0),
(522, 1, '2011-07-31', '2011-07-31 09:53:24', 0),
(523, 1, '2011-07-31', '2011-07-31 14:14:52', 0),
(524, 1, '2011-07-31', '2011-07-31 14:14:55', 0),
(525, 1, '2011-07-31', '2011-08-01 01:04:00', 0),
(526, 1, '2011-07-31', '2011-08-01 01:55:28', 0),
(527, 1, '2011-08-01', '2011-08-01 14:01:57', 0),
(528, 1, '2011-08-01', '2011-08-01 14:02:00', 0),
(529, 1, '2011-08-01', '2011-08-02 01:51:30', 0),
(530, 1, '2011-08-01', '2011-08-02 01:51:48', 0),
(531, 1, '2011-08-01', '2011-08-02 05:10:07', 0),
(532, 1, '2011-08-02', '2011-08-02 11:12:28', 0),
(533, 1, '2011-08-02', '2011-08-02 14:09:46', 0),
(534, 1, '2011-08-02', '2011-08-02 16:14:09', 0),
(535, 5, '2011-08-02', '2011-08-02 16:14:12', 0),
(536, 1, '2011-08-02', '2011-08-03 02:58:46', 0),
(537, 1, '2011-08-03', '2011-08-03 08:15:26', 0),
(538, 1, '2011-08-03', '2011-08-03 08:51:22', 0),
(539, 5, '2011-08-03', '2011-08-03 10:44:35', 0),
(540, 1, '2011-08-03', '2011-08-03 12:41:11', 0),
(541, 1, '2011-08-03', '2011-08-03 14:05:35', 0),
(542, 5, '2011-08-03', '2011-08-03 17:36:04', 0),
(543, 1, '2011-08-03', '2011-08-03 21:52:06', 0),
(544, 1, '2011-08-03', '2011-08-04 02:59:29', 0),
(545, 1, '2011-08-03', '2011-08-04 02:59:33', 0),
(546, 1, '2011-08-04', '2011-08-04 13:59:54', 0),
(547, 1, '2011-08-05', '2011-08-05 08:30:08', 0),
(548, 1, '2011-08-06', '2011-08-06 09:03:39', 0),
(549, 1, '2011-08-06', '2011-08-06 10:14:11', 0),
(550, 1, '2011-08-06', '2011-08-06 10:29:14', 0),
(551, 1, '2011-08-06', '2011-08-06 10:49:33', 0),
(552, 1, '2011-08-07', '2011-08-07 09:53:34', 0),
(553, 1, '2011-08-07', '2011-08-07 13:22:08', 0),
(554, 1, '2011-08-07', '2011-08-07 18:51:41', 0),
(555, 1, '2011-08-07', '2011-08-07 18:51:43', 0),
(556, 5, '2011-08-07', '2011-08-07 20:27:04', 0),
(557, 1, '2011-08-08', '2011-08-08 13:50:48', 0),
(558, 1, '2011-08-08', '2011-08-09 03:13:17', 0),
(559, 1, '2011-08-08', '2011-08-09 03:49:29', 0),
(560, 1, '2011-08-09', '2011-08-09 15:08:06', 0),
(561, 1, '2011-08-09', '2011-08-09 15:08:09', 0),
(562, 5, '2011-08-09', '2011-08-09 15:08:11', 0),
(563, 1, '2011-08-09', '2011-08-09 16:52:52', 0),
(564, 1, '2011-08-09', '2011-08-09 18:46:27', 0),
(565, 1, '2011-08-09', '2011-08-09 19:08:11', 0),
(566, 1, '2011-08-09', '2011-08-09 19:08:15', 0),
(567, 1, '2011-08-10', '2011-08-10 18:18:31', 0),
(568, 1, '2011-08-10', '2011-08-11 04:18:56', 0),
(569, 1, '2011-08-11', '2011-08-11 20:35:12', 0),
(570, 5, '2011-08-12', '2011-08-12 07:25:40', 0),
(571, 1, '2011-08-12', '2011-08-12 07:33:30', 0),
(572, 1, '2011-08-12', '2011-08-12 07:33:32', 0),
(573, 1, '2011-08-12', '2011-08-12 11:13:43', 0),
(574, 5, '2011-08-12', '2011-08-12 11:13:47', 0),
(575, 1, '2011-08-12', '2011-08-12 21:06:08', 0),
(576, 1, '2011-08-12', '2011-08-12 22:05:38', 0),
(577, 1, '2011-08-12', '2011-08-12 22:55:48', 0),
(578, 1, '2011-08-12', '2011-08-13 02:25:10', 0),
(579, 1, '2011-08-13', '2011-08-13 12:45:29', 0),
(580, 5, '2011-08-13', '2011-08-13 14:26:58', 0),
(581, 1, '2011-08-13', '2011-08-13 23:10:47', 0),
(582, 1, '2011-08-14', '2011-08-14 09:31:41', 0),
(583, 1, '2011-08-14', '2011-08-14 09:31:43', 0),
(584, 1, '2011-08-14', '2011-08-14 11:15:27', 0),
(585, 1, '2011-08-14', '2011-08-14 16:35:47', 0),
(586, 1, '2011-08-14', '2011-08-14 17:00:13', 0),
(587, 1, '2011-08-15', '2011-08-15 18:28:44', 0),
(588, 1, '2011-08-15', '2011-08-15 18:54:56', 0),
(589, 1, '2011-08-15', '2011-08-15 19:33:21', 0),
(590, 1, '2011-08-16', '2011-08-16 13:27:11', 0),
(591, 1, '2011-08-16', '2011-08-16 21:54:09', 0),
(592, 1, '2011-08-16', '2011-08-17 01:01:53', 0),
(593, 1, '2011-08-16', '2011-08-17 01:01:54', 0),
(594, 1, '2011-08-16', '2011-08-17 03:06:42', 0),
(595, 1, '2011-08-17', '2011-08-17 18:36:58', 0),
(596, 1, '2011-08-17', '2011-08-17 18:37:08', 0),
(597, 1, '2011-08-17', '2011-08-17 20:42:09', 0),
(598, 1, '2011-08-17', '2011-08-17 21:32:27', 0),
(599, 5, '2011-08-17', '2011-08-18 00:36:29', 0),
(600, 1, '2011-08-17', '2011-08-18 00:50:19', 0),
(601, 1, '2011-08-17', '2011-08-18 01:32:33', 0),
(602, 1, '2011-08-18', '2011-08-19 01:14:43', 0),
(603, 1, '2011-08-18', '2011-08-19 01:33:55', 0),
(604, 1, '2011-08-18', '2011-08-19 04:53:57', 0),
(605, 5, '2011-08-19', '2011-08-19 12:41:41', 0),
(606, 1, '2011-08-19', '2011-08-19 15:34:40', 0),
(607, 1, '2011-08-19', '2011-08-19 20:30:59', 0),
(608, 1, '2011-08-19', '2011-08-19 20:31:01', 0),
(609, 1, '2011-08-19', '2011-08-20 02:06:51', 0),
(610, 1, '2011-08-20', '2011-08-20 21:12:10', 0),
(611, 1, '2011-08-20', '2011-08-20 22:52:46', 0),
(612, 1, '2011-08-20', '2011-08-20 23:11:03', 0),
(613, 1, '2011-08-20', '2011-08-21 00:33:10', 0),
(614, 1, '2011-08-21', '2011-08-21 21:39:33', 0),
(615, 1, '2011-08-21', '2011-08-22 02:26:45', 0),
(616, 1, '2011-08-21', '2011-08-22 02:26:47', 0),
(617, 1, '2011-08-21', '2011-08-22 05:57:26', 0),
(618, 1, '2011-08-22', '2011-08-22 12:38:56', 0),
(619, 1, '2011-08-22', '2011-08-22 19:26:41', 0),
(620, 1, '2011-08-22', '2011-08-22 19:57:00', 0),
(621, 1, '2011-08-22', '2011-08-22 21:14:27', 0),
(622, 1, '2011-08-22', '2011-08-22 23:11:28', 0),
(623, 1, '2011-08-22', '2011-08-23 00:38:01', 0),
(624, 1, '2011-08-23', '2011-08-23 06:41:30', 0),
(625, 1, '2011-08-23', '2011-08-23 08:20:44', 0),
(626, 1, '2011-08-23', '2011-08-23 20:24:39', 0),
(627, 1, '2011-08-23', '2011-08-23 20:24:41', 0),
(628, 1, '2011-08-23', '2011-08-24 01:20:41', 0),
(629, 5, '2011-08-23', '2011-08-24 04:38:56', 0),
(630, 1, '2011-08-24', '2011-08-24 20:22:52', 0),
(631, 1, '2011-08-24', '2011-08-24 20:22:53', 0),
(632, 1, '2011-08-24', '2011-08-24 21:21:03', 0),
(633, 1, '2011-08-24', '2011-08-24 22:18:35', 0),
(634, 1, '2011-08-24', '2011-08-24 22:53:32', 0),
(635, 1, '2011-08-24', '2011-08-24 23:01:11', 0),
(636, 5, '2011-08-24', '2011-08-25 00:52:33', 0),
(637, 1, '2011-08-25', '2011-08-25 08:50:44', 0),
(638, 5, '2011-08-25', '2011-08-25 08:50:56', 0),
(639, 1, '2011-08-25', '2011-08-25 22:11:01', 0),
(640, 1, '2011-08-25', '2011-08-25 23:24:08', 0),
(641, 1, '2011-08-26', '2011-08-26 06:15:57', 0),
(642, 1, '2011-08-26', '2011-08-26 07:22:49', 0),
(643, 1, '2011-08-26', '2011-08-26 07:22:50', 0),
(644, 1, '2011-08-26', '2011-08-26 13:45:18', 0),
(645, 1, '2011-08-26', '2011-08-26 14:17:28', 0),
(646, 1, '2011-08-26', '2011-08-26 19:22:29', 0),
(647, 1, '2011-08-26', '2011-08-26 22:18:32', 0),
(648, 1, '2011-08-27', '2011-08-27 08:35:09', 0),
(649, 1, '2011-08-27', '2011-08-27 22:05:25', 0),
(650, 1, '2011-08-27', '2011-08-27 22:12:35', 0),
(651, 1, '2011-08-27', '2011-08-27 22:51:57', 0),
(652, 1, '2011-08-27', '2011-08-27 22:51:57', 0),
(653, 1, '2011-08-28', '2011-08-28 22:21:58', 0),
(654, 1, '2011-08-28', '2011-08-28 22:40:56', 0),
(655, 1, '2011-08-28', '2011-08-28 23:26:37', 0),
(656, 1, '2011-08-28', '2011-08-29 00:29:06', 0),
(657, 1, '2011-08-28', '2011-08-29 01:04:47', 0),
(658, 1, '2011-08-28', '2011-08-29 01:59:32', 0),
(659, 1, '2011-08-28', '2011-08-29 04:02:37', 0),
(660, 1, '2011-08-29', '2011-08-29 22:34:06', 0),
(661, 1, '2011-08-29', '2011-08-30 01:33:36', 0),
(662, 1, '2011-08-30', '2011-08-30 06:45:53', 0),
(663, 1, '2011-08-30', '2011-08-30 06:45:59', 0),
(664, 1, '2011-08-30', '2011-08-30 07:42:20', 0),
(665, 1, '2011-08-30', '2011-08-30 15:01:10', 0),
(666, 1, '2011-08-30', '2011-08-30 23:32:35', 0),
(667, 1, '2011-08-30', '2011-08-31 00:37:15', 0),
(668, 1, '2011-08-31', '2011-08-31 16:38:45', 0),
(669, 1, '2011-08-31', '2011-09-01 02:16:30', 0),
(670, 1, '2011-09-01', '2011-09-01 07:10:56', 0),
(671, 1, '2011-09-01', '2011-09-01 07:10:59', 0),
(672, 1, '2011-09-01', '2011-09-01 16:07:37', 0),
(673, 1, '2011-09-01', '2011-09-01 17:44:38', 0),
(674, 1, '2011-09-01', '2011-09-01 20:07:57', 0),
(675, 1, '2011-09-01', '2011-09-01 21:34:22', 0),
(676, 1, '2011-09-01', '2011-09-02 03:47:28', 0),
(677, 1, '2011-09-01', '2011-09-02 03:51:31', 0),
(678, 1, '2011-09-01', '2011-09-02 03:51:33', 0),
(679, 1, '2011-09-02', '2011-09-02 12:37:18', 0),
(680, 1, '2011-09-02', '2011-09-02 17:08:06', 0),
(681, 1, '2011-09-02', '2011-09-02 20:24:25', 0),
(682, 1, '2011-09-02', '2011-09-03 02:21:12', 0),
(683, 5, '2011-09-03', '2011-09-03 09:45:34', 0),
(684, 1, '2011-09-03', '2011-09-03 13:30:58', 0),
(685, 1, '2011-09-03', '2011-09-03 21:56:43', 0),
(686, 1, '2011-09-03', '2011-09-03 22:32:38', 0),
(687, 1, '2011-09-03', '2011-09-04 04:11:20', 0),
(688, 1, '2011-09-03', '2011-09-04 04:11:33', 0),
(689, 1, '2011-09-05', '2011-09-05 15:48:31', 0),
(690, 1, '2011-09-05', '2011-09-05 15:48:34', 0),
(691, 1, '2011-09-05', '2011-09-05 17:15:14', 0),
(692, 1, '2011-09-05', '2011-09-05 17:51:30', 0),
(693, 1, '2011-09-05', '2011-09-05 22:22:17', 0),
(694, 1, '2011-09-05', '2011-09-06 05:24:51', 0),
(695, 1, '2011-09-06', '2011-09-06 15:40:42', 0),
(696, 1, '2011-09-07', '2011-09-07 09:51:00', 0),
(697, 1, '2011-09-07', '2011-09-07 21:07:23', 0),
(698, 1, '2011-09-07', '2011-09-07 21:39:55', 0),
(699, 1, '2011-09-07', '2011-09-07 22:28:54', 0),
(700, 1, '2011-09-07', '2011-09-08 01:10:26', 0),
(701, 1, '2011-09-08', '2011-09-08 08:20:04', 0),
(702, 1, '2011-09-08', '2011-09-08 08:20:06', 0),
(703, 5, '2011-09-08', '2011-09-08 18:11:56', 0),
(704, 1, '2011-09-08', '2011-09-08 20:47:27', 0),
(705, 1, '2011-09-08', '2011-09-08 23:22:09', 0),
(706, 1, '2011-09-08', '2011-09-09 05:12:54', 0),
(707, 1, '2011-09-08', '2011-09-09 05:13:28', 0),
(708, 5, '2011-09-08', '2011-09-09 05:13:54', 0),
(709, 1, '2011-09-09', '2011-09-09 09:44:48', 0),
(710, 1, '2011-09-09', '2011-09-09 09:44:49', 0),
(711, 1, '2011-09-09', '2011-09-09 13:46:30', 0),
(712, 1, '2011-09-09', '2011-09-09 22:14:26', 0),
(713, 1, '2011-09-09', '2011-09-09 22:57:36', 0),
(714, 1, '2011-09-09', '2011-09-09 22:57:46', 0),
(715, 1, '2011-09-09', '2011-09-09 22:57:47', 0),
(716, 5, '2011-09-10', '2011-09-10 12:17:02', 0),
(717, 1, '2011-09-10', '2011-09-10 12:26:05', 0),
(718, 1, '2011-09-10', '2011-09-10 16:14:26', 0),
(719, 5, '2011-09-10', '2011-09-10 16:14:37', 0),
(720, 1, '2011-09-11', '2011-09-11 18:03:02', 0),
(721, 1, '2011-09-11', '2011-09-11 19:00:32', 0),
(722, 1, '2011-09-11', '2011-09-12 00:18:10', 0),
(723, 1, '2011-09-11', '2011-09-12 02:06:18', 0),
(724, 1, '2011-09-11', '2011-09-12 02:06:20', 0),
(725, 1, '2011-09-12', '2011-09-12 07:02:07', 0),
(726, 1, '2011-09-12', '2011-09-12 07:07:59', 0),
(727, 1, '2011-09-12', '2011-09-12 16:47:37', 0),
(728, 1, '2011-09-12', '2011-09-12 23:51:17', 0),
(729, 1, '2011-09-13', '2011-09-13 17:00:19', 0),
(730, 1, '2011-09-13', '2011-09-13 17:37:07', 0),
(731, 1, '2011-09-13', '2011-09-13 19:31:42', 0),
(732, 1, '2011-09-13', '2011-09-13 22:23:08', 0),
(733, 1, '2011-09-13', '2011-09-14 05:02:27', 0),
(734, 1, '2011-09-13', '2011-09-14 05:02:36', 0),
(735, 1, '2011-09-13', '2011-09-14 05:06:19', 0),
(736, 1, '2011-09-13', '2011-09-14 05:12:27', 0),
(737, 1, '2011-09-13', '2011-09-14 05:23:39', 0),
(738, 1, '2011-09-14', '2011-09-14 07:51:31', 0),
(739, 1, '2011-09-14', '2011-09-14 08:48:23', 0),
(740, 1, '2011-09-14', '2011-09-14 08:48:24', 0),
(741, 1, '2011-09-14', '2011-09-14 09:19:30', 0),
(742, 5, '2011-09-14', '2011-09-14 16:44:49', 0),
(743, 1, '2011-09-15', '2011-09-15 17:44:08', 0),
(744, 1, '2011-09-15', '2011-09-15 21:48:13', 0),
(745, 1, '2011-09-15', '2011-09-15 22:26:45', 0),
(746, 5, '2011-09-16', '2011-09-16 12:45:16', 0),
(747, 5, '2011-09-16', '2011-09-16 14:12:09', 0),
(748, 1, '2011-09-17', '2011-09-17 15:57:10', 0),
(749, 1, '2011-09-17', '2011-09-17 16:47:57', 0),
(750, 1, '2011-09-17', '2011-09-17 18:19:46', 0),
(751, 5, '2011-09-18', '2011-09-18 07:11:56', 0),
(752, 1, '2011-09-18', '2011-09-18 13:18:15', 0),
(753, 1, '2011-09-18', '2011-09-18 23:06:13', 0),
(754, 1, '2011-09-18', '2011-09-18 23:48:12', 0),
(755, 5, '2011-09-18', '2011-09-19 03:10:11', 0),
(756, 1, '2011-09-19', '2011-09-19 11:55:35', 0),
(757, 1, '2011-09-19', '2011-09-19 20:29:55', 0),
(758, 1, '2011-09-19', '2011-09-19 22:09:53', 0),
(759, 1, '2011-09-19', '2011-09-19 22:46:01', 0),
(760, 1, '2011-09-19', '2011-09-20 03:05:23', 0),
(761, 1, '2011-09-19', '2011-09-20 03:05:25', 0),
(762, 1, '2011-09-20', '2011-09-20 06:33:29', 0),
(763, 1, '2011-09-20', '2011-09-20 06:33:50', 0),
(764, 1, '2011-09-20', '2011-09-20 06:35:58', 0),
(765, 1, '2011-09-20', '2011-09-20 06:41:14', 0),
(766, 1, '2011-09-20', '2011-09-20 09:22:19', 0),
(767, 1, '2011-09-20', '2011-09-20 18:39:22', 0),
(768, 1, '2011-09-20', '2011-09-21 01:10:55', 0),
(769, 1, '2011-09-20', '2011-09-21 02:38:21', 0),
(770, 1, '2011-09-21', '2011-09-21 08:29:41', 0),
(771, 1, '2011-09-21', '2011-09-21 08:29:43', 0),
(772, 1, '2011-09-21', '2011-09-21 13:49:19', 0),
(773, 5, '2011-09-21', '2011-09-22 01:16:10', 0),
(774, 1, '2011-09-21', '2011-09-22 05:00:14', 0),
(775, 1, '2011-09-21', '2011-09-22 05:53:08', 0),
(776, 1, '2011-09-22', '2011-09-22 08:08:58', 0),
(777, 5, '2011-09-22', '2011-09-22 10:20:04', 0),
(778, 1, '2011-09-22', '2011-09-22 10:35:38', 0),
(779, 1, '2011-09-22', '2011-09-22 10:35:39', 0),
(780, 1, '2011-09-22', '2011-09-22 15:07:53', 0),
(781, 1, '2011-09-23', '2011-09-23 10:49:15', 0),
(782, 1, '2011-09-23', '2011-09-23 12:02:52', 0),
(783, 1, '2011-09-23', '2011-09-23 16:02:27', 0),
(784, 1, '2011-09-23', '2011-09-23 17:43:56', 0),
(785, 1, '2011-09-23', '2011-09-23 21:55:35', 0),
(786, 1, '2011-09-23', '2011-09-23 23:56:22', 0),
(787, 1, '2011-09-23', '2011-09-23 23:56:23', 0),
(788, 1, '2011-09-24', '2011-09-24 21:00:37', 0),
(789, 1, '2011-09-24', '2011-09-24 23:08:07', 0),
(790, 1, '2011-09-24', '2011-09-24 23:08:13', 0),
(791, 1, '2011-09-24', '2011-09-25 03:27:19', 0),
(792, 1, '2011-09-24', '2011-09-25 05:06:16', 0),
(793, 1, '2011-09-25', '2011-09-25 08:26:03', 0),
(794, 1, '2011-09-25', '2011-09-25 14:26:23', 0),
(795, 1, '2011-09-25', '2011-09-25 16:39:10', 0),
(796, 1, '2011-09-25', '2011-09-25 18:50:26', 0),
(797, 1, '2011-09-25', '2011-09-25 18:50:28', 0),
(798, 1, '2011-09-25', '2011-09-26 04:41:19', 0),
(799, 1, '2011-09-26', '2011-09-26 07:10:16', 0),
(800, 1, '2011-09-26', '2011-09-26 07:23:22', 0),
(801, 1, '2011-09-26', '2011-09-27 00:37:56', 0),
(802, 1, '2011-09-27', '2011-09-27 07:53:36', 0),
(803, 1, '2011-09-27', '2011-09-27 07:53:39', 0),
(804, 1, '2011-09-27', '2011-09-27 23:11:38', 0),
(805, 1, '2011-09-27', '2011-09-27 23:59:01', 0),
(806, 1, '2011-09-27', '2011-09-28 02:51:32', 0),
(807, 1, '2011-09-28', '2011-09-28 15:45:49', 0),
(808, 1, '2011-09-28', '2011-09-28 15:46:07', 0),
(809, 1, '2011-09-28', '2011-09-28 19:04:33', 0),
(810, 1, '2011-09-28', '2011-09-28 19:04:43', 0),
(811, 1, '2011-09-28', '2011-09-28 21:56:18', 0),
(812, 1, '2011-09-28', '2011-09-29 01:36:01', 0),
(813, 1, '2011-09-28', '2011-09-29 02:20:58', 0),
(814, 1, '2011-09-28', '2011-09-29 03:20:34', 0),
(815, 1, '2011-09-29', '2011-09-29 19:02:48', 0),
(816, 1, '2011-09-29', '2011-09-30 01:38:52', 0),
(817, 1, '2011-09-29', '2011-09-30 01:38:54', 0),
(818, 1, '2011-09-30', '2011-09-30 19:43:02', 0),
(819, 1, '2011-09-30', '2011-09-30 19:43:27', 0),
(820, 1, '2011-09-30', '2011-09-30 22:38:03', 0),
(821, 1, '2011-09-30', '2011-09-30 23:09:22', 0),
(822, 1, '2011-10-01', '2011-10-01 14:35:54', 0),
(823, 1, '2011-10-01', '2011-10-01 21:44:28', 0),
(824, 1, '2011-10-02', '2011-10-02 08:45:07', 0),
(825, 1, '2011-10-02', '2011-10-02 08:45:11', 0),
(826, 1, '2011-10-02', '2011-10-02 18:32:08', 0),
(827, 1, '2011-10-03', '2011-10-03 15:46:45', 0),
(828, 1, '2011-10-03', '2011-10-04 04:37:33', 0),
(829, 1, '2011-10-04', '2011-10-04 12:31:15', 0),
(830, 1, '2011-10-04', '2011-10-04 12:31:17', 0),
(831, 1, '2011-10-04', '2011-10-04 15:18:51', 0),
(832, 1, '2011-10-04', '2011-10-04 20:00:46', 0),
(833, 1, '2011-10-04', '2011-10-04 23:58:58', 0),
(834, 1, '2011-10-04', '2011-10-04 23:59:01', 0),
(835, 1, '2011-10-05', '2011-10-05 21:47:40', 0),
(836, 1, '2011-10-06', '2011-10-06 13:44:37', 0),
(837, 1, '2011-10-06', '2011-10-06 15:13:56', 0),
(838, 1, '2011-10-06', '2011-10-06 15:14:00', 0),
(839, 1, '2011-10-07', '2011-10-07 17:53:11', 0),
(840, 5, '2011-10-07', '2011-10-07 18:24:08', 0),
(841, 5, '2011-10-07', '2011-10-08 01:37:09', 0),
(842, 1, '2011-10-07', '2011-10-08 02:43:05', 0),
(843, 1, '2011-10-07', '2011-10-08 05:30:31', 0),
(844, 1, '2011-10-08', '2011-10-08 09:00:54', 0),
(845, 1, '2011-10-08', '2011-10-08 11:58:52', 0),
(846, 1, '2011-10-08', '2011-10-08 11:58:53', 0),
(847, 1, '2011-10-08', '2011-10-08 13:43:59', 0),
(848, 1, '2011-10-08', '2011-10-08 14:05:08', 0),
(849, 5, '2011-10-08', '2011-10-08 14:05:29', 0),
(850, 5, '2011-10-08', '2011-10-08 14:05:50', 0),
(851, 5, '2011-10-08', '2011-10-08 14:06:16', 0),
(852, 5, '2011-10-08', '2011-10-08 14:06:35', 0),
(853, 5, '2011-10-08', '2011-10-08 14:06:36', 0),
(854, 5, '2011-10-08', '2011-10-08 14:07:22', 0),
(855, 1, '2011-10-08', '2011-10-08 14:07:23', 1),
(856, 15, '2011-10-08', '2011-10-08 14:07:41', 1),
(857, 30, '2011-10-08', '2011-10-08 14:07:54', 1),
(858, 31, '2011-10-08', '2011-10-08 14:07:54', 1),
(859, 34, '2011-10-08', '2011-10-08 14:08:17', 1),
(860, 16, '2011-10-08', '2011-10-08 14:08:33', 1),
(861, 17, '2011-10-08', '2011-10-08 14:08:34', 1),
(862, 17, '2011-10-08', '2011-10-08 14:08:41', 1),
(863, 30, '2011-10-08', '2011-10-08 14:08:48', 1),
(864, 31, '2011-10-08', '2011-10-08 14:08:48', 1),
(865, 30, '2011-10-08', '2011-10-08 14:13:38', 1),
(866, 31, '2011-10-08', '2011-10-08 14:13:39', 1),
(867, 31, '2011-10-08', '2011-10-08 14:13:45', 1),
(868, 34, '2011-10-08', '2011-10-08 14:13:53', 1),
(869, 1, '2011-10-08', '2011-10-08 19:03:11', 0),
(870, 1, '2011-10-08', '2011-10-09 01:19:58', 0),
(871, 1, '2011-10-08', '2011-10-09 01:20:43', 0),
(872, 5, '2011-10-08', '2011-10-09 01:21:26', 0),
(873, 1, '2011-10-09', '2011-10-09 07:05:45', 0),
(874, 1, '2011-10-09', '2011-10-09 09:36:36', 0),
(875, 1, '2011-10-09', '2011-10-09 22:07:36', 0),
(876, 1, '2011-10-09', '2011-10-09 22:25:36', 0),
(877, 1, '2011-10-09', '2011-10-09 23:21:55', 0),
(878, 1, '2011-10-10', '2011-10-10 07:42:55', 0),
(879, 1, '2011-10-10', '2011-10-10 12:35:12', 0),
(880, 1, '2011-10-10', '2011-10-10 12:35:13', 0),
(881, 1, '2011-10-10', '2011-10-10 13:10:18', 0),
(882, 1, '2011-10-10', '2011-10-10 23:15:16', 0),
(883, 1, '2011-10-11', '2011-10-11 10:44:52', 0),
(884, 1, '2011-10-11', '2011-10-11 17:30:54', 0),
(885, 1, '2011-10-11', '2011-10-11 22:05:05', 0),
(886, 1, '2011-10-11', '2011-10-11 23:32:24', 0),
(887, 1, '2011-10-11', '2011-10-12 01:49:42', 0),
(888, 1, '2011-10-11', '2011-10-12 01:54:00', 0),
(889, 5, '2011-10-11', '2011-10-12 01:54:26', 0),
(890, 5, '2011-10-11', '2011-10-12 01:54:36', 0),
(891, 5, '2011-10-11', '2011-10-12 01:55:06', 0),
(892, 5, '2011-10-11', '2011-10-12 02:13:50', 0),
(893, 5, '2011-10-11', '2011-10-12 02:13:53', 0),
(894, 5, '2011-10-11', '2011-10-12 02:13:59', 0),
(895, 5, '2011-10-11', '2011-10-12 02:14:00', 0),
(896, 5, '2011-10-11', '2011-10-12 02:14:07', 0),
(897, 5, '2011-10-11', '2011-10-12 02:15:30', 0),
(898, 1, '2011-10-11', '2011-10-12 02:15:30', 1),
(899, 1, '2011-10-11', '2011-10-12 02:15:42', 1),
(900, 1, '2011-10-11', '2011-10-12 02:15:45', 1),
(901, 1, '2011-10-11', '2011-10-12 02:17:33', 1),
(902, 1, '2011-10-11', '2011-10-12 02:17:47', 1),
(903, 1, '2011-10-11', '2011-10-12 02:18:43', 0),
(904, 5, '2011-10-11', '2011-10-12 02:18:50', 0),
(905, 5, '2011-10-11', '2011-10-12 02:19:01', 0),
(906, 1, '2011-10-11', '2011-10-12 02:19:02', 1),
(907, 5, '2011-10-11', '2011-10-12 02:20:41', 1),
(908, 1, '2011-10-11', '2011-10-12 02:20:41', 0),
(909, 1, '2011-10-11', '2011-10-12 02:21:40', 0),
(910, 5, '2011-10-11', '2011-10-12 02:21:45', 0),
(911, 5, '2011-10-11', '2011-10-12 02:21:52', 0),
(912, 1, '2011-10-11', '2011-10-12 02:21:53', 1),
(913, 1, '2011-10-11', '2011-10-12 02:21:58', 1),
(914, 1, '2011-10-11', '2011-10-12 02:24:44', 1),
(915, 1, '2011-10-11', '2011-10-12 02:28:05', 0),
(916, 5, '2011-10-11', '2011-10-12 02:28:13', 0),
(917, 5, '2011-10-11', '2011-10-12 02:28:18', 0),
(918, 1, '2011-10-11', '2011-10-12 02:28:19', 1),
(919, 1, '2011-10-11', '2011-10-12 02:28:42', 1),
(920, 1, '2011-10-11', '2011-10-12 02:30:38', 1),
(921, 1, '2011-10-11', '2011-10-12 02:31:41', 1),
(922, 1, '2011-10-11', '2011-10-12 02:35:08', 0),
(923, 5, '2011-10-11', '2011-10-12 02:35:38', 0),
(924, 5, '2011-10-11', '2011-10-12 02:35:44', 0),
(925, 1, '2011-10-11', '2011-10-12 02:35:44', 1),
(926, 1, '2011-10-11', '2011-10-12 02:36:30', 1),
(927, 1, '2011-10-11', '2011-10-12 03:37:19', 0),
(928, 5, '2011-10-11', '2011-10-12 03:37:24', 0),
(929, 5, '2011-10-11', '2011-10-12 03:37:30', 0),
(930, 1, '2011-10-11', '2011-10-12 03:37:30', 1),
(931, 1, '2011-10-11', '2011-10-12 03:37:37', 1),
(932, 1, '2011-10-11', '2011-10-12 05:15:55', 0),
(933, 1, '2011-10-11', '2011-10-12 05:16:32', 0),
(934, 1, '2011-10-12', '2011-10-12 07:54:33', 0),
(935, 1, '2011-10-12', '2011-10-12 07:54:52', 0),
(936, 1, '2011-10-12', '2011-10-12 07:54:58', 0);

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

--
-- 表的结构 `PageThemes`
--

CREATE TABLE IF NOT EXISTS `PageThemes` (
  `ptID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ptHandle` varchar(64) NOT NULL,
  `ptName` varchar(255) DEFAULT NULL,
  `ptDescription` text,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ptID`),
  UNIQUE KEY `ptHandle` (`ptHandle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `PageThemes`
--

INSERT INTO `PageThemes` (`ptID`, `ptHandle`, `ptName`, `ptDescription`, `pkgID`) VALUES
(1, 'default', 'Plain Yogurt\n', 'Plain Yogurt is Concrete''s default theme.', 0),
(2, 'greensalad', 'Green Salad Theme\n', 'This is Concrete''s Green Salad site theme.', 0),
(3, 'dark_chocolate', 'Dark Chocolate\n', 'Dark Chocolate is Concrete''s default theme in black.', 0);

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

--
-- 表的结构 `PageThemeStyles`
--

CREATE TABLE IF NOT EXISTS `PageThemeStyles` (
  `ptID` int(10) unsigned NOT NULL DEFAULT '0',
  `ptsHandle` varchar(128) NOT NULL,
  `ptsValue` longtext,
  `ptsType` varchar(32) NOT NULL,
  PRIMARY KEY (`ptID`,`ptsHandle`,`ptsType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `PageTypeAttributes`
--

CREATE TABLE IF NOT EXISTS `PageTypeAttributes` (
  `ctID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ctID`,`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `PageTypeAttributes`
--

INSERT INTO `PageTypeAttributes` (`ctID`, `akID`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4);

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

--
-- 表的结构 `PageTypes`
--

CREATE TABLE IF NOT EXISTS `PageTypes` (
  `ctID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ctHandle` varchar(32) NOT NULL,
  `ctIcon` varchar(128) DEFAULT NULL,
  `ctName` varchar(90) NOT NULL,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ctID`),
  UNIQUE KEY `ctHandle` (`ctHandle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `PageTypes`
--

INSERT INTO `PageTypes` (`ctID`, `ctHandle`, `ctIcon`, `ctName`, `pkgID`) VALUES
(1, 'page', 'template3.png', 'Page', 0);

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

--
-- 表的结构 `PileContents`
--

CREATE TABLE IF NOT EXISTS `PileContents` (
  `pcID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pID` int(10) unsigned NOT NULL DEFAULT '0',
  `itemID` int(10) unsigned NOT NULL DEFAULT '0',
  `itemType` varchar(64) NOT NULL,
  `quantity` int(10) unsigned NOT NULL DEFAULT '1',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `displayOrder` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pcID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `Piles`
--

CREATE TABLE IF NOT EXISTS `Piles` (
  `pID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `isDefault` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) DEFAULT NULL,
  `state` varchar(64) NOT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- 转存表中的数据 `Piles`
--

INSERT INTO `Piles` (`pID`, `uID`, `isDefault`, `timestamp`, `name`, `state`) VALUES
(1, 1, 1, '2011-04-19 17:30:00', NULL, 'READY');

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

--
-- 表的结构 `SignupRequests`
--

CREATE TABLE IF NOT EXISTS `SignupRequests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ipFrom` int(10) unsigned NOT NULL DEFAULT '0',
  `date_access` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `index_ipFrom` (`ipFrom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `SystemNotifications`
--

CREATE TABLE IF NOT EXISTS `SystemNotifications` (
  `snID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `snTypeID` int(3) unsigned NOT NULL DEFAULT '0',
  `snURL` text,
  `snURL2` text,
  `snDateTime` datetime NOT NULL,
  `snIsArchived` int(1) NOT NULL DEFAULT '0',
  `snIsNew` int(1) NOT NULL DEFAULT '0',
  `snTitle` varchar(255) DEFAULT NULL,
  `snDescription` text,
  `snBody` text,
  PRIMARY KEY (`snID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;



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

--
-- 表的结构 `TaskPermissions`
--

CREATE TABLE IF NOT EXISTS `TaskPermissions` (
  `tpID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tpHandle` varchar(255) DEFAULT NULL,
  `tpName` varchar(255) DEFAULT NULL,
  `tpDescription` text,
  `pkgID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tpID`),
  UNIQUE KEY `tpHandle` (`tpHandle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 转存表中的数据 `TaskPermissions`
--

INSERT INTO `TaskPermissions` (`tpID`, `tpHandle`, `tpName`, `tpDescription`, `pkgID`) VALUES
(1, 'access_task_permissions', 'Change Task Permissions', '', 0),
(2, 'access_sitemap', 'Access Sitemap and Page Search', '', 0),
(3, 'access_user_search', 'Access User Search', '', 0),
(4, 'access_group_search', 'Access Group Search', '', 0),
(5, 'access_page_defaults', 'Change Content on Page Type Default Pages', '', 0),
(6, 'backup', 'Perform Full Database Backups', '', 0),
(7, 'sudo', 'Sign in as User', '', 0),
(8, 'uninstall_packages', 'Uninstall Packages', '', 0),
(9, 'install_packages', 'Install Packages and Connect to the Marketplace', '', 0);

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

--
-- 表的结构 `TaskPermissionUserGroups`
--

CREATE TABLE IF NOT EXISTS `TaskPermissionUserGroups` (
  `tpID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `canRead` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tpID`,`gID`,`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `TaskPermissionUserGroups`
--

INSERT INTO `TaskPermissionUserGroups` (`tpID`, `gID`, `uID`, `canRead`) VALUES
(1, 3, 0, 1),
(2, 3, 0, 1),
(3, 3, 0, 1),
(4, 3, 0, 1),
(5, 3, 0, 1),
(6, 3, 0, 1),
(8, 3, 0, 1),
(9, 3, 0, 1);

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

--
-- 表的结构 `UserAttributeKeys`
--

CREATE TABLE IF NOT EXISTS `UserAttributeKeys` (
  `akID` int(10) unsigned NOT NULL,
  `uakProfileDisplay` tinyint(1) NOT NULL DEFAULT '0',
  `uakMemberListDisplay` tinyint(1) NOT NULL DEFAULT '0',
  `uakProfileEdit` tinyint(1) NOT NULL DEFAULT '1',
  `uakProfileEditRequired` tinyint(1) NOT NULL DEFAULT '0',
  `uakRegisterEdit` tinyint(1) NOT NULL DEFAULT '0',
  `uakRegisterEditRequired` tinyint(1) NOT NULL DEFAULT '0',
  `displayOrder` int(10) unsigned DEFAULT '0',
  `uakIsActive` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`akID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserAttributeValues`
--

CREATE TABLE IF NOT EXISTS `UserAttributeValues` (
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `akID` int(10) unsigned NOT NULL DEFAULT '0',
  `avID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uID`,`akID`,`avID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserBannedIPs`
--

CREATE TABLE IF NOT EXISTS `UserBannedIPs` (
  `ipFrom` int(10) unsigned NOT NULL DEFAULT '0',
  `ipTo` int(10) unsigned NOT NULL DEFAULT '0',
  `banCode` int(1) unsigned NOT NULL DEFAULT '1',
  `expires` int(10) unsigned NOT NULL DEFAULT '0',
  `isManual` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ipFrom`,`ipTo`),
  KEY `ipFrom` (`ipFrom`),
  KEY `ipTo` (`ipTo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserGroups`
--

CREATE TABLE IF NOT EXISTS `UserGroups` (
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `ugEntered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`uID`,`gID`),
  KEY `uID` (`uID`),
  KEY `gID` (`gID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserOpenIDs`
--

CREATE TABLE IF NOT EXISTS `UserOpenIDs` (
  `uID` int(10) unsigned NOT NULL,
  `uOpenID` varchar(255) NOT NULL,
  PRIMARY KEY (`uOpenID`),
  KEY `uID` (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserPrivateMessages`
--

CREATE TABLE IF NOT EXISTS `UserPrivateMessages` (
  `msgID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uAuthorID` int(10) unsigned NOT NULL DEFAULT '0',
  `msgDateCreated` datetime NOT NULL,
  `msgSubject` varchar(255) NOT NULL,
  `msgBody` text,
  `uToID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`msgID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `UserPrivateMessagesTo`
--

CREATE TABLE IF NOT EXISTS `UserPrivateMessagesTo` (
  `msgID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `uAuthorID` int(10) unsigned NOT NULL DEFAULT '0',
  `msgMailboxID` int(11) NOT NULL,
  `msgIsNew` int(1) NOT NULL DEFAULT '0',
  `msgIsUnread` int(1) NOT NULL DEFAULT '0',
  `msgIsReplied` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`msgID`,`uID`,`uAuthorID`),
  KEY `uID` (`uID`),
  KEY `uAuthorID` (`uAuthorID`),
  KEY `msgFolderID` (`msgMailboxID`),
  KEY `msgIsNew` (`msgIsNew`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UserSearchIndexAttributes`
--

CREATE TABLE IF NOT EXISTS `UserSearchIndexAttributes` (
  `uID` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `UsersFriends`
--

CREATE TABLE IF NOT EXISTS `UsersFriends` (
  `ufID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `status` varchar(64) NOT NULL,
  `friendUID` int(10) unsigned DEFAULT NULL,
  `uDateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ufID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `UserValidationHashes`
--

CREATE TABLE IF NOT EXISTS `UserValidationHashes` (
  `uvhID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uID` int(10) unsigned DEFAULT NULL,
  `uHash` varchar(64) NOT NULL,
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `uDateGenerated` int(10) unsigned NOT NULL DEFAULT '0',
  `uDateRedeemed` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uvhID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

