gistfile1.sql

CREATE TABLE `demographic_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gender` int(11) NOT NULL DEFAULT '0',
  `country` int(11) NOT NULL DEFAULT '0',
  `expertise` int(11) NOT NULL DEFAULT '0',
  `operating_system` int(11) NOT NULL DEFAULT '0',
  `gaming_genre` int(11) NOT NULL DEFAULT '0',
  `social_network` int(11) NOT NULL DEFAULT '0',
  `web_browser` int(11) NOT NULL DEFAULT '0',
  `min_income` int(11) DEFAULT NULL,
  `max_income` int(11) DEFAULT NULL,
  `min_age` int(11) DEFAULT NULL,
  `max_age` int(11) DEFAULT NULL,
  `birth_year` int(11) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  `form_factor` int(11) NOT NULL DEFAULT '0',
  `other_requirement` text COLLATE utf8mb4_unicode_ci,
  `states` bigint(20) NOT NULL DEFAULT '0',
  `language` bigint(20) NOT NULL DEFAULT '0',
  `employment_status` bigint(20) NOT NULL DEFAULT '0',
  `industry` json DEFAULT NULL,
  `job_function` bigint(20) NOT NULL DEFAULT '0',
  `seniority` bigint(20) NOT NULL DEFAULT '0',
  `company_size` bigint(20) NOT NULL DEFAULT '0',
  `children_present` tinyint(1) DEFAULT NULL,
  `children` json DEFAULT NULL,
  `ipevo_webcam_tester` tinyint(1) NOT NULL DEFAULT '0',
  `recording_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
)

CREATE TABLE `tester_devices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tester_user_id` int(11) NOT NULL,
  `device_id` int(11) NOT NULL
)

CREATE TABLE `devices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `form_factor` int(11) NOT NULL,
  `operating_system` int(11) NOT NULL,
  `sprite_identifier` varchar(255) CHARACTER SET utf8 NOT NULL
)

CREATE TABLE `tester_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `paypal_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `daily_web_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `found_through` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `sample_session_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `demographic_group_id` int(11) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `score_override` int(11) DEFAULT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  `raw_score` float DEFAULT NULL,
  `exclusive_bonus` decimal(12,2) DEFAULT NULL,
  `udid_ipod` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `udid_ipad` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `udid_iphone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_seen_user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `geoip_country` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `preferred_timezone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender_details` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unpaid` tinyint(1) NOT NULL DEFAULT '0',
  `demographics_tracked` tinyint(1) NOT NULL DEFAULT '0'
)

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `encrypted_password` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `reset_password_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `reset_password_sent_at` datetime DEFAULT NULL,
  `remember_created_at` datetime DEFAULT NULL,
  `sign_in_count` int(11) DEFAULT '0',
  `current_sign_in_at` datetime DEFAULT NULL,
  `last_sign_in_at` datetime DEFAULT NULL,
  `current_sign_in_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_sign_in_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `one_time_sign_in_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `current_account_id` int(11) DEFAULT NULL,
  `roles` int(11) DEFAULT '0',
  `quantcast_rating_id` int(11) DEFAULT NULL,
  `settings` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `flags` int(11) NOT NULL DEFAULT '0',
  `failed_attempts` int(11) DEFAULT '0',
  `unlock_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `locked_at` datetime DEFAULT NULL,
  `blocked` tinyint(1) DEFAULT '0',
  `salesperson` tinyint(1) DEFAULT '0',
  `account_manager` tinyint(1) DEFAULT '0',
  `session_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
)