
-- TABLE user
INSERT INTO user VALUES (1, 'username', 'username@domain.ext', '07650a97ef6af6fdd51eb9d873a03c62afc6fd2b', 'SaltSalt', 'First Name', 'Last Name', 'photo.png', '+00123456789', '00000', 1, 1);

-- TABLE project_type
INSERT INTO text VALUES ('PROJECT_TYPE_D', 'es', 'DB_PROJECT_TYPE', 'Desarrollo');
INSERT INTO text VALUES ('PROJECT_TYPE_D', 'en', 'DB_PROJECT_TYPE', 'Development');
INSERT INTO text VALUES ('PROJECT_TYPE_D', 'eu', 'DB_PROJECT_TYPE', 'Development');
INSERT INTO text VALUES ('PROJECT_TYPE_D_SUMMARY', 'es', 'DB_PROJECT_TYPE', 'Desarrollo');
INSERT INTO text VALUES ('PROJECT_TYPE_D_SUMMARY', 'en', 'DB_PROJECT_TYPE', 'Development');
INSERT INTO text VALUES ('PROJECT_TYPE_D_SUMMARY', 'eu', 'DB_PROJECT_TYPE', 'Development');
INSERT INTO text VALUES ('PROJECT_TYPE_S', 'es', 'DB_PROJECT_TYPE', 'Sistemas');
INSERT INTO text VALUES ('PROJECT_TYPE_S', 'en', 'DB_PROJECT_TYPE', 'System');
INSERT INTO text VALUES ('PROJECT_TYPE_S', 'eu', 'DB_PROJECT_TYPE', 'System');
INSERT INTO text VALUES ('PROJECT_TYPE_S_SUMMARY', 'es', 'DB_PROJECT_TYPE', 'Sistemas');
INSERT INTO text VALUES ('PROJECT_TYPE_S_SUMMARY', 'en', 'DB_PROJECT_TYPE', 'System');
INSERT INTO text VALUES ('PROJECT_TYPE_S_SUMMARY', 'eu', 'DB_PROJECT_TYPE', 'System');
INSERT INTO project_type VALUES ('D', 'PROJECT_TYPE_D', 'PROJECT_TYPE_D_SUMMARY');
INSERT INTO project_type VALUES ('S', 'PROJECT_TYPE_S', 'PROJECT_TYPE_S_SUMMARY');

-- TABLE project_url_type
INSERT INTO text VALUES ('URL_TYPE_W', 'es', 'DB_URL_TYPE', 'Ver sitio web');
INSERT INTO text VALUES ('URL_TYPE_W', 'en', 'DB_URL_TYPE', 'Go to web site');
INSERT INTO text VALUES ('URL_TYPE_W', 'eu', 'DB_URL_TYPE', 'Horrialdera');
INSERT INTO text VALUES ('URL_TYPE_W_SUMMARY', 'es', 'DB_URL_TYPE', 'Ver sitio wew de este proyecto en funcionamiento.');
INSERT INTO text VALUES ('URL_TYPE_W_SUMMARY', 'en', 'DB_URL_TYPE', 'See production web site.');
INSERT INTO text VALUES ('URL_TYPE_W_SUMMARY', 'eu', 'DB_URL_TYPE', 'Horrialdera.');
INSERT INTO text VALUES ('URL_TYPE_P', 'es', 'DB_URL_TYPE', 'Google Play');
INSERT INTO text VALUES ('URL_TYPE_P', 'en', 'DB_URL_TYPE', 'Google Play');
INSERT INTO text VALUES ('URL_TYPE_P', 'eu', 'DB_URL_TYPE', 'Google Play');
INSERT INTO text VALUES ('URL_TYPE_P_SUMMARY', 'es', 'DB_URL_TYPE', 'Ver app en Google Play.');
INSERT INTO text VALUES ('URL_TYPE_P_SUMMARY', 'en', 'DB_URL_TYPE', 'See on Google Play.');
INSERT INTO text VALUES ('URL_TYPE_P_SUMMARY', 'eu', 'DB_URL_TYPE', 'Google Play-n.');
INSERT INTO text VALUES ('URL_TYPE_A', 'es', 'DB_URL_TYPE', 'App Store');
INSERT INTO text VALUES ('URL_TYPE_A', 'en', 'DB_URL_TYPE', 'App Store');
INSERT INTO text VALUES ('URL_TYPE_A', 'eu', 'DB_URL_TYPE', 'App Store');
INSERT INTO text VALUES ('URL_TYPE_A_SUMMARY', 'es', 'DB_URL_TYPE', 'Ver app en App Store.');
INSERT INTO text VALUES ('URL_TYPE_A_SUMMARY', 'en', 'DB_URL_TYPE', 'See on App Store.');
INSERT INTO text VALUES ('URL_TYPE_A_SUMMARY', 'eu', 'DB_URL_TYPE', 'App Store-an.');
INSERT INTO text VALUES ('URL_TYPE_G', 'es', 'DB_URL_TYPE', 'Github');
INSERT INTO text VALUES ('URL_TYPE_G', 'en', 'DB_URL_TYPE', 'Github');
INSERT INTO text VALUES ('URL_TYPE_G', 'eu', 'DB_URL_TYPE', 'Github');
INSERT INTO text VALUES ('URL_TYPE_G_SUMMARY', 'es', 'DB_URL_TYPE', 'Ver c&oacute;digo fuente en Github.');
INSERT INTO text VALUES ('URL_TYPE_G_SUMMARY', 'en', 'DB_URL_TYPE', 'Checkout source code on Github.');
INSERT INTO text VALUES ('URL_TYPE_G_SUMMARY', 'eu', 'DB_URL_TYPE', 'Kodea Github-n.');
INSERT INTO text VALUES ('URL_TYPE_M', 'es', 'DB_URL_TYPE', 'Ver');
INSERT INTO text VALUES ('URL_TYPE_M', 'en', 'DB_URL_TYPE', 'See');
INSERT INTO text VALUES ('URL_TYPE_M', 'eu', 'DB_URL_TYPE', 'Ikusi');
INSERT INTO text VALUES ('URL_TYPE_M_SUMMARY', 'es', 'DB_URL_TYPE', 'Ver');
INSERT INTO text VALUES ('URL_TYPE_M_SUMMARY', 'en', 'DB_URL_TYPE', 'See');
INSERT INTO text VALUES ('URL_TYPE_M_SUMMARY', 'eu', 'DB_URL_TYPE', 'Ikusi');
INSERT INTO project_url_type VALUES ('E', null, null, null);
INSERT INTO project_url_type VALUES ('W', 'URL_TYPE_W', 'URL_TYPE_W_SUMMARY', 'web.png');
INSERT INTO project_url_type VALUES ('P', 'URL_TYPE_P', 'URL_TYPE_P_SUMMARY', 'googleplay.png');
INSERT INTO project_url_type VALUES ('A', 'URL_TYPE_A', 'URL_TYPE_A_SUMMARY', 'appstore.png');
INSERT INTO project_url_type VALUES ('G', 'URL_TYPE_G', 'URL_TYPE_G_SUMMARY', 'github.png');
INSERT INTO project_url_type VALUES ('M', 'URL_TYPE_M', 'URL_TYPE_M_SUMMARY', 'misc.png');

-- TABLE project_version_type
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA', 'es', 'VERSION_TYPE', 'Alfa');
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA', 'en', 'VERSION_TYPE', 'Alpha');
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA', 'eu', 'VERSION_TYPE', 'Alpha');
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA_SUMMARY', 'es', 'VERSION_TYPE', 'En sesarrollo. Inestable.');
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA_SUMMARY', 'en', 'VERSION_TYPE', 'In development. Unstable.');
INSERT INTO text VALUES ('VERSION_TYPE_ALPHA_SUMMARY', 'eu', 'VERSION_TYPE', 'En desarrollo. Inestable');
INSERT INTO text VALUES ('VERSION_TYPE_BETA', 'es', 'VERSION_TYPE', 'Beta');
INSERT INTO text VALUES ('VERSION_TYPE_BETA', 'en', 'VERSION_TYPE', 'Beta');
INSERT INTO text VALUES ('VERSION_TYPE_BETA', 'eu', 'VERSION_TYPE', 'Beta');
INSERT INTO text VALUES ('VERSION_TYPE_BETA_SUMMARY', 'es', 'VERSION_TYPE', 'En pruebas. Parcialmente estable.');
INSERT INTO text VALUES ('VERSION_TYPE_BETA_SUMMARY', 'en', 'VERSION_TYPE', 'Under testing. Stability not guaranteed.');
INSERT INTO text VALUES ('VERSION_TYPE_BETA_SUMMARY', 'eu', 'VERSION_TYPE', 'En pruebas. Parcialmente estable.');
INSERT INTO text VALUES ('VERSION_TYPE_PRO', 'es', 'VERSION_TYPE', 'Estable');
INSERT INTO text VALUES ('VERSION_TYPE_PRO', 'en', 'VERSION_TYPE', 'Stable');
INSERT INTO text VALUES ('VERSION_TYPE_PRO', 'eu', 'VERSION_TYPE', 'Estable');
INSERT INTO text VALUES ('VERSION_TYPE_PRO_SUMMARY', 'es', 'VERSION_TYPE', 'Listo para uso en entorno de producci&oacute;n.');
INSERT INTO text VALUES ('VERSION_TYPE_PRO_SUMMARY', 'en', 'VERSION_TYPE', 'Ready for production.');
INSERT INTO text VALUES ('VERSION_TYPE_PRO_SUMMARY', 'eu', 'VERSION_TYPE', 'Listo para uso en entorno de producci&oacute;n.');
INSERT INTO project_version_type VALUES ('A', 'VERSION_TYPE_ALPHA', 'VERSION_TYPE_ALPHA_SUMMARY', '#ff0000');
INSERT INTO project_version_type VALUES ('B', 'VERSION_TYPE_BETA', 'VERSION_TYPE_ALPHA_SUMMARY', '#ffaa00');
INSERT INTO project_version_type VALUES ('P', 'VERSION_TYPE_PRO', 'VERSION_TYPE_PRO_SUMMARY', '#00ff00');

-- TABLE license
INSERT INTO text VALUES ('LICENSE_CC-BY-SA_SUMMARY', 'en', 'LICENSE', '<div style="text-align: left"><div><h3 style="text-align: center">You are free to:</h3><ul><li><strong>Share</strong> — copy and redistribute the material in any medium or format</li><li resource="http://creativecommons.org/ns#DerivativeWorks"><strong>Adapt</strong> — remix, transform, and build upon the material for any purpose, even commercially.</li></ul></div><div><img src="/img/license/freeculturalworks.jpg" style="border: 0" alt="This license is acceptable for Free Cultural Works."></div></div><div><ul style="text-align: center"><li>The licensor cannot revoke these freedoms as long as you follow the license terms.</li></ul></div><div><div><hr></div></div><div><h3 style="text-align: center">Under the following terms:</h3><ul style="text-align: left"><li><p><strong>Attribution</strong> — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.</p><p style="display:none;"><strong>Attribute this work:</strong><br><img src="/images/information.png"></p></li><li><p><strong>ShareAlike</strong> — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.</p></li></ul></div><div><ul><li><strong>No additional restrictions</strong> — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.</li></ul></div><div><div class="col-md-offset-1 col-md-10"><hr></div></div><div><h3 style="text-align: center">Notices:</h3><ul><li>You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation.</li><li>No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.</li></ul></div>');
INSERT INTO text VALUES ('LICENSE_CC-BY-SA', 'en', 'LICENSE', '<h3>Creative Commons Attribution-ShareAlike 4.0 International Public License</h3><p>By exercising the Licensed Rights (defined below), You accept and agree to be bound by the terms and conditions of this Creative Commons Attribution-ShareAlike 4.0 International Public License ("Public License"). To the extent this Public License may be interpreted as a contract, You are granted the Licensed Rights in consideration of Your acceptance of these terms and conditions, and the Licensor grants You such rights in consideration of benefits the Licensor receives from making the Licensed Material available under these terms and conditions.</p><p><strong>Section 1 – Definitions.</strong></p><ol><li><strong>Adapted Material</strong> means material subject to Copyright and Similar Rights that is derived from or based upon the Licensed Material and in which the Licensed Material is translated, altered, arranged, transformed, or otherwise modified in a manner requiring permission under the Copyright and Similar Rights held by the Licensor. For purposes of this Public License, where the Licensed Material is a musical work, performance, or sound recording, Adapted Material is always produced where the Licensed Material is synched in timed relation with a moving image.</li><li><strong>Adapter&#39;s License</strong> means the license You apply to Your Copyright and Similar Rights in Your contributions to Adapted Material in accordance with the terms and conditions of this Public License.</li><li><strong>BY-SA Compatible License</strong> means a license listed at <a href="//creativecommons.org/compatiblelicenses"> creativecommons.org/compatiblelicenses</a>, approved by Creative Commons as essentially the equivalent of this Public License.</li><li><strong>Copyright and Similar Rights</strong> means copyright and/or similar rights closely related to copyright including, without limitation, performance, broadcast, sound recording, and Sui Generis Database Rights, without regard to how the rights are labeled or categorized. For purposes of this Public License, the rights specified in Section 2(b)(1)-(2) are not Copyright and Similar Rights.</li><li><strong>Effective Technological Measures</strong> means those measures that, in the absence of proper authority, may notbe circumvented under laws fulfilling obligations under Article 11 of the WIPO Copyright Treaty adopted on December 20, 1996, and/or similarinternational agreements.</li><li><strong>Exceptions and Limitations</strong> means fair use, fair dealing, and/or any other exception or limitation to Copyright and Similar Rights that applies to Your use of the Licensed Material.</li><li><strong>License Elements</strong> means the license attributes listed in the name of a Creative Commons Public License. The License Elements of this Public License are Attribution and ShareAlike.</li><li><strong>Licensed Material</strong> means the artistic or literary work, database, or other material to which the Licensor applied this Public License.</li><li><strong>Licensed Rights</strong> means the rights granted to You subject to the terms and conditions of this Public License, which are limited to all Copyright and Similar Rights that apply to Your use of the Licensed Material and that the Licensor has authority to license.</li><li><strong>Licensor</strong> means the individual(s) or entity(ies) granting rights under this Public License.</li><li><strong>Share</strong> means to provide material to the public by any means or process that requires permission under the Licensed Rights, such as reproduction, public display, public performance, distribution, dissemination, communication, or importation, and to make material available to the public including in ways that members of the public may access the material from a place and at a time individually chosen by them.</li><li><strong>Sui Generis Database Rights</strong> means rights other than copyright resulting from Directive 96/9/EC of the European Parliament and of the Council of 11 March 1996 on the legal protection of databases, as amended and/or succeeded, as well as other essentially equivalent rights anywhere in the world.</li><li><strong>You</strong> means the individual or entity exercising the Licensed Rights under this Public License. <strong>Your</strong> has a corresponding meaning.</li></ol><p><strong>Section 2 – Scope.</strong></p><ol><li><strong>License grant</strong>.<ol><li>Subject to the terms and conditions of this Public License, the Licensor hereby grants You a worldwide, royalty-free, non-sublicensable, non-exclusive, irrevocable license to exercise the Licensed Rights in the Licensed Material to:<ol><li>reproduce and Share the Licensed Material, in whole or in part; and</li><li>produce, reproduce, and Share Adapted Material.</li></ol></li><li><span style="text-decoration: underline;">Exceptions and Limitations</span>. For the avoidance of doubt, where Exceptions and Limitations apply to Your use, this Public License does not apply, and You do not need to comply with its terms and conditions.</li><li><span style="text-decoration: underline;">Term</span>. The term of this Public License is specified in Section 6(a).</li><li><span style="text-decoration: underline;">Media and formats; technical modifications allowed</span>. The Licensor authorizes You to exercise the Licensed Rights in all media and formats whether now known or hereafter created, and to make technical modifications necessary to do so. The Licensor waives and/or agrees not to assert any right or authority to forbid You from making technical modifications necessary to exercise the Licensed Rights, including technical modifications necessary to circumvent Effective Technological Measures. For purposes of this Public License, simply making modifications authorized by this Section 2(a)(4) never produces Adapted Material.</li><li><span style="text-decoration: underline;">Downstream recipients</span>.<div><ol><li><span style="text-decoration: underline;">Offer from the Licensor – Licensed Material</span>. Every recipient of the Licensed Material automatically receives an offer from the Licensor to exercise the Licensed Rights under the terms and conditions of this Public License.</li><li><span style="text-decoration: underline;">Additional offer from the Licensor – Adapted Material</span>. Every recipient of Adapted Material from You automatically receives an offer from the Licensor to exercise the Licensed Rights in the Adapted Material under the conditions of the Adapter&#39;s License You apply.</li><li><span style="text-decoration: underline;">No downstream restrictions</span>. You may not offer or impose any additional or different terms or conditions on, or apply any Effective Technological Measures to, the Licensed Material if doing so restricts exercise of the Licensed Rights by any recipient of the Licensed Material.</li></ol></div></li><li><span style="text-decoration: underline;">No endorsement</span>. Nothing in this Public License constitutes or may be construed as permission to assert or imply that You are, or that Your use of the Licensed Material is, connected with, or sponsored, endorsed, or granted official status by, the Licensor or others designated to receive attribution as provided in Section 3(a)(1)(A)(i).</li></ol></li><li><p><strong>Other rights</strong>.</p><ol><li>Moral rights, such as the right of integrity, are not licensed under this Public License, nor are publicity, privacy, and/or other similar personality rights; however, to the extent possible, the Licensor waives and/or agrees not to assert any such rights held by the Licensor to the limited extent necessary to allow You to exercise the Licensed Rights, but not otherwise.</li><li>Patent and trademark rights are not licensed under this Public License.</li><li>To the extent possible, the Licensor waives any right to collect royalties from You for the exercise of the Licensed Rights, whether directly or through a collecting society under any voluntary or waivable statutory or compulsory licensing scheme. In all other cases the Licensor expressly reserves any right to collect such royalties.</li></ol></li></ol><p><strong>Section 3 – License Conditions.</strong></p><p>Your exercise of the Licensed Rights is expressly made subject to the following conditions.</p><ol><li><p><strong>Attribution</strong>.</p><ol><li><p>If You Share the Licensed Material (including in modified form), You must:</p><ol><li>retain the following if it is supplied by the Licensor with the Licensed Material:<ol><li>identification of the creator(s) of the Licensed Material and any others designated to receive attribution, in any reasonable manner requested by the Licensor (including by pseudonym if designated);</li><li>a copyright notice;</li><li>a notice that refers to this Public License; </li><li>a notice that refers to the disclaimer of warranties;</li><li>a URI or hyperlink to the Licensed Material to the extent reasonably practicable;</li></ol></li><li>indicate if You modified the Licensed Material and retain an indication of any previous modifications; and</li><li>indicate the Licensed Material is licensed under this Public License,and include the text of, or the URI or hyperlink to, this PublicLicense.</li></ol></li><li>You may satisfy the conditions in Section 3(a)(1) in any reasonable manner based on the medium, means, and context in which You Share the Licensed Material. For example, it may be reasonable to satisfy the conditions by providing a URI or hyperlink to a resource that includes the required information.</li><li>If requested by the Licensor, You must remove any of the information required by Section 3(a)(1)(A) to the extent reasonably practicable.</li></ol></li><li><strong>ShareAlike</strong>.<p>In addition to the conditions in Section 3(a), if You Share Adapted Material You produce, the following conditions also apply.</p><ol><li>The Adapter&#39;s License You apply must be a Creative Commons license with the same License Elements, this version or later, or a BY-SA Compatible License.</li><li>You must include the text of, or the URI or hyperlink to, the Adapter&#39;s License You apply. You may satisfy this condition in any reasonable manner based on the medium, means, and context in which You Share Adapted Material.</li><li>You may not offer or impose any additional or different terms or conditions on, or apply any Effective Technological Measures to, Adapted Material that restrict exercise of the rights granted under the Adapter&#39;s License You apply.</li></ol></li></ol><p><strong>Section 4 – Sui Generis Database Rights.</strong></p><p>Where the Licensed Rights include Sui Generis Database Rights that apply to Your use of the Licensed Material:</p><ol><li>for the avoidance of doubt, Section 2(a)(1) grants You the right to extract, reuse, reproduce, and Share all or a substantial portion of the contents of the database;</li><li>if You include all or a substantial portion of the database contents in a database in which You have Sui Generis Database Rights, then the database in which You have Sui Generis Database Rights (but not its individual contents) is Adapted Material, including for purposes of Section 3(b); and</li><li>You must comply with the conditions in Section 3(a) if You Share all or a substantial portion of the contents of the database.</li></ol>For the avoidance of doubt, this Section 4 supplements and does not replace Your obligations under this Public License where the Licensed Rights include other Copyright and Similar Rights.<p><strong>Section 5 – Disclaimer of Warranties and Limitation of Liability.</strong></p><ol style="font-weight: bold;"><li><strong>Unless otherwise separately undertaken by the Licensor, to the extent possible, the Licensor offers the Licensed Material as-is and as-available, and makes no representations or warranties of any kind concerning the Licensed Material, whether express, implied, statutory, or other. This includes, without limitation, warranties of title, merchantability, fitness for a particular purpose, non-infringement, absence of latent or other defects, accuracy, or the presence or absence of errors, whether or not known or discoverable. Where disclaimers of warranties are not allowed in full or in part, this disclaimer may not apply to You.</strong></li><li><strong>To the extent possible, in no event will the Licensor be liable to You on any legal theory (including, without limitation, negligence) or otherwise for any direct, special, indirect, incidental, consequential, punitive, exemplary, or other losses, costs, expenses, or damages arising out of this Public License or use of the Licensed Material, even if the Licensor has been advised of the possibility of such losses, costs, expenses, or damages. Where a limitation of liability is not allowed in full or in part, this limitation may not apply to You.</strong></li></ol><ol start="3"><li>The disclaimer of warranties and limitation of liability provided above shall be interpreted in a manner that, to the extent possible, most closely approximates an absolute disclaimer and waiver of all liability.</li></ol><p><strong>Section 6 – Term and Termination.</strong></p><ol><li>This Public License applies for the term of the Copyright and Similar Rights licensed here. However, if You fail to comply with this Public License, then Your rights under this Public License terminate automatically.</li><li><p>Where Your right to use the Licensed Material has terminated under Section 6(a), it reinstates:</p><ol><li>automatically as of the date the violation is cured, provided it is cured within 30 days of Your discovery of the violation; or</li><li>upon express reinstatement by the Licensor.</li></ol>For the avoidance of doubt, this Section 6(b) does not affect any right the Licensor may have to seek remedies for Your violations of this Public License.</li><li>For the avoidance of doubt, the Licensor may also offer the Licensed Material under separate terms or conditions or stop distributing the Licensed Material at any time; however, doing so will not terminate this Public License.</li><li>Sections 1, 5, 6, 7, and 8 survive termination of this Public License.</li></ol><p><strong>Section 7 – Other Terms and Conditions.</strong></p><ol><li>The Licensor shall not be bound by any additional or different terms or conditions communicated by You unless expressly agreed.</li><li>Any arrangements, understandings, or agreements regarding the Licensed Material not stated herein are separate from and independent of the terms and conditions of this Public License.</li></ol><p><strong>Section 8 – Interpretation.</strong></p><ol><li>For the avoidance of doubt, this Public License does not, and shall not be interpreted to, reduce, limit, restrict, or impose conditions on any use of the Licensed Material that could lawfully be made without permission under this Public License.</li><li>To the extent possible, if any provision of this Public License is deemed unenforceable, it shall be automatically reformed to the minimum extent necessary to make it enforceable. If the provision cannot be reformed, it shall be severed from this Public License without affecting the enforceability of the remaining terms and conditions.</li><li>No term or condition of this Public License will be waived and no failure to comply consented to unless expressly agreed to by the Licensor.</li><li>Nothing in this Public License constitutes or may be interpreted as a limitation upon, or waiver of, any privileges and immunities that apply to the Licensor or You, including from the legal processes of any jurisdiction or authority.</li></ol>');
INSERT INTO text VALUES ('LICENSE_GPLV3_SUMMARY', 'en', 'LICENSE', ''); -- TODO
INSERT INTO text VALUES ('LICENSE_GPLV3', 'en', 'LICENSE', ''); -- TODO
INSERT INTO license VALUES ('CC-BY-SA', 'LICENSE_CC-BY-SA_SUMMARY', 'LICENSE_CC-BY-SA', 'CC-BY-SA.png', 'CC-BY-SA.png');
INSERT INTO license VALUES ('GPLv3', 'LICENSE_GPLV3_SUMMARY', 'LICENSE_GPLV3', 'GPLV3.png', 'GPLV3.png');

-- TABLE project
INSERT INTO text VALUES ('PROJECT_EXAMPLE', 'es', 'DB_PROJECT', 'Proyecto ejemplo');
INSERT INTO text VALUES ('PROJECT_EXAMPLE', 'en', 'DB_PROJECT', 'Example project');
INSERT INTO text VALUES ('PROJECT_EXAMPLE', 'eu', 'DB_PROJECT', 'Proyecto ejemplo');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_HEADER', 'es', 'DB_PROJECT', 'Proyecto de ejemplo.');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_HEADER', 'en', 'DB_PROJECT', 'Example projectt.');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_HEADER', 'eu', 'DB_PROJECT', 'Proyecto de ejemplo.');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_TEXT', 'es', 'DB_PROJECT', 'Description del proyecto de ejemplo.');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_TEXT', 'en', 'DB_PROJECT', 'Example project description.');
INSERT INTO text VALUES ('PROJECT_EXAMPLE_TEXT', 'eu', 'DB_PROJECT', 'Description del proyecto de ejemplo..');
INSERT INTO project VALUES (1, 'example', 'D', 'PROJECT_EXAMPLE', 'example.png', 'PROJECT_EXAMPLE_HEADER', 'PROJECT_EXAMPLE_TEXT', 'GPLv3', 1, 1, 1);

-- TABLE project_tag
INSERT INTO text VALUES ('TAG_EXAMPLE', 'es', 'TAG', 'Ejemplo');
INSERT INTO text VALUES ('TAG_EXAMPLE', 'en', 'TAG', 'Example');
INSERT INTO text VALUES ('TAG_EXAMPLE', 'eu', 'TAG', 'Ejemplo');

INSERT INTO project_tag VALUES (1, 'TAG_EXAMPLE');


-- TABLE project_url
INSERT INTO project_url VALUES (1, 'E', '/project/example/index.html');
INSERT INTO project_url VALUES (1, 'G', 'https://github.com/user/project');



-- TABLE project_version
INSERT INTO text VALUES ('VERSION_EXAMPLE_0.1', 'es', 'DB_VERSION', 'Primera versi&oacute;n del proyecto de ejemplo.');
INSERT INTO text VALUES ('VERSION_EXAMPLE_0.1', 'en', 'DB_VERSION', 'First version.');
INSERT INTO text VALUES ('VERSION_EXAMPLE_0.1', 'eu', 'DB_VERSION', 'Primera versi&oacute;n del proyecto de ejemplo');
INSERT INTO project_version VALUES (1, 1, '0.1', 'B', 'VERSION_EXAMPLE_0.1', null, str_to_date('2014-04-14', '%Y-%m-%d'), 1);


-- TABLE cv_category
INSERT INTO text VALUES ('CV_CATEGORY_WORK', 'es', 'DB_CV', 'Experiencia');
INSERT INTO text VALUES ('CV_CATEGORY_WORK', 'en', 'DB_CV', 'Experience');
INSERT INTO text VALUES ('CV_CATEGORY_WORK', 'eu', 'DB_CV', 'Experiencia');
INSERT INTO text VALUES ('CV_CATEGORY_EDUCATION', 'es', 'DB_CV', 'Formaci&oacute;n');
INSERT INTO text VALUES ('CV_CATEGORY_EDUCATION', 'en', 'DB_CV', 'Hezkuntza');
INSERT INTO text VALUES ('CV_CATEGORY_EDUCATION', 'eu', 'DB_CV', 'Education');
INSERT INTO cv_category VALUES (1, 'CV_CATEGORY_WORK', null, 1 , 1);
INSERT INTO cv_category VALUES (2, 'CV_CATEGORY_EDUCATION', null, 1 , 3);
