Zk4rMZ0P

1-- phpMyAdmin SQL Dump
2-- version 4.4.10
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 18, 2018 at 12:54 AM
7-- Server version: 10.0.30-MariaDB-0+deb8u2
8-- PHP Version: 5.6.30-0+deb8u1
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: `daw_projecto`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `orders`
27--
28
29CREATE TABLE IF NOT EXISTS `orders` (
30  `id` int(10) unsigned NOT NULL,
31  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
32  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
33  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
34  `zipcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
35  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
36  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
37  `order_state` enum('PAGO','ENVIADO','POR PAGAR','EM PROCESSAMENTO') COLLATE utf8mb4_unicode_ci NOT NULL,
38  `creation_date` date NOT NULL,
39  `dispatch_date` date DEFAULT NULL,
40  `created_at` timestamp NULL DEFAULT NULL,
41  `updated_at` timestamp NULL DEFAULT NULL
42) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
43
44--
45-- Dumping data for table `orders`
46--
47
48INSERT INTO `orders` (`id`, `first_name`, `last_name`, `address`, `zipcode`, `country`, `location`, `order_state`, `creation_date`, `dispatch_date`, `created_at`, `updated_at`) VALUES
49(1, 'Manuel', 'Jacinto', 'Rua das Andorinhas, 9', '7860', 'Portugal', 'Moura', 'PAGO', '2018-01-30', NULL, NULL, NULL),
50(2, 'Vasco', 'Flores', 'Av Bombeiros', '7860', 'Portugal', 'Moura', 'PAGO', '2018-01-30', NULL, '2018-01-30 12:33:53', '2018-01-30 12:33:53');
51
52--
53-- Indexes for dumped tables
54--
55
56--
57-- Indexes for table `orders`
58--
59ALTER TABLE `orders`
60  ADD PRIMARY KEY (`id`);
61
62--
63-- AUTO_INCREMENT for dumped tables
64--
65
66--
67-- AUTO_INCREMENT for table `orders`
68--
69ALTER TABLE `orders`
70  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
71/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
72/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
73/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;