CREATE TABLE users (
userID MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username char(32) NOT NULL default '',
password char(32) NOT NULL default '',
email char(40) NOT NULL default '',
name char(40) NOT NULL default '',
address text NOT NULL default '',
hp char(30) NOT NULL default '',
office char(30) NOT NULL default '',
home char(30) NOT NULL default '',
postcode num(7) NOT NULL default '',
state char(30) NOT NULL default '',
level char(20) NOT NULL default '',
status char(30) NOT NULL default '',
agent char(30) NOT NULL default '',
rquestion char(100) NOT NULL default '',
ranswer char(30) NOT NULL default '',
price1 char(10) NOT NULL default '20',
price2 char(10) NOT NULL default '30',
price3 char(10) NOT NULL default '60'
);

CREATE TABLE company (
companyID MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name char(32) NOT NULL default '',
address char(10) NOT NULL default '',
item char(40) NOT NULL default '',
city char(50) NOT NULL default '',
no char(20) NOT NULL default ''
);