All pastes #63738 Raw Edit

Miscellany

public text v1 · immutable
#63738 ·published 2006-06-10 15:16 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 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"
    );
-- =========================================================================