create table shopper ( idshopper int identity(1,1) NOT NULL, chrfirstname varchar(20) not null, chrlastname varchar(20) not null, chraddress varchar(20) not null, chrcity varchar(20) not null, chrstateprovince varchar(20) not null, chrconntry varchar(20) not null, chrzipcode varchar(20) not null, chrhomephone varchar(20) not null, chrofficephone varchar(20) not null, chrfax varchar(20) not null, chrmobile varchar(20) not null, chrbeeper varchar(20) not null, chremail varchar(20) not null, dtbirthday datetime default '0000-00-00' not null, dtentered datetime default '0000-00-00' not null, dtchanged datetime default '0000-00-00' not null, chrusername varchar(20) not null, chrpassword varchar(20) not null, chrpersonalquestion varchar(60) not null, intcookie int default '1' not null, primary key (idshopper) )
idshopper int identity(1,1) NOT NULL,
chrfirstname varchar(20) not null,
chrlastname varchar(20) not null,
chraddress varchar(20) not null,
chrcity varchar(20) not null,
chrstateprovince varchar(20) not null,
chrconntry varchar(20) not null,
chrzipcode varchar(20) not null,
chrhomephone varchar(20) not null,
chrofficephone varchar(20) not null,
chrfax varchar(20) not null,
chrmobile varchar(20) not null,
chrbeeper varchar(20) not null,
chremail varchar(20) not null,
dtbirthday datetime default '0000-00-00' not null,
dtentered datetime default '0000-00-00' not null,
dtchanged datetime default '0000-00-00' not null,
chrusername varchar(20) not null,
chrpassword varchar(20) not null,
chrpersonalquestion varchar(60) not null,
intcookie int default '1' not null,
primary key (idshopper) )