Untitled

CREATE TABLE IF NOT EXISTS customerdb (
 id int UNIQUE AUTO_INCREMENT,
 account year_created smallint, year_id int auto_incremement, unique key(year_created, year_id)
 company varchar(45) not null default '',
 name varchar(45) not null default '',
 addr1 varchar(150) not null default '',
 addr2 varchar(150) null default '',
 city varchar(50) not null default '',
 state varchar(2) not null default '',
 zip varchar(12) null default '',
 email varchar(150) null default '',
 dayphone varchar(20) null default '000-000-0000',
 exten varchar(10) null default '',
 nightphone varchar(20) null default '000-000-0000',
 cctype varchar(20) null default '',
 cc varchar(20) null default '',
 expdate varchar(10) null default '0000-00-00 00:00:00',
 regdate timestamp NOT NULL default '0000-00-00 00:00:00',
 accountstat varchar(12) null default '',
 username varchar(25) null default '',
 password varchar(25) null default '',
 plan varchar(12) null default '',
 userplan varchar(12) null default '',
 balance varchar(12) null default '',
 timeused varchar(12) null default '',
 cronbill varchar(12) null default '',
 serial varchar(50) null default '',
 device varchar(50) null default '',
 ip varchar(20) null default '',
 protocol varchar(20) null default '',
 outgoingpriv varchar(20) null default '',
 did varchar(45) null default '',
 proxy varchar(12) null default '',
 softcap varchar(12) nulldefault '',
 featuresactive varchar(12) null default '',
 inactivenotes varchar(200) null default '',
 clientnotes varchar(200) null default ''
);