aero03/aero03DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="aero03DataSet" targetNamespace="http://tempuri.org/aero03DataSet.xsd" xmlns:mstns="http://tempuri.org/aero03DataSet.xsd" xmlns="http://tempuri.org/aero03DataSet.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">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="aero03ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="aero03ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Lab1_.Properties.Settings.GlobalReference.Default.aero03ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TripTableAdapter" GeneratorDataComponentClassName="TripTableAdapter" Name="Trip" UserDataComponentName="TripTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="aero03ConnectionString (Settings)" DbObjectName="aero03.dbo.Trip" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Trip] WHERE (([trip_no] = @Original_trip_no) AND ([ID_comp] = @Original_ID_comp) AND ([plane] = @Original_plane) AND ([town_from] = @Original_town_from) AND ([town_to] = @Original_town_to) AND ([time_out] = @Original_time_out) AND ([time_in] = @Original_time_in))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_trip_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trip_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_comp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_comp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_plane" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="plane" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_town_from" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_town_to" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_time_out" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_out" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_time_in" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_in" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Trip] ([trip_no], [ID_comp], [plane], [town_from], [town_to], [time_out], [time_in]) VALUES (@trip_no, @ID_comp, @plane, @town_from, @town_to, @time_out, @time_in);
SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM Trip WHERE (trip_no = @trip_no)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@trip_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trip_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_comp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_comp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@plane" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="plane" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@town_from" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@town_to" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@time_out" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_out" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@time_in" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_in" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM dbo.Trip</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Trip] SET [trip_no] = @trip_no, [ID_comp] = @ID_comp, [plane] = @plane, [town_from] = @town_from, [town_to] = @town_to, [time_out] = @time_out, [time_in] = @time_in WHERE (([trip_no] = @Original_trip_no) AND ([ID_comp] = @Original_ID_comp) AND ([plane] = @Original_plane) AND ([town_from] = @Original_town_from) AND ([town_to] = @Original_town_to) AND ([time_out] = @Original_time_out) AND ([time_in] = @Original_time_in));
SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM Trip WHERE (trip_no = @trip_no)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@trip_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trip_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_comp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_comp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@plane" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="plane" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@town_from" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@town_to" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@time_out" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_out" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@time_in" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_in" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_trip_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="trip_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_comp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_comp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_plane" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="plane" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_town_from" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_town_to" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="town_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_time_out" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_out" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_time_in" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="time_in" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="trip_no" DataSetColumn="trip_no" />
              <Mapping SourceColumn="ID_comp" DataSetColumn="ID_comp" />
              <Mapping SourceColumn="plane" DataSetColumn="plane" />
              <Mapping SourceColumn="town_from" DataSetColumn="town_from" />
              <Mapping SourceColumn="town_to" DataSetColumn="town_to" />
              <Mapping SourceColumn="time_out" DataSetColumn="time_out" />
              <Mapping SourceColumn="time_in" DataSetColumn="time_in" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="aero03DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="aero03DataSet" msprop:Generator_UserDSName="aero03DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Trip" msprop:Generator_TableClassName="TripDataTable" msprop:Generator_TableVarName="tableTrip" msprop:Generator_TablePropName="Trip" msprop:Generator_RowDeletingName="TripRowDeleting" msprop:Generator_RowChangingName="TripRowChanging" msprop:Generator_RowEvHandlerName="TripRowChangeEventHandler" msprop:Generator_RowDeletedName="TripRowDeleted" msprop:Generator_UserTableName="Trip" msprop:Generator_RowChangedName="TripRowChanged" msprop:Generator_RowEvArgName="TripRowChangeEvent" msprop:Generator_RowClassName="TripRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="trip_no" msprop:Generator_ColumnVarNameInTable="columntrip_no" msprop:Generator_ColumnPropNameInRow="trip_no" msprop:Generator_ColumnPropNameInTable="trip_noColumn" msprop:Generator_UserColumnName="trip_no" type="xs:int" />
              <xs:element name="ID_comp" msprop:Generator_ColumnVarNameInTable="columnID_comp" msprop:Generator_ColumnPropNameInRow="ID_comp" msprop:Generator_ColumnPropNameInTable="ID_compColumn" msprop:Generator_UserColumnName="ID_comp" type="xs:int" />
              <xs:element name="plane" msprop:Generator_ColumnVarNameInTable="columnplane" msprop:Generator_ColumnPropNameInRow="plane" msprop:Generator_ColumnPropNameInTable="planeColumn" msprop:Generator_UserColumnName="plane">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="town_from" msprop:Generator_ColumnVarNameInTable="columntown_from" msprop:Generator_ColumnPropNameInRow="town_from" msprop:Generator_ColumnPropNameInTable="town_fromColumn" msprop:Generator_UserColumnName="town_from">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="town_to" msprop:Generator_ColumnVarNameInTable="columntown_to" msprop:Generator_ColumnPropNameInRow="town_to" msprop:Generator_ColumnPropNameInTable="town_toColumn" msprop:Generator_UserColumnName="town_to">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="time_out" msprop:Generator_ColumnVarNameInTable="columntime_out" msprop:Generator_ColumnPropNameInRow="time_out" msprop:Generator_ColumnPropNameInTable="time_outColumn" msprop:Generator_UserColumnName="time_out" type="xs:dateTime" />
              <xs:element name="time_in" msprop:Generator_ColumnVarNameInTable="columntime_in" msprop:Generator_ColumnPropNameInRow="time_in" msprop:Generator_ColumnPropNameInTable="time_inColumn" msprop:Generator_UserColumnName="time_in" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Trip" />
      <xs:field xpath="mstns:trip_no" />
    </xs:unique>
  </xs:element>
</xs:schema>