schema

type ActivationPreview struct {
	DDL      []string       `json:"ddl"`
	Changes  []TieredChange `json:"changes"`
	Blocked  []TieredChange `json:"blocked"`
	Warnings []TieredChange `json:"warnings"`
}

type ColumnAdd struct {
	Name     string
	Type     string
	Nullable bool
	Default  string
}

type ColumnInfo struct {
	Name     string
	Type     string
	Nullable bool
	Default  sql.NullString
	Indexed  bool
}

type ColumnRename struct {
	OldName string
	NewName string
}

type Diff struct {
	NewTables     []string                  // Tables to CREATE
	NewColumns    map[string][]ColumnAdd    // Table → columns to ADD
	NewIndexes    map[string][]IndexAdd     // Table → indexes to CREATE
	RenameColumns map[string][]ColumnRename // Table → columns to RENAME
	Orphaned      []OrphanedColumn          // Columns in DB but not in registry
}

type IndexAdd struct {
	Table   string
	Columns []string
	Unique  bool
}

type OrphanedColumn struct {
	Table  string
	Column string
}

type TableInfo struct {
	Name    string
	Columns map[string]*ColumnInfo
}

type TieredChange struct {
	Tier    string `json:"tier"` // "safe", "warning", "blocked"
	DocType string `json:"doctype"`
	Field   string `json:"field,omitempty"`
	Change  string `json:"change"`
	Rows    int    `json:"rows"`
	DDL     string `json:"ddl,omitempty"`
	Message string `json:"message"`
}