aboutsummaryrefslogtreecommitdiff
path: root/h-source
diff options
context:
space:
mode:
authorIan Gilfillan <ian@greenman.co.za>2016-07-19 20:35:23 +0000
committerIan Gilfillan <ian@greenman.co.za>2016-07-19 20:35:23 +0000
commitae9775b52ffadec19f6ebb5a9fc8d858953180da (patch)
tree025a9d79d702ac22a08e55752a4d8374215fc5a9 /h-source
parente8a65561680b518e29bd96004ef132cdb1db913f (diff)
Correct insert for distros table
Diffstat (limited to 'h-source')
-rw-r--r--h-source/MySQL_changelog/436_to_442_update_sql.sql67
-rw-r--r--h-source/tables.sql66
2 files changed, 67 insertions, 66 deletions
diff --git a/h-source/MySQL_changelog/436_to_442_update_sql.sql b/h-source/MySQL_changelog/436_to_442_update_sql.sql
index b5d33be..c86970e 100644
--- a/h-source/MySQL_changelog/436_to_442_update_sql.sql
+++ b/h-source/MySQL_changelog/436_to_442_update_sql.sql
@@ -11,36 +11,37 @@ create table distros (
active tinyint(1) NOT NULL DEFAULT 1
)engine=innodb;
-insert into distros (clean_name, full_name, id_order) values ('blag_90001', 'BLAG 90001', 1, 0);
-insert into distros (clean_name, full_name, id_order) values ('blag_120000', 'BLAG 120000', 2, 0);
-insert into distros (clean_name, full_name, id_order) values ('blag_140000', 'BLAG 1400000', 3, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7, 1);
-insert into distros (clean_name, full_name, id_order) values ('dragora_1_1', 'Dragora 1.1', 8, 0);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9, 0);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10, 0);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11, 0);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15), 0;
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 16, 1);
-insert into distros (clean_name, full_name, id_order) values ('guix_0_10', 'GuixSD 0.10', 17, 1);
-insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 18, 0);
-insert into distros (clean_name, full_name, id_order) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 19, 0);
-insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 20, 1);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 21, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 22, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 23, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 24, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 25, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 26, 1);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 27, 1);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 28, 0);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 29, 0);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 30, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 31, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 32, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 33, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_90001', 'BLAG 90001', 1, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_120000', 'BLAG 120000', 2, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_140000', 'BLAG 1400000', 3, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_1_1', 'Dragora 1.1', 8, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 16, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 17, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 18, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 19, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 20, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 21, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 22, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 23, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 24, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 25, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 26, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 27, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 28, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 29, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 30, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 31, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 32, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 33, 0);
+
diff --git a/h-source/tables.sql b/h-source/tables.sql
index a6762e3..609eafc 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -565,39 +565,39 @@ create table distros (
active tinyint(1) NOT NULL DEFAULT 1
)engine=innodb;
-insert into distros (clean_name, full_name, id_order) values ('blag_90001', 'BLAG 90001', 1, 0);
-insert into distros (clean_name, full_name, id_order) values ('blag_120000', 'BLAG 120000', 2, 0);
-insert into distros (clean_name, full_name, id_order) values ('blag_140000', 'BLAG 1400000', 3, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 1);
-insert into distros (clean_name, full_name, id_order) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7, 1);
-insert into distros (clean_name, full_name, id_order) values ('dragora_1_1', 'Dragora 1.1', 8, 0);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9, 0);
-insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10, 0);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11, 0);
-insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14, 0);
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15), 0;
-insert into distros (clean_name, full_name, id_order) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 16, 1);
-insert into distros (clean_name, full_name, id_order) values ('guix_0_10', 'GuixSD 0.10', 17, 1);
-insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 18, 0);
-insert into distros (clean_name, full_name, id_order) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 19, 0);
-insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 20, 1);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 21, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 22, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 23, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 24, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 25, 0);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 26, 1);
-insert into distros (clean_name, full_name, id_order) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 27, 1);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 28, 0);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 29, 0);
-insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 30, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 31, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 32, 0);
-insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 33, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_90001', 'BLAG 90001', 1, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_120000', 'BLAG 120000', 2, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('blag_140000', 'BLAG 1400000', 3, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_1_1', 'Dragora 1.1', 8, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_0', 'Dragora 2.0 Ardi', 9, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 10, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 11, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 12, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 13, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 14, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 15, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 16, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 17, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 18, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 19, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 20, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 21, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 22, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 23, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 24, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 25, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 26, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 27, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 28, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 29, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 30, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 31, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 32, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 33, 0);
insert into reggroups (name) values ('manager');
insert into reggroups (name) values ('admin');