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',	'FALSE',	null);
INSERT INTO "Friends" VALUES (
2,	'Randy',	'Savage',	'FALSE',	null);
INSERT INTO "Friends" VALUES (
3,	'Monty',	'Python',	'FALSE',	1);
INSERT INTO "Friends" VALUES (
4,	'Tom',  	'Hanks',	'TRUE',         null);