Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 0771f369

Přidáno uživatelem Lukas Cerny před téměř 6 roky(ů)

Fixed init script

Zobrazit rozdíly:

server/init.sql
124 124 
  DECLARE notification DATETIME;
125 125 

  		




  126
  126
  
    
  SELECT no_sick_days, alert INTO sickDaysCount, notification FROM default_settings ORDER BY id DESC LIMIT 1;


  		




  127
  
  
    
  SELECT EU.id, EU.first_name, EU.last_name, EU.no_vacation, IFNULL(EU.no_sick_days, sickDaysCount), EU.taken_vacations, EU.taken_sick_days, IFNULL(EU.alert, notification), EU.email, EU.photo, EU.creation_date, R.name, APS.name


  		




  
  127
  
    
  SELECT EU.id, EU.first_name, EU.last_name, EU.no_vacations, IFNULL(EU.no_sick_days, sickDaysCount), EU.taken_vacations, EU.taken_sick_days, IFNULL(EU.alert, notification), EU.email, EU.photo, EU.creation_date, R.name, APS.name


  		




  128
  128
  
    
     INTO out_id, out_first_name, out_last_name, out_no_vacations, out_no_sick_days, out_taken_vacations, out_taken_sick_days, out_alert, out_email, out_photo, out_creation_date, out_role, out_status


  		




  129
  129
  
    
     FROM end_user EU


  		




  130
  130
  
    
     INNER JOIN role R ON EU.role_id=R.id


  		




  ......




  153
  153
  
    
  DECLARE notification DATETIME;


  		




  154
  154
  
    

  		




  155
  155
  
    
  SELECT no_sick_days, alert INTO sickDaysCount, notification FROM default_settings ORDER BY id DESC LIMIT 1;


  		




  156
  
  
    
  SELECT EU.id, EU.first_name, EU.last_name, EU.no_vacation, IFNULL(EU.no_sick_days, sickDaysCount), EU.taken_vacations, EU.taken_sick_days, IFNULL(EU.alert, notification), EU.email, EU.photo, EU.creation_date, R.name, APS.name


  		




  
  156
  
    
  SELECT EU.id, EU.first_name, EU.last_name, EU.no_vacations, IFNULL(EU.no_sick_days, sickDaysCount), EU.taken_vacations, EU.taken_sick_days, IFNULL(EU.alert, notification), EU.email, EU.photo, EU.creation_date, R.name, APS.name


  		




  157
  157
  
    
     INTO out_id, out_first_name, out_last_name, out_no_vacations, out_no_sick_days, out_taken_vacations, out_taken_sick_days, out_alert, out_email, out_photo, out_creation_date, out_role, out_status


  		




  158
  158
  
    
     FROM end_user EU


  		




  159
  159
  
    
     INNER JOIN role R ON EU.role_id=R.id


  		












Také k dispozici:  Unified diff