apply-sql-patch

   1 #!/bin/sh
   2
   3 # applies SQL patch to a database and inserts a revision control entry in the
   4 # database.
   5
   6 patch=$1
   7 db=markkit
   8 db_user=root
   9
  10 ctrl_patch_query="insert into ctrl_patch values ('', '$patch')"
  11
  12 cat $patch
  13 mysql -u $db_user $db < $patch
  14 echo $ctrl_patch_query
  15 echo $ctrl_patch_query | mysql -u $db_user $db