public function up(Schema $schema) { $serversTable = $schema->createTable("servers"); $serversTable->addColumn("id", "integer", array("unsigned" => true, "autoincrement" => true, "notnull" => true)); $serversTable->addColumn("servername", "string", array("notnull" => true)); $serversTable->addColumn("ip", "string", array("notnull" => true)); $serversTable->addColumn("protocol", "string", array("notnull" => true)); $serversTable->addColumn("params", "string", array("notnull" => false)); $serversTable->addColumn("created_at", "integer", array("notnull" => true)); $serversTable->addColumn("updated_at", "integer", array("notnull" => true)); $serversTable->addColumn("checked_at", "integer", array("notnull" => false)); $serversTable->setPrimaryKey(array("id")); $serversTable->addUniqueIndex(array("servername")); $serversTable->addUniqueIndex(array("ip")); $softwaresTable = $schema->createTable("softwares"); $softwaresTable->addColumn("id", "integer", array("unsigned" => true, "autoincrement" => true, "notnull" => true)); $softwaresTable->addColumn("server_id", "integer", array("notnull" => true)); $softwaresTable->addColumn("label", "string", array("notnull" => true)); $softwaresTable->addColumn("port", "integer", array("notnull" => true, "length" => 6)); $softwaresTable->addColumn("status", "integer", array("notnull" => true, "length" => 1, "default" => '0')); $softwaresTable->addColumn("created_at", "integer", array("notnull" => true)); $softwaresTable->addColumn("updated_at", "integer", array("notnull" => true)); $softwaresTable->addColumn("checked_at", "integer", array("notnull" => false)); $softwaresTable->setPrimaryKey(array("id")); }
/** * @inheritdoc */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table oro_report **/ $table = $schema->createTable(self::TABLE_NAME); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('business_unit_owner_id', 'integer', ['notnull' => false]); $table->addColumn('type', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('description', 'text', ['notnull' => false]); $table->addColumn('entity', 'string', ['length' => 255]); $table->addColumn('definition', 'text', []); $table->addColumn('createdAt', 'datetime', []); $table->addColumn('updatedAt', 'datetime', []); $table->setPrimaryKey(['id']); $table->addIndex(['type'], 'IDX_B48821B68CDE5729', []); $table->addIndex(['business_unit_owner_id'], 'IDX_B48821B659294170', []); /** End of generate table oro_report **/ /** Generate table oro_report_type **/ $table = $schema->createTable('oro_report_type'); $table->addColumn('name', 'string', ['length' => 32]); $table->addColumn('label', 'string', ['length' => 255]); $table->setPrimaryKey(['name']); $table->addUniqueIndex(['label'], 'UNIQ_397D3359EA750E8'); /** End of generate table oro_report_type **/ /** Generate foreign keys for table oro_report **/ $table = $schema->getTable(self::TABLE_NAME); $table->addForeignKeyConstraint($schema->getTable('oro_business_unit'), ['business_unit_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_report_type'), ['type'], ['name'], ['onDelete' => null, 'onUpdate' => null]); /** End of generate foreign keys for table oro_report **/ // @codingStandardsIgnoreEnd }
public function testRunActivityLists() { $connection = $this->getMockBuilder('Doctrine\\DBAL\\Connection')->disableOriginalConstructor()->getMock(); $connection->expects($this->any())->method('getDatabasePlatform')->will($this->returnValue(new MySqlPlatform())); $this->migrationQuery->setConnection($connection); $table = $this->schema->createTable('acme_test'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->setPrimaryKey(['id']); $table = $this->schema->createTable('oro_activity_list'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->setPrimaryKey(['id']); $extendOptionsManager = new ExtendOptionsManager(); $entityMetadataHelper = $this->getMockBuilder('Oro\\Bundle\\EntityExtendBundle\\Migration\\EntityMetadataHelper')->disableOriginalConstructor()->getMock(); $extendExtension = new ExtendExtension($extendOptionsManager, $entityMetadataHelper); $extendExtension->setNameGenerator($this->nameGenerator); $this->activityListExtension->setExtendExtension($extendExtension); $this->provider->expects($this->once())->method('getTargetEntityClasses')->willReturn(['Acme\\TestBundle\\Entity\\Test']); $this->metadataHelper->expects($this->once())->method('getTableNameByEntityClass')->with('Acme\\TestBundle\\Entity\\Test')->willReturn('acme_test'); $entityMetadataHelper->expects($this->any())->method('getEntityClassByTableName')->willReturnCallback(function ($tableName) { if ($tableName === 'acme_test') { return 'Acme\\TestBundle\\Entity\\Test'; } return 'Oro\\Bundle\\ActivityListBundle\\Entity\\ActivityList'; }); $log = $this->migrationQuery->getDescription(); $this->assertEquals('CREATE TABLE oro_rel_c3990ba6784dd132527c89 (activitylist_id INT NOT NULL, test_id INT NOT NULL, ' . 'INDEX IDX_53682E3596EB1108 (activitylist_id), INDEX IDX_53682E351E5D0459 (test_id), ' . 'PRIMARY KEY(activitylist_id, test_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ' . 'ENGINE = InnoDB', $log[0]); $this->assertEquals('ALTER TABLE oro_rel_c3990ba6784dd132527c89 ADD CONSTRAINT FK_53682E3596EB1108 ' . 'FOREIGN KEY (activitylist_id) REFERENCES oro_activity_list (id) ON DELETE CASCADE', $log[1]); $this->assertEquals('ALTER TABLE oro_rel_c3990ba6784dd132527c89 ADD CONSTRAINT FK_53682E351E5D0459 FOREIGN KEY (test_id) ' . 'REFERENCES acme_test (id) ON DELETE CASCADE', $log[2]); }
public function createShopSchema() { $schema = new Schema(); $products = $schema->createTable('Products'); $products->addColumn('ProductID', 'integer'); $products->addColumn('SupplierID', 'integer'); $products->addColumn('ProductName', 'string'); $products->addColumn('Price', 'decimal', array('scale' => 2, 'precision' => 12)); $products->setPrimaryKey(array('ProductID')); $products->addOption('azure.federated', true); $customers = $schema->createTable('Customers'); $customers->addColumn('CustomerID', 'integer'); $customers->addColumn('CompanyName', 'string'); $customers->addColumn('FirstName', 'string'); $customers->addColumn('LastName', 'string'); $customers->setPrimaryKey(array('CustomerID')); $customers->addOption('azure.federated', true); $customers->addOption('azure.federatedOnColumnName', 'CustomerID'); $orders = $schema->createTable('Orders'); $orders->addColumn('CustomerID', 'integer'); $orders->addColumn('OrderID', 'integer'); $orders->addColumn('OrderDate', 'datetime'); $orders->setPrimaryKey(array('CustomerID', 'OrderID')); $orders->addOption('azure.federated', true); $orders->addOption('azure.federatedOnColumnName', 'CustomerID'); $orderItems = $schema->createTable('OrderItems'); $orderItems->addColumn('CustomerID', 'integer'); $orderItems->addColumn('OrderID', 'integer'); $orderItems->addColumn('ProductID', 'integer'); $orderItems->addColumn('Quantity', 'integer'); $orderItems->setPrimaryKey(array('CustomerID', 'OrderID', 'ProductID')); $orderItems->addOption('azure.federated', true); $orderItems->addOption('azure.federatedOnColumnName', 'CustomerID'); return $schema; }
/** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { /** Generate table timelap_tracker **/ $table = $schema->createTable('timelap_tracker'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('task_id', 'integer', ['notnull' => false]); $table->addColumn('user_id', 'integer', ['notnull' => false]); $table->addColumn('date_started', 'datetime', []); $table->setPrimaryKey(['id']); $table->addIndex(['user_id'], 'IDX_36D2AA8AA76ED395', []); $table->addIndex(['task_id'], 'IDX_36D2AA8A8DB60186', []); /** End of generate table timelap_tracker **/ /** Generate table timelap_worklog **/ $table = $schema->createTable('timelap_worklog'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('task_id', 'integer', ['notnull' => false]); $table->addColumn('user_id', 'integer', ['notnull' => false]); $table->addColumn('time_spent', 'integer', []); $table->addColumn('date_started', 'datetime', []); $table->addColumn('description', 'string', ['notnull' => false, 'length' => 255]); $table->setPrimaryKey(['id']); $table->addIndex(['task_id'], 'IDX_797F12A38DB60186', []); $table->addIndex(['user_id'], 'IDX_797F12A3A76ED395', []); /** End of generate table timelap_worklog **/ /** Generate foreign keys for table timelap_tracker **/ $table = $schema->getTable('timelap_tracker'); $table->addForeignKeyConstraint($schema->getTable('orocrm_task'), ['task_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['user_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table timelap_tracker **/ /** Generate foreign keys for table timelap_worklog **/ $table = $schema->getTable('timelap_worklog'); $table->addForeignKeyConstraint($schema->getTable('orocrm_task'), ['task_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['user_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table timelap_worklog **/ }
public function up(Schema $schema) { ####################################################################### # Baikal\DavServicesBundle\Entity\Lock ####################################################################### $locks = $schema->createTable('locks'); $locks->addColumn('id', 'integer')->setAutoincrement(true); $locks->addColumn('owner', 'string', array('length' => 100, 'notnull' => false)); $locks->addColumn('timeout', 'integer', array('notnull' => false)); $locks->addColumn('created', 'integer', array('notnull' => false)); $locks->addColumn('token', 'string', array('length' => 100, 'notnull' => false)); $locks->addColumn('scope', 'integer', array('notnull' => false)); $locks->addColumn('depth', 'integer', array('notnull' => false)); $locks->addColumn('uri', 'string', array('length' => 1000, 'notnull' => false)); $locks->setPrimaryKey(array('id')); $locks->addIndex(array('token')); ####################################################################### # Baikal\DavServicesBundle\Entity\PropertyStorage ####################################################################### $propertystorage = $schema->createTable('propertystorage'); $propertystorage->addColumn('id', 'integer')->setAutoincrement(true); $propertystorage->addColumn('path', 'string', array('length' => 1024)); $propertystorage->addColumn('name', 'string', array('length' => 100)); $propertystorage->addColumn('value', 'blob'); $propertystorage->setPrimaryKey(array('id')); }
/** * @return Schema[] */ protected function prepareSchemas() { Type::addType('int', 'Doctrine\\DBAL\\Types\\IntegerType'); $fromSchema = new Schema(); $table = $fromSchema->createTable('oro_entity_extend_test_table'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('someExternalColumn', 'string'); $table->addColumn('relation_id', 'int'); $table->addIndex(['someExternalColumn'], 'some_external_index_name'); $table->setPrimaryKey(['id']); $tableRelation = $fromSchema->createTable('oro_entity_extend_test_relation'); $tableRelation->addColumn('id', 'integer', ['autoincrement' => true]); $tableRelation->addColumn('someExtendColumn', 'string'); $tableRelation->addIndex(['someExtendColumn'], 'oro_idx_index_name'); $tableRelation->setPrimaryKey(['id']); $table->addForeignKeyConstraint($tableRelation, ['relation_id'], ['id']); $toSchema = new Schema(); $table = $toSchema->createTable('oro_entity_extend_test_table'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->setPrimaryKey(['id']); $tableRelation = $toSchema->createTable('oro_entity_extend_test_relation'); $tableRelation->addColumn('id', 'integer', ['autoincrement' => true]); $tableRelation->setPrimaryKey(['id']); return [$fromSchema, $toSchema]; }
/** * @inheritdoc * @SuppressWarnings(PHPMD.ExcessiveMethodLength) */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table oro_config **/ $table = $schema->createTable('oro_config'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('entity', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('record_id', 'integer', ['notnull' => false]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['entity', 'record_id'], 'CONFIG_UQ_ENTITY'); /** End of generate table oro_config **/ /** Generate table oro_config_value **/ $table = $schema->createTable('oro_config_value'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('config_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('section', 'string', ['notnull' => false, 'length' => 50]); $table->addColumn('text_value', 'text', ['notnull' => false]); $table->addColumn('object_value', 'object', ['notnull' => false, 'comment' => '(DC2Type:object)']); $table->addColumn('array_value', 'array', ['notnull' => false, 'comment' => '(DC2Type:array)']); $table->addColumn('type', 'string', ['length' => 20]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['name', 'section', 'config_id'], 'CONFIG_VALUE_UQ_ENTITY'); $table->addIndex(['config_id'], 'IDX_DAF6DF5524DB0683', []); /** End of generate table oro_config_value **/ /** Generate foreign keys for table oro_config_value **/ $table = $schema->getTable('oro_config_value'); $table->addForeignKeyConstraint($schema->getTable('oro_config'), ['config_id'], ['id'], ['onDelete' => null, 'onUpdate' => null]); /** End of generate foreign keys for table oro_config_value **/ // @codingStandardsIgnoreEnd }
/** * Return the modules database metadata. * * This not record FK or other indexes. * * @return Doctrine\DBAL\Schema\Schema * @param Doctrine\DBAL\Schema\Schema $sc The schema to add new tables too */ protected function createModuleDBMeta(Schema $sc) { $sGroupTableName = self::DB_TABLE_VOUCHER_GROUP; $sInstanceTableName = self::DB_TABLE_VOUCHER_INSTANCE; $sRuleTableName = self::DB_TABLE_VOUCHER_RULE; $sTypeTableName = self::DB_TABLE_VOUCHER_TYPE; # Voucher Groups $table = $sc->createTable($sGroupTableName); $table->addColumn('voucher_group_id', 'integer', array("unsigned" => true, 'autoincrement' => true)); $table->addColumn('voucher_group_name', 'string', array("length" => 100)); $table->addColumn('voucher_group_slug', 'string', array("length" => 100)); $table->addColumn('is_disabled', 'boolean', array("default" => false)); $table->addColumn('sort_order', 'integer', array("unsigned" => true)); $table->addColumn('date_created', 'datetime', array()); $table->setPrimaryKey(array('voucher_group_id')); $table->addUniqueIndex(array('voucher_group_slug'), 'gl_voucher_group_uiq1'); # Voucher Rules $table = $sc->createTable($sRuleTableName); $table->addColumn('voucher_rule_name', 'string', array('length' => 25)); $table->addColumn('voucher_rule_slug', 'string', array("length" => 25)); $table->addColumn('voucher_gen_rule_id', 'integer', array('unsigned' => true, 'autoincrement' => true)); $table->addColumn('voucher_padding_char', 'string', array('legnth' => '1')); $table->addColumn('voucher_prefix', 'string', array('length' => 50)); $table->addColumn('voucher_suffix', 'string', array('length' => 50)); $table->addColumn('voucher_length', 'smallint', array('unsigned' => true, 'length' => 3)); $table->addColumn('date_created', 'datetime', array()); $table->addColumn('voucher_sequence_no', 'integer', array('unsigned' => true)); $table->addColumn('voucher_sequence_strategy', 'string', array('length' => 20)); $table->setPrimaryKey(array('voucher_gen_rule_id')); # Voucher Type Table $table = $sc->createTable($sTypeTableName); $table->addColumn('voucher_type_id', 'integer', array("unsigned" => true, 'autoincrement' => true)); $table->addColumn("voucher_enabled_from", "datetime", array()); $table->addColumn("voucher_enabled_to", "datetime", array()); $table->addColumn('voucher_name', 'string', array('length' => 100)); $table->addColumn('voucher_name_slug', 'string', array('length' => 100)); $table->addColumn('voucher_description', 'string', array('length' => 500)); $table->addColumn('voucher_group_id', 'integer', array('unsigned' => true)); $table->addColumn('voucher_gen_rule_id', 'integer', array('unsigned' => true)); $table->setPrimaryKey(array('voucher_type_id')); $table->addForeignKeyConstraint('ledger_voucher_group', array('voucher_group_id'), array('voucher_group_id'), array(), 'gl_voucher_type_fk1'); $table->addForeignKeyConstraint('ledger_voucher_gen_rule', array('voucher_gen_rule_id'), array('voucher_gen_rule_id'), array(), 'gl_voucher_type_fk2s'); $table->addUniqueIndex(array('voucher_name', 'voucher_enabled_from'), 'gl_voucher_type_uiq1'); # Vouchers Table (Instance Table) $table = $sc->createTable($sInstanceTableName); $table->addColumn('voucher_instance_id', 'integer', array("unsigned" => true, 'autoincrement' => true)); $table->addColumn('voucher_type_id', 'integer', array("unsigned" => true)); $table->addColumn('voucher_code', 'string', array("length" => 255)); $table->addColumn('date_created', 'datetime', array()); $table->setPrimaryKey(array('voucher_instance_id')); $table->addForeignKeyConstraint('ledger_voucher_type', array('voucher_type_id'), array('voucher_type_id'), array(), 'gl_voucher_instance_fk1'); $table->addUniqueIndex(array('voucher_code'), 'gl_voucher_instance_uiq1'); return $sc; }
/** * @inheritdoc * @SuppressWarnings(PHPMD.ExcessiveMethodLength) */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table oro_calendar **/ $table = $schema->createTable('oro_calendar'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('user_owner_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['notnull' => false, 'length' => 255]); $table->setPrimaryKey(['id']); $table->addIndex(['user_owner_id'], 'IDX_1D171519EB185F9', []); /** End of generate table oro_calendar **/ /** Generate table oro_calendar_connection **/ $table = $schema->createTable('oro_calendar_connection'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('connected_calendar_id', 'integer', []); $table->addColumn('calendar_id', 'integer', []); $table->addColumn('created', 'datetime', []); $table->addColumn('color', 'string', ['notnull' => false, 'length' => 6]); $table->addColumn('background_color', 'string', ['notnull' => false, 'length' => 6]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['calendar_id', 'connected_calendar_id'], 'oro_calendar_connection_uq'); $table->addIndex(['calendar_id'], 'IDX_25D13AB8A40A2C8', []); $table->addIndex(['connected_calendar_id'], 'IDX_25D13AB8F94143E3', []); /** End of generate table oro_calendar_connection **/ /** Generate table oro_calendar_event **/ $table = $schema->createTable('oro_calendar_event'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('calendar_id', 'integer', []); $table->addColumn('title', 'text', []); $table->addColumn('start_at', 'datetime', []); $table->addColumn('end_at', 'datetime', []); $table->addColumn('all_day', 'boolean', []); $table->addColumn('reminder', 'boolean', []); $table->addColumn('remind_at', 'datetime', ['notnull' => false]); $table->addColumn('reminded', 'boolean', ['default' => '0']); $table->setPrimaryKey(['id']); $table->addIndex(['calendar_id'], 'IDX_2DDC40DDA40A2C8', []); $table->addIndex(['calendar_id', 'start_at', 'end_at'], 'oro_calendar_event_idx', []); /** End of generate table oro_calendar_event **/ /** Generate foreign keys for table oro_calendar **/ $table = $schema->getTable('oro_calendar'); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['user_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); /** End of generate foreign keys for table oro_calendar **/ /** Generate foreign keys for table oro_calendar_connection **/ $table = $schema->getTable('oro_calendar_connection'); $table->addForeignKeyConstraint($schema->getTable('oro_calendar'), ['connected_calendar_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_calendar'), ['calendar_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_calendar_connection **/ /** Generate foreign keys for table oro_calendar_event **/ $table = $schema->getTable('oro_calendar_event'); $table->addForeignKeyConstraint($schema->getTable('oro_calendar'), ['calendar_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_calendar_event **/ // @codingStandardsIgnoreEnd }
/** * @param Schema $schema */ public function up(Schema $schema) { $userRoleTable = $schema->createTable(UserPermissionsServiceProvider::USER_ROLES_TABLE); $userRoleTable->addColumn(self::USER_ID_COLUMN, Type::GUID)->setLength(36)->setNotnull(true); $userRoleTable->addColumn(self::ROLE_ID_COLUMN, Type::GUID)->setLength(36)->setNotnull(true); $userRoleTable->setPrimaryKey(array(self::USER_ID_COLUMN, self::ROLE_ID_COLUMN)); $rolePermissionTable = $schema->createTable(UserPermissionsServiceProvider::ROLE_PERMISSIONS_TABLE); $rolePermissionTable->addColumn(self::ROLE_ID_COLUMN, Type::GUID)->setLength(36)->setNotnull(true); $rolePermissionTable->addColumn(self::PERMISSION_COLUMN, Type::STRING)->setLength(255)->setNotnull(true); $rolePermissionTable->setPrimaryKey(array(self::ROLE_ID_COLUMN, self::PERMISSION_COLUMN)); }
public function up(Schema $schema) { ####################################################################### # Baikal\DavServicesBundle\Entity\Addressbook ####################################################################### $addressbooks = $schema->createTable('addressbooks'); $addressbooks->addColumn('id', 'integer')->setAutoincrement(true); $addressbooks->addColumn('principaluri', 'string', array('length' => 255, 'notnull' => false)); $addressbooks->addColumn('displayname', 'string', array('length' => 255, 'notnull' => false)); $addressbooks->addColumn('uri', 'string', array('length' => 255, 'notnull' => false)); $addressbooks->addColumn('synctoken', 'integer', array('notnull' => false)); $addressbooks->addColumn('description', 'text', array('notnull' => false)); $addressbooks->setPrimaryKey(array('id')); $addressbooks->addUniqueIndex(array('principaluri', 'uri')); ####################################################################### # Baikal\DavServicesBundle\Entity\AddressbookContact ####################################################################### $cards = $schema->createTable('cards'); $cards->addColumn('id', 'integer')->setAutoincrement(true); $cards->addColumn('carddata', 'text', array('notnull' => false)); $cards->addColumn('uri', 'string', array('length' => 255, 'notnull' => false)); $cards->addColumn('lastmodified', 'integer', array('notnull' => false)); $cards->addColumn('etag', 'string', array('length' => 32, 'notnull' => false)); $cards->addColumn('size', 'integer', array('notnull' => false)); $cards->addColumn('addressbookid', 'integer'); $cards->setPrimaryKey(array('id')); ####################################################################### # Baikal\DavServicesBundle\Entity\AddressbookChange ####################################################################### $addressbookchanges = $schema->createTable('addressbookchanges'); $addressbookchanges->addColumn('id', 'integer')->setAutoincrement(true); $addressbookchanges->addColumn('uri', 'string', array('length' => 255, 'notnull' => false)); $addressbookchanges->addColumn('synctoken', 'integer', array('notnull' => false)); $addressbookchanges->addColumn('operation', 'boolean', array('notnull' => false)); $addressbookchanges->addColumn('addressbookid', 'integer'); $addressbookchanges->setPrimaryKey(array('id')); $addressbookchanges->addIndex(array('addressbookid', 'synctoken'), 'addressbookid_synctoken'); ####################################################################### # Relations ####################################################################### # addressbooks <= cards #$cards->addForeignKeyConstraint( # $addressbooks, # Foreign table # array('addressbookid'), # Local key # array('id') # Foreign key #); # addressbooks <= addressbookchanges #$addressbookchanges->addForeignKeyConstraint( # $addressbooks, # Foreign table # array('addressbookid'), # Local key # array('id') # Foreign key #); }
/** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { /** Generate table oro_tracking_data **/ $table = $schema->createTable('oro_tracking_data'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('event_id', 'integer', ['notnull' => false]); $table->addColumn('data', 'text', []); $table->addColumn('created_at', 'datetime', []); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['event_id'], 'UNIQ_B3CFDD2D71F7E88B'); /** End of generate table oro_tracking_data **/ /** Generate table oro_tracking_event **/ $table = $schema->createTable('oro_tracking_event'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('website_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('value', 'float', ['notnull' => false]); $table->addColumn('user', 'string', ['length' => 255]); $table->addColumn('created_at', 'datetime', []); $table->addColumn('logged_at', 'datetime', []); $table->addColumn('url', 'string', ['length' => 255]); $table->addColumn('title', 'string', ['notnull' => false, 'length' => 255]); $table->setPrimaryKey(['id']); $table->addIndex(['website_id'], 'IDX_AAD45A1E18F45C82', []); $table->addIndex(['name'], 'event_name_idx', []); $table->addIndex(['logged_at'], 'event_loggedAt_idx', []); /** End of generate table oro_tracking_event **/ /** Generate table oro_tracking_website **/ $table = $schema->createTable('oro_tracking_website'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('user_owner_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('identifier', 'string', ['length' => 255]); $table->addColumn('url', 'string', ['length' => 255]); $table->addColumn('created_at', 'datetime', []); $table->addColumn('updated_at', 'datetime', ['notnull' => false]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['identifier'], 'UNIQ_19038898772E836A'); $table->addIndex(['user_owner_id'], 'IDX_190388989EB185F9', []); /** End of generate table oro_tracking_website **/ /** Generate foreign keys for table oro_tracking_data **/ $table = $schema->getTable('oro_tracking_data'); $table->addForeignKeyConstraint($schema->getTable('oro_tracking_event'), ['event_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_tracking_data **/ /** Generate foreign keys for table oro_tracking_event **/ $table = $schema->getTable('oro_tracking_event'); $table->addForeignKeyConstraint($schema->getTable('oro_tracking_website'), ['website_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_tracking_event **/ /** Generate foreign keys for table oro_tracking_website **/ $table = $schema->getTable('oro_tracking_website'); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['user_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); /** End of generate foreign keys for table oro_tracking_website **/ }
/** * @param Schema $schema */ protected function createOroB2BPaymentIntersectionTables(Schema $schema) { $table = $schema->createTable(static::PAYMENT_TERM_TO_ACCOUNT_TABLE); $table->addColumn('payment_term_id', 'integer', []); $table->addColumn('account_id', 'integer', []); $table->setPrimaryKey(['payment_term_id', 'account_id']); $table->addUniqueIndex(['account_id']); $table = $schema->createTable(static::PAYMENT_TERM_TO_ACCOUNT_GROUP_TABLE); $table->addColumn('payment_term_id', 'integer', []); $table->addColumn('account_group_id', 'integer', []); $table->setPrimaryKey(['payment_term_id', 'account_group_id']); $table->addUniqueIndex(['account_group_id']); }
/** * @inheritdoc */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table orocrm_call **/ $table = $schema->createTable('orocrm_call'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('call_direction_name', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('related_account_id', 'integer', ['notnull' => false]); $table->addColumn('related_contact_id', 'integer', ['notnull' => false]); $table->addColumn('call_status_name', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('owner_id', 'integer', ['notnull' => false]); $table->addColumn('contact_phone_id', 'integer', ['notnull' => false]); $table->addColumn('subject', 'string', ['length' => 255]); $table->addColumn('phone_number', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('notes', 'text', ['notnull' => false]); $table->addColumn('call_date_time', 'datetime', []); $table->addColumn('duration', 'time', ['notnull' => false]); $table->setPrimaryKey(['id']); $table->addIndex(['owner_id'], 'IDX_1FBD1A247E3C61F9', []); $table->addIndex(['related_contact_id'], 'IDX_1FBD1A246D6C2DFA', []); $table->addIndex(['related_account_id'], 'IDX_1FBD1A2411A6570A', []); $table->addIndex(['contact_phone_id'], 'IDX_1FBD1A24A156BF5C', []); $table->addIndex(['call_status_name'], 'IDX_1FBD1A2476DB3689', []); $table->addIndex(['call_direction_name'], 'IDX_1FBD1A249F3E257D', []); /** End of generate table orocrm_call **/ /** Generate table orocrm_call_direction **/ $table = $schema->createTable('orocrm_call_direction'); $table->addColumn('name', 'string', ['length' => 32]); $table->addColumn('label', 'string', ['length' => 255]); $table->setPrimaryKey(['name']); $table->addUniqueIndex(['label'], 'UNIQ_D0EB34BAEA750E8'); /** End of generate table orocrm_call_direction **/ /** Generate table orocrm_call_status **/ $table = $schema->createTable('orocrm_call_status'); $table->addColumn('name', 'string', ['length' => 32]); $table->addColumn('label', 'string', ['length' => 255]); $table->setPrimaryKey(['name']); $table->addUniqueIndex(['label'], 'UNIQ_FBA13581EA750E8'); /** End of generate table orocrm_call_status **/ /** Generate foreign keys for table orocrm_call **/ $table = $schema->getTable('orocrm_call'); $table->addForeignKeyConstraint($schema->getTable('orocrm_call_direction'), ['call_direction_name'], ['name'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('orocrm_account'), ['related_account_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('orocrm_contact'), ['related_contact_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('orocrm_call_status'), ['call_status_name'], ['name'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('orocrm_contact_phone'), ['contact_phone_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); /** End of generate foreign keys for table orocrm_call **/ // @codingStandardsIgnoreEnd }
/** * @return Schema */ public function createFixtureSchema() { $schema = new Schema(); $tableA = $schema->createTable("foo"); $tableA->addColumn("id", 'integer'); $tableA->addColumn("bar", 'string', array('length' => 255)); $tableA->setPrimaryKey(array("id")); $schema->createSequence("foo_seq"); $tableB = $schema->createTable("bar"); $tableB->addColumn("id", 'integer'); $tableB->setPrimaryKey(array("id")); $tableA->addForeignKeyConstraint($tableB, array("bar"), array("id")); return $schema; }
/** * @param Schema $schema */ public function up(Schema $schema) { // create beer table $beerTable = $schema->createTable('beers'); $beerTable->addColumn('id', Type::INTEGER, array('unsigned' => true))->setAutoincrement(true); $beerTable->addColumn('from_user', Type::STRING, array('length' => 32)); $beerTable->addColumn('to_user', Type::STRING, array('length' => 32)); $beerTable->setPrimaryKey(['id']); // create messages table $messagesTable = $schema->createTable('messages'); $messagesTable->addColumn('id', Type::INTEGER, array('unsigned' => true))->setAutoincrement(true); $messagesTable->addColumn('message', Type::TEXT); $messagesTable->setPrimaryKey(['id']); }
/** * @group DBAL-204 */ public function testCleanupForeignKeysDifferentOrder() { $config = new SchemaConfig(); $config->setName("test"); $schema = new Schema(array(), array(), $config); $testTable = $schema->createTable("test.test"); $testTable->addColumn('id', 'integer'); $fooTable = $schema->createTable("foo.bar"); $fooTable->addColumn('id', 'integer'); $testTable->addForeignKeyConstraint("foo.bar", array("id"), array("id")); $schema->visit(new RemoveNamespacedAssets()); $sql = $schema->toSql(new MySqlPlatform()); $this->assertEquals(1, count($sql), "Just one CREATE TABLE statement, no foreign key and table to foo.bar"); }
/** * @inheritdoc * @SuppressWarnings(PHPMD.ExcessiveMethodLength) */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table orocrm_account **/ $table = $schema->createTable('orocrm_account'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('default_contact_id', 'integer', ['notnull' => false]); $table->addColumn('shipping_address_id', 'integer', ['notnull' => false]); $table->addColumn('billing_address_id', 'integer', ['notnull' => false]); $table->addColumn('user_owner_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('createdAt', 'datetime', []); $table->addColumn('updatedAt', 'datetime', []); $table->addColumn('extend_description', 'text', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->addColumn('extend_website', 'string', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->addColumn('extend_employees', 'integer', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->addColumn('extend_ownership', 'string', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->addColumn('extend_ticker_symbol', 'string', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->addColumn('extend_rating', 'string', ['oro_options' => ['extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => false], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true]]]); $table->setPrimaryKey(['id']); $table->addIndex(['user_owner_id'], 'IDX_7166D3719EB185F9', []); $table->addIndex(['shipping_address_id'], 'IDX_7166D3714D4CFF2B', []); $table->addIndex(['billing_address_id'], 'IDX_7166D37179D0C0E4', []); $table->addIndex(['default_contact_id'], 'IDX_7166D371AF827129', []); $table->addIndex(['name'], 'account_name_idx', []); /** End of generate table orocrm_account **/ /** Generate table orocrm_account_to_contact **/ $table = $schema->createTable('orocrm_account_to_contact'); $table->addColumn('account_id', 'integer', []); $table->addColumn('contact_id', 'integer', []); $table->setPrimaryKey(['account_id', 'contact_id']); $table->addIndex(['account_id'], 'IDX_65B8FBEC9B6B5FBA', []); $table->addIndex(['contact_id'], 'IDX_65B8FBECE7A1254A', []); /** End of generate table orocrm_account_to_contact **/ /** Generate foreign keys for table orocrm_account **/ $table = $schema->getTable('orocrm_account'); $table->addForeignKeyConstraint($schema->getTable('orocrm_contact'), ['default_contact_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_address'), ['shipping_address_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_address'), ['billing_address_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['user_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); /** End of generate foreign keys for table orocrm_account **/ /** Generate foreign keys for table orocrm_account_to_contact **/ $table = $schema->getTable('orocrm_account_to_contact'); $table->addForeignKeyConstraint($schema->getTable('orocrm_contact'), ['contact_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('orocrm_account'), ['account_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table orocrm_account_to_contact **/ // @codingStandardsIgnoreEnd }
/** * @inheritdoc */ public function up(Schema $schema, QueryBag $queries) { // @codingStandardsIgnoreStart /** Generate table oro_segment **/ $table = $schema->createTable('oro_segment'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('business_unit_owner_id', 'integer', ['notnull' => false]); $table->addColumn('type', 'string', ['notnull' => true, 'length' => 32]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('description', 'text', ['notnull' => false]); $table->addColumn('entity', 'string', ['length' => 255]); $table->addColumn('definition', 'text', []); $table->addColumn('createdAt', 'datetime', []); $table->addColumn('updatedAt', 'datetime', []); $table->addColumn('last_run', 'datetime', ['notnull' => false]); $table->setPrimaryKey(['id']); $table->addIndex(['type'], 'IDX_D02603B38CDE5729', []); $table->addIndex(['business_unit_owner_id'], 'IDX_D02603B359294170', []); $table->addUniqueIndex(['name'], 'UNIQ_D02603B35E237E06'); /** End of generate table oro_segment **/ /** Generate table oro_segment_type **/ $table = $schema->createTable('oro_segment_type'); $table->addColumn('name', 'string', ['length' => 32]); $table->addColumn('label', 'string', ['length' => 255]); $table->setPrimaryKey(['name']); $table->addUniqueIndex(['label'], 'UNIQ_29D10555EA750E8'); /** End of generate table oro_segment_type **/ /** Generate table oro_segment_snapshot **/ $table = $schema->createTable('oro_segment_snapshot'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('entity_id', 'integer', []); $table->addColumn('segment_id', 'integer', ['notnull' => true]); $table->addColumn('createdAt', 'datetime', []); $table->addIndex(['segment_id'], 'IDX_43B8BB67DB296AAD'); $table->addUniqueIndex(['segment_id', 'entity_id'], 'UNIQ_43B8BB67DB296AAD81257D5D'); $table->setPrimaryKey(['id']); /** End of generate table oro_segment_snapshot **/ /** Generate foreign keys for table oro_segment **/ $table = $schema->getTable('oro_segment'); $table->addForeignKeyConstraint($schema->getTable('oro_business_unit'), ['business_unit_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]); $table->addForeignKeyConstraint($schema->getTable('oro_segment_type'), ['type'], ['name'], ['onDelete' => null, 'onUpdate' => null]); /** End of generate foreign keys for table oro_segment **/ /** Generate foreign keys for table oro_segment_snapshot **/ $table = $schema->getTable('oro_segment_snapshot'); $table->addForeignKeyConstraint($schema->getTable('oro_segment'), ['segment_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_segment_snapshot **/ // @codingStandardsIgnoreEnd }
/** * Generate table oro_reminder * * @param Schema $schema */ public static function oroReminderTable(Schema $schema) { /** Generate table oro_reminder **/ $table = $schema->createTable('oro_reminder'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('recipient_id', 'integer', ['notnull' => false]); $table->addColumn('subject', 'string', ['length' => 32]); $table->addColumn('start_at', 'datetime', []); $table->addColumn('expire_at', 'datetime', []); $table->addColumn('method', 'string', ['length' => 255]); $table->addColumn('interval_number', 'integer', []); $table->addColumn('interval_unit', 'string', ['length' => 1]); $table->addColumn('state', 'string', ['length' => 32]); $table->addColumn('related_entity_id', 'integer', []); $table->addColumn('related_entity_classname', 'string', ['length' => 255]); $table->addColumn('created_at', 'datetime', []); $table->addColumn('updated_at', 'datetime', ['notnull' => false]); $table->addColumn('sent_at', 'datetime', ['notnull' => false]); $table->addColumn('failure_exception', 'array', ['notnull' => false, 'comment' => '(DC2Type:array)']); $table->setPrimaryKey(['id']); $table->addIndex(['recipient_id'], 'IDX_2F4F9F57E92F8F78', []); $table->addIndex(['state'], 'reminder_state_idx', []); /** End of generate table oro_reminder **/ /** Generate foreign keys for table oro_reminder **/ $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['recipient_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); /** End of generate foreign keys for table oro_reminder **/ }
/** * @param Schema $schema */ private function createAuditField(Schema $schema) { $oroAuditFieldTable = $schema->createTable('oro_audit_field'); $oroAuditFieldTable->addColumn('id', 'integer', ['autoincrement' => true]); $oroAuditFieldTable->addColumn('audit_id', 'integer', []); $oroAuditFieldTable->addColumn('field', 'string', ['length' => 255]); $oroAuditFieldTable->addColumn('data_type', 'string', ['length' => 255]); $oroAuditFieldTable->addColumn('old_integer', 'bigint', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_float', 'float', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_boolean', 'boolean', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_text', 'text', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_date', 'date', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_time', 'time', ['notnull' => false]); $oroAuditFieldTable->addColumn('old_datetime', 'datetime', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_integer', 'bigint', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_float', 'float', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_boolean', 'boolean', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_text', 'text', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_date', 'date', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_time', 'time', ['notnull' => false]); $oroAuditFieldTable->addColumn('new_datetime', 'datetime', ['notnull' => false]); $oroAuditFieldTable->setPrimaryKey(['id']); $oroAuditFieldTable->addIndex(['audit_id'], 'IDX_9A31A824BD29F359', []); $oroAuditFieldTable->addForeignKeyConstraint($schema->getTable('oro_audit'), ['audit_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]); }
/** * @param \Doctrine\DBAL\Schema\Schema $schema * @param \SimpleXMLElement $xml * @throws \DomainException */ private function loadTable($schema, $xml) { $table = null; foreach ($xml->children() as $child) { /** * @var \SimpleXMLElement $child */ switch ($child->getName()) { case 'name': $name = (string) $child; $name = str_replace('*dbprefix*', $this->DBTABLEPREFIX, $name); $name = $this->platform->quoteIdentifier($name); $table = $schema->createTable($name); $table->addOption('collate', 'utf8_bin'); break; case 'create': case 'overwrite': case 'charset': break; case 'declaration': if (is_null($table)) { throw new \DomainException('Table declaration before table name'); } $this->loadDeclaration($table, $child); break; default: throw new \DomainException('Unknown element: ' . $child->getName()); } } }
/** * Create marello_address table * * @param Schema $schema */ protected function createMarelloAddressTable(Schema $schema) { $table = $schema->createTable('marello_address'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('region_code', 'string', ['notnull' => false, 'length' => 16]); $table->addColumn('country_code', 'string', ['notnull' => false, 'length' => 2]); $table->addColumn('email', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('phone', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('label', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('street', 'string', ['notnull' => false, 'length' => 500]); $table->addColumn('street2', 'string', ['notnull' => false, 'length' => 500]); $table->addColumn('city', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('postal_code', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('organization', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('region_text', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('name_prefix', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('first_name', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('middle_name', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('last_name', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('name_suffix', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('created', 'datetime', ['comment' => '(DC2Type:datetime)']); $table->addColumn('updated', 'datetime', ['comment' => '(DC2Type:datetime)']); $table->addIndex(['region_code'], 'idx_1c837761aeb327af', []); $table->setPrimaryKey(['id']); $table->addIndex(['country_code'], 'idx_1c837761f026bb7c', []); }
public function getMonitoringTable(SchemaBuilder $builder) { $table = $builder->createTable("later_job_monitor"); # setup pk $table->addColumn('monitor_id', 'integer', array("unsigned" => true, 'autoincrement' => true)); $table->setPrimaryKey(array("monitor_id")); # date and hour $table->addColumn('monitor_dte', 'datetime', array()); # add index $table->addUniqueIndex(array('monitor_dte')); # worker stats $table->addColumn('worker_max_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('worker_min_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('worker_mean_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('worker_mean_throughput', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('worker_max_throughput', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('worker_mean_utilization', 'float', array("unsigned" => true, 'notnull' => false)); # queue stats $table->addColumn('queue_no_waiting_jobs', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_no_failed_jobs', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_no_error_jobs', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_no_completed_jobs', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_no_processing_jobs', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_mean_service_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_min_service_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('queue_max_service_time', 'integer', array("unsigned" => true, 'notnull' => false)); $table->addColumn('monitor_complete', 'boolean', array('default' => false)); }
/** * @param Schema $schema */ public function up(Schema $schema) { // this up() migration is auto-generated, please modify it to your needs $table = $schema->createTable("foo"); $table->addColumn('id', 'integer', array('autoincrement' => true)); $table->setPrimaryKey(array('id')); }
/** * Creates 'oro_email_mailbox_process' table which represents MailboxProcessSettings entity. * A common shared mapped superclass for all mailbox process settings types. * * @param Schema $schema */ public static function createOroEmailMailboxProcessSettingsTable(Schema $schema) { $table = $schema->createTable('oro_email_mailbox_process'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('type', 'string', ['length' => 30]); $table->setPrimaryKey(['id']); }
/** * @param Schema $schema */ public function up(Schema $schema) { $table = $schema->createTable('event_permission_readmodel'); $table->addColumn('event_id', 'guid', array('length' => 36, 'notnull' => true)); $table->addColumn('user_id', 'guid', array('length' => 36, 'notnull' => true)); $table->setPrimaryKey(['event_id', 'user_id']); }
/** * @param Schema $schema * @param string $table * @throws \Doctrine\DBAL\Schema\SchemaException */ public static function addToSchema(Schema $schema, $table) { if ($schema->hasTable($table)) { $table = $schema->getTable($table); } else { $table = $schema->createTable($table); } if (!$table->hasColumn('event_id')) { $id = $table->addColumn('event_id', 'integer', ['unsigned' => true]); $id->setAutoincrement(true); $table->setPrimaryKey(['event_id']); } if (!$table->hasColumn('aggregate_id')) { $table->addColumn('aggregate_id', 'string', ['length' => 50]); } if (!$table->hasColumn('version')) { $table->addColumn('version', 'integer'); } if (!$table->hasColumn('type')) { $table->addColumn('type', 'string', ['length' => 100]); } if (!$table->hasColumn('payload')) { $table->addColumn('payload', 'text'); } if (!$table->hasColumn('recorded_on')) { $table->addColumn('recorded_on', 'string', ['length' => 50]); } $table->addUniqueIndex(['aggregate_id', 'version']); }
/** * Create orob2b_websites_locales table * * @param Schema $schema */ protected function createOrob2BWebsitesLocalesTable(Schema $schema) { $table = $schema->createTable('orob2b_websites_locales'); $table->addColumn('website_id', 'integer', []); $table->addColumn('locale_id', 'integer', []); $table->setPrimaryKey(['website_id', 'locale_id']); }