changelog-1.0.1.groovy

databaseChangeLog = {
    delegate.databaseChangeLog logicalFilePath: "site-autobase"

    changeSet(id: "WikiPageDeprecation", author: "pledbrook") {
        addColumn(tableName: "content") {
            column name: "deprecated", type: "boolean", {
                constraints nullable: true
            }

            column name: "deprecated_uri", type: "varchar(255)", {
                constraints nullable: true
            }
        }

        // All existing Wiki pages should have a default 'deprecated'
        // value of false, not null.
        update(tableName: "content") {
            column name: "deprecated", valueBoolean: false
            where "number is null"
        }
    }

    changeSet(id: "ZombiePluginSupport", author: "pledbrook") {
        addColumn(tableName: "plugin") {
            column name: "zombie", type: "boolean", {
                constraints nullable: true
            }
        }

        // All existing Wiki pages should have a default 'deprecated'
        // value of false, not null.
        update(tableName: "plugin") {
            column name: "zombie", valueBoolean: false
        }
    }

    changeSet(id: "ExtraPluginFields", author: "pledbrook") {
        addColumn(tableName: "plugin") {
            column name: "group_id", type: "varchar(255)", {
                constraints nullable: false
            }
            column name: "summary", type: "text", {
                constraints nullable: true
            }
            column name: "scm_url", type: "varchar(255)", {
                constraints nullable: true
            }
        }

        // All existing Wiki pages should have a default 'deprecated'
        // value of false, not null.
        update(tableName: "plugin") {
            column name: "group_id", value: "org.grails.plugins"
        }
    }

    changeSet(id: "VideoHostForScreencasts", author: "pledbrook") {
        createTable tableName: "video_host", {
            column name: "id", type: "bigint", autoIncrement: true, {
                constraints primaryKey: true, nullable: false
            }
            column name: "version", type: "bigint", {
                constraints nullable: false
            }
            column name: "embed_template", type: "text", {
                constraints nullable: false
            }
            column name: "name", type: "varchar(255)", {
                constraints nullable: false, unique: true
            }
        }

        addColumn tableName: "screencast", {
            column name: "video_host_id", type: "bigint", {
                constraints nullable: true, foreignKeyName: "FKE72625AB937EA8A1"
            }
            column name: "video_id", type: "varchar(255)"
        }

        addForeignKeyConstraint constraintName: "FKE72625AB937EA8A1",
                                baseTableName: "screencast",
                                baseColumnNames: "video_host_id",
                                referencedTableName: "video_host",
                                referencedColumnNames: "id"
    }
}