Deveel.Data.SelectTests.CreateTestTable C# (CSharp) Method

        private static void CreateTestTable(IQuery context)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            context.Access().CreateTable(table => table
                .Named(tableName)
                .WithColumn(column => column
                    .Named("id")
                    .HavingType(PrimitiveTypes.Integer())
                    .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY",
                        new SqlExpression[] {SqlExpression.Constant(tableName.FullName)})))
                .WithColumn("first_name", PrimitiveTypes.String())
                .WithColumn("last_name", PrimitiveTypes.String())
                .WithColumn("birth_date", PrimitiveTypes.DateTime())
                .WithColumn("active", PrimitiveTypes.Boolean()));

            context.Session.Access().AddPrimaryKey(tableName, "id", "PK_TEST_TABLE");
        }