-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest.sql
More file actions
35 lines (28 loc) · 865 Bytes
/
test.sql
File metadata and controls
35 lines (28 loc) · 865 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
/*
Navicat MySQL Data Transfer
Source Server : Local_microservice
Source Server Version : 50716
Source Host : localhost
Source Database : test
Target Server Version : 50716
File Encoding : utf-8
Date: 07/08/2017 14:19:23 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `clients`
-- ----------------------------
DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
`id_client` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id_client`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `clients`
-- ----------------------------
BEGIN;
INSERT INTO `clients` VALUES ('1', 'Juan'), ('2', 'Pedro'), ('3', 'Jose'), ('4', 'Carlos');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;