public override void Up()
{
CreateTable(
"dbo.Account",
c => new
{
Id = c.Guid(nullable: false),
Type = c.Int(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
ClassType = c.Int(nullable: false),
User_Id = c.Guid(),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.User", t => t.User_Id)
.Index(t => t.User_Id);
CreateTable(
"dbo.Group",
c => new
{
Id = c.Guid(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
Description = c.String(maxLength: 250),
IsDisabled = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.User",
c => new
{
Id = c.Guid(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
IsDisabled = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.Organization",
c => new
{
Id = c.Guid(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
Description = c.String(maxLength: 250),
IsDisabled = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.Role",
c => new
{
Id = c.Guid(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.Permission",
c => new
{
Id = c.Guid(nullable: false),
Name = c.String(nullable: false, maxLength: 50),
Description = c.String(maxLength: 250),
})
.PrimaryKey(t => t.Id);
CreateTable(
"dbo.UserOrganization",
c => new
{
UserId = c.Guid(nullable: false),
OrganizationId = c.Guid(nullable: false),
})
.PrimaryKey(t => new { t.UserId, t.OrganizationId })
.ForeignKey("dbo.User", t => t.UserId, cascadeDelete: true)
.ForeignKey("dbo.Organization", t => t.OrganizationId, cascadeDelete: true)
.Index(t => t.UserId)
.Index(t => t.OrganizationId);
CreateTable(
"dbo.RolePermission",
c => new
{
PermissionId = c.Guid(nullable: false),
RoleId = c.Guid(nullable: false),
})
.PrimaryKey(t => new { t.PermissionId, t.RoleId })
.ForeignKey("dbo.Permission", t => t.PermissionId, cascadeDelete: true)
.ForeignKey("dbo.Role", t => t.RoleId, cascadeDelete: true)
.Index(t => t.PermissionId)
.Index(t => t.RoleId);
CreateTable(
"dbo.UserRole",
c => new
{
UserId = c.Guid(nullable: false),
RoleId = c.Guid(nullable: false),
})
.PrimaryKey(t => new { t.UserId, t.RoleId })
.ForeignKey("dbo.User", t => t.UserId, cascadeDelete: true)
.ForeignKey("dbo.Role", t => t.RoleId, cascadeDelete: true)
.Index(t => t.UserId)
.Index(t => t.RoleId);
CreateTable(
"dbo.UserGroup",
c => new
{
GroupId = c.Guid(nullable: false),
UserId = c.Guid(nullable: false),
})
.PrimaryKey(t => new { t.GroupId, t.UserId })
.ForeignKey("dbo.Group", t => t.GroupId, cascadeDelete: true)
.ForeignKey("dbo.User", t => t.UserId, cascadeDelete: true)
.Index(t => t.GroupId)
.Index(t => t.UserId);
}