Table structure for table  oenummer 

CREATE TABLE oenummer (

  id int(11) NOT NULL auto_increment,

  sku char(8) default  0 ,

  oe_no char(15) default NULL,

  PRIMARY KEY  (id),

  KEY artnr (sku)

) TYPE=MyISAM;

   Table structure for table  users 

CREATE TABLE users (

  id int(11) NOT NULL auto_increment,

  firstname varchar(30) default NULL,

  lastname varchar(30) NOT NULL default   ,

  email varchar(100) NOT NULL default   ,

  company varchar(50) default NULL,

  street varchar(40) default NULL,

  zip varchar(12) default NULL,

  city varchar(40) default NULL,

  status int(1) NOT NULL default  1 ,

  solutation varchar(12) default NULL,

  loginname varchar(10) default NULL,

  password varchar(10) default NULL,

  telephon varchar(30) default NULL,

  fax varchar(40) default NULL,

  customer_no varchar(12) default NULL,

  PRIMARY KEY  (id),

  KEY name (lastname,firstname)

) TYPE=MyISAM;

   Table structure for table  shopping_cart 

CREATE TABLE shopping_cart (

  sc_id int(11) unsigned NOT NULL auto_increment,

  user_id int(11) unsigned default NULL,

  cnt int(10) unsigned default NULL,

  cat_id int(12) unsigned default NULL,

  status varchar(10) default NULL,

  PRIMARY KEY  (sc_id),

  UNIQUE KEY sc_id (sc_id)

 Chapter 5. Database porting 

121