Project

General

Profile

« Previous | Next » 

Revision 309

Added by stefan almost 19 years ago

Added default value '' to all varchar and text fields

View differences:

install.php
36 36 
	                 . ' `section_id` INT NOT NULL ,'
37 37 
	                 . ' `page_id` INT NOT NULL ,'
38 38 
	                 . ' `position` INT NOT NULL ,'
39 
	                 . ' `title` VARCHAR(255) NOT NULL ,'
40 
	                 . ' `type` VARCHAR(255) NOT NULL ,'
39 
	                 . ' `title` VARCHAR(255) NOT NULL DEFAULT \'\' ,'
40 
	                 . ' `type` VARCHAR(255) NOT NULL DEFAULT \'\' ,'
41 41 
	                 . ' `required` INT NOT NULL ,'
42 
	                 . ' `value` TEXT NOT NULL ,'
43 
	                 . ' `extra` TEXT NOT NULL ,'
42 
	                 . ' `value` TEXT NOT NULL DEFAULT \'\' ,'
43 
	                 . ' `extra` TEXT NOT NULL DEFAULT \'\' ,'
44 44 
	                 . ' PRIMARY KEY ( `field_id` ) )'
45 45 
	                 . ' ';
46 46 
	$database->query($mod_form);
......
48 48 
	$mod_form = 'CREATE TABLE `'.TABLE_PREFIX.'mod_form_settings` ('
49 49 
						  . ' `section_id` INT NOT NULL,'
50 50 
						  . ' `page_id` INT NOT NULL,'
51 
	                 . ' `header` TEXT NOT NULL ,'
52 
	                 . ' `field_loop` TEXT NOT NULL ,'
53 
	                 . ' `footer` TEXT NOT NULL ,'
54 
	                 . ' `email_to` TEXT NOT NULL ,'
55 
	                 . ' `email_from` VARCHAR(255) NOT NULL ,'
56 
	                 . ' `email_subject` VARCHAR(255) NOT NULL ,'
57 
	                 . ' `success_message` TEXT NOT NULL ,'
51 
	                 . ' `header` TEXT NOT NULL DEFAULT \'\' ,'
52 
	                 . ' `field_loop` TEXT NOT NULL DEFAULT \'\' ,'
53 
	                 . ' `footer` TEXT NOT NULL DEFAULT \'\' ,'
54 
	                 . ' `email_to` TEXT NOT NULL DEFAULT \'\' ,'
55 
	                 . ' `email_from` VARCHAR(255) NOT NULL DEFAULT \'\' ,'
56 
	                 . ' `email_subject` VARCHAR(255) NOT NULL DEFAULT \'\' ,'
57 
	                 . ' `success_message` TEXT NOT NULL DEFAULT \'\' ,'
58 58 
					 . ' `stored_submissions` INT NOT NULL,'
59 59 
					 . ' `max_submissions` INT NOT NULL,'
60 60 
					 . ' `use_captcha` INT NOT NULL,'
......
67 67 
						  . ' `page_id` INT NOT NULL,'
68 68 
						  . ' `submitted_when` INT NOT NULL,'
69 69 
						  . ' `submitted_by` INT NOT NULL,'
70 
	                 . ' `body` TEXT NOT NULL ,'
70 
	                 . ' `body` TEXT NOT NULL DEFAULT \'\' ,'
71 71 
	                 . ' PRIMARY KEY ( `submission_id` ) )'
72 72 
	                 . ' ';
73 73 
	$database->query($mod_form);
......
101 101 

  		




  102
  102
  
    
}


  		




  103
  103
  
    

  		




  104
  
  
    
?>


  		




  
  104
  
    
?>


  		












Also available in:  Unified diff