namespace sbcLabSystem.Data.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class InitDatabaseAndBuildAccounts : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "dbo.ResourceInfoes",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ResourceNo = c.String(),
                        ResourceName = c.String(),
                        ParentResourceNo = c.String(),
                        Url = c.String(),
                        Order = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "dbo.RoleInfoes",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        RoleName = c.String(),
                        RoleDescription = c.String(),
                        Privilege = c.String(),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "dbo.UserInfoes",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        UserNo = c.String(),
                        UserName = c.String(),
                        Email = c.String(),
                        IsUse = c.Int(nullable: false),
                        Password = c.String(),
                        CurrentEnvirnoment = c.String(),
                        ModifiedTime = c.DateTime(nullable: false),
                        Barcode = c.String(),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "dbo.RoleInfoResourceInfoes",
                c => new
                    {
                        RoleInfo_Id = c.Int(nullable: false),
                        ResourceInfo_Id = c.Int(nullable: false),
                    })
                .PrimaryKey(t => new { t.RoleInfo_Id, t.ResourceInfo_Id })
                .ForeignKey("dbo.RoleInfoes", t => t.RoleInfo_Id, cascadeDelete: true)
                .ForeignKey("dbo.ResourceInfoes", t => t.ResourceInfo_Id, cascadeDelete: true)
                .Index(t => t.RoleInfo_Id)
                .Index(t => t.ResourceInfo_Id);
            
            CreateTable(
                "dbo.UserInfoRoleInfoes",
                c => new
                    {
                        UserInfo_Id = c.Int(nullable: false),
                        RoleInfo_Id = c.Int(nullable: false),
                    })
                .PrimaryKey(t => new { t.UserInfo_Id, t.RoleInfo_Id })
                .ForeignKey("dbo.UserInfoes", t => t.UserInfo_Id, cascadeDelete: true)
                .ForeignKey("dbo.RoleInfoes", t => t.RoleInfo_Id, cascadeDelete: true)
                .Index(t => t.UserInfo_Id)
                .Index(t => t.RoleInfo_Id);
            
        }
        
        public override void Down()
        {
            DropForeignKey("dbo.UserInfoRoleInfoes", "RoleInfo_Id", "dbo.RoleInfoes");
            DropForeignKey("dbo.UserInfoRoleInfoes", "UserInfo_Id", "dbo.UserInfoes");
            DropForeignKey("dbo.RoleInfoResourceInfoes", "ResourceInfo_Id", "dbo.ResourceInfoes");
            DropForeignKey("dbo.RoleInfoResourceInfoes", "RoleInfo_Id", "dbo.RoleInfoes");
            DropIndex("dbo.UserInfoRoleInfoes", new[] { "RoleInfo_Id" });
            DropIndex("dbo.UserInfoRoleInfoes", new[] { "UserInfo_Id" });
            DropIndex("dbo.RoleInfoResourceInfoes", new[] { "ResourceInfo_Id" });
            DropIndex("dbo.RoleInfoResourceInfoes", new[] { "RoleInfo_Id" });
            DropTable("dbo.UserInfoRoleInfoes");
            DropTable("dbo.RoleInfoResourceInfoes");
            DropTable("dbo.UserInfoes");
            DropTable("dbo.RoleInfoes");
            DropTable("dbo.ResourceInfoes");
        }
    }
}