# phpMyAdmin MySQL-Dump
# version 2.5.0
# http://www.phpmyadmin.net/ (download page)
# --------------------------------------------------------

#
# Table structure for table `canned`
#

CREATE TABLE `canned` (
  `id` int(255) NOT NULL auto_increment,
  `department` varchar(255) default NULL,
  `operator` varchar(255) default NULL,
  `subject` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `chat`
#

CREATE TABLE `chat` (
  `id` int(255) NOT NULL auto_increment,
  `chatid` varchar(255) NOT NULL default '',
  `author` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  `time` varchar(255) NOT NULL default '0',
  `x` char(1) NOT NULL default '',
  `operator` int(1) NOT NULL default '0',
  `guest` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `departments`
#

CREATE TABLE `departments` (
  `id` int(255) NOT NULL auto_increment,
  `department` varchar(255) NOT NULL default '',
  `operator` varchar(255) default NULL,
  `email` varchar(255) NOT NULL default '',
  `poll` int(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `faqs`
#

CREATE TABLE `faqs` (
  `id` int(255) NOT NULL auto_increment,
  `topicid` int(255) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `footprints`
#

CREATE TABLE `footprints` (
  `id` int(255) NOT NULL auto_increment,
  `chatid` varchar(255) NOT NULL default '',
  `page` text NOT NULL,
  `time` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `hotpages`
#

CREATE TABLE `hotpages` (
  `id` int(255) NOT NULL auto_increment,
  `page` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `icons`
#

CREATE TABLE `icons` (
  `id` int(255) NOT NULL auto_increment,
  `department` varchar(255) default NULL,
  `status` int(1) default NULL,
  `name` varchar(255) NOT NULL default '',
  `image` blob NOT NULL,
  `size` varchar(255) NOT NULL default '0',
  `type` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `operators`
#

CREATE TABLE `operators` (
  `id` int(255) NOT NULL auto_increment,
  `operator` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `level` int(1) NOT NULL default '0',
  `time` int(255) NOT NULL default '0',
  `autosave` int(1) NOT NULL default '1',
  `status` int(1) NOT NULL default '0',
  `sounds` int(1) NOT NULL default '1',
  `imageblob` blob NOT NULL,
  `imagetype` varchar(255) NOT NULL default '',
  `usepic` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `responses`
#

CREATE TABLE `responses` (
  `id` int(255) NOT NULL auto_increment,
  `ticketid` int(255) NOT NULL default '0',
  `author` int(1) NOT NULL default '0',
  `time` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `session`
#

CREATE TABLE `session` (
  `id` int(255) NOT NULL auto_increment,
  `chatid` varchar(255) NOT NULL default '',
  `department` varchar(255) default NULL,
  `operator` varchar(255) default NULL,
  `guest` varchar(255) NOT NULL default '',
  `alert` varchar(20) NOT NULL default '',
  `poll` int(11) NOT NULL default '0',
  `timeo` int(255) NOT NULL default '0',
  `timeg` int(255) NOT NULL default '0',
  `typeo` int(255) NOT NULL default '0',
  `typeg` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `sounds`
#

CREATE TABLE `sounds` (
  `id` int(255) NOT NULL auto_increment,
  `operator` varchar(255) NOT NULL default '',
  `sound` varchar(255) NOT NULL default '',
  `time` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `system`
#

CREATE TABLE `system` (
  `id` int(255) NOT NULL auto_increment,
  `operator` varchar(255) NOT NULL default '',
  `chatid` varchar(255) NOT NULL default '',
  `time` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `tickets`
#

CREATE TABLE `tickets` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `operator` varchar(255) default NULL,
  `department` varchar(255) default NULL,
  `subject` varchar(255) NOT NULL default '',
  `status` int(1) NOT NULL default '0',
  `urgency` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `topics`
#

CREATE TABLE `topics` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `sort` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `traffic`
#

CREATE TABLE `traffic` (
  `id` int(255) NOT NULL auto_increment,
  `chatid` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `hostname` varchar(255) NOT NULL default '',
  `referrer` text NOT NULL,
  `time` int(255) NOT NULL default '0',
  `requests` int(255) NOT NULL default '0',
  `visits` int(255) NOT NULL default '1',
  `start` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `transcripts`
#

CREATE TABLE `transcripts` (
  `id` int(255) NOT NULL auto_increment,
  `chatid` varchar(255) NOT NULL default '',
  `operator` varchar(255) NOT NULL default '',
  `department` varchar(255) NOT NULL default '',
  `guest` varchar(255) NOT NULL default '',
  `hostname` varchar(255) NOT NULL default '',
  `time` varchar(255) NOT NULL default '',
  `transcript` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE `users` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;