public ArchivedArtistVersionMap()
{
Id(m => m.Id);
Map(m => m.AgentName).Not.Nullable();
Map(m => m.Created).Not.Nullable();
Map(m => m.Data).Not.Nullable();
Map(m => m.Hidden).Not.Nullable();
Map(m => m.Notes).Length(200).Not.Nullable();
Map(m => m.PictureMime).Length(32).Nullable();
Map(m => m.Reason).Length(30).Not.Nullable();
Map(m => m.Status).Not.Nullable();
Map(m => m.Version).Not.Nullable();
References(m => m.Artist);
References(m => m.Author);
Component(m => m.Diff, c => {
c.Map(m => m.ChangedFieldsString, ClassConventions.EscapeColumn("ChangedFields")).Length(1000).Not.Nullable();
c.Map(m => m.IsSnapshot).Not.Nullable();
});
Component(m => m.Picture, c => {
c.Map(m => m.Bytes, "PictureBytes").Length(int.MaxValue);
}).LazyLoad();
}
public ArchivedSongVersionMap()
{
Id(m => m.Id);
Map(m => m.AgentName).Length(100).Not.Nullable();
Map(m => m.Created).Not.Nullable();
Map(m => m.Data).Not.Nullable();
Map(m => m.Notes).Length(200).Not.Nullable();
Map(m => m.Reason).Length(30).Not.Nullable();
Map(m => m.Status).Not.Nullable();
Map(m => m.Version).Not.Nullable();
References(m => m.Author);
References(m => m.Song);
Component(m => m.Diff, c => {
c.Map(m => m.ChangedFieldsString, ClassConventions.EscapeColumn("ChangedFields")).Length(1000).Not.Nullable();
c.Map(m => m.IsSnapshot).Not.Nullable();
});
}
public SongMap()
{
Cache.ReadWrite();
Id(m => m.Id);
Map(m => m.CreateDate).Not.Nullable();
Map(m => m.Deleted).Not.Nullable();
Map(m => m.FavoritedTimes).Not.Nullable();
Map(m => m.LengthSeconds).Not.Nullable();
Map(m => m.NicoId).Nullable();
Map(m => m.PersonalDescriptionAuthorId).Column(ClassConventions.EscapeColumn("PersonalDescriptionAuthor")).Nullable();
Map(m => m.PersonalDescriptionText).Nullable();
Map(m => m.PVServices).CustomType(typeof(PVServices)).Not.Nullable();
Map(m => m.RatingScore).Not.Nullable();
Map(m => m.SongType).Not.Nullable();
Map(m => m.Status).CustomType(typeof(EntryStatus)).Not.Nullable();
Map(m => m.ThumbUrl).Length(255).Nullable();
Map(m => m.Version).Not.Nullable();
References(m => m.OriginalVersion).Nullable();
References(m => m.ReleaseEvent).Nullable();
Component(m => m.ArchivedVersionsManager,
c => c.HasMany(m => m.Versions).KeyColumn("[Song]").Inverse().Cascade.All().OrderBy("Created DESC"));
Component(m => m.Names, c => {
c.Map(m => m.AdditionalNamesString).Not.Nullable().Length(1024);
c.HasMany(m => m.Names).Table("SongNames").KeyColumn("[Song]").Inverse().Cascade.All().Cache.ReadWrite();
c.Component(m => m.SortNames, c2 => {
c2.Map(m => m.DefaultLanguage, "DefaultNameLanguage");
c2.Map(m => m.Japanese, "JapaneseName");
c2.Map(m => m.English, "EnglishName");
c2.Map(m => m.Romaji, "RomajiName");
});
});
Component(m => m.Notes, c => {
c.Map(m => m.Original).Column("Notes").Not.Nullable().Length(int.MaxValue);
c.Map(m => m.English).Column("NotesEng").Not.Nullable().Length(int.MaxValue);
});
Component(m => m.PublishDate, c => c.Map(m => m.DateTime).Column("PublishDate").Nullable());
Component(m => m.PVs, c => {
c.HasMany(m => m.PVs).KeyColumn("[Song]").Inverse().Cascade.All().Cache.ReadWrite();
});
Component(m => m.Tags, c => {
c.HasMany(m => m.Usages).KeyColumn("[Song]").Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
});
Component(m => m.ArtistString, c => {
c.Map(m => m.Japanese, "ArtistString").Length(500).Not.Nullable();
c.Map(m => m.Romaji, "ArtistStringRomaji").Length(500).Not.Nullable();
c.Map(m => m.English, "ArtistStringEnglish").Length(500).Not.Nullable();
c.Map(m => m.Default, "ArtistStringDefault").Length(500).Not.Nullable();
});
HasMany(m => m.AllAlbums).Table("SongsInAlbums").Inverse().Cascade.All().Cache.ReadWrite();
HasMany(m => m.AllAlternateVersions).KeyColumn("[OriginalVersion]").Inverse().Cache.ReadWrite();
HasMany(m => m.AllArtists).Table("ArtistsForSongs").Inverse().Cascade.All().Cache.ReadWrite();
HasMany(m => m.Comments).Inverse().Cascade.AllDeleteOrphan().OrderBy("Created");
HasMany(m => m.Hits).Inverse();
HasMany(m => m.ListLinks).Inverse();
HasMany(m => m.Lyrics).Inverse().Cascade.All().Cache.ReadWrite();
HasMany(m => m.UserFavorites).Inverse();
HasMany(m => m.WebLinks).Table("SongWebLinks").Inverse().Cascade.All().Cache.ReadWrite();
}
public AlbumMap() {
Cache.ReadWrite();
Id(m => m.Id);
Map(m => m.CoverPictureMime).Length(32).Nullable();
Map(m => m.CreateDate).Not.Nullable();
Map(m => m.Deleted).Not.Nullable();
Map(m => m.DiscType).Column("[Type]").Not.Nullable();
Map(m => m.PersonalDescriptionAuthorId).Column(ClassConventions.EscapeColumn("PersonalDescriptionAuthor")).Nullable();
Map(m => m.PersonalDescriptionText).Nullable();
Map(m => m.RatingAverageInt).Column("[RatingAverage]").Not.Nullable();
Map(m => m.RatingCount).Not.Nullable();
Map(m => m.RatingTotal).Not.Nullable();
Map(m => m.Status).Not.Nullable();
Map(m => m.Version).Not.Nullable();
Component(m => m.ArchivedVersionsManager,
c => c.HasMany(m => m.Versions).KeyColumn("[Album]").Inverse().Cascade.All().OrderBy("Created DESC"));
Component(m => m.ArtistString, c => {
c.Map(m => m.Japanese, "ArtistString").Length(500).Not.Nullable();
c.Map(m => m.Romaji, "ArtistStringRomaji").Length(500).Not.Nullable();
c.Map(m => m.English, "ArtistStringEnglish").Length(500).Not.Nullable();
c.Map(m => m.Default, "ArtistStringDefault").Length(500).Not.Nullable();
});
Component(m => m.CoverPictureData, c => {
c.Map(m => m.Bytes, "CoverPictureBytes").Length(int.MaxValue);
c.Component(m => m.Thumb250, c2 => c2.Map(m => m.Bytes, "CoverPictureThumb250Bytes").Length(int.MaxValue));
}).LazyLoad();
Component(m => m.Description, c => {
c.Map(m => m.Original).Column("Description").Not.Nullable().Length(int.MaxValue);
c.Map(m => m.English).Column("DescriptionEng").Not.Nullable().Length(int.MaxValue);
});
Component(m => m.OriginalRelease, c => {
c.Map(m => m.CatNum, "ReleaseCatNum");
c.References(m => m.ReleaseEvent).Nullable();
c.Component(m => m.ReleaseDate, c2 => {
c2.Map(m => m.Year, "ReleaseYear");
c2.Map(m => m.Month, "ReleaseMonth");
c2.Map(m => m.Day, "ReleaseDay");
});
});
Component(m => m.Names, c => {
c.Map(m => m.AdditionalNamesString).Not.Nullable().Length(1024);
c.HasMany(m => m.Names).Table("AlbumNames").KeyColumn("[Album]").Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
c.Component(m => m.SortNames, c2 => {
c2.Map(m => m.DefaultLanguage, "DefaultNameLanguage");
c2.Map(m => m.Japanese, "JapaneseName");
c2.Map(m => m.English, "EnglishName");
c2.Map(m => m.Romaji, "RomajiName");
//c.Map(m => m.Other, "OtherName");
});
});
Component(m => m.Pictures, c => {
c.HasMany(m => m.Pictures).KeyColumn("[Album]").Inverse().Cascade.All().Cache.ReadWrite();
});
Component(m => m.Tags, c => {
c.HasMany(m => m.Usages).Table("AlbumTagUsages").KeyColumn("[Album]").Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
});
HasMany(m => m.AllArtists).Table("ArtistsForAlbums").Inverse().Cascade.All().Cache.ReadWrite();
HasMany(m => m.AllSongs).Inverse().Cascade.All().OrderBy("DiscNumber, TrackNumber").Cache.ReadWrite();
HasMany(m => m.Comments).Inverse().Cascade.AllDeleteOrphan().OrderBy("Created");
HasMany(m => m.Discs).Inverse().Cascade.AllDeleteOrphan().OrderBy("DiscNumber").Cache.ReadWrite();
HasMany(m => m.Hits).Inverse().Cascade.AllDeleteOrphan();
HasMany(m => m.Identifiers).Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
HasMany(m => m.OtherArtists).Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
HasMany(m => m.PVs).Inverse().Cascade.AllDeleteOrphan();
HasMany(m => m.UserCollections).Inverse().Cache.ReadWrite();
HasMany(m => m.WebLinks).Table("AlbumWebLinks").Inverse().Cascade.AllDeleteOrphan().Cache.ReadWrite();
}