-- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 01. Oktober 2007 um 19:34 -- Server Version: 4.0.23 -- PHP-Version: 4.4.4 -- -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_categories` -- CREATE TABLE `wp_1_categories` ( `cat_ID` bigint(20) NOT NULL auto_increment, `cat_name` varchar(55) NOT NULL default '', `category_nicename` varchar(200) NOT NULL default '', `category_description` longtext NOT NULL, `category_parent` bigint(20) NOT NULL default '0', `category_count` bigint(20) NOT NULL default '0', `link_count` bigint(20) NOT NULL default '0', `posts_private` tinyint(1) NOT NULL default '0', `links_private` tinyint(1) NOT NULL default '0', PRIMARY KEY (`cat_ID`), KEY `category_nicename` (`category_nicename`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_1_categories` -- INSERT INTO `wp_1_categories` VALUES (1, 'Uncategorized', 'uncategorized', '', 0, 1, 0, 0, 0); INSERT INTO `wp_1_categories` VALUES (2, 'Blogroll', 'blogroll', '', 0, 0, 2, 0, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_comments` -- CREATE TABLE `wp_1_comments` ( `comment_ID` bigint(20) unsigned NOT NULL auto_increment, `comment_post_ID` int(11) NOT NULL default '0', `comment_author` tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL default '', `comment_author_url` varchar(200) NOT NULL default '', `comment_author_IP` varchar(100) 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 NOT NULL, `comment_karma` int(11) NOT NULL default '0', `comment_approved` enum('0','1','spam') NOT NULL default '1', `comment_agent` varchar(255) NOT NULL default '', `comment_type` varchar(20) NOT NULL default '', `comment_parent` bigint(20) NOT NULL default '0', `user_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`comment_ID`), KEY `comment_approved` (`comment_approved`), KEY `comment_post_ID` (`comment_post_ID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `wp_1_comments` -- INSERT INTO `wp_1_comments` VALUES (1, 1, 'Mr WordPress', '', 'http://meinedomain.de/', '127.0.0.1', '2007-10-01 19:31:56', '2007-10-01 17:31:56', 'Hi, this is a comment.
To delete a comment, just log in, and view the posts'' comments, there you will have the option to edit or delete them.', 0, '1', '', '', 0, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_link2cat` -- CREATE TABLE `wp_1_link2cat` ( `rel_id` bigint(20) NOT NULL auto_increment, `link_id` bigint(20) NOT NULL default '0', `category_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`rel_id`), KEY `link_id` (`link_id`,`category_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_1_link2cat` -- INSERT INTO `wp_1_link2cat` VALUES (1, 1, 2); INSERT INTO `wp_1_link2cat` VALUES (2, 2, 2); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_links` -- CREATE TABLE `wp_1_links` ( `link_id` bigint(20) NOT NULL auto_increment, `link_url` varchar(255) NOT NULL default '', `link_name` varchar(255) NOT NULL default '', `link_image` varchar(255) NOT NULL default '', `link_target` varchar(25) NOT NULL default '', `link_category` bigint(20) NOT NULL default '0', `link_description` varchar(255) NOT NULL default '', `link_visible` enum('Y','N') NOT NULL default 'Y', `link_owner` int(11) 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) NOT NULL default '', `link_notes` mediumtext NOT NULL, `link_rss` varchar(255) NOT NULL default '', PRIMARY KEY (`link_id`), KEY `link_category` (`link_category`), KEY `link_visible` (`link_visible`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_1_links` -- INSERT INTO `wp_1_links` VALUES (1, 'http://wordpress.com/', 'WordPress.com', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', 'http://wordpress.com/feed/'); INSERT INTO `wp_1_links` VALUES (2, 'http://wordpress.org/', 'WordPress.org', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', 'http://wordpress.org/development/feed/'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_options` -- CREATE TABLE `wp_1_options` ( `option_id` bigint(20) NOT NULL auto_increment, `blog_id` int(11) NOT NULL default '0', `option_name` varchar(64) NOT NULL default '', `option_can_override` enum('Y','N') NOT NULL default 'Y', `option_type` int(11) NOT NULL default '1', `option_value` longtext NOT NULL, `option_width` int(11) NOT NULL default '20', `option_height` int(11) NOT NULL default '8', `option_description` tinytext NOT NULL, `option_admin_level` int(11) NOT NULL default '1', `autoload` enum('yes','no') NOT NULL default 'yes', PRIMARY KEY (`option_id`,`blog_id`,`option_name`), KEY `option_name` (`option_name`) ) TYPE=MyISAM AUTO_INCREMENT=72 ; -- -- Daten für Tabelle `wp_1_options` -- INSERT INTO `wp_1_options` VALUES (1, 0, 'siteurl', 'Y', 1, 'http://meinedomain.de/', 20, 8, 'WordPress web address', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (2, 0, 'blogname', 'Y', 1, 'Internet Activity', 20, 8, 'Blog title', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (3, 0, 'blogdescription', 'Y', 1, 'Just another weblog', 20, 8, 'Short tagline', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (67, 0, 'wp_1_user_roles', 'Y', 1, 'a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:46:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:6:"import";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:8:"level_10";b:1;s:7:"level_9";b:1;s:7:"level_8";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;s:12:"delete_users";b:1;s:12:"create_users";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:33:{s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{s:12:"upload_files";b:1;s:10:"edit_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:4:"read";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;s:22:"delete_published_posts";b:1;}}s:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{s:10:"edit_posts";b:1;s:4:"read";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;}}s:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (5, 0, 'users_can_register', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (6, 0, 'admin_email', 'Y', 1, 'email@web.de', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (7, 0, 'start_of_week', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (8, 0, 'use_balanceTags', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (9, 0, 'use_smilies', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (10, 0, 'require_name_email', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (11, 0, 'comments_notify', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (12, 0, 'posts_per_rss', 'Y', 1, '10', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (13, 0, 'rss_excerpt_length', 'Y', 1, '50', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (14, 0, 'rss_use_excerpt', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (15, 0, 'mailserver_url', 'Y', 1, 'mail.example.com', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (16, 0, 'mailserver_login', 'Y', 1, 'login@example.com', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (17, 0, 'mailserver_pass', 'Y', 1, 'password', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (18, 0, 'mailserver_port', 'Y', 1, '110', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (19, 0, 'default_category', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (20, 0, 'default_comment_status', 'Y', 1, 'open', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (21, 0, 'default_ping_status', 'Y', 1, 'open', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (22, 0, 'default_pingback_flag', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (23, 0, 'default_post_edit_rows', 'Y', 1, '10', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (24, 0, 'posts_per_page', 'Y', 1, '10', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (25, 0, 'what_to_show', 'Y', 1, 'posts', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (26, 0, 'date_format', 'Y', 1, 'F j, Y', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (27, 0, 'time_format', 'Y', 1, 'g:i a', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (28, 0, 'links_updated_date_format', 'Y', 1, 'F j, Y g:i a', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (29, 0, 'links_recently_updated_prepend', 'Y', 1, '', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (30, 0, 'links_recently_updated_append', 'Y', 1, '', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (31, 0, 'links_recently_updated_time', 'Y', 1, '120', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (32, 0, 'comment_moderation', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (33, 0, 'moderation_notify', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (34, 0, 'permalink_structure', 'Y', 1, '/%category%/%postname%/', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (35, 0, 'gzipcompression', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (36, 0, 'hack_file', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (37, 0, 'blog_charset', 'Y', 1, 'UTF-8', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (38, 0, 'moderation_keys', 'Y', 1, '', 20, 8, '', 1, 'no'); INSERT INTO `wp_1_options` VALUES (39, 0, 'active_plugins', 'Y', 1, '', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (40, 0, 'home', 'Y', 1, 'http://meinedomain.de/', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (41, 0, 'category_base', 'Y', 1, '', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (42, 0, 'ping_sites', 'Y', 1, 'http://rpc.pingomatic.com/', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (43, 0, 'advanced_edit', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (44, 0, 'comment_max_links', 'Y', 1, '2', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (45, 0, 'gmt_offset', 'Y', 1, '2', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (46, 0, 'default_email_category', 'Y', 1, '1', 20, 8, 'Posts by email go to this category', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (47, 0, 'recently_edited', 'Y', 1, '', 20, 8, '', 1, 'no'); INSERT INTO `wp_1_options` VALUES (48, 0, 'use_linksupdate', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (49, 0, 'template', 'Y', 1, 'home', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (50, 0, 'stylesheet', 'Y', 1, 'home', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (51, 0, 'comment_whitelist', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (70, 0, 'page_uris', 'Y', 1, 'a:1:{s:5:"about";i:2;}', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (53, 0, 'blacklist_keys', 'Y', 1, '', 20, 8, '', 1, 'no'); INSERT INTO `wp_1_options` VALUES (54, 0, 'comment_registration', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (55, 0, 'rss_language', 'Y', 1, 'en', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (56, 0, 'html_type', 'Y', 1, 'text/html', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (57, 0, 'use_trackback', 'Y', 1, '0', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (58, 0, 'default_role', 'Y', 1, 'subscriber', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (59, 0, 'db_version', 'Y', 1, '5200', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (60, 0, 'uploads_use_yearmonth_folders', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (61, 0, 'upload_path', 'Y', 1, 'wp-content/blogs.dir/1/files', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (62, 0, 'secret', 'Y', 1, '89074587be135b8e495210aeb04e2f8b', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (63, 0, 'blog_public', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (64, 0, 'default_link_category', 'Y', 1, '2', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (65, 0, 'show_on_front', 'Y', 1, 'posts', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (68, 0, 'fileupload_url', 'Y', 1, 'http://meinedomain.de/files', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (69, 0, 'post_count', 'Y', 1, '1', 20, 8, '', 1, 'yes'); INSERT INTO `wp_1_options` VALUES (71, 0, 'rewrite_rules', 'Y', 1, '', 20, 8, '', 1, 'yes'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_post2cat` -- CREATE TABLE `wp_1_post2cat` ( `rel_id` bigint(20) NOT NULL auto_increment, `post_id` bigint(20) NOT NULL default '0', `category_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`rel_id`), KEY `post_id` (`post_id`,`category_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_1_post2cat` -- INSERT INTO `wp_1_post2cat` VALUES (1, 1, 1); INSERT INTO `wp_1_post2cat` VALUES (2, 2, 1); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_postmeta` -- CREATE TABLE `wp_1_postmeta` ( `meta_id` bigint(20) NOT NULL auto_increment, `post_id` bigint(20) NOT NULL default '0', `meta_key` varchar(255) default NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `post_id` (`post_id`), KEY `meta_key` (`meta_key`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Daten für Tabelle `wp_1_postmeta` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_1_posts` -- CREATE TABLE `wp_1_posts` ( `ID` bigint(20) unsigned NOT NULL auto_increment, `post_author` bigint(20) 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 NOT NULL, `post_title` text NOT NULL, `post_category` int(4) NOT NULL default '0', `post_excerpt` text NOT NULL, `post_status` enum('publish','draft','private','static','object','attachment','inherit','future') NOT NULL default 'publish', `comment_status` enum('open','closed','registered_only') NOT NULL default 'open', `ping_status` enum('open','closed') NOT NULL default 'open', `post_password` varchar(20) NOT NULL default '', `post_name` varchar(200) NOT NULL default '', `to_ping` text NOT NULL, `pinged` text 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` text NOT NULL, `post_parent` bigint(20) NOT NULL default '0', `guid` varchar(255) NOT NULL default '', `menu_order` int(11) NOT NULL default '0', `post_type` varchar(20) NOT NULL default 'post', `post_mime_type` varchar(100) NOT NULL default '', `comment_count` bigint(20) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `post_name` (`post_name`), KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_1_posts` -- INSERT INTO `wp_1_posts` VALUES (1, 1, '2007-10-01 19:31:56', '2007-10-01 17:31:56', 'Welcome to meinedomain.de. This is your first post. Edit or delete it, then start blogging!', 'Hello world!', 0, '', 'publish', 'open', 'open', '', 'hello-world', '', '', '2007-10-01 19:31:56', '2007-10-01 17:31:56', '', 0, '', 0, 'post', '', 1); INSERT INTO `wp_1_posts` VALUES (2, 1, '2007-10-01 19:31:56', '2007-10-01 17:31:56', 'This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.', 'About', 0, '', 'publish', 'open', 'open', '', 'about', '', '', '2007-10-01 19:31:56', '2007-10-01 17:31:56', '', 0, '', 0, 'page', '', 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_blog_versions` -- CREATE TABLE `wp_blog_versions` ( `blog_id` bigint(20) NOT NULL default '0', `db_version` varchar(20) NOT NULL default '', `last_updated` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`blog_id`), KEY `db_version` (`db_version`) ) TYPE=MyISAM; -- -- Daten für Tabelle `wp_blog_versions` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_blogs` -- CREATE TABLE `wp_blogs` ( `blog_id` bigint(20) NOT NULL auto_increment, `site_id` bigint(20) NOT NULL default '0', `domain` varchar(200) NOT NULL default '', `path` varchar(100) NOT NULL default '', `registered` datetime NOT NULL default '0000-00-00 00:00:00', `last_updated` datetime NOT NULL default '0000-00-00 00:00:00', `public` tinyint(2) NOT NULL default '1', `archived` enum('0','1') NOT NULL default '0', `mature` tinyint(2) NOT NULL default '0', `spam` tinyint(2) NOT NULL default '0', `deleted` tinyint(2) NOT NULL default '0', `lang_id` int(11) NOT NULL default '0', PRIMARY KEY (`blog_id`), KEY `domain` (`domain`(50),`path`(5)), KEY `lang_id` (`lang_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `wp_blogs` -- INSERT INTO `wp_blogs` VALUES (1, 1, 'meinedomain.de', '/', '2007-10-01 19:31:55', '0000-00-00 00:00:00', 1, '0', 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_registration_log` -- CREATE TABLE `wp_registration_log` ( `ID` bigint(20) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `IP` varchar(30) NOT NULL default '', `blog_id` bigint(20) NOT NULL default '0', `date_registered` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `IP` (`IP`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `wp_registration_log` -- INSERT INTO `wp_registration_log` VALUES (1, 'email@web.de', '88.134.232.194', 1, '2007-10-01 19:31:56'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_signups` -- CREATE TABLE `wp_signups` ( `domain` varchar(200) NOT NULL default '', `path` varchar(100) NOT NULL default '', `title` longtext NOT NULL, `user_login` varchar(60) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `registered` datetime NOT NULL default '0000-00-00 00:00:00', `activated` datetime NOT NULL default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '0', `activation_key` varchar(50) NOT NULL default '', `meta` longtext, KEY `activation_key` (`activation_key`), KEY `domain` (`domain`) ) TYPE=MyISAM; -- -- Daten für Tabelle `wp_signups` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_site` -- CREATE TABLE `wp_site` ( `id` bigint(20) NOT NULL auto_increment, `domain` varchar(200) NOT NULL default '', `path` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), KEY `domain` (`domain`,`path`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `wp_site` -- INSERT INTO `wp_site` VALUES (1, 'meinedomain.de', '/'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_sitecategories` -- CREATE TABLE `wp_sitecategories` ( `cat_ID` bigint(20) NOT NULL auto_increment, `cat_name` varchar(55) NOT NULL default '', `category_nicename` varchar(200) NOT NULL default '', `last_updated` timestamp(14) NOT NULL, PRIMARY KEY (`cat_ID`), KEY `category_nicename` (`category_nicename`), KEY `last_updated` (`last_updated`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `wp_sitecategories` -- INSERT INTO `wp_sitecategories` VALUES (1, 'Uncategorized', 'uncategorized', '20071001193155'); INSERT INTO `wp_sitecategories` VALUES (2, 'Blogroll', 'blogroll', '20071001193155'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_sitemeta` -- CREATE TABLE `wp_sitemeta` ( `meta_id` bigint(20) NOT NULL auto_increment, `site_id` bigint(20) NOT NULL default '0', `meta_key` varchar(255) default NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `meta_key` (`meta_key`), KEY `site_id` (`site_id`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; -- -- Daten für Tabelle `wp_sitemeta` -- INSERT INTO `wp_sitemeta` VALUES (1, 1, 'admin_email', 'email@web.de'); INSERT INTO `wp_sitemeta` VALUES (2, 1, 'admin_user_id', '1'); INSERT INTO `wp_sitemeta` VALUES (3, 1, 'upload_filetypes', 'jpg jpeg png gif mp3 mov avi wmv midi mid pdf'); INSERT INTO `wp_sitemeta` VALUES (4, 1, 'blog_upload_space', '10'); INSERT INTO `wp_sitemeta` VALUES (5, 1, 'fileupload_maxk', '1500'); INSERT INTO `wp_sitemeta` VALUES (6, 1, 'site_admins', 'a:1:{i:0;s:5:"admin";}'); INSERT INTO `wp_sitemeta` VALUES (7, 1, 'allowed_themes', 'a:2:{i:0;s:17:"WordPress Classic";i:1;s:17:"WordPress Default";}'); INSERT INTO `wp_sitemeta` VALUES (8, 1, 'illegal_names', 'a:7:{i:0;s:3:"www";i:1;s:3:"web";i:2;s:4:"root";i:3;s:5:"admin";i:4;s:4:"main";i:5;s:6:"invite";i:6;s:13:"administrator";}'); INSERT INTO `wp_sitemeta` VALUES (9, 1, 'welcome_email', 'Dear User,\n\nYour new SITE_NAME blog has been successfully set up at:\nBLOG_URL\n\nYou can log in to the administrator account with the following information:\n Username: USERNAME\n Password: PASSWORD\nLogin Here: BLOG_URLwp-login.php\n\nWe hope you enjoy your new weblog.\n Thanks!\n\n--The Team @ SITE_NAME'); INSERT INTO `wp_sitemeta` VALUES (10, 1, 'first_post', 'Welcome to SITE_NAME. This is your first post. Edit or delete it, then start blogging!'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_usermeta` -- CREATE TABLE `wp_usermeta` ( `umeta_id` bigint(20) NOT NULL auto_increment, `user_id` bigint(20) NOT NULL default '0', `meta_key` varchar(255) default NULL, `meta_value` longtext, PRIMARY KEY (`umeta_id`), KEY `user_id` (`user_id`), KEY `meta_key` (`meta_key`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; -- -- Daten für Tabelle `wp_usermeta` -- INSERT INTO `wp_usermeta` VALUES (1, 1, 'nickname', 'admin'); INSERT INTO `wp_usermeta` VALUES (2, 1, 'rich_editing', 'true'); INSERT INTO `wp_usermeta` VALUES (4, 1, 'primary_blog', '1'); INSERT INTO `wp_usermeta` VALUES (5, 1, 'source_domain', 'meinedomain.de'); INSERT INTO `wp_usermeta` VALUES (6, 1, 'wp_1_capabilities', 'a:1:{s:13:"administrator";b:1;}'); INSERT INTO `wp_usermeta` VALUES (7, 1, 'wp_1_user_level', '10'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `wp_users` -- CREATE TABLE `wp_users` ( `ID` bigint(20) unsigned NOT NULL auto_increment, `user_login` varchar(60) NOT NULL default '', `user_pass` varchar(64) NOT NULL default '', `user_nicename` varchar(50) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `user_url` varchar(100) NOT NULL default '', `user_registered` datetime NOT NULL default '0000-00-00 00:00:00', `user_activation_key` varchar(60) NOT NULL default '', `user_status` int(11) NOT NULL default '0', `display_name` varchar(250) 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`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `wp_users` -- INSERT INTO `wp_users` VALUES (1, 'admin', '8b95d6648cb7d92fd1c7a14d3abbffcb', 'admin', 'email@web.de', '', '2007-10-01 17:31:55', '', 0, 'admin', 0, 0);