Forum Replies Created

<?php
/**
 * Admin new order email
 *
 * @author WooThemes
 * @package WooCommerce/Templates/Emails/HTML
 * @version 2.0.0
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}

?>

<?php do_action( 'woocommerce_email_header', $email_heading ); ?>

<p><?php printf( __( 'You have received an order from %s. The order is as follows:', 'woocommerce' ), $order->billing_first_name . ' ' . $order->billing_last_name ); ?></p>

<?php do_action( 'woocommerce_email_before_order_table', $order, true, false ); ?>

<h2><a href="<?php echo admin_url( 'post.php?post=' . $order->id . '&action=edit' ); ?>"><?php printf( __( 'Order #%s', 'woocommerce'), $order->get_order_number() ); ?></a> (<?php printf( '<time datetime="%s">%s</time>', date_i18n( 'c', strtotime( $order->order_date ) ), date_i18n( wc_date_format(), strtotime( $order->order_date ) ) ); ?>)</h2>

<table cellspacing="0" cellpadding="6" style="width: 100%; border: 1px solid #eee;" border="1" bordercolor="#eee">
	<thead>
		<tr>
			<th scope="col" style="text-align:left; border: 1px solid #eee;"><?php _e( 'Product', 'woocommerce' ); ?></th>
			<th scope="col" style="text-align:left; border: 1px solid #eee;"><?php _e( 'Quantity', 'woocommerce' ); ?></th>
			<th scope="col" style="text-align:left; border: 1px solid #eee;"><?php _e( 'Price', 'woocommerce' ); ?></th>
		</tr>
	</thead>
	<tbody>
		<?php echo $order->email_order_items_table( false, true ); ?>
	</tbody>
	<tfoot>
		<?php
			if ( $totals = $order->get_order_item_totals() ) {
				$i = 0;
				foreach ( $totals as $total ) {
					$i++;
					?><tr>
						<th scope="row" colspan="2" style="text-align:left; border: 1px solid #eee; <?php if ( $i == 1 ) echo 'border-top-width: 4px;'; ?>"><?php echo $total['label']; ?></th>
						<td style="text-align:left; border: 1px solid #eee; <?php if ( $i == 1 ) echo 'border-top-width: 4px;'; ?>"><?php echo $total['value']; ?></td>
					</tr><?php
				}
			}
		?>
	</tfoot>
</table>

<?php do_action( 'woocommerce_email_after_order_table', $order, true, false ); ?>

<?php do_action( 'woocommerce_email_order_meta', $order, true, false ); ?>

<?php do_action( 'woocommerce_email_customer_details', $order, $sent_to_admin, $plain_text ); ?>

<?php do_action( 'woocommerce_email_footer' ); ?>

Thanks
Nat

Forum: Plugins
In reply to: [Gift Aid for WooCommerce] Gift Aid in the emails

Thread Starter nat@cry

(@natcry)

8 years, 1 month ago

Hi Dave

Wordpress: 4.7.2
Woocommerce: 2.6.14
Gift aid for Woocommerce: 1.2.4

We are using custom templates for the emails, would this affect it?

Kind regards
Nat

Forum: Plugins
In reply to: [WP Password Policy Manager] Form not valid ?

nat@cry

(@natcry)

9 years, 3 months ago

Hi We are now experiencing this problem on our website is there a fix for this?

Kind regards
Nat

Forum: Plugins
In reply to: [Events Made Easy] Database insert failed!

Thread Starter nat@cry

(@natcry)

10 years, 5 months ago

Hi sorry I haadn’t seen your reply will try it and see if it works. Sorry for the delay.

Forum: Plugins
In reply to: [Events Made Easy] Database insert failed!

Thread Starter nat@cry

(@natcry)

10 years, 5 months ago

Right is this what your after?

-- phpMyAdmin SQL Dump
-- version 4.1.8
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 27, 2014 at 09:19 AM
-- Server version: 5.5.37-cll
-- PHP Version: 5.4.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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: <code>c1578172_wp252</code>
--

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

--
-- Table structure for table <code>wp_2_commentmeta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_commentmeta</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>comment_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>meta_id</code>),
  KEY <code>comment_id</code> (<code>comment_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table <code>wp_2_comments</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_comments</code> (
  <code>comment_ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>comment_post_ID</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>comment_author</code> tinytext NOT NULL,
  <code>comment_author_email</code> varchar(100) NOT NULL DEFAULT '',
  <code>comment_author_url</code> varchar(200) NOT NULL DEFAULT '',
  <code>comment_author_IP</code> varchar(100) NOT NULL DEFAULT '',
  <code>comment_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>comment_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>comment_content</code> text NOT NULL,
  <code>comment_karma</code> int(11) NOT NULL DEFAULT '0',
  <code>comment_approved</code> varchar(20) NOT NULL DEFAULT '1',
  <code>comment_agent</code> varchar(255) NOT NULL DEFAULT '',
  <code>comment_type</code> varchar(20) NOT NULL DEFAULT '',
  <code>comment_parent</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>user_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>comment_ID</code>),
  KEY <code>comment_post_ID</code> (<code>comment_post_ID</code>),
  KEY <code>comment_approved_date_gmt</code> (<code>comment_approved</code>,<code>comment_date_gmt</code>),
  KEY <code>comment_date_gmt</code> (<code>comment_date_gmt</code>),
  KEY <code>comment_parent</code> (<code>comment_parent</code>),
  KEY <code>comment_author_email</code> (<code>comment_author_email</code>(10))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_2_eme_answers</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_answers</code> (
  <code>booking_id</code> mediumint(9) NOT NULL,
  <code>field_name</code> tinytext NOT NULL,
  <code>answer</code> text NOT NULL,
  KEY <code>booking_id</code> (<code>booking_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_2_eme_bookings</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_bookings</code> (
  <code>booking_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>event_id</code> mediumint(9) NOT NULL,
  <code>person_id</code> mediumint(9) NOT NULL,
  <code>booking_seats</code> mediumint(9) NOT NULL,
  <code>booking_seats_mp</code> varchar(250) DEFAULT NULL,
  <code>booking_approved</code> tinyint(1) DEFAULT '0',
  <code>booking_comment</code> text,
  <code>booking_price</code> text,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>booking_payed</code> tinyint(1) DEFAULT '0',
  <code>transfer_nbr_be97</code> varchar(20) DEFAULT NULL,
  <code>wp_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>lang</code> varchar(10) DEFAULT '',
  UNIQUE KEY <code>booking_id</code> (<code>booking_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_categories</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_categories</code> (
  <code>category_id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>category_name</code> tinytext NOT NULL,
  UNIQUE KEY <code>category_id</code> (<code>category_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_events</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_events</code> (
  <code>event_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>event_status</code> mediumint(9) DEFAULT '1',
  <code>event_author</code> mediumint(9) DEFAULT '0',
  <code>event_name</code> text NOT NULL,
  <code>event_slug</code> text,
  <code>event_url</code> text,
  <code>event_start_time</code> time NOT NULL,
  <code>event_end_time</code> time NOT NULL,
  <code>event_start_date</code> date NOT NULL,
  <code>event_end_date</code> date DEFAULT NULL,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>event_notes</code> longtext,
  <code>event_rsvp</code> tinyint(1) DEFAULT '0',
  <code>use_paypal</code> tinyint(1) DEFAULT '0',
  <code>use_google</code> tinyint(1) DEFAULT '0',
  <code>use_2co</code> tinyint(1) DEFAULT '0',
  <code>use_webmoney</code> tinyint(1) DEFAULT '0',
  <code>use_fdgg</code> tinyint(1) DEFAULT '0',
  <code>price</code> text,
  <code>currency</code> text,
  <code>rsvp_number_days</code> tinyint(3) unsigned DEFAULT '0',
  <code>rsvp_number_hours</code> tinyint(3) unsigned DEFAULT '0',
  <code>event_seats</code> text,
  <code>event_contactperson_id</code> mediumint(9) DEFAULT '0',
  <code>location_id</code> mediumint(9) DEFAULT '0',
  <code>recurrence_id</code> mediumint(9) DEFAULT '0',
  <code>event_category_ids</code> text,
  <code>event_attributes</code> text,
  <code>event_properties</code> text,
  <code>event_page_title_format</code> text,
  <code>event_single_event_format</code> text,
  <code>event_contactperson_email_body</code> text,
  <code>event_respondent_email_body</code> text,
  <code>event_registration_recorded_ok_html</code> text,
  <code>event_registration_pending_email_body</code> text,
  <code>event_registration_updated_email_body</code> text,
  <code>event_registration_form_format</code> text,
  <code>event_cancel_form_format</code> text,
  <code>registration_requires_approval</code> tinyint(1) DEFAULT '0',
  <code>registration_wp_users_only</code> tinyint(1) DEFAULT '0',
  <code>event_image_url</code> text,
  <code>event_image_id</code> mediumint(9) NOT NULL DEFAULT '0',
  <code>event_external_ref</code> text,
  UNIQUE KEY <code>event_id</code> (<code>event_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table <code>wp_2_eme_fieldtypes</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_fieldtypes</code> (
  <code>type_id</code> int(11) NOT NULL,
  <code>type_info</code> tinytext NOT NULL,
  <code>is_multi</code> int(1) DEFAULT '0',
  UNIQUE KEY <code>type_id</code> (<code>type_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_2_eme_formfields</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_formfields</code> (
  <code>field_id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>field_type</code> mediumint(9) NOT NULL,
  <code>field_name</code> tinytext NOT NULL,
  <code>field_info</code> text NOT NULL,
  <code>field_tags</code> text,
  UNIQUE KEY <code>field_id</code> (<code>field_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_locations</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_locations</code> (
  <code>location_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>location_name</code> text NOT NULL,
  <code>location_slug</code> text,
  <code>location_url</code> text,
  <code>location_address</code> tinytext NOT NULL,
  <code>location_town</code> tinytext NOT NULL,
  <code>location_latitude</code> float DEFAULT NULL,
  <code>location_longitude</code> float DEFAULT NULL,
  <code>location_description</code> text,
  <code>location_author</code> mediumint(9) DEFAULT '0',
  <code>location_category_ids</code> text,
  <code>location_creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_image_url</code> text,
  <code>location_image_id</code> mediumint(9) NOT NULL DEFAULT '0',
  <code>location_attributes</code> text,
  <code>location_properties</code> text,
  <code>location_external_ref</code> text,
  UNIQUE KEY <code>location_id</code> (<code>location_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table <code>wp_2_eme_payments</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_payments</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>booking_ids</code> text NOT NULL,
  UNIQUE KEY <code>id</code> (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_people</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_people</code> (
  <code>person_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>person_name</code> tinytext NOT NULL,
  <code>person_email</code> tinytext NOT NULL,
  <code>person_phone</code> tinytext,
  <code>wp_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>lang</code> varchar(10) DEFAULT '',
  UNIQUE KEY <code>person_id</code> (<code>person_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_recurrence</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_recurrence</code> (
  <code>recurrence_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>recurrence_start_date</code> date NOT NULL,
  <code>recurrence_end_date</code> date NOT NULL,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>recurrence_interval</code> tinyint(4) NOT NULL,
  <code>recurrence_freq</code> tinytext NOT NULL,
  <code>recurrence_byday</code> tinytext NOT NULL,
  <code>recurrence_byweekno</code> tinyint(4) NOT NULL,
  <code>recurrence_specific_days</code> text,
  UNIQUE KEY <code>recurrence_id</code> (<code>recurrence_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_eme_templates</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_eme_templates</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>description</code> tinytext,
  <code>format</code> text NOT NULL,
  UNIQUE KEY <code>id</code> (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_bookings</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_bookings</code> (
  <code>booking_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>event_id</code> bigint(20) unsigned NOT NULL,
  <code>person_id</code> bigint(20) unsigned NOT NULL,
  <code>booking_spaces</code> int(5) NOT NULL,
  <code>booking_comment</code> text,
  <code>booking_date</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  <code>booking_status</code> tinyint(1) NOT NULL DEFAULT '1',
  <code>booking_price</code> decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  <code>booking_tax_rate</code> decimal(5,2) DEFAULT NULL,
  <code>booking_taxes</code> decimal(10,2) DEFAULT NULL,
  <code>booking_meta</code> longtext,
  PRIMARY KEY (<code>booking_id</code>),
  KEY <code>event_id</code> (<code>event_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_events</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_events</code> (
  <code>event_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_id</code> bigint(20) unsigned NOT NULL,
  <code>event_slug</code> varchar(200) DEFAULT NULL,
  <code>event_owner</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_status</code> int(1) DEFAULT NULL,
  <code>event_name</code> text,
  <code>event_start_time</code> time DEFAULT NULL,
  <code>event_end_time</code> time DEFAULT NULL,
  <code>event_all_day</code> int(1) DEFAULT NULL,
  <code>event_start_date</code> date DEFAULT NULL,
  <code>event_end_date</code> date DEFAULT NULL,
  <code>post_content</code> longtext,
  <code>event_rsvp</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>event_rsvp_date</code> date DEFAULT NULL,
  <code>event_rsvp_time</code> time DEFAULT NULL,
  <code>event_rsvp_spaces</code> int(5) DEFAULT NULL,
  <code>event_spaces</code> int(5) DEFAULT '0',
  <code>event_private</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>location_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>recurrence_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_category_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_attributes</code> text,
  <code>event_date_created</code> datetime DEFAULT NULL,
  <code>event_date_modified</code> datetime DEFAULT NULL,
  <code>recurrence</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>recurrence_interval</code> int(4) DEFAULT NULL,
  <code>recurrence_freq</code> tinytext,
  <code>recurrence_byday</code> tinytext,
  <code>recurrence_byweekno</code> int(4) DEFAULT NULL,
  <code>recurrence_days</code> int(4) DEFAULT NULL,
  <code>blog_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>group_id</code> bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (<code>event_id</code>),
  KEY <code>event_status</code> (<code>event_status</code>),
  KEY <code>post_id</code> (<code>post_id</code>),
  KEY <code>blog_id</code> (<code>blog_id</code>),
  KEY <code>group_id</code> (<code>group_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_locations</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_locations</code> (
  <code>location_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_id</code> bigint(20) unsigned NOT NULL,
  <code>blog_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>location_slug</code> varchar(200) DEFAULT NULL,
  <code>location_name</code> text,
  <code>location_owner</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>location_address</code> varchar(200) DEFAULT NULL,
  <code>location_town</code> varchar(200) DEFAULT NULL,
  <code>location_state</code> varchar(200) DEFAULT NULL,
  <code>location_postcode</code> varchar(10) DEFAULT NULL,
  <code>location_region</code> varchar(200) DEFAULT NULL,
  <code>location_country</code> char(2) DEFAULT NULL,
  <code>location_latitude</code> float(10,6) DEFAULT NULL,
  <code>location_longitude</code> float(10,6) DEFAULT NULL,
  <code>post_content</code> longtext,
  <code>location_status</code> int(1) DEFAULT NULL,
  <code>location_private</code> tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>location_id</code>),
  KEY <code>location_state</code> (<code>location_state</code>),
  KEY <code>location_region</code> (<code>location_region</code>),
  KEY <code>location_country</code> (<code>location_country</code>),
  KEY <code>post_id</code> (<code>post_id</code>),
  KEY <code>blog_id</code> (<code>blog_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_meta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_meta</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>object_id</code> bigint(20) unsigned NOT NULL,
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  <code>meta_date</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (<code>meta_id</code>),
  KEY <code>object_id</code> (<code>object_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_tickets</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_tickets</code> (
  <code>ticket_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>event_id</code> bigint(20) unsigned NOT NULL,
  <code>ticket_name</code> tinytext NOT NULL,
  <code>ticket_description</code> text,
  <code>ticket_price</code> decimal(10,2) DEFAULT NULL,
  <code>ticket_start</code> datetime DEFAULT NULL,
  <code>ticket_end</code> datetime DEFAULT NULL,
  <code>ticket_min</code> int(10) DEFAULT NULL,
  <code>ticket_max</code> int(10) DEFAULT NULL,
  <code>ticket_spaces</code> int(11) DEFAULT NULL,
  <code>ticket_members</code> int(1) DEFAULT NULL,
  <code>ticket_members_roles</code> longtext,
  <code>ticket_guests</code> int(1) DEFAULT NULL,
  <code>ticket_required</code> int(1) DEFAULT NULL,
  PRIMARY KEY (<code>ticket_id</code>),
  KEY <code>event_id</code> (<code>event_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_em_tickets_bookings</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_em_tickets_bookings</code> (
  <code>ticket_booking_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>booking_id</code> bigint(20) unsigned NOT NULL,
  <code>ticket_id</code> bigint(20) unsigned NOT NULL,
  <code>ticket_booking_spaces</code> int(6) NOT NULL,
  <code>ticket_booking_price</code> decimal(10,2) NOT NULL,
  PRIMARY KEY (<code>ticket_booking_id</code>),
  KEY <code>booking_id</code> (<code>booking_id</code>),
  KEY <code>ticket_id</code> (<code>ticket_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_links</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_links</code> (
  <code>link_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>link_url</code> varchar(255) NOT NULL DEFAULT '',
  <code>link_name</code> varchar(255) NOT NULL DEFAULT '',
  <code>link_image</code> varchar(255) NOT NULL DEFAULT '',
  <code>link_target</code> varchar(25) NOT NULL DEFAULT '',
  <code>link_description</code> varchar(255) NOT NULL DEFAULT '',
  <code>link_visible</code> varchar(20) NOT NULL DEFAULT 'Y',
  <code>link_owner</code> bigint(20) unsigned NOT NULL DEFAULT '1',
  <code>link_rating</code> int(11) NOT NULL DEFAULT '0',
  <code>link_updated</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>link_rel</code> varchar(255) NOT NULL DEFAULT '',
  <code>link_notes</code> mediumtext NOT NULL,
  <code>link_rss</code> varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (<code>link_id</code>),
  KEY <code>link_visible</code> (<code>link_visible</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_options</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_options</code> (
  <code>option_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>option_name</code> varchar(64) NOT NULL DEFAULT '',
  <code>option_value</code> longtext NOT NULL,
  <code>autoload</code> varchar(20) NOT NULL DEFAULT 'yes',
  PRIMARY KEY (<code>option_id</code>),
  UNIQUE KEY <code>option_name</code> (<code>option_name</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=654 ;

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

--
-- Table structure for table <code>wp_2_postmeta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_postmeta</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>meta_id</code>),
  KEY <code>post_id</code> (<code>post_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=106 ;

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

--
-- Table structure for table <code>wp_2_posts</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_posts</code> (
  <code>ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_author</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>post_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>post_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>post_content</code> longtext NOT NULL,
  <code>post_title</code> text NOT NULL,
  <code>post_excerpt</code> text NOT NULL,
  <code>post_status</code> varchar(20) NOT NULL DEFAULT 'publish',
  <code>comment_status</code> varchar(20) NOT NULL DEFAULT 'open',
  <code>ping_status</code> varchar(20) NOT NULL DEFAULT 'open',
  <code>post_password</code> varchar(20) NOT NULL DEFAULT '',
  <code>post_name</code> varchar(200) NOT NULL DEFAULT '',
  <code>to_ping</code> text NOT NULL,
  <code>pinged</code> text NOT NULL,
  <code>post_modified</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>post_modified_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>post_content_filtered</code> longtext NOT NULL,
  <code>post_parent</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>guid</code> varchar(255) NOT NULL DEFAULT '',
  <code>menu_order</code> int(11) NOT NULL DEFAULT '0',
  <code>post_type</code> varchar(20) NOT NULL DEFAULT 'post',
  <code>post_mime_type</code> varchar(100) NOT NULL DEFAULT '',
  <code>comment_count</code> bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>ID</code>),
  KEY <code>post_name</code> (<code>post_name</code>),
  KEY <code>type_status_date</code> (<code>post_type</code>,<code>post_status</code>,<code>post_date</code>,<code>ID</code>),
  KEY <code>post_parent</code> (<code>post_parent</code>),
  KEY <code>post_author</code> (<code>post_author</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

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

--
-- Table structure for table <code>wp_2_terms</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_terms</code> (
  <code>term_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>name</code> varchar(200) NOT NULL DEFAULT '',
  <code>slug</code> varchar(200) NOT NULL DEFAULT '',
  <code>term_group</code> bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>term_id</code>),
  UNIQUE KEY <code>slug</code> (<code>slug</code>),
  KEY <code>name</code> (<code>name</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table <code>wp_2_term_relationships</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_term_relationships</code> (
  <code>object_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>term_taxonomy_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>term_order</code> int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>object_id</code>,<code>term_taxonomy_id</code>),
  KEY <code>term_taxonomy_id</code> (<code>term_taxonomy_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_2_term_taxonomy</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_term_taxonomy</code> (
  <code>term_taxonomy_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>term_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>taxonomy</code> varchar(32) NOT NULL DEFAULT '',
  <code>description</code> longtext NOT NULL,
  <code>parent</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>count</code> bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>term_taxonomy_id</code>),
  UNIQUE KEY <code>term_id_taxonomy</code> (<code>term_id</code>,<code>taxonomy</code>),
  KEY <code>taxonomy</code> (<code>taxonomy</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table <code>wp_2_wpuf_customfields</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_wpuf_customfields</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>field</code> varchar(30) NOT NULL,
  <code>type</code> varchar(20) NOT NULL,
  <code>values</code> text NOT NULL,
  <code>label</code> varchar(200) NOT NULL,
  <code>desc</code> varchar(200) NOT NULL,
  <code>required</code> varchar(5) NOT NULL,
  <code>region</code> varchar(20) NOT NULL DEFAULT 'top',
  <code>order</code> int(1) NOT NULL,
  PRIMARY KEY (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_wpuf_subscription</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_wpuf_subscription</code> (
  <code>id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>name</code> varchar(255) NOT NULL,
  <code>description</code> text NOT NULL,
  <code>count</code> int(5) DEFAULT '0',
  <code>duration</code> int(5) NOT NULL DEFAULT '0',
  <code>cost</code> float NOT NULL DEFAULT '0',
  <code>created</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_2_wpuf_transaction</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_2_wpuf_transaction</code> (
  <code>id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>user_id</code> bigint(20) DEFAULT NULL,
  <code>status</code> varchar(255) NOT NULL DEFAULT 'pending_payment',
  <code>cost</code> varchar(255) DEFAULT '',
  <code>post_id</code> bigint(20) DEFAULT NULL,
  <code>pack_id</code> bigint(20) DEFAULT NULL,
  <code>payer_first_name</code> longtext,
  <code>payer_last_name</code> longtext,
  <code>payer_email</code> longtext,
  <code>payment_type</code> longtext,
  <code>payer_address</code> longtext,
  <code>transaction_id</code> longtext,
  <code>created</code> datetime NOT NULL,
  PRIMARY KEY (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_blogs</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_blogs</code> (
  <code>blog_id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>site_id</code> bigint(20) NOT NULL DEFAULT '0',
  <code>domain</code> varchar(200) NOT NULL DEFAULT '',
  <code>path</code> varchar(100) NOT NULL DEFAULT '',
  <code>registered</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>last_updated</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>public</code> tinyint(2) NOT NULL DEFAULT '1',
  <code>archived</code> tinyint(2) NOT NULL DEFAULT '0',
  <code>mature</code> tinyint(2) NOT NULL DEFAULT '0',
  <code>spam</code> tinyint(2) NOT NULL DEFAULT '0',
  <code>deleted</code> tinyint(2) NOT NULL DEFAULT '0',
  <code>lang_id</code> int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>blog_id</code>),
  KEY <code>domain</code> (<code>domain</code>(50),<code>path</code>(5)),
  KEY <code>lang_id</code> (<code>lang_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table <code>wp_blog_versions</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_blog_versions</code> (
  <code>blog_id</code> bigint(20) NOT NULL DEFAULT '0',
  <code>db_version</code> varchar(20) NOT NULL DEFAULT '',
  <code>last_updated</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (<code>blog_id</code>),
  KEY <code>db_version</code> (<code>db_version</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_bp_activity</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_activity</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>user_id</code> bigint(20) NOT NULL,
  <code>component</code> varchar(75) NOT NULL,
  <code>type</code> varchar(75) NOT NULL,
  <code>action</code> text NOT NULL,
  <code>content</code> longtext NOT NULL,
  <code>primary_link</code> varchar(255) NOT NULL,
  <code>item_id</code> bigint(20) NOT NULL,
  <code>secondary_item_id</code> bigint(20) DEFAULT NULL,
  <code>date_recorded</code> datetime NOT NULL,
  <code>hide_sitewide</code> tinyint(1) DEFAULT '0',
  <code>mptt_left</code> int(11) NOT NULL DEFAULT '0',
  <code>mptt_right</code> int(11) NOT NULL DEFAULT '0',
  <code>is_spam</code> tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>id</code>),
  KEY <code>date_recorded</code> (<code>date_recorded</code>),
  KEY <code>user_id</code> (<code>user_id</code>),
  KEY <code>item_id</code> (<code>item_id</code>),
  KEY <code>secondary_item_id</code> (<code>secondary_item_id</code>),
  KEY <code>component</code> (<code>component</code>),
  KEY <code>type</code> (<code>type</code>),
  KEY <code>mptt_left</code> (<code>mptt_left</code>),
  KEY <code>mptt_right</code> (<code>mptt_right</code>),
  KEY <code>hide_sitewide</code> (<code>hide_sitewide</code>),
  KEY <code>is_spam</code> (<code>is_spam</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table <code>wp_bp_activity_meta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_activity_meta</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>activity_id</code> bigint(20) NOT NULL,
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>id</code>),
  KEY <code>activity_id</code> (<code>activity_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_bp_notifications</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_notifications</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>user_id</code> bigint(20) NOT NULL,
  <code>item_id</code> bigint(20) NOT NULL,
  <code>secondary_item_id</code> bigint(20) DEFAULT NULL,
  <code>component_name</code> varchar(75) NOT NULL,
  <code>component_action</code> varchar(75) NOT NULL,
  <code>date_notified</code> datetime NOT NULL,
  <code>is_new</code> tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>id</code>),
  KEY <code>item_id</code> (<code>item_id</code>),
  KEY <code>secondary_item_id</code> (<code>secondary_item_id</code>),
  KEY <code>user_id</code> (<code>user_id</code>),
  KEY <code>is_new</code> (<code>is_new</code>),
  KEY <code>component_name</code> (<code>component_name</code>),
  KEY <code>component_action</code> (<code>component_action</code>),
  KEY <code>useritem</code> (<code>user_id</code>,<code>is_new</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_bp_user_blogs</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_user_blogs</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>user_id</code> bigint(20) NOT NULL,
  <code>blog_id</code> bigint(20) NOT NULL,
  PRIMARY KEY (<code>id</code>),
  KEY <code>user_id</code> (<code>user_id</code>),
  KEY <code>blog_id</code> (<code>blog_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table <code>wp_bp_user_blogs_blogmeta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_user_blogs_blogmeta</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>blog_id</code> bigint(20) NOT NULL,
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>id</code>),
  KEY <code>blog_id</code> (<code>blog_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

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

--
-- Table structure for table <code>wp_bp_xprofile_data</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_xprofile_data</code> (
  <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>field_id</code> bigint(20) unsigned NOT NULL,
  <code>user_id</code> bigint(20) unsigned NOT NULL,
  <code>value</code> longtext NOT NULL,
  <code>last_updated</code> datetime NOT NULL,
  PRIMARY KEY (<code>id</code>),
  KEY <code>field_id</code> (<code>field_id</code>),
  KEY <code>user_id</code> (<code>user_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_bp_xprofile_fields</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_xprofile_fields</code> (
  <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>group_id</code> bigint(20) unsigned NOT NULL,
  <code>parent_id</code> bigint(20) unsigned NOT NULL,
  <code>type</code> varchar(150) NOT NULL,
  <code>name</code> varchar(150) NOT NULL,
  <code>description</code> longtext NOT NULL,
  <code>is_required</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>is_default_option</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>field_order</code> bigint(20) NOT NULL DEFAULT '0',
  <code>option_order</code> bigint(20) NOT NULL DEFAULT '0',
  <code>order_by</code> varchar(15) NOT NULL DEFAULT '',
  <code>can_delete</code> tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (<code>id</code>),
  KEY <code>group_id</code> (<code>group_id</code>),
  KEY <code>parent_id</code> (<code>parent_id</code>),
  KEY <code>field_order</code> (<code>field_order</code>),
  KEY <code>can_delete</code> (<code>can_delete</code>),
  KEY <code>is_required</code> (<code>is_required</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_bp_xprofile_groups</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_xprofile_groups</code> (
  <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>name</code> varchar(150) NOT NULL,
  <code>description</code> mediumtext NOT NULL,
  <code>group_order</code> bigint(20) NOT NULL DEFAULT '0',
  <code>can_delete</code> tinyint(1) NOT NULL,
  PRIMARY KEY (<code>id</code>),
  KEY <code>can_delete</code> (<code>can_delete</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_bp_xprofile_meta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_bp_xprofile_meta</code> (
  <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
  <code>object_id</code> bigint(20) NOT NULL,
  <code>object_type</code> varchar(150) NOT NULL,
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>id</code>),
  KEY <code>object_id</code> (<code>object_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_commentmeta</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_commentmeta</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>comment_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>meta_id</code>),
  KEY <code>comment_id</code> (<code>comment_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_comments</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_comments</code> (
  <code>comment_ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>comment_post_ID</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>comment_author</code> tinytext NOT NULL,
  <code>comment_author_email</code> varchar(100) NOT NULL DEFAULT '',
  <code>comment_author_url</code> varchar(200) NOT NULL DEFAULT '',
  <code>comment_author_IP</code> varchar(100) NOT NULL DEFAULT '',
  <code>comment_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>comment_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>comment_content</code> text NOT NULL,
  <code>comment_karma</code> int(11) NOT NULL DEFAULT '0',
  <code>comment_approved</code> varchar(20) NOT NULL DEFAULT '1',
  <code>comment_agent</code> varchar(255) NOT NULL DEFAULT '',
  <code>comment_type</code> varchar(20) NOT NULL DEFAULT '',
  <code>comment_parent</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>user_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (<code>comment_ID</code>),
  KEY <code>comment_post_ID</code> (<code>comment_post_ID</code>),
  KEY <code>comment_approved_date_gmt</code> (<code>comment_approved</code>,<code>comment_date_gmt</code>),
  KEY <code>comment_date_gmt</code> (<code>comment_date_gmt</code>),
  KEY <code>comment_parent</code> (<code>comment_parent</code>),
  KEY <code>comment_author_email</code> (<code>comment_author_email</code>(10))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_eme_answers</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_answers</code> (
  <code>booking_id</code> mediumint(9) NOT NULL,
  <code>field_name</code> tinytext NOT NULL,
  <code>answer</code> text NOT NULL,
  KEY <code>booking_id</code> (<code>booking_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_eme_bookings</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_bookings</code> (
  <code>booking_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>event_id</code> mediumint(9) NOT NULL,
  <code>person_id</code> mediumint(9) NOT NULL,
  <code>booking_seats</code> mediumint(9) NOT NULL,
  <code>booking_seats_mp</code> varchar(250) DEFAULT NULL,
  <code>booking_approved</code> tinyint(1) DEFAULT '0',
  <code>booking_comment</code> text,
  <code>booking_price</code> text,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>booking_payed</code> tinyint(1) DEFAULT '0',
  <code>transfer_nbr_be97</code> varchar(20) DEFAULT NULL,
  <code>wp_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>lang</code> varchar(10) DEFAULT '',
  UNIQUE KEY <code>booking_id</code> (<code>booking_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_categories</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_categories</code> (
  <code>category_id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>category_name</code> tinytext NOT NULL,
  UNIQUE KEY <code>category_id</code> (<code>category_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_events</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_events</code> (
  <code>event_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>event_status</code> mediumint(9) DEFAULT '1',
  <code>event_name</code> text,
  <code>event_slug</code> text,
  <code>event_url</code> text,
  <code>event_start_time</code> time NOT NULL,
  <code>event_end_time</code> time NOT NULL,
  <code>event_start_date</code> date NOT NULL,
  <code>event_end_date</code> date DEFAULT NULL,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>event_notes</code> longtext,
  <code>event_rsvp</code> tinyint(1) DEFAULT '0',
  <code>use_paypal</code> tinyint(1) DEFAULT '0',
  <code>use_google</code> tinyint(1) DEFAULT '0',
  <code>use_2co</code> tinyint(1) DEFAULT '0',
  <code>use_webmoney</code> tinyint(1) DEFAULT '0',
  <code>use_fdgg</code> tinyint(1) DEFAULT '0',
  <code>price</code> text,
  <code>currency</code> text,
  <code>rsvp_number_days</code> tinyint(3) unsigned DEFAULT '0',
  <code>rsvp_number_hours</code> tinyint(3) unsigned DEFAULT '0',
  <code>event_seats</code> text,
  <code>event_contactperson_id</code> mediumint(9) DEFAULT '0',
  <code>location_id</code> mediumint(9) DEFAULT '0',
  <code>recurrence_id</code> mediumint(9) DEFAULT '0',
  <code>event_category_ids</code> text,
  <code>event_attributes</code> text,
  <code>event_properties</code> text,
  <code>event_page_title_format</code> text,
  <code>event_single_event_format</code> text,
  <code>event_contactperson_email_body</code> text,
  <code>event_respondent_email_body</code> text,
  <code>event_registration_recorded_ok_html</code> text,
  <code>event_registration_pending_email_body</code> text,
  <code>event_registration_updated_email_body</code> text,
  <code>event_registration_form_format</code> text,
  <code>event_cancel_form_format</code> text,
  <code>registration_requires_approval</code> tinyint(1) DEFAULT '0',
  <code>registration_wp_users_only</code> tinyint(1) DEFAULT '0',
  <code>event_image_url</code> text,
  <code>event_image_id</code> mediumint(9) NOT NULL DEFAULT '0',
  <code>event_external_ref</code> text,
  UNIQUE KEY <code>event_id</code> (<code>event_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table <code>wp_eme_fieldtypes</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_fieldtypes</code> (
  <code>type_id</code> int(11) NOT NULL,
  <code>type_info</code> tinytext NOT NULL,
  <code>is_multi</code> int(1) DEFAULT '0',
  UNIQUE KEY <code>type_id</code> (<code>type_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table <code>wp_eme_formfields</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_formfields</code> (
  <code>field_id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>field_type</code> mediumint(9) NOT NULL,
  <code>field_name</code> tinytext NOT NULL,
  <code>field_info</code> text NOT NULL,
  <code>field_tags</code> text,
  UNIQUE KEY <code>field_id</code> (<code>field_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_locations</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_locations</code> (
  <code>location_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>location_name</code> text NOT NULL,
  <code>location_slug</code> text,
  <code>location_url</code> text,
  <code>location_address</code> tinytext NOT NULL,
  <code>location_town</code> tinytext NOT NULL,
  <code>location_latitude</code> float DEFAULT NULL,
  <code>location_longitude</code> float DEFAULT NULL,
  <code>location_description</code> text,
  <code>location_author</code> mediumint(9) DEFAULT '0',
  <code>location_category_ids</code> text,
  <code>location_creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>location_image_url</code> text,
  <code>location_image_id</code> mediumint(9) NOT NULL DEFAULT '0',
  <code>location_attributes</code> text,
  <code>location_properties</code> text,
  <code>location_external_ref</code> text,
  UNIQUE KEY <code>location_id</code> (<code>location_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

--
-- Table structure for table <code>wp_eme_payments</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_payments</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>booking_ids</code> text NOT NULL,
  UNIQUE KEY <code>id</code> (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_people</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_people</code> (
  <code>person_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>person_name</code> tinytext NOT NULL,
  <code>person_email</code> tinytext NOT NULL,
  <code>person_phone</code> tinytext,
  <code>wp_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>lang</code> varchar(10) DEFAULT '',
  UNIQUE KEY <code>person_id</code> (<code>person_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_recurrence</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_recurrence</code> (
  <code>recurrence_id</code> mediumint(9) NOT NULL AUTO_INCREMENT,
  <code>recurrence_start_date</code> date NOT NULL,
  <code>recurrence_end_date</code> date NOT NULL,
  <code>creation_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>creation_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>modif_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  <code>recurrence_interval</code> tinyint(4) NOT NULL,
  <code>recurrence_freq</code> tinytext NOT NULL,
  <code>recurrence_byday</code> tinytext NOT NULL,
  <code>recurrence_byweekno</code> tinyint(4) NOT NULL,
  <code>recurrence_specific_days</code> text,
  UNIQUE KEY <code>recurrence_id</code> (<code>recurrence_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_eme_templates</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_eme_templates</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>description</code> tinytext,
  <code>format</code> text NOT NULL,
  UNIQUE KEY <code>id</code> (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table <code>wp_em_bookings</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_em_bookings</code> (
  <code>booking_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>event_id</code> bigint(20) unsigned NOT NULL,
  <code>person_id</code> bigint(20) unsigned NOT NULL,
  <code>booking_spaces</code> int(5) NOT NULL,
  <code>booking_comment</code> text,
  <code>booking_date</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  <code>booking_status</code> tinyint(1) NOT NULL DEFAULT '1',
  <code>booking_price</code> decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  <code>booking_tax_rate</code> decimal(5,2) DEFAULT NULL,
  <code>booking_taxes</code> decimal(10,2) DEFAULT NULL,
  <code>booking_meta</code> longtext,
  PRIMARY KEY (<code>booking_id</code>),
  KEY <code>event_id</code> (<code>event_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_em_events</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_em_events</code> (
  <code>event_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_id</code> bigint(20) unsigned NOT NULL,
  <code>event_slug</code> varchar(200) DEFAULT NULL,
  <code>event_owner</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_status</code> int(1) DEFAULT NULL,
  <code>event_name</code> text,
  <code>event_start_time</code> time DEFAULT NULL,
  <code>event_end_time</code> time DEFAULT NULL,
  <code>event_all_day</code> int(1) DEFAULT NULL,
  <code>event_start_date</code> date DEFAULT NULL,
  <code>event_end_date</code> date DEFAULT NULL,
  <code>post_content</code> longtext,
  <code>event_rsvp</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>event_rsvp_date</code> date DEFAULT NULL,
  <code>event_rsvp_time</code> time DEFAULT NULL,
  <code>event_rsvp_spaces</code> int(5) DEFAULT NULL,
  <code>event_spaces</code> int(5) DEFAULT '0',
  <code>event_private</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>location_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>recurrence_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_category_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>event_attributes</code> text,
  <code>event_date_created</code> datetime DEFAULT NULL,
  <code>event_date_modified</code> datetime DEFAULT NULL,
  <code>recurrence</code> tinyint(1) NOT NULL DEFAULT '0',
  <code>recurrence_interval</code> int(4) DEFAULT NULL,
  <code>recurrence_freq</code> tinytext,
  <code>recurrence_byday</code> tinytext,
  <code>recurrence_byweekno</code> int(4) DEFAULT NULL,
  <code>recurrence_days</code> int(4) DEFAULT NULL,
  <code>blog_id</code> bigint(20) unsigned DEFAULT NULL,
  <code>group_id</code> bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (<code>event_id</code>),
  KEY <code>event_status</code> (<code>event_status</code>),
  KEY <code>post_id</code> (<code>post_id</code>),
  KEY <code>blog_id</code> (<code>blog_id</code>),
  KEY <code>group_id</code> (<code>group_id</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table <code>wp_em_locations</code>
--

CREATE TABLE IF NOT EXISTS <code>wp_em_locations</code> (
  <code>location_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>post_id</code> bigint(20) unsigned NOT NULL,
  <code>blog_id</code> bigint(20) unsigned DEFAULT NULL,
  <code

Forum: Plugins
In reply to: [Events Made Easy] Database insert failed!

Thread Starter nat@cry

(@natcry)

10 years, 5 months ago

Ok . . . I’ll try not done this before. i assume its in the phpadmin bit.
Will let you know how it goes.
Thanks

Forum: Plugins
In reply to: [Events Made Easy] Database insert failed!

Thread Starter nat@cry

(@natcry)

10 years, 5 months ago

Hi Franky

Thanks for the quick response.
I have all the correct administrative rights to create alter and delete tables.

Funny but if i edit the 3 demo events they update fine.

Is there a way to manual create or amend the db tables?

Thanks

Forum: Plugins
In reply to: [WC - APG Weight Shipping] Not Working with Latest WP?

nat@cry

(@natcry)

10 years, 5 months ago

Hi I am having the same error after updating to the latest version of Woocommerce.

How do i resolve this?

Thanks

Forum: Plugins
In reply to: [Checkout Field Manager (Checkout Manager) for WooCommerce] 'Unable to create order' Error

nat@cry

(@natcry)

10 years, 5 months ago

@cyhcqcys how did you fix this error?

Thanks

Forum: Plugins
In reply to: [Events Manager - Calendar, Bookings, Tickets, and more!] Order the events list into a custom order

Thread Starter nat@cry

(@natcry)

10 years, 10 months ago

Oww could you point me in the right area to do this and I might have a go at it. Please

Forum: Fixing WordPress
In reply to: problems since the 3.9 update

nat@cry

(@natcry)

10 years, 11 months ago

I have found that you need to download a copy of wordpress 3.9 and then copy across the wp-settings.php file from that to replace your websites copy and that should work.

It might also have something to do with increasing your php memory from 40MB

Forum: Plugins
In reply to: [User Submitted Posts – Enable Users to Submit Posts from the Front End] Ask for email

Thread Starter nat@cry

(@natcry)

11 years, 1 month ago

Thanks!

Forum: Plugins
In reply to: [User Submitted Posts – Enable Users to Submit Posts from the Front End] Ask for email

Thread Starter nat@cry

(@natcry)

11 years, 1 month ago

Okie dokie . . . I fear this might be above my skill level . . . any pointers please.

Maybe with a little pointing I might be able to do this . . .

Thanks Jeff Starr you are a STAR!

Viewing 15 replies - 1 through 15 (of 28 total)

1 2 →