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
|