diff options
| -rw-r--r-- | appinfo/database.xml | 532 | ||||
| -rw-r--r-- | lib/Migration/Version0001Date20181204203147.php | 353 |
2 files changed, 353 insertions, 532 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml deleted file mode 100644 index 75d117c7..00000000 --- a/appinfo/database.xml +++ /dev/null @@ -1,532 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<database> - <name>*dbname*</name> - <create>true</create> - <overwrite>false</overwrite> - <charset>utf8</charset> - - <table> - <name>*dbprefix*social_server_actors</name> - <declaration> - - <field> - <name>id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - <primary>true</primary> - </field> - - <field> - <name>user_id</name> - <type>text</type> - <length>63</length> - <notnull>true</notnull> - </field> - - <field> - <name>preferred_username</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>summary</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>public_key</name> - <type>text</type> - <length>1000</length> - </field> - - <field> - <name>private_key</name> - <type>text</type> - <length>2000</length> - </field> - - <field> - <name>avatar_version</name> - <type>integer</type> - <length>2</length> - <notnull>false</notnull> - </field> - - <field> - <name>creation</name> - <type>timestamp</type> - </field> - - </declaration> - </table> - - <table> - <name>*dbprefix*social_server_follows</name> - <declaration> - - <field> - <name>id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - <primary>true</primary> - </field> - - <field> - <name>type</name> - <type>text</type> - <length>31</length> - <notnull>false</notnull> - </field> - - <field> - <name>actor_id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>object_id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>follow_id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>accepted</name> - <type>boolean</type> - <default>false</default> - <notnull>true</notnull> - </field> - - <field> - <name>creation</name> - <type>timestamp</type> - </field> - - </declaration> - </table> - - <table> - <name>*dbprefix*social_server_notes</name> - <declaration> - - <field> - <name>id</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - <primary>true</primary> - </field> - - <field> - <name>type</name> - <type>text</type> - <length>31</length> - <notnull>true</notnull> - </field> - - <field> - <name>to</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>to_array</name> - <type>text</type> - <length>2000</length> - <notnull>true</notnull> - </field> - - <field> - <name>cc</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>bcc</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>content</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>summary</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>published</name> - <type>text</type> - <length>31</length> - <notnull>true</notnull> - </field> - - <field> - <name>published_time</name> - <type>timestamp</type> - <default>0</default> - </field> - - <field> - <name>attributed_to</name> - <type>text</type> - <length>127</length> - </field> - - <field> - <name>in_reply_to</name> - <type>text</type> - <length>127</length> - </field> - - <field> - <name>source</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>instances</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>creation</name> - <type>timestamp</type> - </field> - - <field> - <name>local</name> - <type>boolean</type> - <default>false</default> - <notnull>true</notnull> - </field> - - </declaration> - </table> - - <table> - <name>*dbprefix*social_cache_actors</name> - <declaration> - - <field> - <name>id</name> - <type>string</type> - <length>127</length> - <notnull>true</notnull> - <primary>true</primary> - </field> - - <field> - <name>type</name> - <type>text</type> - <length>31</length> - <notnull>true</notnull> - </field> - - <field> - <name>account</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>local</name> - <type>boolean</type> - <default>false</default> - <notnull>true</notnull> - </field> - - <field> - <name>following</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>followers</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>inbox</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>shared_inbox</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>outbox</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>featured</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>url</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>preferred_username</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>name</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>icon_id</name> - <type>text</type> - <length>127</length> - <notnull>false</notnull> - </field> - - <field> - <name>summary</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>public_key</name> - <type>text</type> - <length>500</length> - <notnull>true</notnull> - </field> - - <field> - <name>source</name> - <type>text</type> - <length>3000</length> - <notnull>true</notnull> - </field> - - <field> - <name>details</name> - <type>text</type> - <length>3000</length> - <notnull>false</notnull> - </field> - - <field> - <name>creation</name> - <type>timestamp</type> - </field> - - </declaration> - </table> - - <table> - <name>*dbprefix*social_cache_documents</name> - <declaration> - - <field> - <name>id</name> - <type>string</type> - <length>127</length> - <notnull>true</notnull> - <primary>true</primary> - </field> - - <field> - <name>type</name> - <type>text</type> - <length>31</length> - <notnull>true</notnull> - </field> - - <field> - <name>media_type</name> - <type>text</type> - <length>63</length> - <notnull>true</notnull> - </field> - - <field> - <name>mime_type</name> - <type>text</type> - <length>63</length> - <notnull>true</notnull> - </field> - - <field> - <name>url</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>local_copy</name> - <type>text</type> - <length>127</length> - <notnull>true</notnull> - </field> - - <field> - <name>public</name> - <type>boolean</type> - <notnull>true</notnull> - </field> - - <field> - <name>error</name> - <type>integer</type> - <length>1</length> - <notnull>true</notnull> - </field> - - <field> - <name>creation</name> - <type>timestamp</type> - </field> - - <field> - <name>caching</name> - <type>timestamp</type> - </field> - - <index> - <name>unique_url</name> - <unique>true</unique> - <field> - <name>url</name> - </field> - </index> - </declaration> - </table> - - <table> - <name>*dbprefix*social_request_queue</name> - <declaration> - - <field> - <name>id</name> - <type>integer</type> - <length>11</length> - <unsigned>true</unsigned> - <notnull>true</notnull> - <autoincrement>true</autoincrement> - <primary>true</primary> - </field> - - <field> - <name>token</name> - <type>text</type> - <length>63</length> - <notnull>true</notnull> - </field> - - <field> - <name>author</name> - <type>text</type> - <length>1270</length> - <notnull>true</notnull> - </field> - - <field> - <name>activity</name> - <type>text</type> - <length>6000</length> - <notnull>true</notnull> - </field> - - <field> - <name>instance</name> - <type>text</type> - <length>500</length> - <notnull>false</notnull> - </field> - - <field> - <name>priority</name> - <type>integer</type> - <length>1</length> - <default>0</default> - <notnull>false</notnull> - </field> - - <field> - <name>status</name> - <type>integer</type> - <length>1</length> - <default>0</default> - <notnull>false</notnull> - </field> - - <field> - <name>tries</name> - <type>integer</type> - <length>2</length> - <default>0</default> - <notnull>false</notnull> - </field> - - <field> - <name>last</name> - <type>timestamp</type> - </field> - - </declaration> - </table> - -</database> - diff --git a/lib/Migration/Version0001Date20181204203147.php b/lib/Migration/Version0001Date20181204203147.php new file mode 100644 index 00000000..46bf48eb --- /dev/null +++ b/lib/Migration/Version0001Date20181204203147.php @@ -0,0 +1,353 @@ +<?php +declare(strict_types=1); +/** + * @copyright Copyright (c) 2018, Roeland Jago Douma <roeland@famdouma.nl> + * + * @author Roeland Jago Douma <roeland@famdouma.nl> + * + * @license GNU AGPL version 3 or any later version + * + * This program is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License as + * published by the Free Software Foundation, either version 3 of the + * License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Affero General Public License for more details. + * + * You should have received a copy of the GNU Affero General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + * + */ + +namespace OCA\Social\Migration; + +use Closure; +use OCP\DB\ISchemaWrapper; +use OCP\Migration\SimpleMigrationStep; +use OCP\Migration\IOutput; + +class Version0001Date20181204203147 extends SimpleMigrationStep { + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + * @return null|ISchemaWrapper + */ + public function changeSchema(IOutput $output, Closure $schemaClosure, array $options) { + /** @var ISchemaWrapper $schema */ + $schema = $schemaClosure(); + + if (!$schema->hasTable('social_server_actors')) { + $table = $schema->createTable('social_server_actors'); + $table->addColumn('id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('user_id', 'string', [ + 'notnull' => true, + 'length' => 63, + ]); + $table->addColumn('preferred_username', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('name', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('summary', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('public_key', 'string', [ + 'notnull' => false, + 'length' => 1000, + ]); + $table->addColumn('private_key', 'string', [ + 'notnull' => false, + 'length' => 2000, + ]); + $table->addColumn('avatar_version', 'integer', [ + 'notnull' => false, + 'length' => 2, + ]); + $table->addColumn('creation', 'datetime', [ + 'notnull' => false, + ]); + $table->setPrimaryKey(['id']); + } + + if (!$schema->hasTable('social_server_follows')) { + $table = $schema->createTable('social_server_follows'); + $table->addColumn('id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('type', 'string', [ + 'notnull' => false, + 'length' => 31, + ]); + $table->addColumn('actor_id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('object_id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('follow_id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('accepted', 'boolean', [ + 'notnull' => true, + 'default' => false + ]); + $table->addColumn('creation', 'datetime', [ + 'notnull' => false, + ]); + $table->setPrimaryKey(['id']); + } + + if (!$schema->hasTable('social_server_notes')) { + $table = $schema->createTable('social_server_notes'); + $table->addColumn('id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('type', 'string', [ + 'notnull' => true, + 'length' => 31, + ]); + $table->addColumn('to', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('to_array', 'string', [ + 'notnull' => true, + 'length' => 2000, + ]); + $table->addColumn('cc', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('bcc', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('content', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('summary', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('published', 'string', [ + 'notnull' => true, + 'length' => 31, + ]); + $table->addColumn('published_time', 'datetime', [ + 'notnull' => false, + ]); + $table->addColumn('attributed_to', 'string', [ + 'notnull' => false, + 'length' => 127, + ]); + $table->addColumn('in_reply_to', 'string', [ + 'notnull' => false, + 'length' => 127, + ]); + $table->addColumn('source', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('instances', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('creation', 'datetime', [ + 'notnull' => false, + ]); + $table->addColumn('local', 'boolean', [ + 'notnull' => true, + 'default' => false + ]); + $table->setPrimaryKey(['id']); + } + + if (!$schema->hasTable('social_cache_actors')) { + $table = $schema->createTable('social_cache_actors'); + $table->addColumn('id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('type', 'string', [ + 'notnull' => true, + 'length' => 31, + ]); + $table->addColumn('account', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('local', 'boolean', [ + 'notnull' => true, + 'default' => false + ]); + $table->addColumn('following', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('followers', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('inbox', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('shared_inbox', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('outbox', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('featured', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('url', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('preferred_username', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('name', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('icon_id', 'string', [ + 'notnull' => false, + 'length' => 127, + ]); + $table->addColumn('summary', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('public_key', 'string', [ + 'notnull' => true, + 'length' => 500, + ]); + $table->addColumn('source', 'string', [ + 'notnull' => true, + 'length' => 3000, + ]); + $table->addColumn('details', 'string', [ + 'notnull' => false, + 'length' => 3000, + ]); + $table->addColumn('creation', 'datetime', [ + 'notnull' => false, + ]); + $table->setPrimaryKey(['id']); + } + + if (!$schema->hasTable('social_cache_documents')) { + $table = $schema->createTable('social_cache_documents'); + $table->addColumn('id', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('type', 'string', [ + 'notnull' => true, + 'length' => 31, + ]); + $table->addColumn('media_type', 'string', [ + 'notnull' => true, + 'length' => 63, + ]); + $table->addColumn('mime_type', 'string', [ + 'notnull' => true, + 'length' => 63, + ]); + $table->addColumn('url', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('local_copy', 'string', [ + 'notnull' => true, + 'length' => 127, + ]); + $table->addColumn('public', 'boolean', [ + 'notnull' => true, + 'default' => false + ]); + $table->addColumn('error', 'smallint', [ + 'notnull' => true, + 'length' => 1, + ]); + $table->addColumn('creation', 'datetime', [ + 'notnull' => false, + ]); + $table->addColumn('caching', 'datetime', [ + 'notnull' => false, + ]); + $table->setPrimaryKey(['id']); + $table->addUniqueIndex(['url'], 'unique_url'); + } + + if (!$schema->hasTable('social_request_queue')) { + $table = $schema->createTable('social_request_queue'); + $table->addColumn('id', 'bigint', [ + 'autoincrement' => true, + 'notnull' => true, + 'length' => 11, + 'unsigned' => true, + ]); + $table->addColumn('token', 'string', [ + 'notnull' => true, + 'length' => 63, + ]); + $table->addColumn('author', 'string', [ + 'notnull' => true, + 'length' => 1270, + ]); + $table->addColumn('activity', 'string', [ + 'notnull' => true, + 'length' => 6000, + ]); + $table->addColumn('instance', 'string', [ + 'notnull' => false, + 'length' => 500, + ]); + $table->addColumn('priority', 'smallint', [ + 'notnull' => false, + 'length' => 1, + 'default' => 0, + ]); + $table->addColumn('status', 'smallint', [ + 'notnull' => false, + 'length' => 1, + 'default' => 0, + ]); + $table->addColumn('tries', 'smallint', [ + 'notnull' => false, + 'length' => 2, + 'default' => 0, + ]); + $table->addColumn('last', 'datetime', [ + 'notnull' => false, + ]); + $table->setPrimaryKey(['id']); + } + return $schema; + } +} |