# Add 4 users to the database
INSERT INTO gpb_user VALUES(NULL, "d8578edf8458ce06fbc5bb76a58c5ca4", "Linus", "Linus Thorvalds", "linus@mail.com", "http://www.linux.org", "12345678", "911", "1968-07-07", 3, 996824553, "Kernel hacker", "Tove, Linux, Tux, ...", "California, USA", "Don't underestimate the power of survival of the fittest.", "The one and only", "http://www.nedlinux.nl/linux/images/linus.jpg", "", "en", "simple", 200, 1, 1, 1, 9, 14);
INSERT INTO gpb_user VALUES(NULL, "d8578edf8458ce06fbc5bb76a58c5ca4", "Alan", "Alan Cox", "alan@mail.com", "http://www.redhat.com", "", "112", "1965-07-07", 2, 1000824553, "Kernel hacker", "Linux, Linux and Linux", "UK", "Engineering does not require science. Science helps a lot but people built perfectly good brick walls long before they knew why cement works.", "The hatman", "http://www.saturnus.com/~krynos/trip1/20-alan-cox.jpg", "", "en", "ubb", 100, 0, 1, 0, 5, 10);
INSERT INTO gpb_user VALUES(NULL, "d8578edf8458ce06fbc5bb76a58c5ca4", "RMS", "Richard Stallman", "richard@gnu.org", "http://www.gnu.org", "", "0123456789", "1960-07-07", 1, 1000000000, "GNU leader and programmer", "GPL's Software", "Bosten, USA", "GNU: GNU is Not Unix", "GPL guru", "http://www.nedlinux.nl/linux/images/richard_big.jpg", "", "nl", "simple", 0, 1, 1, 1, 0, 0);
INSERT INTO gpb_user VALUES(NULL, "d8578edf8458ce06fbc5bb76a58c5ca4", "Dictator", "Steve Ballmer", "ballmer@mail.com", "http://www.microsoft.com", "", "", "", 0, 983747332, "CEO of Mickeysoft", "Windows, Bugs and BSOD", "Redmont, USA", "With our software your TCO will be lower", "Microsoft CEO", "http://a.r.tv.com/cnet.1d/i/ne/en/2001/05/0511SteveBallmer.gif", "http://a.r.tv.com/cnet.1d/i/ne/en/2001/05/0511SteveBallmer.gif", "en", "ubb", 20, 0, 0, 0, 0, 0);

# Add 3 categories to the database
INSERT INTO gpb_cat VALUES(NULL, 'Category 1', 1);
INSERT INTO gpb_cat VALUES(NULL, 'Category 3', 3);
INSERT INTO gpb_cat VALUES(NULL, 'Category 2', 2);

# Add 6 Subcategories to the database
INSERT INTO gpb_subcat VALUES (1, 1, 0, 'Subcategory 1.1', 'Description of subcategory 1.1', '1.1', 2, 5, 12, 1, 1);
INSERT INTO gpb_subcat VALUES (2, 2, 1, 'Subcategory 3.1', 'Description of subcategory 3.1', '3.1', 2, 3, 13, 1, 1);
INSERT INTO gpb_subcat VALUES (3, 1, 0, 'Subcategory 1.3', 'Description of subcategory 1.3', '1.3', 1, 2, 10, 2, 9);
INSERT INTO gpb_subcat VALUES (4, 3, 0, 'Subcategory 2.2', 'Description of subcategory 2.2', '2.2', 1, 3, 14, 2, 5);
INSERT INTO gpb_subcat VALUES (5, 3, 1, 'Subcategory 2.1', 'Description of subcategory 2.1', '2.1', 0, 0, 0, 1, 4);
INSERT INTO gpb_subcat VALUES (6, 1, 0, 'Subcategory 1.2', 'Description of subcategory 1.2', '1.2', 1, 1, 2, 2, 8);

# Add 7 topic to the database
INSERT INTO gpb_topic VALUES (1, 4, 1, 'Topic 1 in subcategory 2.2', 3, 1007502851, 1, 1, 14, 0);
INSERT INTO gpb_topic VALUES (2, 6, 1, 'Topic 1 in subcategory 1.2', 1, 1007503106, 10, 1, 2, 0);
INSERT INTO gpb_topic VALUES (3, 3, 1, 'Topic 1 in subcategory 1.3', 2, 1007503215, 2, 1, 10, 0);
INSERT INTO gpb_topic VALUES (4, 2, 1, 'Topic 1 in subcategory 3.1', 2, 1007503268, 6, 1, 13, 0);
INSERT INTO gpb_topic VALUES (5, 1, 1, 'Topic 1 in subcategory 1.1', 4, 1007503340, 7, 0, 12, 0);
INSERT INTO gpb_topic VALUES (6, 1, 2, 'Topic 2 in subcategory 1.1', 1, 1007503405, 13, 1, 6, 1);
INSERT INTO gpb_topic VALUES (7, 2, 2, 'Topic 2 in subcategory 3.1', 1, 1007503491, 9, 1, 7, 0);

# Add 14 posts to the database
INSERT INTO gpb_post VALUES (1, 1, 1, 'test content', 1007502851, 1, 1, 1);
INSERT INTO gpb_post VALUES (2, 2, 1, 'test content', 1007503106, 1, 10, 1);
INSERT INTO gpb_post VALUES (3, 3, 1, 'test content', 1007503215, 1, 2, 0);
INSERT INTO gpb_post VALUES (4, 4, 1, 'test content', 1007503268, 1, 6, 1);
INSERT INTO gpb_post VALUES (5, 5, 1, 'test content', 1007503340, 1, 7, 0);
INSERT INTO gpb_post VALUES (6, 6, 2, 'test content', 1007503405, 1, 13, 1);
INSERT INTO gpb_post VALUES (7, 7, 2, 'test content', 1007503491, 1, 9, 1);
INSERT INTO gpb_post VALUES (8, 5, 2, 'test reply', 1007503525, 0, 5, 0);
INSERT INTO gpb_post VALUES (9, 1, 2, 'test reply', 1007503564, 0, 8, 1);
INSERT INTO gpb_post VALUES (10, 3, 2, 'test reply', 1007503594, 0, 4, 1);
INSERT INTO gpb_post VALUES (11, 5, 1, 'test reply', 1007503622, 0, 1, 1);
INSERT INTO gpb_post VALUES (12, 5, 1, 'test reply', 1007503671, 0, 1, 1);
INSERT INTO gpb_post VALUES (13, 4, 1, 'test reply', 1007503691, 0, 1, 1);
INSERT INTO gpb_post VALUES (14, 1, 1, 'test reply', 1007503764, 0, 11, 1);