--
-- Table structure for table `wp_bp_activity`
--
CREATE TABLE `wp_bp_activity` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`user_id` bigint(20) NOT NULL,
`component` varchar(75) NOT NULL,
`type` varchar(75) NOT NULL,
`action` text NOT NULL,
`content` longtext NOT NULL,
`primary_link` varchar(255) NOT NULL,
`item_id` bigint(20) NOT NULL,
`secondary_item_id` bigint(20),
`date_recorded` datetime NOT NULL,
`hide_sitewide` tinyint(1) DEFAULT "0",
`mptt_left` int(11) NOT NULL DEFAULT "0",
`mptt_right` int(11) NOT NULL DEFAULT "0",
`is_spam` tinyint(1) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_activity_meta`
--
CREATE TABLE `wp_bp_activity_meta` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`activity_id` bigint(20) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_friends`
--
CREATE TABLE `wp_bp_friends` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`initiator_user_id` bigint(20) NOT NULL,
`friend_user_id` bigint(20) NOT NULL,
`is_confirmed` tinyint(1) DEFAULT "0",
`is_limited` tinyint(1) DEFAULT "0",
`date_created` datetime NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_groups`
--
CREATE TABLE `wp_bp_groups` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`creator_id` bigint(20) NOT NULL,
`name` varchar(100) NOT NULL,
`slug` varchar(200) NOT NULL,
`description` longtext NOT NULL,
`status` varchar(10) NOT NULL DEFAULT "public",
`enable_forum` tinyint(1) NOT NULL DEFAULT "1",
`date_created` datetime NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_groups_groupmeta`
--
CREATE TABLE `wp_bp_groups_groupmeta` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`group_id` bigint(20) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_groups_members`
--
CREATE TABLE `wp_bp_groups_members` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`group_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`inviter_id` bigint(20) NOT NULL,
`is_admin` tinyint(1) NOT NULL DEFAULT "0",
`is_mod` tinyint(1) NOT NULL DEFAULT "0",
`user_title` varchar(100) NOT NULL,
`date_modified` datetime NOT NULL,
`comments` longtext NOT NULL,
`is_confirmed` tinyint(1) NOT NULL DEFAULT "0",
`is_banned` tinyint(1) NOT NULL DEFAULT "0",
`invite_sent` tinyint(1) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_messages_messages`
--
CREATE TABLE `wp_bp_messages_messages` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`thread_id` bigint(20) NOT NULL,
`sender_id` bigint(20) NOT NULL,
`subject` varchar(200) NOT NULL,
`message` longtext NOT NULL,
`date_sent` datetime NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_messages_notices`
--
CREATE TABLE `wp_bp_messages_notices` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`subject` varchar(200) NOT NULL,
`message` longtext NOT NULL,
`date_sent` datetime NOT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_messages_recipients`
--
CREATE TABLE `wp_bp_messages_recipients` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`user_id` bigint(20) NOT NULL,
`thread_id` bigint(20) NOT NULL,
`unread_count` int(10) NOT NULL DEFAULT "0",
`sender_only` tinyint(1) NOT NULL DEFAULT "0",
`is_deleted` tinyint(1) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_notifications`
--
CREATE TABLE `wp_bp_notifications` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`user_id` bigint(20) NOT NULL,
`item_id` bigint(20) NOT NULL,
`secondary_item_id` bigint(20),
`component_name` varchar(75) NOT NULL,
`component_action` varchar(75) NOT NULL,
`date_notified` datetime NOT NULL,
`is_new` tinyint(1) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_user_blogs`
--
CREATE TABLE `wp_bp_user_blogs` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`user_id` bigint(20) NOT NULL,
`blog_id` bigint(20) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_user_blogs_blogmeta`
--
CREATE TABLE `wp_bp_user_blogs_blogmeta` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`blog_id` bigint(20) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_xprofile_data`
--
CREATE TABLE `wp_bp_xprofile_data` (
`id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`field_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`value` longtext NOT NULL,
`last_updated` datetime NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_xprofile_fields`
--
CREATE TABLE `wp_bp_xprofile_fields` (
`id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`group_id` bigint(20) unsigned NOT NULL,
`parent_id` bigint(20) unsigned NOT NULL,
`type` varchar(150) NOT NULL,
`name` varchar(150) NOT NULL,
`description` longtext NOT NULL,
`is_required` tinyint(1) NOT NULL DEFAULT "0",
`is_default_option` tinyint(1) NOT NULL DEFAULT "0",
`field_order` bigint(20) NOT NULL DEFAULT "0",
`option_order` bigint(20) NOT NULL DEFAULT "0",
`order_by` varchar(15) NOT NULL,
`can_delete` tinyint(1) NOT NULL DEFAULT "1"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_xprofile_groups`
--
CREATE TABLE `wp_bp_xprofile_groups` (
`id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(150) NOT NULL,
`description` mediumtext NOT NULL,
`group_order` bigint(20) NOT NULL DEFAULT "0",
`can_delete` tinyint(1) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_bp_xprofile_meta`
--
CREATE TABLE `wp_bp_xprofile_meta` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`object_id` bigint(20) NOT NULL,
`object_type` varchar(150) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_commentmeta`
--
CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`comment_id` bigint(20) unsigned NOT NULL DEFAULT "0",
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_comments`
--
CREATE TABLE `wp_comments` (
`comment_ID` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT "0",
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL,
`comment_author_url` varchar(200) NOT NULL,
`comment_author_IP` varchar(100) NOT NULL,
`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` varchar(20) NOT NULL DEFAULT "1",
`comment_agent` varchar(255) NOT NULL,
`comment_type` varchar(20) NOT NULL,
`comment_parent` bigint(20) unsigned NOT NULL DEFAULT "0",
`user_id` bigint(20) unsigned NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_hdwplayer`
--
CREATE TABLE `wp_hdwplayer` (
`id` int(5) NOT NULL auto_increment  PRIMARY KEY,
`videoid` int(5) NOT NULL,
`playlistid` int(5) NOT NULL,
`galleryid` int(5) NOT NULL,
`width` int(5) NOT NULL,
`height` int(5) NOT NULL,
`skinmode` varchar(20) NOT NULL,
`stretchtype` varchar(20) NOT NULL,
`buffertime` int(3) NOT NULL,
`volumelevel` int(3) NOT NULL,
`autoplay` tinyint(4) NOT NULL,
`playlistautoplay` tinyint(4) NOT NULL,
`playlistopen` tinyint(4) NOT NULL,
`playlistrandom` tinyint(4) NOT NULL,
`controlbar` tinyint(4) NOT NULL,
`playpause` tinyint(4) NOT NULL,
`progressbar` tinyint(4) NOT NULL,
`timer` tinyint(4) NOT NULL,
`share` tinyint(4) NOT NULL,
`volume` tinyint(4) NOT NULL,
`fullscreen` tinyint(4) NOT NULL,
`playdock` tinyint(4) NOT NULL,
`playlist` tinyint(4) NOT NULL,
`token` varchar(20) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_hdwplayer_gallery`
--
CREATE TABLE `wp_hdwplayer_gallery` (
`id` int(5) NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(255) NOT NULL,
`rows` int(3) NOT NULL,
`columns` int(3) NOT NULL,
`limit` int(5) NOT NULL,
`width` int(5) NOT NULL,
`height` int(5) NOT NULL,
`space` int(5) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_hdwplayer_playlist`
--
CREATE TABLE `wp_hdwplayer_playlist` (
`id` int(5) NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(255) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_hdwplayer_videos`
--
CREATE TABLE `wp_hdwplayer_videos` (
`id` int(5) NOT NULL auto_increment  PRIMARY KEY,
`playlistid` int(5) NOT NULL,
`title` varchar(255) NOT NULL,
`type` varchar(20) NOT NULL,
`streamer` varchar(255) NOT NULL,
`dvr` tinyint(4) NOT NULL,
`video` varchar(255) NOT NULL,
`hdvideo` varchar(255) NOT NULL,
`preview` varchar(255) NOT NULL,
`thumb` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`ordering` int(11) DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_links`
--
CREATE TABLE `wp_links` (
`link_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`link_url` varchar(255) NOT NULL,
`link_name` varchar(255) NOT NULL,
`link_image` varchar(255) NOT NULL,
`link_target` varchar(25) NOT NULL,
`link_description` varchar(255) NOT NULL,
`link_visible` varchar(20) 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) NOT NULL,
`link_notes` mediumtext NOT NULL,
`link_rss` varchar(255) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_ngg_album`
--
CREATE TABLE `wp_ngg_album` (
`id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`previewpic` bigint(20) NOT NULL DEFAULT "0",
`albumdesc` mediumtext,
`sortorder` longtext NOT NULL,
`pageid` bigint(20) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_ngg_gallery`
--
CREATE TABLE `wp_ngg_gallery` (
`gid` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`path` mediumtext,
`title` mediumtext,
`galdesc` mediumtext,
`pageid` bigint(20) NOT NULL DEFAULT "0",
`previewpic` bigint(20) NOT NULL DEFAULT "0",
`author` bigint(20) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_ngg_pictures`
--
CREATE TABLE `wp_ngg_pictures` (
`pid` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`image_slug` varchar(255) NOT NULL,
`post_id` bigint(20) NOT NULL DEFAULT "0",
`galleryid` bigint(20) NOT NULL DEFAULT "0",
`filename` varchar(255) NOT NULL,
`description` mediumtext,
`alttext` mediumtext,
`imagedate` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`exclude` tinyint(4) DEFAULT "0",
`sortorder` bigint(20) NOT NULL DEFAULT "0",
`meta_data` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_nm_forms`
--
CREATE TABLE `wp_nm_forms` (
`form_id` int(5) NOT NULL auto_increment  PRIMARY KEY,
`form_name` varchar(50) NOT NULL,
`from_email` varchar(50),
`from_name` varchar(50),
`subject` varchar(50),
`receiver_emails` varchar(250),
`reply_to` varchar(50),
`allow_file_upload` varchar(3),
`send_file_as` varchar(15),
`file_meta` mediumtext,
`the_meta` mediumtext NOT NULL,
`form_created` datetime NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_options`
--
CREATE TABLE `wp_options` (
`option_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`option_name` varchar(64) NOT NULL,
`option_value` longtext NOT NULL,
`autoload` varchar(20) NOT NULL DEFAULT "yes"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_discount_codes`
--
CREATE TABLE `wp_pmpro_discount_codes` (
`id` int(10) unsigned NOT NULL auto_increment  PRIMARY KEY,
`code` varchar(32) NOT NULL,
`starts` date NOT NULL,
`expires` date NOT NULL,
`uses` int(11) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_discount_codes_levels`
--
CREATE TABLE `wp_pmpro_discount_codes_levels` (
`code_id` int(11) unsigned NOT NULL PRIMARY KEY,
`level_id` int(11) unsigned NOT NULL PRIMARY KEY,
`initial_payment` decimal(10,2) NOT NULL DEFAULT "0.00",
`billing_amount` decimal(10,2) NOT NULL DEFAULT "0.00",
`cycle_number` int(11) NOT NULL DEFAULT "0",
`cycle_period` enum('Day','Week','Month','Year') DEFAULT "Month",
`billing_limit` int(11) NOT NULL,
`trial_amount` decimal(10,2) NOT NULL DEFAULT "0.00",
`trial_limit` int(11) NOT NULL DEFAULT "0",
`expiration_number` int(10) unsigned NOT NULL,
`expiration_period` enum('Day','Week','Month','Year') NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_discount_codes_uses`
--
CREATE TABLE `wp_pmpro_discount_codes_uses` (
`id` int(10) unsigned NOT NULL auto_increment  PRIMARY KEY,
`code_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`order_id` int(10) unsigned NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT "CURRENT_TIMESTAMP" on update CURRENT_TIMESTAMP 
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_membership_levels`
--
CREATE TABLE `wp_pmpro_membership_levels` (
`id` int(11) unsigned NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`confirmation` longtext NOT NULL,
`initial_payment` decimal(10,2) NOT NULL DEFAULT "0.00",
`billing_amount` decimal(10,2) NOT NULL DEFAULT "0.00",
`cycle_number` int(11) NOT NULL DEFAULT "0",
`cycle_period` enum('Day','Week','Month','Year') DEFAULT "Month",
`billing_limit` int(11) NOT NULL,
`trial_amount` decimal(10,2) NOT NULL DEFAULT "0.00",
`trial_limit` int(11) NOT NULL DEFAULT "0",
`allow_signups` tinyint(4) NOT NULL DEFAULT "1",
`expiration_number` int(10) unsigned NOT NULL,
`expiration_period` enum('Day','Week','Month','Year') NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_membership_orders`
--
CREATE TABLE `wp_pmpro_membership_orders` (
`id` int(11) unsigned NOT NULL auto_increment  PRIMARY KEY,
`code` varchar(10) NOT NULL,
`session_id` varchar(64) NOT NULL,
`user_id` int(11) unsigned NOT NULL DEFAULT "0",
`membership_id` int(11) unsigned NOT NULL DEFAULT "0",
`paypal_token` varchar(64) NOT NULL,
`billing_name` varchar(128) NOT NULL,
`billing_street` varchar(128) NOT NULL,
`billing_city` varchar(128) NOT NULL,
`billing_state` varchar(32) NOT NULL,
`billing_zip` varchar(16) NOT NULL,
`billing_country` varchar(128) NOT NULL,
`billing_phone` varchar(32) NOT NULL,
`subtotal` varchar(16) NOT NULL,
`tax` varchar(16) NOT NULL,
`couponamount` varchar(16) NOT NULL,
`certificate_id` int(11) NOT NULL DEFAULT "0",
`certificateamount` varchar(16) NOT NULL,
`total` varchar(16) NOT NULL,
`payment_type` varchar(64) NOT NULL,
`cardtype` varchar(32) NOT NULL,
`accountnumber` varchar(32) NOT NULL,
`expirationmonth` char(2) NOT NULL,
`expirationyear` varchar(4) NOT NULL,
`status` varchar(32) NOT NULL,
`gateway` varchar(64) NOT NULL,
`gateway_environment` varchar(64) NOT NULL,
`payment_transaction_id` varchar(64) NOT NULL,
`subscription_transaction_id` varchar(32) NOT NULL,
`timestamp` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`affiliate_id` varchar(32) NOT NULL,
`affiliate_subid` varchar(32) NOT NULL,
`notes` text NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_memberships_categories`
--
CREATE TABLE `wp_pmpro_memberships_categories` (
`membership_id` int(11) unsigned NOT NULL PRIMARY KEY,
`category_id` int(11) unsigned NOT NULL PRIMARY KEY,
`modified` timestamp NOT NULL DEFAULT "CURRENT_TIMESTAMP" on update CURRENT_TIMESTAMP 
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_memberships_pages`
--
CREATE TABLE `wp_pmpro_memberships_pages` (
`membership_id` int(11) unsigned NOT NULL PRIMARY KEY,
`page_id` int(11) unsigned NOT NULL PRIMARY KEY,
`modified` timestamp NOT NULL DEFAULT "CURRENT_TIMESTAMP" on update CURRENT_TIMESTAMP 
) ENGINE = MYISAM;



--
-- Table structure for table `wp_pmpro_memberships_users`
--
CREATE TABLE `wp_pmpro_memberships_users` (
`id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`user_id` int(11) unsigned NOT NULL,
`membership_id` int(11) unsigned NOT NULL,
`code_id` int(11) unsigned NOT NULL,
`initial_payment` decimal(10,2) NOT NULL,
`billing_amount` decimal(10,2) NOT NULL,
`cycle_number` int(11) NOT NULL,
`cycle_period` enum('Day','Week','Month','Year') NOT NULL DEFAULT "Month",
`billing_limit` int(11) NOT NULL,
`trial_amount` decimal(10,2) NOT NULL,
`trial_limit` int(11) NOT NULL,
`status` varchar(20) NOT NULL DEFAULT "active",
`startdate` datetime NOT NULL,
`enddate` datetime,
`modified` timestamp NOT NULL DEFAULT "CURRENT_TIMESTAMP" on update CURRENT_TIMESTAMP 
) ENGINE = MYISAM;



--
-- Table structure for table `wp_polaroid_slides_lite`
--
CREATE TABLE `wp_polaroid_slides_lite` (
`id` int(11) NOT NULL auto_increment  PRIMARY KEY,
`parent_id` int(11) NOT NULL DEFAULT "0",
`slider_id` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`name` text NOT NULL,
`data` text NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_postmeta`
--
CREATE TABLE `wp_postmeta` (
`meta_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`post_id` bigint(20) unsigned NOT NULL DEFAULT "0",
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_posts`
--
CREATE TABLE `wp_posts` (
`ID` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`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 NOT NULL,
`post_title` text NOT NULL,
`post_excerpt` text NOT NULL,
`post_status` varchar(20) NOT NULL DEFAULT "publish",
`comment_status` varchar(20) NOT NULL DEFAULT "open",
`ping_status` varchar(20) NOT NULL DEFAULT "open",
`post_password` varchar(20) NOT NULL,
`post_name` varchar(200) NOT NULL,
`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` longtext NOT NULL,
`post_parent` bigint(20) unsigned NOT NULL DEFAULT "0",
`guid` varchar(255) NOT NULL,
`menu_order` int(11) NOT NULL DEFAULT "0",
`post_type` varchar(20) NOT NULL DEFAULT "post",
`post_mime_type` varchar(100) NOT NULL,
`comment_count` bigint(20) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_term_relationships`
--
CREATE TABLE `wp_term_relationships` (
`object_id` bigint(20) unsigned NOT NULL DEFAULT "0" PRIMARY KEY,
`term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT "0" PRIMARY KEY,
`term_order` int(11) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_term_taxonomy`
--
CREATE TABLE `wp_term_taxonomy` (
`term_taxonomy_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`term_id` bigint(20) unsigned NOT NULL DEFAULT "0",
`taxonomy` varchar(32) NOT NULL,
`description` longtext NOT NULL,
`parent` bigint(20) unsigned NOT NULL DEFAULT "0",
`count` bigint(20) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_terms`
--
CREATE TABLE `wp_terms` (
`term_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`name` varchar(200) NOT NULL,
`slug` varchar(200) NOT NULL,
`term_group` bigint(10) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_usermeta`
--
CREATE TABLE `wp_usermeta` (
`umeta_id` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`user_id` bigint(20) unsigned NOT NULL DEFAULT "0",
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_users`
--
CREATE TABLE `wp_users` (
`ID` bigint(20) unsigned NOT NULL auto_increment  PRIMARY KEY,
`user_login` varchar(60) NOT NULL,
`user_pass` varchar(64) NOT NULL,
`user_nicename` varchar(50) NOT NULL,
`user_email` varchar(100) NOT NULL,
`user_url` varchar(100) NOT NULL,
`user_registered` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`user_activation_key` varchar(60) NOT NULL,
`user_status` int(11) NOT NULL DEFAULT "0",
`display_name` varchar(250) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_attribute_taxonomies`
--
CREATE TABLE `wp_woocommerce_attribute_taxonomies` (
`attribute_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`attribute_name` varchar(200) NOT NULL,
`attribute_label` longtext,
`attribute_type` varchar(200) NOT NULL,
`attribute_orderby` varchar(200) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_downloadable_product_permissions`
--
CREATE TABLE `wp_woocommerce_downloadable_product_permissions` (
`download_id` varchar(32) NOT NULL PRIMARY KEY,
`product_id` bigint(20) NOT NULL PRIMARY KEY,
`order_id` bigint(20) NOT NULL DEFAULT "0" PRIMARY KEY,
`order_key` varchar(200) NOT NULL PRIMARY KEY,
`user_email` varchar(200) NOT NULL,
`user_id` bigint(20),
`downloads_remaining` varchar(9),
`access_granted` datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
`access_expires` datetime,
`download_count` bigint(20) NOT NULL DEFAULT "0"
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_order_itemmeta`
--
CREATE TABLE `wp_woocommerce_order_itemmeta` (
`meta_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`order_item_id` bigint(20) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_order_items`
--
CREATE TABLE `wp_woocommerce_order_items` (
`order_item_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`order_item_name` longtext NOT NULL,
`order_item_type` varchar(200) NOT NULL,
`order_id` bigint(20) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_tax_rate_locations`
--
CREATE TABLE `wp_woocommerce_tax_rate_locations` (
`location_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`location_code` varchar(255) NOT NULL,
`tax_rate_id` bigint(20) NOT NULL,
`location_type` varchar(40) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_tax_rates`
--
CREATE TABLE `wp_woocommerce_tax_rates` (
`tax_rate_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`tax_rate_country` varchar(200) NOT NULL,
`tax_rate_state` varchar(200) NOT NULL,
`tax_rate` varchar(200) NOT NULL,
`tax_rate_name` varchar(200) NOT NULL,
`tax_rate_priority` bigint(20) NOT NULL,
`tax_rate_compound` int(1) NOT NULL DEFAULT "0",
`tax_rate_shipping` int(1) NOT NULL DEFAULT "1",
`tax_rate_order` bigint(20) NOT NULL,
`tax_rate_class` varchar(200) NOT NULL
) ENGINE = MYISAM;



--
-- Table structure for table `wp_woocommerce_termmeta`
--
CREATE TABLE `wp_woocommerce_termmeta` (
`meta_id` bigint(20) NOT NULL auto_increment  PRIMARY KEY,
`woocommerce_term_id` bigint(20) NOT NULL,
`meta_key` varchar(255),
`meta_value` longtext
) ENGINE = MYISAM;



