PHP版在线客服系统(php Help Agent)

-- -------------------------------------------------------- -- -- Table structure for table `chat_msg` -- CREATE TABLE `chat_msg` ( `msg_id` mediumint(8) unsigned NOT NULL auto_increment, `msg_text` varchar(255) NOT NULL default '', PRIMARY KEY (`msg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `chat_ol` -- CREATE TABLE `chat_ol` ( `ol_exp` int(15) NOT NULL default '0', `ol_user` mediumint(9) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `chat_talk` -- CREATE TABLE `chat_talk` ( `talk_exp` int(15) NOT NULL default '0', `talk_id` mediumint(9) NOT NULL default '0', `talker` enum('o','u','s') NOT NULL default 'u', `talk_text` varchar(255) NOT NULL default '', PRIMARY KEY (`talk_exp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `chat_usr` -- CREATE TABLE `chat_usr` ( `c_usr_id` mediumint(8) unsigned NOT NULL auto_increment, `c_usr_name` varchar(20) NOT NULL default '', `c_usr_exp` int(15) NOT NULL default '0', `c_usr_email` varchar(150) NOT NULL default '', `c_usr_assignee` varchar(20) NOT NULL default '', PRIMARY KEY (`c_usr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `kbase` -- CREATE TABLE `kbase` ( `kb_id` mediumint(8) unsigned NOT NULL auto_increment, `kb_q` varchar(150) NOT NULL default '', `kb_a` text NOT NULL, PRIMARY KEY (`kb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `site` -- CREATE TABLE `site` ( `site_id` mediumint(8) unsigned NOT NULL auto_increment, `site_name` varchar(100) NOT NULL default '', `site_email` varchar(175) NOT NULL default '', `site_url` varchar(255) NOT NULL default '', `ticket_exp` int(11) NOT NULL default '0', PRIMARY KEY (`site_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tickets` -- CREATE TABLE `tickets` ( `ticket_id` varchar(20) NOT NULL default '', `ticket_subject` varchar(50) NOT NULL default '', `user_id` mediumint(9) NOT NULL default '0', `ticket_priority` varchar(10) NOT NULL default '', `ticket_status` enum('open','closed') NOT NULL default 'open', `ticket_life` int(15) NOT NULL default '0', `assignee` varchar(175) NOT NULL default '', PRIMARY KEY (`ticket_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `ticket_text` -- CREATE TABLE `ticket_text` ( `entry_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(20) NOT NULL default '0', `entry_by` varchar(50) NOT NULL default '', `entry_text` text NOT NULL, `entry_date` varchar(100) NOT NULL default '', PRIMARY KEY (`entry_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `user_id` mediumint(8) unsigned NOT NULL auto_increment, `user_name` varchar(20) NOT NULL default '', `user_email` varchar(175) NOT NULL default '', `user_pass` varchar(20) NOT NULL default '', `user_level` char(1) NOT NULL default '3', PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;