· 8 years ago · May 09, 2018, 05:10 PM
1# Dumping structure for table editz.to_import
2CREATE TABLE IF NOT EXISTS `to_import` (
3 `id` int(11) unsigned NOT NULL auto_increment,
4 `reference` int(11) unsigned NOT NULL,
5 `trackid` int(11) unsigned NOT NULL,
6 `side_pos1` char(2) NOT NULL,
7 `side1` varchar(255) NOT NULL,
8 `pos1` char(2) NOT NULL,
9 `hh1` char(2) NOT NULL,
10 `mm1` char(2) NOT NULL,
11 `ss1` char(2) NOT NULL,
12 `atl1` varchar(255) NOT NULL,
13 `side_pos2` char(2) NOT NULL,
14 `side2` varchar(255) NOT NULL,
15 `pos2` char(2) NOT NULL,
16 `hh2` char(2) NOT NULL,
17 `mm2` char(2) NOT NULL,
18 `ss2` char(2) NOT NULL,
19 `atl2` varchar(255) NOT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=1311 DEFAULT CHARSET=utf8;
22
23# Dumping data for table editz.to_import: ~1.025 rows (approximately)
24DELETE FROM `to_import`;
25/*!40000 ALTER TABLE `to_import` DISABLE KEYS */;
26INSERT INTO `to_import` (`id`, `reference`, `trackid`, `side_pos1`, `side1`, `pos1`, `hh1`, `mm1`, `ss1`, `atl1`, `side_pos2`, `side2`, `pos2`, `hh2`, `mm2`, `ss2`, `atl2`) VALUES
27 (1, 205, 550, '0', 'Single Side', '0', '??', '??', '??', 'Noizefucker - Tons Of Bluesteel - Special Forces', '0', 'Single Side', '0', '??', '??', '??', 'Noizefucker - Tons Of Bluesteel - Special Forces'),
28 ... some lines, approx 1300)...
29 (1310, 268, 463, '#', '', '20', '00', '41', '00', 'Ingler - Trek', '#', '', '20', '00', '41', '00', 'Ingler - Trek');
30/*!40000 ALTER TABLE `to_import` ENABLE KEYS */;
31/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
32/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
33/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
34
35#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
36
37mysql> SELECT @@sql_mode;
38
39/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
40
41/*!40101 SET OLD_SQL_MODE=@SQL_MODE */;
42
43/*!40101 SET @saved_cs_client = @@character_set_client */;
44/*!40101 SET character_set_client = utf8 */;