add debian 8 jessie

2 files changed, 67 insertions, 24 deletions

diff --git a/h-source/MySQL_changelog/429_to_430_update_sql.sql b/h-source/MySQL_changelog/429_to_430_update_sql.sql
new file mode 100644
index 0000000..7994e67
--- /dev/null
+++ b/h-source/MySQL_changelog/429_to_430_update_sql.sql
@@ -0,0 +1,42 @@
+-- Apply these queries in order to update your database from revision 422 to revision 422
+
+drop table distros;
+
+create table distros (
+	id_distro INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	clean_name varchar(200) CHARACTER SET utf8 not null,
+	full_name varchar(200) CHARACTER SET utf8 not null,
+	id_order INT UNSIGNED NOT NULL
+)engine=innodb;
+
+insert into distros (clean_name, full_name, id_order) values ('blag_90001', 'BLAG 90001', 1);
+insert into distros (clean_name, full_name, id_order) values ('blag_120000', 'BLAG 120000', 2);
+insert into distros (clean_name, full_name, id_order) values ('blag_140000', 'BLAG 1400000', 3);
+insert into distros (clean_name, full_name, id_order) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4);
+insert into distros (clean_name, full_name, id_order) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5);
+insert into distros (clean_name, full_name, id_order) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6);
+insert into distros (clean_name, full_name, id_order) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7);
+insert into distros (clean_name, full_name, id_order) values ('dragora_1_1', 'Dragora 1.1', 8);
+insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9);
+insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10);
+insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11);
+insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15);
+insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 16);
+insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 17);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 18);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 19);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 20);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 21);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 22);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 23);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 24);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 25);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 26);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 27);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 28);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 29);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 30);
diff --git a/h-source/tables.sql b/h-source/tables.sql
index e83ae8f..246b75a 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -570,29 +570,30 @@ insert into distros (clean_name, full_name, id_order) values ('blag_140000', 'BL
 insert into distros (clean_name, full_name, id_order) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4);
 insert into distros (clean_name, full_name, id_order) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5);
 insert into distros (clean_name, full_name, id_order) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6);
-insert into distros (clean_name, full_name, id_order) values ('dragora_1_1', 'Dragora 1.1', 7);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 8);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 9);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 10);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 11);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 12);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 13);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 14);
-insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 15);
-insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 16);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 17);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 18);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 19);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 20);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 21);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 22);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 7.0 Belenos', 23);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 24);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 25);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 26);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 27);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 28);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 28);
+insert into distros (clean_name, full_name, id_order) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7);
+insert into distros (clean_name, full_name, id_order) values ('dragora_1_1', 'Dragora 1.1', 8);
+insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9);
+insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10);
+insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11);
+insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14);
+insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15);
+insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 16);
+insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 17);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 18);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 19);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 20);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 21);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 22);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 23);
+insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 7.0 Belenos', 24);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 25);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 26);
+insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 27);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 28);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 29);
+insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 30);
 
 insert into reggroups (name) values ('manager');
 insert into reggroups (name) values ('admin');
@@ -602,4 +603,4 @@ insert into regusers (username,password) values ('admin',sha1('admin'));
 
 insert into regusers_groups (id_user, id_group) values (1,1);
 insert into regusers_groups (id_user, id_group) values (1,2);
-insert into regusers_groups (id_user, id_group) values (1,3);
\ No newline at end of file
+insert into regusers_groups (id_user, id_group) values (1,3);