forked from COP4331-Group20-Sum2021/ContactManager
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertion.sql
14 lines (12 loc) · 1.16 KB
/
insertion.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
/* Insert new users in the database. */
/* Used for the register API */
INSERT INTO users (firstname,lastname,login,password) VALUES ('Nate','Wilk','N8','abc123');
INSERT INTO users (firstname,lastname,login,password) VALUES ('John','Doe','jdoe','abc123');
INSERT INTO users (firstname,lastname,login,password) VALUES ('Cool','Joe','cjoe','abc123');
/* Insert new contacts in the database. */
/* Used for the add contacts API */
INSERT INTO contacts (firstname,lastname,userid,phone,email,description) VALUES ('Cool','Guy',1,'999999999','[email protected]','dude I met at the park');
INSERT INTO contacts (firstname,lastname,userid,phone,email,description) VALUES ('Ice','Cream',1,'888888888','[email protected]','Free ice cream treats');
INSERT INTO contacts (firstname,lastname,userid,phone,email,description) VALUES ('BBQ','Guy',1,'777777777','[email protected]','BBQ Social');
INSERT INTO contacts (firstname,lastname,userid,phone,email,description) VALUES ('Cool','Guy',2,'999999999','[email protected]','dude I met at the park');
INSERT INTO contacts (firstname,lastname,userid,phone,email,description) VALUES ('Cool','Guy',3,'999999999','[email protected]','dude I met at the park');