[phpwebapp-commits] CVS: top10/db init_db.sh,1.1,1.1.2.1 top10_tables.sql,1.1,1.1.2.1 update_db.sh,1.1,1.1.2.1

[Dashamir H. <das...@us...>]

Update of /cvsroot/phpwebapp/top10/db
In directory sc8-pr-cvs1:/tmp/cvs-serv21756/db

Modified Files:
      Tag: maisp
	init_db.sh top10_tables.sql update_db.sh 
Log Message:


Index: init_db.sh
===================================================================
RCS file: /cvsroot/phpwebapp/top10/db/init_db.sh,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -C2 -d -r1.1 -r1.1.2.1
*** init_db.sh	5 Jan 2004 14:38:31 -0000	1.1
--- init_db.sh	6 Jan 2004 15:22:42 -0000	1.1.2.1
***************
*** 10,15 ****
  echo ""
  echo "Inserting some sample data:"
! echo "$ mysql -u $username -p top10_db < top10_data.sql"
! mysql -u $username -p top10_db < top10_data.sql
  
  echo ""
--- 10,15 ----
  echo ""
  echo "Inserting some sample data:"
! echo "$ mysql -u $username -p inima_top10 < top10_data.sql"
! mysql -u $username -p inima_top10 < top10_data.sql
  
  echo ""

Index: top10_tables.sql
===================================================================
RCS file: /cvsroot/phpwebapp/top10/db/top10_tables.sql,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -C2 -d -r1.1 -r1.1.2.1
*** top10_tables.sql	5 Jan 2004 14:38:31 -0000	1.1
--- top10_tables.sql	6 Jan 2004 15:22:42 -0000	1.1.2.1
***************
*** 4,12 ****
  
  --
! -- Create the database top10_db
  --
  
! CREATE DATABASE IF NOT EXISTS top10_db;
! USE top10_db;
  
  --
--- 4,12 ----
  
  --
! -- Create the database inima_top10
  --
  
! CREATE DATABASE IF NOT EXISTS inima_top10;
! USE inima_top10;
  
  --

Index: update_db.sh
===================================================================
RCS file: /cvsroot/phpwebapp/top10/db/update_db.sh,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -C2 -d -r1.1 -r1.1.2.1
*** update_db.sh	5 Jan 2004 14:38:31 -0000	1.1
--- update_db.sh	6 Jan 2004 15:22:42 -0000	1.1.2.1
***************
*** 3,5 ****
  # This script must be executed periodically at least once a day
  
! mysql --user='root' --password='' top10_db < update_db.sql
--- 3,5 ----
  # This script must be executed periodically at least once a day
  
! mysql --user='root' --password='' inima_top10 < update_db.sql