public override void Up()
{
CreateTable(
"dbo.Books",
c => new
{
ID = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false, maxLength: 255),
CategoriesID = c.Int(nullable: false),
Author = c.String(nullable: false),
Introduce = c.String(),
imagePath = c.String(),
pubYear = c.DateTime(nullable: false),
})
.PrimaryKey(t => t.ID)
.ForeignKey("dbo.Categories", t => t.CategoriesID, cascadeDelete: true)
.Index(t => t.CategoriesID);
CreateTable(
"dbo.Categories",
c => new
{
ID = c.Int(nullable: false, identity: true),
Name = c.String(nullable: false),
})
.PrimaryKey(t => t.ID);
CreateTable(
"dbo.Comments",
c => new
{
ComID = c.Int(nullable: false, identity: true),
Contents = c.String(),
DatePost = c.DateTime(nullable: false),
BookID = c.Int(nullable: false),
UserID = c.Int(nullable: false),
})
.PrimaryKey(t => t.ComID)
.ForeignKey("dbo.Books", t => t.BookID, cascadeDelete: true)
.ForeignKey("dbo.Users", t => t.UserID, cascadeDelete: true)
.Index(t => t.BookID)
.Index(t => t.UserID);
CreateTable(
"dbo.Users",
c => new
{
UserID = c.Int(nullable: false, identity: true),
UserName = c.String(),
Pass = c.String(),
IsActive = c.Boolean(nullable: false),
})
.PrimaryKey(t => t.UserID);
CreateTable(
"dbo.Roles",
c => new
{
RoleID = c.Int(nullable: false, identity: true),
RoleName = c.String(),
})
.PrimaryKey(t => t.RoleID);
CreateTable(
"dbo.UserRoles",
c => new
{
UserID = c.Int(nullable: false),
RoleID = c.Int(nullable: false),
})
.PrimaryKey(t => new { t.UserID, t.RoleID })
.ForeignKey("dbo.Users", t => t.UserID, cascadeDelete: true)
.ForeignKey("dbo.Roles", t => t.RoleID, cascadeDelete: true)
.Index(t => t.UserID)
.Index(t => t.RoleID);
}