Gecko [ paroquia-rio-de-mouro.pt ]

Linux anchor 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64
Apache/2.4.18 (Ubuntu)
Server IP : 10.10.100.4 & Your IP : 216.73.217.150
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
Version20170101010100.php	21.05 KB	-rw-r--r--	2018-04-19 18:15
Version20170101215145.php	4.5 KB	-rw-r--r--	2018-04-19 18:15
Version20170111103310.php	4.2 KB	-rw-r--r--	2018-04-19 18:15
Version20170213215145.php	532 B	-rw-r--r--	2018-04-19 18:15
Version20170214112458.php	1.46 KB	-rw-r--r--	2018-04-19 18:15
Version20170221114437.php	953 B	-rw-r--r--	2018-04-19 18:15
Version20170221121536.php	1.7 KB	-rw-r--r--	2018-04-19 18:15
Version20170315173825.php	3.53 KB	-rw-r--r--	2018-04-19 18:15
Version20170320173955.php	1.21 KB	-rw-r--r--	2018-04-19 18:15
Version20170418154659.php	1.32 KB	-rw-r--r--	2018-04-19 18:15
Version20170516100103.php	2.17 KB	-rw-r--r--	2018-04-19 18:15
Version20170526104128.php	1.57 KB	-rw-r--r--	2018-04-19 18:15
Version20170605143658.php	745 B	-rw-r--r--	2018-04-19 18:15
Version20170711191432.php	673 B	-rw-r--r--	2018-04-19 18:15
Version20170804201253.php	1.07 KB	-rw-r--r--	2018-04-19 18:15
Version20170928120000.php	628 B	-rw-r--r--	2018-04-19 18:15
Version20171026130750.php	787 B	-rw-r--r--	2018-04-19 18:15
Version20180123131835.php	880 B	-rw-r--r--	2018-04-19 18:15
Version20180319102121.php	543 B	-rw-r--r--	2018-04-19 18:15

Rename

<?php
namespace OC\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;
use OCP\Migration\ISchemaMigration;

class Version20170214112458 implements ISchemaMigration {

public function changeSchema(Schema $schema, array $options) {
		$prefix = $options['tablePrefix'];
		$table = $schema->createTable("{$prefix}accounts");
		$table->addColumn('id', Type::BIGINT, [
			'autoincrement' => true,
			'unsigned' => true,
			'notnull' => true,
		]);
		$table->addColumn('email', Type::STRING, [
			'notnull' => false,
			'length' => 255,
		]);
		$table->addColumn('user_id', Type::STRING, [
			'notnull' => true,
			'length' => 255,
		]);
		$table->addColumn('lower_user_id', Type::STRING, [
			'notnull' => true,
			'length' => 255,
		]);
		$table->addColumn('display_name', Type::STRING, [
			'notnull' => false,
			'length' => 255,
		]);
		$table->addColumn('quota', Type::STRING, [
			'notnull' => false,
			'length' => 32,
		]);
		$table->addColumn('last_login', Type::INTEGER, [
			'notnull' => true,
			'length' => 32,
			'default' => 0,
		]);
		$table->addColumn('backend', Type::STRING, [
			'notnull' => true,
			'length' => 64,
		]);
		$table->addColumn('home', Type::STRING, [
			'notnull' => true,
			'length' => 1024,
		]);
		$table->addColumn('state', Type::SMALLINT, [
			'notnull' => true,
			'default' => 0,
			'comment' => '0: initial, 1: enabled, 2: disabled, 3: deleted'
		]);

$table->setPrimaryKey(['id']);
		$table->addUniqueIndex(['user_id']);
    }
}