home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Area 51 - Testing Area
Rework of SQLite wrapper
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="disaster123" data-source="post: 834028" data-attributes="member: 74707"><p><strong>AW: Rework of SQLite wrapper</strong></p><p></p><p>Part 1:</p><p>[CODE]</p><p>sqlite> SELECT sql FROM sqlite_master WHERE name='local_episodes';</p><p>CREATE TABLE local_episodes (EpisodeFilename String primary key, OriginalComposi</p><p>te String, CompositeID String, SeriesID Int, SeasonIndex Int, EpisodeIndex Int,</p><p>LocalEpisodeName String, LocalImportProcessed Int, CompositeUpdated Int, Availab</p><p>leSubtitles String, OriginalComposite2 String, CompositeID2 String, EpisodeIndex</p><p>2 Int, videoWidth Int, videoHeight Int, FileDateAdded String, FileDateCreated St</p><p>ring, IsAvailable Int, ext String, Removable String, localPlaytime String, Video</p><p>Codec String, VideoFormat String, VideoFormatProfile String, VideoBitrate String</p><p>, VideoFrameRate String, VideoAspectRatio String, AudioCodec String, AudioFormat</p><p> String, AudioFormatProfile String, AudioBitrate String, AudioChannels String, A</p><p>udioTracks String, TextCount String, StopTime String, VolumeLabel String, DateWa</p><p>tched String, FirstAired String)</p><p>[/CODE]</p><p></p><p>Part 2:</p><p>[CODE]</p><p>sqlite> SELECT sql FROM sqlite_master WHERE name='online_episodes';</p><p>CREATE TABLE online_episodes (CompositeID String primary key, EpisodeID Int, Ser</p><p>iesID Int, EpisodeIndex Int, SeasonIndex Int, EpisodeName String, Watched Int, S</p><p>ummary String, FirstAired String, OnlineDataImported Int, GuestStars String, Dir</p><p>ector String, Writer String, Hidden Int, lastupdated String, DownloadPending Int</p><p>, DownloadExpectedName String, ThumbUrl String, thumbFilename String, Combined_e</p><p>pisodenumber String, Combined_season String, DVD_chapter String, DVD_discid Stri</p><p>ng, DVD_episodenumber String, DVD_season String, EpImgFlag String, IMDB_ID Strin</p><p>g, Language String, ProductionCode String, Rating String, absolute_number String</p><p>, seasonid String, airsafter_season String, airsbefore_episode String, airsbefor</p><p>e_season String, RatingCount String, TraktSeen Int, TraktLibrary Int, follwit_id</p><p> Int)</p><p>[/CODE]</p><p></p><p></p><p>Hope it helps!</p></blockquote><p></p>
[QUOTE="disaster123, post: 834028, member: 74707"] [b]AW: Rework of SQLite wrapper[/b] Part 1: [CODE] sqlite> SELECT sql FROM sqlite_master WHERE name='local_episodes'; CREATE TABLE local_episodes (EpisodeFilename String primary key, OriginalComposi te String, CompositeID String, SeriesID Int, SeasonIndex Int, EpisodeIndex Int, LocalEpisodeName String, LocalImportProcessed Int, CompositeUpdated Int, Availab leSubtitles String, OriginalComposite2 String, CompositeID2 String, EpisodeIndex 2 Int, videoWidth Int, videoHeight Int, FileDateAdded String, FileDateCreated St ring, IsAvailable Int, ext String, Removable String, localPlaytime String, Video Codec String, VideoFormat String, VideoFormatProfile String, VideoBitrate String , VideoFrameRate String, VideoAspectRatio String, AudioCodec String, AudioFormat String, AudioFormatProfile String, AudioBitrate String, AudioChannels String, A udioTracks String, TextCount String, StopTime String, VolumeLabel String, DateWa tched String, FirstAired String) [/CODE] Part 2: [CODE] sqlite> SELECT sql FROM sqlite_master WHERE name='online_episodes'; CREATE TABLE online_episodes (CompositeID String primary key, EpisodeID Int, Ser iesID Int, EpisodeIndex Int, SeasonIndex Int, EpisodeName String, Watched Int, S ummary String, FirstAired String, OnlineDataImported Int, GuestStars String, Dir ector String, Writer String, Hidden Int, lastupdated String, DownloadPending Int , DownloadExpectedName String, ThumbUrl String, thumbFilename String, Combined_e pisodenumber String, Combined_season String, DVD_chapter String, DVD_discid Stri ng, DVD_episodenumber String, DVD_season String, EpImgFlag String, IMDB_ID Strin g, Language String, ProductionCode String, Rating String, absolute_number String , seasonid String, airsafter_season String, airsbefore_episode String, airsbefor e_season String, RatingCount String, TraktSeen Int, TraktLibrary Int, follwit_id Int) [/CODE] Hope it helps! [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Area 51 - Testing Area
Rework of SQLite wrapper
Contact us
RSS
Top
Bottom