Skip to content

Instantly share code, notes, and snippets.

Created December 14, 2012 08:49
Show Gist options
  • Save anonymous/4283733 to your computer and use it in GitHub Desktop.
Save anonymous/4283733 to your computer and use it in GitHub Desktop.
relates to Settings.yaml https://gist.github.com/4283679 and Migrations/Sqlite/Version20121211145611.php https://gist.github.com/4283731
-bash:$ ./flow3 doctrine:entitystatus
Found 12 mapped entities:
[OK] TYPO3\FLOW3\Resource\ResourcePointer
[OK] TYPO3\FLOW3\Mvc\Routing\ObjectPathMapping
[OK] TYPO3\FLOW3\Resource\Publishing\AbstractPublishingConfiguration
[OK] TYPO3\FLOW3\Resource\Resource
[OK] TYPO3\FLOW3\Security\Account
[OK] TYPO3\FLOW3\Security\Authorization\Resource\SecurityPublishingConfiguration
[OK] TYPO3\FLOW3\Security\Policy\Role
[OK] TYPO3\Party\Domain\Model\AbstractParty
[OK] TYPO3\Party\Domain\Model\ElectronicAddress
[OK] TYPO3\Party\Domain\Model\Person
[OK] TYPO3\Party\Domain\Model\PersonName
[OK] My\Package\Name\Domain\Model\Prototype
-bash:[return code: (0)]
-bash:$ ./flow3 doctrine:migrationstatus
== Configuration
>> Name: Doctrine Database Migrations
>> Database Driver: pdo_sqlite
>> Database Name:
>> Configuration Source: manually configured
>> Version Table Name: flow3_doctrine_migrationstatus
>> Migrations Namespace: TYPO3\FLOW3\Persistence\Doctrine\Migrations
>> Migrations Target Directory: ~flowInstallDir/Data/DoctrineMigrations
>> Current Version: 0
>> Latest Version: 2012-12-11 14:56:11 (20121211145611)
>> Executed Migrations: 0
>> Available Migrations: 1
>> New Migrations: 1
== Migration Versions
>> 2012-12-11 14:56:11 (20121211145611) not migrated
-bash:[return code: (0)]
-bash:$ ./flow3 doctrine:migrate
Migrating up to 20121211145611 from 0
++ migrating 20121211145611
-> CREATE TABLE typo3_flow3_security_account (flow3_persistence_identifier VARCHAR(40) NOT NULL, party VARCHAR(40) DEFAULT NULL, accountidentifier VARCHAR(255) NOT NULL, authenticationprovidername VARCHAR(255) NOT NULL, credentialssource VARCHAR(255) DEFAULT NULL, creationdate DATETIME NOT NULL, expirationdate DATETIME DEFAULT NULL, roles CLOB NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE INDEX IDX_65EFB31C89954EE0 ON typo3_flow3_security_account (party)
-> CREATE UNIQUE INDEX flow3_identity_typo3_flow3_security_account ON typo3_flow3_security_account (accountidentifier, authenticationprovidername)
-> CREATE TABLE typo3_flow3_security_authorization_resource_securitypubli_6180a (flow3_persistence_identifier VARCHAR(40) NOT NULL, allowedroles CLOB NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE TABLE typo3_flow3_security_policy_role (identifier VARCHAR(255) NOT NULL, PRIMARY KEY('identifier'))
-> CREATE TABLE typo3_party_domain_model_abstractparty (flow3_persistence_identifier VARCHAR(40) NOT NULL, dtype VARCHAR(255) NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE TABLE typo3_party_domain_model_electronicaddress (flow3_persistence_identifier VARCHAR(40) NOT NULL, identifier VARCHAR(255) NOT NULL, type VARCHAR(20) NOT NULL, usagetype VARCHAR(20) DEFAULT NULL, approved BOOLEAN NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE TABLE typo3_party_domain_model_person (flow3_persistence_identifier VARCHAR(40) NOT NULL, name VARCHAR(40) DEFAULT NULL, primaryelectronicaddress VARCHAR(40) DEFAULT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE UNIQUE INDEX UNIQ_C60479E15E237E06 ON typo3_party_domain_model_person (name)
-> CREATE INDEX IDX_C60479E1A7CECF13 ON typo3_party_domain_model_person (primaryelectronicaddress)
-> CREATE TABLE typo3_party_domain_model_person_electronicaddresses_join (party_person VARCHAR(40) NOT NULL, party_electronicaddress VARCHAR(40) NOT NULL, PRIMARY KEY('party_person', 'party_electronicaddress'))
-> CREATE INDEX IDX_BE7D49F772AAAA2F ON typo3_party_domain_model_person_electronicaddresses_join (party_person)
-> CREATE INDEX IDX_BE7D49F7B06BD60D ON typo3_party_domain_model_person_electronicaddresses_join (party_electronicaddress)
-> CREATE TABLE typo3_party_domain_model_personname (flow3_persistence_identifier VARCHAR(40) NOT NULL, title VARCHAR(255) NOT NULL, firstname VARCHAR(255) NOT NULL, middlename VARCHAR(255) NOT NULL, lastname VARCHAR(255) NOT NULL, othername VARCHAR(255) NOT NULL, alias VARCHAR(255) NOT NULL, fullname VARCHAR(255) NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
-> CREATE TABLE my_package_name_domain_model_prototype (flow3_persistence_identifier VARCHAR(40) NOT NULL, PRIMARY KEY('flow3_persistence_identifier'))
++ migrated (0,03s)
------------------------
++ finished in 0,03
++ 1 migrations executed
++ 15 sql queries
-bash:[return code: (0)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment