Projet

Général

Profil

Télécharger (339 octets)

US #884 » script_signUp.sql

Anonyme, 30/01/2025 17:35

 
1 
use socle ;
2 

    		
  

  

    
      3
    
    
      
ALTER TABLE company 


    		
  

  

    
      4
    
    
      
CHANGE COLUMN SIRET taxRegistration VARCHAR(255) NULL,


    		
  

  

    
      5
    
    
      
ADD COLUMN subSectorCode VARCHAR(255) NULL,


    		
  

  

    
      6
    
    
      
ADD CONSTRAINT fk_subSector FOREIGN KEY (subSectorCode) 


    		
  

  

    
      7
    
    
      
REFERENCES solution_setting_sub_sector(code) 


    		
  

  

    
      8
    
    
      
ON DELETE CASCADE ON UPDATE CASCADE;


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      
ALTER TABLE company_users 


    		
  

  

    
      11
    
    
      
ADD COLUMN  poste VARCHAR(255) NULL;


    		
  

  

    
      12
    
    
      

    		
  












  (4-4/4)