[phpwebapp-commits] CVS: web_app/boxes/webnotes/db webnotes.sql,NONE,1.1 dump.sh,NONE,1.1

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

Update of /cvsroot/phpwebapp/web_app/boxes/webnotes/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1019/boxes/webnotes/db

Added Files:
	webnotes.sql dump.sh 
Log Message:
The webbox 'webnotes' can be used to append comments or notes
to documentation pages or to other web pages.


--- NEW FILE: webnotes.sql ---
-- MySQL dump 8.23
--
-- Host: localhost    Database: webnotes
---------------------------------------------------------
-- Server version	3.23.58

--
-- Current Database: webnotes
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ webnotes;

USE webnotes;

--
-- Table structure for table `webnotes`
--

CREATE TABLE webnotes (
  note_id int(10) unsigned NOT NULL auto_increment,
  page_id varchar(255) NOT NULL default '',
  email varchar(100) default '',
  ip varchar(100) default '',
  date_modified datetime default '0000-00-00 00:00:00',
  status varchar(100) default '',
  note_text text,
  PRIMARY KEY  (note_id)
) TYPE=MyISAM;


--- NEW FILE: dump.sh ---
#!/bin/bash

### modify them as appropriate
host=localhost
user=inima
dbname=webnotes

### dump the database $dbname into the file webnotes_backup.sql
mysqldump --add-drop-table --allow-keyword \
          --complete-insert --extended-insert \
          --compress --host=$host --user=$user -p \
          --result-file=webnotes_backup.sql --databases $dbname

### dump the structure of the database as well
mysqldump --allow-keyword --no-data \
          --host=$host --user=$user -p \
          --result-file=webnotes.sql --databases $dbname

### create the database with the command: 
### $ mysql -p -u $user < webnotes.sql
###
### restore the database with the command: 
### $ mysql -p -u $user < webnotes_backup.sql