DROP TABLE "Friends";
CREATE TABLE "Friends"
(
"FRIEND_ID" INTEGER not null primary key,
"FIRST_NAME" VARCHAR(30),
"LAST_NAME" VARCHAR(30),
"BEST_FRIEND" VARCHAR(5) default 'FALSE',
"CONTACT_ID" INTEGER,
CONSTRAINT CONTACT_ID_FK FOREIGN KEY (CONTACT_ID) REFERENCES "CONTACTS"(ID)
);
INSERT INTO "Friends" VALUES (
1, 'Paula', 'Abdul', 'UNTERMINATED STRING, null);
INSERT INTO "Friends" VALUES (
2, 'Randy', 'Savage', 'FALSE', null);
INSERT INTO "Friends" VALUES (
3, 'Monty', 'Python', 'FALSE', 1);