[Webnotes-cvs] webnotes/sql db_upgrade.sql,1.9,1.10

[<vb...@us...>]

Update of /cvsroot/webnotes/webnotes/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv22181/sql

Modified Files:
	db_upgrade.sql 
Log Message:
- Added the "visits" field to the pages table.
- Added support for tracking the page visits.
- Display the page visits in the manage notes page.

Index: db_upgrade.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_upgrade.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- db_upgrade.sql	7 Oct 2002 02:54:39 -0000	1.9
+++ db_upgrade.sql	20 Aug 2003 08:46:36 -0000	1.10
@@ -16,3 +16,4 @@
 # Upgrade 2.0.0pr1 to latest
 #
 ALTER TABLE `phpwn_user_table` ADD `protected` INT( 1 ) DEFAULT '0' NOT NULL AFTER `enabled` ;
+ALTER TABLE `phpWN_page_table` ADD `visits` INT(10) NOT NULL;