Skip to:
Create table like so:
CREATE TABLE TESTBIT(BIT_NULL BIT(6) NULL,BIT_NOTNULL BIT(6) NOT NULL,BIT_DEFAULT BIT(6) DEFAULT '1',BIT_PK BIT(6) NOT NULL,BIT_UNIQUE BIT(6) NOT NULL,CONSTRAINT PK_BIT PRIMARY KEY (BIT_PK),CONSTRAINT UN_BIT UNIQUE (BIT_UNIQUE));
Note the sizing of BIT(6). Take snapshot and note the size is BIT(1)
<changeSet author="robert" id="1383674467554-3"><createTable tableName="testbit"><column name="BIT_NULL" type="BIT(1)"/><column name="BIT_NOTNULL" type="BIT(1)"><constraints nullable="false"/></column><column defaultValueNumeric="110001" name="BIT_DEFAULT" type="BIT(1)"/><column name="BIT_PK" type="BIT(1)"><constraints nullable="false"/></column><column name="BIT_UNIQUE" type="BIT(1)"><constraints nullable="false"/></column></createTable></changeSet>
Linux and MySQL
Create table like so:
CREATE TABLE TESTBIT(
BIT_NULL BIT(6) NULL,
BIT_NOTNULL BIT(6) NOT NULL,
BIT_DEFAULT BIT(6) DEFAULT '1',
BIT_PK BIT(6) NOT NULL,
BIT_UNIQUE BIT(6) NOT NULL,
CONSTRAINT PK_BIT PRIMARY KEY (BIT_PK),
CONSTRAINT UN_BIT UNIQUE (BIT_UNIQUE)
);
Note the sizing of BIT(6). Take snapshot and note the size is BIT(1)
<changeSet author="robert" id="1383674467554-3">
<createTable tableName="testbit">
<column name="BIT_NULL" type="BIT(1)"/>
<column name="BIT_NOTNULL" type="BIT(1)">
<constraints nullable="false"/>
</column>
<column defaultValueNumeric="110001" name="BIT_DEFAULT" type="BIT(1)"/>
<column name="BIT_PK" type="BIT(1)">
<constraints nullable="false"/>
</column>
<column name="BIT_UNIQUE" type="BIT(1)">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>