CREATE TABLE wp_PO_groups (
group_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
group_name varchar(255) NOT NULL default '',
group_members longtext NOT NULL,
PRIMARY KEY PO_group_id (group_id));
CREATE TABLE wp_PO_post_plugins (
post_id bigint(20) unsigned NOT NULL,
permalink longtext NOT NULL,
disabled_plugins longtext NOT NULL,
enabled_plugins longtext NOT NULL,
PRIMARY KEY PO_post_id (post_id));
CREATE TABLE wp_PO_url_plugins (
url_id bigint(20) unsigned NOT NULL auto_increment,
permalink longtext NOT NULL,
children int(1) NOT NULL default 0,
disabled_plugins longtext NOT NULL,
enabled_plugins longtext NOT NULL,
PRIMARY KEY PO_id (url_id));
Try that. I had an error in my sql statements.
thanks Jeff– now I get:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE wp_PO_post_plugins ( post_id bigint(20) unsigned NOT NULL, permal' at line 7