--
-- Host: localhost    Database: atendimento
-- ------------------------------------------------------


--
-- Table structure for table `livehelp_autoinvite`
--

CREATE TABLE `livehelp_autoinvite` (
  `idnum` int(10) NOT NULL auto_increment,
  `isactive` char(1) NOT NULL default '',
  `department` int(10) NOT NULL default '0',
  `message` text,
  `page` varchar(255) NOT NULL default '',
  `visits` int(8) NOT NULL default '0',
  `referer` varchar(255) NOT NULL default '',
  `typeof` varchar(255) NOT NULL default '',
  `seconds` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`idnum`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_autoinvite`
--

INSERT INTO `livehelp_autoinvite` VALUES (1,'Y',0,'5','',0,'','layer',60);

--
-- Table structure for table `livehelp_departments`
--

CREATE TABLE `livehelp_departments` (
  `recno` int(5) NOT NULL auto_increment,
  `nameof` varchar(30) NOT NULL default '',
  `onlineimage` varchar(255) NOT NULL default '',
  `offlineimage` varchar(255) NOT NULL default '',
  `layerinvite` varchar(255) NOT NULL default '',
  `requirename` char(1) NOT NULL default '',
  `messageemail` varchar(60) NOT NULL default '',
  `leaveamessage` varchar(10) NOT NULL default '',
  `opening` text,
  `offline` text,
  `creditline` char(1) NOT NULL default 'L',
  `imagemap` text,
  `whilewait` text,
  `timeout` int(5) NOT NULL default '150',
  `leavetxt` text,
  `topframeheight` int(10) NOT NULL default '35',
  `topbackground` varchar(255) NOT NULL default '',
  `colorscheme` varchar(255) NOT NULL default '',
  `speaklanguage` varchar(60) NOT NULL default '',
  `busymess` text,
  `emailfun` char(1) NOT NULL default 'Y',
  `dbfun` char(1) NOT NULL default 'Y',
  `everythingelse` text,
  `ordering` int(8) NOT NULL default '0',
  `smiles` char(1) NOT NULL default 'Y',
  `visible` int(1) NOT NULL default '1',
  PRIMARY KEY  (`recno`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_departments`
--

INSERT INTO `livehelp_departments` VALUES (1,'default','onoff_images/online1.gif','onoff_images/offline1.gif','dhtmlimage.gif','Y','fabianokrul@gmail.com','YES','<blockquote>Bem-vindo à Central de Atendimento, Por favor informe seu nome e sua mensagem.</blockquote>','<blockquote>Sorry no operators are currently online to provide Live support at this time.</blockquote>','L','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,400,197><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,157,213,257><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=237,157,400,257></MAP>','Please be patient while an operator is contacted... ',150,'<h3><SPAN CLASS=wh>LEAVE A MESSAGE:</SPAN></h3>Please type in your comments/questions in the below box <br> and provide an e-mail address so we can get back to you',45,'topclouds.gif','blue','','<blockquote>Sorry all operators are currently helping other clients and are unable to provide Live support at this time.<br>Would you like to continue to wait for an operator or leave a message?<br><table width=450><tr><td width=40%><a href=livehelp.php?page=livehelp.php&department=[department]&tab=1 target=_top><font size=+1>Continue to wait</font></a></td><td width=20% align=center><b>or</b></td><td width=40%><a href=leavemessage.php?department=[department]><font size=+1>Leave A Message</a></td></tr></table><blockquote>','Y','Y',NULL,0,'Y',1),(2,'Central de Atendimento','onoff_images/online1.gif','onoff_images/offline1.gif','','Y','fabianokrul@gmail.com','YES','<blockquote>Bem-vindo à Central de Atendimento, Por favor informe seu nome e sua mensagem.</blockquote>','<blockquote>Desculpe, todos os nossos atendentes estão offline.</blockquote>','L',NULL,'Por favor, aguarde o contato com o Atendente...',150,'<h3><SPAN CLASS=wh>LEAVE A MESSAGE:</SPAN></h3>Please type in your comments/questions in the below box <br> and provide an e-mail address so we can get back to you',45,'topclouds.gif','blue','Portuguese_Brazilian','<blockquote>Sorry all operators are currently helping other clients and are unable to provide Live support at this time.<br>Would you like to continue to wait for an operator or leave a message?<br><table width=450><tr><td width=40%><a href=livehelp.php?page=livehelp.php&department=[department]&tab=1 target=_top><font size=+1>Continue to wait</font></a></td><td width=20% align=center><b>or</b></td><td width=40%><a href=leavemessage.php?department=[department]><font size=+1>Leave A Message</a></td></tr></table><blockquote>','Y','Y',NULL,0,'Y',1);

--
-- Table structure for table `livehelp_identity_daily`
--

CREATE TABLE `livehelp_identity_daily` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `isnamed` char(1) NOT NULL default 'N',
  `groupidentity` int(11) NOT NULL default '0',
  `groupusername` int(11) NOT NULL default '0',
  `identity` varchar(100) NOT NULL default '',
  `cookieid` varchar(40) NOT NULL default '',
  `ipaddress` varchar(30) NOT NULL default '',
  `username` varchar(100) NOT NULL default '',
  `dateof` bigint(14) NOT NULL default '0',
  `uservisits` int(10) NOT NULL default '0',
  `seconds` int(10) NOT NULL default '0',
  `useragent` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `isnamed` (`isnamed`),
  KEY `groupidentity` (`groupidentity`),
  KEY `groupusername` (`groupusername`),
  KEY `identity` (`identity`),
  KEY `cookieid` (`cookieid`),
  KEY `username` (`username`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_identity_daily`
--


--
-- Table structure for table `livehelp_identity_monthly`
--

CREATE TABLE `livehelp_identity_monthly` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `isnamed` char(1) NOT NULL default 'N',
  `groupidentity` int(11) NOT NULL default '0',
  `groupusername` int(11) NOT NULL default '0',
  `identity` varchar(100) NOT NULL default '',
  `cookieid` varchar(40) NOT NULL default '',
  `ipaddress` varchar(30) NOT NULL default '',
  `username` varchar(100) NOT NULL default '',
  `dateof` bigint(14) NOT NULL default '0',
  `uservisits` int(10) NOT NULL default '0',
  `seconds` int(10) NOT NULL default '0',
  `useragent` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `isnamed` (`isnamed`),
  KEY `groupidentity` (`groupidentity`),
  KEY `groupusername` (`groupusername`),
  KEY `identity` (`identity`),
  KEY `cookieid` (`cookieid`),
  KEY `username` (`username`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_identity_monthly`
--


--
-- Table structure for table `livehelp_keywords_daily`
--

CREATE TABLE `livehelp_keywords_daily` (
  `recno` int(11) NOT NULL auto_increment,
  `parentrec` int(11) unsigned NOT NULL default '0',
  `referer` varchar(255) NOT NULL default '',
  `pageurl` varchar(255) NOT NULL default '',
  `keywords` varchar(255) NOT NULL default '',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `levelvisits` (`levelvisits`),
  KEY `dateof` (`dateof`),
  KEY `referer` (`referer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_keywords_daily`
--


--
-- Table structure for table `livehelp_keywords_monthly`
--

CREATE TABLE `livehelp_keywords_monthly` (
  `recno` int(11) NOT NULL auto_increment,
  `parentrec` int(11) unsigned NOT NULL default '0',
  `referer` varchar(255) NOT NULL default '',
  `pageurl` varchar(255) NOT NULL default '',
  `keywords` varchar(255) NOT NULL default '',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `levelvisits` (`levelvisits`),
  KEY `dateof` (`dateof`),
  KEY `referer` (`referer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_keywords_monthly`
--


--
-- Table structure for table `livehelp_layerinvites`
--

CREATE TABLE `livehelp_layerinvites` (
  `layerid` int(10) NOT NULL default '0',
  `name` varchar(60) NOT NULL default '',
  `imagename` varchar(60) NOT NULL default '',
  `imagemap` text,
  `department` varchar(60) NOT NULL default '',
  `user` int(10) NOT NULL default '0',
  PRIMARY KEY  (`layerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_layerinvites`
--

INSERT INTO `livehelp_layerinvites` VALUES (1,'','layer-Phone.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,472,150><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=241,150,484,256><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=0,150,241,250></MAP>','',0),(2,'','layer-Help_button.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,400,197><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,157,213,257><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=237,157,400,257></MAP>','',0),(3,'','layer-Woman_invite.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,400,197><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,157,213,257><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=237,157,400,257></MAP>','',0),(4,'','layer-Subsilver.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,419,216><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,216,319,279><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=326,218,429,280></MAP>','',0),(5,'','layer-default.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,400,197><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,157,213,257><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=237,157,400,257></MAP>','',0),(6,'','layer-Man_invite.gif','<MAP NAME=myimagemap><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,0,400,197><AREA HREF=javascript:openLiveHelp() SHAPE=RECT COORDS=0,157,213,257><AREA HREF=javascript:closeDHTML() SHAPE=RECT COORDS=237,157,400,257></MAP>','',0);

--
-- Table structure for table `livehelp_leavemessage`
--

CREATE TABLE `livehelp_leavemessage` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `subject` varchar(200) NOT NULL default '',
  `department` int(11) unsigned NOT NULL default '0',
  `dateof` bigint(14) NOT NULL default '0',
  `sessiondata` text,
  `deliminated` text,
  PRIMARY KEY  (`id`),
  KEY `department` (`department`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_leavemessage`
--


--
-- Table structure for table `livehelp_messages`
--

CREATE TABLE `livehelp_messages` (
  `id_num` int(10) NOT NULL auto_increment,
  `message` text,
  `channel` int(10) NOT NULL default '0',
  `timeof` bigint(14) NOT NULL default '0',
  `saidfrom` int(10) NOT NULL default '0',
  `saidto` int(10) NOT NULL default '0',
  `typeof` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id_num`),
  KEY `channel` (`channel`),
  KEY `timeof` (`timeof`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_messages`
--


--
-- Table structure for table `livehelp_modules`
--

CREATE TABLE `livehelp_modules` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `adminpath` varchar(255) NOT NULL default '',
  `query_string` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_modules`
--

INSERT INTO `livehelp_modules` VALUES (1,'Live Help!','livehelp.php','',''),(2,'Contact','leavemessage.php','',''),(3,'Q & A','user_qa.php','qa.php','');

--
-- Table structure for table `livehelp_modules_dep`
--

CREATE TABLE `livehelp_modules_dep` (
  `rec` int(10) NOT NULL auto_increment,
  `departmentid` int(10) NOT NULL default '0',
  `modid` int(10) NOT NULL default '0',
  `ordernum` int(8) NOT NULL default '0',
  `defaultset` char(1) NOT NULL default '',
  PRIMARY KEY  (`rec`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_modules_dep`
--

INSERT INTO `livehelp_modules_dep` VALUES (1,1,1,1,''),(2,1,2,2,'Y'),(6,2,2,2,'Y'),(5,2,1,1,'');

--
-- Table structure for table `livehelp_operator_channels`
--

CREATE TABLE `livehelp_operator_channels` (
  `id` int(10) NOT NULL auto_increment,
  `user_id` int(10) NOT NULL default '0',
  `channel` int(10) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `statusof` char(1) NOT NULL default '',
  `startdate` bigint(8) NOT NULL default '0',
  `bgcolor` varchar(10) NOT NULL default '000000',
  `txtcolor` varchar(10) NOT NULL default '000000',
  `channelcolor` varchar(10) NOT NULL default 'F7FAFF',
  `txtcolor_alt` varchar(10) NOT NULL default '000000',
  PRIMARY KEY  (`id`),
  KEY `channel` (`channel`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_operator_channels`
--


--
-- Table structure for table `livehelp_operator_departments`
--

CREATE TABLE `livehelp_operator_departments` (
  `recno` int(10) NOT NULL auto_increment,
  `user_id` int(10) NOT NULL default '0',
  `department` int(10) NOT NULL default '0',
  `extra` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`recno`),
  KEY `user_id` (`user_id`),
  KEY `department` (`department`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_operator_departments`
--

INSERT INTO `livehelp_operator_departments` VALUES (1,1,1,''),(2,1,2,''),(3,6,2,'');

--
-- Table structure for table `livehelp_paths_firsts`
--

CREATE TABLE `livehelp_paths_firsts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `visit_recno` int(11) unsigned NOT NULL default '0',
  `exit_recno` int(11) unsigned NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `visits` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `visit_recno` (`visit_recno`,`dateof`,`visits`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_paths_firsts`
--


--
-- Table structure for table `livehelp_paths_monthly`
--

CREATE TABLE `livehelp_paths_monthly` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `visit_recno` int(11) unsigned NOT NULL default '0',
  `exit_recno` int(11) unsigned NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `visits` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `visit_recno` (`visit_recno`,`dateof`,`visits`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_paths_monthly`
--


--
-- Table structure for table `livehelp_qa`
--

CREATE TABLE `livehelp_qa` (
  `recno` int(10) NOT NULL auto_increment,
  `parent` int(10) NOT NULL default '0',
  `question` text,
  `typeof` varchar(10) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `username` varchar(60) NOT NULL default '',
  `ordernum` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_qa`
--


--
-- Table structure for table `livehelp_questions`
--

CREATE TABLE `livehelp_questions` (
  `id` int(10) NOT NULL auto_increment,
  `department` int(10) NOT NULL default '0',
  `ordering` int(8) NOT NULL default '0',
  `headertext` text,
  `fieldtype` varchar(30) NOT NULL default '',
  `options` text,
  `flags` varchar(60) NOT NULL default '',
  `module` varchar(60) NOT NULL default '',
  `required` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `department` (`department`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_questions`
--

INSERT INTO `livehelp_questions` VALUES (1,1,0,'E-mail:','email','','','leavemessage','Y'),(2,1,0,'Question:','textarea','','','leavemessage','N'),(3,1,0,'Name','username','','','livehelp','N'),(5,1,1,'Question','textarea','','','livehelp','N'),(6,2,0,'Nome','username','','','livehelp','Y'),(7,2,1,'Questão','textarea','','','livehelp','Y'),(8,2,0,'E-mail:','email','','','leavemessage','Y'),(9,2,0,'Question:','textarea','','','leavemessage','N');

--
-- Table structure for table `livehelp_quick`
--

CREATE TABLE `livehelp_quick` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `typeof` varchar(30) NOT NULL default '',
  `message` text,
  `visiblity` varchar(20) NOT NULL default '',
  `department` varchar(60) NOT NULL default '0',
  `user` int(10) NOT NULL default '0',
  `ishtml` varchar(3) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_quick`
--


--
-- Table structure for table `livehelp_referers_daily`
--

CREATE TABLE `livehelp_referers_daily` (
  `recno` int(11) NOT NULL auto_increment,
  `pageurl` varchar(255) NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  `parentrec` int(11) unsigned NOT NULL default '0',
  `level` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `pageurl` (`pageurl`),
  KEY `parentrec` (`parentrec`),
  KEY `levelvisits` (`levelvisits`),
  KEY `directvisits` (`directvisits`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_referers_daily`
--


--
-- Table structure for table `livehelp_referers_monthly`
--

CREATE TABLE `livehelp_referers_monthly` (
  `recno` int(11) NOT NULL auto_increment,
  `pageurl` varchar(255) NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  `parentrec` int(11) unsigned NOT NULL default '0',
  `level` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `pageurl` (`pageurl`),
  KEY `parentrec` (`parentrec`),
  KEY `levelvisits` (`levelvisits`),
  KEY `directvisits` (`directvisits`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_referers_monthly`
--


--
-- Table structure for table `livehelp_smilies`
--

CREATE TABLE `livehelp_smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_smilies`
--

INSERT INTO `livehelp_smilies` VALUES (1,':D','icon_biggrin.gif','Very Happy'),(2,':-D','icon_biggrin.gif','Very Happy'),(3,':grin:','icon_biggrin.gif','Very Happy'),(4,':)','icon_smile.gif','Smile'),(5,':-)','icon_smile.gif','Smile'),(6,':smile:','icon_smile.gif','Smile'),(7,':(','icon_sad.gif','Sad'),(8,':-(','icon_sad.gif','Sad'),(9,':sad:','icon_sad.gif','Sad'),(10,':o','icon_surprised.gif','Surprised'),(11,':-o','icon_surprised.gif','Surprised'),(12,':eek:','icon_surprised.gif','Surprised'),(13,':shock:','icon_eek.gif','Shocked'),(14,':?','icon_confused.gif','Confused'),(15,':-?','icon_confused.gif','Confused'),(16,':???:','icon_confused.gif','Confused'),(17,'8)','icon_cool.gif','Cool'),(18,'8-)','icon_cool.gif','Cool'),(19,':cool:','icon_cool.gif','Cool'),(20,':lol:','icon_lol.gif','Laughing'),(21,':x','icon_mad.gif','Mad'),(22,':-x','icon_mad.gif','Mad'),(23,':mad:','icon_mad.gif','Mad'),(24,':P','icon_razz.gif','Razz'),(25,':-P','icon_razz.gif','Razz'),(26,':razz:','icon_razz.gif','Razz'),(27,':oops:','icon_redface.gif','Embarassed'),(28,':cry:','icon_cry.gif','Crying or Very sad'),(29,':evil:','icon_evil.gif','Evil or Very Mad'),(30,':twisted:','icon_twisted.gif','Twisted Evil'),(31,':roll:','icon_rolleyes.gif','Rolling Eyes'),(32,':wink:','icon_wink.gif','Wink'),(33,';)','icon_wink.gif','Wink'),(34,';-)','icon_wink.gif','Wink'),(35,':!:','icon_exclaim.gif','Exclamation'),(36,':?:','icon_question.gif','Question'),(37,':idea:','icon_idea.gif','Idea'),(38,':arrow:','icon_arrow.gif','Arrow'),(39,':|','icon_neutral.gif','Neutral'),(40,':-|','icon_neutral.gif','Neutral'),(41,':neutral:','icon_neutral.gif','Neutral'),(42,':mrgreen:','icon_mrgreen.gif','Mr. Green');

--
-- Table structure for table `livehelp_visits_daily`
--

CREATE TABLE `livehelp_visits_daily` (
  `recno` int(11) NOT NULL auto_increment,
  `pageurl` varchar(255) NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  `parentrec` int(11) unsigned NOT NULL default '0',
  `level` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `pageurl` (`pageurl`),
  KEY `parentrec` (`parentrec`),
  KEY `levelvisits` (`levelvisits`),
  KEY `directvisits` (`directvisits`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_visits_daily`
--


--
-- Table structure for table `livehelp_visits_monthly`
--

CREATE TABLE `livehelp_visits_monthly` (
  `recno` int(11) NOT NULL auto_increment,
  `pageurl` varchar(255) NOT NULL default '0',
  `dateof` int(8) NOT NULL default '0',
  `levelvisits` int(11) unsigned NOT NULL default '0',
  `directvisits` int(11) unsigned NOT NULL default '0',
  `parentrec` int(11) unsigned NOT NULL default '0',
  `level` int(10) NOT NULL default '0',
  PRIMARY KEY  (`recno`),
  KEY `pageurl` (`pageurl`),
  KEY `parentrec` (`parentrec`),
  KEY `levelvisits` (`levelvisits`),
  KEY `directvisits` (`directvisits`),
  KEY `dateof` (`dateof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livehelp_visits_monthly`
--


--
-- Dumping routines for database 'atendimento'
--
DELIMITER ;;
DELIMITER ;


