Mauro Artizzu mauroartizzu

## Mysql created_at updated_at triggers
ALTER TABLE xxxxxx
ADD created_at TIMESTAMP DEFAULT '0000-00-00 00:00:00',
ADD updated_at TIMESTAMP DEFAULT '0000-00-00 00:00:00';
CREATE TRIGGER xxxxxx_create BEFORE INSERT ON `xxxxxx`
FOR EACH ROW SET NEW.created_at = NOW(), NEW.updated_at = NOW();
CREATE TRIGGER xxxxxx_update BEFORE UPDATE ON `xxxxxx`
FOR EACH ROW SET NEW.updated_at = NOW(), NEW.created_at = OLD.created_at;

## gist:4648542

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                mauroartizzu
                / gist:4648542
            
            
              Created
              January 27, 2013 14:22
            
          
        
      
        
  
      
    #Mac OS X
Preferences

#Disable window animations
sudo defaults write NSGlobalDomain NSAutomaticWindowAnimationsEnabled -bool false

#Enable repeat on keydown
sudo defaults write -g ApplePressAndHoldEnabled -bool false
	ALTER TABLE xxxxxx
	ADD created_at TIMESTAMP DEFAULT '0000-00-00 00:00:00',
	ADD updated_at TIMESTAMP DEFAULT '0000-00-00 00:00:00';
	CREATE TRIGGER xxxxxx_create BEFORE INSERT ON `xxxxxx`
	FOR EACH ROW SET NEW.created_at = NOW(), NEW.updated_at = NOW();
	CREATE TRIGGER xxxxxx_update BEFORE UPDATE ON `xxxxxx`
	FOR EACH ROW SET NEW.updated_at = NOW(), NEW.created_at = OLD.created_at;