QQUCLKcV

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Gazda: 127.0.0.1
6-- Timp de generare: 17 Noi 2016 la 16:10
7-- Versiune server: 5.5.50-0ubuntu0.14.04.1
8-- Versiune PHP: 5.5.9-1ubuntu4.19
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Bază de date: `smart_blog`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Structura de tabel pentru tabelul `article`
21--
22
23DROP TABLE IF EXISTS `article`;
24CREATE TABLE IF NOT EXISTS `article` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `user_id` int(11) NOT NULL,
27  `title` varchar(255) NOT NULL,
28  `description` varchar(255) NOT NULL,
29  `date_created` date NOT NULL,
30  `date_published` date DEFAULT NULL,
31  `date_updated` int(11) DEFAULT NULL,
32  `status` enum('draft','published') NOT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;