Deveel.Data.DropTableTests.CreateTestTables C# (CSharp) Method

        private static void CreateTestTables(IQuery context)
        {
            var tn1 = ObjectName.Parse("APP.test_table1");
            context.Access().CreateTable(table => table
                .Named(tn1)
                .WithColumn("id", PrimitiveTypes.Integer())
                .WithColumn("name", PrimitiveTypes.String())
                .WithColumn("date", PrimitiveTypes.DateTime()));

            context.Session.Access().AddPrimaryKey(tn1, "id");

            var tn2 = ObjectName.Parse("APP.test_table2");

            context.Access().CreateTable(table => table
                .Named(tn2)
                .WithColumn("id", PrimitiveTypes.Integer())
                .WithColumn("other_id", PrimitiveTypes.Integer())
                .WithColumn("count", PrimitiveTypes.Integer()));

            context.Session.Access().AddPrimaryKey(tn2, "id");
            context.Session.Access().AddForeignKey(tn2, new[] { "other_id" }, tn1, new[] { "id" }, ForeignKeyAction.Cascade,
                ForeignKeyAction.Cascade, null);
        }