==================================================
                    SQL QuickRegister - March 15, 2007
              ==================================================

Date Tables
-----------
1. register
   username     varchar(127) not null,
   email        varchar(100),
   lastname     varchar(40),
   firstname    varchar(25),
   company      varchar(100),
   address1     varchar(40),
   address2     varchar(40),
   city         varchar(40),
   state        varchar(40),
   state2       varchar(40),
   zip          varchar(10),
   country      varchar(150),
   instantmsgid varchar(100),
   phone        varchar(20),
   cell         varchar(20),
   fax          varchar(20),
   website      varchar(255),
   blog         varchar(255),
   description1 varchar(255),
   description2 varchar(255),
   description3 varchar(255),
   description4 varchar(255),
   description5 varchar(255),
   description6 varchar(255),
   description7 varchar(255),
   description8 varchar(255),
   description9 varchar(255),
   description10 varchar(255),
   registerdate date,
   updatedate   date,
   activatedate date,
   expirydate   date,
   grp         varchar(255),
   password    varchar(20),
   timein      int,
   ipfootprint varchar(255),
   sessionkey  varchar(60),
   uniqueid    varchar(60),
   activate    tinyint,
   trans_id    varchar(20),
   amount_paid float(8,2),
   txn_id      varchar(40),
   status      tinyint


MANDATORY FIELDS
-----------------
username, email, lastname, firstname, registerdate, updatedate, activatedate,
expirydate, password, timein, activate

OPTIONAL FIELDS
-----------------
address, city, state, zip, country, phone, fax, cell, instantmsgid, etc..



2. recovery
      username    varchar(20) not null,
      password    varchar(20),
      reminder    varchar(40)
      
      
3. loginstats 
      username    varchar(20) not null,
      login_date  date,
      login_time  time 

4. paypal_transactions 
      rec_id  int unsigned auto_increment not null primary key,
      txn_id          varchar(40) not null,
      orderdate       date not null,
      ordertime       time not null,
      first_name      varchar(64),
      last_name       varchar(64),
      address_street  varchar(200),
      address_city    varchar(40),
      address_state   varchar(40),
      address_zip     varchar(40),
      address_country varchar(64),
      address_country_code varchar(2),
      address_name    varchar(128),
      address_status  varchar(15),
      business        varchar(127),
      charset         varchar(100),
      custom          varchar(255),
      invoice         varchar(127),
      mc_currency     varchar(3),
      mc_fee          float(9,2),
      mc_gross        float(9,2),
      mc_handling     float(9,2),
      mc_shipping     float(9,2),
      exchange_rate   float(9,2),
      settle_amount   float(9,2),
      settle_currency varchar(3),
      notify_version  varchar(6),
      num_cart_items  int,
      payer_business_name varchar(127),
      payer_email     varchar(127),
      payer_id        varchar(13),
      payer_status    varchar(15),
      payment_date    varchar(40),
      payment_fee     float(9,2),
      payment_gross   float(9,2),
      payment_status  varchar(15),
      payment_type    varchar(15),
      pending_reason  varchar(20),
      reason_code     varchar(20),
      receiver_email  varchar(127),
      receiver_id     varchar(13),
      amt             float(9,2),
      cc              varchar(3),
      cm              varchar(255),
      residence_country varchar(2),
      st              varchar(40),
      tx              varchar(40),
      sig             blob,
      txn_type        varchar(15),
      verify_sign     varchar(255),
      item_number     varchar(127),
      item_name       varchar(127),
      quantity        int,
      item_cost       float(9,2),
      shipping        float(9,2),
      tax             float(9,2),
      handling        float(9,2),
      memo            varchar(255) )");

6.invalid_paypal_transactions 
      rec_id  int unsigned auto_increment not null primary key,
      reason          varchar(255),
      txn_id          varchar(40) not null,
      orderdate       date not null,
      ordertime       time not null,
      first_name      varchar(64),
      last_name       varchar(64),
      address_street  varchar(200),
      address_city    varchar(40),
      address_state   varchar(40),
      address_zip     varchar(40),
      address_country varchar(64),
      address_country_code varchar(2),
      address_name    varchar(128),
      address_status  varchar(15),
      business        varchar(127),
      charset         varchar(100),
      custom          varchar(255),
      invoice         varchar(127),
      mc_currency     varchar(3),
      mc_fee          float(9,2),
      mc_gross        float(9,2),
      mc_handling     float(9,2),
      mc_shipping     float(9,2),
      exchange_rate   float(9,2),
      settle_amount   float(9,2),
      settle_currency varchar(3),
      notify_version  varchar(6),
      num_cart_items  int,
      payer_business_name varchar(127),
      payer_email     varchar(127),
      payer_id        varchar(13),
      payer_status    varchar(15),
      payment_date    varchar(40),
      payment_fee     float(9,2),
      payment_gross   float(9,2),
      payment_status  varchar(15),
      payment_type    varchar(15),
      pending_reason  varchar(20),
      reason_code     varchar(20),
      receiver_email  varchar(127),
      receiver_id     varchar(13),
      amt             float(9,2),
      cc              varchar(3),
      cm              varchar(255),
      residence_country varchar(2),
      st              varchar(40),
      tx              varchar(40),
      sig             blob,
      txn_type        varchar(15),
      verify_sign     varchar(255),
      item_number     varchar(127),
      item_name       varchar(127),
      quantity        int,
      item_cost       float(9,2),
      shipping        float(9,2),
      tax             float(9,2),
      handling        float(9,2),
      memo            varchar(255)

7. admin 
   username  varchar(20),
   sessionkey  varchar(60),
   uniqueid    varchar(60)