CREATE TABLE whois_e (
id_num int(11) DEFAULT '0' NOT NULL,
email int,
url int,
query char(128),
sent int(11) DEFAULT '0' NOT NULL,
);
####
create index whosis_1 on whois_e(id_num);
create index whosis_1 on whois_e(email);
create index whosis_1 on whois_e(url);
create index whosis_1 on whois_e(sent);
##
##
select * from whois_e
where email = '$email'
and url = '$url'
and sent = '1'
##
##
create index whosis_2 on whois_e(email, url, sent);
##
##
CREATE TABLE whois_e (
id_num int(11) unsigned DEFAULT '0' NOT NULL auto_increment primary key,
email int unsigned not null,
url int unsigned not null,
query char(128),
sent int(11) DEFAULT '0' NOT NULL,
);
##
##
INSERT into whois_e VALUES(...), (...),(...), (...).....;