Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `temp_123` (
- `bet_result` tinyint(4) NOT NULL,
- `id` int(10) UNSIGNED DEFAULT NULL,
- `vm_id` varchar(50) NOT NULL,
- `fork_id` int(10) UNSIGNED NOT NULL,
- `bet_type` varchar(25) NOT NULL,
- `bet_name` varchar(45) NOT NULL,
- `bk1_name` varchar(255) NOT NULL,
- `bk2_name` varchar(255) NOT NULL,
- `bk1_is_init` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `bk2_is_init` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `bk1_forks_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `bk2_forks_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
- `bk_league` varchar(1024) NOT NULL,
- `bk_game` varchar(255) NOT NULL,
- `added_at` datetime NOT NULL,
- `fork_income` float(8,2) DEFAULT NULL,
- `real_cf` float(6,3) UNSIGNED DEFAULT NULL,
- `in_event_count` int(10) UNSIGNED DEFAULT NULL,
- `api_score` float(10,2) DEFAULT NULL,
- `game_score` varchar(255) DEFAULT NULL,
- `real_cf_diff` float(5,4) DEFAULT NULL,
- `cfscount` int(10) UNSIGNED DEFAULT '0',
- `min_max_diff` float(8,2) DEFAULT NULL,
- `min2max2diff` float(8,2) DEFAULT NULL,
- `bkpos` float(8,2) DEFAULT NULL,
- `real_cf_bk_names` varchar(255) DEFAULT NULL,
- `period_num` int(4) DEFAULT NULL,
- `win_amount` float(8,2) DEFAULT NULL,
- `day_time` varchar(5) NOT NULL DEFAULT '',
- `week_day` int(4) NOT NULL DEFAULT '0',
- `goals_done` int(4) DEFAULT NULL,
- `games_done` int(4) DEFAULT NULL,
- `amount` float(8,2) DEFAULT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
- INSERT INTO `temp_123` (`bet_result`, `id`, `vm_id`, `fork_id`, `bet_type`, `bet_name`, `bk1_name`, `bk2_name`, `bk1_is_init`, `bk2_is_init`, `bk1_forks_count`, `bk2_forks_count`, `bk_league`, `bk_game`, `added_at`, `fork_income`, `real_cf`, `in_event_count`, `api_score`, `game_score`, `real_cf_diff`, `cfscount`, `min_max_diff`, `min2max2diff`, `bkpos`, `real_cf_bk_names`, `period_num`, `win_amount`, `day_time`, `week_day`, `goals_done`, `games_done`, `amount`) VALUE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement