From 2016e9b41ee60b12d4cb23f8fd7440b4980b63f0 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Fri, 16 May 2014 15:46:54 +0000 Subject: changed MySQL update sql to revision 422 --- h-source/MySQL_changelog/420_to_421_update_sql.sql | 48 ---------------------- 1 file changed, 48 deletions(-) delete mode 100644 h-source/MySQL_changelog/420_to_421_update_sql.sql (limited to 'h-source/MySQL_changelog/420_to_421_update_sql.sql') diff --git a/h-source/MySQL_changelog/420_to_421_update_sql.sql b/h-source/MySQL_changelog/420_to_421_update_sql.sql deleted file mode 100644 index 32245af..0000000 --- a/h-source/MySQL_changelog/420_to_421_update_sql.sql +++ /dev/null @@ -1,48 +0,0 @@ --- Apply these queries in order to update your database from revision 420 to revision 421 - -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); - -insert into reggroups (name) values ('manager'); -insert into reggroups (name) values ('admin'); -insert into reggroups (name) values ('moderator'); - -insert into regusers (username,password) values ('admin',sha1('admin')); - -insert into regusers_groups (id_user, id_group) values (1,1); -- cgit v1.2.3