Revision 15:5e82fb01dfb3 notes.txt

b/notes.txt
9 9 

  		





  10
  10
  
    
Connection:


  		





  11
  11
  
    

  		





  12
  
  
    
/usr/local/mysql/bin/mysql --host=ccenoc.in2p3.fr --user=UTH_GR_2 --password=MOhnrreHCo0ka1sj


  		





  
  12
  
    
/usr/local/mysql/bin/mysql --host=ccenoc.in2p3.fr --user=UTH_GR_2 TTdb


  		





  
  13
  
    
--password=MOhnrreHCo0ka1sj


  		





  13
  14
  
    

  		





  14
  15
  
    
Transfer data to local store:


  		





  15
  16
  
    

  		





  ......




  57
  58
  
    

  		





  58
  59
  
    
alter table ttstd change TT_STATUS TT_STATUS varchar(255);


  		





  59
  60
  
    

  		





  60
  
  
    
alter table ttstd add UN_ID VARCHAR(255);


  		





  
  61
  
    
alter table ttstd add UNNORMALISED_ID VARCHAR(255);


  		





  
  62
  
    

  		





  
  63
  
    
alter table ttstd change ENOC_DATETIME_STORED ENOC_DATETIME_STORED timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;


  		





  61
  64
  
    

  		





  62
  65
  
    
* TT templates


  		





  63
  66
  
    

  		












Also available in:
  Unified diff