-
Notifications
You must be signed in to change notification settings - Fork 0
/
TODO
28 lines (17 loc) · 810 Bytes
/
TODO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
In SQLite/Postgres (non-MySQL) mode:
In CREATE TABLE:
Replace AUTO_INCREMENT columns with INTEGER PRIMARY KEY for SQLite or
serial for Postgres.
Change TINYINT to SMALLINT. Remove UNSIGNED.
For Postgres replace int with INTEGER.
Remove CHARACTER SET, COLLATE and COMMENT from column definitions.
Remove KEY and index name from UNIQUE KEY:
UNIQUE KEY name (columns) -> UNIQUE (columns).
Change multicolumn PRIMARY KEY to UNIQUE.
Remove table options like ENGINE, AUTO_INCREMENT, CHARSET, etc:
CREATE TABLE name (column_definitions) table_options.
Convert KEY to CREATE INDEX; remove size limit:
KEY name ("COLUMN_NAME"(20)) ->
CREATE INDEX name ON table ("COLUMN_NAME").
Remove LOCK/UNLOCK TABLES.
Installers.