trotFunky
9911895b5b
This first version allows login of pre-existing users, creation and update of truths by admins, vote on the truths by users, their display as well as a simple graph for the vote results. Everything persisting in a SQLite database.
21 lines
3.9 KiB
SQL
21 lines
3.9 KiB
SQL
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 1,
|
||
-- "This is a bit of bullshit that might be a looooot of bullshit, like, fucking hell, a lot.",
|
||
-- "This is a bit of bullshit that might be a looooot of bullshit, like, fucking hell, a lot.", 1);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 6,
|
||
-- "This one, small one",
|
||
-- "This one, small one", 4);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 3,
|
||
-- "At the time of writing, the share price is down more than 19 percent as the security shop to some of the biggest organizations in the world continues to work through issues with its customers.",
|
||
-- "At the time of writing, the share price is down more than 19 percent as the security shop to some of the biggest organizations in the world continues to work through issues with its customers.", 5);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 4,
|
||
-- "Les récentes recherches démontrent qu’une civilisation perdue aurait développée une technologie fonctionnant à base de cristaux de mana élémentaires. Les outils actuels sont limités quand à l’utilisation de ces derniers mais nul doute que si l’on parvenait à les utiliser le monde entier subirait une révolution technologique. ",
|
||
-- "Les récentes recherches démontrent qu’une civilisation perdue aurait développée une technologie fonctionnant à base de cristaux de mana élémentaires. Les outils actuels sont limités quand à l’utilisation de ces derniers mais nul doute que si l’on parvenait à les utiliser le monde entier subirait une révolution technologique. ", 3);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 5,
|
||
-- "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec aliquet egestas lacus at posuere. Donec quis laoreet lacus. Curabitur aliquam pharetra ligula vestibulum lacinia. Donec vitae elit venenatis, interdum lacus a, lobortis sem. Aliquam non dictum velit, at sagittis ex. Duis vestibulum nisi vitae mattis posuere. Integer rutrum accumsan diam. Cras cursus sapien tempus, bibendum metus et, scelerisque erat. Etiam eleifend vitae nunc vel pretium. Ut ipsum risus, consequat ac orci a, varius aliquam sapien. Integer ut elit bibendum, bibendum dui ac, maximus lacus. Aenean scelerisque sapien id tincidunt euismod. Morbi placerat, massa ac vehicula congue, mi sem eleifend diam, id consequat mauris nibh non neque. Integer et lacus leo. Aliquam hendrerit facilisis arcu at auctor. ",
|
||
-- "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec aliquet egestas lacus at posuere. Donec quis laoreet lacus. Curabitur aliquam pharetra ligula vestibulum lacinia. Donec vitae elit venenatis, interdum lacus a, lobortis sem. Aliquam non dictum velit, at sagittis ex. Duis vestibulum nisi vitae mattis posuere. Integer rutrum accumsan diam. Cras cursus sapien tempus, bibendum metus et, scelerisque erat. Etiam eleifend vitae nunc vel pretium. Ut ipsum risus, consequat ac orci a, varius aliquam sapien. Integer ut elit bibendum, bibendum dui ac, maximus lacus. Aenean scelerisque sapien id tincidunt euismod. Morbi placerat, massa ac vehicula congue, mi sem eleifend diam, id consequat mauris nibh non neque. Integer et lacus leo. Aliquam hendrerit facilisis arcu at auctor. ", 6);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 2,
|
||
-- "And another one ! And another one ! And another one ! And another one ! And another one ! And another one ! And another one ! And another one !",
|
||
-- "And another one ! And another one ! And another one ! And another one ! And another one ! And another one ! And another one ! And another one !", 8);
|
||
--INSERT INTO Truths (week, number, rendered_text, raw_text, author_id) VALUES (1, 7,
|
||
-- "Sure <b>why not</b> use emojis 🍌 and tags",
|
||
-- "Sure *why not* use emojis 🍌 and tags", 7);
|