Hi All,
I am working on sqlite database schema for Music/Track files. I am
posting few tables schema here.
CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
UNIQUE(file_path));
CREATE TABLE if not exists AlbumTbl
On Thu, Nov 7, 2013 at 11:50 AM, dd wrote:
> CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
> AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
> UNIQUE(file_path));
>
Some years ago i worked on something similar to keep track of my multimedia
collection and i a
Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
ad this to my schema.
On Thu, Nov 7, 2013 at 3:07 PM, Stephan Beal wrote:
> On Thu, Nov 7, 2013 at 11:50 AM, dd wrote:
>
>> CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
>> AUTOINCREMENT, file_path TEXT NOT NUL
On Thu, Nov 7, 2013 at 12:15 PM, dd wrote:
> Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
> ad this to my schema.
>
If you're only storing the list for local use on one machine, adding the
media ID is almost certainly overkill, but i found it useful for my
lots-of-externa
It has to work with multiple devices in future. This is valid point
for me. Thanks.
On Thu, Nov 7, 2013 at 3:42 PM, Stephan Beal wrote:
> On Thu, Nov 7, 2013 at 12:15 PM, dd wrote:
>
>> Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
>> ad this to my schema.
>>
>
> If you're
On Thu, 7 Nov 2013 14:50:44 +0400
dd wrote:
> I am working on sqlite database schema for Music/Track files. I am
> posting few tables schema here.
>
> CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
> AUTOINCREMENT, file_path TEXT NOT NULL, file_type INTEGER NOT NULL,
> UNIQUE(f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/11/13 19:47, James K. Lowden wrote:
> You might guess from my email domain name that I take an interest in
> posts like yours. And it's pretty good first cut, no pun intended.
> ;-)
It is also worthwhile looking at musicbrainz
http://musicb
Hi James K. Lowden,
Sorry. My backup application pulls tracks from albums and upload to
server. Here, I need to store these Albums and Tracks information into
database. From my application point of view, Every Track is a
file.File may be track. When same track avail with different albums,
then d
On 2013/11/08 05:47, James K. Lowden wrote:
Not that you asked, but I also suggest you consider dropping the "Tbl" from the table names. Noting that at table is a table in
its name is like calling every file "data". It makes it harder to read and conveys no information. I myself prefer plurals fo
9 matches
Mail list logo
