RES: [PHP] Mutiple SQL request

[Jônatas Zechim]

Can you dump the table structure to show us how you've set it up?
 
Bastien

Cat, the other other white meat

 

Yeah, that’s it:

 

CREATE TABLE `ctalk_admin` (

  `admin_id` int(9) NOT NULL auto_increment,

  `admin_nome` varchar(50) NOT NULL,

  `admin_login_nome` varchar(32) NOT NULL,

  `admin_pass` varchar(32) NOT NULL,

  `admin_login` int(10) NOT NULL,

  `admin_lastping` int(10) NOT NULL,

  PRIMARY KEY  (`admin_id`),

  KEY `admin_lastping` (`admin_lastping`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

CREATE TABLE `ctalk_chat` (

  `id` int(4) NOT NULL auto_increment,

  `id_admin` int(4) NOT NULL,

  `id_cliente` int(4) NOT NULL,

  `start_time` int(10) NOT NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

CREATE TABLE `ctalk_chat_mensagem` (

  `id` int(4) NOT NULL auto_increment,

  `mensagem` varchar(400) NOT NULL,

  `hora` int(10) NOT NULL,

  `id_chat` int(4) NOT NULL,

  PRIMARY KEY  (`id`),

  KEY `id_chat` (`id_chat`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

CREATE TABLE `ctalk_cliente` (

  `cliente_id` int(4) NOT NULL auto_increment,

  `cliente_nome` varchar(50) NOT NULL,

  `cliente_email` varchar(50) NOT NULL,

  `cliente_cpf` varchar(14) NOT NULL,

  `cliente_login` int(10) NOT NULL,

  `cliente_key` varchar(32) NOT NULL,

  `cliente_lastping` int(10) NOT NULL,

  `cliente_inchat` int(1) NOT NULL,

  PRIMARY KEY  (`cliente_id`),

  KEY `cliente_lastping` (`cliente_lastping`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;