3v70PDGj

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 10, 2019 at 07:29 AM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
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 utf8 */;
18
19--
20-- Database: `catering`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `categories`
27--
28
29CREATE TABLE IF NOT EXISTS `categories` (
30  `ID` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(100) NOT NULL,
32  `descriere` text NOT NULL,
33  `parent_id` int(11) NOT NULL,
34  `product_count` int(11) NOT NULL,
35  PRIMARY KEY (`ID`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `foods`
42--
43
44CREATE TABLE IF NOT EXISTS `foods` (
45  `ID` int(11) NOT NULL AUTO_INCREMENT,
46  `name` varchar(100) NOT NULL,
47  `descriere` text NOT NULL,
48  `date_last_updated` date NOT NULL,
49  `date_added` date NOT NULL,
50  `heated` tinyint(1) NOT NULL,
51  `cooled` tinyint(1) NOT NULL,
52  `category_id` int(11) NOT NULL,
53  `current_price` float NOT NULL,
54  `total_weight` int(11) NOT NULL,
55  `time_min` time NOT NULL,
56  `time_max` time NOT NULL,
57  `alcoholic` tinyint(1) NOT NULL,
58  `fasting_ok` tinyint(1) NOT NULL,
59  PRIMARY KEY (`ID`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
61
62/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
63/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
64/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;