seed.sql

-- populate categories
-- INSERT INTO categories(title) VALUES ('Category 1');
-- INSERT INTO categories(title) VALUES ('Category 2');
-- INSERT INTO categories(title) VALUES ('Category 3');
-- INSERT INTO categories(title) VALUES ('Others');

-- populate query_reports
-- INSERT INTO reports(title, description, query, user_id, category_id) VALUES ('Report 1', 'This is Report 1', 'SELECT * FROM data_source', 1, 1);
-- INSERT INTO reports(title, description, query, user_id, category_id) VALUES ('Report 2', 'This is Report 2', 'SELECT * FROM data_source', 1, 2);
-- INSERT INTO reports(title, description, query, user_id, category_id) VALUES ('Report 3', 'This is Report 3', 'SELECT * FROM data_source', 1, 3);

INSERT INTO students(name, gender, birthday, nationality) VALUES ('abigail', 'f', '2000-02-01', 'chinese');
INSERT INTO students(name, gender, birthday, nationality) VALUES ('laura', 'f', '2000-06-10', 'chinese');
INSERT INTO students(name, gender, birthday, nationality) VALUES ('suresh', 'm', '2000-05-15', 'indian');
INSERT INTO students(name, gender, birthday, nationality) VALUES ('kumar', 'm', '2000-05-24', 'malay');
INSERT INTO students(name, gender, birthday, nationality) VALUES ('siti', 'f', '2000-06-10', 'malay');