-- Create table structure 
CREATE TABLE IF NOT EXISTS `gitlog` (
    `hash`    varchar(40) NOT NULL DEFAULT '' COMMENT 'Unique identifier of commit',
    `date`    int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Time of commit',
    `author`  varchar(30) NOT NULL DEFAULT '' COMMENT 'Author of commit',
    `email`   varchar(30) NOT NULL DEFAULT '' COMMENT 'Email of commit',
    `subject` text NOT NULL COMMENT 'Subject of commit',
    `body`    text NOT NULL COMMENT 'Body message of commit',
    PRIMARY KEY(`hash`)
);

-- Insert rows
REPLACE INTO `gitlog`
    (`hash`,`date`,`author`,`email`,`subject`,`body`)
VALUES
('52571d990cf1c8ad1c71009354e001bf9fa012ec', '1327744139', 'DoesntMatter', 'jaed1@gmx.net', '[50] Removed useless file handlers', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('3c5518a4347cb5319356a2b641958c80c388dae7', '1327743865', 'DoesntMatter', 'jaed1@gmx.net', '[49] Improved SQL statements', 'Better to use REPLACE in case of commits with --amend
Use all column names directly to allow adding custom columns
More performant to use only one statement

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('8440dece4075f9aa676776ed54e06706d9ac7d2e', '1327685576', 'DoesntMatter', 'jaed1@gmx.net', '[48] Use timestamp instead of date output in SQL dump', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('999a36b389fac812a9f9be938ae6908f865df8b7', '1327335596', 'DoesntMatter', 'jaed1@gmx.net', '[47] Fixed RSS customizing options', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('7c5e34c10647b9bb0dfcc036d36d1bc57092cf9f', '1327335524', 'DoesntMatter', 'jaed1@gmx.net', '[46] Implemented title and github option for HTML conversion', 'Additionally cleaned up and adjusted README

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('18e9047feefe44cdb054181df29d663c6aadf794', '1327317710', 'DoesntMatter', 'jaed1@gmx.net', '[45] Fixed link option for RSS Feed', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('269734cecc56163a2cd7e7d17092f88b0cd87271', '1327316232', 'DoesntMatter', 'jaed1@gmx.net', '[44] Switch to version 1.8 and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('182b8d719a0b9986cb91950324c7fc8e1778b6a9', '1327316104', 'DoesntMatter', 'jaed1@gmx.net', '[43] Added .html files to .gitignore', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('4429e42eaec08082f81662bfd06cda05405ddf79', '1327316021', 'DoesntMatter', 'jaed1@gmx.net', '[42] Implemented new method to convert `git log` to HTML file', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('aee61dff9dfbfb9e935ec9a311d710aa58c50458', '1327312627', 'DoesntMatter', 'jaed1@gmx.net', '[41] Switch to version 1.7', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('13cfbed7acd13a29711bc5fe57dc5aab8cb4e824', '1327312524', 'DoesntMatter', 'jaed1@gmx.net', '[40] Moved value check of options to generic functions', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('2a05aaed36568376d42df904b97e336c7c8ee136', '1327311797', 'DoesntMatter', 'jaed1@gmx.net', '[39] Improved the setting of outfile option', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('809d9375ddadcca12e7c60bc47adde6bb8b1f2e9', '1327311012', 'DoesntMatter', 'jaed1@gmx.net', '[38] Corrected query escaping of strings', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('9d54862c5609b8d4f02f9cfce5869529345e2ee0', '1327310739', 'DoesntMatter', 'jaed1@gmx.net', '[37] Implemented option to specify custom table name', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('a233c7d16d618bb6d465c9b91bde8ce2166a228d', '1327309933', 'DoesntMatter', 'jaed1@gmx.net', '[36] Switch to version 1.6 and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('0aa9a81058241307faa9182178c00e1afb2045ca', '1327309742', 'DoesntMatter', 'jaed1@gmx.net', '[35] Do not show warnings for uninitialized values in generator modules', 'This is no mistake here

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('a6f5ad5c3f256c7a7bb73132aed83f19df13d457', '1327309414', 'DoesntMatter', 'jaed1@gmx.net', '[34] Only substitude body if its variable is defined', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('53d57fae00b03ac8fc29749f36849dc68c7f1f19', '1327308726', 'DoesntMatter', 'jaed1@gmx.net', '[33] User perl modules instead of headers', 'Fixed inclusion of libraries

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('177cfc663cad7fdb768e56b6af75b0bd68852652', '1327263208', 'DoesntMatter', 'jaed1@gmx.net', '[32] Fixed paths of required header files', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('3bcc5e05294d36c8e23f20259673b787de29d31d', '1327261530', 'DoesntMatter', 'jaed1@gmx.net', '[31] Switch to version 1.5 and removed beta status', 'Additionally updated manual with gitlog_to_sql

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('f817e0cbfe58b5bc5d0381960db2ab08cdd35816', '1327261313', 'DoesntMatter', 'jaed1@gmx.net', '[30] Moved scripts to new folder', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('1ad58a81eeff5dc21fcdb078275cb2b6b1cb9c8a', '1327261171', 'DoesntMatter', 'jaed1@gmx.net', '[29] Added sql files to .gitignore', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('d397ff41358b6721d8d56bc6ffc9a8c58fd68df3', '1327261121', 'DoesntMatter', 'jaed1@gmx.net', '[28] Implemented new method to convert `git log` to SQL file', ''),
('7169f1bed464f9a9899cc5c8ada34770a24ba8f7', '1327256479', 'DoesntMatter', 'jaed1@gmx.net', '[27] Switch to version 1.4 and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('3ee52397eaeea34e307761a83853b3c71c724c0a', '1327256389', 'DoesntMatter', 'jaed1@gmx.net', '[26] Moved parsing functions to new header', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('b002aa9971e0dbec8faefdb02edae855d9f842a8', '1327256154', 'DoesntMatter', 'jaed1@gmx.net', '[25] Implemented option to use github links in RSS feed', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('9b2bdc9d9faa4a528a634d4335158933f7329e59', '1327248809', 'DoesntMatter', 'jaed1@gmx.net', '[24] Moved HTML encoding to RSS specific places', 'We want to get non encoded output
Split function may needs some rewrite

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('50ec852f2ee50cac7bc9996bd69e628bd4c5fdc3', '1327246228', 'DoesntMatter', 'jaed1@gmx.net', '[23] Switch project to version 1.3', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('b71d9ea5f336421daff2d1bf47d0111438aa7f95', '1327245883', 'DoesntMatter', 'jaed1@gmx.net', '[22] Rewritten project to object-oriented structure', 'Use header files for subroutines
Use packages for better accessing

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('c46043eb37334e57e0c09a221cc62bae1c45bc73', '1327244075', 'DoesntMatter', 'jaed1@gmx.net', '[21] Renamed project and its description', 'I have planned to support more filetypes
The next will be SQL

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('97d837c87bbabff778a77f71cd0bc29740f77fc6', '1327243577', 'DoesntMatter', 'jaed1@gmx.net', '[20] Switch to version 1.2 and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('3cd6c11c3241f156ae60d892a3b60dc697fbb24e', '1327243567', 'DoesntMatter', 'jaed1@gmx.net', '[19] Implemented possibility of `git log` restriction', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('d5bee6ca06542a435f98722be620ef41f65207ef', '1327243558', 'DoesntMatter', 'jaed1@gmx.net', '[18] Link author of commit to github', 'Due to the fact that most users are registered on github
This can be changed via $weblink variable

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('b2b673360df0de4dd2da4972bd27a07b8c272cdd', '1327243549', 'DoesntMatter', 'jaed1@gmx.net', '[17] Added .gitignore for rss files', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('04777cfb9c1d3fffab914f2bd8e73047486c7d8e', '1327243535', 'DoesntMatter', 'jaed1@gmx.net', '[16] Switch to version 1.1 and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('f853633ec213b667b1f915b364fd90f178f94f26', '1327243525', 'DoesntMatter', 'jaed1@gmx.net', '[15] Implemented additional options for customizing rss', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('0cd1f573c6d30894549d6fd49f43c0bdf979564c', '1327243515', 'DoesntMatter', 'jaed1@gmx.net', '[14] Implemented possibilty of prompting user input', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('459db2b582f9a929522d7c8106aa35fc9b6190eb', '1327243505', 'DoesntMatter', 'jaed1@gmx.net', '[13] Move repository check to its own function', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('ca0d0f639b9eed1513a7e7e4b414b2b7f6ed3017', '1327243490', 'DoesntMatter', 'jaed1@gmx.net', '[12] Switch to beta status and updated manual', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('b81762da862a9bf6a88d8cceed190fa0984b70b5', '1327243480', 'DoesntMatter', 'jaed1@gmx.net', '[11] Implemented first version of function for RSS creation', 'This tool needs additional options to customize Feeds

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('fe840990a8004e8534f474d5c82697aa386c2dde', '1327243467', 'DoesntMatter', 'jaed1@gmx.net', '[10] Fixed whitespace issues in parser function', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('8b978a7740374914ffc069e1c461e0fc7d992e22', '1327243455', 'DoesntMatter', 'jaed1@gmx.net', '[9] Encode HTML entities for RSS validation', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('7e3cdcc46b79ac8ee7d1b50c5fca349205dc5b4e', '1327243443', 'DoesntMatter', 'jaed1@gmx.net', '[8] Corrected count of lines to split', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('5f61a918715cc19199441c4e3461bc38f9457cd6', '1327243423', 'DoesntMatter', 'jaed1@gmx.net', '[7] Corrected case of undefined outfile', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('fc8aea0c118a0d02cd0c625c5ee2cec3b3f9f0d9', '1327243406', 'DoesntMatter', 'jaed1@gmx.net', '[6] Adjusted `git log` formatting options', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('45f1163597b8173b4a42083362acf9b18dfc8735', '1327243392', 'DoesntMatter', 'jaed1@gmx.net', '[5] Implemented function to split commits into 2d array', 'With this we have better accessibility

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('7c4c8e41280872c2048570008877817a6a32d31c', '1327243382', 'DoesntMatter', 'jaed1@gmx.net', '[4] Implemented function to parse `git log` command', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('9220f24abba1a894307453067beb330b4f292e83', '1327243370', 'DoesntMatter', 'jaed1@gmx.net', '[3] Check and set given options', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('49ba0f12573f366d6a73d8778b8bc270be99948e', '1327243358', 'DoesntMatter', 'jaed1@gmx.net', '[2] Added inital version', 'Yet without any real functionality

Signed-off-by: DoesntMatter <jaed1@gmx.net>'),
('92f69a2e613205add6162b99b502c3e732df2750', '1327243341', 'DoesntMatter', 'jaed1@gmx.net', '[1] Added README file', 'Signed-off-by: DoesntMatter <jaed1@gmx.net>');