aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
blob: 1c8951604f6868c537a08a9183b0a761cf15e81a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
?This file describes the differences in schema creation and migration scripts.

MySQL is used as reference script against which differences are listed.

Generally MySQL create table options should be removed for other databases.

_PostgreSQL_
* DOUBLE->DOUBLE PRECISION
* BIT->BOOLEAN

_MsSql_
* VARCHAR->NVARCHAR
* Remove DEFAULT-keywords
* DOUBLE->REAL