PHP Classes

File: sql.sql

Recommend this page to a friend!
  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: 13 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 ;