public static void CreateTable(this IQueryContext context, TableInfo tableInfo, bool onlyIfNotExists)
{
CreateTable(context, tableInfo, onlyIfNotExists, false);
}
public static void AlterTable(this IQueryContext context, TableInfo tableInfo)
{
context.AlterObject(tableInfo);
}
public static void CreateTable(this IQueryContext context, TableInfo tableInfo)
{
CreateTable(context, tableInfo, false);
}
public void OnTableCompositeCreate(IQuery systemQuery)
{
// SYSTEM.PKEY_INFO
var tableInfo = new TableInfo(SystemSchema.PrimaryKeyInfoTableName);
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("name", PrimitiveTypes.String());
tableInfo.AddColumn("schema", PrimitiveTypes.String());
tableInfo.AddColumn("table", PrimitiveTypes.String());
tableInfo.AddColumn("deferred", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.PKEY_COLS
tableInfo = new TableInfo(SystemSchema.PrimaryKeyColumnsTableName);
tableInfo.AddColumn("pk_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("column", PrimitiveTypes.String());
tableInfo.AddColumn("seq_no", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.FKEY_INFO
tableInfo = new TableInfo(SystemSchema.ForeignKeyInfoTableName);
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("name", PrimitiveTypes.String());
tableInfo.AddColumn("schema", PrimitiveTypes.String());
tableInfo.AddColumn("table", PrimitiveTypes.String());
tableInfo.AddColumn("ref_schema", PrimitiveTypes.String());
tableInfo.AddColumn("ref_table", PrimitiveTypes.String());
tableInfo.AddColumn("update_rule", PrimitiveTypes.Numeric());
tableInfo.AddColumn("delete_rule", PrimitiveTypes.Numeric());
tableInfo.AddColumn("deferred", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.FKEY_COLS
tableInfo = new TableInfo(SystemSchema.ForeignKeyColumnsTableName);
tableInfo.AddColumn("fk_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("fcolumn", PrimitiveTypes.String());
tableInfo.AddColumn("pcolumn", PrimitiveTypes.String());
tableInfo.AddColumn("seq_no", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.UNIQUE_INFO
tableInfo = new TableInfo(SystemSchema.UniqueKeyInfoTableName);
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("name", PrimitiveTypes.String());
tableInfo.AddColumn("schema", PrimitiveTypes.String());
tableInfo.AddColumn("table", PrimitiveTypes.String());
tableInfo.AddColumn("deferred", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.UNIQUE_COLS
tableInfo = new TableInfo(SystemSchema.UniqueKeyColumnsTableName);
tableInfo.AddColumn("un_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("column", PrimitiveTypes.String());
tableInfo.AddColumn("seq_no", PrimitiveTypes.Numeric());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
// SYSTEM.CHECK_INFO
tableInfo = new TableInfo(SystemSchema.CheckInfoTableName);
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("name", PrimitiveTypes.String());
tableInfo.AddColumn("schema", PrimitiveTypes.String());
tableInfo.AddColumn("table", PrimitiveTypes.String());
tableInfo.AddColumn("expression", PrimitiveTypes.String());
tableInfo.AddColumn("deferred", PrimitiveTypes.Numeric());
tableInfo.AddColumn("serialized_expression", PrimitiveTypes.Binary());
tableInfo = tableInfo.AsReadOnly();
systemQuery.Access().CreateTable(tableInfo);
}
