Alt1 BASE TABLE MyISAM
indexA1 int(11) NO MUL auto_increment
pagetype char(40) NO
textpage text YES

Alt2 BASE TABLE MyISAM
indexA2 int(11) NO MUL auto_increment
pagetype char(40) NO
textpage text YES

Alt3 BASE TABLE MyISAM
indexA3 int(11) NO MUL auto_increment
pagetype char(40) NO PRI
textpage text YES

Alt4 BASE TABLE MyISAM
indexA4 int(11) NO MUL auto_increment
pagetype char(40) NO
textpage text YES

H1 BASE TABLE MyISAM
indexH1 int(10) NO PRI auto_increment
pagetype char(20) NO
textpage varchar(400) YES

H2 BASE TABLE MyISAM
indexH2 int(10) NO PRI auto_increment
pagetype char(30) NO
textpage varchar(400) YES

H3 BASE TABLE MyISAM
IndexH3 int(10) NO PRI auto_increment
pagetype char(30) NO
textpage varchar(400) YES

Master BASE TABLE MyISAM
mastind int(5) NO PRI auto_increment
company varchar(30) NO
emailnotify varchar(30) NO
emailpaypal varchar(30) NO
emailcc varchar(30) NO
paytype char(1) NO
logintype char(1) NO
items varchar(1) NO
url varchar(30) NO
masttest varchar(1) NO
contactphone varchar(40) NO
register varchar(1) NO
news varchar(1) NO
talks varchar(1) NO
tours varchar(1) NO
text varchar(1) NO
phototext varchar(1) NO
tabs varchar(1) NO
photos varchar(1) NO
H1 varchar(1) NO
H2 varchar(1) NO
H3 varchar(1) NO
Alt1 varchar(1) NO
Alt2 varchar(1) NO
Alt3 varchar(1) NO
Ext4 varchar(1) NO
urlphotos varchar(40) NO

MetaKeywords BASE TABLE MyISAM
indexMK int(10) NO PRI auto_increment
pagetype char(20) NO
keyword varchar(400) YES

MetaTitles BASE TABLE MyISAM
indexMT int(10) NO PRI auto_increment
pagetype char(20) NO
textpage varchar(300) YES

T1 BASE TABLE MyISAM
indexT1 int(10) NO PRI auto_increment
pagetype char(20) NO
textnum int(5) NO
textpage varchar(3000) YES

Titles BASE TABLE MyISAM
indexT int(10) NO PRI auto_increment
pagetype char(30) NO
textpage varchar(300) YES

photos BASE TABLE InnoDB
indexP int(10) NO PRI auto_increment
pagetype varchar(20) NO
textnum int(5) NO
photo_n varchar(20) NO
photo_d varchar(200) YES
photo_ld varchar(600) NO
photo_id varchar(80) YES
photo varchar(3) NO

test_table BASE TABLE MyISAM
col1 int(11) YES
col2 varchar(40) YES
col3 smallint(6) YES
col4 timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP

users BASE TABLE MyISAM
user_id int(10) unsigned NO PRI auto_increment
email varchar(40) NO UNI
pass varchar(40) NO
first_name varchar(15) NO
last_name varchar(30) NO
active varchar(32) YES
registration_date datetime NO 0000-00-00 00:00:00
user_country char(3) YES
TestFlag char(1) YES