[Opda-develop] OPDA/db 2006-07-23_mod.sql,NONE,1.1

[Alex N. <dig...@us...>]

Update of /cvsroot/opda/OPDA/db
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv7603/db

Added Files:
	2006-07-23_mod.sql 
Log Message:
changed subscription_list table to be acts as nested set


--- NEW FILE: 2006-07-23_mod.sql ---
ALTER TABLE `subscription_lists` ADD `root_id` INT NOT NULL DEFAULT '0' AFTER `parent_id` ,
ADD `lft` INT NOT NULL DEFAULT '0' AFTER `root_id` ,
ADD `rgt` INT NOT NULL DEFAULT '0' AFTER `lft` ,
ADD `depth` INT NOT NULL DEFAULT '0' AFTER `rgt` ;