<h2>Editing File: /usr/local/sitepad/lib/sitepad.sql</h2><form method='post'><textarea name='content' class='file-edit'>
SET SQL_MODE = &quot;NO_AUTO_VALUE_ON_ZERO&quot;;
SET time_zone = &quot;+00:00&quot;;


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `sitepad`
--

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

--
-- Table structure for table `[[dbprefix]]commentmeta`
--

CREATE TABLE `[[dbprefix]]commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
  `meta_value` longtext COLLATE [[collate]],
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]comments`
--

CREATE TABLE `[[dbprefix]]comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext COLLATE [[collate]] NOT NULL,
  `comment_author_email` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text COLLATE [[collate]] NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `[[dbprefix]]links`
--

CREATE TABLE `[[dbprefix]]links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'Y',
  `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
  `link_rating` int(11) NOT NULL DEFAULT '0',
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE [[collate]] NOT NULL,
  `link_rss` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]options`
--

CREATE TABLE `[[dbprefix]]options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) COLLATE [[collate]] NOT NULL DEFAULT '',
  `option_value` longtext COLLATE [[collate]] NOT NULL,
  `autoload` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=113 ;

--
-- Dumping data for table `[[dbprefix]]options`
--

INSERT INTO `[[dbprefix]]options` VALUES
(1, 'siteurl', '[[softurl]]', 'yes'),
(2, 'home', '[[softurl]]', 'yes'),
(3, 'blogname', '[[site_name]]', 'yes'),
(4, 'blogdescription', '[[site_desc]]', 'yes'),
(5, 'users_can_register', '0', 'yes'),
(6, 'admin_email', '[[admin_email]]', 'yes'),
(7, 'start_of_week', '1', 'yes'),
(8, 'use_balanceTags', '0', 'yes'),
(9, 'use_smilies', '1', 'yes'),
(10, 'require_name_email', '1', 'yes'),
(11, 'comments_notify', '1', 'yes'),
(12, 'posts_per_rss', '10', 'yes'),
(13, 'rss_use_excerpt', '0', 'yes'),
(14, 'mailserver_url', 'mail.example.com', 'yes'),
(15, 'mailserver_login', 'login@example.com', 'yes'),
(16, 'mailserver_pass', 'password', 'yes'),
(17, 'mailserver_port', '110', 'yes'),
(18, 'default_category', '1', 'yes'),
(19, 'default_comment_status', 'open', 'yes'),
(20, 'default_ping_status', 'open', 'yes'),
(21, 'default_pingback_flag', '1', 'yes'),
(22, 'posts_per_page', '10', 'yes'),
(23, 'date_format', 'F j, Y', 'yes'),
(24, 'time_format', 'g:i a', 'yes'),
(25, 'links_updated_date_format', 'F j, Y g:i a', 'yes'),
(26, 'comment_moderation', '0', 'yes'),
(27, 'moderation_notify', '1', 'yes'),
(28, 'permalink_structure', '/blog/%year%/%monthnum%/%day%/%postname%/', 'yes'),
(29, 'rewrite_rules', '', 'yes'),
(30, 'hack_file', '0', 'yes'),
(31, 'blog_charset', 'UTF-8', 'yes'),
(32, 'moderation_keys', '', 'no'),
(33, 'active_plugins', '[[active_plugins]]', 'yes'),
(34, 'category_base', '', 'yes'),
(35, 'ping_sites', 'http://rpc.pingomatic.com/', 'yes'),
(36, 'comment_max_links', '2', 'yes'),
(37, 'gmt_offset', '0', 'yes'),
(38, 'default_email_category', '1', 'yes'),
(39, 'recently_edited', '', 'no'),
(40, 'template', '[[theme_name]]', 'yes'),
(41, 'stylesheet', '[[theme_name]]', 'yes'),
(42, 'comment_whitelist', '1', 'yes'),
(43, 'blacklist_keys', '', 'no'),
(44, 'comment_registration', '0', 'yes'),
(45, 'html_type', 'text/html', 'yes'),
(46, 'use_trackback', '0', 'yes'),
(47, 'default_role', 'subscriber', 'yes'),
(48, 'db_version', '44719', 'yes'),
(49, 'uploads_use_yearmonth_folders', '1', 'yes'),
(50, 'upload_path', '', 'yes'),
(51, 'blog_public', '1', 'yes'),
(52, 'default_link_category', '2', 'yes'),
(53, 'show_on_front', 'page', 'yes'),
(54, 'tag_base', '', 'yes'),
(55, 'show_avatars', '1', 'yes'),
(56, 'avatar_rating', 'G', 'yes'),
(57, 'upload_url_path','[[uploads_url]]','yes'),
(58, 'thumbnail_size_w', '150', 'yes'),
(59, 'thumbnail_size_h', '150', 'yes'),
(60, 'thumbnail_crop', '1', 'yes'),
(61, 'medium_size_w', '300', 'yes'),
(62, 'medium_size_h', '300', 'yes'),
(63, 'avatar_default', 'mystery', 'yes'),
(64, 'large_size_w', '1024', 'yes'),
(65, 'large_size_h', '1024', 'yes'),
(66, 'image_default_link_type', 'none', 'yes'),
(67, 'image_default_size', '', 'yes'),
(68, 'image_default_align', '', 'yes'),
(69, 'close_comments_for_old_posts', '0', 'yes'),
(70, 'close_comments_days_old', '14', 'yes'),
(71, 'thread_comments', '1', 'yes'),
(72, 'thread_comments_depth', '5', 'yes'),
(73, 'page_comments', '0', 'yes'),
(74, 'comments_per_page', '50', 'yes'),
(75, 'default_comments_page', 'newest', 'yes'),
(76, 'comment_order', 'asc', 'yes'),
(77, 'sticky_posts', 'a:0:{}', 'yes'),
(78, 'widget_categories', 'a:2:{i:2;a:4:{s:5:&quot;title&quot;;s:0:&quot;&quot;;s:5:&quot;count&quot;;i:0;s:12:&quot;hierarchical&quot;;i:0;s:8:&quot;dropdown&quot;;i:0;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(79, 'widget_text', 'a:0:{}', 'yes'),
(80, 'widget_rss', 'a:0:{}', 'yes'),
(81, 'uninstall_plugins', 'a:0:{}', 'no'),
(82, 'timezone_string', '', 'yes'),
(83, 'page_for_posts', '0', 'yes'),
(84, 'page_on_front', '0', 'yes'),
(85, 'default_post_format', '0', 'yes'),
(86, 'link_manager_enabled', '0', 'yes'),
(87, 'finished_splitting_shared_terms', '1', 'yes'),
(88, 'site_icon', '0', 'yes'),
(89, 'medium_large_size_w', '768', 'yes'),
(90, 'medium_large_size_h', '0', 'yes'),
(91, 'wp_page_for_privacy_policy', '3', 'yes'),
(92, 'show_comments_cookies_opt_in', '1', 'yes'),
(93, 'initial_db_version', '44719', 'yes'),
(94, '[[dbprefix]]user_roles', 'a:5:{s:13:&quot;administrator&quot;;a:2:{s:4:&quot;name&quot;;s:13:&quot;Administrator&quot;;s:12:&quot;capabilities&quot;;a:61:{s:13:&quot;switch_themes&quot;;b:1;s:11:&quot;edit_themes&quot;;b:1;s:16:&quot;activate_plugins&quot;;b:1;s:12:&quot;edit_plugins&quot;;b:1;s:10:&quot;edit_users&quot;;b:1;s:10:&quot;edit_files&quot;;b:1;s:14:&quot;manage_options&quot;;b:1;s:17:&quot;moderate_comments&quot;;b:1;s:17:&quot;manage_categories&quot;;b:1;s:12:&quot;manage_links&quot;;b:1;s:12:&quot;upload_files&quot;;b:1;s:6:&quot;import&quot;;b:1;s:15:&quot;unfiltered_html&quot;;b:1;s:10:&quot;edit_posts&quot;;b:1;s:17:&quot;edit_others_posts&quot;;b:1;s:20:&quot;edit_published_posts&quot;;b:1;s:13:&quot;publish_posts&quot;;b:1;s:10:&quot;edit_pages&quot;;b:1;s:4:&quot;read&quot;;b:1;s:8:&quot;level_10&quot;;b:1;s:7:&quot;level_9&quot;;b:1;s:7:&quot;level_8&quot;;b:1;s:7:&quot;level_7&quot;;b:1;s:7:&quot;level_6&quot;;b:1;s:7:&quot;level_5&quot;;b:1;s:7:&quot;level_4&quot;;b:1;s:7:&quot;level_3&quot;;b:1;s:7:&quot;level_2&quot;;b:1;s:7:&quot;level_1&quot;;b:1;s:7:&quot;level_0&quot;;b:1;s:17:&quot;edit_others_pages&quot;;b:1;s:20:&quot;edit_published_pages&quot;;b:1;s:13:&quot;publish_pages&quot;;b:1;s:12:&quot;delete_pages&quot;;b:1;s:19:&quot;delete_others_pages&quot;;b:1;s:22:&quot;delete_published_pages&quot;;b:1;s:12:&quot;delete_posts&quot;;b:1;s:19:&quot;delete_others_posts&quot;;b:1;s:22:&quot;delete_published_posts&quot;;b:1;s:20:&quot;delete_private_posts&quot;;b:1;s:18:&quot;edit_private_posts&quot;;b:1;s:18:&quot;read_private_posts&quot;;b:1;s:20:&quot;delete_private_pages&quot;;b:1;s:18:&quot;edit_private_pages&quot;;b:1;s:18:&quot;read_private_pages&quot;;b:1;s:12:&quot;delete_users&quot;;b:1;s:12:&quot;create_users&quot;;b:1;s:17:&quot;unfiltered_upload&quot;;b:1;s:14:&quot;edit_dashboard&quot;;b:1;s:14:&quot;update_plugins&quot;;b:1;s:14:&quot;delete_plugins&quot;;b:1;s:15:&quot;install_plugins&quot;;b:1;s:13:&quot;update_themes&quot;;b:1;s:14:&quot;install_themes&quot;;b:1;s:11:&quot;update_core&quot;;b:1;s:10:&quot;list_users&quot;;b:1;s:12:&quot;remove_users&quot;;b:1;s:13:&quot;promote_users&quot;;b:1;s:18:&quot;edit_theme_options&quot;;b:1;s:13:&quot;delete_themes&quot;;b:1;s:6:&quot;export&quot;;b:1;}}s:6:&quot;editor&quot;;a:2:{s:4:&quot;name&quot;;s:6:&quot;Editor&quot;;s:12:&quot;capabilities&quot;;a:34:{s:17:&quot;moderate_comments&quot;;b:1;s:17:&quot;manage_categories&quot;;b:1;s:12:&quot;manage_links&quot;;b:1;s:12:&quot;upload_files&quot;;b:1;s:15:&quot;unfiltered_html&quot;;b:1;s:10:&quot;edit_posts&quot;;b:1;s:17:&quot;edit_others_posts&quot;;b:1;s:20:&quot;edit_published_posts&quot;;b:1;s:13:&quot;publish_posts&quot;;b:1;s:10:&quot;edit_pages&quot;;b:1;s:4:&quot;read&quot;;b:1;s:7:&quot;level_7&quot;;b:1;s:7:&quot;level_6&quot;;b:1;s:7:&quot;level_5&quot;;b:1;s:7:&quot;level_4&quot;;b:1;s:7:&quot;level_3&quot;;b:1;s:7:&quot;level_2&quot;;b:1;s:7:&quot;level_1&quot;;b:1;s:7:&quot;level_0&quot;;b:1;s:17:&quot;edit_others_pages&quot;;b:1;s:20:&quot;edit_published_pages&quot;;b:1;s:13:&quot;publish_pages&quot;;b:1;s:12:&quot;delete_pages&quot;;b:1;s:19:&quot;delete_others_pages&quot;;b:1;s:22:&quot;delete_published_pages&quot;;b:1;s:12:&quot;delete_posts&quot;;b:1;s:19:&quot;delete_others_posts&quot;;b:1;s:22:&quot;delete_published_posts&quot;;b:1;s:20:&quot;delete_private_posts&quot;;b:1;s:18:&quot;edit_private_posts&quot;;b:1;s:18:&quot;read_private_posts&quot;;b:1;s:20:&quot;delete_private_pages&quot;;b:1;s:18:&quot;edit_private_pages&quot;;b:1;s:18:&quot;read_private_pages&quot;;b:1;}}s:6:&quot;author&quot;;a:2:{s:4:&quot;name&quot;;s:6:&quot;Author&quot;;s:12:&quot;capabilities&quot;;a:10:{s:12:&quot;upload_files&quot;;b:1;s:10:&quot;edit_posts&quot;;b:1;s:20:&quot;edit_published_posts&quot;;b:1;s:13:&quot;publish_posts&quot;;b:1;s:4:&quot;read&quot;;b:1;s:7:&quot;level_2&quot;;b:1;s:7:&quot;level_1&quot;;b:1;s:7:&quot;level_0&quot;;b:1;s:12:&quot;delete_posts&quot;;b:1;s:22:&quot;delete_published_posts&quot;;b:1;}}s:11:&quot;contributor&quot;;a:2:{s:4:&quot;name&quot;;s:11:&quot;Contributor&quot;;s:12:&quot;capabilities&quot;;a:5:{s:10:&quot;edit_posts&quot;;b:1;s:4:&quot;read&quot;;b:1;s:7:&quot;level_1&quot;;b:1;s:7:&quot;level_0&quot;;b:1;s:12:&quot;delete_posts&quot;;b:1;}}s:10:&quot;subscriber&quot;;a:2:{s:4:&quot;name&quot;;s:10:&quot;Subscriber&quot;;s:12:&quot;capabilities&quot;;a:2:{s:4:&quot;read&quot;;b:1;s:7:&quot;level_0&quot;;b:1;}}}', 'yes'),
(95, 'fresh_site', '1', 'yes'),
(96, 'widget_search', 'a:2:{i:2;a:1:{s:5:&quot;title&quot;;s:0:&quot;&quot;;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(97, 'widget_recent-posts', 'a:2:{i:2;a:2:{s:5:&quot;title&quot;;s:0:&quot;&quot;;s:6:&quot;number&quot;;i:5;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(98, 'widget_recent-comments', 'a:2:{i:2;a:2:{s:5:&quot;title&quot;;s:0:&quot;&quot;;s:6:&quot;number&quot;;i:5;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(99, 'widget_archives', 'a:2:{i:2;a:3:{s:5:&quot;title&quot;;s:0:&quot;&quot;;s:5:&quot;count&quot;;i:0;s:8:&quot;dropdown&quot;;i:0;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(100, 'widget_meta', 'a:2:{i:2;a:1:{s:5:&quot;title&quot;;s:0:&quot;&quot;;}s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(101, 'sidebars_widgets', 'a:3:{s:19:&quot;wp_inactive_widgets&quot;;a:0:{}s:9:&quot;sidebar-1&quot;;a:6:{i:0;s:8:&quot;search-2&quot;;i:1;s:14:&quot;recent-posts-2&quot;;i:2;s:17:&quot;recent-comments-2&quot;;i:3;s:10:&quot;archives-2&quot;;i:4;s:12:&quot;categories-2&quot;;i:5;s:6:&quot;meta-2&quot;;}s:13:&quot;array_version&quot;;i:3;}', 'yes'),
(102, 'widget_pages', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(103, 'widget_calendar', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(104, 'widget_media_audio', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(105, 'widget_media_image', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(106, 'widget_media_gallery', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(107, 'widget_media_video', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(108, 'widget_tag_cloud', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(109, 'widget_nav_menu', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(110, 'widget_custom_html', 'a:1:{s:12:&quot;_multiwidget&quot;;i:1;}', 'yes'),
(111, 'cron', 'a:4:{i:[[timestamp]];a:4:{s:34:&quot;wp_privacy_delete_old_export_files&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:6:&quot;hourly&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:3600;}}s:16:&quot;wp_version_check&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:10:&quot;twicedaily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:43200;}}s:17:&quot;wp_update_plugins&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:10:&quot;twicedaily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:43200;}}s:16:&quot;wp_update_themes&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:10:&quot;twicedaily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:43200;}}}i:[[timestamp]];a:2:{s:19:&quot;wp_scheduled_delete&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:5:&quot;daily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:86400;}}s:25:&quot;delete_expired_transients&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:5:&quot;daily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:86400;}}}i:[[timestamp]];a:1:{s:30:&quot;wp_scheduled_auto_draft_delete&quot;;a:1:{s:32:&quot;40cd750bba9870f18aada2478b24840a&quot;;a:3:{s:8:&quot;schedule&quot;;s:5:&quot;daily&quot;;s:4:&quot;args&quot;;a:0:{}s:8:&quot;interval&quot;;i:86400;}}}s:7:&quot;version&quot;;i:2;}', 'yes'),
(112, 'can_compress_scripts', '0', 'no'),
(113, 'sp-login', '', 'no'),
(114, 'WPLANG', '[[WPLANG]]', 'auto');
-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]postmeta`
--

CREATE TABLE `[[dbprefix]]postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
  `meta_value` longtext COLLATE [[collate]],
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;


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

--
-- Table structure for table `[[dbprefix]]posts`
--

CREATE TABLE `[[dbprefix]]posts` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext COLLATE [[collate]] NOT NULL,
  `post_title` text COLLATE [[collate]] NOT NULL,
  `post_excerpt` text COLLATE [[collate]] NOT NULL,
  `post_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'open',
  `post_password` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `post_name` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
  `to_ping` text COLLATE [[collate]] NOT NULL,
  `pinged` text COLLATE [[collate]] NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext COLLATE [[collate]] NOT NULL,
  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `guid` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `menu_order` int(11) NOT NULL DEFAULT '0',
  `post_type` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
  `comment_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`(191)),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;

--
-- Table structure for table `[[dbprefix]]termmeta`
--

CREATE TABLE `[[dbprefix]]termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
  `meta_value` longtext COLLATE [[collate]],
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]terms`
--

CREATE TABLE `[[dbprefix]]terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]terms`
--

INSERT INTO `[[dbprefix]]terms` VALUES
(1, 'Uncategorized', 'uncategorized', 0);

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

--
-- Table structure for table `[[dbprefix]]term_relationships`
--

CREATE TABLE `[[dbprefix]]term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]];

--
-- Dumping data for table `[[dbprefix]]term_relationships`
--

INSERT INTO `[[dbprefix]]term_relationships` VALUES
(1, 1, 0);

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

--
-- Table structure for table `[[dbprefix]]term_taxonomy`
--

CREATE TABLE `[[dbprefix]]term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE [[collate]] NOT NULL DEFAULT '',
  `description` longtext COLLATE [[collate]] NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]term_taxonomy`
--

INSERT INTO `[[dbprefix]]term_taxonomy` VALUES
(1, 1, 'category', '', 0, 1);

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

--
-- Table structure for table `[[dbprefix]]usermeta`
--

CREATE TABLE `[[dbprefix]]usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
  `meta_value` longtext COLLATE [[collate]],
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=16 ;

--
-- Dumping data for table `[[dbprefix]]usermeta`
--

INSERT INTO `[[dbprefix]]usermeta` VALUES
(1, 1, 'nickname', '[[admin_username]]'),
(2, 1, 'first_name', ''),
(3, 1, 'last_name', ''),
(4, 1, 'description', ''),
(5, 1, 'rich_editing', 'true'),
(6, 1, 'syntax_highlighting', 'true'),
(7, 1, 'comment_shortcuts', 'false'),
(8, 1, 'admin_color', 'fresh'),
(9, 1, 'use_ssl', '0'),
(10, 1, 'show_admin_bar_front', 'true'),
(11, 1, 'locale', ''),
(12, 1, '[[dbprefix]]capabilities', 'a:1:{s:13:&quot;administrator&quot;;b:1;}'),
(13, 1, '[[dbprefix]]user_level', '10'),
(14, 1, 'dismissed_wp_pointers', ''),
(15, 1, 'show_welcome_panel', '1');

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

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_pass` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(250) COLLATE [[collate]] NOT NULL DEFAULT '',
  `spam` tinyint(2) NOT NULL DEFAULT '0',
  `deleted` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
)  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', '[[admin_username]]', '[[admin_email]]', '', '[[date_gmt]]', '', 0, '[[admin_username]]', 0, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fsitepad%2Flib'>Back to Directory</a>