Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Oracle.EntityFrameworkCore.Metadata;
- namespace baja.Migrations
- {
- public partial class First : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "Users",
- columns: table => new
- {
- UserId = table.Column<int>(nullable: false)
- .Annotation("Oracle:ValueGenerationStrategy", OracleValueGenerationStrategy.IdentityColumn),
- FirstName = table.Column<string>(nullable: true),
- LastName = table.Column<string>(nullable: true),
- Login = table.Column<string>(nullable: true),
- Password = table.Column<string>(nullable: true),
- Email = table.Column<string>(nullable: true),
- Salt = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Users", x => x.UserId);
- });
- migrationBuilder.CreateTable(
- name: "Messages",
- columns: table => new
- {
- MessageID = table.Column<long>(nullable: false)
- .Annotation("Oracle:ValueGenerationStrategy", OracleValueGenerationStrategy.IdentityColumn),
- UserID = table.Column<long>(nullable: false),
- Text = table.Column<string>(nullable: true),
- ModifiedOn = table.Column<DateTime>(nullable: true),
- UserId = table.Column<int>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Messages", x => x.MessageID);
- table.ForeignKey(
- name: "FK_Messages_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "UserId",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateTable(
- name: "MessageRights",
- columns: table => new
- {
- MessageRightID = table.Column<long>(nullable: false)
- .Annotation("Oracle:ValueGenerationStrategy", OracleValueGenerationStrategy.IdentityColumn),
- UserID = table.Column<long>(nullable: false),
- MessageID = table.Column<long>(nullable: false),
- UserId = table.Column<int>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_MessageRights", x => x.MessageRightID);
- table.ForeignKey(
- name: "FK_MessageRights_Messages_MessageID",
- column: x => x.MessageID,
- principalTable: "Messages",
- principalColumn: "MessageID",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_MessageRights_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "UserId",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateIndex(
- name: "IX_MessageRights_MessageID",
- table: "MessageRights",
- column: "MessageID");
- migrationBuilder.CreateIndex(
- name: "IX_MessageRights_UserId",
- table: "MessageRights",
- column: "UserId");
- migrationBuilder.CreateIndex(
- name: "IX_Messages_UserId",
- table: "Messages",
- column: "UserId");
- }
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "MessageRights");
- migrationBuilder.DropTable(
- name: "Messages");
- migrationBuilder.DropTable(
- name: "Users");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement