in reply to Re: MySQL-pp, Perl and MySQL Triggers
in thread MySQL-pp, Perl and MySQL Triggers
$sql = "create table login (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
created DATE,
tec_id VARCHAR(15),
type VARCHAR(50),
password VARCHAR(100),
stage_name VARCHAR(150),
last_log DATE,
last_time TIME,
active VARCHAR(3),
banned VARCHAR(3),
PRIMARY KEY (id),
INDEX (`tec_id` ASC),
INDEX (`type` ASC),
INDEX (`stage_name` ASC),
INDEX (`last_log` ASC)
) ENGINE=MyISAM;";
AND
$sql = "create table user (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
tec_id VARCHAR(15) NOT NULL UNIQUE,
created DATE,
agent_id VARCHAR(15),
type VARCHAR(50),
approved DATE,
dob DATE,
age_create VARCHAR(3),
first_name VARCHAR(100),
last_name VARCHAR(100),
address_01 VARCHAR(150),
address_02 VARCHAR(150),
country VARCHAR(50),
state VARCHAR(50),
city VARCHAR(50),
zip CHAR(12),
referring_user VARCHAR(15),
referring_code VARCHAR(100),
terms_accept VARCHAR(3),
terms_initials VARCHAR(5),
terms_date DATE,
rate VARCHAR(5),
PRIMARY KEY (id),
INDEX (`tec_id` ASC),
INDEX (`city` ASC),
INDEX (`type` ASC)
) ENGINE=MyISAM;";
|
|---|