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` ;
|
