Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
tree: 642f0b501f
Fetching contributors…

Cannot retrieve contributors at this time

294 lines (294 sloc) 17.12 kb
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="AniSharpDBModel.Store" Alias="Self" Provider="System.Data.SqlServerCe.3.5" ProviderManifestToken="3.5" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
<EntityContainer Name="AniSharpDBModelStoreContainer">
<EntitySet Name="episode" EntityType="AniSharpDBModel.Store.episode" store:Type="Tables" Schema="dbo" />
<EntitySet Name="groups" EntityType="AniSharpDBModel.Store.groups" store:Type="Tables" Schema="dbo" />
<EntitySet Name="serie" EntityType="AniSharpDBModel.Store.serie" store:Type="Tables" Schema="dbo" />
<AssociationSet Name="FK_epsiode_groups" Association="AniSharpDBModel.Store.FK_epsiode_groups">
<End Role="groups" EntitySet="groups" />
<End Role="episode" EntitySet="episode" />
</AssociationSet>
<AssociationSet Name="FK_epsiode_serie" Association="AniSharpDBModel.Store.FK_epsiode_serie">
<End Role="serie" EntitySet="serie" />
<End Role="episode" EntitySet="episode" />
</AssociationSet>
</EntityContainer>
<EntityType Name="episode">
<Key>
<PropertyRef Name="animeId" />
<PropertyRef Name="episodeId" />
<PropertyRef Name="ed2k" />
</Key>
<Property Name="animeId" Type="int" Nullable="false" />
<Property Name="episodeId" Type="int" Nullable="false" />
<Property Name="groupId" Type="int" Nullable="false" />
<Property Name="size" Type="bigint" Nullable="true" />
<Property Name="ed2k" Type="nvarchar" Nullable="false" MaxLength="4000" />
<Property Name="md5" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="sha1" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="crc32" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="quality" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="source" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="videoCodec" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="videoResolution" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="dubLanguage" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="subLanguage" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="epno" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="epName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="epRomajiName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="epKanjiName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="state" Type="smallint" Nullable="true" />
</EntityType>
<EntityType Name="groups">
<Key>
<PropertyRef Name="groupsId" />
</Key>
<Property Name="groupsId" Type="int" Nullable="false" />
<Property Name="rating" Type="int" Nullable="true" />
<Property Name="name" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="shortName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="ircChannel" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="ircServer" Type="nvarchar" Nullable="true" MaxLength="4000" />
</EntityType>
<EntityType Name="serie">
<Key>
<PropertyRef Name="serienId" />
</Key>
<Property Name="serienId" Type="int" Nullable="false" />
<Property Name="type" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="category" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="romajiName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="kanjiName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="englishName" Type="nvarchar" Nullable="true" MaxLength="4000" />
<Property Name="episodes" Type="int" Nullable="true" />
<Property Name="rating" Type="int" Nullable="true" />
<Property Name="tempRating" Type="int" Nullable="true" />
<Property Name="otherName" Type="nvarchar" Nullable="false" />
<Property Name="highestNoEp" Type="int" Nullable="false" />
<Property Name="specialEpCount" Type="int" Nullable="false" />
</EntityType>
<Association Name="FK_epsiode_groups">
<End Role="groups" Type="AniSharpDBModel.Store.groups" Multiplicity="1" />
<End Role="episode" Type="AniSharpDBModel.Store.episode" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="groups">
<PropertyRef Name="groupsId" />
</Principal>
<Dependent Role="episode">
<PropertyRef Name="groupId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_epsiode_serie">
<End Role="serie" Type="AniSharpDBModel.Store.serie" Multiplicity="1" />
<End Role="episode" Type="AniSharpDBModel.Store.episode" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="serie">
<PropertyRef Name="serienId" />
</Principal>
<Dependent Role="episode">
<PropertyRef Name="animeId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema></edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="AniSharpDBModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
<EntityContainer Name="AniSharpDBEntities" annotation:LazyLoadingEnabled="true" >
<EntitySet Name="episode" EntityType="AniSharpDBModel.episode" />
<EntitySet Name="groups" EntityType="AniSharpDBModel.groups" />
<EntitySet Name="serie" EntityType="AniSharpDBModel.serie" />
<AssociationSet Name="FK_epsiode_groups" Association="AniSharpDBModel.FK_epsiode_groups">
<End Role="groups" EntitySet="groups" />
<End Role="episode" EntitySet="episode" />
</AssociationSet>
<AssociationSet Name="FK_epsiode_serie" Association="AniSharpDBModel.FK_epsiode_serie">
<End Role="serie" EntitySet="serie" />
<End Role="episode" EntitySet="episode" />
</AssociationSet>
</EntityContainer>
<EntityType Name="episode">
<Key>
<PropertyRef Name="animeId" />
<PropertyRef Name="episodeId" />
<PropertyRef Name="ed2k" />
</Key>
<Property Type="Int32" Name="animeId" Nullable="false" />
<Property Type="Int32" Name="episodeId" Nullable="false" />
<Property Type="Int32" Name="groupId" Nullable="false" />
<Property Type="Int64" Name="size" />
<Property Type="String" Name="ed2k" MaxLength="4000" FixedLength="false" Unicode="true" Nullable="false" />
<Property Type="String" Name="md5" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="sha1" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="crc32" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="quality" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="source" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="videoCodec" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="videoResolution" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="dubLanguage" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="subLanguage" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="epno" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="epName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="epRomajiName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="epKanjiName" MaxLength="4000" FixedLength="false" Unicode="true" />
<NavigationProperty Name="groups" Relationship="AniSharpDBModel.FK_epsiode_groups" FromRole="episode" ToRole="groups" />
<NavigationProperty Name="serie" Relationship="AniSharpDBModel.FK_epsiode_serie" FromRole="episode" ToRole="serie" />
<Property Type="Int16" Name="state" />
</EntityType>
<EntityType Name="groups">
<Key>
<PropertyRef Name="groupsId" />
</Key>
<Property Type="Int32" Name="groupsId" Nullable="false" />
<Property Type="Int32" Name="rating" />
<Property Type="String" Name="name" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="shortName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="ircChannel" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="ircServer" MaxLength="4000" FixedLength="false" Unicode="true" />
<NavigationProperty Name="episode" Relationship="AniSharpDBModel.FK_epsiode_groups" FromRole="groups" ToRole="episode" />
</EntityType>
<EntityType Name="serie">
<Key>
<PropertyRef Name="serienId" />
</Key>
<Property Type="Int32" Name="serienId" Nullable="false" />
<Property Type="String" Name="type" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="category" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="romajiName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="kanjiName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="String" Name="englishName" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Type="Int32" Name="episodes" />
<Property Type="Int32" Name="rating" />
<Property Type="Int32" Name="tempRating" />
<NavigationProperty Name="episode" Relationship="AniSharpDBModel.FK_epsiode_serie" FromRole="serie" ToRole="episode" />
<Property Type="String" Name="otherName" Nullable="false" />
<Property Type="Int32" Name="highestNoEp" Nullable="false" />
<Property Type="Int32" Name="specialEpCount" Nullable="false" />
</EntityType>
<Association Name="FK_epsiode_groups">
<End Type="AniSharpDBModel.groups" Role="groups" Multiplicity="1" />
<End Type="AniSharpDBModel.episode" Role="episode" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="groups">
<PropertyRef Name="groupsId" />
</Principal>
<Dependent Role="episode">
<PropertyRef Name="groupId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_epsiode_serie">
<End Type="AniSharpDBModel.serie" Role="serie" Multiplicity="1" />
<End Type="AniSharpDBModel.episode" Role="episode" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="serie">
<PropertyRef Name="serienId" />
</Principal>
<Dependent Role="episode">
<PropertyRef Name="animeId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
<EntityContainerMapping StorageEntityContainer="AniSharpDBModelStoreContainer" CdmEntityContainer="AniSharpDBEntities">
<EntitySetMapping Name="episode">
<EntityTypeMapping TypeName="IsTypeOf(AniSharpDBModel.episode)">
<MappingFragment StoreEntitySet="episode">
<ScalarProperty Name="animeId" ColumnName="animeId" />
<ScalarProperty Name="episodeId" ColumnName="episodeId" />
<ScalarProperty Name="ed2k" ColumnName="ed2k" />
<ScalarProperty Name="groupId" ColumnName="groupId" />
<ScalarProperty Name="size" ColumnName="size" />
<ScalarProperty Name="md5" ColumnName="md5" />
<ScalarProperty Name="sha1" ColumnName="sha1" />
<ScalarProperty Name="crc32" ColumnName="crc32" />
<ScalarProperty Name="quality" ColumnName="quality" />
<ScalarProperty Name="source" ColumnName="source" />
<ScalarProperty Name="videoCodec" ColumnName="videoCodec" />
<ScalarProperty Name="videoResolution" ColumnName="videoResolution" />
<ScalarProperty Name="dubLanguage" ColumnName="dubLanguage" />
<ScalarProperty Name="subLanguage" ColumnName="subLanguage" />
<ScalarProperty Name="epno" ColumnName="epno" />
<ScalarProperty Name="epName" ColumnName="epName" />
<ScalarProperty Name="epRomajiName" ColumnName="epRomajiName" />
<ScalarProperty Name="epKanjiName" ColumnName="epKanjiName" />
<ScalarProperty Name="state" ColumnName="state" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="groups">
<EntityTypeMapping TypeName="IsTypeOf(AniSharpDBModel.groups)">
<MappingFragment StoreEntitySet="groups">
<ScalarProperty Name="groupsId" ColumnName="groupsId" />
<ScalarProperty Name="rating" ColumnName="rating" />
<ScalarProperty Name="name" ColumnName="name" />
<ScalarProperty Name="shortName" ColumnName="shortName" />
<ScalarProperty Name="ircChannel" ColumnName="ircChannel" />
<ScalarProperty Name="ircServer" ColumnName="ircServer" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="serie">
<EntityTypeMapping TypeName="IsTypeOf(AniSharpDBModel.serie)">
<MappingFragment StoreEntitySet="serie">
<ScalarProperty Name="serienId" ColumnName="serienId" />
<ScalarProperty Name="type" ColumnName="type" />
<ScalarProperty Name="category" ColumnName="category" />
<ScalarProperty Name="romajiName" ColumnName="romajiName" />
<ScalarProperty Name="kanjiName" ColumnName="kanjiName" />
<ScalarProperty Name="englishName" ColumnName="englishName" />
<ScalarProperty Name="episodes" ColumnName="episodes" />
<ScalarProperty Name="rating" ColumnName="rating" />
<ScalarProperty Name="tempRating" ColumnName="tempRating" />
<ScalarProperty Name="otherName" ColumnName="otherName" />
<ScalarProperty Name="highestNoEp" ColumnName="highestNoEp" />
<ScalarProperty Name="specialEpCount" ColumnName="specialEpCount" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
</EntityContainerMapping>
</Mapping></edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<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="False" />
<DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
</DesignerInfoPropertySet>
</Options>
<!-- Diagram content (shape and connector positions) -->
<Diagrams>
<Diagram Name="AniSharpDB" ZoomLevel="94" >
<EntityTypeShape EntityType="AniSharpDBModel.episode" Width="1.5" PointX="3" PointY="1.125" Height="5.0571093749999987" />
<EntityTypeShape EntityType="AniSharpDBModel.groups" Width="1.5" PointX="0.75" PointY="2.5" Height="2.3648893229166679" />
<EntityTypeShape EntityType="AniSharpDBModel.serie" Width="1.5" PointX="0.75" PointY="7.25" Height="3.5186979166666656" />
<AssociationConnector Association="AniSharpDBModel.FK_epsiode_groups" >
<ConnectorPoint PointX="2.25" PointY="3.6824446614583337" />
<ConnectorPoint PointX="3" PointY="3.6824446614583337" />
</AssociationConnector>
<AssociationConnector Association="AniSharpDBModel.FK_epsiode_serie" >
<ConnectorPoint PointX="2.25" PointY="9.0093489583333337" />
<ConnectorPoint PointX="3.75" PointY="9.0093489583333337" />
<ConnectorPoint PointX="3.75" PointY="6.1821093749999987" />
</AssociationConnector>
</Diagram>
</Diagrams>
</Designer>
</edmx:Edmx>
Jump to Line
Something went wrong with that request. Please try again.