
INSERT INTO `forms` (`id`, `username`, `title`, `height`, `status`) VALUES 
(7422922882, 'starter', 'Contact Us', 367, 'Enabled'),
(7434127882, 'starter', 'Suggest Website', 370, 'Enabled'),
(7434622882, 'starter', 'Job Application', 467, 'Enabled'),
(7430244882, 'starter', 'Reservation', 306, 'Enabled'),
(7430615882, 'starter', 'Satisfaction Survey', 452, 'Enabled'),
(7433124882, 'starter', 'Membership Registration', 402, 'Enabled'),
(7431838882, 'starter', 'Party RSVP', 404, 'Enabled'),
(7434425882, 'starter', 'Wedding Attendance', 386, 'Enabled'),
(7435627882, 'starter', 'Submit Product', 389, 'Enabled'),
(7914831882, 'starter', 'Bug Tracker', 479, 'Enabled'),
(7915625882, 'starter', 'Time Sheet', 306, 'Enabled'),
(7911101882, 'starter', 'Blank Form', 168, 'Enabled');

INSERT INTO `monthly_usage` (`username`, `submissions`, `ssl_submissions`, `payments`, `uploads`, `tickets`) VALUES 
('starter', 0, 0, 0, 0, 0);
INSERT INTO `monthly_usage` (`username`, `submissions`, `ssl_submissions`, `payments`, `uploads`, `tickets`) VALUES 
('test', 0, 0, 0, 0, 0);

INSERT INTO `question_properties` (`form_id`, `question_id`, `prop`, `value`) VALUES 
(7434425882, 999, 'email', 'yes'),
(7434425882, 999, 'email_addr', ''),
(7431838882, 2, 'text', 'First Name:'),
(7431838882, 3, 'text', 'Last Name:'),
(7430244882, 999, 'fontcolor', 'black'),
(7430244882, 999, 'theme', 'Default'),
(7431838882, 999, 'fontsize', '12'),
(7430244882, 3, 'text', 'E-mail:'),
(7430244882, 999, 'font', 'Verdana'),
(7430244882, 6, 'required', 'yes'),
(7430244882, 999, 'alignment', 'default'),
(7430244882, 999, 'background', 'white'),
(7430244882, 999, 'email', 'yes'),
(7430244882, 999, 'email_addr', ''),
(7431838882, 999, 'background', 'white'),
(7430244882, 999, 'fontsize', '12'),
(7430615882, 8, 'text', 'Customer Service:'),
(7430615882, 2, 'text', 'Name: (optional)'),
(7430615882, 4, 'text', 'E-mail:  (optional)'),
(7430615882, 7, 'options', 'Very Satisfied<br>Satisfied<br>Neither satisfied nor unsatisfied<br>Unsatisfied<br>Very Unsatisfied'),
(7430615882, 9, 'text', 'Comments:'),
(7435627882, 10, 'desc', ''),
(7434425882, 7, 'text', 'Number of children:'),
(7435627882, 10, 'columns', '10'),
(7435627882, 10, 'rows', '5'),
(7435627882, 6, 'text', 'Volume Discount'),
(7435627882, 10, 'text', 'Sizes'),
(7435627882, 1, 'text', ''),
(7435627882, 3, 'size', '5'),
(7435627882, 6, 'options', 'Yes <br>No'),
(7434425882, 1, 'text', ''),
(7434425882, 5, 'options', 'can attend <br>can\\''t attend<br>'),
(7435627882, 10, 'validation', 'no'),
(7435627882, 2, 'text', 'Product Name'),
(7435627882, 9, 'text', 'Description (Optional)'),
(7435627882, 3, 'text', 'Price'),
(7430615882, 1, 'text', ''),
(7434127882, 3, 'required', 'yes'),
(7434127882, 6, 'required', 'yes'),
(7434127882, 7, 'options', 'Arts<br>Business<br>Education<br>Entertainment<br>Family<br>Finance<br>Games<br>Government<br>Health<br>Home & Living<br>International<br>News<br>Portal<br>Regional/Local<br>Science<br>Shopping<br>Society & Culture<br>Sports<br>Technology<br>Travel<br>Other'),
(7435627882, 10, 'layout', 'Horizontal'),
(7431838882, 999, 'email', 'yes'),
(7430244882, 5, 'text', 'Date:'),
(7435627882, 999, 'background', 'white'),
(7435627882, 999, 'font', 'Verdana'),
(7434425882, 999, 'theme', 'Default'),
(7434425882, 999, 'fontcolor', 'black'),
(7434425882, 999, 'font', 'Verdana'),
(7434425882, 999, 'fontsize', '12'),
(7434425882, 999, 'alignment', 'default'),
(7434425882, 6, 'options', '1<br>2<br>3<br>4<br>5<br>more'),
(7434425882, 999, 'disabled', 'Enabled'),
(7422922882, 999, 'spamcheck', 'Disabled'),
(7422922882, 6, 'required', 'yes'),
(7911101882, 1, 'text', ''),
(7430244882, 2, 'text', 'Name:'),
(7434425882, 7, 'options', '1<br>2<br>3<br>4<br>5<br>more'),
(7434127882, 0, 'required', 'yes'),
(7430615882, 7, 'text', 'Product Quality:'),
(7430244882, 6, 'text', 'Phone:'),
(7435627882, 10, 'required', 'no'),
(7434127882, 2, 'text', 'Name:'),
(7434127882, 0, 'text', 'E-mail:'),
(7434127882, 3, 'text', 'Web Site Name:'),
(7434127882, 6, 'text', 'Web Site URL:'),
(7431838882, 5, 'options', '1<br>2<br>3<br>4<br>5<br>6<br>7<br>8<br>9<br>10 or more'),
(7430244882, 3, 'required', 'yes'),
(7430244882, 2, 'required', 'yes'),
(7430244882, 7, 'text', 'Additional Comments:'),
(7430244882, 1, 'text', ''),
(7434425882, 6, 'text', 'Number of Adults:'),
(7434425882, 4, 'text', 'Message to the Bride and Groom'),
(7434425882, 3, 'text', 'E-mail:'),
(7434425882, 0, 'text', 'First Name:'),
(7434425882, 2, 'text', 'Last Name:'),
(7434425882, 5, 'text', 'Attendance:'),
(7433124882, 999, 'email_addr', ''),
(7433124882, 999, 'fontcolor', 'black'),
(7433124882, 999, 'theme', 'Default'),
(7433124882, 2, 'required', 'yes'),
(7433124882, 3, 'required', 'yes'),
(7433124882, 8, 'special', 'US States'),
(7433124882, 999, 'fontsize', '12'),
(7433124882, 999, 'email', 'yes'),
(7433124882, 4, 'text', 'Country:'),
(7433124882, 1, 'text', ''),
(7434127882, 7, 'text', 'Category:'),
(7434127882, 4, 'text', 'Other Category:'),
(7434127882, 5, 'text', 'Description:'),
(7434127882, 1, 'text', ''),
(7434127882, 2, 'required', 'yes'),
(7434127882, 0, 'maxsize', '100'),
(7422922882, 999, 'conf_body', 'Thanks for submitting our form, we will get back to you as soon as possible.'),
(7422922882, 0, 'text', 'First Name:'),
(7422922882, 8, 'required', 'yes'),
(7422922882, 0, 'validation', 'no'),
(7422922882, 999, 'disabled', 'Enabled'),
(7422922882, 1, 'text', 'E-mail:'),
(7422922882, 0, 'required', 'yes'),
(7422922882, 1, 'required', 'yes'),
(7435627882, 999, 'fontsize', '12'),
(7422922882, 2, 'text', 'Phone:'),
(7422922882, 6, 'text', 'Your Message:'),
(7422922882, 7, 'text', ''),
(7911101882, 4, 'text', 'Drag and drop questions from the right side to create your form.'),
(7422922882, 6, 'columns', '35'),
(7422922882, 0, 'size', '20'),
(7422922882, 6, 'rows', '5'),
(7434425882, 2, 'required', 'yes'),
(7434425882, 0, 'required', 'yes'),
(7434425882, 5, 'required', 'yes'),
(7435627882, 999, 'alignment', 'default'),
(7435627882, 999, 'theme', 'Default'),
(7435627882, 999, 'fontcolor', 'black'),
(7435627882, 999, 'email', 'yes'),
(7435627882, 999, 'email_addr', ''),
(7435627882, 999, 'disabled', 'Enabled'),
(7422922882, 999, 'conf_send', 'no'),
(7434425882, 999, 'background', 'white'),
(7914831882, 999, 'disabled', 'Enabled'),
(7914831882, 999, 'fontcolor', 'black'),
(7914831882, 999, 'email', 'yes'),
(7914831882, 999, 'email_addr', ''),
(7434622882, 999, 'disabled', 'Enabled'),
(7434622882, 999, 'email', 'yes'),
(7434622882, 999, 'email_addr', ''),
(7434622882, 999, 'font', 'Verdana'),
(7434622882, 999, 'fontsize', '12'),
(7434622882, 999, 'theme', 'Default'),
(7434622882, 999, 'fontcolor', 'black'),
(7434622882, 14, 'text', 'Upload Resume'),
(7434622882, 1, 'text', ''),
(7434622882, 0, 'required', 'yes'),
(7434622882, 3, 'maxsize', '100'),
(7434622882, 3, 'required', 'yes'),
(7434622882, 6, 'size', '30'),
(7434622882, 12, 'columns', '35'),
(7434622882, 12, 'rows', '5'),
(7434622882, 14, 'extensions', 'doc, txt, rtf, pdf'),
(7434622882, 14, 'maxsize', '200'),
(7434622882, 999, 'alignment', 'default'),
(7434622882, 999, 'background', 'white'),
(7434622882, 12, 'text', 'Cover Letter'),
(7434622882, 13, 'text', 'When can you start?'),
(7434622882, 0, 'text', 'Name:'),
(7434622882, 3, 'text', 'E-mail:'),
(7434622882, 4, 'text', 'Telephone Number:'),
(7434622882, 8, 'text', 'Address:'),
(7434622882, 6, 'text', 'Applying for Position:'),
(7434127882, 999, 'alignment', 'default'),
(7434127882, 999, 'background', 'white'),
(7434127882, 999, 'font', 'Verdana'),
(7434127882, 999, 'fontsize', '12'),
(7434127882, 999, 'theme', 'Default'),
(7434127882, 999, 'fontcolor', 'black'),
(7434127882, 999, 'email', 'yes'),
(7434127882, 999, 'email_addr', ''),
(7434127882, 999, 'disabled', 'Enabled'),
(7430244882, 999, 'disabled', 'Enabled'),
(7430615882, 8, 'options', 'Very Satisfied<br>Satisfied<br>Neither satisfied nor unsatisfied<br>Unsatisfied<br>Very Unsatisfied'),
(7430615882, 999, 'alignment', 'default'),
(7430615882, 999, 'background', 'white'),
(7430615882, 999, 'font', 'Verdana'),
(7430615882, 999, 'fontsize', '12'),
(7430615882, 999, 'theme', 'Default'),
(7430615882, 999, 'fontcolor', 'black'),
(7430615882, 999, 'email', 'yes'),
(7430615882, 999, 'email_addr', ''),
(7430615882, 999, 'disabled', 'Enabled'),
(7914831882, 7, 'options', 'Windows Vista<br>Windows XP<br>Windows 2000<br>Mac OS X<br>Linux'),
(7433124882, 999, 'alignment', 'default'),
(7433124882, 999, 'background', 'white'),
(7433124882, 999, 'font', 'Verdana'),
(7433124882, 3, 'text', 'E-mail:'),
(7433124882, 9, 'text', 'Phone:'),
(7433124882, 10, 'text', 'Address:'),
(7433124882, 0, 'text', 'City:'),
(7433124882, 8, 'text', 'State:'),
(7433124882, 7, 'text', 'Zip code:'),
(7433124882, 2, 'text', 'Name:'),
(7914831882, 3, 'rows', '5'),
(7914831882, 999, 'alignment', 'default'),
(7914831882, 999, 'background', 'white'),
(7914831882, 999, 'font', 'Verdana'),
(7914831882, 999, 'fontsize', '12'),
(7914831882, 999, 'theme', 'Default'),
(7433124882, 999, 'disabled', 'Enabled'),
(7431838882, 999, 'font', 'Verdana'),
(7431838882, 1, 'text', ''),
(7431838882, 999, 'disabled', 'Enabled'),
(7431838882, 999, 'alignment', 'default'),
(7431838882, 999, 'email_addr', ''),
(7431838882, 999, 'fontcolor', 'black'),
(7431838882, 999, 'theme', 'Default'),
(7431838882, 6, 'text', 'Anything you want to add?'),
(7431838882, 4, 'text', 'E-mail:'),
(7431838882, 0, 'text', 'Phone Number:'),
(7431838882, 5, 'text', 'Number of people attending:'),
(7431838882, 8, 'text', 'What are the names of the other people coming, if any?'),
(7914831882, 6, 'options', 'Internet Explorer<br>Firefox<br>Opera<br>Safari<br>Other'),
(7914831882, 8, 'options', 'High<br>Medium<br>Low'),
(7914831882, 5, 'options', 'Bug<br>Feature Suggestion<br>Comment'),
(7914831882, 1, 'text', ''),
(7914831882, 5, 'text', 'Type:'),
(7914831882, 8, 'text', 'Priority:'),
(7914831882, 6, 'text', 'Browser:'),
(7914831882, 3, 'columns', '35'),
(7914831882, 3, 'text', 'Details:'),
(7914831882, 7, 'text', 'Operating System:'),
(7914831882, 0, 'text', 'Name:'),
(7914831882, 2, 'text', 'Email:'),
(7915625882, 0, 'text', 'Employee Name:'),
(7915625882, 2, 'text', 'Project:'),
(7915625882, 3, 'text', 'Date:'),
(7915625882, 4, 'text', 'Hours:'),
(7915625882, 5, 'text', 'Tasks:'),
(7915625882, 1, 'text', ''),
(7915625882, 4, 'size', '5'),
(7915625882, 999, 'alignment', 'default'),
(7915625882, 999, 'background', 'white'),
(7915625882, 999, 'font', 'Verdana'),
(7915625882, 999, 'fontsize', '12'),
(7915625882, 999, 'theme', 'Default'),
(7915625882, 999, 'fontcolor', 'black'),
(7915625882, 999, 'email', 'yes'),
(7915625882, 999, 'email_addr', ''),
(7915625882, 999, 'disabled', 'Enabled'),
(7422922882, 2, 'required', 'no'),
(7422922882, 999, 'not_subj', 'New Submission: {qForm Title}'),
(7422922882, 6, 'cols', '30'),
(7422922882, 8, 'desc', ''),
(7422922882, 8, 'validation', 'no'),
(7422922882, 0, 'maxsize', '100'),
(7422922882, 1, 'size', '20'),
(7422922882, 8, 'maxsize', '100'),
(7422922882, 999, 'fontcolor', 'black'),
(7422922882, 999, 'email_addr', ''),
(7422922882, 999, 'email', 'yes'),
(7911101882, 999, 'conf_body', 'Thanks for submitting our form, we will get back to you as soon as possible.'),
(7911101882, 999, 'conf_subj', 'Submission Received'),
(7422922882, 8, 'text', 'Last Name:'),
(7911101882, 1, 'clear', 'no'),
(7911101882, 1, 'submittext', 'Submit'),
(7911101882, 999, 'alignment', 'default'),
(7422922882, 999, 'font', 'Verdana'),
(7422922882, 999, 'fontsize', '12'),
(7422922882, 1, 'maxsize', '100'),
(7422922882, 1, 'validation', 'Email'),
(7422922882, 1, 'desc', ''),
(7422922882, 6, 'validation', 'no'),
(7422922882, 6, 'desc', ''),
(7911101882, 999, 'font', 'Verdana'),
(7422922882, 999, 'not_reply', ''),
(7911101882, 999, 'conf_send', 'no'),
(7911101882, 999, 'conf_from', ''),
(7422922882, 999, 'background', 'white'),
(7422922882, 0, 'desc', ''),
(7911101882, 999, 'background', 'white'),
(7422922882, 999, 'alignment', 'default'),
(7422922882, 8, 'size', '20'),
(7911101882, 999, 'fontsize', '12'),
(7911101882, 999, 'theme', 'Default'),
(7911101882, 999, 'fontcolor', 'black'),
(7911101882, 999, 'email', 'yes'),
(7911101882, 999, 'email_addr', ''),
(7911101882, 999, 'disabled', 'Enabled'),
(7911101882, 999, 'spamcheck', 'Disabled'),
(7911101882, 999, 'not_reply', ''),
(7911101882, 999, 'not_subj', 'New Submission: {qForm Title}'),
(7422922882, 999, 'conf_subj', 'Submission Received'),
(7422922882, 999, 'conf_from', ''),
(7422922882, 999, 'theme', 'Default');


INSERT INTO `questions` (`form_id`, `id`, `order`, `type`) VALUES 
(7430244882, 3, 1, 'control_textbox'),
(7433124882, 9, 2, 'control_textbox'),
(7430615882, 1, 5, 'control_button'),
(7430615882, 9, 4, 'control_textarea'),
(7430244882, 1, 5, 'control_button'),
(7434425882, 6, 5, 'control_dropdown'),
(7434425882, 7, 4, 'control_dropdown'),
(7435627882, 1, 5, 'control_button'),
(7435627882, 3, 2, 'control_textbox'),
(7435627882, 6, 3, 'control_radio'),
(7435627882, 10, 4, 'control_textarea'),
(7434425882, 3, 3, 'control_textbox'),
(7435627882, 9, 1, 'control_textarea'),
(7435627882, 2, 0, 'control_textbox'),
(7430615882, 8, 3, 'control_radio'),
(7430615882, 7, 2, 'control_radio'),
(7430615882, 4, 1, 'control_textbox'),
(7434425882, 2, 2, 'control_textbox'),
(7430615882, 2, 0, 'control_textbox'),
(7430244882, 7, 4, 'control_textarea'),
(7430244882, 5, 3, 'control_datetimepicker'),
(7433124882, 3, 1, 'control_textbox'),
(7434127882, 1, 7, 'control_button'),
(7434127882, 5, 6, 'control_textarea'),
(7434127882, 4, 5, 'control_textbox'),
(7434127882, 7, 4, 'control_dropdown'),
(7434127882, 6, 3, 'control_textbox'),
(7434127882, 3, 2, 'control_textbox'),
(7434127882, 0, 1, 'control_textbox'),
(7430244882, 6, 2, 'control_textbox'),
(7430244882, 2, 0, 'control_textbox'),
(7434425882, 0, 1, 'control_textbox'),
(7434425882, 5, 0, 'control_radio'),
(7431838882, 1, 7, 'control_button'),
(7434425882, 4, 6, 'control_textarea'),
(7431838882, 5, 4, 'control_dropdown'),
(7431838882, 8, 5, 'control_textarea'),
(7431838882, 0, 3, 'control_textbox'),
(7433124882, 10, 3, 'control_textarea'),
(7433124882, 0, 4, 'control_textbox'),
(7433124882, 8, 5, 'control_dropdown'),
(7434127882, 2, 0, 'control_textbox'),
(7422922882, 1, 3, 'control_textbox'),
(7911101882, 4, 1, 'control_text'),
(7422922882, 0, 1, 'control_textbox'),
(7911101882, 1, 2, 'control_button'),
(7434425882, 1, 7, 'control_button'),
(7434622882, 12, 6, 'control_textarea'),
(7434622882, 13, 5, 'control_datetimepicker'),
(7434622882, 6, 4, 'control_textbox'),
(7434622882, 8, 3, 'control_textarea'),
(7434622882, 4, 2, 'control_textbox'),
(7434622882, 3, 1, 'control_textbox'),
(7434622882, 0, 0, 'control_textbox'),
(7434622882, 14, 7, 'control_fileupload'),
(7434622882, 1, 8, 'control_button'),
(7433124882, 2, 0, 'control_textbox'),
(7433124882, 7, 6, 'control_textbox'),
(7433124882, 4, 7, 'control_dropdown'),
(7433124882, 1, 8, 'control_button'),
(7431838882, 6, 6, 'control_textarea'),
(7431838882, 2, 0, 'control_textbox'),
(7431838882, 3, 1, 'control_textbox'),
(7431838882, 4, 2, 'control_textbox'),
(7914831882, 1, 7, 'control_button'),
(7914831882, 3, 6, 'control_textarea'),
(7914831882, 7, 5, 'control_dropdown'),
(7914831882, 6, 4, 'control_dropdown'),
(7914831882, 8, 3, 'control_radio'),
(7914831882, 5, 2, 'control_radio'),
(7914831882, 2, 1, 'control_textbox'),
(7914831882, 0, 0, 'control_textbox'),
(7915625882, 0, 0, 'control_textbox'),
(7915625882, 2, 1, 'control_textbox'),
(7915625882, 3, 2, 'control_datetimepicker'),
(7915625882, 4, 3, 'control_textbox'),
(7915625882, 5, 4, 'control_textarea'),
(7915625882, 1, 5, 'control_button'),
(7422922882, 8, 2, 'control_textbox'),
(7422922882, 2, 4, 'control_textbox'),
(7422922882, 6, 5, 'control_textarea'),
(7422922882, 7, 6, 'control_button');


INSERT INTO `users` (`username`, `password`, `email`, `name`, `url`, `account_type`, `friends`, `is_html`, `creation_date`, `time_zone`) VALUES 
('starter', '324123455243432sdf', 'jotform@jotform.com', NULL, NULL, 'PREMIUM', '', 'yes', '0000-00-00', 0);

INSERT INTO `users` (`username`, `password`, `email`, `name`, `url`, `account_type`, `friends`, `is_html`, `creation_date`, `time_zone`) VALUES 
('test', 'test', 'jotform@jotform.com', NULL, NULL, 'PREMIUM', '', 'yes', '0000-00-00', 0);



