Skip to content

Instantly share code, notes, and snippets.

@StasKoval
Created August 18, 2015 14:25
Show Gist options
  • Save StasKoval/0914f23d030db529792f to your computer and use it in GitHub Desktop.
Save StasKoval/0914f23d030db529792f to your computer and use it in GitHub Desktop.
CREATE TABLE `build_flows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`device_id` int(11) DEFAULT NULL,
`device_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`job_id` int(11) DEFAULT NULL,
`job_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`branch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`build_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pbt_sdk` tinyint(4) DEFAULT '0',
`pbt_opensource` tinyint(4) DEFAULT '0',
`pbt_qt` tinyint(4) DEFAULT '0',
`status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_build_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`dashboard_visible` tinyint(1) DEFAULT '0',
`grt_enabled` tinyint(1) DEFAULT '0',
`blacklisted` tinyint(1) DEFAULT '0',
`use_prebuilts` tinyint(1) DEFAULT '0',
`build_params` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`target_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`block_merge` tinyint(1) DEFAULT '0',
`blacklisted_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`grab_components_stats` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `flow_index` (`device_id`,`job_id`,`branch`,`build_type`,`pbt_sdk`,`pbt_opensource`,`pbt_qt`)
) ENGINE=InnoDB AUTO_INCREMENT=4888 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment