
create table users (
userid int auto_increment primary key,
 username char(25) not null, 
password char(255) not null,
 companyname char(255) not null,
  contactname char(255) not 
null, email char(255) not null,
 baddress1 char(255) not null,
  baddress2 char(255) not null, 
bcity char(255) not null,
 bstate char(50) not null,
  bzip char(50) not null,
   saddress1 char(255) not null,
    saddress2 char(255) not null,
     scity char(255) not null,
      sstate char(25) not null, szip 
char(50) not null,
 tel char(255) not null,
  fax char(255) not null,
   active tinyint,
    ccname char(255) not null,
     cctype tinyint not null,
      ccnum char(255) not null,
       expdate char(255) not null,
        scountry char(255) not null,
         bcountry char(255) not null,
          discount decimal(5,4),
           needsvalidation tinyint not null,
            taxexempt tinyint not null, terms int not null); 
create table sessions (
	sessionid int auto_increment primary key,
	 userid int,
	  ipaddress char (255) not null,
	   created timestamp,
	    returnpage char(255) not null); 
