vhyP5ZkG

1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.5.55-0ubuntu0.14.04.1)
9# Database: cars
10# Generation Time: 2018-03-23 09:59:52 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table trucks
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `trucks`;
27
28CREATE TABLE `trucks` (
29  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30  `brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
31  `price` decimal(6,2) DEFAULT NULL,
32  `maxkg` int(11) DEFAULT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
35
36
37
38
39/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
40/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
41/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
42/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
43/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
44/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;