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

CREATE TABLE `wpsc_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=74617 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

insert wpsc_posts(ID, post_content, post_title, post_excerpt, post_status, to_ping, pinged, post_type)
select seq, rand()*300 + 13, rand()*13+seq, rand()*300, 'publish', rand()*300, rand()*300, 'actors' from seq_1_to_7500;
insert wpsc_posts(ID, post_content, post_title, post_excerpt, post_status, to_ping, pinged, post_type)
select seq, rand()*300 + 13, rand()*13+seq, rand()*300, 'publish', rand()*300, rand()*300, 'actors' from seq_7501_to_15000;


insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'gender', 'Female' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'gender', 'Male' from seq_10001_to_15000;

insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'age', '28-30' from seq_1_to_2000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'age', '28' from seq_2001_to_3000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'age', '29' from seq_3001_to_4000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'age', '30' from seq_4001_to_5000;

insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'age', '30' from seq_4000_to_5000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'actor_ethnicity', 'Maltese' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'complexion', 'Fair Freckles' from seq_1_to_10000;

insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'natural_accent', 'Maltese' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'actor_height', '60-70' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'chest', '813' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'waist', '6' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'hip', '191' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'eye_colour', 'Cyan' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'hair_colour', 'Pink' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'male_clothing_size', 'M' from seq_1_to_10000;
insert wpsc_postmeta(post_id, meta_key, meta_value)
select seq, 'female_clothing_size', '88' from seq_1_to_10000;
