Update of /cvsroot/webnotes/webnotes/sql
In directory usw-pr-cvs1:/tmp/cvs-serv26969/sql
Modified Files:
db_upgrade.sql
Log Message:
- Added prev_id and next_id to the pages table.
- Handled prev/next from theme
- Auto setting prev/next if specific in the call to webnotes.
- Added XHTML example, to demonstrate the prev / prev-next / next.
There is still a problem with pages that have no notes.
Index: db_upgrade.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_upgrade.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- db_upgrade.sql 19 Sep 2002 21:51:02 -0000 1.4
+++ db_upgrade.sql 19 Sep 2002 22:50:39 -0000 1.5
@@ -1,3 +1,5 @@
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 ;
|
