File: sql.sql

- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 10, 2011 at 02:49 PM
-- Server version: 5.0.91
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `phpticket`
--

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

--
-- Table structure for table `core`
--

CREATE TABLE IF NOT EXISTS `core` (
  `emp` varchar(1) NOT NULL,
  `adm` varchar(100) NOT NULL,
  `pwd` varchar(32) NOT NULL,
  `site_name` varchar(200) NOT NULL,
  `site_link` varchar(150) NOT NULL,
  `adm_link` varchar(150) NOT NULL,
  `page_title` varchar(150) NOT NULL,
  `site_mail` varchar(90) NOT NULL,
  `adm_mail` varchar(90) NOT NULL,
  `script_mail` varchar(90) NOT NULL,
  `secert_q` varchar(100) NOT NULL,
  `secert_a` varchar(100) NOT NULL,
  `check_ip` tinyint(1) NOT NULL,
  `check_em` tinyint(1) NOT NULL,
  `valid_link` varchar(200) NOT NULL,
  `status_link` varchar(200) NOT NULL,
  `rem_link` varchar(200) NOT NULL,
  `remval_link` varchar(200) NOT NULL,
  `total` int(5) NOT NULL,
  `max_ticket` int(5) NOT NULL,
  PRIMARY KEY  (`emp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tickets`
--

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `email` varchar(320) NOT NULL,
  `site` varchar(150) NOT NULL,
  `ticket` varchar(64) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `msg` longtext NOT NULL,
  `ip` varchar(150) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `valid` tinyint(1) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `cdate` date NOT NULL,
  `ctime` time NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;