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

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 Menu Bar', 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),
(9, 'width', 'Width', 1, 0, 1, 0, 0, 6, 3, 0),
(10, 'height', 'Height', 1, 0, 1, 0, 0, 6, 3, 0),
(11, 'tags', 'Tags', 0, 0, 0, 0, 1, 8, 1, 0);

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);

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);

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

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'),
(8, 10, 9, 'DUPLICATE'),
(9, 11, 10, 'DUPLICATE');

INSERT INTO `Blocks` (`bID`, `bName`, `bDateAdded`, `bDateModified`, `bFilename`, `bIsActive`, `btID`, `uID`) VALUES
(1, 'Banner_default', NOW(), NOW(), NULL, '1', 8, 2),
(2, 'Logo_default', NOW(), NOW(), NULL, '1', 1, 2),
(3, NULL, NOW(), NOW(), NULL, '1', 1, 2),
(4, NULL, NOW(), NOW(), NULL, '1', 8, 2),
(5, NULL, NOW(), NOW(), NULL, '1', 13, 2),
(6, NULL, NOW(), NOW(), NULL, '1', 12, 1),
(7, NULL, NOW(), NOW(), NULL, '1', 12, 1),
(8, NULL, NOW(), NOW(), NULL, '1', 3, 1),
(9, NULL, NOW(), NOW(), NULL, '1', 12, 1),
(10, NULL, NOW(), NOW(), NULL, '1', 12, 1),
(11, NULL, NOW(), NOW(), NULL, '1', 12, 1);

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),
(21, 'sortable_fancybox_gallery', 'Sortable Fancybox Gallery', 'Displays images in a fileset (with an optional lightbox), and allows you to change their display order via drag-and-drop.', 1, 0, 0, 0, 800, 480, 1),
(22, 'swp_breadcrumbs', 'Breadcrumbs', 'Add breadcrumbs to your website<br />By <a href="http://www.smartwebprojects.net/">www.smartwebprojects.net</a>', 1, 0, 0, 0, 400, 80, 2),
(23, 'youku', 'Youku Video', 'Embeds a Youku Video in your web page.', 1, 0, 0, 0, 400, 170, 3);

INSERT INTO `btContentImage` (`bID`, `fID`, `fOnstateID`, `maxWidth`, `maxHeight`, `externalLink`, `altText`) VALUES
(1, 1, 0, 0, 0, 'http://', NULL),
(4, 2, 0, 0, 0, 'http://', NULL);

INSERT INTO `btContentLocal` (`bID`, `content`) VALUES
(2, 'CLINKCMS'),
(3, '<h3>歡迎使用 CLINK網站內容管理系統</h3><br />智慧化的管理平台，能逹到&ldquo;所見即所得&rdquo;的效果。<br />登入平台 及 點擊&ldquo;修改網頁&rdquo;，進入編輯狀態後，用滑鼠點擊想修改的內容作即時修改。<br />配合拖拽功能，可隨意改變圖片及文字的顯示位置。懂打字及使用滑鼠便能自主您的網站內容。');

INSERT INTO `btGoogleMap` (`bID`, `title`, `location`, `latitude`, `longitude`, `zoom`) VALUES
(5, '', '1 Tai Yau St.,San Po Kong', 22.338766, 114.199495, 14);

INSERT INTO `btNavigation` (`bID`, `orderBy`, `displayPages`, `displayPagesCID`, `displayPagesIncludeSelf`, `displaySubPages`, `displaySubPageLevels`, `displaySubPageLevelsNum`, `displayUnavailablePages`) VALUES
(8, 'display_asc', 'top', 0, 0, 'none', 'all', 0, 0);

INSERT INTO `btSearch` (`bID`, `title`, `buttonText`, `baseSearchPath`, `resultsURL`) VALUES
(6, 'Search Results', 'Search', '', ''),
(7, '', '', '', 'searchresult'),
(9, '', '', '', 'searchresult'),
(10, ' ', '', '', 'searchresult'),
(11, ' ', '', '', 'searchresult');

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, 4, 46),
(68, 3, 4, 46),
(68, 4, 4, 46),
(68, 5, 4, 46),
(68, 6, 4, 46),
(68, 7, 4, 46),
(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);

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

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),
(36, NULL, NULL, NULL, 0, 0, NULL, 0, 0, NULL),
(67, '', '', '', 0, 0, NULL, 0, 0, NULL),
(68, NULL, NULL, NULL, 1, 0, NULL, 0, 0, NULL);

INSERT INTO `CollectionVersionBlocks` (`cID`, `cvID`, `bID`, `arHandle`, `cbDisplayOrder`, `isOriginal`, `cbOverrideAreaPermissions`, `cbIncludeAll`) VALUES
(36, 2, 1, 'Global', 0, '1', 0, 0),
(36, 3, 1, 'Global', 0, '0', 0, 0),
(36, 3, 2, 'Global', 1, '1', 0, 0),
(1, 3, 3, '[ 主要區域 ]', 0, '1', 0, 0),
(1, 4, 3, '[ 主要區域 ]', 0, '0', 0, 0),
(1, 4, 4, '[ 邊欄區域 ]', 0, '1', 0, 0),
(1, 5, 3, '[ 主要區域 ]', 0, '0', 0, 0),
(1, 5, 4, '[ 邊欄區域 ]', 0, '0', 0, 0),
(1, 5, 5, '[ 其他區域 2 ]', 0, '1', 0, 0),
(68, 3, 8, '[ 主選單列 ]', 0, '1', 0, 0),
(68, 4, 8, '[ 主選單列 ]', 0, '0', 0, 0),
(68, 4, 9, '[ 主要區域 ]', 0, '1', 0, 0),
(68, 5, 8, '[ 主選單列 ]', 0, '0', 0, 0),
(68, 5, 9, '[ 主要區域 ]', 0, '0', 0, 0),
(1, 6, 3, '[ 主要區域 ]', 0, '0', 0, 0),
(1, 7, 3, '[ 主要區域 ]', 0, '0', 0, 0),
(1, 6, 5, '[ 其他區域 2 ]', 0, '0', 0, 0),
(1, 7, 5, '[ 其他區域 1 ]', 0, '0', 0, 0),
(68, 6, 8, '[ 主選單列 ]', 0, '0', 0, 0),
(68, 7, 8, '[ 主選單列 ]', 0, '0', 0, 0),
(68, 6, 10, '[ 主要區域 ]', 0, '1', 0, 0),
(68, 7, 11, '[ 主要區域 ]', 0, '1', 0, 0);

INSERT INTO `CollectionVersionBlockStyles` (`cID`, `cvID`, `bID`, `arHandle`, `csrID`) VALUES
(36, 3, 1, 'Global', 0),
(1, 4, 3, '[ 主要區域 ]', 0),
(1, 5, 3, '[ 主要區域 ]', 0),
(1, 5, 4, '[ 邊欄區域 ]', 0),
(68, 4, 8, '[ 主選單列 ]', 0),
(68, 5, 8, '[ 主選單列 ]', 0),
(68, 5, 9, '[ 主要區域 ]', 0),
(1, 6, 3, '[ 主要區域 ]', 0),
(68, 7, 8, '[ 主選單列 ]', 0),
(1, 6, 5, '[ 其他區域 2 ]', 0),
(68, 6, 8, '[ 主選單列 ]', 0),
(68, 6, 10, '[ 主要區域 ]', 0),
(68, 7, 11, '[ 主要區域 ]', 0);

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

INSERT INTO Config VALUES('SITE',NOW(),'{[CCM:SITE]}',0,0);

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);

INSERT INTO `FileAttributeValues` (`fID`, `fvID`, `akID`, `avID`) VALUES
(1, 1, 12, 1),
(1, 1, 13, 2),
(1, 2, 9, 47),
(1, 2, 10, 48),
(1, 2, 12, 1),
(1, 2, 13, 2);

INSERT INTO `Files` (`fID`, `fDateAdded`, `uID`, `fslID`, `ocID`, `fOverrideSetPermissions`, `fPassword`) VALUES
(1, NOW(), 2, 0, 22, 0, NULL);

INSERT INTO `FileSearchIndexAttributes` (`fID`, `ak_width`, `ak_height`) VALUES
(1, 995.0000, 292.0000),
(2, 178.0000, 136.0000);

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);

INSERT INTO `FileVersionLog` (`fvlID`, `fID`, `fvID`, `fvUpdateTypeID`, `fvUpdateTypeAttributeID`) VALUES
(1, 1, 1, 5, 12),
(2, 1, 1, 5, 13),
(5, 1, 2, 1, 0),
(6, 1, 2, 5, 9),
(7, 1, 2, 5, 10);

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, 'banner.jpg', '661321236954', 1, 122676, 'banner.jpg', '', '', 0, NOW(), 2, 2, NOW(), 1, 1, 0, 'jpg', 1),
(1, 2, 'banner.jpg', '541329796345', 1, 84790, 'banner.jpg', '', '', 1, NOW(), 2, 2, NOW(), 1, 1, 0, 'jpg', 1);

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),
(4, 'cms', 'Master Group by CLink', 0, NULL, NULL, 0, NULL);

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.', NOW(), NOW(), 0, 'Index updated. 2 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.', NOW(), NOW(), 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..', NOW(), NOW(), 0, 'The Job was run successfully.', 0, 'ENABLED', 'process_email', 0);

INSERT INTO `MailImporters` (`miID`, `miHandle`, `miServer`, `miUsername`, `miPassword`, `miEncryption`, `miIsEnabled`, `miEmail`, `miPort`, `pkgID`) VALUES
(1, 'private_message', NULL, NULL, NULL, NULL, 0, NULL, 0, 0);

INSERT INTO `Packages` (`pkgID`, `pkgName`, `pkgHandle`, `pkgDescription`, `pkgDateInstalled`, `pkgIsInstalled`, `pkgVersion`, `pkgAvailableVersion`) VALUES
(1, 'Sortable Fancybox Gallery', 'sortable_fancybox_gallery', 'Displays images in a fileset (with an optional lightbox), and allows you to change their display order via drag-and-drop.', NOW(), 1, '1.13', NULL),
(2, 'Breadcrumbs', 'swp_breadcrumbs', 'Allows to add breadcrumbs navigation as a block.<br />By <a href="http://www.smartwebprojects.net/">www.smartwebprojects.net</a>', NOW(), 1, '1.0', NULL),
(3, 'Youku Player', 'youku', 'Embeds a Youku Player in your web page.', NOW(), 1, '1.0.3', NULL);

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),
(68, 1, 0, 'r', NULL, NULL),
(68, 3, 0, 'rv:wa:db:dc:adm', NULL, NULL),
(68, 4, 0, 'rv:wa:db:dc:adm', NULL, NULL);

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, 2, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'OVERRIDE', NULL, 0, NULL, 0, 11, 0, 0, 0, 1, -1, '0', 0),
(2, 1, '1', NULL, 0, NULL, NULL, NULL, NULL, NOW(), 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, NOW(), 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, NOW(), NULL, NULL, 1, 6, 'OVERRIDE', '/register.php', 0, NULL, 0, 0, 3, 1, 0, 1, -1, '0', 0),
(7, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', '/profile/view.php', 0, NULL, 0, 4, 4, 1, 0, 1, -1, '0', 0),
(8, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), NULL, NULL, 1, 1, 'PARENT', '/page_not_found.php', 0, NULL, 0, 0, 6, 1, 0, 1, -1, '0', 0),
(14, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', '/page_forbidden.php', 0, NULL, 0, 0, 7, 1, 0, 1, -1, '0', 0),
(15, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 15, 'OVERRIDE', '/dashboard/view.php', 0, NULL, 0, 9, 8, 1, 0, 0, -1, '0', 0),
(16, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), 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, NOW(), NULL, NULL, 1, 1, 'PARENT', '/download_file.php', 0, NULL, 0, 0, 9, 1, 0, 0, -1, '0', 0),
(64, 2, '1', NULL, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 0, 'PARENT', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, -1, '0', 0),
(65, 3, '1', NULL, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 0, 'PARENT', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, -1, '0', 0),
(66, 4, '1', NULL, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 0, 'PARENT', NULL, 0, NULL, 0, 0, 0, 0, 0, 0, -1, '0', 0),
(67, 2, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 1, 5, 1, 0, 1, -1, '0', 0),
(68, 5, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 0, 11, 1, 0, 1, -1, '0', 0),
(69, 2, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 1, 1, 1, 0, 1, -1, '0', 0),
(70, 2, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 0, 0, 69, 0, 1, -1, '0', 0),
(71, 1, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 2, 2, 1, 0, 1, -1, '0', 0),
(72, 4, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 0, 0, 71, 0, 1, -1, '0', 0),
(73, 4, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', NULL, 0, NULL, 0, 0, 1, 71, 0, 1, -1, '0', 0),
(74, 0, '0', 1, 0, NULL, NULL, NULL, NULL, NOW(), NULL, NULL, 1, 1, 'PARENT', '/members.php', 0, NULL, 0, 0, 10, 1, 0, 0, -1, '0', 0);

INSERT INTO `PageSearchIndex` (`cID`, `content`, `cName`, `cDescription`, `cPath`, `cDatePublic`, `cDateLastIndexed`, `cDateLastSitemapped`) VALUES
(1, '歡迎使用 CLINK網站內容管理系統 智慧化的管理平台，能逹到&ldquo;所見即所得&rdquo;的效果。 登入平台 及 點擊&ldquo;修改網頁&rdquo;，進入編輯狀態後，用滑鼠點擊想修改的內容作即時修改。 配合拖拽功能，可隨意改變圖片及文字的顯示位置。懂打字及使用滑鼠便能自主您的網站內容。 ', 'Home', NULL, NULL, NOW(), NOW(), NULL),
(36, 'CLINKCMS ', 'Scrapbook', 'Share content across your site.', '/dashboard/scrapbook', NOW(), NOW(), NULL),
(68, '', 'Search Result', '', '/searchresult', NOW(), NOW(), NULL);



INSERT INTO `PageThemes` (`ptID`, `ptHandle`, `ptName`, `ptDescription`, `pkgID`) VALUES
(1, 'default', 'Default', 'Default Theme.', 0);

INSERT INTO `PageTypeAttributes` (`ctID`, `akID`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(6, 4),
(7, 4),
(8, 4);

INSERT INTO `PageTypes` (`ctID`, `ctHandle`, `ctIcon`, `ctName`, `pkgID`) VALUES
(1, 'right_sidebar', 't0_c_right.png', 'Right Sidebar (Default)', 0),
(2, 'left_sidebar', 't0_b_left.png', 'Left Sidebar (Default)', 0),
(3, 'full', 't0_a_main.png', 'Full Width (Default)', 0),
(4, '3cols', 't0_d_3cols.png', 'Three-Column (Default)', 0),
(5, 'full_custom', 't1_a_main.png', 'Full Width (Custom)', 0),
(6, 'left_sidebar_custom', 't1_b_left.png', 'Left Sidebar (Custom)', 0),
(7, 'right_sidebar_custom', 't1_c_right.png', 'Right Sidebar (Custom)', 0),
(8, '3cols_custom', 't1_d_3cols.png', 'Three-Column (Custom)', 0);



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);

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

INSERT INTO `UserGroups` (`uID`, `gID`, `ugEntered`, `type`) VALUES
(1, 3, NOW(), NULL),
(1, 4, NOW(), NULL),
(2, 3, NOW(), NULL);


