commit 6b1518863e1d8e2bacf20f82aba64c72a879a86f
Author: Martin Szulecki <[email protected]>
Date: Tue Jul 27 15:30:55 2010 +0200
[sqlitedb] Remove the i_tunes_u column to fix a post process error
This column is created by the post process commands defined by the
device on demand.
src/itdb_sqlite_queries.h | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/src/itdb_sqlite_queries.h b/src/itdb_sqlite_queries.h
index 630ce0f..fd674a4 100644
--- a/src/itdb_sqlite_queries.h
+++ b/src/itdb_sqlite_queries.h
@@ -50,7 +50,7 @@ static const char Library_create[] =
"BEGIN TRANSACTION;" \
"CREATE TABLE version_info (id INTEGER PRIMARY KEY, major INTEGER,
minor INTEGER, compatibility INTEGER DEFAULT 0, update_level INTEGER DEFAULT 0,
device_update_level INTEGER DEFAULT 0, platform INTEGER DEFAULT 0);" \
"CREATE TABLE db_info (pid INTEGER NOT NULL, primary_container_pid
INTEGER, media_folder_url TEXT, audio_language INTEGER, subtitle_language
INTEGER, genius_cuid TEXT, bib BLOB, rib BLOB, PRIMARY KEY (pid));" \
- "CREATE TABLE item (pid INTEGER NOT NULL, revision_level INTEGER,
media_kind INTEGER DEFAULT 0, is_song INTEGER DEFAULT 0, is_audio_book INTEGER
DEFAULT 0, is_music_video INTEGER DEFAULT 0, is_movie INTEGER DEFAULT 0,
is_tv_show INTEGER DEFAULT 0, is_ringtone INTEGER DEFAULT 0, is_voice_memo
INTEGER DEFAULT 0, is_rental INTEGER DEFAULT 0, is_itunes_u INTEGER DEFAULT 0,
is_podcast INTEGER DEFAULT 0, date_modified INTEGER DEFAULT 0, date_backed_up
INTEGER DEFAULT 0, year INTEGER DEFAULT 0, content_rating INTEGER DEFAULT 0,
content_rating_level INTEGER DEFAULT 0, is_compilation INTEGER,
is_user_disabled INTEGER DEFAULT 0, remember_bookmark INTEGER DEFAULT 0,
exclude_from_shuffle INTEGER DEFAULT 0, part_of_gapless_album INTEGER DEFAULT
0, artwork_status INTEGER, artwork_cache_id INTEGER DEFAULT 0, start_time_ms
REAL DEFAULT 0, stop_time_ms REAL DEFAULT 0, total_time_ms REAL DEFAULT 0,
total_burn_time_ms REAL, track_number INTEGER DEFAULT 0, track_count INTEGER
DEFAULT 0, disc_number INTEGER DEFAULT 0, disc_count INTEGER DEFAULT 0, bpm
INTEGER DEFAULT 0, relative_volume INTEGER, eq_preset TEXT, radio_stream_status
TEXT, genius_id INTEGER DEFAULT 0, genre_id INTEGER DEFAULT 0, category_id
INTEGER DEFAULT 0, album_pid INTEGER DEFAULT 0, artist_pid INTEGER DEFAULT 0,
composer_pid INTEGER DEFAULT 0, title TEXT, artist TEXT, album TEXT,
album_artist TEXT, composer TEXT, sort_title TEXT, sort_artist TEXT, sort_album
TEXT, sort_album_artist TEXT, sort_composer TEXT, title_order INTEGER,
artist_order INTEGER, album_order INTEGER, genre_order INTEGER, composer_order
INTEGER, album_artist_order INTEGER, album_by_artist_order INTEGER,
series_name_order INTEGER, comment TEXT, grouping TEXT, description TEXT,
description_long TEXT, PRIMARY KEY (pid));" \
+ "CREATE TABLE item (pid INTEGER NOT NULL, revision_level INTEGER,
media_kind INTEGER DEFAULT 0, is_song INTEGER DEFAULT 0, is_audio_book INTEGER
DEFAULT 0, is_music_video INTEGER DEFAULT 0, is_movie INTEGER DEFAULT 0,
is_tv_show INTEGER DEFAULT 0, is_ringtone INTEGER DEFAULT 0, is_voice_memo
INTEGER DEFAULT 0, is_rental INTEGER DEFAULT 0, is_podcast INTEGER DEFAULT 0,
date_modified INTEGER DEFAULT 0, date_backed_up INTEGER DEFAULT 0, year INTEGER
DEFAULT 0, content_rating INTEGER DEFAULT 0, content_rating_level INTEGER
DEFAULT 0, is_compilation INTEGER, is_user_disabled INTEGER DEFAULT 0,
remember_bookmark INTEGER DEFAULT 0, exclude_from_shuffle INTEGER DEFAULT 0,
part_of_gapless_album INTEGER DEFAULT 0, artwork_status INTEGER,
artwork_cache_id INTEGER DEFAULT 0, start_time_ms REAL DEFAULT 0, stop_time_ms
REAL DEFAULT 0, total_time_ms REAL DEFAULT 0, total_burn_time_ms REAL,
track_number INTEGER DEFAULT 0, track_count INTEGER DEFAULT 0, disc_number
INTEGER DEFAULT 0, disc_count INTEGER DEFAULT 0, bpm INTEGER DEFAULT 0,
relative_volume INTEGER, eq_preset TEXT, radio_stream_status TEXT, genius_id
INTEGER DEFAULT 0, genre_id INTEGER DEFAULT 0, category_id INTEGER DEFAULT 0,
album_pid INTEGER DEFAULT 0, artist_pid INTEGER DEFAULT 0, composer_pid INTEGER
DEFAULT 0, title TEXT, artist TEXT, album TEXT, album_artist TEXT, composer
TEXT, sort_title TEXT, sort_artist TEXT, sort_album TEXT, sort_album_artist
TEXT, sort_composer TEXT, title_order INTEGER, artist_order INTEGER,
album_order INTEGER, genre_order INTEGER, composer_order INTEGER,
album_artist_order INTEGER, album_by_artist_order INTEGER, series_name_order
INTEGER, comment TEXT, grouping TEXT, description TEXT, description_long TEXT,
PRIMARY KEY (pid));" \
"CREATE TABLE avformat_info (item_pid INTEGER NOT NULL, sub_id INTEGER
NOT NULL DEFAULT 0, audio_format INTEGER, bit_rate INTEGER DEFAULT 0,
sample_rate REAL DEFAULT 0, duration INTEGER, gapless_heuristic_info INTEGER,
gapless_encoding_delay INTEGER, gapless_encoding_drain INTEGER,
gapless_last_frame_resynch INTEGER, analysis_inhibit_flags INTEGER,
audio_fingerprint INTEGER, volume_normalization_energy INTEGER, PRIMARY KEY
(item_pid,sub_id));" \
"CREATE TABLE video_info (item_pid INTEGER NOT NULL,
has_alternate_audio INTEGER, has_subtitles INTEGER, characteristics_valid
INTEGER, has_closed_captions INTEGER, is_self_contained INTEGER, is_compressed
INTEGER, is_anamorphic INTEGER, season_number INTEGER, audio_language INTEGER,
audio_track_index INTEGER, audio_track_id INTEGER, subtitle_language INTEGER,
subtitle_track_index INTEGER, subtitle_track_id INTEGER, series_name TEXT,
sort_series_name TEXT, episode_id TEXT, episode_sort_id INTEGER, network_name
TEXT, extended_content_rating TEXT, movie_info TEXT, PRIMARY KEY (item_pid));" \
"CREATE TABLE video_characteristics (item_pid INTEGER, sub_id INTEGER
DEFAULT 0, track_id INTEGER, height INTEGER, width INTEGER, depth INTEGER,
codec INTEGER, frame_rate REAL, percentage_encrypted REAL, bit_rate INTEGER,
peak_bit_rate INTEGER, buffer_size INTEGER, profile INTEGER, level INTEGER,
complexity_level INTEGER, UNIQUE (item_pid,sub_id,track_id));" \
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
gtkpod-cvs2 mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/gtkpod-cvs2
