RES: [PHP] Mutiple SQL request

From: 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, 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 ;

« previous php.general (#287619) next »