summaryrefslogtreecommitdiff
path: root/maintenance/sqlite/README
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/sqlite/README')
-rw-r--r--maintenance/sqlite/README12
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