BeerConf.Migrations.Migration201107122012.Up C# (CSharp) Method

        public override void Up()
        {
            Create.Table("EVENT_PARTICIPANTS")
                .WithColumn("EVENT_ID").AsInt32().PrimaryKey()
                .WithColumn("USER_ID").AsInt32().PrimaryKey();

            Create.Table("EVENTS")
                .WithColumn("EVENT_ID").AsInt32().PrimaryKey().References("FK_EVENT_PARTICIPANTS_EVENTS", "EVENT_PARTICIPANTS", new[] {"EVENT_ID"})
                .WithColumn("STARTED_AT").AsDateTime().NotNullable()
                .WithColumn("FINISHED_AT").AsDateTime().NotNullable()
                .WithColumn("PLACE").AsString().NotNullable()
                .WithColumn("NAME").AsString().NotNullable()
                .WithColumn("DESCRIPTION").AsString().NotNullable();

            Create.Table("USERS")
                .WithColumn("USER_ID").AsInt32().PrimaryKey().References("FK_EVENT_PARTICIPANTS_USERS", "EVENT_PARTICIPANTS", new[] {"USER_ID"});
        }