Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS "user" CASCADE;
- DROP TABLE IF EXISTS question CASCADE;
- DROP TABLE IF EXISTS "comment" CASCADE;
- DROP TABLE IF EXISTS private_message CASCADE;
- DROP TABLE IF EXISTS inbox CASCADE;
- DROP TABLE IF EXISTS notification CASCADE;
- DROP TABLE IF EXISTS message_notification CASCADE;
- DROP TABLE IF EXISTS question_notification CASCADE;
- DROP TABLE IF EXISTS moderator CASCADE;
- DROP TABLE IF EXISTS "admin" CASCADE;
- DROP TABLE IF EXISTS banned_user CASCADE;
- DROP TABLE IF EXISTS topic CASCADE;
- DROP TABLE IF EXISTS question_vote CASCADE;
- DROP TABLE IF EXISTS comment_vote CASCADE;
- DROP TABLE IF EXISTS achievement CASCADE;
- DROP TABLE IF EXISTS reward_item CASCADE;
- -- Tables
- CREATE TABLE "user" (
- id SERIAL NOT NULL,
- username text NOT NULL,
- email text NOT NULL,
- password text NOT NULL,
- imagePath text NOT NULL,
- creationDate TIMESTAMP WITH TIME zone NOT NULL,
- behaviorFlag BOOLEAN DEFAULT FALSE,
- experience FLOAT NOT NULL
- --is_admin BOOLEAN NOT NULL,
- --is_moderator BOOLEAN NOT NULL
- );
- CREATE TABLE question (
- id SERIAL NOT NULL,
- user_id INTEGER NOT NULL,
- topic_id INTEGER NOT NULL,
- title text NOT NULL,
- textContent text NOT NULL,
- dateCreated TIMESTAMP WITH TIME zone NOT NULL
- );
- CREATE TABLE "comment" (
- id SERIAL NOT NULL,
- question_id INTEGER NOT NULL,
- user_id INTEGER NOT NULL,
- textContent text NOT NULL,
- dateCreated TIMESTAMP WITH TIME zone NOT NULL
- );
- CREATE TABLE private_message (
- id SERIAL NOT NULL,
- sender_id INTEGER NOT NULL,
- receiver_id INTEGER NOT NULL,
- textContent text NOT NULL,
- dateCreated TIMESTAMP WITH TIME zone NOT NULL,
- seen BOOLEAN DEFAULT FALSE
- );
- CREATE TABLE inbox (
- user_id INTEGER NOT NULL
- );
- CREATE TABLE notification (
- id SERIAL NOT NULL,
- user_id INTEGER NOT NULL,
- seen BOOLEAN DEFAULT FALSE
- );
- CREATE TABLE message_notification (
- notification_id INTEGER NOT NULL,
- private_message_id INTEGER NOT NULL
- );
- CREATE TABLE question_notification (
- notification_id INTEGER NOT NULL,
- question_id INTEGER NOT NULL
- );
- CREATE TABLE moderator (
- user_id INTEGER NOT NULL
- );
- CREATE TABLE "admin" (
- user_id INTEGER NOT NULL
- );
- CREATE TABLE banned_user (
- user_id INTEGER NOT NULL,
- banDate TIMESTAMP WITH TIME zone NOT NULL
- );
- CREATE TABLE topic (
- id SERIAL NOT NULL,
- name text NOT NULL
- );
- CREATE TABLE question_vote (
- question_id INTEGER NOT NULL,
- user_id INTEGER NOT NULL,
- "value" INTEGER NOT NULL CHECK (("value" >= -1) AND ("value" <= 1))
- );
- CREATE TABLE comment_vote (
- comment_id INTEGER NOT NULL,
- user_id INTEGER NOT NULL,
- "value" INTEGER NOT NULL CHECK (("value" >= -1) AND ("value" <= 1))
- );
- CREATE TABLE achievement (
- id SERIAL NOT NULL,
- user_id INTEGER NOT NULL,
- title text NOT NULL,
- objective text NOT NULL,
- dateAchieved TIMESTAMP WITH TIME zone NOT NULL,
- completionFlag BOOLEAN DEFAULT FALSE,
- experienceGain INTEGER NOT NULL CHECK (experienceGain > 0)
- );
- CREATE TABLE reward_item (
- id SERIAL NOT NULL,
- achievement_id INTEGER NOT NULL,
- name text NOT NULL,
- imagePath text NOT NULL
- );
- -- Primary Keys and Uniques
- ALTER TABLE ONLY "user"
- ADD CONSTRAINT user_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY "user"
- ADD CONSTRAINT user_email_key UNIQUE (email);
- ALTER TABLE ONLY "user"
- ADD CONSTRAINT user_username UNIQUE (username);
- ALTER TABLE ONLY question
- ADD CONSTRAINT question_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY "comment"
- ADD CONSTRAINT comment_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY private_message
- ADD CONSTRAINT private_message_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY inbox
- ADD CONSTRAINT inbox_pkey PRIMARY KEY (user_id);
- ALTER TABLE ONLY notification
- ADD CONSTRAINT notification_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY message_notification
- ADD CONSTRAINT message_notification_pkey PRIMARY KEY (notification_id);
- ALTER TABLE ONLY question_notification
- ADD CONSTRAINT question_notification_pkey PRIMARY KEY (notification_id);
- ALTER TABLE ONLY moderator
- ADD CONSTRAINT moderator_pkey PRIMARY KEY (user_id);
- ALTER TABLE ONLY "admin"
- ADD CONSTRAINT admin_pkey PRIMARY KEY (user_id);
- ALTER TABLE ONLY banned_user
- ADD CONSTRAINT banned_user_pkey PRIMARY KEY (user_id);
- ALTER TABLE ONLY topic
- ADD CONSTRAINT topic_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY topic
- ADD CONSTRAINT topic_name UNIQUE (name);
- ALTER TABLE ONLY question_vote
- ADD CONSTRAINT question_vote_id_pkey PRIMARY KEY (question_id, user_id);
- ALTER TABLE ONLY comment_vote
- ADD CONSTRAINT comment_vote_id_pkey PRIMARY KEY (comment_id, user_id);
- ALTER TABLE ONLY achievement
- ADD CONSTRAINT achievement_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY achievement
- ADD CONSTRAINT achievement_title UNIQUE (title);
- ALTER TABLE ONLY reward_item
- ADD CONSTRAINT reward_item_pkey PRIMARY KEY (id);
- ALTER TABLE ONLY reward_item
- ADD CONSTRAINT reward_item_name UNIQUE (name);
- ALTER TABLE ONLY reward_item
- ADD CONSTRAINT reward_item_image_path UNIQUE (imagePath);
- -- Foreign Keys
- ALTER TABLE ONLY question
- ADD CONSTRAINT question_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY question
- ADD CONSTRAINT question_topic_id_fkey FOREIGN KEY (topic_id) REFERENCES topic(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY "comment"
- ADD CONSTRAINT comment_question_id_fkey FOREIGN KEY (question_id) REFERENCES question(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY "comment"
- ADD CONSTRAINT comment_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY private_message
- ADD CONSTRAINT private_message_sender_id_fkey FOREIGN KEY (sender_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY private_message
- ADD CONSTRAINT private_message_receiver_id_fkey FOREIGN KEY (receiver_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY inbox
- ADD CONSTRAINT inbox_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY notification
- ADD CONSTRAINT notification_inbox_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY message_notification
- ADD CONSTRAINT message_notification_id_fkey FOREIGN KEY (notification_id) REFERENCES notification(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY message_notification
- ADD CONSTRAINT message_notification_message_id_fkey FOREIGN KEY (private_message_id) REFERENCES private_message(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY question_notification
- ADD CONSTRAINT question_notification_id_fkey FOREIGN KEY (notification_id) REFERENCES notification(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY question_notification
- ADD CONSTRAINT question_notification_question_id_fkey FOREIGN KEY (question_id) REFERENCES question(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY moderator
- ADD CONSTRAINT moderator_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY "admin"
- ADD CONSTRAINT admin_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY banned_user
- ADD CONSTRAINT banned_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY question_vote
- ADD CONSTRAINT question_vote_question_id_fkey FOREIGN KEY (question_id) REFERENCES question(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY question_vote
- ADD CONSTRAINT question_vote_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY comment_vote
- ADD CONSTRAINT comment_vote_question_id_fkey FOREIGN KEY (comment_id) REFERENCES "comment" (id) ON UPDATE CASCADE;
- ALTER TABLE ONLY comment_vote
- ADD CONSTRAINT comment_vote_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY achievement
- ADD CONSTRAINT achievement_user_id_fkey FOREIGN KEY (user_id) REFERENCES "user"(id) ON UPDATE CASCADE;
- ALTER TABLE ONLY reward_item
- ADD CONSTRAINT reward_item_achievement_id_fkey FOREIGN KEY (achievement_id) REFERENCES achievement(id) ON UPDATE CASCADE;
- -- TRIGGERS
- CREATE FUNCTION equalPassword() RETURNS TRIGGER AS $equal_password$
- --&BODY&
- BEGIN
- IF EXISTS (SELECT id, password FROM "user" WHERE id = NEW.id AND password = NEW.password)
- THEN
- RAISE EXCEPTION 'Your new password must be different than the older';
- END IF;
- RETURN NEW;
- END;
- --$BODY$
- $equal_password$ LANGUAGE plpgsql;
- CREATE TRIGGER newPassEqualToOld
- BEFORE UPDATE ON "user"
- FOR EACH ROW
- EXECUTE PROCEDURE equalPassword();
- CREATE FUNCTION autoVoteQuestion() RETURNS TRIGGER AS $auto_vote_question$
- --&BODY&
- BEGIN
- INSERT INTO question_vote (question_id, user_id, "value") VALUES (NEW.id, NEW.user_id, 1);
- RETURN NEW;
- END;
- --&BODY&
- $auto_vote_question$ LANGUAGE plpgsql;
- CREATE TRIGGER questionAutoVote
- AFTER INSERT ON question
- FOR EACH ROW
- EXECUTE PROCEDURE autoVoteQuestion();
- CREATE FUNCTION autoVoteComment() RETURNS TRIGGER AS $auto_vote_comment$
- --&BODY&
- BEGIN
- INSERT INTO comment_vote (comment_id, user_id, "value") VALUES (NEW.id, NEW.user_id, 1);
- RETURN NEW;
- END;
- --&BODY&
- $auto_vote_comment$ LANGUAGE plpgsql;
- CREATE TRIGGER commentAutoVote
- AFTER INSERT ON "comment"
- FOR EACH ROW
- EXECUTE PROCEDURE autoVoteComment();
- -- Inserts
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (1, 'User1', 'testuser1@gmail.com', 'FDSG7DE9', 'defaultimage.png', '2016-02-15 15:48:29', FALSE, 3710);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (2, 'User2', 'testuser2@gmail.com', 'SDFGHN12', 'defaultimage.png', '2016-05-12 19:37:52', FALSE, 67243);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (3, 'User3', 'testuser3@gmail.com', 'MDO671KM', 'defaultimage.png', '2016-05-28 21:15:16', TRUE, 272);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (4, 'User4', 'testuser4@gmail.com', '85SDF978', 'defaultimage.png', '2016-10-05 03:42:19', FALSE, 45412);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (5, 'User5', 'testuser5@gmail.com', 'OMJHDF80', 'defaultimage.png', '2017-04-21 15:12:54', FALSE, 137532);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (6, 'User6', 'testuser6@gmail.com', 'H1K2HNJL', 'defaultimage.png', '2017-07-15 09:54:45', FALSE, 54321);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (7, 'User7', 'testuser7@gmail.com', 'DSH098DS', 'defaultimage.png', '2017-08-17 10:03:15', FALSE, 43523);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (8, 'User8', 'testuser8@gmail.com', 'MO32MMDS', 'defaultimage.png', '2017-10-25 23:12:32', FALSE, 623);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (9, 'User9', 'testuser9@gmail.com', 'DSF5D0SH', 'defaultimage.png', '2017-12-28 05:27:12', FALSE, 4713);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (10, 'User10', 'testuser10@gmail.com', '54KLNNLK', 'defaultimage.png', '2018-01-04 13:07:51', TRUE, 4326);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (11, 'User11', 'testuser11@gmail.com', 'KIN423SD', 'defaultimage.png', '2018-03-02 19:47:18', FALSE, 13832);
- INSERT INTO "user" (id, username, email, password, imagePath, creationDate, behaviorFlag, experience) VALUES (12, 'User12', 'testuser12@gmail.com', 'BDS87G9M', 'defaultimage.png', '2018-03-18 22:41:59', FALSE, 435);
- INSERT INTO topic (id, name) VALUES (1, 'Character');
- INSERT INTO topic (id, name) VALUES (2, 'Combat');
- INSERT INTO topic (id, name) VALUES (3, 'Dungeon Mastering');
- INSERT INTO topic (id, name) VALUES (4, 'Itemization');
- INSERT INTO topic (id, name) VALUES (5, 'Roleplay');
- INSERT INTO topic (id, name) VALUES (6, 'Text Play');
- INSERT INTO topic (id, name) VALUES (7, 'Off-Topic');
- INSERT INTO question (id, user_id, topic_id, title, textContent, dateCreated) VALUES (1, 4, 2, 'How to I engage in combat?', 'Duis pretium porta nibh, quis interdum turpis facilisis non. Nulla sed faucibus arcu. Nunc et ligula eu purus interdum laoreet non in felis. Nulla sed vulputate velit. Nulla nunc ligula, consequat sit amet auctor ac, tincidunt nec libero.', '2016-11-21 16:22:52');
- INSERT INTO question (id, user_id, topic_id, title, textContent, dateCreated) VALUES (2, 2, 5, 'I have a question about roleplaying...', 'Quisque maximus erat vel sem iaculis condimentum. Suspendisse sit amet mollis sapien. Nam auctor, diam eu egestas aliquam, turpis nulla accumsan mi, quis tristique sem mi sit amet orci. Nulla nisl velit, rhoncus eu neque id, consequat sodales augue. Mauris lacinia, nibh vitae vestibulum dignissim, erat turpis scelerisque felis, ut placerat massa ipsum eget neque. Sed at ante in enim facilisis finibus et ac erat.', '2017-01-05 13:28:31');
- INSERT INTO question (id, user_id, topic_id, title, textContent, dateCreated) VALUES (3, 5, 4, 'Making itemization rewarding for players...', 'Phasellus at neque ornare, luctus velit ac, luctus mauris. Aenean commodo velit a dui elementum, in egestas libero lobortis. Aliquam erat volutpat. Nunc vitae nibh metus. Mauris pellentesque malesuada tincidunt. Duis accumsan, arcu scelerisque malesuada scelerisque, sem nunc ultrices sapien, ac lacinia ipsum nibh non metus. Aenean nec lacus id tellus varius venenatis eu ut nisi. Vestibulum a cursus velit. Donec mauris lacus, pulvinar vel viverra vel, blandit non purus. Vestibulum vel gravida nunc, eget scelerisque turpis. Pellentesque eu feugiat tortor. Vestibulum ultricies lectus quis orci venenatis gravida.', '2017-12-10 11:41:19');
- INSERT INTO question (id, user_id, topic_id, title, textContent, dateCreated) VALUES (4, 7, 1, 'How can I create an interesting character?', 'Vivamus massa libero, ornare vitae elementum a, ultricies sed turpis. Suspendisse venenatis, turpis non porta blandit, neque leo gravida purus, a pulvinar nulla nunc pretium sapien. Phasellus quis enim quis tortor malesuada volutpat sit amet nec lorem. Nulla facilisi. Curabitur sit amet rhoncus sapien. In enim nibh, vestibulum a faucibus vitae, fermentum vitae purus. Nullam nulla ex, laoreet ut aliquam in, vestibulum non sapien. Morbi posuere vestibulum nulla at venenatis. Mauris sed metus eu ante suscipit mattis. Interdum et malesuada fames ac ante ipsum primis in faucibus. Maecenas a mi lobortis, scelerisque magna vel, convallis enim. Nullam bibendum scelerisque lorem. In ex nibh, pharetra vitae sodales nec, luctus vitae neque. Aliquam ut augue erat.', '2018-01-03 15:23:34');
- INSERT INTO question (id, user_id, topic_id, title, textContent, dateCreated) VALUES (5, 11, 3, 'As a DM, how am I supposed to keep players engaged?', 'Cras malesuada nunc vel vestibulum pharetra. Nulla eu ex arcu. Pellentesque lacinia urna ac turpis ultrices, a interdum nibh vehicula. Pellentesque eu leo mollis, sollicitudin velit quis, congue enim. Donec luctus, velit vestibulum pretium pulvinar, urna magna luctus dui, in auctor sem nisi a libero. Nam finibus nibh sed mi iaculis, vitae iaculis dui iaculis. Fusce congue suscipit nulla eu cursus. Nullam et eros id nulla placerat lacinia.', '2018-03-03 01:51:29');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (1, 1, 12, 'Cras malesuada nunc vel vestibulum pharetra. Nulla eu ex arcu. Pellentesque lacinia urna ac turpis ultrices, a interdum nibh vehicula. Pellentesque eu leo mollis, sollicitudin velit quis, congue enim.', '2016-11-22 01:25:17');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (2, 1, 6, 'Vivamus massa libero, ornare vitae elementum a, ultricies sed turpis. Suspendisse venenatis, turpis non porta blandit, neque leo gravida purus, a pulvinar nulla nunc pretium sapien.', '2016-11-22 10:41:52');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (3, 1, 8, 'Aliquam volutpat dictum nibh, ac hendrerit nunc pellentesque in. Donec augue elit, blandit non neque rhoncus, malesuada semper odio.', '2016-11-22 15:18:29');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (4, 2, 4, 'Mauris sed metus eu ante suscipit mattis. Interdum et malesuada fames ac ante ipsum primis in faucibus. Maecenas a mi lobortis, scelerisque magna vel, convallis enim. Nullam bibendum scelerisque lorem. In ex nibh, pharetra vitae sodales nec, luctus vitae neque. Aliquam ut augue erat.', '2017-01-08 04:28:18');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (5, 1, 1, 'Phasellus quis enim quis tortor malesuada volutpat sit amet nec lorem. Nulla facilisi. Curabitur sit amet rhoncus sapien. In enim nibh, vestibulum a faucibus vitae, fermentum vitae purus.', '2017-01-10 02:55:12');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (6, 2, 10, 'Duis accumsan, arcu scelerisque malesuada scelerisque, sem nunc ultrices sapien, ac lacinia ipsum nibh non metus.', '2017-01-10 08:14:47');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (7, 3, 7, 'Morbi posuere vestibulum nulla at venenatis. Mauris sed metus eu ante suscipit mattis. Interdum et malesuada fames ac ante ipsum primis in faucibus.', '2017-12-10 15:17:41');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (8, 3, 2, 'Phasellus at neque ornare, luctus velit ac, luctus mauris.', '2017-12-11 21:38:18');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (9, 2, 5, 'Sed dapibus magna ac interdum rhoncus. Maecenas laoreet scelerisque ullamcorper. Nunc eget tellus venenatis ante luctus mattis.', '2017-12-18 17:03:45');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (10, 3, 5, 'Maecenas a mi lobortis, scelerisque magna vel, convallis enim. Nullam bibendum scelerisque lorem. In ex nibh, pharetra vitae sodales nec, luctus vitae neque. Aliquam ut augue erat.', '2017-12-18 17:26:12');
- INSERT INTO "comment" (id, question_id, user_id, textContent, dateCreated) VALUES (11, 4, 5, 'Maecenas a mi lobortis, scelerisque magna vel, convallis enim. Nullam bibendum scelerisque lorem. In ex nibh, pharetra vitae sodales nec, luctus vitae neque. Aliquam ut augue erat.', '2018-01-05 23:17:58');
- INSERT INTO private_message (id, sender_id, receiver_id, textContent, dateCreated, seen) VALUES (1, 1, 2, 'Hello', '2016-05-15 00:15:40', TRUE);
- INSERT INTO private_message (id, sender_id, receiver_id, textContent, dateCreated, seen) VALUES (2, 2, 1, 'Hey man', '2016-05-15 01:24:17', TRUE);
- INSERT INTO private_message (id, sender_id, receiver_id, textContent, dateCreated, seen) VALUES (3, 1, 2, 'What''s up?', '2016-05-15 01:26:10', TRUE);
- INSERT INTO private_message (id, sender_id, receiver_id, textContent, dateCreated, seen) VALUES (4, 2, 1, 'Lorem Ipsum', '2016-05-15 01:29:41', TRUE);
- INSERT INTO private_message (id, sender_id, receiver_id, textContent, dateCreated, seen) VALUES (5, 1, 2, 'bitconnect', '2016-05-15 01:31:16', FALSE);
- INSERT INTO notification (id, user_id, seen) VALUES (1, 2, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (2, 1, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (3, 2, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (4, 1, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (5, 2, FALSE);
- INSERT INTO notification (id, user_id, seen) VALUES (6, 4, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (7, 4, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (8, 4, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (9, 2, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (10, 4, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (11, 2, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (12, 5, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (13, 5, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (14, 2, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (15, 5, TRUE);
- INSERT INTO notification (id, user_id, seen) VALUES (16, 7, TRUE);
- INSERT INTO message_notification (notification_id, private_message_id) VALUES (1, 1);
- INSERT INTO message_notification (notification_id, private_message_id) VALUES (2, 2);
- INSERT INTO message_notification (notification_id, private_message_id) VALUES (3, 3);
- INSERT INTO message_notification (notification_id, private_message_id) VALUES (4, 4);
- INSERT INTO message_notification (notification_id, private_message_id) VALUES (5, 5);
- INSERT INTO question_notification (notification_id, question_id) VALUES (6, 1);
- INSERT INTO question_notification (notification_id, question_id) VALUES (7, 1);
- INSERT INTO question_notification (notification_id, question_id) VALUES (8, 1);
- INSERT INTO question_notification (notification_id, question_id) VALUES (9, 2);
- INSERT INTO question_notification (notification_id, question_id) VALUES (10, 1);
- INSERT INTO question_notification (notification_id, question_id) VALUES (11, 2);
- INSERT INTO question_notification (notification_id, question_id) VALUES (12, 3);
- INSERT INTO question_notification (notification_id, question_id) VALUES (13, 3);
- INSERT INTO question_notification (notification_id, question_id) VALUES (14, 2);
- INSERT INTO question_notification (notification_id, question_id) VALUES (15, 3);
- INSERT INTO question_notification (notification_id, question_id) VALUES (16, 4);
- INSERT INTO moderator (user_id) VALUES (2);
- INSERT INTO moderator (user_id) VALUES (4);
- INSERT INTO "admin" (user_id) VALUES (1);
- INSERT INTO banned_user (user_id, banDate) VALUES (3, '2016-05-30 12:03:27');
- INSERT INTO banned_user (user_id, banDate) VALUES (10, '2018-01-07 23:19:11');
- --Need to check votes and achievements later
- INSERT INTO question_vote (question_id, user_id, "value") VALUES (1, 1, 1);
- INSERT INTO question_vote (question_id, user_id, "value") VALUES (2, 1, 1);
- INSERT INTO question_vote (question_id, user_id, "value") VALUES (3, 1, -1);
- INSERT INTO question_vote (question_id, user_id, "value") VALUES (5, 1, 1);
- INSERT INTO comment_vote (comment_id, user_id, "value") VALUES (4, 1, 1);
- INSERT INTO comment_vote (comment_id, user_id, "value") VALUES (7, 2, 1);
- INSERT INTO comment_vote (comment_id, user_id, "value") VALUES (8, 1, 1);
- INSERT INTO achievement (id, user_id, title, objective, dateAchieved, completionFlag, experienceGain) VALUES (1, 2, 'The first of Many', 'Post your first question', '2016-05-30 12:03:27', FALSE, 10);
- INSERT INTO achievement (id, user_id, title, objective, dateAchieved, completionFlag, experienceGain) VALUES (3, 2, 'Template1', 'Template', '2016-05-30 12:03:27', FALSE, 10);
- INSERT INTO achievement (id, user_id, title, objective, dateAchieved, completionFlag, experienceGain) VALUES (2, 2, 'Template2', 'Template', '2016-05-30 12:03:27', FALSE, 10);
- INSERT INTO achievement (id, user_id, title, objective, dateAchieved, completionFlag, experienceGain) VALUES (4, 2, 'Template3', 'Template', '2016-05-30 12:03:27', FALSE, 10);
- INSERT INTO reward_item (id, achievement_id, name, imagePath) VALUES (1, 1, 'The sword of a thousand truths', 'TheSwordOfAThousandTruths.jpg');
- INSERT INTO reward_item (id, achievement_id, name, imagePath) VALUES (2, 2, 'Template1', 'Template1.jpg');
- INSERT INTO reward_item (id, achievement_id, name, imagePath) VALUES (3, 3, 'Template2', 'Template2.jpg');
- INSERT INTO reward_item (id, achievement_id, name, imagePath) VALUES (4, 4, 'Template3', 'Template3.jpg');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement