CREATE TABLE REGISTRATION_2009 (
  ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  FIRST_NAME VARCHAR(20),
  LAST_NAME VARCHAR(30),
  REGISTRANT_TYPE VARCHAR(25),
  SCREEN_NAME VARCHAR(50),
  EMAIL VARCHAR(75),
  CITY VARCHAR(30),
  STATE VARCHAR(2),
  ZIP VARCHAR(7),
  PHONE VARCHAR(15),
  CAR_YEAR INT,
  CAR_MODEL VARCHAR(20),
  CAR_COLOR VARCHAR(30),
  CAR_SHOW INT,
  CAR_SHOW_GEN VARCHAR(10),
  CAR_SHOW_CLASS VARCHAR(25),
  CAR_SHOW_MODIFICATIONS  VARCHAR(100),
  PAYED  INT DEFAULT 0,
  DATE_ADDED TIMESTAMP
);

Give them a receipt on the thank you page.
Email them the receipt.


CREATE TABLE REGISTRATION_2009_PRODUCTS (
  REG_ID INT NOT NULL,
  PRODUCT_TYPE VARCHAR(50),
  PRODUCT_SIZE VARCHAR(4),
  DATE_ADDED TIMESTAMP
);

CREATE TABLE REGISTRATION_2009_MODELS (
  CAR_MODEL VARCHAR(20)
);


INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('240Z');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('260Z');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('280Z');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('280ZX');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('300ZX (Z31)');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('300ZX (Z32)');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('300ZX-TT');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('350Z');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('350Z Roadster');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('370Z');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('Fairlady Roadster');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('G35 Coupe');
INSERT INTO REGISTRATION_2009_MODELS (CAR_MODEL) VALUES ('G35 Sedan');


CREATE TABLE REGISTRATION_2009_CLASSES (
  CAR_CLASS VARCHAR(25),
  CAR_CLASS_DESC VARCHAR(200)
);

CREATE TABLE REGISTRATION_2009_REG_TYPES (
  ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  REG_TYPE_NAME VARCHAR(25),
  REG_TYPE_PRICE INT,
  REG_TYPE_DESC VARCHAR(500)
);


INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Full Access Primary',60,'<ul><li>2009 ZdayZ T-Shirt</li><li>Friday all day pass for all the day''s events and prizes</li><li>Friday night dinner</li><li>Saturday all day pass for all the day''s events and prizes</li><li>Saturday night dinner</li></ul>');
INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Full Access Guest',45,'Must be paid for with a Primary attendee<ul><li>Friday all day pass for all the day''s events and prizes</li><li>Friday night dinner</li><li>Saturday all day pass for all the day''s events and prizes</li><li>Saturday night dinner</li></ul>');

INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Friday Only Primary',35,'<ul><li>2009 ZdayZ T-Shirt</li><li>Friday all day pass for all the day''s events and prizes</li><li>Friday night dinner</li></ul>');
INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Friday Only Guest',20,'Must be paid for with a Primary attendee<ul><li>Friday all day pass for all the day''s events and prizes</li><li>Friday night dinner</li></ul>');

INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Saturday Only Primary',45,'<ul><li>2009 ZdayZ T-Shirt</li><li>Saturday all day pass for all the day''s events and prizes</li><li>Saturday night dinner</li></ul>');
INSERT INTO REGISTRATION_2009_REG_TYPES (REG_TYPE_NAME,REG_TYPE_PRICE,REG_TYPE_DESC) VALUES ('Saturday Only Guest',30,'Must be paid for with a Primary attendee<ul><li>Saturday all day pass for all the day''s events and prizes</li><li>Saturday night dinner</li></ul>');