From d4fad0e1e0c4968fef39c8fbf905916abd76df28 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Thu, 25 Jun 2015 08:24:49 +0000 Subject: added Trisquel 7.0 --- h-source/Application/Include/params.php | 6 ++-- h-source/Config/Config.php | 8 ++--- h-source/MySQL_changelog/423_to_429_update_sql.sql | 41 ++++++++++++++++++++++ h-source/tables.sql | 11 +++--- 4 files changed, 54 insertions(+), 12 deletions(-) create mode 100644 h-source/MySQL_changelog/423_to_429_update_sql.sql (limited to 'h-source') diff --git a/h-source/Application/Include/params.php b/h-source/Application/Include/params.php index 2cb1b3f..19f1ed7 100644 --- a/h-source/Application/Include/params.php +++ b/h-source/Application/Include/params.php @@ -22,7 +22,7 @@ if (!defined('EG')) die('Direct access not allowed!'); class Website { - static public $generalMail = "test@apineindustriose.org"; + static public $generalMail = ""; static public $fromEmail = "noreply@h-node.org"; @@ -30,9 +30,9 @@ class Website static public $projectName = "h-node"; - static public $mailServer = "smtp.apineindustriose.org"; + static public $mailServer = ""; - static public $mailPassword = "lt241rskav1"; + static public $mailPassword = ""; static public $allowAnonymousSubmission = "yes"; diff --git a/h-source/Config/Config.php b/h-source/Config/Config.php index bea5562..7f8d0cd 100755 --- a/h-source/Config/Config.php +++ b/h-source/Config/Config.php @@ -23,10 +23,10 @@ if (!defined('EG')) die('Direct access not allowed!'); -define('DB', ''); -define('USER', ''); -define('PWD', ''); -define('HOST', ''); +define('DB', 'h-source'); +define('USER', 'root'); +define('PWD', 'Nnppdclp12vag'); +define('HOST', 'localhost'); /*default controller name*/ define('DEFAULT_CONTROLLER','home'); diff --git a/h-source/MySQL_changelog/423_to_429_update_sql.sql b/h-source/MySQL_changelog/423_to_429_update_sql.sql new file mode 100644 index 0000000..734113c --- /dev/null +++ b/h-source/MySQL_changelog/423_to_429_update_sql.sql @@ -0,0 +1,41 @@ +-- 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/tables.sql b/h-source/tables.sql index 6b0f6d6..e83ae8f 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -586,11 +586,12 @@ insert into distros (clean_name, full_name, id_order) values ('trisquel_4_5', 'T 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 ('trisquel_6_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); insert into reggroups (name) values ('manager'); -- cgit v1.2.3