[Webnotes-cvs] webnotes/sql db_upgrade.sql,1.5,1.6

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

Update of /cvsroot/webnotes/webnotes/sql
In directory usw-pr-cvs1:/tmp/cvs-serv28006/sql

Modified Files:
	db_upgrade.sql 
Log Message:
- Fixed the border in the submit form
- Removed the menu from the preview page.
- Added a spacer in the preview page.
- Fixed the alignment in the login / submit forms.
- Removed the last updated from the preview.
- Fixed the formatting of the note submit timestamp
- Added the last updated timestamp for the page to the database.
- Implemented the code to update/view the page last updated timestamp.

Index: db_upgrade.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_upgrade.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- db_upgrade.sql	19 Sep 2002 22:50:39 -0000	1.5
+++ db_upgrade.sql	22 Sep 2002 02:47:16 -0000	1.6
@@ -1,5 +1,6 @@
 ALTER TABLE `phpWN_user_table` CHANGE `password` `password` VARCHAR( 32 ) NOT NULL;
 ALTER TABLE `phpWN_user_table` CHANGE `access_level` `access_level` INT( 2 ) DEFAULT '40' NOT NULL;
 ALTER TABLE `phpWN_page_table` ADD `url` VARCHAR( 255 ) NOT NULL ;
-ALTER TABLE `phpWN_page_table` ADD `prev_id` INT( 10 ) UNSIGNEDZEROFILL NOT NULL ;
-ALTER TABLE `phpWN_page_table` ADD `next_id` INT( 10 ) UNSIGNEDZEROFILL NOT NULL ;
+ALTER TABLE `phpWN_page_table` ADD `prev_id` INT( 10 ) UNSIGNED ZEROFILL NOT NULL ;
+ALTER TABLE `phpWN_page_table` ADD `next_id` INT( 10 ) UNSIGNED ZEROFILL NOT NULL ;
+ALTER TABLE `phpWN_page_table` ADD `last_updated` DATETIME NOT NULL AFTER `date_indexed` ;
\ No newline at end of file