db_schema.sql

-- CREATE TABLE contacts(
--                       id serial PRIMARY KEY NOT NULL,
--                       fname VARCHAR(50) NOT NULL,
--                       lname VARCHAR(50) NOT NULL,
--                       email VARCHAR(50) NOT NULL
--                       );


CREATE TABLE phones(
                     id serial PRIMARY KEY NOT NULL,
                     contac_id INTEGER NOT NULL,
                     type VARCHAR(40) ,
                     num VARCHAR(40) NOT NULL
);

  

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Anderson', 'Saunders', 'andsbf@gmail.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Paula', 'Saunders', 'Paula@gmail.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Banana', 'Fruit', 'Banana@split.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Apple', 'Fruit', 'apple@fruit.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Apple', 'INC', 'apple@inc.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Onion', 'Purple', 'onion@purple.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Kiwi', 'California', 'kiwi@domain.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Mushroom', 'hippie', 'm.h@peace.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Potate', 'vegetables', 'french@fries.com');

-- INSERT INTO contacts(fname, lname, email) 
--   VALUES('Ham', 'cheese', 'hot@sandwich.com');