meetup-db.txt

CREATE TABLE students (
  id int NOT NULL auto_increment,
  first_name varchar(255),
  profession varchar(255),
  age int,
  gender varchar(255),
  PRIMARY KEY (id)
);

CREATE TABLE meetups (
  id int NOT NULL auto_increment,
  title varchar(255),
  PRIMARY KEY (id)
);

CREATE TABLE meetup_students (
    id int NOT NULL auto_increment,
    student_id int NOT NULL,
    meetup_id int NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (student_id) REFERENCES students(id),
    FOREIGN KEY (meetup_id) REFERENCES meetups(id)
);

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Ben', 'Designer', 30, 'M');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Sy', 'Accountant', 34, 'M');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Olivia', 'Student', 20, 'F');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Christine', 'IT', 29, 'F');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Michael', 'Micro Biologist', 34, 'M');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Hien', 'Marketer', 27, 'M');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Gabriel', 'Chemist', 36, 'M');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Sophia', 'IT', 25, 'F');

INSERT INTO students (first_name, profession, age, gender) 
VALUES ('Johnny', 'Marketer', 32, 'M');


INSERT INTO meetups (title)
VALUES ('Intro to HTML & CSS');

INSERT INTO meetups (title)
VALUES ('Intro to Ruby');

INSERT INTO meetups (title)
VALUES ('Intro to JavaScript');

INSERT INTO meetups (title)
VALUES ('Intro to Git & GitHub');


INSERT INTO meetup_students (student_id, meetup_id)
VALUES (1, 2);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (1, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (1, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (2, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (3, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (3, 2);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (3, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (3, 4);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (4, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (5, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (5, 2);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (5, 4);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (6, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (7, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (7, 2);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (7, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (8, 4);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (9, 1);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (9, 2);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (9, 3);

INSERT INTO meetup_students (student_id, meetup_id)
VALUES (9, 4);