| System: |
 |
| Body: |
|
Fields
| idMovie |
integer |
| idSource |
integer |
| MoviePath |
text |
| Type |
bool |
| HasSub |
bool |
| New |
bool |
| Mark |
bool |
| Imdb |
text |
| Lock |
bool |
| Title |
text |
| OriginalTitle |
text |
| Year |
text |
| Rating |
text |
| Votes |
text |
| MPAA |
text |
| Top250 |
integer |
| Outline |
text |
| Plot |
text |
| Tagline |
text |
| Certification |
text |
| Runtime |
text |
| premiered |
text |
| Playcount |
integer |
| Trailer |
text |
| EThumbsPath |
text |
| NfoPath |
text |
| TrailerPath |
text |
| SubPath |
text |
| FanartURL |
text |
| OutOfTolerance |
bool |
| VideoSource |
text |
| SortTitle |
text |
| DateAdded |
integer |
| EFanartsPath |
text |
| ThemePath |
text |
| TMDB |
text |
| TMDBColID |
text |
| DateModified |
integer |
| MarkCustom1 |
bool |
| MarkCustom2 |
bool |
| MarkCustom3 |
bool |
| MarkCustom4 |
bool |
| HasSet |
bool |
| iLastPlayed |
integer |
| Language |
text |
| iUserRating |
integer |
| userNote |
text |
| edition |
text |
| SortedTitle |
|
| Source |
text |
| BannerPath |
text |
| ClearArtPath |
text |
| ClearLogoPath |
text |
| DiscArtPath |
text |
| FanartPath |
text |
| KeyartPath |
text |
| LandscapePath |
text |
| PosterPath |
text |
| Country |
|
| Credits |
|
| Director |
|
| Genre |
|
| Studio |
|
| Tag |
|
Triggers
There are no triggers for view "movie-dateadded"
Definition:
CREATE VIEW "movie-DateAdded"
AS
SELECT * FROM movielist ORDER BY DateAdded DESC;
