CREATE TABLE 'hvcPledge' ( 'createDate' DATE NOT NULL, 'last_name1' VARCHAR(50) NOT NULL, 'first_name1' VARCHAR(50) NOT NULL, 'middle_name1' VARCHAR(1), 'addr1_street' VARCHAR(65), 'addr1_city' VARCHAR(50), 'addr1_state' CHAR(2), 'addr1_zip' CHAR(10), 'addr1_h_phone' CHAR(29), 'addr1_e_mail' VARCHAR(65), 'last_Name2' VARCHAR(50), 'first_Name2' VARCHAR(50), 'middle_name2' VARCHAR(1), 'addr2_street' VARCHAR(65), 'addr2_city' VARCHAR(50), 'addr2_state' CHAR(2), 'addr2_zip' CHAR(10), 'addr2_h_phone' CHAR(29), 'addr2_e_mail' VARCHAR(65), 'first_name_c1' VARCHAR(50), 'grade1' CHAR(6), 'school1' CHAR(17), 'first_name_c2' VARCHAR(50), 'grade2' CHAR(6), 'school2' CHAR(17), 'first_name_c3' VARCHAR(50), 'grade3' CHAR(6), 'school3' CHAR(17), 'first_name_c4' VARCHAR(50), 'grade4' CHAR(6), 'school4' CHAR(17), 'first_name_c5' VARCHAR(50), 'grade5' CHAR(6), 'school5' CHAR(17), 'comments' TEXT, 'first_name_cp' VARCHAR(50), 'middle_name_cp' VARCHAR(1), 'last_name_cp' VARCHAR(50), PRIMARY KEY ('loginName') ) ; INSERT INTO member (loginName, password, createDate, lastName, firstName, street, city, state, zip, email, phone, fax) VALUES ("mmouse", "secret", "2008-07-04", "Mouse", "Mickey", "123 Main Street", "Disney Land", "CA", "90210", "mmouse@disney.com", "555-555-5551", "555-555-5552")