[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 196/323: Fix SQL
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 196/323: Fix SQL |
Date: |
Wed, 14 Mar 2018 17:38:48 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit ed461f9d549a098416474813359c3ec4409f5143
Author: Dany De Bontridder <address@hidden>
Date: Sat Feb 10 23:12:26 2018 +0100
Fix SQL
---
html/install.php | 2 +-
include/sql/account_repository/data.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/html/install.php b/html/install.php
index 0e414a1..c770c84 100644
--- a/html/install.php
+++ b/html/install.php
@@ -526,7 +526,7 @@ if ($account == 0 ) {
$cn->execute_script(NOALYSS_INCLUDE."/sql/account_repository/constraint.sql");
/* update name administrator */
$cadmin=NOALYSS_ADMINISTRATOR;
- $cn->exec_sql("update ac_users set use_login=$1 where use_id=1",
+ $cn->exec_sql("update ac_users set use_login=$1,use_active=1 where use_id=1",
array(strtolower($cadmin)));
$cn->commit($cn);
diff --git a/include/sql/account_repository/data.sql
b/include/sql/account_repository/data.sql
index 7cd908d..c97cbde 100644
--- a/include/sql/account_repository/data.sql
+++ b/include/sql/account_repository/data.sql
@@ -11,7 +11,7 @@ SET client_min_messages = warning;
INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active,
use_pass, use_admin, use_email) VALUES (4, 'demo', 'demo', 'demo', 0,
'fe01ce2a7fbac8fafaed7c982a04e229', 0, NULL);
-INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active,
use_pass, use_admin, use_email) VALUES (1, NULL, NULL, 'admin', 0,
'b1cc88e1907cde80cb2595fa793b3da9', 1, NULL);
+INSERT INTO ac_users (use_id, use_first_name, use_name, use_login, use_active,
use_pass, use_admin, use_email) VALUES (1, NULL, NULL, 'admin', 1,
'b1cc88e1907cde80cb2595fa793b3da9', 1, NULL);
- [Noalyss-commit] [noalyss] 204/323: change email, (continued)
- [Noalyss-commit] [noalyss] 204/323: change email, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 191/323: Fix SQL, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 186/323: Merge branch 'master' into sql-review-700, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 223/323: Dashboard : Event hour is not mandatory, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 224/323: Dashboard : Add event improve cosmetic, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 205/323: CSS : recover box, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 210/323: sorttable.js : alternate properly the color of the table rows, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 220/323: Welcome : adapt to small screen, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 195/323: demo is inactive by default, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 211/323: sorttable.js : Add an icon if the column is already sorted, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 196/323: Fix SQL,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 227/323: patch sql : remove commented code, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 225/323: Dashboard : Fix box, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 181/323: Task #0001535: TVA : réécriture du module CFGTVA, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 183/323: Task #0001536: Achat - Vente : n'utilisez que les codes TVA disponibles, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 215/323: Plugin : fix doc, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 213/323: Plugin : fix indent, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 234/323: Fix warning, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 230/323: index.css : CSS responsive, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 249/323: SQL Patch : correct syntax for new version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 252/323: PLANANC : fix bug when creating first plan, Dany De Bontridder, 2018/03/14