hdabo_sf: app/DoctrineMigrations/Version20111209060357.php@624e5900f5a4 (annotated)

57 b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	1	<?php
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	2
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	3	namespace Application\Migrations;
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	4
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	5	use Doctrine\DBAL\Migrations\AbstractMigration,
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	6	Doctrine\DBAL\Schema\Schema;
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	7
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	8	/**
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	9	* Auto-generated Migration: Please modify to your need!
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	10	*/
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	11	class Version20111209060357 extends AbstractMigration
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	12	{
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	13	public function up(Schema $schema)
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	14	{
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	15	// this up() migration is autogenerated, please modify it to your needs
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	16	$this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	17
58 624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	18	$this->addSql("ALTER TABLE wikitag_document ADD created_at DATETIME NULL");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	19	$this->addSql("ALTER TABLE wikitag_document_tag ADD created_at DATETIME NULL");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	20	$this->addSql("ALTER TABLE wikitag_tag ADD created_at DATETIME NULL");
57 b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	21
58 624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	22	$this->addSql("UPDATE wikitag_document SET created_at = UTC_TIMESTAMP()");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	23	$this->addSql("UPDATE wikitag_document_tag SET created_at = UTC_TIMESTAMP()");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	24	$this->addSql("UPDATE wikitag_tag SET created_at = UTC_TIMESTAMP()");
57 b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	25
58 624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	26	$this->addSql("ALTER TABLE wikitag_document MODIFY created_at DATETIME NOT NULL");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	27	$this->addSql("ALTER TABLE wikitag_document_tag MODIFY created_at DATETIME NOT NULL");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	28	$this->addSql("ALTER TABLE wikitag_tag MODIFY created_at DATETIME NOT NULL");
57 b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	29
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	30	}
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	31
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	32	public function down(Schema $schema)
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	33	{
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	34	// this down() migration is autogenerated, please modify it to your needs
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	35	$this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	36
58 624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	37	$this->addSql("ALTER TABLE wikitag_document DROP created_at");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	38	$this->addSql("ALTER TABLE wikitag_document_tag DROP created_at");
624e5900f5a4 add tests and fixtures ymh <ymh.work@gmail.com> parents: 57 diff changeset	39	$this->addSql("ALTER TABLE wikitag_tag DROP created_at");
57 b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	40	}
b36a42d260d8 add creation timestamp on document tag and document tag ymh <ymh.work@gmail.com> parents: diff changeset	41	}

author	ymh <ymh.work@gmail.com>
	Wed, 14 Dec 2011 23:28:58 +0100
changeset 58	624e5900f5a4
parent 57	b36a42d260d8
child 71	b01e36991488
permissions	-rw-r--r--