diff options
Diffstat (limited to 'h-source/MySQL_changelog')
| -rw-r--r-- | h-source/MySQL_changelog/412_to_413_update_sql.sql | 36 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/413_to_419_update_sql.sql | 4 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/419_to_420_update_sql.sql | 40 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/420_to_422_update_sql.sql | 40 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/422_to_423_update_sql.sql | 41 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/423_to_429_update_sql.sql | 41 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/429_to_430_update_sql.sql | 42 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/430_to_436_update_sql.sql | 45 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/436_to_442_update_sql.sql | 47 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/443_to_446_update_sql.sql | 51 | ||||
| -rw-r--r-- | h-source/MySQL_changelog/446_to_449_update_sql.sql | 51 | ||||
| -rwxr-xr-x | h-source/MySQL_changelog/449_to_450_update_sql.sql | 52 | ||||
| -rwxr-xr-x | h-source/MySQL_changelog/450_to_451_update_sql.sql | 52 |
13 files changed, 0 insertions, 542 deletions
diff --git a/h-source/MySQL_changelog/412_to_413_update_sql.sql b/h-source/MySQL_changelog/412_to_413_update_sql.sql deleted file mode 100644 index 65a9316..0000000 --- a/h-source/MySQL_changelog/412_to_413_update_sql.sql +++ /dev/null @@ -1,36 +0,0 @@ --- 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/MySQL_changelog/413_to_419_update_sql.sql b/h-source/MySQL_changelog/413_to_419_update_sql.sql deleted file mode 100644 index a17fc01..0000000 --- a/h-source/MySQL_changelog/413_to_419_update_sql.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Apply these queries in order to update your database from revision 413 to revision 419 - -alter table hardware modify kernel varchar(100) NOT NULL; -alter table revisions modify kernel varchar(100) NOT NULL; diff --git a/h-source/MySQL_changelog/419_to_420_update_sql.sql b/h-source/MySQL_changelog/419_to_420_update_sql.sql deleted file mode 100644 index 458361e..0000000 --- a/h-source/MySQL_changelog/419_to_420_update_sql.sql +++ /dev/null @@ -1,40 +0,0 @@ --- Apply these queries in order to update your database from revision 419 to revision 420 - -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_6_0', 'Debian GNU/Linux 6.0 squeeze', 4); -insert into distros (clean_name, full_name, id_order) values ('debian_7_0', 'Debian GNU/Linux 7.0 wheezy', 5); -insert into distros (clean_name, full_name, id_order) values ('debian_7_5', 'Debian GNU/Linux 7.5 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 ('ututo_xs_2009', 'UTUTO XS 2009', 23); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 24); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 25); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 26); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 27); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 28); diff --git a/h-source/MySQL_changelog/420_to_422_update_sql.sql b/h-source/MySQL_changelog/420_to_422_update_sql.sql deleted file mode 100644 index ef987d5..0000000 --- a/h-source/MySQL_changelog/420_to_422_update_sql.sql +++ /dev/null @@ -1,40 +0,0 @@ --- Apply these queries in order to update your database from revision 420 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 ('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 ('ututo_xs_2009', 'UTUTO XS 2009', 23); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 24); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 25); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 26); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 27); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 28); diff --git a/h-source/MySQL_changelog/422_to_423_update_sql.sql b/h-source/MySQL_changelog/422_to_423_update_sql.sql deleted file mode 100644 index b7deec8..0000000 --- a/h-source/MySQL_changelog/422_to_423_update_sql.sql +++ /dev/null @@ -1,41 +0,0 @@ --- 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_testing', 'Debian GNU/Linux Testing', 4); -insert into distros (clean_name, full_name, id_order) values ('debian_unstable', 'Debian GNU/Linux Unstable', 5); -insert into distros (clean_name, full_name, id_order) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 6); -insert into distros (clean_name, full_name, id_order) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 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 ('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', 29); diff --git a/h-source/MySQL_changelog/423_to_429_update_sql.sql b/h-source/MySQL_changelog/423_to_429_update_sql.sql deleted file mode 100644 index 734113c..0000000 --- a/h-source/MySQL_changelog/423_to_429_update_sql.sql +++ /dev/null @@ -1,41 +0,0 @@ --- 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 ('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_7_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); diff --git a/h-source/MySQL_changelog/429_to_430_update_sql.sql b/h-source/MySQL_changelog/429_to_430_update_sql.sql deleted file mode 100644 index 7994e67..0000000 --- a/h-source/MySQL_changelog/429_to_430_update_sql.sql +++ /dev/null @@ -1,42 +0,0 @@ --- 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/MySQL_changelog/430_to_436_update_sql.sql b/h-source/MySQL_changelog/430_to_436_update_sql.sql deleted file mode 100644 index 70bc259..0000000 --- a/h-source/MySQL_changelog/430_to_436_update_sql.sql +++ /dev/null @@ -1,45 +0,0 @@ --- Apply these queries in order to update your database from revision 430 to revision 436 - -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 ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 16); -insert into distros (clean_name, full_name, id_order) values ('guix_0_10', 'GuixSD 0.10', 17); -insert into distros (clean_name, full_name, id_order) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 18); -insert into distros (clean_name, full_name, id_order) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 19); -insert into distros (clean_name, full_name, id_order) values ('parabola', 'Parabola GNU/Linux', 20); -insert into distros (clean_name, full_name, id_order) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 21); -insert into distros (clean_name, full_name, id_order) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 22); -insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 23); -insert into distros (clean_name, full_name, id_order) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 24); -insert into distros (clean_name, full_name, id_order) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 25); -insert into distros (clean_name, full_name, id_order) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 26); -insert into distros (clean_name, full_name, id_order) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 27); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2009', 'UTUTO XS 2009', 28); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2010', 'UTUTO XS 2010', 29); -insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 30); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 31); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 32); -insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 33); diff --git a/h-source/MySQL_changelog/436_to_442_update_sql.sql b/h-source/MySQL_changelog/436_to_442_update_sql.sql deleted file mode 100644 index c86970e..0000000 --- a/h-source/MySQL_changelog/436_to_442_update_sql.sql +++ /dev/null @@ -1,47 +0,0 @@ --- Apply these queries in order to update your database from revision 436 to revision 442 - -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, 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/MySQL_changelog/443_to_446_update_sql.sql b/h-source/MySQL_changelog/443_to_446_update_sql.sql deleted file mode 100644 index 3fa3218..0000000 --- a/h-source/MySQL_changelog/443_to_446_update_sql.sql +++ /dev/null @@ -1,51 +0,0 @@ --- Apply these queries in order to update your database from revision 443 to revision 446 - -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, 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 ('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, 1); -insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 18, 1); -insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 19, 0); -insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 20, 0); -insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 21, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 22, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 23, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 24, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 25, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 26, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 27, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 28, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_8_0', 'Trisquel 8.0 Flidas', 29, 1); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 30, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 31, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 32, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 33, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 34, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 35, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_testing', 'Debian GNU/Linux Testing', 36, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_unstable', 'Debian GNU/Linux Unstable', 37, 0); - diff --git a/h-source/MySQL_changelog/446_to_449_update_sql.sql b/h-source/MySQL_changelog/446_to_449_update_sql.sql deleted file mode 100644 index 0eae780..0000000 --- a/h-source/MySQL_changelog/446_to_449_update_sql.sql +++ /dev/null @@ -1,51 +0,0 @@ --- Apply these queries in order to update your database from revision 446 to revision 449 - -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, 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 ('debian_9', 'Debian GNU/Linux 9 jessie', 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, 1); -insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 18, 1); -insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 19, 0); -insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 20, 0); -insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 21, 1); -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 ('trisquel_3_5', 'Trisquel 3.5 Awen', 23, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 24, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 25, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 26, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 27, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 28, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 29, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_8_0', 'Trisquel 8.0 Flidas', 30, 1); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 31, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 32, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 33, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 34, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 35, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 36, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_testing', 'Debian GNU/Linux Testing', 37, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_unstable', 'Debian GNU/Linux Unstable', 38, 0); diff --git a/h-source/MySQL_changelog/449_to_450_update_sql.sql b/h-source/MySQL_changelog/449_to_450_update_sql.sql deleted file mode 100755 index 3769cdd..0000000 --- a/h-source/MySQL_changelog/449_to_450_update_sql.sql +++ /dev/null @@ -1,52 +0,0 @@ --- Apply these queries in order to update your database from revision 449 to revision 450 - -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 jessie', 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); diff --git a/h-source/MySQL_changelog/450_to_451_update_sql.sql b/h-source/MySQL_changelog/450_to_451_update_sql.sql deleted file mode 100755 index b0cd21f..0000000 --- a/h-source/MySQL_changelog/450_to_451_update_sql.sql +++ /dev/null @@ -1,52 +0,0 @@ --- Apply these queries in order to update your database from revision 450 to revision 451 - -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', '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); |