Index: trunk/phase3/maintenance/sqlite/README |
— | — | @@ -1,12 +0,0 @@ |
2 | | -SQLite shares the MySQL schema file at maintenance/tables.sql, with a set of |
3 | | -compatibility regexes to convert MySQL syntax to SQLite syntax: |
4 | | - |
5 | | -* BINARY() and VARBINARY() fields are converted to BLOB |
6 | | -* the UNSIGNED modifier is removed |
7 | | -* "INT" fields are converted to "INTEGER" |
8 | | -* ENUM is converted to BLOB |
9 | | -* the BINARY collation modifier is removed |
10 | | -* AUTO_INCREMENT is converted to AUTOINCREMENT |
11 | | -* Any table options are removed |
12 | | -* Truncated indexes are upgraded to full-width indexes |
13 | | -* FULLTEXT indexes are converted to ordinary indexes |
Index: trunk/phase3/maintenance/ibm_db2/README |
— | — | @@ -1,3 +0,0 @@ |
2 | | -== See also == |
3 | | -*[http://www.mediawiki.org/wiki/Manual:IBM_DB2 Installation instructions] |
4 | | -*[http://ca.php.net/manual/en/function.db2-connect.php PHP Manual for DB2 functions] |
\ No newline at end of file |
Index: trunk/phase3/docs/database.txt |
— | — | @@ -171,3 +171,20 @@ |
172 | 172 | UPDATE, or by using unique indexes in combination with INSERT IGNORE. |
173 | 173 | Then use the affected row count to see if the query succeeded. |
174 | 174 | |
| 175 | +------------------------------------------------------------------------ |
| 176 | + Supported DBMSs |
| 177 | +------------------------------------------------------------------------ |
| 178 | + |
| 179 | +MediaWiki is written primarily for use with MySQL. Queries are optimized |
| 180 | +for it and its schema is considered the canonical version. However, |
| 181 | +MediaWiki does support the following other DBMSs to varying degrees. |
| 182 | + |
| 183 | +* PostgreSQL |
| 184 | +* SQLite |
| 185 | +* Oracle |
| 186 | +* IBM DB2 |
| 187 | +* MSSQL |
| 188 | + |
| 189 | +More information can be found about each of these databases (known issues, |
| 190 | +level of support, extra configuration) in the "databases" subdirectory in |
| 191 | +this folder. |
Index: trunk/phase3/docs/databases/sqlite.txt |
— | — | @@ -0,0 +1,12 @@ |
| 2 | +SQLite shares the MySQL schema file at maintenance/tables.sql, with a set of |
| 3 | +compatibility regexes to convert MySQL syntax to SQLite syntax: |
| 4 | + |
| 5 | +* BINARY() and VARBINARY() fields are converted to BLOB |
| 6 | +* the UNSIGNED modifier is removed |
| 7 | +* "INT" fields are converted to "INTEGER" |
| 8 | +* ENUM is converted to BLOB |
| 9 | +* the BINARY collation modifier is removed |
| 10 | +* AUTO_INCREMENT is converted to AUTOINCREMENT |
| 11 | +* Any table options are removed |
| 12 | +* Truncated indexes are upgraded to full-width indexes |
| 13 | +* FULLTEXT indexes are converted to ordinary indexes |
Property changes on: trunk/phase3/docs/databases/sqlite.txt |
___________________________________________________________________ |
Added: svn:eol-style |
1 | 14 | + native |
Index: trunk/phase3/docs/databases/ibm_db2.txt |
— | — | @@ -0,0 +1,3 @@ |
| 2 | +== See also == |
| 3 | +*[http://www.mediawiki.org/wiki/Manual:IBM_DB2 Installation instructions] |
| 4 | +*[http://ca.php.net/manual/en/function.db2-connect.php PHP Manual for DB2 functions] |
\ No newline at end of file |
Property changes on: trunk/phase3/docs/databases/ibm_db2.txt |
___________________________________________________________________ |
Added: svn:eol-style |
1 | 5 | + native |