#
# mSQL Dump  (requires mSQL-1.0.6 or better)
#
# Host: localhost    Database: camelcityC
#--------------------------------------------------------


#
# Table structure for table 'ads'
#
CREATE TABLE ads (
  Ad_ID CHAR(30) NOT NULL PRIMARY KEY,
  Creation_Date INT,
  Expire_Date INT,
  First_name CHAR(15),
  Last_name CHAR(15),
  Address_1 CHAR(25),
  Address_2 CHAR(25),
  City CHAR(25),
  State CHAR(15),
  Country CHAR(15),
  Zip CHAR(15),
  E_mail_1 CHAR(35),
  Telephone_1 CHAR(15),
  Fax CHAR(15),
  Personal_web CHAR(45),
  Ad_type CHAR(25),
  Text_for_ad CHAR(256),
  Remote_host CHAR(128),
  I_name CHAR(1),
  I_address CHAR(1),
  I_telephone_1 CHAR(1),
  I_fax CHAR(1),
  I_e_mail_1 CHAR(1),
  I_web CHAR(1)
) \g