User: cmicali Date: 06/08/28 21:01:20 Modified: documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain TaskDaoImpl.cs TimeAllocationDaoImpl.cs TimecardDaoImpl.cs documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Service MembershipServiceImpl.cs documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web ApproveTimecards.aspx Home.aspx NewTimecardSetup.aspx SearchTimecards.aspx TimecardDetails.aspx documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/mda/src/uml Northwind.TimeTracker.Model.xmi Added: documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database build-db.bat static-data-delete.sql static-data-insert.sql test-data-delete.sql test-data-insert.sql Removed: documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database TestData.sql Log: - Database build scripts - Fixed spelling errors Revision Changes Path 1.2 +17 -4 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TaskDaoImpl.cs Index: TaskDaoImpl.cs =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TaskDaoImpl.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- TaskDaoImpl.cs 28 Aug 2006 04:22:17 -0000 1.1 +++ TaskDaoImpl.cs 29 Aug 2006 04:01:18 -0000 1.2 @@ -20,8 +20,15 @@ /// </summary> public override Northwind.TimeTracker.VO.TaskVO ToTaskVO(Northwind.TimeTracker.Domain.Task entity) { - // put your implementation here - return null; + // Entity to VO conversion + + Northwind.TimeTracker.VO.TaskVO valueObject = new Northwind.TimeTracker.VO.TaskVO(); + + valueObject.Id = entity.Id; + valueObject.Name = entity.Name; + + return valueObject; + } /// <summary> @@ -29,8 +36,14 @@ /// </summary> public override Northwind.TimeTracker.Domain.Task TaskVOToEntity(Northwind.TimeTracker.VO.TaskVO taskVO) { - // put your implementation here - return null; + // VO to entity conversion + Northwind.TimeTracker.Domain.Task entity = Northwind.TimeTracker.Domain.Task.Factory.newInstance(); + + entity.Id = taskVO.Id; + entity.Name = taskVO.Name; + + return entity; + } } 1.2 +10 -2 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TimeAllocationDaoImpl.cs Index: TimeAllocationDaoImpl.cs =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TimeAllocationDaoImpl.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- TimeAllocationDaoImpl.cs 28 Aug 2006 04:22:17 -0000 1.1 +++ TimeAllocationDaoImpl.cs 29 Aug 2006 04:01:18 -0000 1.2 @@ -20,8 +20,16 @@ /// </summary> public override Northwind.TimeTracker.VO.TimeAllocationVO ToTimeAllocationVO(Northwind.TimeTracker.Domain.TimeAllocation entity) { - // put your implementation here - return null; + // Entity to VO conversion + + Northwind.TimeTracker.VO.TimeAllocationVO valueObject = new Northwind.TimeTracker.VO.TimeAllocationVO(); + + valueObject.Id = entity.Id; + valueObject.TaskId = entity.Task.Id; + // valueObject.TimePeriodVO + + return valueObject; + } /// <summary> 1.2 +12 -2 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TimecardDaoImpl.cs Index: TimecardDaoImpl.cs =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Domain/TimecardDaoImpl.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- TimecardDaoImpl.cs 28 Aug 2006 04:22:17 -0000 1.1 +++ TimecardDaoImpl.cs 29 Aug 2006 04:01:18 -0000 1.2 @@ -62,9 +62,19 @@ valueObject.Id = entity.Id; valueObject.StartDate = entity.StartDate; valueObject.Status = entity.Status; + valueObject.ApproverName = string.Empty; + valueObject.SubmitterName = string.Empty; + try + { valueObject.ApproverName = entity.Approver.FirstName + " " + entity.Approver.LastName; + } + catch { } + try + { valueObject.SubmitterName = entity.Submitter.FirstName + " " + entity.Submitter.LastName; } + catch { } + } /// <summary> /// @see Northwind.TimeTracker.Domain.ITimecardDao#ToTimecardVO(Northwind.TimeTracker.Domain.Timecard) 1.2 +10 -10 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Service/MembershipServiceImpl.cs Index: MembershipServiceImpl.cs =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Core/src/Northwind/TimeTracker/Service/MembershipServiceImpl.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- MembershipServiceImpl.cs 28 Aug 2006 04:22:18 -0000 1.1 +++ MembershipServiceImpl.cs 29 Aug 2006 04:01:18 -0000 1.2 @@ -38,7 +38,7 @@ protected override string HandleGetUserNameByEmail(string email) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("SELECT user.UserName FROM UserImpl user WHERE user.Email = :email"); + IQuery query = session.CreateQuery("SELECT user.Username FROM UserImpl user WHERE user.Email = :email"); query.SetParameter("email", email); return (string)query.UniqueResult(); } @@ -49,7 +49,7 @@ protected override long HandleGetUserIdByUsername(string username) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("SELECT user.Id FROM UserImpl user WHERE user.UserName = :username"); + IQuery query = session.CreateQuery("SELECT user.Id FROM UserImpl user WHERE user.Username = :username"); query.SetParameter("username", username); return (long)query.UniqueResult(); } @@ -60,7 +60,7 @@ protected override UserVO HandleGetUser(String username) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.UserName = :username"); + IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.Username = :username"); query.SetParameter("username", username); IList users = query.List(); if (users.Count == 1) @@ -168,7 +168,7 @@ protected override bool HandleUpdatePassword(string username, string oldPassword, string newPassword) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.UserName = :username AND user.Password = :password"); + IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.Username = :username AND user.Password = :password"); query.SetParameter("username", username); query.SetParameter("password", oldPassword); IList users = query.List(); @@ -208,7 +208,7 @@ protected override System.Collections.IList HandleFindUsersByName(String usernameToMatch, int pageIndex, int pageSize) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.UserName LIKE :username"); + IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.Username LIKE :username"); query.SetParameter("username", usernameToMatch); return this.UserDao.ToUserVOList(query.List()); } @@ -219,7 +219,7 @@ protected override UserVO HandleValidateUser(String username, String password) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.UserName = :username AND user.Password = :password"); + IQuery query = session.CreateQuery("FROM UserImpl user WHERE user.Username = :username AND user.Password = :password"); query.SetParameter("username", username); query.SetParameter("password", password); IList users = query.List(); @@ -260,7 +260,7 @@ protected override Role[] HandleGetRolesForUser(string username) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("FROM UserRoleImpl role WHERE role.User.UserName = :username"); + IQuery query = session.CreateQuery("FROM UserRoleImpl role WHERE role.User.Username = :username"); query.SetParameter("username", username); IList results = query.List(); Role[] roles = new Role[results.Count]; @@ -277,7 +277,7 @@ protected override string[] HandleGetUsernamesInRole(Role role) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("SELECT role.User.UserName FROM UserRoleImpl role WHERE role.Role = :roletype"); + IQuery query = session.CreateQuery("SELECT role.User.Username FROM UserRoleImpl role WHERE role.Role = :roletype"); query.SetParameter("roletype", (int)role); IList usernameList = query.List(); Array usernames = Array.CreateInstance(typeof(string), usernameList.Count); @@ -291,7 +291,7 @@ protected override string[] HandleFindUsernamesInRole(Role role, string usernameToMatch) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("SELECT role.User.UserName FROM UserRoleImpl role WHERE role.Role = :roletype AND role.User.UserName LIKE :usernameToMatch"); + IQuery query = session.CreateQuery("SELECT role.User.Username FROM UserRoleImpl role WHERE role.Role = :roletype AND role.User.Username LIKE :usernameToMatch"); query.SetParameter("roletype", (int)role); query.SetParameter("usernameToMatch", usernameToMatch); IList usernameList = query.List(); @@ -321,7 +321,7 @@ protected override bool HandleIsUserInRole(string username, Role role) { ISession session = SessionManagerFactory.SessionManager.Session; - IQuery query = session.CreateQuery("SELECT role.Id FROM UserRoleImpl role WHERE role.User.UserName = :username AND role.Role = :roletype"); + IQuery query = session.CreateQuery("SELECT role.Id FROM UserRoleImpl role WHERE role.User.Username = :username AND role.Role = :roletype"); query.SetParameter("username", username); query.SetParameter("roletype", (int)role); IList roles = query.List(); 1.2 +19 -1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/ApproveTimecards.aspx Index: ApproveTimecards.aspx =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/ApproveTimecards.aspx,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- ApproveTimecards.aspx 28 Aug 2006 04:22:20 -0000 1.1 +++ ApproveTimecards.aspx 29 Aug 2006 04:01:18 -0000 1.2 @@ -1,4 +1,22 @@ -<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="ApproveTimecards.aspx.cs" Inherits="ApproveTimecards" Title="Untitled Page" %> +<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="ApproveTimecards.aspx.cs" Inherits="ApproveTimecards" Title="Approve Timecards" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> + + <div class="menubar"> + <ul> + <li class="first"> + <a href="Home.aspx">Home</a> + </li> + <li> + <a href="TimecardDetails.aspx">Timecard Details</a> + </li> + <li> + <a href="SearchTimecards.aspx">Search Timecards</a> + </li> + <li> + <a class="selected" href="ApproveTimecards.aspx">Approve Timecards</a> + </li> + </ul> + </div> + </asp:Content> 1.3 +3 -3 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/Home.aspx Index: Home.aspx =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/Home.aspx,v retrieving revision 1.2 retrieving revision 1.3 diff -u -w -r1.2 -r1.3 --- Home.aspx 29 Aug 2006 02:39:34 -0000 1.2 +++ Home.aspx 29 Aug 2006 04:01:18 -0000 1.3 @@ -1,10 +1,10 @@ -<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="Home.aspx.cs" Inherits="Home" Title="Untitled Page" %> +<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="Home.aspx.cs" Inherits="Home" Title="Home" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <div class="menubar"> <ul> <li class="first"><a class="selected" href="Home.aspx">Home</a></li> - <li><a href="EditTimecard.aspx">Timecard Details</a></li> + <li><a href="TimecardDetails.aspx">Timecard Details</a></li> <li><a href="SearchTimecards.aspx">Search Timecards</a></li> <li><a href="ApproveTimecards.aspx">Approve Timecards</a></li> </ul> @@ -22,7 +22,7 @@ <td><a href="NewTimecardSetup.aspx">New timecard</a></td> </tr> <tr> - <td><a href="timecard.html">Last saved timecard</a></td> + <td><a href="TimecardDetails.aspx">Last saved timecard</a></td> </tr> <tr> <td><a href="SearchTimecards.aspx">Search timecards</a></td> 1.2 +9 -0 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/NewTimecardSetup.aspx Index: NewTimecardSetup.aspx =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/NewTimecardSetup.aspx,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- NewTimecardSetup.aspx 28 Aug 2006 04:22:21 -0000 1.1 +++ NewTimecardSetup.aspx 29 Aug 2006 04:01:18 -0000 1.2 @@ -1,6 +1,15 @@ <%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="NewTimecardSetup.aspx.cs" Inherits="NewTimecardSetup" Title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> + <div class="menubar"> + <ul> + <li><a class="selected" href="Home.aspx">Home</a></li> + <li class="first"><a href="TimecardDetails.aspx">Timecard Details</a></li> + <li><a href="SearchTimecards.aspx">Search Timecards</a></li> + <li><a href="ApproveTimecards.aspx">Approve Timecards</a></li> + </ul> + </div> + <div class="content"> <h2>New Timecard Setup</h2> 1.3 +2 -2 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/SearchTimecards.aspx Index: SearchTimecards.aspx =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/SearchTimecards.aspx,v retrieving revision 1.2 retrieving revision 1.3 diff -u -w -r1.2 -r1.3 --- SearchTimecards.aspx 29 Aug 2006 02:39:34 -0000 1.2 +++ SearchTimecards.aspx 29 Aug 2006 04:01:18 -0000 1.3 @@ -1,4 +1,4 @@ -<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="SearchTimecards.aspx.cs" Inherits="SearchTimecards" Title="Untitled Page" %> +<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="SearchTimecards.aspx.cs" Inherits="SearchTimecards" Title="Search Timecards" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:ObjectDataSource @@ -93,7 +93,7 @@ <td><%# Eval("SubmitterName") %></td> <td><%# Eval("ApproverName") %></td> <td><%# Eval("Status") %></td> - <td><%# Eval("StartDate") %></td> + <td><%# ((DateTime)Eval("StartDate")).ToString("d") %></td> <td><a href="EditTimecard.aspx?Id=<%# Eval("Id") %>">Details</a></td> </tr> </ItemTemplate> 1.2 +19 -1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/TimecardDetails.aspx Index: TimecardDetails.aspx =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Northwind.TimeTracker.Web/TimecardDetails.aspx,v retrieving revision 1.1 retrieving revision 1.2 diff -u -w -r1.1 -r1.2 --- TimecardDetails.aspx 29 Aug 2006 02:39:34 -0000 1.1 +++ TimecardDetails.aspx 29 Aug 2006 04:01:18 -0000 1.2 @@ -1,4 +1,22 @@ -<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="TimecardDetails.aspx.cs" Inherits="TimecardDetails" Title="Untitled Page" %> +<%@ Page Language="C#" MasterPageFile="~/Layout/Default.master" AutoEventWireup="true" CodeFile="TimecardDetails.aspx.cs" Inherits="TimecardDetails" Title="Timecard Details" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> + + <div class="menubar"> + <ul> + <li class="first"> + <a href="Home.aspx">Home</a> + </li> + <li> + <a class="selected" href="TimecardDetails.aspx">Timecard Details</a> + </li> + <li> + <a href="SearchTimecards.aspx">Search Timecards</a> + </li> + <li> + <a href="ApproveTimecards.aspx">Approve Timecards</a> + </li> + </ul> + </div> + </asp:Content> 1.3 +59 -45 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/mda/src/uml/Northwind.TimeTracker.Model.xmi Index: Northwind.TimeTracker.Model.xmi =================================================================== RCS file: /cvsroot/andromdaplugins/plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/mda/src/uml/Northwind.TimeTracker.Model.xmi,v retrieving revision 1.2 retrieving revision 1.3 diff -u -w -r1.2 -r1.3 --- Northwind.TimeTracker.Model.xmi 29 Aug 2006 02:39:37 -0000 1.2 +++ Northwind.TimeTracker.Model.xmi 29 Aug 2006 04:01:19 -0000 1.3 @@ -3,7 +3,7 @@ <!-- This xmi file is optimized for MagicDraw UML. Some references are not saved. --> <!-- Change MagicDraw UML environment options property General->.Save Rich XMI --> -<XMI xmi.version='1.2' timestamp='Mon Aug 28 12:33:29 EDT 2006' xmlns:UML='omg.org/UML/1.4'> +<XMI xmi.version='1.2' timestamp='Mon Aug 28 23:32:25 EDT 2006' xmlns:UML='omg.org/UML/1.4'> <XMI.header> <XMI.documentation> <XMI.exporter>MagicDraw UML</XMI.exporter> @@ -827,8 +827,15 @@ </UML:StructuralFeature.type> </UML:Attribute> <UML:Attribute xmi.id='_9_5_1_874026a_1156385000753_225025_324' name='firstName' visibility='public'> + <UML:StructuralFeature.multiplicity> + <UML:Multiplicity xmi.id='_9_5_1_874026a_1156822345619_77763_350'> + <UML:Multiplicity.range> + <UML:MultiplicityRange xmi.id='_9_5_1_874026a_1156822345619_358016_351' lower='0' upper='1'/> + </UML:Multiplicity.range> + </UML:Multiplicity> + </UML:StructuralFeature.multiplicity> <UML:Attribute.initialValue> - <UML:Expression xmi.id='_9_5_1_874026a_1156736949726_423672_7'/> + <UML:Expression xmi.id='_9_5_1_874026a_1156822345619_109517_352'/> </UML:Attribute.initialValue> <UML:StructuralFeature.type> <UML:Classifier href='andromda-profile-datatype-3.2-SNAPSHOT.xml.zip|_9_0_1fe00f9_1119336925531_364079_66'> @@ -839,8 +846,15 @@ </UML:StructuralFeature.type> </UML:Attribute> <UML:Attribute xmi.id='_9_5_1_874026a_1156385004158_820166_328' name='lastName' visibility='public'> + <UML:StructuralFeature.multiplicity> + <UML:Multiplicity xmi.id='_9_5_1_874026a_1156822345619_412241_353'> + <UML:Multiplicity.range> + <UML:MultiplicityRange xmi.id='_9_5_1_874026a_1156822345619_834179_354' lower='0' upper='1'/> + </UML:Multiplicity.range> + </UML:Multiplicity> + </UML:StructuralFeature.multiplicity> <UML:Attribute.initialValue> - <UML:Expression xmi.id='_9_5_1_874026a_1156736949726_156391_8'/> + <UML:Expression xmi.id='_9_5_1_874026a_1156822345619_558280_355'/> </UML:Attribute.initialValue> <UML:StructuralFeature.type> <UML:Classifier href='andromda-profile-datatype-3.2-SNAPSHOT.xml.zip|_9_0_1fe00f9_1119336925531_364079_66'> @@ -1973,7 +1987,7 @@ <value xmi.value='false'/> </mdElement> </properties> - <geometry>30, 50, 135, 171</geometry> + <geometry>30, 50, 137, 171</geometry> </mdElement> <mdElement elementClass='ClassView' xmi.id='_9_5_1_874026a_1156380806978_363344_2866'> <elementID xmi.idref='_9_5_1_874026a_1148487426786_832415_417'/> @@ -2047,9 +2061,9 @@ <elementID xmi.idref='_9_5_1_874026a_1156376533361_245304_893'/> <zoomFactor xmi.value='1.0'/> <diagramOpened xmi.value='true'/> - <diagramWindowBounds>0, 0, 1032, 829</diagramWindowBounds> - <diagramScrollPositionX xmi.value='0'/> - <diagramScrollPositionY xmi.value='0'/> + <diagramWindowBounds>0, 0, 491, 551</diagramWindowBounds> + <diagramScrollPositionX xmi.value='470'/> + <diagramScrollPositionY xmi.value='17'/> <maximized xmi.value='true'/> <active xmi.value='true'/> <mdOwnedViews> @@ -2386,7 +2400,7 @@ <value xmi.value='false'/> </mdElement> </properties> - <geometry>500, 50, 135, 171</geometry> + <geometry>500, 50, 137, 171</geometry> </mdElement> <mdElement elementClass='AssociationView' xmi.id='_9_5_1_874026a_1156380515860_348271_1849'> <elementID xmi.idref='_9_5_1_874026a_1156380515860_372385_1848'/> @@ -2418,28 +2432,28 @@ </mdElement> <mdElement elementClass='RoleView' xmi.id='_9_5_1_874026a_1156380515860_560935_1857'> <elementID xmi.idref='_9_5_1_874026a_1156380515860_39877_1846'/> - <geometry>378, 95, 10, 10</geometry> + <geometry>378, 90, 10, 10</geometry> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_571422_1858'> <visible xmi.value='false'/> - <geometry>378, 85, 30, 15</geometry> + <geometry>378, 80, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_307142_1860'> - <geometry>383, 75, 30, 15</geometry> + <geometry>383, 70, 30, 15</geometry> <text>*</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_773999_1862'> <visible xmi.value='false'/> - <geometry>378, 85, 30, 15</geometry> + <geometry>378, 80, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156380515860_730380_1864'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>378, 105, 30, 15</geometry> + <geometry>378, 100, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_851034_1867'> <visible xmi.value='false'/> - <geometry>378, 85, 30, 15</geometry> + <geometry>378, 80, 30, 15</geometry> <text><html> <body> <p></p> @@ -2455,28 +2469,28 @@ </mdElement> <mdElement elementClass='RoleView' xmi.id='_9_5_1_874026a_1156380515860_267076_1871'> <elementID xmi.idref='_9_5_1_874026a_1156380515860_435521_1847'/> - <geometry>500, 95, 10, 10</geometry> + <geometry>490, 90, 10, 10</geometry> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_658501_1872'> - <geometry>427, 95, 60, 15</geometry> + <geometry>417, 90, 60, 15</geometry> <text>+submitter</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_695009_1874'> - <geometry>455, 75, 30, 15</geometry> + <geometry>445, 70, 30, 15</geometry> <text>1</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_713601_1876'> <visible xmi.value='false'/> - <geometry>480, 85, 30, 15</geometry> + <geometry>470, 80, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156380515860_2452_1878'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>480, 105, 30, 15</geometry> + <geometry>470, 100, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380515860_841889_1881'> <visible xmi.value='false'/> - <geometry>480, 85, 30, 15</geometry> + <geometry>470, 80, 30, 15</geometry> <text><html> <body> <p></p> @@ -2531,28 +2545,28 @@ </mdElement> <mdElement elementClass='RoleView' xmi.id='_9_5_1_874026a_1156380576797_95513_1952'> <elementID xmi.idref='_9_5_1_874026a_1156380576797_56809_1941'/> - <geometry>378, 150, 10, 10</geometry> + <geometry>378, 145, 10, 10</geometry> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_640495_1953'> <visible xmi.value='false'/> - <geometry>378, 140, 30, 15</geometry> + <geometry>378, 135, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_939152_1955'> - <geometry>383, 130, 30, 15</geometry> + <geometry>383, 125, 30, 15</geometry> <text>*</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_732895_1957'> <visible xmi.value='false'/> - <geometry>378, 140, 30, 15</geometry> + <geometry>378, 135, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156380576797_95406_1959'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>378, 160, 30, 15</geometry> + <geometry>378, 155, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_993956_1962'> <visible xmi.value='false'/> - <geometry>378, 140, 30, 15</geometry> + <geometry>378, 135, 30, 15</geometry> <text><html> <body> <p></p> @@ -2568,28 +2582,28 @@ </mdElement> <mdElement elementClass='RoleView' xmi.id='_9_5_1_874026a_1156380576797_767818_1966'> <elementID xmi.idref='_9_5_1_874026a_1156380576797_466944_1942'/> - <geometry>500, 150, 10, 10</geometry> + <geometry>490, 145, 10, 10</geometry> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_140757_1967'> - <geometry>427, 150, 56, 15</geometry> + <geometry>417, 145, 56, 15</geometry> <text>+approver</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_456737_1969'> - <geometry>455, 130, 30, 15</geometry> + <geometry>445, 125, 30, 15</geometry> <text>0..1</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_677520_1971'> <visible xmi.value='false'/> - <geometry>480, 140, 30, 15</geometry> + <geometry>470, 135, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156380576797_488299_1973'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>480, 160, 30, 15</geometry> + <geometry>470, 155, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156380576797_548544_1976'> <visible xmi.value='false'/> - <geometry>480, 140, 30, 15</geometry> + <geometry>470, 135, 30, 15</geometry> <text><html> <body> <p></p> @@ -2630,24 +2644,24 @@ <elementID xmi.idref='_9_5_1_874026a_1156737323213_714933_188'/> <linkFirstEndID xmi.idref='_9_5_1_874026a_1156380429556_397264_1795'/> <linkSecondEndID xmi.idref='_9_5_1_874026a_1156737251170_176391_155'/> - <geometry>635, 128; 780, 128; </geometry> + <geometry>637, 128; 780, 128; </geometry> <linkNameID xmi.idref='_9_5_1_874026a_1156737323223_543280_225'/> <nameVisible xmi.value='true'/> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_749467_190'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>693, 99, 30, 15</geometry> + <geometry>694, 99, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156737323223_681998_192'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>693, 141, 30, 15</geometry> + <geometry>694, 141, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_320153_195'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>335, 0, 30, 15</geometry> + <geometry>342, 0, 30, 15</geometry> <text><html> <body> <p></p> @@ -2656,28 +2670,28 @@ </mdElement> <mdElement elementClass='RoleView' xmi.id='_9_5_1_874026a_1156737323223_768361_197'> <elementID xmi.idref='_9_5_1_874026a_1156737323213_674633_186'/> - <geometry>635, 123, 10, 10</geometry> + <geometry>637, 123, 10, 10</geometry> <mdOwnedViews> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_91335_198'> - <geometry>640, 107, 33, 15</geometry> + <geometry>642, 107, 33, 15</geometry> <text>+user</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_406758_200'> - <geometry>650, 137, 30, 15</geometry> + <geometry>652, 137, 30, 15</geometry> <text>1</text> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_819992_202'> <visible xmi.value='false'/> - <geometry>635, 123, 30, 15</geometry> + <geometry>637, 123, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxWithIconView' xmi.id='_9_5_1_874026a_1156737323223_925759_204'> <editable xmi.value='false'/> <visible xmi.value='false'/> - <geometry>635, 143, 30, 15</geometry> + <geometry>637, 143, 30, 15</geometry> </mdElement> <mdElement elementClass='TextBoxView' xmi.id='_9_5_1_874026a_1156737323223_635189_207'> <visible xmi.value='false'/> - <geometry>635, 123, 30, 15</geometry> + <geometry>637, 123, 30, 15</geometry> <text><html> <body> <p></p> @@ -2729,7 +2743,7 @@ </mdElement> <mdElement elementClass='AssociationTextBoxView' xmi.id='_9_5_1_874026a_1156737323223_543280_225'> <visible xmi.value='false'/> - <geometry>686, 114, 45, 15</geometry> + <geometry>687, 114, 45, 15</geometry> </mdElement> </mdOwnedViews> <linkConstraintID xmi.idref='_9_5_1_874026a_1156737323223_749467_190'/> @@ -2875,7 +2889,7 @@ <mdElement elementClass='StringProperty'> <propertyID>BROWSER_LAYOUT</propertyID> <propertyDescriptionID>BROWSER_LAYOUT_DESCRIPTION</propertyDescriptionID> - <value>0 13 0 0 0 0 0 0 0 0 0 0 5 70 0 0 3 da 0 0 0 0 0 0 0 9 0 0 0 d 0 44 0 4f 0 43 0 55 0 4d 0 45 0 4e 0 54 0 41 0 54 0 49 0 4f 0 4e 0 0 6e 53 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 6e 53 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 d 0 44 0 49 0 41 0 47 0 52 0 41 0 4d 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 dd 75 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 dd 75 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c 0 5a 0 4f 0 4f 0 4d 0 5f 0 43 0 4f 0 4e 0 54 0 52 0 4f 0 4c 0 0 df d6 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 df d6 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 f 0 45 0 58 0 54 0 45 0 4e 0 53 0 49 0 4f 0 4e 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 bf 59 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 bf 59 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 49 0 4e 0 48 0 45 0 52 0 49 0 54 0 41 0 4e 0 43 0 45 0 5f 0 54 0 52 0 45 0 45 0 0 bd c3 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 bd c3 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 0 53 0 45 0 41 0 52 0 43 0 48 0 5f 0 52 0 45 0 53 0 55 0 4c 0 54 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 eb 9a 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 eb 9a 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 f 0 4d 0 45 0 53 0 53 0 41 0 47 0 45 0 53 0 5f 0 57 0 49 0 4e 0 44 0 4f 0 57 0 0 8c eb 0 0 0 2 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 8c eb 0 0 0 0 0 0 0 3c 0 0 0 3c 0 0 0 c8 0 0 0 c8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a 0 50 0 52 0 4f 0 50 0 45 0 52 0 54 0 49 0 45 0 53 0 0 b9 47 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 b9 47 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 43 0 4f 0 4e 0 54 0 41 0 49 0 4e 0 4d 0 45 0 4e 0 54 0 5f 0 54 0 52 0 45 0 45 0 0 2e 63 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 3f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 2e 63 0 0 0 2 0 0 0 0 0 0 0 0 0 0 5 68 0 0 3 55 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 63 0 0 0 0 0 0 1e 98 0 0 0 1 0 0 4 63 0 0 0 1 0 0 c1 f 0 0 0 2 0 0 4 63 0 0 0 0 0 0 34 7a 0 0 0 2 0 0 4 64 0 0 21 4f 0 0 0 5 0 0 4 65 0 0 0 10 0 43 0 4f 0 4e 0 54 0 41 0 49 0 4e 0 4d 0 45 0 4e 0 54 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 10 0 49 0 4e 0 48 0 45 0 52 0 49 0 54 0 41 0 4e 0 43 0 45 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 d 0 44 0 49 0 41 0 47 0 52 0 41 0 4d 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 f 0 45 0 58 0 54 0 45 0 4e 0 53 0 49 0 4f 0 4e 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 13 0 53 0 45 0 41 0 52 0 43 0 48 0 5f 0 52 0 45 0 53 0 55 0 4c 0 54 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 1 5c 0 0 1 26 0 0 0 0 0 0 4 64 0 0 3f a1 0 0 0 3 0 0 4 65 0 0 0 c 0 5a 0 4f 0 4f 0 4d 0 5f 0 43 0 4f 0 4e 0 54 0 52 0 4f 0 4c 0 0 4 65 0 0 0 d 0 44 0 4f 0 43 0 55 0 4d 0 45 0 4e 0 54 0 41 0 54 0 49 0 4f 0 4e 0 0 4 65 0 0 0 a 0 50 0 52 0 4f 0 50 0 45 0 52 0 54 0 49 0 45 0 53 0 0 1 5c 0 0 1 26 0 0 0 0 0 0 1 5c 0 0 2 50 0 0 4 66 0 0 0 1 0 0 0 19 0 0 0 0 0 0 1 61 0 0 2 50 0 0 1 61 0 0 2 50 0 0 0 3 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 f 0 4d 0 45 0 53 0 53 0 41 0 47 0 45 0 53 0 5f 0 57 0 49 0 4e 0 44 0 4f 0 57 </value> + <value>0 13 0 0 0 1 0 0 0 0 0 0 3 53 0 0 2 c4 0 0 0 0 0 0 0 9 0 0 0 d 0 44 0 4f 0 43 0 55 0 4d 0 45 0 4e 0 54 0 41 0 54 0 49 0 4f 0 4e 0 0 6e 53 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 6e 53 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 d 0 44 0 49 0 41 0 47 0 52 0 41 0 4d 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 dd 75 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 dd 75 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c 0 5a 0 4f 0 4f 0 4d 0 5f 0 43 0 4f 0 4e 0 54 0 52 0 4f 0 4c 0 0 df d6 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 df d6 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 f 0 45 0 58 0 54 0 45 0 4e 0 53 0 49 0 4f 0 4e 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 bf 59 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 bf 59 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 49 0 4e 0 48 0 45 0 52 0 49 0 54 0 41 0 4e 0 43 0 45 0 5f 0 54 0 52 0 45 0 45 0 0 bd c3 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 bd c3 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13 0 53 0 45 0 41 0 52 0 43 0 48 0 5f 0 52 0 45 0 53 0 55 0 4c 0 54 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 eb 9a 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 eb 9a 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 f 0 4d 0 45 0 53 0 53 0 41 0 47 0 45 0 53 0 5f 0 57 0 49 0 4e 0 44 0 4f 0 57 0 0 8c eb 0 0 0 2 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 8c eb 0 0 0 0 0 0 0 3c 0 0 0 3c 0 0 0 c8 0 0 0 c8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a 0 50 0 52 0 4f 0 50 0 45 0 52 0 54 0 49 0 45 0 53 0 0 b9 47 0 0 0 8 0 0 0 1 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 b9 47 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 3f a1 0 0 0 3 0 0 df d6 0 0 6e 53 0 0 b9 47 0 0 0 2 0 0 34 7a 0 0 3f a1 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 43 0 4f 0 4e 0 54 0 41 0 49 0 4e 0 4d 0 45 0 4e 0 54 0 5f 0 54 0 52 0 45 0 45 0 0 2e 63 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 f 0 0 0 4 0 0 0 4 0 0 0 8 0 0 1 5c 0 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 0 0 2e 63 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 4b 0 0 2 3f 0 0 0 8 0 0 0 0 0 0 21 4f 0 0 0 5 0 0 2e 63 0 0 bd c3 0 0 dd 75 0 0 bf 59 0 0 eb 9a 0 0 0 2 0 0 34 7a 0 0 21 4f 0 0 0 0 0 0 0 2 0 0 21 4f 0 0 3f a1 0 0 c1 f 0 0 34 7a 0 0 0 1 0 0 0 2 0 0 34 7a ff ff ff ff 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 63 0 0 0 0 0 0 1e 98 0 0 0 1 0 0 4 63 0 0 0 1 0 0 c1 f 0 0 0 2 0 0 4 63 0 0 0 0 0 0 34 7a 0 0 0 2 0 0 4 64 0 0 21 4f 0 0 0 5 0 0 4 65 0 0 0 10 0 43 0 4f 0 4e 0 54 0 41 0 49 0 4e 0 4d 0 45 0 4e 0 54 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 10 0 49 0 4e 0 48 0 45 0 52 0 49 0 54 0 41 0 4e 0 43 0 45 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 d 0 44 0 49 0 41 0 47 0 52 0 41 0 4d 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 f 0 45 0 58 0 54 0 45 0 4e 0 53 0 49 0 4f 0 4e 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 4 65 0 0 0 13 0 53 0 45 0 41 0 52 0 43 0 48 0 5f 0 52 0 45 0 53 0 55 0 4c 0 54 0 53 0 5f 0 54 0 52 0 45 0 45 0 0 1 5c 0 0 1 26 0 0 0 0 0 0 4 64 0 0 3f a1 0 0 0 3 0 0 4 65 0 0 0 c 0 5a 0 4f 0 4f 0 4d 0 5f 0 43 0 4f 0 4e 0 54 0 52 0 4f 0 4c 0 0 4 65 0 0 0 d 0 44 0 4f 0 43 0 55 0 4d 0 45 0 4e 0 54 0 41 0 54 0 49 0 4f 0 4e 0 0 4 65 0 0 0 a 0 50 0 52 0 4f 0 50 0 45 0 52 0 54 0 49 0 45 0 53 0 0 1 5c 0 0 1 26 0 0 0 0 0 0 1 5c 0 0 2 50 0 0 4 66 0 0 0 1 0 0 0 19 0 0 0 0 0 0 1 61 0 0 2 50 0 0 1 61 0 0 2 50 0 0 0 3 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 f 0 4d 0 45 0 53 0 53 0 41 0 47 0 45 0 53 0 5f 0 57 0 49 0 4e 0 44 0 4f 0 57 </value> <multiline xmi.value='false'/> </mdElement> <mdElement elementClass='StringProperty'> @@ -2924,7 +2938,7 @@ <mdElement elementClass='StringProperty'> <propertyID>INFO_PROPERTY</propertyID> <propertyDescriptionID>INFO_PROPERTY_DESCRIPTION</propertyDescriptionID> - <value>7e 33 f 41 26 59 43 7d 63 41 2d 24 ed 33 2e ce 24 3a 89 e3 50 92 e4 1f f4 2c 47 9a 69 72 c8 ef 17 4b ef c4 86 b9 d 96 c3 fb 23 2f 60 95 e 10 3e b 16 97 9a 79 28 dc 6b ae 18 b2 1f 11 aa 20 9c dc 94 f4 1a bd 6 </value> + <value>7e 33 f 41 26 59 43 7d 63 41 2d 24 ed 33 2e ce 24 3a 89 e3 50 92 e7 1e f4 2c 46 9a 69 7e c8 ef 17 4b ef c4 86 b9 d 96 c3 fb 23 2f 60 95 e 10 3e b 16 97 9a 79 28 dc 6b ae 18 b2 1f 11 aa 20 9c dc 94 f4 1a bd 6 </value> <multiline xmi.value='false'/> </mdElement> <mdElement elementClass='ChoiceProperty'> 1.1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database/build-db.bat Index: build-db.bat =================================================================== osql -S localhost -E -d TimeTrackerDotNet -i test-data-delete.sql osql -S localhost -E -d TimeTrackerDotNet -i static-data-delete.sql osql -S localhost -E -d TimeTrackerDotNet -i static-data-insert.sql osql -S localhost -E -d TimeTrackerDotNet -i test-data-insert.sql 1.1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database/static-data-delete.sql Index: static-data-delete.sql =================================================================== delete from USER_ROLE; delete from USERS; delete from TASK; 1.1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database/static-data-insert.sql Index: static-data-insert.sql =================================================================== SET IDENTITY_INSERT USERS ON insert into USERS (ID, USERNAME, PASSWORD, FIRST_NAME, LAST_NAME, EMAIL, IS_ACTIVE, CREATION_DATE, COMMENT) values (1, 'nbhatia', 'BiLpFCmanGIhhw6CEmEkz1vAdYs=', 'Naresh', 'Bhatia', 'nb...@no...', 1, '2006/01/01 09:00', null); insert into USERS (ID, USERNAME, PASSWORD, FIRST_NAME, LAST_NAME, EMAIL, IS_ACTIVE, CREATION_DATE, COMMENT) values (2, 'lcoude', 'BiLpFCmanGIhhw6CEmEkz1vAdYs=', 'Louis', 'Coude', 'lc...@no...', 1, '2006/01/01 09:00', null); insert into USERS (ID, USERNAME, PASSWORD, FIRST_NAME, LAST_NAME, EMAIL, IS_ACTIVE, CREATION_DATE, COMMENT) values (3, 'ecrutchfield', 'BiLpFCmanGIhhw6CEmEkz1vAdYs=', 'Eric', 'Crutchfield', 'ecr...@no...', 1, '2006/01/01 09:00', null); insert into USERS (ID, USERNAME, PASSWORD, FIRST_NAME, LAST_NAME, EMAIL, IS_ACTIVE, CREATION_DATE, COMMENT) values (4, 'cmicali', 'BiLpFCmanGIhhw6CEmEkz1vAdYs=', 'Chris', 'Micali', 'cm...@no...', 1, '2006/01/01 09:00', null); SET IDENTITY_INSERT USERS OFF SET IDENTITY_INSERT USER_ROLE ON insert into USER_ROLE (ID, ROLE, USER_FK) values (1, 1, 1); insert into USER_ROLE (ID, ROLE, USER_FK) values (2, 2, 1); insert into USER_ROLE (ID, ROLE, USER_FK) values (3, 1, 2); insert into USER_ROLE (ID, ROLE, USER_FK) values (4, 1, 3); insert into USER_ROLE (ID, ROLE, USER_FK) values (5, 1, 4); SET IDENTITY_INSERT USER_ROLE OFF SET IDENTITY_INSERT TASK ON insert into TASK (ID, NAME) values (1, 'Research'); insert into TASK (ID, NAME) values (2, 'Development'); insert into TASK (ID, NAME) values (3, 'Testing'); insert into TASK (ID, NAME) values (4, 'Admin'); insert into TASK (ID, NAME) values (5, 'Meeting'); SET IDENTITY_INSERT TASK OFF 1.1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database/test-data-delete.sql Index: test-data-delete.sql =================================================================== delete from TIME_ALLOCATION; delete from TIMECARD; 1.1 plugins/documentation/samples/time-tracker-dotnet-maven2/Northwind.TimeTracker/Database/test-data-insert.sql Index: test-data-insert.sql =================================================================== SET IDENTITY_INSERT TIMECARD ON insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 1, 2, '2006/05/15', 'Timecard 01', 1, 2); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 2, 2, '2006/05/15', 'Timecard 02', 2, 3); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 3, 2, '2006/05/15', 'Timecard 03', 3, 4); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 4, 2, '2006/05/15', 'Timecard 04', 4, 1); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 5, 3, '2006/05/22', 'Timecard 05', 1, 2); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 6, 3, '2006/05/22', 'Timecard 06', 2, 3); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 7, 3, '2006/05/22', 'Timecard 07', 3, 4); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 8, 3, '2006/05/22', 'Timecard 08', 4, 1); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values ( 9, 1, '2006/05/29', 'Timecard 09', 1, 2); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (10, 1, '2006/05/29', 'Timecard 10', 2, 3); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (11, 1, '2006/05/29', 'Timecard 11', 3, 4); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (12, 1, '2006/05/29', 'Timecard 12', 4, 1); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (13, 0, '2006/06/05', 'Timecard 13', null, 2); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (14, 0, '2006/06/05', 'Timecard 14', null, 3); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (15, 0, '2006/06/05', 'Timecard 15', null, 4); insert into TIMECARD (ID, STATUS, START_DATE, COMMENTS, APPROVER_FK, SUBMITTER_FK) values (16, 0, '2006/06/05', 'Timecard 16', null, 1); SET IDENTITY_INSERT TIMECARD OFF SET IDENTITY_INSERT TIME_ALLOCATION ON insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 1, '2006/05/15 09:00', '2006/05/15 05:00', 1, 1); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 2, '2006/05/16 09:00', '2006/05/16 05:00', 1, 1); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 3, '2006/05/15 09:00', '2006/05/15 05:00', 2, 2); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 4, '2006/05/16 09:00', '2006/05/16 05:00', 2, 2); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 5, '2006/05/15 09:00', '2006/05/15 05:00', 3, 3); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 6, '2006/05/16 09:00', '2006/05/16 05:00', 3, 3); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 7, '2006/05/15 09:00', '2006/05/15 05:00', 4, 4); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values ( 8, '2006/05/16 09:00', '2006/05/16 05:00', 4, 4); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (11, '2006/05/22 09:00', '2006/05/22 05:00', 5, 5); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (12, '2006/05/23 09:00', '2006/05/23 05:00', 5, 5); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (13, '2006/05/22 09:00', '2006/05/22 05:00', 1, 6); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (14, '2006/05/23 09:00', '2006/05/23 05:00', 1, 6); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (15, '2006/05/22 09:00', '2006/05/22 05:00', 2, 7); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (16, '2006/05/23 09:00', '2006/05/23 05:00', 2, 7); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (17, '2006/05/22 09:00', '2006/05/22 05:00', 3, 8); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (18, '2006/05/23 09:00', '2006/05/23 05:00', 3, 8); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (21, '2006/05/29 09:00', '2006/05/29 05:00', 4, 9); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (22, '2006/05/30 09:00', '2006/05/30 05:00', 4, 9); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (23, '2006/05/29 09:00', '2006/05/29 05:00', 5, 10); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (24, '2006/05/30 09:00', '2006/05/30 05:00', 5, 10); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (25, '2006/05/29 09:00', '2006/05/29 05:00', 1, 11); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (26, '2006/05/30 09:00', '2006/05/30 05:00', 1, 11); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (27, '2006/05/29 09:00', '2006/05/29 05:00', 2, 12); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (28, '2006/05/30 09:00', '2006/05/30 05:00', 2, 12); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (29, '2006/06/05 09:00', '2006/06/05 05:00', 3, 13); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (30, '2006/06/06 09:00', '2006/06/06 05:00', 3, 13); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (31, '2006/06/05 09:00', '2006/06/05 05:00', 4, 14); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (32, '2006/06/06 09:00', '2006/06/06 05:00', 4, 14); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (33, '2006/06/05 09:00', '2006/06/05 05:00', 5, 15); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (34, '2006/06/06 09:00', '2006/06/06 05:00', 5, 15); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (35, '2006/06/05 09:00', '2006/06/05 05:00', 1, 16); insert into TIME_ALLOCATION (ID, TIME_PERIOD_START_TIME, TIME_PERIOD_END_TIME, TASK_FK, TIMECARD_FK) values (36, '2006/06/06 09:00', '2006/06/06 05:00', 1, 16); SET IDENTITY_INSERT TIME_ALLOCATION OFF |