All pastes #63741 Raw Edit

Mine

public sql v1 · immutable
#63741 ·published 2006-06-10 15:29 UTC
rendered paste body
-- # 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 BrownDomain: UnixQType: MultiChoiceQURL: URL for questionQuestion: Is there life on Mars?X1: Yes, Little Green MenX2: Yes, Little Green Women3: Yes, My Favorite Martian4: Yes, Ugly Squids5: 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 GreenDomain: InstallQType: MultiChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What  kind of chocolate do you like?1: Hersheys2: Sanders3: SwissX4: 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 BlueDomain: SecurityQType: MultiChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What kind of food do you like?1: PeasX2: Carrots3: Lettuce4: 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 RedDomain: InstallQType: MultiChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What  kind of drinks do you like?1: Water2: CoffeeX3: Beer4: 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 BrownDomain: InstallQType: MultiChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What  kind of cars do you like?1: Sports Car2: SedanX3: Race CarX4: 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 BrownDomain: UsersQType: RadioChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What  kind of women do you like?1: Intelligent2: Good Looking3: Low Maintenance4: HonestX5: 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 BrownDomain: NETWORKQType: MultiChoiceQURL: http://foo.bar.baz/image1.pngQuestion: What  kind of travels do you like?X1: Walks2: Road Trips3: Airline Flights4: 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 BlackDomain: UnixQType: YesNoQURL: http://foo.bar.baz/image1.pngQuestion: Do you like BSD?X1: Yes2: 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 PurpleDomain: UnixQType: TrueFalseQURL: http://foo.bar.baz/image1.pngQuestion: BSD is the best operating system.X1: True2: 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"    );-- =========================================================================