From bb4898d22c820e031d52eb71599e9e8437989eae Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Sun, 13 Oct 2013 11:14:07 +0000 Subject: added table distros to containt the list of allowed distros so h-node.org admin can update the list from the admin panel --- h-source/MySQL_changelog/412_to_413_update_sql.sql | 36 +++++++++++++++++++++ h-source/tables.sql | 37 +++++++++++++++++++++- 2 files changed, 72 insertions(+), 1 deletion(-) create mode 100644 h-source/MySQL_changelog/412_to_413_update_sql.sql (limited to 'h-source') diff --git a/h-source/MySQL_changelog/412_to_413_update_sql.sql b/h-source/MySQL_changelog/412_to_413_update_sql.sql new file mode 100644 index 0000000..65a9316 --- /dev/null +++ b/h-source/MySQL_changelog/412_to_413_update_sql.sql @@ -0,0 +1,36 @@ +-- NB: only if you are currently working with the revision 412 (otherwise apply all the steps to get to revision 412)!! +-- Apply these queries in order to update your database and work with revision 413 + +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 ('dragora_1_1', 'Dragora 1.1', 4); +insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 5); +insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 6); +insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 7); +insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 8); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 9); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 10); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 11); +insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 12); +insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 13); +insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 14); +insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 15); +insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 16); +insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 17); +insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 18); +insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 19); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 20); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 21); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 22); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 23); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 24); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 25); \ No newline at end of file diff --git a/h-source/tables.sql b/h-source/tables.sql index 7d75b76..a695600 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -551,4 +551,39 @@ create table vendors ( full_name varchar(200) CHARACTER SET utf8 not null, bus ENUM('PCI', 'USB'), unique(bus,vendorid) -)engine=innodb; \ No newline at end of file +)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 +)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 ('dragora_1_1', 'Dragora 1.1', 4); +insert into distros (clean_name, full_name, id_order) values ('dragora_2_0', 'Dragora 2.0 Ardi', 5); +insert into distros (clean_name, full_name, id_order) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 6); +insert into distros (clean_name, full_name, id_order) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 7); +insert into distros (clean_name, full_name, id_order) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 8); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 9); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 10); +insert into distros (clean_name, full_name, id_order) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 11); +insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 12); +insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 13); +insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 14); +insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 15); +insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 16); +insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 17); +insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 18); +insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 19); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 20); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 21); +insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 22); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 23); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 24); +insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 25); -- cgit v1.2.3