View GitHub Repository ribs-module-blog

Schedule Inspection
Subscribe
Completed
Push — master ( 07fbdf...209162 )
by Anthony
02:20
created

install.php (1 issue)

← previous file next file →

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1 
<?php
2 
	$requete = "
3 
		DROP TABLE IF EXISTS _blog_article ;
4 
		CREATE TABLE _blog_article (ID_article INT  AUTO_INCREMENT NOT NULL,
5 
		title VARCHAR(50),
6 
		article TEXT,
7 
		publication_date DATETIME,
8 
		ID_identite INT,
9 
		ID_state INT NOT NULL,
10 
		PRIMARY KEY (ID_article) ) ENGINE=InnoDB;
11
12 
		DROP TABLE IF EXISTS _blog_state ;
13 
		CREATE TABLE _blog_state (ID_state INT  AUTO_INCREMENT NOT NULL,
14 
		state VARCHAR(50),
15 
		PRIMARY KEY (ID_state) ) ENGINE=InnoDB;
16
17 
		DROP TABLE IF EXISTS _blog_category ;
18 
		CREATE TABLE _blog_category (ID_category INT  AUTO_INCREMENT NOT NULL,
19 
		category VARCHAR(50),
20 
		PRIMARY KEY (ID_category) ) ENGINE=InnoDB;
21
22 
		DROP TABLE IF EXISTS _blog_configuration ;
23 
		CREATE TABLE _blog_configuration (ID_configuration INT  AUTO_INCREMENT NOT NULL,
24 
		force_login_comment INT(1),
25 
		article_index INT,
26 
		validate_comment INT(1),
27 
		PRIMARY KEY (ID_configuration) ) ENGINE=InnoDB;
28
29 
		DROP TABLE IF EXISTS _blog_article_category ;
30 
		CREATE TABLE _blog_article_category (ID_article_category INT  AUTO_INCREMENT NOT NULL,
31 
		ID_category INT,
32 
		ID_article INT,
33 
		PRIMARY KEY (ID_article_category) ) ENGINE=InnoDB;
34
35 
		INSERT INTO _blog_configuration (ID_configuration, force_login_comment, article_index, validate_comment) VALUES (NULL, '0', '5', '0');
36
37 
		INSERT INTO `_blog_state` (`ID_state`, `state`) VALUES (NULL, 'publish'), (NULL, 'draft'), (NULL, 'replay'), (NULL, 'trash');
38 
	";
39 
?>
0 ignored issues
– show
Best Practice introduced by
It is not recommended to use PHP's closing tag ?> in files other than templates.

Using a closing tag in PHP files that only contain PHP code is not recommended as you might accidentally add whitespace after the closing tag which would then be output by PHP. This can cause severe problems, for example headers cannot be sent anymore.

A simple precaution is to leave off the closing tag as it is not required, and it also has no negative effects whatsoever.

Loading history...
40 

            


            
                                                        
            
                                    
            
            

                
                    41