summaryrefslogtreecommitdiff
path: root/docs/manual/smsd
diff options
context:
space:
mode:
Diffstat (limited to 'docs/manual/smsd')
-rw-r--r--docs/manual/smsd/mysql.rst21
-rw-r--r--docs/manual/smsd/odbc.rst4
-rw-r--r--docs/manual/smsd/pgsql.rst2
-rw-r--r--docs/manual/smsd/sql.rst2
4 files changed, 23 insertions, 6 deletions
diff --git a/docs/manual/smsd/mysql.rst b/docs/manual/smsd/mysql.rst
index d57f6c0..19b59bf 100644
--- a/docs/manual/smsd/mysql.rst
+++ b/docs/manual/smsd/mysql.rst
@@ -50,14 +50,22 @@ privileges should be enough:
For creating the SQL tables you need more privileges, especially for
creating triggers, which are used for some functionality.
-.. _MySQL: http://www.mysql.com/
+.. _MySQL: https://www.mysql.com/
.. _mysql-create:
Creating tables for MySQL
-------------------------
-SQL script for creating tables in MySQL database:
+Depending on MySQL version and settings please choose best fitting
+script to create tables:
+
+* :file:`mysql-strict.sql` can be used in strict mode, but requires MySQL 5.6.5
+ or newer
+* :file:`mysql.sql` supports all MySQL versions, but requires neither of
+ `NO_ZERO_DATE`, `ANSI` or `STRICT` modes to be set in the server
+
+SQL script :file:`mysql.sql` for creating tables in MySQL database:
.. literalinclude:: ../../sql/mysql.sql
:language: mysql
@@ -66,6 +74,15 @@ SQL script for creating tables in MySQL database:
You can find the script in :file:`docs/sql/mysql.sql` as well.
+SQL script :file:`mysql-strict.sql` for creating tables in MySQL database:
+
+.. literalinclude:: ../../sql/mysql-strict.sql
+ :language: mysql
+
+.. note::
+
+ You can find the script in :file:`docs/sql/mysql-strict.sql` as well.
+
Upgrading tables
----------------
diff --git a/docs/manual/smsd/odbc.rst b/docs/manual/smsd/odbc.rst
index fd78044..e9efe10 100644
--- a/docs/manual/smsd/odbc.rst
+++ b/docs/manual/smsd/odbc.rst
@@ -22,7 +22,7 @@ Supported drivers
On Microsoft Windows, Gammu uses native ODBC, on other platforms, `unixODBC`_
can be used.
-.. _ODBC: http://en.wikipedia.org/wiki/Open_Database_Connectivity
+.. _ODBC: https://en.wikipedia.org/wiki/Open_Database_Connectivity
.. _unixODBC: http://www.unixodbc.org/
Limitations
@@ -51,7 +51,7 @@ You specify data source name (DSN) as :config:option:`Host` in
Windows or in global configuration on Linux).
On Microsoft Windows, you can find instructions on Microsoft website:
-http://support.microsoft.com/kb/305599
+https://support.microsoft.com/kb/305599
For unixODBC this is documented in the user manual:
http://www.unixodbc.org/doc/UserManual/
diff --git a/docs/manual/smsd/pgsql.rst b/docs/manual/smsd/pgsql.rst
index 021456f..eb55b62 100644
--- a/docs/manual/smsd/pgsql.rst
+++ b/docs/manual/smsd/pgsql.rst
@@ -14,7 +14,7 @@ For tables description see :ref:`gammu-smsd-tables`.
This backend is based on :ref:`gammu-smsd-sql`.
-.. _PostgreSQL: http://www.postgresql.org/
+.. _PostgreSQL: https://www.postgresql.org/
Configuration
-------------
diff --git a/docs/manual/smsd/sql.rst b/docs/manual/smsd/sql.rst
index 190abcf..fd894e0 100644
--- a/docs/manual/smsd/sql.rst
+++ b/docs/manual/smsd/sql.rst
@@ -37,7 +37,7 @@ Specific for DBI:
.. seealso:: The variables are fully described in :ref:`gammurc` documentation.
-.. _Custom tables:
+.. _Configurable tables:
Tables
------