Advertisement
viamvadens

Untitled

Nov 6th, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1.  
  2. CREATE TABLE `temp_123` (
  3. `bet_result` tinyint(4) NOT NULL,
  4. `id` int(10) UNSIGNED DEFAULT NULL,
  5. `vm_id` varchar(50) NOT NULL,
  6. `fork_id` int(10) UNSIGNED NOT NULL,
  7. `bet_type` varchar(25) NOT NULL,
  8. `bet_name` varchar(45) NOT NULL,
  9. `bk1_name` varchar(255) NOT NULL,
  10. `bk2_name` varchar(255) NOT NULL,
  11. `bk1_is_init` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  12. `bk2_is_init` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  13. `bk1_forks_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  14. `bk2_forks_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  15. `bk_league` varchar(1024) NOT NULL,
  16. `bk_game` varchar(255) NOT NULL,
  17. `added_at` datetime NOT NULL,
  18. `fork_income` float(8,2) DEFAULT NULL,
  19. `real_cf` float(6,3) UNSIGNED DEFAULT NULL,
  20. `in_event_count` int(10) UNSIGNED DEFAULT NULL,
  21. `api_score` float(10,2) DEFAULT NULL,
  22. `game_score` varchar(255) DEFAULT NULL,
  23. `real_cf_diff` float(5,4) DEFAULT NULL,
  24. `cfscount` int(10) UNSIGNED DEFAULT '0',
  25. `min_max_diff` float(8,2) DEFAULT NULL,
  26. `min2max2diff` float(8,2) DEFAULT NULL,
  27. `bkpos` float(8,2) DEFAULT NULL,
  28. `real_cf_bk_names` varchar(255) DEFAULT NULL,
  29. `period_num` int(4) DEFAULT NULL,
  30. `win_amount` float(8,2) DEFAULT NULL,
  31. `day_time` varchar(5) NOT NULL DEFAULT '',
  32. `week_day` int(4) NOT NULL DEFAULT '0',
  33. `goals_done` int(4) DEFAULT NULL,
  34. `games_done` int(4) DEFAULT NULL,
  35. `amount` float(8,2) DEFAULT NULL
  36. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
  37. 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