diff options
Diffstat (limited to 'docs/manual/smsd')
-rw-r--r-- | docs/manual/smsd/mysql.rst | 21 | ||||
-rw-r--r-- | docs/manual/smsd/odbc.rst | 4 | ||||
-rw-r--r-- | docs/manual/smsd/pgsql.rst | 2 | ||||
-rw-r--r-- | docs/manual/smsd/sql.rst | 2 |
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 ------ |