Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030401.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030401.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030401.sql	25 Feb 2010 23:28:53 -0000	1.1.2.1
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030401.sql	26 Feb 2010 21:23:54 -0000	1.1.2.2
@@ -15,6 +15,18 @@
    , PRIMARY KEY (user_id,learning_design_id)
 )TYPE=InnoDB;
 
+CREATE TABLE lams_planner_node_role (
+       uid BIGINT(20) NOT NULL AUTO_INCREMENT
+     , node_uid BIGINT(20) NOT NULL
+     , user_id BIGINT(20) NOT NULL
+     , role_id INT(6) NOT NULL
+     , PRIMARY KEY (uid)
+     , UNIQUE KEY (node_uid, user_id, role_id)
+     , CONSTRAINT FK_planner_node_role_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE NO ACTION
+     , CONSTRAINT FK_planner_node_role_node FOREIGN KEY (node_uid) REFERENCES lams_planner_nodes (uid) ON DELETE CASCADE ON UPDATE NO ACTION
+     , CONSTRAINT FK_planner_node_role_role FOREIGN KEY (role_id) REFERENCES lams_role (role_id) ON DELETE CASCADE ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
 update lams_configuration set config_value='2.3.4' where config_key='Version';
 update lams_configuration set config_value='2.3.4.201002190000' where config_key='LearnerClientVersion' OR config_key='ServerVersionNumber' OR config_key='MonitorClientVersion' OR config_key='AuthoringClientVersion';
 update lams_configuration set config_value='2010-02-19' where config_key='DictionaryDateCreated';