by jm511 Cc

DROP TABLE IF EXISTS submits;
CREATE TABLE submits (
   id_submit int(11) NOT NULL auto_increment,
   company_name varchar(255) NOT NULL,
   contact_name varchar(255) NOT NULL,
   address text NOT NULL,
   city varchar(255) NOT NULL,
   state varchar(255) NOT NULL,
   zip varchar(255) NOT NULL,
   phone varchar(255) NOT NULL,
   fax varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   website varchar(255) NOT NULL,
   logo_name varchar(255) NOT NULL,
   logo_filename varchar(255) NOT NULL,
   submitted_by varchar(255) NOT NULL,
   title_submitted text NOT NULL,
   email_submitted varchar(255) NOT NULL,
   date_submitted varchar(255) NOT NULL,
   mpay varchar(255) NOT NULL,
   card_type varchar(255) NOT NULL,
   card_number varchar(255) NOT NULL,
   card_date varchar(255) NOT NULL,
   price varchar(255) NOT NULL,
   submission_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   KEY id_submit (id_submit)
);

INSERT INTO submits VALUES('1', 'Home company', 'George Hanu', 'Iasi Rozelor', 'Iasi', 'Moldova', '72001', '(123)456-789', '(12)34-56', '[email protected]', 'hp.media-sun.ro', '5ae9bde32933a6752333a7a26a2aa98e.jpg', '87621DjLI_w.jpg', 'Hanu pompiliu', 'Eclipse', '[email protected]', 'astazi', 'CreditCard', 'Visa', '123456789012', '12/13/09', '400', '2008-08-06 13:50:02');
INSERT INTO submits VALUES('2', 'cname1', 'conname1', 'address2', 'city2', 'state2', 'zip2', '(123;)456;-789;', '(1234;)567;-890;', '[email protected];', 'website;', '', '', '', '', '', '', 'CreditCard', 'AmEx', '1234567890121;', '12/13/09;', '150', '2008-08-08 15:30:03');
INSERT INTO submits VALUES('3', 'EdgellTEST', 'Scott Ernst - TEST', '4 Middlebury Blvd.', 'Randolph', 'NJ', '07869', '(973)607-1316', '(973)607-1395', '[email protected]', 'www.edgellcommunications.com', '', '', '', '', '', '', 'Invoice', '', '', '', '200', '2008-08-08 17:39:23');