Home / wiki / maintenance / sqlite / archives
Name Modified Size InfoDownloads / Week
Parent folder
searchindex-fts3.sql 2011-03-17 588 Bytes
0
searchindex-no-fts.sql 2011-03-17 757 Bytes
1 1 weekly downloads
initial-indexes.sql 2011-03-17 18.0 kB
0
patch-tc-timestamp.sql 2011-03-17 160 Bytes
0
patch-rd_interwiki.sql 2011-03-17 215 Bytes
0
patch-log_user_text.sql 2011-03-17 323 Bytes
0
Totals: 6 Items   20.1 kB 1 
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
Source: README, updated 2011-03-17