· 7 years ago · Feb 12, 2019, 11:04 AM
1-- MySqlBackup.NET 2.0.9.2
2-- Dump Time: 2019-02-07 09:22:47
3-- --------------------------------------
4-- Server version 8.0.14 MySQL Community Server - GPL
5
6--
7-- Create schema db_1
8--
9
10CREATE DATABASE IF NOT EXISTS `db_1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;
11Use `db_1`;
12
13
14-- Definition of tab_1
15DROP TABLE IF EXISTS `tab_1`;
16CREATE TABLE IF NOT EXISTS `tab_1` (
17 `ID` int(11) NOT NULL AUTO_INCREMENT,
18 `W_1` int(11) DEFAULT '0',
19 `W_2` int(11) DEFAULT '0',
20`Time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
21PRIMARY KEY (`ID`)
22) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
23
24--
25-- Dumping data for table tab_1
26--
27
28/*!40000 ALTER TABLE `tab_1` DISABLE KEYS */;
29INSERT INTO `tab_1`(`ID`,`W_1`,`W_2`) VALUES
30 (12,2,2),
31(13,3,3,),
32(14,4,4,);
33/*!40000 ALTER TABLE `tab_1` ENABLE KEYS */;
34
35
36-- Dump completed on 2019-02-07 09:22:48
37-- Total time: 0:0:0:0:136 (d:h:m:s:ms)