Rm6WPFEy

1-- phpMyAdmin SQL Dump
2-- version 4.5.4.1deb2ubuntu2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 21, 2018 at 04:10 PM
7-- Server version: 5.7.20-0ubuntu0.16.04.1
8-- PHP Version: 7.0.22-0ubuntu0.16.04.1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
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 utf8mb4 */;
18
19--
20-- Database: `dbms_vincenzo`
21--
22CREATE DATABASE IF NOT EXISTS `dbms_vincenzo` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `dbms_vincenzo`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `Company_Information`
29--
30
31CREATE TABLE `Company_Information` (
32  `CompanyName` varchar(250) NOT NULL,
33  `CompanyVatNumber` varchar(50) NOT NULL,
34  `VAT_percent` decimal(10,0) NOT NULL,
35  `IBAN` varchar(50) NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `Items`
42--
43
44CREATE TABLE `Items` (
45  `Item Number` varchar(50) NOT NULL,
46  `EAN13 Code` varchar(15) NOT NULL,
47  `Mkt Code` varchar(10) NOT NULL,
48  `Product Grouping` varchar(250) NOT NULL,
49  `Brand` varchar(250) NOT NULL,
50  `Name` varchar(250) NOT NULL,
51  `Stock Availability` decimal(10,0) NOT NULL,
52  `Cost` decimal(10,0) NOT NULL,
53  `Qty in order` decimal(10,0) NOT NULL,
54  `Arrival of the new ordered` decimal(10,0) NOT NULL,
55  `Arrival date of ordered Qty` date NOT NULL,
56  `Manufacturer suggested price` decimal(10,0) NOT NULL,
57  `Dropshipper suggested price` decimal(10,0) NOT NULL,
58  `Picture Link` varchar(250) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61-- --------------------------------------------------------
62
63--
64-- Table structure for table `Pricing_Rules`
65--
66
67CREATE TABLE `Pricing_Rules` (
68  `Percent_Margin` decimal(10,0) NOT NULL,
69  `Fixed_Costs` decimal(10,0) NOT NULL
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
72-- --------------------------------------------------------
73
74--
75-- Table structure for table `Setup table`
76--
77
78CREATE TABLE `Setup table` (
79  `ID` int(11) NOT NULL,
80  `FTP Connection Link` varchar(250) NOT NULL,
81  `FTP_Item_Folder` varchar(250) NOT NULL,
82  `FTP_Order_folder` varchar(250) NOT NULL,
83  `FTP Username` varchar(100) NOT NULL,
84  `FTP Password` varchar(100) NOT NULL,
85  `Ebay API Key` varchar(100) NOT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88--
89-- Indexes for dumped tables
90--
91
92--
93-- Indexes for table `Items`
94--
95ALTER TABLE `Items`
96  ADD PRIMARY KEY (`Item Number`);
97
98--
99-- Indexes for table `Setup table`
100--
101ALTER TABLE `Setup table`
102  ADD PRIMARY KEY (`ID`);
103
104--
105-- AUTO_INCREMENT for dumped tables
106--
107
108--
109-- AUTO_INCREMENT for table `Setup table`
110--
111ALTER TABLE `Setup table`
112  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
113/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
114/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
115/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;