View difference between Paste ID: MEG4t6YX and 1ByVrPdQ
SHOW: | | - or go back to the newest paste.
1
-- phpMyAdmin SQL Dump
2-
-- version 4.0.1
2+
-- version 4.0.5
3
-- http://www.phpmyadmin.net
4
--
5
-- Host: localhost
6-
-- Generation Time: Dec 19, 2013 at 11:27 PM
6+
-- Generation Time: Dec 22, 2013 at 06:21 AM
7-
-- Server version: 5.1.62-0ubuntu0.10.04.1
7+
-- Server version: 5.1.71
8-
-- PHP Version: 5.4.15-1~lucid+1
8+
-- PHP Version: 5.3.3
9
10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11
SET time_zone = "+00:00";
12
13
--
14
-- Database: `open`
15
--
16
17
-- --------------------------------------------------------
18
19
--
20-
-- Table structure for table `cmt`
20+
21
--
22
23-
CREATE TABLE IF NOT EXISTS `cmt` (
23+
DROP TABLE IF EXISTS `users`;
24
CREATE TABLE IF NOT EXISTS `users` (
25-
  `uid` int(11) NOT NULL,
25+
26-
  `pid` int(11) NOT NULL,
26+
27-
  `cmt` text NOT NULL,
27+
28-
  `posted` varchar(30) NOT NULL,
28+
29-
  PRIMARY KEY (`id`),
29+
30-
  UNIQUE KEY `id` (`id`),
30+
31-
  UNIQUE KEY `posted` (`posted`),
31+
  PRIMARY KEY (`id`)
32-
  KEY `id_2` (`id`),
32+
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=158 ;