populate_users.sql

-- Populate user table
INSERT INTO user VALUES (
    88888888,
    'bholiday',
    'password123',
    'Billie',
    'Holiday',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    'Fall', 2018,
    'bholiday@gmail.com'
);

INSERT INTO user VALUES (
    99999999,
    'dkrall',
    'password123',
    'Diana',
    'Krall',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    'Fall', 2019,
    'dkrall@gmail.com'
);

INSERT INTO user VALUES (
    10101010,
    'bnarahari',
    'password123',
    'Bhagirath',
    'Narahari',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    NULL, NULL,
    'bnarahari@gmail.com'
);

INSERT INTO user VALUES (
    16161616,
    'gparmer',
    'password123',
    'Gabe',
    'Parmer',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    NULL, NULL,
    'gparmer@gmail.com'
);

INSERT INTO user VALUES (
    12121212,
    'hchoi',
    'password123',
    'Hyeong-Ah',
    'Choi',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    NULL, NULL,
    'hchoi@gmail.com'
);

INSERT INTO user VALUES (
    45454545,
    'jfisher',
    'password123',
    'Jason',
    'Fisher',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    100.00,
    0,
    0,
    0,
    NULL,
    0,
    NULL, NULL,
    'jfisher@gmail.com'
);

INSERT INTO user VALUES (
    43782859,
    'abroaddus',
    'password123',
    'Alex',
    'Broaddus',
    '43204 Wintergrove Dr',
    'Ashburn',
    'VA',
    20147,
    100.00,
    0, 0, 0, NULL, 0,
    NULL, NULL,
    'alexbroaddus1@gmail.com'
);

INSERT INTO user VALUES (
    23456789,
    'efitzgerald',
    'password123',
    'Ella',
    'Fitzgerald',
    '961 Mayflower Lane',
    'Oviedo',
    'FL',
    32765,
    0,
    0, 0, 0,
    NULL,
    1,
    'Fall', 2019,
    'efitzgerald@gmail.com'
);

INSERT INTO user VALUES (
    13131313,
    'avijay',
    'password123',
    'Arjun',
    'Vijay',
    '961 Mayflower Lane',
    'Oviedo',
    'FL',
    32765,
    0,
    0, 0, 0,
    NULL,
    1,
    NULL, NULL,
    'avijay@gmail.com'
);

INSERT INTO user VALUES (
    87654321,
    'ecassidy',
    'password123',
    'Eva',
    'Cassidy',
    '923 Briarwood Ave',
    'Elmhurst',
    'NY',
    11373,
    0.0,
    0, 0, 0,
    NULL,
    0,
    'Fall', 2017,
    'ecassidy@gmail.com'
);

INSERT INTO user VALUES (
    45678901,
    'jhendrix',
    'password123',
    'Jimi',
    'Hendrix',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    NULL,
    0,
    'Fall', 2017,
    'jhendrix@gmail.com'
);

INSERT INTO user VALUES (
    55555555,
    'pmccartney',
    'password123',
    'Paul',
    'McCartney',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    10101010,
    0,
    'Fall', 2017,
    'pmccartney@gmail.com'
);

INSERT INTO user VALUES (
    66666666,
    'gharrison',
    'password123',
    'George',
    'Harrison',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    16161616,
    0,
    'Fall', 2016,
    'gharrison@gmail.com'
);

INSERT INTO user VALUES (
    12345678,
    'snicks',
    'password123',
    'Stevie',
    'Nicks',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    NULL,
    0,
    'Fall', 2017,
    'snicks@gmail.com'
);

INSERT INTO user VALUES (
    77777777,
    'eclapton',
    'password123',
    'Eric',
    'Clapton',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    NULL,
    0,
    'Fall', 2012,
    'eclapton@gmail.com'
);

INSERT INTO user VALUES (
    34567890,
    'kcobain',
    'password123',
    'Kurt',
    'Cobain',
    '309 Brandywine St',
    'Saint Cloud',
    'MN',
    56301,
    100.0,
    0, 0, 0,
    NULL,
    0,
    'Fall', 2012,
    'kcobain@gmail.com'
);

INSERT INTO user(uid,username, password, fname, lname, street, city, state, zip) VALUES (
    55551111,
    'jLennon',
    'password123',
    'John',
    'Lennon',
    '2121 I St NW',
    'Washington',
    'DC',
    20052
);

INSERT INTO user(uid,username, password, fname, lname, street, city, state, zip) VALUES (
    66661111,
    'ringostar',
    'password123',
    'Ringo',
    'Star',
    '2121 I St NW',
    'Washington',
    'DC',
    20052
);

INSERT INTO user(uid,username, password, fname, lname, street, city, state, zip) VALUES (
    00001234,
    'lArmstrong',
    'password123',
    'Louis',
    'Armstrong',
    '2121 I St NW',
    'Washington',
    'DC',
    20052
);

INSERT INTO user VALUES (
    00001235,
    'afranklin',
    'password123',
    'Aretha',
    'Franklin',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    0,
    0,
    0,
    0,
    0,
    0,
    'Fall', 
    2017,
    'afranklin@gmail.com'
);

INSERT INTO user VALUES (
    00001236,
    'cSantana',
    'password123',
    'Carlos',
    'Santana',
    '2121 I St NW',
    'Washington',
    'DC',
    20052,
    0,
    0,
    0,
    0,
    0,
    0,
    'Fall', 
    2017,
    'cSantana@gmail.com'
);