Skip to content

Instantly share code, notes, and snippets.

@mercuryrain

mercuryrain/2791.sh

Created February 28, 2012 11:39
Show Gist options
  • Save mercuryrain/1932067 to your computer and use it in GitHub Desktop.
Save mercuryrain/1932067 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
2791.sh
cd ~/Projects/sandiego/frontends/scripts
mysql -uroot -p12plok reporting_development<<EOFMYSQL
TRUNCATE TABLE reporting_tool_values;
EOFMYSQL
mysql -uroot -p12plok roswell_development<<EOFMYSQL
TRUNCATE vacatures;
EOFMYSQL
php add-demo-vacatures.php 1 10
mysql -uroot -p12plok roswell_development<<EOFMYSQL
UPDATE vacatures SET
created_datetime = DATE_ADD(created_datetime, INTERVAL -1 DAY ) ,
vs_createddate = DATE_ADD(vs_createddate, INTERVAL -1 DAY ) ,
vs_startdate = DATE_ADD(vs_startdate, INTERVAL -1 DAY ) ,
updated_datetime = DATE_ADD(updated_datetime, INTERVAL -1 DAY ) ;
EOFMYSQL
cd ~/Projects/sandiego
php ~/Projects/sandiego/platform/scripts/cron/reporting/reporting_tool.php
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment