aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDenis 'GNUtoo' Carikli <GNUtoo@cyberdimension.org>2022-06-25 22:52:41 +0200
committerYuchen Pei <hi@ypei.me>2022-06-29 22:32:53 +1000
commit71f53b7022db9f838720aef598c31da24b3ea5fc (patch)
treea13d4d3508bcf7d7a002e3cb416aa257a049f6db
parent9f63d98ee32b416fbb46eb22571084bb0a7c05ac (diff)
distros: align distro id_order and active field
That will make the review easier when adding new distributions as this makes mistakes more visible when two lines are almost identical but one contains a mistake. Signed-off-by: Denis 'GNUtoo' Carikli <GNUtoo@cyberdimension.org>
-rw-r--r--distros.sql92
1 files changed, 46 insertions, 46 deletions
diff --git a/distros.sql b/distros.sql
index 21640ac..85861e7 100644
--- a/distros.sql
+++ b/distros.sql
@@ -9,50 +9,50 @@ create table distros (
active tinyint(1) NOT NULL DEFAULT 1
)engine=innodb;
-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, 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, 0);
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, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 0);
-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 ('debian_9', 'Debian GNU/Linux 9 stretch', 8, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_10', 'Debian GNU/Linux 10 buster', 9, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_11', 'Debian GNU/Linux 11 bullseye', 10, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_12', 'Debian GNU/Linux 12 bookworm', 11, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('dragora_1_1', 'Dragora 1.1', 12, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_0', 'Dragora 2.0 Ardi', 13, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 14, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 15, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 16, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 17, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 18, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 19, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 20, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 21, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('guix', 'GNU Guix System', 22, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('hyperbola', 'Hyperbola GNU/Linux', 23, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 24, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 25, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 26, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('pureos_8_0', 'PureOS 8.0 Prometheus', 27, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('pureos_9_0', 'PureOS 9.0 Amber', 28, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('pureos_10_0', 'PureOS 10.0 Byzantium', 29, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 30, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 31, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 32, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 33, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 34, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 35, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 36, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_8_0', 'Trisquel 8.0 Flidas', 37, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_9_0', 'Trisquel 9.0 Etiona', 38, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('trisquel_10_0', 'Trisquel 10.0 Nabia', 39, 1);
-insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 40, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 41, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 42, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 43, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 44, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 45, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_testing', 'Debian GNU/Linux Testing', 46, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('debian_unstable', 'Debian GNU/Linux Unstable', 47, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 0);
+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 ('debian_9', 'Debian GNU/Linux 9 stretch', 8, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_10', 'Debian GNU/Linux 10 buster', 9, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_11', 'Debian GNU/Linux 11 bullseye', 10, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_12', 'Debian GNU/Linux 12 bookworm', 11, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_1_1', 'Dragora 1.1', 12, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_0', 'Dragora 2.0 Ardi', 13, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 14, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 15, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 16, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 17, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 18, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 19, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 20, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 21, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('guix', 'GNU Guix System', 22, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('hyperbola', 'Hyperbola GNU/Linux', 23, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 24, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 25, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 26, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('pureos_8_0', 'PureOS 8.0 Prometheus', 27, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('pureos_9_0', 'PureOS 9.0 Amber', 28, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('pureos_10_0', 'PureOS 10.0 Byzantium', 29, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 30, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 31, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 32, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 33, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 34, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 35, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 36, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_8_0', 'Trisquel 8.0 Flidas', 37, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_9_0', 'Trisquel 9.0 Etiona', 38, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('trisquel_10_0', 'Trisquel 10.0 Nabia', 39, 1);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 40, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 41, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 42, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 43, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 44, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 45, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_testing', 'Debian GNU/Linux Testing', 46, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('debian_unstable', 'Debian GNU/Linux Unstable', 47, 0);