database.sql 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. /*
  2. * Copyright (C) 2014 Jeroen De Meerleer <me@jeroened.be>
  3. *
  4. * This program is free software: you can redistribute it and/or modify
  5. * it under the terms of the GNU General Public License as published by
  6. * the Free Software Foundation, either version 3 of the License, or
  7. * (at your option) any later version.
  8. *
  9. * This program is distributed in the hope that it will be useful,
  10. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  12. * GNU General Public License for more details.
  13. *
  14. * You should have received a copy of the GNU General Public License
  15. * along with this program. If not, see <http://www.gnu.org/licenses></http:>.
  16. */
  17. DROP DATABASE IF EXISTS instantbugfix;
  18. CREATE DATABASE instantbugfix;
  19. USE instantbugfix;
  20. CREATE TABLE ibf_fixes( fixID int NOT NULL AUTO_INCREMENT, fix tinytext NOT NULL, CONSTRAINT fixPK PRIMARY KEY (fixID));
  21. INSERT INTO ibf_fixes (fix)
  22. VALUES ('Have you tried turning it off and on again?');
  23. INSERT INTO ibf_fixes (fix)
  24. VALUES ('Get a couple of beers and try again tommorow');
  25. INSERT INTO ibf_fixes (fix)
  26. VALUES ('You cannot return flase');
  27. INSERT INTO ibf_fixes (fix)
  28. VALUES ('Is that an infinite loop?');
  29. INSERT INTO ibf_fixes (fix)
  30. VALUES ('Private properties are private');
  31. INSERT INTO ibf_fixes (fix)
  32. VALUES ('Sorry, I don\'t understand that thing');
  33. INSERT INTO ibf_fixes (fix)
  34. VALUES ('Void methods are not supposed to return strings');
  35. INSERT INTO ibf_fixes (fix)
  36. VALUES ('You cannot expect responses from a server which is not running');
  37. INSERT INTO ibf_fixes (fix)
  38. VALUES ('Executing that script requires permission');
  39. INSERT INTO ibf_fixes (fix)
  40. VALUES ('Works for me!');
  41. INSERT INTO ibf_fixes (fix)
  42. VALUES ('Escaping strings is most of the times not a bad idea');
  43. INSERT INTO ibf_fixes (fix)
  44. VALUES ('You missed a semicolon ;)');
  45. CREATE TABLE ibf_revisions( revID int NOT NULL AUTO_INCREMENT, pageslug varchar(25) NOT NULL, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, content text NOT NULL, isCurrent bool, CONSTRAINT revPK PRIMARY KEY (revID));
  46. INSERT INTO ibf_revisions (pageslug, content, isCurrent)
  47. VALUES ('about',
  48. '<h1>Jeroen De Meerleer - Developer</h1> <h2>Who am I?</h2> <p><img src="/content/images/JeroenED.jpg" class="nomobile" style="float: right; height: 150px;"/>My name is Jeroen De Meerleer and I am a developer. I live in Waregem, Belgium and I am doing an evening course as Programmer/Network Engineer (I am doing both) My hobbies are Programming and Chess (I eat Deep Blue for breakfast :-) ). When I am not doing one of these I am probably working on my server (VagrantBox running CentOS with lots of provisioning behind it. PHP-Development is run there too).</p> <h2>Why this website?</h2> <p>I created this mini-site as a project to show employers that I can program. I already did some projects but they were not quite good, so I created a completely new project where I could do whatever I want and this is it.</p> <h2>Credits and Used sources</h2> <p><ul> <li>Original idea: instantbugfix.com (taken offline; author unknown)</li> <li><a href="http://jquery.com">jQuery</a></li> <li><a href="http://spoon-library.com/">Spoon Library</a></li> </ul></p><p style="line-height: 15px;"> </p>',
  49. 1);