|
|
<?xml version="1.0" encoding="utf-8"?>
|
|
|
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
|
|
|
|
|
|
<edmx:Runtime>
|
|
|
|
|
|
<edmx:StorageModels>
|
|
|
<Schema Namespace="MovieFinderModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
|
|
|
<EntityContainer Name="MovieFinderModelStoreContainer">
|
|
|
<EntitySet Name="Movie" EntityType="MovieFinderModel.Store.Movie" store:Type="Tables" Schema="dbo" />
|
|
|
<EntitySet Name="MovieLink" EntityType="MovieFinderModel.Store.MovieLink" store:Type="Tables" Schema="dbo" />
|
|
|
<EntitySet Name="Plugin" EntityType="MovieFinderModel.Store.Plugin" store:Type="Tables" Schema="dbo" />
|
|
|
<EntitySet Name="VisitorProfile" EntityType="MovieFinderModel.Store.VisitorProfile" store:Type="Tables" Schema="dbo" />
|
|
|
<AssociationSet Name="FK_MovieLink_Movie" Association="MovieFinderModel.Store.FK_MovieLink_Movie">
|
|
|
<End Role="Movie" EntitySet="Movie" />
|
|
|
<End Role="MovieLink" EntitySet="MovieLink" />
|
|
|
</AssociationSet>
|
|
|
</EntityContainer>
|
|
|
<EntityType Name="Movie">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Name="ID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
|
|
<Property Name="Name" Type="varchar" Nullable="false" MaxLength="100" />
|
|
|
<Property Name="UniqueID" Type="varchar" Nullable="false" MaxLength="100" />
|
|
|
<Property Name="ImageUrl" Type="varchar" MaxLength="500" />
|
|
|
<Property Name="ReleaseDate" Type="datetime" Nullable="false" />
|
|
|
<Property Name="LanguageCode" Type="char" Nullable="false" MaxLength="2" />
|
|
|
<Property Name="Description" Type="varchar" MaxLength="1000" />
|
|
|
<Property Name="CreateDate" Type="datetime" Nullable="false" />
|
|
|
<Property Name="ModifiedDate" Type="datetime" />
|
|
|
<Property Name="Version" Type="int" Nullable="false" />
|
|
|
<Property Name="VersionChange" Type="int" Nullable="false" />
|
|
|
<Property Name="ImageScrapperID" Type="varchar" Nullable="false" MaxLength="100" />
|
|
|
<Property Name="ImageLocalUrl" Type="varchar" MaxLength="500" />
|
|
|
<Property Name="ViewCount" Type="int" Nullable="false" />
|
|
|
<Property Name="LikeCount" Type="int" Nullable="false" />
|
|
|
</EntityType>
|
|
|
<EntityType Name="MovieLink">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Name="ID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
|
|
<Property Name="MovieID" Type="int" Nullable="false" />
|
|
|
<Property Name="LinkTitle" Type="varchar" Nullable="false" MaxLength="1000" />
|
|
|
<Property Name="SiteTitle" Type="varchar" Nullable="false" MaxLength="50" />
|
|
|
<Property Name="PageUrl" Type="varchar" Nullable="false" MaxLength="500" />
|
|
|
<Property Name="PageSiteID" Type="varchar" Nullable="false" MaxLength="10" />
|
|
|
<Property Name="DownloadSiteID" Type="varchar" Nullable="false" MaxLength="50" />
|
|
|
<Property Name="DowloadUrl" Type="varchar" Nullable="false" MaxLength="500" />
|
|
|
<Property Name="FailedAttempts" Type="int" Nullable="false" />
|
|
|
<Property Name="LastValidatedWhen" Type="datetime" />
|
|
|
<Property Name="Version" Type="int" Nullable="false" />
|
|
|
<Property Name="LastValidatedBy" Type="uniqueidentifier" />
|
|
|
<Property Name="HasSubtitle" Type="bit" Nullable="false" />
|
|
|
<Property Name="IsWebSupported" Type="bit" Nullable="false" />
|
|
|
<Property Name="IsDesktopSupported" Type="bit" Nullable="false" />
|
|
|
<Property Name="PartID" Type="int" />
|
|
|
<Property Name="PartIndex" Type="int" />
|
|
|
</EntityType>
|
|
|
<EntityType Name="Plugin">
|
|
|
<Key>
|
|
|
<PropertyRef Name="GKName" />
|
|
|
</Key>
|
|
|
<Property Name="GKName" Type="varchar" Nullable="false" MaxLength="50" />
|
|
|
<Property Name="PluginName" Type="varchar" MaxLength="75" StoreGeneratedPattern="Computed" />
|
|
|
<Property Name="SiteID" Type="varchar" Nullable="false" MaxLength="250" />
|
|
|
<Property Name="LastUpdatedTime" Type="int" Nullable="false" />
|
|
|
</EntityType>
|
|
|
<EntityType Name="VisitorProfile">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Name="ID" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity" />
|
|
|
<Property Name="UserID" Type="int" />
|
|
|
<Property Name="LastAccessedTime" Type="datetime" Nullable="false" />
|
|
|
<Property Name="LastAccessedIP" Type="varchar" Nullable="false" MaxLength="20" />
|
|
|
<Property Name="LastAccessedLanguage" Type="varchar" Nullable="false" MaxLength="2" />
|
|
|
<Property Name="LastAccessedUrl" Type="varchar" Nullable="false" MaxLength="200" />
|
|
|
<Property Name="HitCount" Type="int" Nullable="false" />
|
|
|
</EntityType>
|
|
|
<Association Name="FK_MovieLink_Movie">
|
|
|
<End Role="Movie" Type="MovieFinderModel.Store.Movie" Multiplicity="1">
|
|
|
<OnDelete Action="Cascade" />
|
|
|
</End>
|
|
|
<End Role="MovieLink" Type="MovieFinderModel.Store.MovieLink" Multiplicity="*" />
|
|
|
<ReferentialConstraint>
|
|
|
<Principal Role="Movie">
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Principal>
|
|
|
<Dependent Role="MovieLink">
|
|
|
<PropertyRef Name="MovieID" />
|
|
|
</Dependent>
|
|
|
</ReferentialConstraint>
|
|
|
</Association>
|
|
|
</Schema></edmx:StorageModels>
|
|
|
|
|
|
<edmx:ConceptualModels>
|
|
|
<Schema Namespace="MovieFinderModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
|
|
|
<EntityContainer Name="MovieFinderEntities" annotation:LazyLoadingEnabled="true">
|
|
|
<EntitySet Name="MovieLinks" EntityType="MovieFinderModel.MovieLink" />
|
|
|
<EntitySet Name="Movies" EntityType="MovieFinderModel.Movie" />
|
|
|
<AssociationSet Name="FK_MovieLink_Movie" Association="MovieFinderModel.FK_MovieLink_Movie">
|
|
|
<End Role="Movie" EntitySet="Movies" />
|
|
|
<End Role="MovieLink" EntitySet="MovieLinks" />
|
|
|
</AssociationSet>
|
|
|
<EntitySet Name="VisitorProfiles" EntityType="MovieFinderModel.VisitorProfile" />
|
|
|
<EntitySet Name="Plugins" EntityType="MovieFinderModel.Plugin" />
|
|
|
</EntityContainer>
|
|
|
<EntityType Name="MovieLink">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
|
<Property Name="MovieID" Type="Int32" Nullable="false" />
|
|
|
<Property Name="SiteTitle" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
|
|
|
<Property Type="String" Name="DownloadSiteID" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="PageUrl" Nullable="false" MaxLength="500" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="PageSiteID" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="DowloadUrl" Nullable="false" MaxLength="500" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="LinkTitle" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="Int32" Name="FailedAttempts" Nullable="false" />
|
|
|
<Property Type="DateTime" Name="LastValidatedWhen" />
|
|
|
<Property Type="Int32" Name="Version" Nullable="false" />
|
|
|
<Property Type="Guid" Name="LastValidatedBy" />
|
|
|
<Property Type="Boolean" Name="HasSubtitle" Nullable="false" />
|
|
|
<Property Type="Boolean" Name="IsWebSupported" Nullable="false" />
|
|
|
<Property Type="Boolean" Name="IsDesktopSupported" Nullable="false" />
|
|
|
<Property Type="Int32" Name="PartID" />
|
|
|
<Property Type="Int32" Name="PartIndex" />
|
|
|
<NavigationProperty Name="Movie" Relationship="MovieFinderModel.FK_MovieLink_Movie" FromRole="MovieLink" ToRole="Movie" />
|
|
|
</EntityType>
|
|
|
<EntityType Name="Movie">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Type="Int32" Name="ID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
|
<Property Type="String" Name="Name" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="UniqueID" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="ImageUrl" MaxLength="500" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="DateTime" Name="ReleaseDate" Nullable="false" />
|
|
|
<Property Type="String" Name="LanguageCode" Nullable="false" MaxLength="2" FixedLength="true" Unicode="false" />
|
|
|
<Property Type="String" Name="Description" MaxLength="1000" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="DateTime" Name="CreateDate" Nullable="false" />
|
|
|
<Property Type="DateTime" Name="ModifiedDate" />
|
|
|
<Property Type="Int32" Name="Version" Nullable="false" />
|
|
|
<Property Type="Int32" Name="VersionChange" Nullable="false" />
|
|
|
<Property Type="String" Name="ImageScrapperID" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="ImageLocalUrl" MaxLength="500" FixedLength="false" Unicode="false" />
|
|
|
<NavigationProperty Name="MovieLinks" Relationship="MovieFinderModel.FK_MovieLink_Movie" FromRole="Movie" ToRole="MovieLink" />
|
|
|
<Property Type="Int32" Name="ViewCount" Nullable="false" />
|
|
|
<Property Type="Int32" Name="LikeCount" Nullable="false" />
|
|
|
</EntityType>
|
|
|
<Association Name="FK_MovieLink_Movie">
|
|
|
<End Type="MovieFinderModel.Movie" Role="Movie" Multiplicity="1" />
|
|
|
<End Type="MovieFinderModel.MovieLink" Role="MovieLink" Multiplicity="*" />
|
|
|
<ReferentialConstraint>
|
|
|
<Principal Role="Movie">
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Principal>
|
|
|
<Dependent Role="MovieLink">
|
|
|
<PropertyRef Name="MovieID" />
|
|
|
</Dependent>
|
|
|
</ReferentialConstraint>
|
|
|
</Association>
|
|
|
<EntityType Name="VisitorProfile">
|
|
|
<Key>
|
|
|
<PropertyRef Name="ID" />
|
|
|
</Key>
|
|
|
<Property Type="Guid" Name="ID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
|
<Property Type="Int32" Name="UserID" />
|
|
|
<Property Type="DateTime" Name="LastAccessedTime" Nullable="false" />
|
|
|
<Property Type="String" Name="LastAccessedIP" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="LastAccessedLanguage" Nullable="false" MaxLength="2" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="LastAccessedUrl" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="Int32" Name="HitCount" Nullable="false" />
|
|
|
</EntityType>
|
|
|
<EntityType Name="Plugin">
|
|
|
<Key>
|
|
|
<PropertyRef Name="GKName" />
|
|
|
</Key>
|
|
|
<Property Type="String" Name="GKName" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="String" Name="PluginName" MaxLength="75" FixedLength="false" Unicode="false" annotation:StoreGeneratedPattern="Computed" />
|
|
|
<Property Type="String" Name="SiteID" Nullable="false" MaxLength="250" FixedLength="false" Unicode="false" />
|
|
|
<Property Type="Int32" Name="LastUpdatedTime" Nullable="false" />
|
|
|
</EntityType>
|
|
|
</Schema>
|
|
|
</edmx:ConceptualModels>
|
|
|
|
|
|
<edmx:Mappings>
|
|
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
|
|
|
<EntityContainerMapping StorageEntityContainer="MovieFinderModelStoreContainer" CdmEntityContainer="MovieFinderEntities">
|
|
|
<EntitySetMapping Name="MovieLinks"><EntityTypeMapping TypeName="MovieFinderModel.MovieLink"><MappingFragment StoreEntitySet="MovieLink">
|
|
|
<ScalarProperty Name="PartIndex" ColumnName="PartIndex" />
|
|
|
<ScalarProperty Name="PartID" ColumnName="PartID" />
|
|
|
<ScalarProperty Name="IsDesktopSupported" ColumnName="IsDesktopSupported" />
|
|
|
<ScalarProperty Name="IsWebSupported" ColumnName="IsWebSupported" />
|
|
|
<ScalarProperty Name="HasSubtitle" ColumnName="HasSubtitle" />
|
|
|
<ScalarProperty Name="LastValidatedBy" ColumnName="LastValidatedBy" />
|
|
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
|
|
<ScalarProperty Name="LastValidatedWhen" ColumnName="LastValidatedWhen" />
|
|
|
<ScalarProperty Name="FailedAttempts" ColumnName="FailedAttempts" />
|
|
|
<ScalarProperty Name="LinkTitle" ColumnName="LinkTitle" />
|
|
|
<ScalarProperty Name="DowloadUrl" ColumnName="DowloadUrl" />
|
|
|
<ScalarProperty Name="PageSiteID" ColumnName="PageSiteID" />
|
|
|
<ScalarProperty Name="PageUrl" ColumnName="PageUrl" />
|
|
|
<ScalarProperty Name="DownloadSiteID" ColumnName="DownloadSiteID" />
|
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
|
<ScalarProperty Name="MovieID" ColumnName="MovieID" />
|
|
|
<ScalarProperty Name="SiteTitle" ColumnName="SiteTitle" />
|
|
|
</MappingFragment></EntityTypeMapping></EntitySetMapping>
|
|
|
<EntitySetMapping Name="Movies">
|
|
|
<EntityTypeMapping TypeName="MovieFinderModel.Movie">
|
|
|
<MappingFragment StoreEntitySet="Movie">
|
|
|
<ScalarProperty Name="LikeCount" ColumnName="LikeCount" />
|
|
|
<ScalarProperty Name="ViewCount" ColumnName="ViewCount" />
|
|
|
<ScalarProperty Name="ImageLocalUrl" ColumnName="ImageLocalUrl" />
|
|
|
<ScalarProperty Name="ImageScrapperID" ColumnName="ImageScrapperID" />
|
|
|
<ScalarProperty Name="VersionChange" ColumnName="VersionChange" />
|
|
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
|
|
<ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
|
|
|
<ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
|
|
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
|
|
<ScalarProperty Name="LanguageCode" ColumnName="LanguageCode" />
|
|
|
<ScalarProperty Name="ReleaseDate" ColumnName="ReleaseDate" />
|
|
|
<ScalarProperty Name="ImageUrl" ColumnName="ImageUrl" />
|
|
|
<ScalarProperty Name="UniqueID" ColumnName="UniqueID" />
|
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
|
</MappingFragment>
|
|
|
</EntityTypeMapping>
|
|
|
</EntitySetMapping>
|
|
|
<EntitySetMapping Name="VisitorProfiles">
|
|
|
<EntityTypeMapping TypeName="MovieFinderModel.VisitorProfile">
|
|
|
<MappingFragment StoreEntitySet="VisitorProfile">
|
|
|
<ScalarProperty Name="HitCount" ColumnName="HitCount" />
|
|
|
<ScalarProperty Name="LastAccessedUrl" ColumnName="LastAccessedUrl" />
|
|
|
<ScalarProperty Name="LastAccessedLanguage" ColumnName="LastAccessedLanguage" />
|
|
|
<ScalarProperty Name="LastAccessedIP" ColumnName="LastAccessedIP" />
|
|
|
<ScalarProperty Name="LastAccessedTime" ColumnName="LastAccessedTime" />
|
|
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
|
</MappingFragment>
|
|
|
</EntityTypeMapping>
|
|
|
</EntitySetMapping>
|
|
|
<EntitySetMapping Name="Plugins">
|
|
|
<EntityTypeMapping TypeName="MovieFinderModel.Plugin">
|
|
|
<MappingFragment StoreEntitySet="Plugin">
|
|
|
<ScalarProperty Name="LastUpdatedTime" ColumnName="LastUpdatedTime" />
|
|
|
<ScalarProperty Name="SiteID" ColumnName="SiteID" />
|
|
|
<ScalarProperty Name="PluginName" ColumnName="PluginName" />
|
|
|
<ScalarProperty Name="GKName" ColumnName="GKName" />
|
|
|
</MappingFragment>
|
|
|
</EntityTypeMapping>
|
|
|
</EntitySetMapping>
|
|
|
</EntityContainerMapping>
|
|
|
</Mapping>
|
|
|
</edmx:Mappings>
|
|
|
</edmx:Runtime>
|
|
|
|
|
|
<Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
|
|
|
<Connection>
|
|
|
<DesignerInfoPropertySet>
|
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|
|
</DesignerInfoPropertySet>
|
|
|
</Connection>
|
|
|
<Options>
|
|
|
<DesignerInfoPropertySet>
|
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|
|
<DesignerProperty Name="EnablePluralization" Value="True" />
|
|
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
|
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="None" />
|
|
|
</DesignerInfoPropertySet>
|
|
|
</Options>
|
|
|
|
|
|
<Diagrams>
|
|
|
<Diagram Name="MovieDB">
|
|
|
<EntityTypeShape EntityType="MovieFinderModel.MovieLink" Width="1.5" PointX="3" PointY="1.5" Height="2.7494921874999996" IsExpanded="true" />
|
|
|
<EntityTypeShape EntityType="MovieFinderModel.Movie" Width="1.5" PointX="0.75" PointY="1.875" Height="3.7109993489583317" />
|
|
|
<AssociationConnector Association="MovieFinderModel.FK_MovieLink_Movie" >
|
|
|
<ConnectorPoint PointX="2.25" PointY="3.7304996744791659" />
|
|
|
<ConnectorPoint PointX="3" PointY="3.7304996744791659" />
|
|
|
</AssociationConnector>
|
|
|
<EntityTypeShape EntityType="MovieFinderModel.VisitorProfile" Width="1.5" PointX="5.375" PointY="3.75" Height="2.3648893229166656" />
|
|
|
<EntityTypeShape EntityType="MovieFinderModel.Plugin" Width="1.5" PointX="5.375" PointY="0.75" Height="1.7879850260416674" />
|
|
|
</Diagram>
|
|
|
</Diagrams>
|
|
|
</Designer>
|
|
|
</edmx:Edmx> |
