public static function checkTablesVersioning($connection)
{
$sExecute = " CREATE TABLE IF NOT EXISTS configuracao.database_version ( \n";
$sExecute .= " db142_versao varchar NOT NULL, \n";
$sExecute .= " db142_datacriacao timestamp without time zone DEFAULT now() NOT NULL \n";
$sExecute .= " ); \n";
$sExecute .= " \n";
$sExecute .= " ALTER TABLE ONLY configuracao.database_version \n";
$sExecute .= " ADD CONSTRAINT database_version_pk PRIMARY KEY (db142_versao); \n";
if (!DBDataBaseMigration::createTable($connection, 'configuracao', 'database_version', $sExecute)) {
return false;
}
$sExecute = " create table configuracao.database_version_sql ( \n";
$sExecute .= " db143_arquivo varchar not null, \n";
$sExecute .= " db143_versao varchar not null, \n";
$sExecute .= " db143_script text not null, \n";
$sExecute .= " db143_tipo varchar not null, \n";
$sExecute .= " db143_executado boolean not null default false \n";
$sExecute .= " ); \n";
$sExecute .= " \n";
$sExecute .= " ALTER TABLE ONLY configuracao.database_version_sql \n";
$sExecute .= " ADD CONSTRAINT database_version_sql_pk \n";
$sExecute .= " PRIMARY KEY (db143_arquivo, db143_versao); \n";
$sExecute .= " \n";
$sExecute .= " CREATE INDEX database_version_sql_version_idx \n";
$sExecute .= " ON configuracao.database_version_sql \n";
$sExecute .= " USING btree (db143_versao); \n";
$sExecute .= " \n";
$sExecute .= " ALTER TABLE ONLY configuracao.database_version_sql \n";
$sExecute .= " ADD CONSTRAINT database_version_sql_version_fk \n";
$sExecute .= " FOREIGN KEY (db143_versao) REFERENCES configuracao.database_version(db142_versao); \n";
if (!DBDataBaseMigration::createTable($connection, 'configuracao', 'database_version_sql', $sExecute)) {
return false;
}
return true;
}
