Skip to content

Commit b76c985

Browse files
AlexP11223AlexP11223
committed
Ratings dummy data
1 parent e11bcb4 commit b76c985

1 file changed

Lines changed: 107 additions & 0 deletions

File tree

‎src/main/resources/dummy-data.sql‎

Lines changed: 107 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1708,3 +1708,110 @@ INSERT INTO comments(id, commentText, dateTime, post_id, user_id, deleted, paren
17081708
INSERT INTO comments(id, commentText, dateTime, post_id, user_id, deleted, parent_id) VALUES(11, 'And cat language!', '2015-04-09 13:30:58', 85, 2, 0, 6);
17091709

17101710
INSERT INTO comments(id, commentText, dateTime, post_id, user_id, deleted, parent_id) VALUES(12, '**VRASUBATBURUK UG BUTHARUBATGRUIUK!!!**', '2015-05-09 12:30:58', 85, 8, 1, 2);
1711+
1712+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 1, 1);
1713+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 1, 2);
1714+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 5, 2);
1715+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 6, 2);
1716+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 3, 3);
1717+
1718+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 3, 7);
1719+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 5, 7);
1720+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 6, 7);
1721+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 7, 7);
1722+
1723+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 3, 8);
1724+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 4, 8);
1725+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 5, 8);
1726+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 6, 8);
1727+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 7, 8);
1728+
1729+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 2, 9);
1730+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 3, 9);
1731+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 4, 9);
1732+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 6, 9);
1733+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 7, 9);
1734+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(1, 8, 9);
1735+
1736+
INSERT INTO comment_ratings(value, user_id, comment_id) VALUES(-1, 5, 10);
1737+
1738+
1739+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 2, 83);
1740+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 3, 83);
1741+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 4, 83);
1742+
1743+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 85);
1744+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 3, 85);
1745+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 85);
1746+
1747+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 84);
1748+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 3, 84);
1749+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 84);
1750+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 84);
1751+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 84);
1752+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 84);
1753+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 8, 84);
1754+
1755+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 82);
1756+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 82);
1757+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 82);
1758+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 82);
1759+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 82);
1760+
1761+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 80);
1762+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 3, 80);
1763+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 80);
1764+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 80);
1765+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 80);
1766+
1767+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 79);
1768+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 3, 79);
1769+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 79);
1770+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 5, 79);
1771+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 79);
1772+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 79);
1773+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 79);
1774+
1775+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 78);
1776+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 78);
1777+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 78);
1778+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 78);
1779+
1780+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 77);
1781+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 3, 77);
1782+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 4, 77);
1783+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 77);
1784+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 77);
1785+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 77);
1786+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 77);
1787+
1788+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 76);
1789+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 76);
1790+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 76);
1791+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 76);
1792+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 76);
1793+
1794+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 75);
1795+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 75);
1796+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 75);
1797+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 75);
1798+
1799+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 74);
1800+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 74);
1801+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 74);
1802+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 74);
1803+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 74);
1804+
1805+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(-1, 4, 73);
1806+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 73);
1807+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 73);
1808+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 73);
1809+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 73);
1810+
1811+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 2, 42);
1812+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 3, 42);
1813+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 4, 42);
1814+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 5, 42);
1815+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 6, 42);
1816+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 7, 42);
1817+
INSERT INTO post_ratings(value, user_id, post_id) VALUES(1, 8, 42);

0 commit comments

Comments
 (0)