Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement