PHP Classes
elePHPant
Icontem

File: sql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Lee J  >  PHP easy ticket and help system  >  sql.sql  >  Download  
File: sql.sql
Role: Auxiliary data
Content type: text/plain
Description: sql data base file
Class: PHP easy ticket and help system
Manage help desk ticket submissions
Author: By
Last change:
Date: 4 years ago
Size: 1,948 bytes
 

Contents

Class file image Download
- 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 ;