12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046 |
- <?php
- namespace OC\Core\Migrations;
- use Doctrine\DBAL\Platforms\PostgreSQL94Platform;
- use OCP\DB\Types;
- use OCP\DB\ISchemaWrapper;
- use OCP\IDBConnection;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version13000Date20170718121200 extends SimpleMigrationStep {
- public function __construct(
- private IDBConnection $connection,
- ) {
- }
- public function preSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- if (!$schema->hasTable('properties')) {
- return;
- }
-
-
- $table = $schema->getTable('properties');
- if ($table->hasColumn('fileid')) {
- $qb = $this->connection->getQueryBuilder();
- $qb->delete('properties');
- $qb->execute();
- }
- }
-
- public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- if (!$schema->hasTable('appconfig')) {
- $table = $schema->createTable('appconfig');
- $table->addColumn('appid', 'string', [
- 'notnull' => true,
- 'length' => 32,
- 'default' => '',
- ]);
- $table->addColumn('configkey', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('configvalue', 'text', [
- 'notnull' => false,
- ]);
- $table->setPrimaryKey(['appid', 'configkey']);
- $table->addIndex(['configkey'], 'appconfig_config_key_index');
- $table->addIndex(['appid'], 'appconfig_appid_key');
- }
- if (!$schema->hasTable('storages')) {
- $table = $schema->createTable('storages');
- $table->addColumn('id', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('numeric_id', Types::BIGINT, [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('available', 'integer', [
- 'notnull' => true,
- 'default' => 1,
- ]);
- $table->addColumn('last_checked', 'integer', [
- 'notnull' => false,
- ]);
- $table->setPrimaryKey(['numeric_id']);
- $table->addUniqueIndex(['id'], 'storages_id_index');
- }
- if (!$schema->hasTable('mounts')) {
- $table = $schema->createTable('mounts');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- ]);
- $table->addColumn('storage_id', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('root_id', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('user_id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- ]);
- $table->addColumn('mount_point', 'string', [
- 'notnull' => true,
- 'length' => 4000,
- ]);
- $table->addColumn('mount_id', Types::BIGINT, [
- 'notnull' => false,
- 'length' => 20,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['user_id'], 'mounts_user_index');
- $table->addIndex(['storage_id'], 'mounts_storage_index');
- $table->addIndex(['root_id'], 'mounts_root_index');
- $table->addIndex(['mount_id'], 'mounts_mount_id_index');
- $table->addIndex(['user_id', 'root_id', 'mount_point'], 'mounts_user_root_path_index', [], ['lengths' => [null, null, 128]]);
- } else {
- $table = $schema->getTable('mounts');
- $table->addColumn('mount_id', Types::BIGINT, [
- 'notnull' => false,
- 'length' => 20,
- ]);
- if (!$table->hasIndex('mounts_mount_id_index')) {
- $table->addIndex(['mount_id'], 'mounts_mount_id_index');
- }
- }
- if (!$schema->hasTable('mimetypes')) {
- $table = $schema->createTable('mimetypes');
- $table->addColumn('id', Types::BIGINT, [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('mimetype', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['mimetype'], 'mimetype_id_index');
- }
- if (!$schema->hasTable('filecache')) {
- $table = $schema->createTable('filecache');
- $table->addColumn('fileid', Types::BIGINT, [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 20,
- ]);
- $table->addColumn('storage', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('path', 'string', [
- 'notnull' => false,
- 'length' => 4000,
- ]);
- $table->addColumn('path_hash', 'string', [
- 'notnull' => true,
- 'length' => 32,
- 'default' => '',
- ]);
- $table->addColumn('parent', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('name', 'string', [
- 'notnull' => false,
- 'length' => 250,
- ]);
- $table->addColumn('mimetype', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('mimepart', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('size', 'bigint', [
- 'notnull' => true,
- 'length' => 8,
- 'default' => 0,
- ]);
- $table->addColumn('mtime', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('storage_mtime', Types::BIGINT, [
- 'notnull' => true,
- 'length' => 20,
- 'default' => 0,
- ]);
- $table->addColumn('encrypted', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- ]);
- $table->addColumn('unencrypted_size', 'bigint', [
- 'notnull' => true,
- 'length' => 8,
- 'default' => 0,
- ]);
- $table->addColumn('etag', 'string', [
- 'notnull' => false,
- 'length' => 40,
- ]);
- $table->addColumn('permissions', 'integer', [
- 'notnull' => false,
- 'length' => 4,
- 'default' => 0,
- ]);
- $table->addColumn('checksum', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- $table->setPrimaryKey(['fileid']);
- $table->addUniqueIndex(['storage', 'path_hash'], 'fs_storage_path_hash');
- $table->addIndex(['parent', 'name'], 'fs_parent_name_hash');
- $table->addIndex(['storage', 'mimetype'], 'fs_storage_mimetype');
- $table->addIndex(['storage', 'mimepart'], 'fs_storage_mimepart');
- $table->addIndex(['storage', 'size', 'fileid'], 'fs_storage_size');
- $table->addIndex(['fileid', 'storage', 'size'], 'fs_id_storage_size');
- $table->addIndex(['parent'], 'fs_parent');
- $table->addIndex(['mtime'], 'fs_mtime');
- $table->addIndex(['size'], 'fs_size');
- if (!$schema->getDatabasePlatform() instanceof PostgreSQL94Platform) {
- $table->addIndex(['storage', 'path'], 'fs_storage_path_prefix', [], ['lengths' => [null, 64]]);
- }
- }
- if (!$schema->hasTable('group_user')) {
- $table = $schema->createTable('group_user');
- $table->addColumn('gid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['gid', 'uid']);
- $table->addIndex(['uid'], 'gu_uid_index');
- }
- if (!$schema->hasTable('group_admin')) {
- $table = $schema->createTable('group_admin');
- $table->addColumn('gid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['gid', 'uid']);
- $table->addIndex(['uid'], 'group_admin_uid');
- }
- if (!$schema->hasTable('groups')) {
- $table = $schema->createTable('groups');
- $table->addColumn('gid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['gid']);
- }
- if (!$schema->hasTable('preferences')) {
- $table = $schema->createTable('preferences');
- $table->addColumn('userid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('appid', 'string', [
- 'notnull' => true,
- 'length' => 32,
- 'default' => '',
- ]);
- $table->addColumn('configkey', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('configvalue', 'text', [
- 'notnull' => false,
- ]);
- $table->setPrimaryKey(['userid', 'appid', 'configkey']);
- $table->addIndex(['appid', 'configkey'], 'preferences_app_key');
- }
- if (!$schema->hasTable('properties')) {
- $table = $schema->createTable('properties');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- ]);
- $table->addColumn('userid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('propertypath', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('propertyname', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('propertyvalue', 'text', [
- 'notnull' => true,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['userid'], 'property_index');
- $table->addIndex(['userid', 'propertypath'], 'properties_path_index');
- $table->addIndex(['propertypath'], 'properties_pathonly_index');
- } else {
- $table = $schema->getTable('properties');
- if ($table->hasColumn('propertytype')) {
- $table->dropColumn('propertytype');
- }
- if ($table->hasColumn('fileid')) {
- $table->dropColumn('fileid');
- }
- if (!$table->hasColumn('propertypath')) {
- $table->addColumn('propertypath', 'string', [
- 'notnull' => true,
- 'length' => 255,
- ]);
- }
- if (!$table->hasColumn('userid')) {
- $table->addColumn('userid', 'string', [
- 'notnull' => false,
- 'length' => 64,
- 'default' => '',
- ]);
- }
- }
- if (!$schema->hasTable('share')) {
- $table = $schema->createTable('share');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- ]);
- $table->addColumn('share_type', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->addColumn('share_with', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- $table->addColumn('password', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- $table->addColumn('uid_owner', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('uid_initiator', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('parent', 'integer', [
- 'notnull' => false,
- 'length' => 4,
- ]);
- $table->addColumn('item_type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('item_source', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- $table->addColumn('item_target', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- $table->addColumn('file_source', 'integer', [
- 'notnull' => false,
- 'length' => 4,
- ]);
- $table->addColumn('file_target', 'string', [
- 'notnull' => false,
- 'length' => 512,
- ]);
- $table->addColumn('permissions', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->addColumn('stime', 'bigint', [
- 'notnull' => true,
- 'length' => 8,
- 'default' => 0,
- ]);
- $table->addColumn('accepted', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->addColumn('expiration', 'datetime', [
- 'notnull' => false,
- ]);
- $table->addColumn('token', 'string', [
- 'notnull' => false,
- 'length' => 32,
- ]);
- $table->addColumn('mail_send', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->addColumn('share_name', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['item_type', 'share_type'], 'item_share_type_index');
- $table->addIndex(['file_source'], 'file_source_index');
- $table->addIndex(['token'], 'token_index');
- $table->addIndex(['share_with'], 'share_with_index');
- $table->addIndex(['parent'], 'parent_index');
- $table->addIndex(['uid_owner'], 'owner_index');
- $table->addIndex(['uid_initiator'], 'initiator_index');
- } else {
- $table = $schema->getTable('share');
- if (!$table->hasColumn('password')) {
- $table->addColumn('password', 'string', [
- 'notnull' => false,
- 'length' => 255,
- ]);
- }
- }
- if (!$schema->hasTable('jobs')) {
- $table = $schema->createTable('jobs');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('class', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('argument', 'string', [
- 'notnull' => true,
- 'length' => 4000,
- 'default' => '',
- ]);
- $table->addColumn('last_run', 'integer', [
- 'notnull' => false,
- 'default' => 0,
- ]);
- $table->addColumn('last_checked', 'integer', [
- 'notnull' => false,
- 'default' => 0,
- ]);
- $table->addColumn('reserved_at', 'integer', [
- 'notnull' => false,
- 'default' => 0,
- ]);
- $table->addColumn('execution_duration', 'integer', [
- 'notnull' => true,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['class'], 'job_class_index');
- $table->addIndex(['last_checked', 'reserved_at'], 'job_lastcheck_reserved');
- }
- if (!$schema->hasTable('users')) {
- $table = $schema->createTable('users');
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('displayname', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('password', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['uid']);
- }
- if (!$schema->hasTable('authtoken')) {
- $table = $schema->createTable('authtoken');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('login_name', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('password', 'text', [
- 'notnull' => false,
- ]);
- $table->addColumn('name', 'text', [
- 'notnull' => true,
- 'default' => '',
- ]);
- $table->addColumn('token', 'string', [
- 'notnull' => true,
- 'length' => 200,
- 'default' => '',
- ]);
- $table->addColumn('type', 'smallint', [
- 'notnull' => false,
- 'length' => 2,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('remember', 'smallint', [
- 'notnull' => false,
- 'length' => 1,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('last_activity', 'integer', [
- 'notnull' => false,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('last_check', 'integer', [
- 'notnull' => false,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('scope', 'text', [
- 'notnull' => false,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['token'], 'authtoken_token_index');
- $table->addIndex(['last_activity'], 'authtoken_last_activity_idx');
- } else {
- $table = $schema->getTable('authtoken');
- $table->addColumn('scope', 'text', [
- 'notnull' => false,
- ]);
- }
- if (!$schema->hasTable('bruteforce_attempts')) {
- $table = $schema->createTable('bruteforce_attempts');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('action', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('occurred', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('ip', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('subnet', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('metadata', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['ip'], 'bruteforce_attempts_ip');
- $table->addIndex(['subnet'], 'bruteforce_attempts_subnet');
- }
- if (!$schema->hasTable('vcategory')) {
- $table = $schema->createTable('vcategory');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('category', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['uid'], 'uid_index');
- $table->addIndex(['type'], 'type_index');
- $table->addIndex(['category'], 'category_index');
- }
- if (!$schema->hasTable('vcategory_to_object')) {
- $table = $schema->createTable('vcategory_to_object');
- $table->addColumn('objid', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('categoryid', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['categoryid', 'objid', 'type']);
- $table->addIndex(['objid', 'type'], 'vcategory_objectd_index');
- }
- if (!$schema->hasTable('systemtag')) {
- $table = $schema->createTable('systemtag');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('name', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('visibility', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 1,
- ]);
- $table->addColumn('editable', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 1,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['name', 'visibility', 'editable'], 'tag_ident');
- }
- if (!$schema->hasTable('systemtag_object_mapping')) {
- $table = $schema->createTable('systemtag_object_mapping');
- $table->addColumn('objectid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('objecttype', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('systemtagid', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->setPrimaryKey(['objecttype', 'objectid', 'systemtagid'], 'som_pk');
- $table->addIndex(['systemtagid', 'objecttype'], 'systag_by_tagid');
- }
- if (!$schema->hasTable('systemtag_group')) {
- $table = $schema->createTable('systemtag_group');
- $table->addColumn('systemtagid', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('gid', 'string', [
- 'notnull' => true,
- ]);
- $table->setPrimaryKey(['gid', 'systemtagid']);
- }
- if (!$schema->hasTable('file_locks')) {
- $table = $schema->createTable('file_locks');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('lock', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- ]);
- $table->addColumn('key', 'string', [
- 'notnull' => true,
- 'length' => 64,
- ]);
- $table->addColumn('ttl', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => -1,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['key'], 'lock_key_index');
- $table->addIndex(['ttl'], 'lock_ttl_index');
- }
- if (!$schema->hasTable('comments')) {
- $table = $schema->createTable('comments');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- 'unsigned' => true,
- ]);
- $table->addColumn('parent_id', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('topmost_parent_id', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('children_count', 'integer', [
- 'notnull' => true,
- 'length' => 4,
- 'default' => 0,
- 'unsigned' => true,
- ]);
- $table->addColumn('actor_type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('actor_id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('message', 'text', [
- 'notnull' => false,
- ]);
- $table->addColumn('verb', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('creation_timestamp', 'datetime', [
- 'notnull' => false,
- ]);
- $table->addColumn('latest_child_timestamp', 'datetime', [
- 'notnull' => false,
- ]);
- $table->addColumn('object_type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('object_id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('reference_id', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addIndex(['parent_id'], 'comments_parent_id_index');
- $table->addIndex(['topmost_parent_id'], 'comments_topmost_parent_id_idx');
- $table->addIndex(['object_type', 'object_id', 'creation_timestamp'], 'comments_object_index');
- $table->addIndex(['actor_type', 'actor_id'], 'comments_actor_index');
- }
- if (!$schema->hasTable('comments_read_markers')) {
- $table = $schema->createTable('comments_read_markers');
- $table->addColumn('user_id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('marker_datetime', 'datetime', [
- 'notnull' => false,
- ]);
- $table->addColumn('object_type', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('object_id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addIndex(['object_type', 'object_id'], 'comments_marker_object_index');
- $table->setPrimaryKey(['user_id', 'object_type', 'object_id'], 'crm_pk');
- }
- if (!$schema->hasTable('admin_sections')) {
- $table = $schema->createTable('admin_sections');
- $table->addColumn('id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- ]);
- $table->addColumn('class', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('priority', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['class'], 'admin_sections_class');
- }
- if (!$schema->hasTable('admin_settings')) {
- $table = $schema->createTable('admin_settings');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- ]);
- $table->addColumn('class', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('section', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('priority', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['class'], 'admin_settings_class');
- $table->addIndex(['section'], 'admin_settings_section');
- }
- if (!$schema->hasTable('personal_sections')) {
- $table = $schema->createTable('personal_sections');
- $table->addColumn('id', 'string', [
- 'notnull' => true,
- 'length' => 64,
- ]);
- $table->addColumn('class', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('priority', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['class'], 'personal_sections_class');
- }
- if (!$schema->hasTable('personal_settings')) {
- $table = $schema->createTable('personal_settings');
- $table->addColumn('id', 'integer', [
- 'autoincrement' => true,
- 'notnull' => true,
- 'length' => 4,
- ]);
- $table->addColumn('class', 'string', [
- 'notnull' => true,
- 'length' => 255,
- 'default' => '',
- ]);
- $table->addColumn('section', 'string', [
- 'notnull' => false,
- 'length' => 64,
- ]);
- $table->addColumn('priority', 'smallint', [
- 'notnull' => true,
- 'length' => 1,
- 'default' => 0,
- ]);
- $table->setPrimaryKey(['id']);
- $table->addUniqueIndex(['class'], 'personal_settings_class');
- $table->addIndex(['section'], 'personal_settings_section');
- }
- if (!$schema->hasTable('accounts')) {
- $table = $schema->createTable('accounts');
- $table->addColumn('uid', 'string', [
- 'notnull' => true,
- 'length' => 64,
- 'default' => '',
- ]);
- $table->addColumn('data', 'text', [
- 'notnull' => true,
- 'default' => '',
- ]);
- $table->setPrimaryKey(['uid']);
- }
- return $schema;
- }
- public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- if (!$schema->hasTable('dav_properties')) {
- return;
- }
- $query = $this->connection->getQueryBuilder();
- $query->select('*')
- ->from('dav_properties');
- $insert = $this->connection->getQueryBuilder();
- $insert->insert('properties')
- ->setValue('propertypath', $insert->createParameter('propertypath'))
- ->setValue('propertyname', $insert->createParameter('propertyname'))
- ->setValue('propertyvalue', $insert->createParameter('propertyvalue'))
- ->setValue('userid', $insert->createParameter('userid'));
- $result = $query->execute();
- while ($row = $result->fetch()) {
- preg_match('/(calendar)\/([A-z0-9-@_]+)\//', $row['propertypath'], $match);
- $insert->setParameter('propertypath', (string) $row['propertypath'])
- ->setParameter('propertyname', (string) $row['propertyname'])
- ->setParameter('propertyvalue', (string) $row['propertyvalue'])
- ->setParameter('userid', ($match[2] ?? ''));
- $insert->execute();
- }
- }
- }
|