View GitHub Repository files_paperhive

Schedule Inspection
Subscribe
Completed
Pull Request — master (#14)
by Piotr
01:32
created

Version20181006201617::changeSchema()   A

↳ Parent: Version20181006201617

Complexity

Conditions 2
Paths 2

Size

Total Lines 23

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 23
rs 9.552
c 0
b 0
f 0
cc 2
nc 2
nop 2
1 
<?php
2 
/**
3 
 * @author Piotr Mrowczynski <[email protected]>
4 
 *
5 
 * @copyright Copyright (c) 2017, ownCloud GmbH
6 
 * @license AGPL-3.0
7 
 *
8 
 * This code is free software: you can redistribute it and/or modify
9 
 * it under the terms of the GNU Affero General Public License, version 3,
10 
 * as published by the Free Software Foundation.
11 
 *
12 
 * This program is distributed in the hope that it will be useful,
13 
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 
 * GNU Affero General Public License for more details.
16 
 *
17 
 * You should have received a copy of the GNU Affero General Public License, version 3,
18 
 * along with this program.  If not, see <http://www.gnu.org/licenses/>
19 
 *
20 
 */
21 

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    22
                

                                    
                                                    
                
                
                
namespace OCA\Files_PaperHive\Migrations;

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    23
                

                                    
                                                    
                
                
                

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    24
                

                                    
                                                    
                
                
                
use Doctrine\DBAL\Schema\Schema;

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    25
                

                                    
                                                    
                
                
                
use OCP\Migration\ISchemaMigration;

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    26
                

                                    
                                                    
                
                
                

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    27
                

                                    
                                                    
                
                
                
class Version20181006201617 implements ISchemaMigration {

            


            
                                                                                                            
                                                                
            
                                    
            
            

                
                    28
                

                                    
                                                    
                
                
                

            


            
                                                        
            
                                    
            
            

                
                    29
                

                                    
                                                    
                
                
                
	public function changeSchema(Schema $schema, array $options) {

            


            
                                                        
            
                                    
            
            

                
                    30
                

                                    
                                                    
                
                
                
		$prefix = $options['tablePrefix'];

            


            
                                                        
            
                                    
            
            

                
                    31
                

                                    
                                                    
                
                
                
		if (!$schema->hasTable("{$prefix}paperhive")) {

            


            
                                                        
            
                                    
            
            

                
                    32
                

                                    
                                                    
                
                
                
			$table = $schema->createTable("{$prefix}paperhive");

            


            
                                                        
            
                                    
            
            

                
                    33
                

                                    
                                                    
                
                
                

            


            
                                                        
            
                                    
            
            

                
                    34
                

                                    
                                                    
                
                
                
			$table->addColumn('fileid', 'integer', [

            


            
                                                        
            
                                    
            
            

                
                    35
                

                                    
                                                    
                
                
                
				'length' => 20,

            


            
                                                        
            
                                    
            
            

                
                    36
                

                                    
                                                    
                
                
                
				'notnull' => true,

            


            
                                                        
            
                                    
            
            

                
                    37
                

                                    
                                                    
                
                
                
				'unsigned' => true,

            


            
                                                        
            
                                    
            
            

                
                    38
                

                                    
                                                    
                
                
                
			]);

            


            
                                                        
            
                                    
            
            

                
                    39
                

                                    
                                                    
                
                
                

            


            
                                                        
            
                                    
            
            

                
                    40
                

                                    
                                                    
                
                
                
			$table->addColumn('bookid', 'string', [

            


            
                                                        
            
                                    
            
            

                
                    41
                

                                    
                                                    
                
                
                
				'length' => 64,

            


            
                                                        
            
                                    
            
            

                
                    42
                

                                    
                                                    
                
                
                
				'notnull' => true,

            


            
                                                        
            
                                    
            
            

                
                    43
                

                                    
                                                    
                
                
                
				'default' => ''

            


            
                                                        
            
                                    
            
            

                
                    44
                

                                    
                                                    
                
                
                
			]);

            


            
                                                        
            
                                    
            
            

                
                    45
                

                                    
                                                    
                
                
                

            


            
                                                        
            
                                    
            
            

                
                    46
                

                                    
                                                    
                
                
                
			$table->addIndex(

            


            
                                                        
            
                                    
            
            

                
                    47
                

                                    
                                                    
                
                
                
				['fileid'],

            


            
                                                        
            
                                    
            
            

                
                    48
                

                                    
                                                    
                
                
                
				'paperhive_fileid_index'

            


            
                                                        
            
                                    
            
            

                
                    49
                

                                    
                                                    
                
                
                
			);

            


            
                                                        
            
                                    
            
            

                
                    50
                

                                    
                                                    
                
                
                
		}

            


            
                                                        
            
                                    
            
            

                
                    51
                

                                    
                                                    
                
                
                
	}

            


            
                                                        
            
                                    
            
            

                
                    52
                

                                    
                                                    
                
                
                
}

            


            
                                                        
            
                                    
            
            

                
                    53