All pastes #942065 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-03-14 05:45 UTC
rendered paste body
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 14, 2008 at 01:42 AM
-- Server version: 5.0.37
-- PHP Version: 5.2.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `facebook`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `naughtlist`
-- 

CREATE TABLE `naughtlist` (
  `id` int(11) NOT NULL auto_increment,
  `jobpic` text NOT NULL,
  `jobtext` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `naughtlist`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `naughtyjobs`
-- 

CREATE TABLE `naughtyjobs` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL,
  `jobid` int(11) NOT NULL,
  `jobprice` date NOT NULL,
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `naughtyjobs`
--