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`
--