public void WriteTo(SqlBuilder sql)
{
sql.CreateTable(new SchemaObject(Name));
sql.AppendLine(" (");
var i = 0;
foreach (var column in Columns)
{
if (++i != 1)
{
sql.AppendLine(",");
}
sql.Indent(1);
column.WriteTo(sql);
}
if (!PrimaryKey[0].IsIdentity)
{
sql.AppendLine(",");
sql.Indent(1);
sql.Append("PRIMARY KEY ");
sql.WriteTuple(PrimaryKey.Names);
}
foreach (var index in Indexes)
{
sql.AppendLine(",");
if (index.Type == IndexFlags.Unique)
{
// UNIQUE KEY `ix_phone` (`country`, `area`, `number`, `extension`),
sql.Indent(1);
sql.Append("UNIQUE KEY ");
sql.WriteIdentifier(index.Name);
sql.Append(" ");
sql.WriteTuple(ValueList.With(index.Members));
}
else
{
sql.Indent(1);
sql.Append("INDEX ");
sql.WriteIdentifier(index.Name);
sql.Append(" ");
sql.WriteTuple(ValueList.With(index.Members));
}
}
sql.AppendLine("");
sql.Append(")");
}
public void WriteTo(SqlBuilder sb)
{
sb.WriteIdentifier(Name);
sb.Append(" ");
sb.Write(Type);
if (!IsOptional)
{
sb.Append(" NOT NULL");
}
if (AutoIncriment)
{
sb.Append(" AUTO_INCREMENT");
}
if (IsKey)
{
sb.Append(" ");
sb.Append(IsUnique ? "UNIQUE" : "PRIMARY");
sb.Append(" KEY");
}
if (Default != null)
{
sb.Append(" DEFAULT ");
sb.Append(Default);
}
if (OnUpdate != null)
{
sb.Append(" ON UPDATE ");
sb.Append(OnUpdate);
}
if (Format != null)
{
sb.Append(" " + Format.Value.ToString().ToUpper());
}
}