use iBatisNet;


create table ACCOUNTS
(
   ACCOUNT_ID                     int                            not null,
   ACCOUNT_FIRSTNAME              varchar(32)                    not null,
   ACCOUNT_LASTNAME               varchar(32)                    not null,
   ACCOUNT_EMAIL                  varchar(128),
   primary key (ACCOUNT_ID)
) TYPE=INNODB;

INSERT INTO Accounts VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com');
INSERT INTO Accounts VALUES(2,'Averel', 'Dalton', 'Averel.Dalton@somewhere.com');
INSERT INTO Accounts VALUES(3,'William', 'Dalton', null);
INSERT INTO Accounts VALUES(4,'Jack', 'Dalton', 'Jack.Dalton@somewhere.com');
INSERT INTO Accounts VALUES(5,'Gilles', 'Bayon', null);