summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/scripts/mysql/enumeration-init.sql
blob: a194b636d05ca527c7a720aba78e673c0d31919f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

use IBatisNet;

drop table if exists Enumerations;

create table Enumerations
(
   Enum_Id                        int                            not null,
   Enum_Day                       int                            not null,
   Enum_Color                     int                            not null,
   Enum_Month                     int,
   primary key (Enum_Id)
) TYPE=INNODB;

INSERT INTO Enumerations VALUES(1, 1, 1, 128);
INSERT INTO Enumerations VALUES(2, 2, 2, 2048);
INSERT INTO Enumerations VALUES(3, 3, 4, 256);
INSERT INTO Enumerations VALUES(4, 4, 8, null);