schema

type ColumnDiff struct {
	Type        ColumnDiffType // Type of column operation
	ColumnName  string         // Name of the column
	Current     *ColumnInfo    // Current column definition (nil for ADD)
	Target      *ColumnInfo    // Target column definition (nil for DROP)
	Description string         // Human-readable description
}

type ColumnDiffType string

type ColumnInfo struct {
	Name     string // Column name
	DataType string // Full data type specification (e.g., "Nullable(String)", "Array(UInt64)")
	Default  string // Default value specification (e.g., "DEFAULT 'value'", "MATERIALIZED expr")
	Codec    string // Compression codec (e.g., "CODEC(ZSTD)")
	TTL      string // Column-level TTL
	Comment  string // Column comment
}

type DatabaseDiff struct {
	Type            DatabaseDiffType // Type of operation (CREATE, ALTER, DROP, RENAME)
	DatabaseName    string           // Name of the database being modified
	Description     string           // Human-readable description of the change
	UpSQL           string           // SQL to apply the change (forward migration)
	DownSQL         string           // SQL to rollback the change (reverse migration)
	Current         *DatabaseInfo    // Current state (nil if database doesn't exist)
	Target          *DatabaseInfo    // Target state (nil if database should be dropped)
	NewDatabaseName string           // For rename operations - the new name
}

type DatabaseDiffType string

type DatabaseInfo struct {
	Name    string // Database name
	Engine  string // Engine type (e.g., "Atomic", "MySQL", "Memory")
	Comment string // Database comment (without quotes)
	Cluster string // Cluster name if specified (empty if not clustered)
}

type DictionaryDiff struct {
	Type              DictionaryDiffType // Type of operation (CREATE, DROP, REPLACE, RENAME)
	DictionaryName    string             // Full name of the dictionary (database.name)
	Description       string             // Human-readable description of the change
	UpSQL             string             // SQL to apply the change (forward migration)
	DownSQL           string             // SQL to rollback the change (reverse migration)
	Current           *DictionaryInfo    // Current state (nil if dictionary doesn't exist)
	Target            *DictionaryInfo    // Target state (nil if dictionary should be dropped)
	NewDictionaryName string             // For rename operations - the new full name
}

type DictionaryDiffType string

type DictionaryInfo struct {
	Name      string                       // Dictionary name
	Database  string                       // Database name (empty for default database)
	Cluster   string                       // Cluster name if specified (empty if not clustered)
	Comment   string                       // Dictionary comment (without quotes)
	Statement *parser.CreateDictionaryStmt // Full parsed CREATE DICTIONARY statement for deep comparison
}

type TableDiff struct {
	Type          TableDiffType // Type of operation (CREATE, ALTER, DROP, RENAME)
	TableName     string        // Name of the table being modified (with database prefix if needed)
	Description   string        // Human-readable description of the change
	UpSQL         string        // SQL to apply the change (forward migration)
	DownSQL       string        // SQL to rollback the change (reverse migration)
	Current       *TableInfo    // Current state (nil if table doesn't exist)
	Target        *TableInfo    // Target state (nil if table should be dropped)
	NewTableName  string        // For rename operations - the new name
	ColumnChanges []ColumnDiff  // For ALTER operations - specific column changes
}

type TableDiffType string

type TableInfo struct {
	Name        string            // Table name (without database prefix)
	Database    string            // Database name (empty if not specified)
	Engine      string            // Engine type and parameters (e.g., "MergeTree()", "ReplicatedMergeTree('/path', 'replica')")
	Cluster     string            // Cluster name for distributed tables
	Comment     string            // Table comment
	OrderBy     string            // ORDER BY expression
	PartitionBy string            // PARTITION BY expression
	PrimaryKey  string            // PRIMARY KEY expression
	SampleBy    string            // SAMPLE BY expression
	TTL         string            // Table-level TTL expression
	Settings    map[string]string // Table settings
	Columns     []ColumnInfo      // Column definitions
	OrReplace   bool              // Whether CREATE OR REPLACE was used
	IfNotExists bool              // Whether IF NOT EXISTS was used
}

type ViewDiff struct {
	Type           ViewDiffType // Type of operation (CREATE, DROP, ALTER, RENAME)
	ViewName       string       // Full name of the view (database.name)
	Description    string       // Human-readable description of the change
	UpSQL          string       // SQL to apply the change (forward migration)
	DownSQL        string       // SQL to rollback the change (reverse migration)
	Current        *ViewInfo    // Current state (nil if view doesn't exist)
	Target         *ViewInfo    // Target state (nil if view should be dropped)
	NewViewName    string       // For rename operations - the new full name
	IsMaterialized bool         // True if this is a materialized view
}

type ViewDiffType string

type ViewInfo struct {
	Name           string                 // View name
	Database       string                 // Database name (empty for default database)
	Cluster        string                 // Cluster name if specified (empty if not clustered)
	IsMaterialized bool                   // True if this is a materialized view
	OrReplace      bool                   // True if created with OR REPLACE
	Query          string                 // Query string for validation compatibility
	Statement      *parser.CreateViewStmt // Full parsed CREATE VIEW statement for deep comparison
}