Home Explore Help
Register Sign In
Exylience
/
Rp41Murashkin
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Rp41Murashkin
/
Rp41MursahkinDataSet.xsd

Rp41MursahkinDataSet.xsd 22 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231 
  1. <?xml version="1.0" encoding="utf-8"?>
    2. 

  2. <xs:schema id="Rp41MursahkinDataSet" targetNamespace="http://tempuri.org/Rp41MursahkinDataSet.xsd" xmlns:mstns="http://tempuri.org/Rp41MursahkinDataSet.xsd" xmlns="http://tempuri.org/Rp41MursahkinDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
    3. 

  3.   <xs:annotation>
    4. 

  4.     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
    5. 

  5.       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
    6. 

  6.         <Connections>
    7. 

  7.           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Rp41MursahkinConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Rp41MursahkinConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Rp41Murashkin.Properties.Settings.GlobalReference.Default.Rp41MursahkinConnectionString" Provider="System.Data.SqlClient" />
    8. 

  8.         </Connections>
    9. 

  9.         <Tables>
    10. 

  10.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="clientsTableAdapter" GeneratorDataComponentClassName="clientsTableAdapter" Name="clients" UserDataComponentName="clientsTableAdapter">
    11. 

  11.             <MainSource>
    12. 

  12.               <DbSource ConnectionRef="Rp41MursahkinConnectionString (Settings)" DbObjectName="Rp41Mursahkin.dbo.clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    13. 

  13.                 <InsertCommand>
    14. 

  14.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    15. 

  15.                     <CommandText>INSERT INTO [dbo].[clients] ([surname], [name], [patronymic], [gender], [phone], [birth_date], [email], [created_at]) VALUES (@surname, @name, @patronymic, @gender, @phone, @birth_date, @email, @created_at)</CommandText>
    16. 

  16.                     <Parameters>
    17. 

  17.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Current" />
    18. 

  18.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
    19. 

  19.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="patronymic" SourceColumnNullMapping="false" SourceVersion="Current" />
    20. 

  20.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Current" />
    21. 

  21.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phone" SourceColumnNullMapping="false" SourceVersion="Current" />
    22. 

  22.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@birth_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="birth_date" SourceColumnNullMapping="false" SourceVersion="Current" />
    23. 

  23.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
    24. 

  24.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@created_at" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="created_at" SourceColumnNullMapping="false" SourceVersion="Current" />
    25. 

  25.                     </Parameters>
    26. 

  26.                   </DbCommand>
    27. 

  27.                 </InsertCommand>
    28. 

  28.                 <SelectCommand>
    29. 

  29.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    30. 

  30.                     <CommandText>SELECT surname, name, patronymic, gender, phone, birth_date, email, created_at FROM dbo.clients</CommandText>
    31. 

  31.                     <Parameters />
    32. 

  32.                   </DbCommand>
    33. 

  33.                 </SelectCommand>
    34. 

  34.               </DbSource>
    35. 

  35.             </MainSource>
    36. 

  36.             <Mappings>
    37. 

  37.               <Mapping SourceColumn="surname" DataSetColumn="surname" />
    38. 

  38.               <Mapping SourceColumn="name" DataSetColumn="name" />
    39. 

  39.               <Mapping SourceColumn="patronymic" DataSetColumn="patronymic" />
    40. 

  40.               <Mapping SourceColumn="gender" DataSetColumn="gender" />
    41. 

  41.               <Mapping SourceColumn="phone" DataSetColumn="phone" />
    42. 

  42.               <Mapping SourceColumn="birth_date" DataSetColumn="birth_date" />
    43. 

  43.               <Mapping SourceColumn="email" DataSetColumn="email" />
    44. 

  44.               <Mapping SourceColumn="created_at" DataSetColumn="created_at" />
    45. 

  45.             </Mappings>
    46. 

  46.             <Sources />
    47. 

  47.           </TableAdapter>
    48. 

  48.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="service_clientsTableAdapter" GeneratorDataComponentClassName="service_clientsTableAdapter" Name="service_clients" UserDataComponentName="service_clientsTableAdapter">
    49. 

  49.             <MainSource>
    50. 

  50.               <DbSource ConnectionRef="Rp41MursahkinConnectionString (Settings)" DbObjectName="Rp41Mursahkin.dbo.service_clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    51. 

  51.                 <InsertCommand>
    52. 

  52.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    53. 

  53.                     <CommandText>INSERT INTO [dbo].[service_clients] ([service], [start_date], [client]) VALUES (@service, @start_date, @client)</CommandText>
    54. 

  54.                     <Parameters>
    55. 

  55.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@service" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="service" SourceColumnNullMapping="false" SourceVersion="Current" />
    56. 

  56.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@start_date" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="start_date" SourceColumnNullMapping="false" SourceVersion="Current" />
    57. 

  57.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@client" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="client" SourceColumnNullMapping="false" SourceVersion="Current" />
    58. 

  58.                     </Parameters>
    59. 

  59.                   </DbCommand>
    60. 

  60.                 </InsertCommand>
    61. 

  61.                 <SelectCommand>
    62. 

  62.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    63. 

  63.                     <CommandText>SELECT service, start_date, client FROM dbo.service_clients</CommandText>
    64. 

  64.                     <Parameters />
    65. 

  65.                   </DbCommand>
    66. 

  66.                 </SelectCommand>
    67. 

  67.               </DbSource>
    68. 

  68.             </MainSource>
    69. 

  69.             <Mappings>
    70. 

  70.               <Mapping SourceColumn="service" DataSetColumn="service" />
    71. 

  71.               <Mapping SourceColumn="start_date" DataSetColumn="start_date" />
    72. 

  72.               <Mapping SourceColumn="client" DataSetColumn="client" />
    73. 

  73.             </Mappings>
    74. 

  74.             <Sources />
    75. 

  75.           </TableAdapter>
    76. 

  76.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="servicesTableAdapter" GeneratorDataComponentClassName="servicesTableAdapter" Name="services" UserDataComponentName="servicesTableAdapter">
    77. 

  77.             <MainSource>
    78. 

  78.               <DbSource ConnectionRef="Rp41MursahkinConnectionString (Settings)" DbObjectName="Rp41Mursahkin.dbo.services" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    79. 

  79.                 <InsertCommand>
    80. 

  80.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    81. 

  81.                     <CommandText>INSERT INTO [dbo].[services] ([title], [image], [duration], [price], [discount]) VALUES (@title, @image, @duration, @price, @discount)</CommandText>
    82. 

  82.                     <Parameters>
    83. 

  83.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
    84. 

  84.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="image" SourceColumnNullMapping="false" SourceVersion="Current" />
    85. 

  85.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@duration" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="duration" SourceColumnNullMapping="false" SourceVersion="Current" />
    86. 

  86.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
    87. 

  87.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@discount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="discount" SourceColumnNullMapping="false" SourceVersion="Current" />
    88. 

  88.                     </Parameters>
    89. 

  89.                   </DbCommand>
    90. 

  90.                 </InsertCommand>
    91. 

  91.                 <SelectCommand>
    92. 

  92.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    93. 

  93.                     <CommandText>SELECT title, image, duration, price, discount FROM dbo.services</CommandText>
    94. 

  94.                     <Parameters />
    95. 

  95.                   </DbCommand>
    96. 

  96.                 </SelectCommand>
    97. 

  97.               </DbSource>
    98. 

  98.             </MainSource>
    99. 

  99.             <Mappings>
    100. 

  100.               <Mapping SourceColumn="title" DataSetColumn="title" />
    101. 

  101.               <Mapping SourceColumn="image" DataSetColumn="image" />
    102. 

  102.               <Mapping SourceColumn="duration" DataSetColumn="duration" />
    103. 

  103.               <Mapping SourceColumn="price" DataSetColumn="price" />
    104. 

  104.               <Mapping SourceColumn="discount" DataSetColumn="discount" />
    105. 

  105.             </Mappings>
    106. 

  106.             <Sources />
    107. 

  107.           </TableAdapter>
    108. 

  108.         </Tables>
    109. 

  109.         <Sources />
    110. 

  110.       </DataSource>
    111. 

  111.     </xs:appinfo>
    112. 

  112.   </xs:annotation>
    113. 

  113.   <xs:element name="Rp41MursahkinDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Rp41MursahkinDataSet" msprop:Generator_UserDSName="Rp41MursahkinDataSet">
    114. 

  114.     <xs:complexType>
    115. 

  115.       <xs:choice minOccurs="0" maxOccurs="unbounded">
    116. 

  116.         <xs:element name="clients" msprop:Generator_TableClassName="clientsDataTable" msprop:Generator_TableVarName="tableclients" msprop:Generator_TablePropName="clients" msprop:Generator_RowDeletingName="clientsRowDeleting" msprop:Generator_RowChangingName="clientsRowChanging" msprop:Generator_RowEvHandlerName="clientsRowChangeEventHandler" msprop:Generator_RowDeletedName="clientsRowDeleted" msprop:Generator_UserTableName="clients" msprop:Generator_RowChangedName="clientsRowChanged" msprop:Generator_RowEvArgName="clientsRowChangeEvent" msprop:Generator_RowClassName="clientsRow">
    117. 

  117.           <xs:complexType>
    118. 

  118.             <xs:sequence>
    119. 

  119.               <xs:element name="surname" msprop:Generator_ColumnVarNameInTable="columnsurname" msprop:Generator_ColumnPropNameInRow="surname" msprop:Generator_ColumnPropNameInTable="surnameColumn" msprop:Generator_UserColumnName="surname">
    120. 

  120.                 <xs:simpleType>
    121. 

  121.                   <xs:restriction base="xs:string">
    122. 

  122.                     <xs:maxLength value="50" />
    123. 

  123.                   </xs:restriction>
    124. 

  124.                 </xs:simpleType>
    125. 

  125.               </xs:element>
    126. 

  126.               <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
    127. 

  127.                 <xs:simpleType>
    128. 

  128.                   <xs:restriction base="xs:string">
    129. 

  129.                     <xs:maxLength value="50" />
    130. 

  130.                   </xs:restriction>
    131. 

  131.                 </xs:simpleType>
    132. 

  132.               </xs:element>
    133. 

  133.               <xs:element name="patronymic" msprop:Generator_ColumnVarNameInTable="columnpatronymic" msprop:Generator_ColumnPropNameInRow="patronymic" msprop:Generator_ColumnPropNameInTable="patronymicColumn" msprop:Generator_UserColumnName="patronymic" minOccurs="0">
    134. 

  134.                 <xs:simpleType>
    135. 

  135.                   <xs:restriction base="xs:string">
    136. 

  136.                     <xs:maxLength value="50" />
    137. 

  137.                   </xs:restriction>
    138. 

  138.                 </xs:simpleType>
    139. 

  139.               </xs:element>
    140. 

  140.               <xs:element name="gender" msprop:Generator_ColumnVarNameInTable="columngender" msprop:Generator_ColumnPropNameInRow="gender" msprop:Generator_ColumnPropNameInTable="genderColumn" msprop:Generator_UserColumnName="gender">
    141. 

  141.                 <xs:simpleType>
    142. 

  142.                   <xs:restriction base="xs:string">
    143. 

  143.                     <xs:maxLength value="50" />
    144. 

  144.                   </xs:restriction>
    145. 

  145.                 </xs:simpleType>
    146. 

  146.               </xs:element>
    147. 

  147.               <xs:element name="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnPropNameInTable="phoneColumn" msprop:Generator_UserColumnName="phone">
    148. 

  148.                 <xs:simpleType>
    149. 

  149.                   <xs:restriction base="xs:string">
    150. 

  150.                     <xs:maxLength value="50" />
    151. 

  151.                   </xs:restriction>
    152. 

  152.                 </xs:simpleType>
    153. 

  153.               </xs:element>
    154. 

  154.               <xs:element name="birth_date" msprop:Generator_ColumnVarNameInTable="columnbirth_date" msprop:Generator_ColumnPropNameInRow="birth_date" msprop:Generator_ColumnPropNameInTable="birth_dateColumn" msprop:Generator_UserColumnName="birth_date" type="xs:dateTime" />
    155. 

  155.               <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email">
    156. 

  156.                 <xs:simpleType>
    157. 

  157.                   <xs:restriction base="xs:string">
    158. 

  158.                     <xs:maxLength value="50" />
    159. 

  159.                   </xs:restriction>
    160. 

  160.                 </xs:simpleType>
    161. 

  161.               </xs:element>
    162. 

  162.               <xs:element name="created_at" msprop:Generator_ColumnVarNameInTable="columncreated_at" msprop:Generator_ColumnPropNameInRow="created_at" msprop:Generator_ColumnPropNameInTable="created_atColumn" msprop:Generator_UserColumnName="created_at" type="xs:dateTime" />
    163. 

  163.             </xs:sequence>
    164. 

  164.           </xs:complexType>
    165. 

  165.         </xs:element>
    166. 

  166.         <xs:element name="service_clients" msprop:Generator_TableClassName="service_clientsDataTable" msprop:Generator_TableVarName="tableservice_clients" msprop:Generator_TablePropName="service_clients" msprop:Generator_RowDeletingName="service_clientsRowDeleting" msprop:Generator_RowChangingName="service_clientsRowChanging" msprop:Generator_RowEvHandlerName="service_clientsRowChangeEventHandler" msprop:Generator_RowDeletedName="service_clientsRowDeleted" msprop:Generator_UserTableName="service_clients" msprop:Generator_RowChangedName="service_clientsRowChanged" msprop:Generator_RowEvArgName="service_clientsRowChangeEvent" msprop:Generator_RowClassName="service_clientsRow">
    167. 

  167.           <xs:complexType>
    168. 

  168.             <xs:sequence>
    169. 

  169.               <xs:element name="service" msprop:Generator_ColumnVarNameInTable="columnservice" msprop:Generator_ColumnPropNameInRow="service" msprop:Generator_ColumnPropNameInTable="serviceColumn" msprop:Generator_UserColumnName="service">
    170. 

  170.                 <xs:simpleType>
    171. 

  171.                   <xs:restriction base="xs:string">
    172. 

  172.                     <xs:maxLength value="50" />
    173. 

  173.                   </xs:restriction>
    174. 

  174.                 </xs:simpleType>
    175. 

  175.               </xs:element>
    176. 

  176.               <xs:element name="start_date" msprop:Generator_ColumnVarNameInTable="columnstart_date" msprop:Generator_ColumnPropNameInRow="start_date" msprop:Generator_ColumnPropNameInTable="start_dateColumn" msprop:Generator_UserColumnName="start_date" type="xs:dateTime" />
    177. 

  177.               <xs:element name="client" msprop:Generator_ColumnVarNameInTable="columnclient" msprop:Generator_ColumnPropNameInRow="client" msprop:Generator_ColumnPropNameInTable="clientColumn" msprop:Generator_UserColumnName="client">
    178. 

  178.                 <xs:simpleType>
    179. 

  179.                   <xs:restriction base="xs:string">
    180. 

  180.                     <xs:maxLength value="50" />
    181. 

  181.                   </xs:restriction>
    182. 

  182.                 </xs:simpleType>
    183. 

  183.               </xs:element>
    184. 

  184.             </xs:sequence>
    185. 

  185.           </xs:complexType>
    186. 

  186.         </xs:element>
    187. 

  187.         <xs:element name="services" msprop:Generator_TableClassName="servicesDataTable" msprop:Generator_TableVarName="tableservices" msprop:Generator_TablePropName="services" msprop:Generator_RowDeletingName="servicesRowDeleting" msprop:Generator_RowChangingName="servicesRowChanging" msprop:Generator_RowEvHandlerName="servicesRowChangeEventHandler" msprop:Generator_RowDeletedName="servicesRowDeleted" msprop:Generator_UserTableName="services" msprop:Generator_RowChangedName="servicesRowChanged" msprop:Generator_RowEvArgName="servicesRowChangeEvent" msprop:Generator_RowClassName="servicesRow">
    188. 

  188.           <xs:complexType>
    189. 

  189.             <xs:sequence>
    190. 

  190.               <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
    191. 

  191.                 <xs:simpleType>
    192. 

  192.                   <xs:restriction base="xs:string">
    193. 

  193.                     <xs:maxLength value="50" />
    194. 

  194.                   </xs:restriction>
    195. 

  195.                 </xs:simpleType>
    196. 

  196.               </xs:element>
    197. 

  197.               <xs:element name="image" msprop:Generator_ColumnVarNameInTable="columnimage" msprop:Generator_ColumnPropNameInRow="image" msprop:Generator_ColumnPropNameInTable="imageColumn" msprop:Generator_UserColumnName="image" minOccurs="0">
    198. 

  198.                 <xs:simpleType>
    199. 

  199.                   <xs:restriction base="xs:string">
    200. 

  200.                     <xs:maxLength value="100" />
    201. 

  201.                   </xs:restriction>
    202. 

  202.                 </xs:simpleType>
    203. 

  203.               </xs:element>
    204. 

  204.               <xs:element name="duration" msprop:Generator_ColumnVarNameInTable="columnduration" msprop:Generator_ColumnPropNameInRow="duration" msprop:Generator_ColumnPropNameInTable="durationColumn" msprop:Generator_UserColumnName="duration">
    205. 

  205.                 <xs:simpleType>
    206. 

  206.                   <xs:restriction base="xs:string">
    207. 

  207.                     <xs:maxLength value="50" />
    208. 

  208.                   </xs:restriction>
    209. 

  209.                 </xs:simpleType>
    210. 

  210.               </xs:element>
    211. 

  211.               <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price">
    212. 

  212.                 <xs:simpleType>
    213. 

  213.                   <xs:restriction base="xs:string">
    214. 

  214.                     <xs:maxLength value="50" />
    215. 

  215.                   </xs:restriction>
    216. 

  216.                 </xs:simpleType>
    217. 

  217.               </xs:element>
    218. 

  218.               <xs:element name="discount" msprop:Generator_ColumnVarNameInTable="columndiscount" msprop:Generator_ColumnPropNameInRow="discount" msprop:Generator_ColumnPropNameInTable="discountColumn" msprop:Generator_UserColumnName="discount" minOccurs="0">
    219. 

  219.                 <xs:simpleType>
    220. 

  220.                   <xs:restriction base="xs:string">
    221. 

  221.                     <xs:maxLength value="50" />
    222. 

  222.                   </xs:restriction>
    223. 

  223.                 </xs:simpleType>
    224. 

  224.               </xs:element>
    225. 

  225.             </xs:sequence>
    226. 

  226.           </xs:complexType>
    227. 

  227.         </xs:element>
    228. 

  228.       </xs:choice>
    229. 

  229.     </xs:complexType>
    230. 

  230.   </xs:element>
    231. 

  231. </xs:schema>
    232.