Jump to content
Sign in to follow this  
Eugenio Silva

Erro No Mysql Serv. Dedicado

Recommended Posts

Ola pessoal, sou novo aqui mais vejo que este fórum é um dos melhores em quesito ajuda. rsrs..

vejo que muita gente já foi ajudada aqui e estou precisando de uma mãozinha de vocês também.

 

Tenho um Servidor Dedicado e estou tentando instalar um Atendimento online e quando coloco 

os dados do banco de dados diz o seguinte erro:

 

Error: Database produced the following error(s). Please correct and submit.
Error: Following database error(s) were generated: 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'signal tinyint(1) NOT NULL default '0', rateme tinyint(1) NOT NULL default '0'' at line 14
 
Verifying your MySQL Information Help
Verifying your MySQL Information Help Docs
 
Agradeço desde já qualquer ajuda.

Web Rádio Completa, Revenda de Streaming e Sites Gerenciáveis - Acesse: https://ehostsolucoes.com.br

Share this post


Link to post
Share on other sites

Pelo que entendi de seu erro o seu sistema de atendimento não esta sendo compatível com a versão do MYSQL
Veja junto ao desenvolver de seu sistema de atendimento a versão de seu mysql

 

 

ou veja este video quando procurei pelo erro deu nisso +-

http://www.youtube.com/watch?v=zofqioAWCwU

 

leia os comentários tem algumas respostas relacionadas a seu erro.


Fox Soluções | (011) 3090 4444 / (011) 96841-9797 |  www.FoxSolucoes.com
 | Streaming Áudio | CentovaCast | Revendas de Streaming | Data Center Brasil  EUA | 
 | Streaming Vídeo | CastControl WOWZA | Revendas de Streaming | Data Center Brasil  EUA | 

Share this post


Link to post
Share on other sites

Creio que este sistema que ele esta tentando instalar é o PHP Live, correto?

 

Bom é certo que o erro é mesmo da versão do mysql que não esta compatível.
Você tera que ir até o arquivo que esta o banco de dados e alterar a versão do mysql.


Hospedagem, Revendas, Servidores VPS - [Adven Host]

Share this post


Link to post
Share on other sites

[Advirhost] que arquivo você se refere? o sistema é este mesmo sempre instalei ele 

pois agora estou com este pequeno problema creio seja incompatível mesmo o MySQL com o sistema.


Web Rádio Completa, Revenda de Streaming e Sites Gerenciáveis - Acesse: https://ehostsolucoes.com.br

Share this post


Link to post
Share on other sites

Basta Alterar o Arquivo: phplive.txt

da pasta: SUPER

 

colocando estes dados no arquivo.

--
-- Banco de Dados: `teste`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatcanned`
--

CREATE TABLE IF NOT EXISTS `chatcanned` (
  `cannedID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `type` char(1) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `message` mediumtext NOT NULL,
  PRIMARY KEY (`cannedID`),
  KEY `userID` (`userID`),
  KEY `type` (`type`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatclicks`
--

CREATE TABLE IF NOT EXISTS `chatclicks` (
  `trackID` int(10) unsigned NOT NULL DEFAULT '0',
  `statdate` int(10) unsigned NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `clicks` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `aspID` (`aspID`),
  KEY `trackID` (`trackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatclicktracking`
--

CREATE TABLE IF NOT EXISTS `chatclicktracking` (
  `trackID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `unique_key` tinyint(2) NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `color` varchar(7) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `landing_url` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`trackID`),
  KEY `aspID` (`aspID`),
  KEY `unique_key` (`unique_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatdepartments`
--

CREATE TABLE IF NOT EXISTS `chatdepartments` (
  `deptID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  `transcript_save` tinyint(1) NOT NULL DEFAULT '0',
  `transcript_share` tinyint(1) NOT NULL DEFAULT '0',
  `transcript_expire_string` varchar(10) NOT NULL DEFAULT '',
  `transcript_expire` int(10) NOT NULL DEFAULT '0',
  `show_que` tinyint(1) NOT NULL DEFAULT '0',
  `email` varchar(150) NOT NULL DEFAULT '',
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  `initiate_chat` tinyint(1) NOT NULL DEFAULT '0',
  `email_trans` tinyint(1) NOT NULL DEFAULT '1',
  `status_image_offline` varchar(20) NOT NULL DEFAULT '',
  `status_image_online` varchar(20) NOT NULL DEFAULT '',
  `status_image_away` varchar(20) NOT NULL DEFAULT '',
  `message` mediumtext NOT NULL,
  `away_message` mediumtext NOT NULL,
  `greeting` text NOT NULL,
  PRIMARY KEY (`deptID`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatfootprints`
--

CREATE TABLE IF NOT EXISTS `chatfootprints` (
  `printID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`printID`),
  KEY `ip` (`ip`),
  KEY `created` (`created`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatfootprintstats`
--

CREATE TABLE IF NOT EXISTS `chatfootprintstats` (
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `statdate` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `pageviews` int(10) unsigned NOT NULL DEFAULT '0',
  `uniquevisits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aspID`,`statdate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatfootprintsunique`
--

CREATE TABLE IF NOT EXISTS `chatfootprintsunique` (
  `ip` varchar(20) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `updated` int(10) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`,`aspID`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatfootprinturlstats`
--

CREATE TABLE IF NOT EXISTS `chatfootprinturlstats` (
  `statID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `statdate` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `url` char(255) NOT NULL DEFAULT '',
  `clicks` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`statID`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatkbcats`
--

CREATE TABLE IF NOT EXISTS `chatkbcats` (
  `catID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `catID_parent` int(10) unsigned NOT NULL DEFAULT '0',
  `display_order` mediumint(3) unsigned NOT NULL DEFAULT '1',
  `name` char(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`catID`),
  KEY `aspID` (`aspID`),
  KEY `deptID` (`deptID`),
  KEY `catID_parent` (`catID_parent`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatkbquestions`
--

CREATE TABLE IF NOT EXISTS `chatkbquestions` (
  `questID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `catID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `points` int(10) NOT NULL DEFAULT '0',
  `clicks` int(10) unsigned NOT NULL DEFAULT '0',
  `question` varchar(255) NOT NULL DEFAULT '',
  `answer` text NOT NULL,
  PRIMARY KEY (`questID`),
  KEY `points` (`points`),
  KEY `deptID` (`deptID`),
  KEY `aspID` (`aspID`),
  KEY `catID` (`catID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatkbratings`
--

CREATE TABLE IF NOT EXISTS `chatkbratings` (
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `questID` int(10) unsigned NOT NULL DEFAULT '0',
  `catID` int(10) unsigned NOT NULL DEFAULT '0',
  `rating` tinyint(1) NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` char(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`questID`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatkbsearchterms`
--

CREATE TABLE IF NOT EXISTS `chatkbsearchterms` (
  `searchID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `counter` int(10) unsigned NOT NULL DEFAULT '0',
  `searchterm` varchar(255) NOT NULL DEFAULT '',
  `correction` varchar(255) NOT NULL DEFAULT '',
  `related` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`searchID`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatrefer`
--

CREATE TABLE IF NOT EXISTS `chatrefer` (
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `trackID` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` char(20) NOT NULL DEFAULT '',
  `refer_url` char(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`aspID`,`ip`),
  KEY `created` (`created`),
  KEY `trackID` (`trackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatrequestlogs`
--

CREATE TABLE IF NOT EXISTS `chatrequestlogs` (
  `chat_session` int(10) NOT NULL DEFAULT '0',
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) NOT NULL DEFAULT '0',
  `surveyID` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` char(20) NOT NULL DEFAULT '',
  `hostname` char(150) NOT NULL DEFAULT '',
  `display_resolution` char(20) NOT NULL DEFAULT '',
  `browser_os` char(60) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `url` char(255) NOT NULL DEFAULT '',
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  KEY `userID` (`userID`),
  KEY `created` (`created`),
  KEY `aspID` (`aspID`),
  KEY `chat_session` (`chat_session`),
  KEY `status` (`status`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatrequests`
--

CREATE TABLE IF NOT EXISTS `chatrequests` (
  `requestID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userID` int(10) NOT NULL DEFAULT '0',
  `deptID` int(10) NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `from_screen_name` varchar(50) NOT NULL DEFAULT '',
  `sessionID` int(10) unsigned NOT NULL DEFAULT '0',
  `surveyID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `tstatus` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `tflag` tinyint(1) NOT NULL DEFAULT '0',
  `ip_address` varchar(20) NOT NULL DEFAULT '',
  `browser_type` varchar(60) NOT NULL DEFAULT '',
  `display_resolution` varchar(20) NOT NULL DEFAULT '',
  `visitor_time` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(150) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `question` text NOT NULL,
  PRIMARY KEY (`requestID`),
  KEY `sessionID` (`sessionID`),
  KEY `deptID` (`deptID`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsessionlist`
--

CREATE TABLE IF NOT EXISTS `chatsessionlist` (
  `sessionID` int(10) unsigned NOT NULL DEFAULT '0',
  `screen_name` char(50) NOT NULL DEFAULT '',
  `updated` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `sessionID` (`sessionID`),
  KEY `userID` (`screen_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsessions`
--

CREATE TABLE IF NOT EXISTS `chatsessions` (
  `sessionID` int(10) unsigned NOT NULL DEFAULT '0',
  `screen_name` char(50) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `initiate` char(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`sessionID`),
  KEY `userID` (`screen_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsp`
--

CREATE TABLE IF NOT EXISTS `chatsp` (
  `spID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(160) NOT NULL DEFAULT '',
  `enotify` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`spID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatspamips`
--

CREATE TABLE IF NOT EXISTS `chatspamips` (
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aspID`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatspfootprints`
--

CREATE TABLE IF NOT EXISTS `chatspfootprints` (
  `spID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  KEY `spID` (`spID`),
  KEY `created` (`created`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsprefer`
--

CREATE TABLE IF NOT EXISTS `chatsprefer` (
  `spID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `trackID` int(10) unsigned NOT NULL DEFAULT '0',
  `chat_session` int(10) unsigned NOT NULL DEFAULT '0',
  `numfootprints` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `refer_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`spID`),
  KEY `aspID` (`aspID`),
  KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsurveylogs`
--

CREATE TABLE IF NOT EXISTS `chatsurveylogs` (
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `surveyID` int(10) unsigned NOT NULL DEFAULT '0',
  `rejected` tinyint(1) NOT NULL DEFAULT '0',
  `s_c1` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c2` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c3` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c4` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c5` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `q_open` text NOT NULL,
  PRIMARY KEY (`ip`,`aspID`,`surveyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatsurveys`
--

CREATE TABLE IF NOT EXISTS `chatsurveys` (
  `surveyID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created` int(10) NOT NULL DEFAULT '0',
  `s_totaltaken` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c1` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c2` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c3` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c4` int(10) unsigned NOT NULL DEFAULT '0',
  `s_c5` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(60) NOT NULL DEFAULT '',
  `survey_data` text NOT NULL,
  PRIMARY KEY (`surveyID`),
  UNIQUE KEY `name` (`name`),
  KEY `aspID` (`aspID`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chattranscripts`
--

CREATE TABLE IF NOT EXISTS `chattranscripts` (
  `chat_session` varchar(20) NOT NULL DEFAULT '',
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `from_screen_name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(150) NOT NULL DEFAULT '',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) NOT NULL DEFAULT '0',
  `plain` text NOT NULL,
  `formatted` text NOT NULL,
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`chat_session`),
  KEY `deptID` (`deptID`),
  KEY `userID` (`userID`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chatuserdeptlist`
--

CREATE TABLE IF NOT EXISTS `chatuserdeptlist` (
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `ordernum` mediumint(3) unsigned NOT NULL DEFAULT '1',
  `last_active` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `userID` (`userID`),
  KEY `deptID` (`deptID`),
  KEY `ordernum` (`ordernum`),
  KEY `last_active_time` (`last_active`),
  KEY `last_active` (`last_active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chat_admin`
--

CREATE TABLE IF NOT EXISTS `chat_admin` (
  `userID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(15) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(150) NOT NULL DEFAULT '',
  `available_status` tinyint(1) NOT NULL DEFAULT '0',
  `last_active_time` int(10) unsigned NOT NULL DEFAULT '0',
  `utrigger` tinyint(1) NOT NULL DEFAULT '1',
  `console_close_min` mediumint(3) unsigned NOT NULL DEFAULT '10',
  `session_sid` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '1',
  `rateme` tinyint(1) NOT NULL DEFAULT '0',
  `rate_sum` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_total` int(10) unsigned NOT NULL DEFAULT '0',
  `rate_ave` tinyint(2) NOT NULL DEFAULT '0',
  `op2op` tinyint(4) NOT NULL DEFAULT '1',
  `console_refresh` mediumint(9) NOT NULL DEFAULT '10',
  `pic` varchar(25) NOT NULL DEFAULT '',
  `theme` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`userID`),
  KEY `created` (`created`),
  KEY `aspID` (`aspID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chat_adminrate`
--

CREATE TABLE IF NOT EXISTS `chat_adminrate` (
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `sessionID` int(10) unsigned NOT NULL DEFAULT '0',
  `rating` int(10) unsigned NOT NULL DEFAULT '0',
  `deptID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `aspID` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sessionID`),
  KEY `userID` (`userID`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chat_adminstatus`
--

CREATE TABLE IF NOT EXISTS `chat_adminstatus` (
  `logID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userID` int(10) unsigned NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`logID`),
  KEY `userID` (`userID`),
  KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estrutura da tabela `chat_asp`
--

CREATE TABLE IF NOT EXISTS `chat_asp` (
  `aspID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(25) NOT NULL DEFAULT '',
  `password` varchar(15) NOT NULL DEFAULT '',
  `company` varchar(50) NOT NULL DEFAULT '',
  `contact_name` varchar(50) NOT NULL DEFAULT '',
  `contact_email` varchar(160) NOT NULL DEFAULT '',
  `max_dept` mediumint(3) NOT NULL DEFAULT '0',
  `max_users` mediumint(3) NOT NULL DEFAULT '0',
  `footprints` tinyint(1) NOT NULL DEFAULT '0',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(10) unsigned NOT NULL DEFAULT '0',
  `active_status` tinyint(1) NOT NULL DEFAULT '0',
  `initiate_chat` tinyint(1) NOT NULL DEFAULT '0',
  `admin_polling_type` tinyint(1) NOT NULL DEFAULT '0',
  `knowledgebase` tinyint(1) NOT NULL DEFAULT '1',
  `trans_message` varchar(255) NOT NULL DEFAULT '',
  `trans_email` text NOT NULL,
  PRIMARY KEY (`aspID`),
  KEY `created` (`created`),
  KEY `max_dept` (`max_dept`),
  KEY `max_users` (`max_users`),
  KEY `active_status` (`active_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Funcionando 100%.

Edited by advirhost
  • Like 1

Hospedagem, Revendas, Servidores VPS - [Adven Host]

Share this post


Link to post
Share on other sites

Erro ainda persiste alguém que souber por favor postar ai já tentei varias formas e ate o momento não tive sucesso...

Aguardo!!! 


Web Rádio Completa, Revenda de Streaming e Sites Gerenciáveis - Acesse: https://ehostsolucoes.com.br

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.




×
×
  • Create New...