TGkCNPff

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Dinero MySQL
5Source Server Version : 50505
6Source Host           : localhost:3306
7Source Database       : dinero
8
9Target Server Type    : MYSQL
10Target Server Version : 50505
11File Encoding         : 65001
12
13Date: 2021-08-24 16:02:49
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `shops`
20-- ----------------------------
21DROP TABLE IF EXISTS `shops`;
22CREATE TABLE `shops` (
23  `id` int(11) NOT NULL,
24  `name` varchar(100) NOT NULL,
25  `display` varchar(100) NOT NULL,
26  `type` varchar(100) NOT NULL,
27  `price` int(11) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31-- ----------------------------
32-- Records of shops
33-- ----------------------------
34INSERT INTO `shops` VALUES ('1', 'clip', 'Magazin', 'item', '2000');
35INSERT INTO `shops` VALUES ('3', 'phone', 'Handy', 'item', '1250');
36INSERT INTO `shops` VALUES ('5', 'medikit', 'Medkit', 'item', '900');
37INSERT INTO `shops` VALUES ('6', 'kabelbinder', 'Seile', 'item', '500');