summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mysql/user-init.sql
blob: c124fc2b26a1ef9b00edfde0dff0511561a35ce2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14

use NHibernate;

drop table if exists Users;

create table Users
(
   LogonId                      varchar(20)						not null default '0',
   Name							varchar(40)                     default null,
   Password                     varchar(20)						default null,
   EmailAddress                 varchar(40)						default null,
   LastLogon					datetime						default null,
   primary key (LogonId)
) TYPE=INNODB;