[H-source-users] [predev] branch predev updated: [bug #61318] Separating out distro schema and updated guix name.

[Yuchen Pei]

This is an automated email from the git hooks/post-receive script.

ycp pushed a commit to branch predev
in repository h-source.

The following commit(s) were added to refs/heads/predev by this push:
     new ef15e0e  [bug #61318] Separating out distro schema and updated guix 
name.
ef15e0e is described below

commit ef15e0e558c50e7797efde4e1d4cfaa6ff4a472f
Author: Yuchen Pei <hi@ypei.me>
AuthorDate: Tue Dec 14 20:43:41 2021 +1100

    [bug #61318] Separating out distro schema and updated guix name.
    
    - will document deployment process to reflect the change
---
 distros.sql | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++
 tables.sql  | 50 --------------------------------------------------
 2 files changed, 50 insertions(+), 50 deletions(-)

diff --git a/distros.sql b/distros.sql
new file mode 100644
index 0000000..1d785ec
--- /dev/null
+++ b/distros.sql
@@ -0,0 +1,50 @@
+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,
+       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 
('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 
('dragora_1_1', 'Dragora 1.1', 9, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('dragora_2_0', 'Dragora 2.0 Ardi', 10, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('dragora_2_2', 'Dragora 2.2 Rafaela', 11, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 12, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 13, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_2_3', 'gNewSense 2.3 Deltah', 14, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 15, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 16, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 17, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('guix_0_10', 'GuixSD 0.10', 18, 0);
+insert into distros (clean_name, full_name, id_order, active) values ('guix', 
'GNU Guix System', 19, 1);
+insert into distros (clean_name, full_name, id_order, active) values 
('musix_2_0', 'Musix GNU+Linux 2.0 R0', 20, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 21, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('parabola', 'Parabola GNU/Linux', 22, 1);
+insert into distros (clean_name, full_name, id_order, active) values 
('pureos_8_0', 'PureOS 8.0 Prometheus', 23, 1);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_3_5', 'Trisquel 3.5 Awen', 24, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_4_0', 'Trisquel 4.0 Taranis', 25, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_4_5', 'Trisquel 4.5 Slaine', 26, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_5_0', 'Trisquel 5.0 Dagda', 27, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_5_5', 'Trisquel 5.5 Brigantia', 28, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_6_0', 'Trisquel 6.0 Toutatis', 29, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_7_0', 'Trisquel 7.0 Belenos', 30, 1);
+insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_8_0', 'Trisquel 8.0 Flidas', 31, 1);
+insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2009', 'UTUTO XS 2009', 32, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2010', 'UTUTO XS 2010', 33, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2012_04', 'UTUTO XS 2012.04', 34, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_8', 'VENENUX 0.8', 35, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_8_2', 'VENENUX-EC 0.8.2', 36, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_9', 'VENENUX 0.9', 37, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('debian_testing', 'Debian GNU/Linux Testing', 38, 0);
+insert into distros (clean_name, full_name, id_order, active) values 
('debian_unstable', 'Debian GNU/Linux Unstable', 39, 0);
diff --git a/tables.sql b/tables.sql
index 1382eb9..0085b42 100644
--- a/tables.sql
+++ b/tables.sql
@@ -555,56 +555,6 @@ create table vendors (
        unique(bus,vendorid)
 )engine=innodb;
 
-
-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,
-       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 
('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 
('dragora_1_1', 'Dragora 1.1', 9, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('dragora_2_0', 'Dragora 2.0 Ardi', 10, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('dragora_2_2', 'Dragora 2.2 Rafaela', 11, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 12, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 13, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_2_3', 'gNewSense 2.3 Deltah', 14, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 15, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 16, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 17, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('guix_0_10', 'GuixSD 0.10', 18, 0);
-insert into distros (clean_name, full_name, id_order, active) values ('guix', 
'GuixSD', 19, 1);
-insert into distros (clean_name, full_name, id_order, active) values 
('musix_2_0', 'Musix GNU+Linux 2.0 R0', 20, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 21, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('parabola', 'Parabola GNU/Linux', 22, 1);
-insert into distros (clean_name, full_name, id_order, active) values 
('pureos_8_0', 'PureOS 8.0 Prometheus', 23, 1);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_3_5', 'Trisquel 3.5 Awen', 24, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_4_0', 'Trisquel 4.0 Taranis', 25, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_4_5', 'Trisquel 4.5 Slaine', 26, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_5_0', 'Trisquel 5.0 Dagda', 27, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_5_5', 'Trisquel 5.5 Brigantia', 28, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_6_0', 'Trisquel 6.0 Toutatis', 29, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_7_0', 'Trisquel 7.0 Belenos', 30, 1);
-insert into distros (clean_name, full_name, id_order, active) values 
('trisquel_8_0', 'Trisquel 8.0 Flidas', 31, 1);
-insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2009', 'UTUTO XS 2009', 32, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2010', 'UTUTO XS 2010', 33, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('ututo_xs_2012_04', 'UTUTO XS 2012.04', 34, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_8', 'VENENUX 0.8', 35, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_8_2', 'VENENUX-EC 0.8.2', 36, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('venenux_0_9', 'VENENUX 0.9', 37, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('debian_testing', 'Debian GNU/Linux Testing', 38, 0);
-insert into distros (clean_name, full_name, id_order, active) values 
('debian_unstable', 'Debian GNU/Linux Unstable', 39, 0);
-
 insert into reggroups (name) values ('manager');
 insert into reggroups (name) values ('admin');
 insert into reggroups (name) values ('moderator');