diff options
Diffstat (limited to 'maintenance/sqlite/README')
| -rw-r--r-- | maintenance/sqlite/README | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/maintenance/sqlite/README b/maintenance/sqlite/README new file mode 100644 index 00000000..b8a45553 --- /dev/null +++ b/maintenance/sqlite/README @@ -0,0 +1,12 @@ +SQLite shares the MySQL schema file at maintenance/tables.sql, with a set of +compatibility regexes to convert MySQL syntax to SQLite syntax: + +* BINARY() and VARBINARY() fields are converted to BLOB +* the UNSIGNED modifier is removed +* "INT" fields are converted to "INTEGER" +* ENUM is converted to BLOB +* the BINARY collation modifier is removed +* AUTO_INCREMENT is converted to AUTOINCREMENT +* Any table options are removed +* Truncated indexes are upgraded to full-width indexes +* FULLTEXT indexes are converted to ordinary indexes |