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

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

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

Modified Files:
	db_upgrade.sql 
Log Message:
- Fixed a problem with page_update_neighbours, where neighbours were only
  updated if both prev/next are changed, rather than if only one changed.
- Added parent_id field to the page table in the database.
- Update neighbours currently defaults the prev/next/parent to the database
  value if null is passed, rather than replacing it with 0.  Any empty string
  should be used to highlight the fact that there is no prev/next/parent.  Or if
  it was never set, then null would work.
- Dropped a redundant index (id) in the pages table.
- Dropped a redundant index (id) in the notes table.
- Removed an extra </table> in case of pages without notes (phpnet theme).
- Implemented the first version of the php-like manual and added the necessary.


Index: db_upgrade.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_upgrade.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- db_upgrade.sql	22 Sep 2002 02:47:16 -0000	1.6
+++ db_upgrade.sql	1 Oct 2002 06:51:45 -0000	1.7
@@ -3,4 +3,8 @@
 ALTER TABLE `phpWN_page_table` ADD `url` VARCHAR( 255 ) 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
+ALTER TABLE `phpWN_page_table` ADD `last_updated` DATETIME NOT NULL AFTER `date_indexed` ;
+ALTER TABLE `phpWN_page_table` ADD `parent_id` INT( 10 ) UNSIGNED ZEROFILL NOT NULL AFTER `url` ;
+ALTER TABLE `phpWN_page_table` ADD INDEX ( `parent_id` ) ;
+ALTER TABLE `phpWN_page_table` DROP INDEX `id` ;
+ALTER TABLE `phpWN_note_table` DROP INDEX `id` ;