RES: [PHP] Mutiple SQL request
| From: | Jônatas Zechim | Date: | Wed, 04 Feb 2009 17:21:48 +0000 |
| Subject: | RES: [PHP] Mutiple SQL request | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287619@lists.php.net to get a copy of this message | ||
Can you dump the table structure to show us how you've set it up?
Bastien
Cat, the other other white meat
Yeah, thats 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 ;