init

songjun

2024-09-05 a3302fda10ff21ed3700be462ad560163ca13f14

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
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");
        }
    }
}