Menu
▾
▴
[tcdb-devel] SF.net SVN: tcdb: [43] WebPrototype
|
From: <ro...@us...> - 2006-06-20 18:59:39
|
Revision: 43 Author: rouquin Date: 2006-06-20 11:59:21 -0700 (Tue, 20 Jun 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=43&view=rev Log Message: ----------- WorkOrderEdit now allows you to create and edit workorders and assign and unassign testcases. You cannot currently set the status on a testcase; I need to learn exactly what fields must be set - I may need to add inputs for builds and versions. It may also be nice to filter the test cases by version and platform. Matt shows the idea of a workOrder template in his design but I don't see any support for this in the database yet. Leaving off for now. Modified Paths: -------------- WebPrototype/App_Code/DummyDataSet.xsd WebPrototype/App_Code/DummyDataSet.xss WebPrototype/App_Data/ASPNETDB.MDF WebPrototype/App_Data/Database.mdf WebPrototype/App_Data/Database_log.LDF WebPrototype/App_Data/aspnetdb_log.ldf WebPrototype/WorkOrderEdit.aspx WebPrototype/WorkOrderEdit.aspx.cs Modified: WebPrototype/App_Code/DummyDataSet.xsd =================================================================== --- WebPrototype/App_Code/DummyDataSet.xsd 2006-06-20 18:11:44 UTC (rev 42) +++ WebPrototype/App_Code/DummyDataSet.xsd 2006-06-20 18:59:21 UTC (rev 43) @@ -329,6 +329,16 @@ </DbCommand> </DeleteCommand> </DbSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.TestCase" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllTestCaseData" GetMethodModifier="Public" GetMethodName="GetAllTestCaseData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllTestCaseData" UserSourceName="FillBy"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT id, objectiveID, CAST(number AS varchar(20)) + ': ' + name AS Name, statusID, steps, createdby, editedby, dateCreated, dateEdited +FROM TestCase</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InsertTestCase" Modifier="Public" Name="InsertTestCase" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertTestCase"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> @@ -930,12 +940,13 @@ <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAssignmentDataByID" GetMethodModifier="Public" GetMethodName="GetAssignmentDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAssignmentDataByID" UserSourceName="GetAssignmentDataByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT WorkOrder.workOrderID, WorkOrder.name, WorkOrder.platformID, WorkOrder.testPassID, Assignments.assignmentID, Assignments.creatorID, - Assignments.assignedID, Assignments.dateAssigned, Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, - Assignments.highPriorityID + <CommandText>SELECT WorkOrder.workOrderID, WorkOrder.name, WorkOrder.testPassID, Assignments.assignmentID, Assignments.creatorID, Assignments.assignedID, + Assignments.dateAssigned, Assignments.dateFinished, Assignments.dateDue, Assignments.statusID, Assignments.highPriorityID, platform.osID, + platform.architectureID FROM WorkOrder INNER JOIN - Assignments ON WorkOrder.workOrderID = Assignments.workOrderID -WHERE WorkOrder.workOrderID=@workOrderID</CommandText> + Assignments ON WorkOrder.workOrderID = Assignments.workOrderID LEFT OUTER JOIN + platform ON platform.platformID = WorkOrder.platformID +WHERE (WorkOrder.workOrderID = @workOrderID)</CommandText> <Parameters> <Parameter AllowDbNull="False" AutogeneratedName="workOrderID" ColumnName="workOrderID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.WorkOrder" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@workOrderID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="workOrderID" SourceColumnNullMapping="False" SourceVersion="Current"> </Parameter> @@ -991,7 +1002,8 @@ <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetWorkOrderTestCaseDataByID" GetMethodModifier="Public" GetMethodName="GetWorkOrderTestCaseDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetWorkOrderTestCaseDataByID" UserSourceName="GetWorkOrderTestCaseDataByID1"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> - <CommandText>SELECT workOrderTestCase.testCaseID as testcaseID, TestCase.number AS number, TestCase.name AS name, TestCase.statusID as statusID, TestCase.steps AS steps + <CommandText>SELECT workOrderTestCase.testCaseID AS testcaseID, CAST(TestCase.number AS varchar(20)) + ': ' + TestCase.name AS Name, TestCase.statusID, + TestCase.steps,TestCase.number FROM workOrderTestCase INNER JOIN TestCase ON workOrderTestCase.testCaseID = TestCase.id WHERE (workOrderTestCase.workOrderID = @workOrderID)</CommandText> @@ -1022,11 +1034,26 @@ <Mapping SourceColumn="osID" DataSetColumn="osID" /> </Mappings> <Sources> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetPlatformNameDataByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetPlatformNameDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetPlatformNameDataByID" UserSourceName="FillBy"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT platform.platformID, architecture.name, os.friendlyName +FROM platform LEFT OUTER JOIN + architecture ON architecture.architectureID = platform.architectureID LEFT OUTER JOIN + os ON os.osID = platform.osID +WHERE (platform.platformID = @id)</CommandText> + <Parameters> + <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="platformID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\MICHAELT\DESKTOP\TCDB\WEBPROTOTYPE\APP_DATA\DATABASE.MDF].dbo.platform" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="platformID" SourceColumnNullMapping="False" SourceVersion="Current"> + </Parameter> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="resultTableAdapter" GeneratorDataComponentClassName="resultTableAdapter" Name="result" UserDataComponentName="resultTableAdapter"> <MainSource> - <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.result" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllResultData" GetMethodModifier="Public" GetMethodName="GetAllResultData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllResultData" UserSourceName="Fill"> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.result" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllResultData" GetMethodModifier="Public" GetMethodName="GetAllResultData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllResultData" UserSourceName="GetAllResultData"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="True"> <CommandText>SELECT * FROM Result</CommandText> @@ -1045,6 +1072,46 @@ <Sources> </Sources> </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="architectureTableAdapter" GeneratorDataComponentClassName="architectureTableAdapter" Name="architecture" UserDataComponentName="architectureTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.architecture" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllArchitectureData" GetMethodModifier="Public" GetMethodName="GetAllArchitectureData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllArchitectureData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT architectureID, name +FROM architecture</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="architectureID" DataSetColumn="architectureID" /> + <Mapping SourceColumn="name" DataSetColumn="name" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> + <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="osTableAdapter" GeneratorDataComponentClassName="osTableAdapter" Name="os" UserDataComponentName="osTableAdapter"> + <MainSource> + <DbSource ConnectionRef="DummyDatabaseConnectionString (Web.config)" DbObjectName="dbo.os" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetAllOSData" GetMethodModifier="Public" GetMethodName="GetAllOSData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllOSData" UserSourceName="Fill"> + <SelectCommand> + <DbCommand CommandType="Text" ModifiedByUser="True"> + <CommandText>SELECT * FROM os</CommandText> + <Parameters> + </Parameters> + </DbCommand> + </SelectCommand> + </DbSource> + </MainSource> + <Mappings> + <Mapping SourceColumn="osID" DataSetColumn="osID" /> + <Mapping SourceColumn="friendlyName" DataSetColumn="friendlyName" /> + <Mapping SourceColumn="codeName" DataSetColumn="codeName" /> + </Mappings> + <Sources> + </Sources> + </TableAdapter> </Tables> <Sources> </Sources> @@ -1057,117 +1124,117 @@ <xs:element name="Feature" msprop:Generator_UserTableName="Feature" msprop:Generator_RowDeletedName="FeatureRowDeleted" msprop:Generator_RowChangedName="FeatureRowChanged" msprop:Generator_RowClassName="FeatureRow" msprop:Generator_RowChangingName="FeatureRowChanging" msprop:Generator_RowEvArgName="FeatureRowChangeEvent" msprop:Generator_RowEvHandlerName="FeatureRowChangeEventHandler" msprop:Generator_TableClassName="FeatureDataTable" msprop:Generator_TableVarName="tableFeature" msprop:Generator_RowDeletingName="FeatureRowDeleting" msprop:Generator_TablePropName="Feature"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="parent_id" msprop:Generator_UserColumnName="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" type="xs:int" minOccurs="0" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> + <xs:element name="featureNumber" msprop:Generator_UserColumnName="featureNumber" msprop:Generator_ColumnVarNameInTable="columnfeatureNumber" msprop:Generator_ColumnPropNameInRow="featureNumber" msprop:Generator_ColumnPropNameInTable="featureNumberColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Objective" msprop:Generator_UserTableName="Objective" msprop:Generator_RowDeletedName="ObjectiveRowDeleted" msprop:Generator_RowChangedName="ObjectiveRowChanged" msprop:Generator_RowClassName="ObjectiveRow" msprop:Generator_RowChangingName="ObjectiveRowChanging" msprop:Generator_RowEvArgName="ObjectiveRowChangeEvent" msprop:Generator_RowEvHandlerName="ObjectiveRowChangeEventHandler" msprop:Generator_TableClassName="ObjectiveDataTable" msprop:Generator_TableVarName="tableObjective" msprop:Generator_RowDeletingName="ObjectiveRowDeleting" msprop:Generator_TablePropName="Objective"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> + <xs:element name="user" msprop:Generator_UserColumnName="user" msprop:Generator_ColumnVarNameInTable="columnuser" msprop:Generator_ColumnPropNameInRow="user" msprop:Generator_ColumnPropNameInTable="userColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="feature" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInTable="featureColumn" type="xs:int" /> - <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" type="xs:dateTime" /> + <xs:element name="feature" msprop:Generator_UserColumnName="feature" msprop:Generator_ColumnVarNameInTable="columnfeature" msprop:Generator_ColumnPropNameInRow="feature" msprop:Generator_ColumnPropNameInTable="featureColumn" type="xs:int" /> + <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" type="xs:dateTime" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="TestCase" msprop:Generator_UserTableName="TestCase" msprop:Generator_RowDeletedName="TestCaseRowDeleted" msprop:Generator_RowChangedName="TestCaseRowChanged" msprop:Generator_RowClassName="TestCaseRow" msprop:Generator_RowChangingName="TestCaseRowChanging" msprop:Generator_RowEvArgName="TestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="TestCaseRowChangeEventHandler" msprop:Generator_TableClassName="TestCaseDataTable" msprop:Generator_TableVarName="tableTestCase" msprop:Generator_RowDeletingName="TestCaseRowDeleting" msprop:Generator_TablePropName="TestCase"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> + <xs:element name="steps" msprop:Generator_UserColumnName="steps" msprop:Generator_ColumnVarNameInTable="columnsteps" msprop:Generator_ColumnPropNameInRow="steps" msprop:Generator_ColumnPropNameInTable="stepsColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> - <xs:element name="createdby" msprop:Generator_UserColumnName="createdby" msprop:Generator_ColumnPropNameInRow="createdby" msprop:Generator_ColumnVarNameInTable="columncreatedby" msprop:Generator_ColumnPropNameInTable="createdbyColumn" type="xs:int" minOccurs="0" /> - <xs:element name="editedby" msprop:Generator_UserColumnName="editedby" msprop:Generator_ColumnPropNameInRow="editedby" msprop:Generator_ColumnVarNameInTable="columneditedby" msprop:Generator_ColumnPropNameInTable="editedbyColumn" type="xs:int" minOccurs="0" /> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> - <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" /> + <xs:element name="createdby" msprop:Generator_UserColumnName="createdby" msprop:Generator_ColumnVarNameInTable="columncreatedby" msprop:Generator_ColumnPropNameInRow="createdby" msprop:Generator_ColumnPropNameInTable="createdbyColumn" type="xs:int" minOccurs="0" /> + <xs:element name="editedby" msprop:Generator_UserColumnName="editedby" msprop:Generator_ColumnVarNameInTable="columneditedby" msprop:Generator_ColumnPropNameInRow="editedby" msprop:Generator_ColumnPropNameInTable="editedbyColumn" type="xs:int" minOccurs="0" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="dateEdited" msprop:Generator_UserColumnName="dateEdited" msprop:Generator_ColumnVarNameInTable="columndateEdited" msprop:Generator_ColumnPropNameInRow="dateEdited" msprop:Generator_ColumnPropNameInTable="dateEditedColumn" type="xs:dateTime" minOccurs="0" /> + <xs:element name="objectiveID" msprop:Generator_UserColumnName="objectiveID" msprop:Generator_ColumnVarNameInTable="columnobjectiveID" msprop:Generator_ColumnPropNameInRow="objectiveID" msprop:Generator_ColumnPropNameInTable="objectiveIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="statusID" msprop:Generator_UserColumnName="statusID" msprop:Generator_ColumnVarNameInTable="columnstatusID" msprop:Generator_ColumnPropNameInRow="statusID" msprop:Generator_ColumnPropNameInTable="statusIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Tags" msprop:Generator_UserTableName="Tags" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_RowClassName="TagsRow" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvArgName="TagsRowChangeEvent" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_TablePropName="Tags"> <xs:complexType> <xs:sequence> - <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> + <xs:element name="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> @@ -1180,27 +1247,27 @@ <xs:element name="Products" msprop:Generator_UserTableName="Products" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_TablePropName="Products"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0"> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0"> + <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="DevManager" msprop:Generator_UserColumnName="DevManager" msprop:Generator_ColumnVarNameInTable="columnDevManager" msprop:Generator_ColumnPropNameInRow="DevManager" msprop:Generator_ColumnPropNameInTable="DevManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="QAManager" msprop:Generator_UserColumnName="QAManager" msprop:Generator_ColumnVarNameInTable="columnQAManager" msprop:Generator_ColumnPropNameInRow="QAManager" msprop:Generator_ColumnPropNameInTable="QAManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="DevLead" msprop:Generator_UserColumnName="DevLead" msprop:Generator_ColumnVarNameInTable="columnDevLead" msprop:Generator_ColumnPropNameInRow="DevLead" msprop:Generator_ColumnPropNameInTable="DevLeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="QALead" msprop:Generator_UserColumnName="QALead" msprop:Generator_ColumnVarNameInTable="columnQALead" msprop:Generator_ColumnPropNameInRow="QALead" msprop:Generator_ColumnPropNameInTable="QALeadColumn" type="xs:int" minOccurs="0" /> - <xs:element name="ProductManager" msprop:Generator_UserColumnName="ProductManager" msprop:Generator_ColumnVarNameInTable="columnProductManager" msprop:Generator_ColumnPropNameInRow="ProductManager" msprop:Generator_ColumnPropNameInTable="ProductManagerColumn" type="xs:int" minOccurs="0" /> - <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" minOccurs="0"> + <xs:element name="DevManager" msprop:Generator_UserColumnName="DevManager" msprop:Generator_ColumnPropNameInRow="DevManager" msprop:Generator_ColumnVarNameInTable="columnDevManager" msprop:Generator_ColumnPropNameInTable="DevManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="QAManager" msprop:Generator_UserColumnName="QAManager" msprop:Generator_ColumnPropNameInRow="QAManager" msprop:Generator_ColumnVarNameInTable="columnQAManager" msprop:Generator_ColumnPropNameInTable="QAManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="DevLead" msprop:Generator_UserColumnName="DevLead" msprop:Generator_ColumnPropNameInRow="DevLead" msprop:Generator_ColumnVarNameInTable="columnDevLead" msprop:Generator_ColumnPropNameInTable="DevLeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="QALead" msprop:Generator_UserColumnName="QALead" msprop:Generator_ColumnPropNameInRow="QALead" msprop:Generator_ColumnVarNameInTable="columnQALead" msprop:Generator_ColumnPropNameInTable="QALeadColumn" type="xs:int" minOccurs="0" /> + <xs:element name="ProductManager" msprop:Generator_UserColumnName="ProductManager" msprop:Generator_ColumnPropNameInRow="ProductManager" msprop:Generator_ColumnVarNameInTable="columnProductManager" msprop:Generator_ColumnPropNameInTable="ProductManagerColumn" type="xs:int" minOccurs="0" /> + <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> @@ -1213,72 +1280,72 @@ <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="Users"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> + <xs:element name="officePhone" msprop:Generator_UserColumnName="officePhone" msprop:Generator_ColumnPropNameInRow="officePhone" msprop:Generator_ColumnVarNameInTable="columnofficePhone" msprop:Generator_ColumnPropNameInTable="officePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> + <xs:element name="homePhone" msprop:Generator_UserColumnName="homePhone" msprop:Generator_ColumnPropNameInRow="homePhone" msprop:Generator_ColumnVarNameInTable="columnhomePhone" msprop:Generator_ColumnPropNameInTable="homePhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> + <xs:element name="cellPhone" msprop:Generator_UserColumnName="cellPhone" msprop:Generator_ColumnPropNameInRow="cellPhone" msprop:Generator_ColumnVarNameInTable="columncellPhone" msprop:Generator_ColumnPropNameInTable="cellPhoneColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" minOccurs="0"> + <xs:element name="firstName" msprop:Generator_UserColumnName="firstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" minOccurs="0"> + <xs:element name="lastName" msprop:Generator_UserColumnName="lastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" minOccurs="0" /> + <xs:element name="automation" msprop:Generator_UserColumnName="automation" msprop:Generator_ColumnPropNameInRow="automation" msprop:Generator_ColumnVarNameInTable="columnautomation" msprop:Generator_ColumnPropNameInTable="automationColumn" type="xs:boolean" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Status" msprop:Generator_UserTableName="Status" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowClassName="StatusRow" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_TablePropName="Status"> <xs:complexType> <xs:sequence> - <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> - <xs:element name="stateName" msprop:Generator_UserColumnName="stateName" msprop:Generator_ColumnPropNameInRow="stateName" msprop:Generator_ColumnVarNameInTable="columnstateName" msprop:Generator_ColumnPropNameInTable="stateNameColumn" minOccurs="0"> + <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" /> + <xs:element name="stateName" msprop:Generator_UserColumnName="stateName" msprop:Generator_ColumnVarNameInTable="columnstateName" msprop:Generator_ColumnPropNameInRow="stateName" msprop:Generator_ColumnPropNameInTable="stateNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> + <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="255" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="groupName" msprop:Generator_UserColumnName="groupName" msprop:Generator_ColumnPropNameInRow="groupName" msprop:Generator_ColumnVarNameInTable="columngroupName" msprop:Generator_ColumnPropNameInTable="groupNameColumn" minOccurs="0"> + <xs:element name="groupName" msprop:Generator_UserColumnName="groupName" msprop:Generator_ColumnVarNameInTable="columngroupName" msprop:Generator_ColumnPropNameInRow="groupName" msprop:Generator_ColumnPropNameInTable="groupNameColumn" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> @@ -1291,132 +1358,132 @@ <xs:element name="testCaseTags" msprop:Generator_UserTableName="testCaseTags" msprop:Generator_RowDeletedName="testCaseTagsRowDeleted" msprop:Generator_RowChangedName="testCaseTagsRowChanged" msprop:Generator_RowClassName="testCaseTagsRow" msprop:Generator_RowChangingName="testCaseTagsRowChanging" msprop:Generator_RowEvArgName="testCaseTagsRowChangeEvent" msprop:Generator_RowEvHandlerName="testCaseTagsRowChangeEventHandler" msprop:Generator_TableClassName="testCaseTagsDataTable" msprop:Generator_TableVarName="tabletestCaseTags" msprop:Generator_RowDeletingName="testCaseTagsRowDeleting" msprop:Generator_TablePropName="testCaseTags"> <xs:complexType> <xs:sequence> - <xs:element name="testCaseTagsID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testCaseTagsID" msprop:Generator_ColumnVarNameInTable="columntestCaseTagsID" msprop:Generator_ColumnPropNameInRow="testCaseTagsID" msprop:Generator_ColumnPropNameInTable="testCaseTagsIDColumn" type="xs:int" /> - <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" /> - <xs:element name="tagID" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> + <xs:element name="testCaseTagsID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="testCaseTagsID" msprop:Generator_ColumnPropNameInRow="testCaseTagsID" msprop:Generator_ColumnVarNameInTable="columntestCaseTagsID" msprop:Generator_ColumnPropNameInTable="testCaseTagsIDColumn" type="xs:int" /> + <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" /> + <xs:element name="tagID" msprop:Generator_UserColumnName="tagID" msprop:Generator_ColumnPropNameInRow="tagID" msprop:Generator_ColumnVarNameInTable="columntagID" msprop:Generator_ColumnPropNameInTable="tagIDColumn" type="xs:int" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="version" msprop:Generator_UserTableName="version" msprop:Generator_RowDeletedName="versionRowDeleted" msprop:Generator_RowChangedName="versionRowChanged" msprop:Generator_RowClassName="versionRow" msprop:Generator_RowChangingName="versionRowChanging" msprop:Generator_RowEvArgName="versionRowChangeEvent" msprop:Generator_RowEvHandlerName="versionRowChangeEventHandler" msprop:Generator_TableClassName="versionDataTable" msprop:Generator_TableVarName="tableversion" msprop:Generator_RowDeletingName="versionRowDeleting" msprop:Generator_TablePropName="version"> <xs:complexType> <xs:sequence> - <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" /> - <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> - <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnPropNameInTable="numberColumn"> + <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" /> + <xs:element name="productID" msprop:Generator_UserColumnName="productID" msprop:Generator_ColumnPropNameInRow="productID" msprop:Generator_ColumnVarNameInTable="columnproductID" msprop:Generator_ColumnPropNameInTable="productIDColumn" type="xs:int" /> + <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> - <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" /> - <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> + <xs:element name="dateCreated" msprop:Generator_UserColumnName="dateCreated" msprop:Generator_ColumnPropNameInRow="dateCreated" msprop:Generator_ColumnVarNameInTable="columndateCreated" msprop:Generator_ColumnPropNameInTable="dateCreatedColumn" type="xs:dateTime" /> + <xs:element name="active" msprop:Generator_UserColumnName="active" msprop:Generator_ColumnPropNameInRow="active" msprop:Generator_ColumnVarNameInTable="columnactive" msprop:Generator_ColumnPropNameInTable="activeColumn" type="xs:boolean" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="versionTestCase" msprop:Generator_UserTableName="versionTestCase" msprop:Generator_RowDeletedName="versionTestCaseRowDeleted" msprop:Generator_RowChangedName="versionTestCaseRowChanged" msprop:Generator_RowClassName="versionTestCaseRow" msprop:Generator_RowChangingName="versionTestCaseRowChanging" msprop:Generator_RowEvArgName="versionTestCaseRowChangeEvent" msprop:Generator_RowEvHandlerName="versionTestCaseRowChangeEventHandler" msprop:Generator_TableClassName="versionTestCaseDataTable" msprop:Generator_TableVarName="tableversionTestCase" msprop:Generator_RowDeletingName="versionTestCaseRowDeleting" msprop:Generator_TablePropName="versionTestCase"> <xs:complexType> <xs:sequence> - <xs:element name="versionTestCaseID" msprop:Generator_UserColumnName="versionTestCaseID" msprop:Generator_ColumnVarNameInTable="columnversionTestCaseID" msprop:Generator_ColumnPropNameInRow="versionTestCaseID" msprop:Generator_ColumnPropNameInTable="versionTestCaseIDColumn" type="xs:int" /> - <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="versionTestCaseID" msprop:Generator_UserColumnName="versionTestCaseID" msprop:Generator_ColumnPropNameInRow="versionTestCaseID" msprop:Generator_ColumnVarNameInTable="columnversionTestCaseID" msprop:Generator_ColumnPropNameInTable="versionTestCaseIDColumn" type="xs:int" /> + <xs:element name="testCaseID" msprop:Generator_UserColumnName="testCaseID" msprop:Generator_ColumnPropNameInRow="testCaseID" msprop:Generator_ColumnVarNameInTable="columntestCaseID" msprop:Generator_ColumnPropNameInTable="testCaseIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="versionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="featureVersion" msprop:Generator_UserTableName="featureVersion" msprop:Generator_RowDeletedName="featureVersionRowDeleted" msprop:Generator_RowChangedName="featureVersionRowChanged" msprop:Generator_RowClassName="featureVersionRow" msprop:Generator_RowChangingName="featureVersionRowChanging" msprop:Generator_RowEvArgName="featureVersionRowChangeEvent" msprop:Generator_RowEvHandlerName="featureVersionRowChangeEventHandler" msprop:Generator_TableClassName="featureVersionDataTable" msprop:Generator_TableVarName="tablefeatureVersion" msprop:Generator_RowDeletingName="featureVersionRowDeleting" msprop:Generator_TablePropName="featureVersion"> <xs:complexType> <xs:sequence> - <xs:element name="featureVersionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="featureVersionID" msprop:Generator_ColumnVarNameInTable="columnfeatureVersionID" msprop:Generator_ColumnPropNameInRow="featureVersionID" msprop:Generator_ColumnPropNameInTable="featureVersionIDColumn" type="xs:int" /> - <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" minOccurs="0" /> - <xs:element name="versionID" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="featureVersionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="featureVersionID" msprop:Generator_ColumnPropNameInRow="featureVersionID" msprop:Generator_ColumnVarNameInTable="columnfeatureVersionID" msprop:Generator_ColumnPropNameInTable="featureVersionIDColumn" type="xs:int" /> + <xs:element name="featureID" msprop:Generator_UserColumnName="featureID" msprop:Generator_ColumnPropNameInRow="featureID" msprop:Generator_ColumnVarNameInTable="columnfeatureID" msprop:Generator_ColumnPropNameInTable="featureIDColumn" type="xs:int" minOccurs="0" /> + <xs:element name="versionID" msprop:Generator_UserColumnName="versionID" msprop:Generator_ColumnPropNameInRow="versionID" msprop:Generator_ColumnVarNameInTable="columnversionID" msprop:Generator_ColumnPropNameInTable="versionIDColumn" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Assignments" msprop:Generator_UserTableName="Assignments" msprop:Generator_RowDeletedName="AssignmentsRowDeleted" msprop:Generator_RowChangedName="AssignmentsRowChanged" msprop:Generator_RowClassName="AssignmentsRow" msprop:Generator_RowChangingName="AssignmentsRowChanging" msprop:Generator_RowEvArgName="AssignmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignmentsRowChangeEventHandler" msprop:Generator_TableClassName="AssignmentsDataTable" msprop:Generator_TableVarName="tableAssignmen... [truncated message content] |
