-- # Start of Program -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 1 "Jim Brown", "Y", "Unix", "Sat Jun 10 11:09:23 2006", "MultiChoice ", "Is there life on Mars?", "URL for question", "Author: Jim Brown Domain: Unix QType: MultiChoice QURL: URL for question Question: Is there life on Mars? X1: Yes, Little Green Men X2: Yes, Little Green Women 3: Yes, My Favorite Martian 4: Yes, Ugly Squids 5: Yes, Mars Attacks! 6: No, "There is no life on Mars". ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "Yes, Little Green Men", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "Yes, Little Green Women", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "Yes, My Favorite Martian", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "Yes, Ugly Squids", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "Yes, Mars Attacks!", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 1 "1", "No, 'There is no life on Mars'.", "NO URLS YET", "N" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 2 "Jim Green", "Y", "Install", "Sat Jun 10 11:09:23 2006", "MultiChoice", "What kind of chocolate do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Green Domain: Install QType: MultiChoice QURL: http://foo.bar.baz/image1.png Question: What kind of chocolate do you like? 1: Hersheys 2: Sanders 3: Swiss X4: Ghiradellis ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 2 "2", "Hersheys", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 2 "2", "Sanders", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 2 "2", "Swiss", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 2 "2", "Ghiradellis", "NO URLS YET", "Y" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 3 "Jim Blue", "Y", "Security", "Sat Jun 10 11:09:23 2006", "MultiChoice", "What kind of food do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Blue Domain: Security QType: MultiChoice QURL: http://foo.bar.baz/image1.png Question: What kind of food do you like? 1: Peas X2: Carrots 3: Lettuce 4: Yohgurt ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 3 "3", "Peas", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 3 "3", "Carrots", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 3 "3", "Lettuce", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 3 "3", "Yohgurt", "NO URLS YET", "N" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 4 "Jim Red", "Y", "Install", "Sat Jun 10 11:09:23 2006", "MultiChoice", "What kind of drinks do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Red Domain: Install QType: MultiChoice QURL: http://foo.bar.baz/image1.png Question: What kind of drinks do you like? 1: Water 2: Coffee X3: Beer 4: Wine ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 4 "4", "Water", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 4 "4", "Coffee", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 4 "4", "Beer", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 4 "4", "Wine", "NO URLS YET", "N" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 5 "Jim Brown", "Y", "Install", "Sat Jun 10 11:09:23 2006", "MultiChoice", "What kind of cars do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Brown Domain: Install QType: MultiChoice QURL: http://foo.bar.baz/image1.png Question: What kind of cars do you like? 1: Sports Car 2: Sedan X3: Race Car X4: Tricycle ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 5 "5", "Sports Car", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 5 "5", "Sedan", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 5 "5", "Race Car", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 5 "5", "Tricycle", "NO URLS YET", "Y" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 6 "Jim Brown", "Y", "Users", "Sat Jun 10 11:09:23 2006", "RadioChoice", "What kind of women do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Brown Domain: Users QType: RadioChoice QURL: http://foo.bar.baz/image1.png Question: What kind of women do you like? 1: Intelligent 2: Good Looking 3: Low Maintenance 4: Honest X5: All of the Above ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 6 "6", "Intelligent", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 6 "6", "Good Looking", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 6 "6", "Low Maintenance", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 6 "6", "Honest", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 6 "6", "All of the Above", "NO URLS YET", "Y" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 7 "Jim Brown", "Y", "NETWORK", "Sat Jun 10 11:09:23 2006", "MultiChoice", "What kind of travels do you like?", "http://foo.bar.baz/image1.png", "Author: Jim Brown Domain: NETWORK QType: MultiChoice QURL: http://foo.bar.baz/image1.png Question: What kind of travels do you like? X1: Walks 2: Road Trips 3: Airline Flights 4: Stanley Steamer ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 7 "7", "Walks", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 7 "7", "Road Trips", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 7 "7", "Airline Flights", "NO URLS YET", "N" ); INSERT INTO answers VALUES ( NULL, -- 7 "7", "Stanley Steamer", "NO URLS YET", "N" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 8 "Jim Black", "Y", "Unix", "Sat Jun 10 11:09:23 2006", "YesNo", "Do you like BSD?", "http://foo.bar.baz/image1.png", "Author: Jim Black Domain: Unix QType: YesNo QURL: http://foo.bar.baz/image1.png Question: Do you like BSD? X1: Yes 2: No Steamer ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 8 "8", "Yes", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 8 "8", "No Steamer", "NO URLS YET", "N" ); -- ========================================================================= INSERT INTO questions VALUES ( NULL, -- 9 "Jim Purple", "Y", "Unix", "Sat Jun 10 11:09:23 2006", "TrueFalse", "BSD is the best operating system.", "http://foo.bar.baz/image1.png", "Author: Jim Purple Domain: Unix QType: TrueFalse QURL: http://foo.bar.baz/image1.png Question: BSD is the best operating system. X1: True 2: False ", "R", "Comments", "Forms", "Sat Jun 10 11:09:23 2006 - Initial Entry::" ); INSERT INTO answers VALUES ( NULL, -- 9 "9", "True", "NO URLS YET", "Y" ); INSERT INTO answers VALUES ( NULL, -- 9 "9", "False", "NO URLS YET", "N" ); -- =========================================================================