create table Account (
	id            int not null identity,

	instance      int null references Instance(id),
	fullname      nvarchar(255) null,
	email         nvarchar(255) null,
	password      nvarchar(255) null,
	password_salt varchar(50) null,
	password_tag  varchar(255) null,
	createdate    datetimeoffset(0) null,
	last_login    datetimeoffset(0) null,

	primary key (id)
);

CREATE INDEX Account_instance_index ON Account(instance);
CREATE INDEX Account_email_index ON Account(email);

create table Account (
	id            int not null identity,

	instance      int null references Instance(id),
	fullname      nvarchar(255) null,
	email         nvarchar(255) null,
	password      nvarchar(255) null,
	password_salt varchar(50) null,
	password_tag  varchar(255) null,
	createdate    datetime2 null,
	last_login    datetime2 null,

	primary key (id)
);

CREATE INDEX Account_instance_index ON Account(instance);
CREATE INDEX Account_email_index ON Account(email);

Change date datatype to one without TZ offset information. Dates are stored in UTC.
Change date datatype to one without TZ offset information. Dates are stored in UTC.

svn commit r54386
