Update of /cvsroot/freevo/freevo/helpers
In directory sc8-pr-cvs1:/tmp/cvs-serv30638/helpers
Modified Files:
musicsqlimport.py
Log Message:
Require MD5 to be a unique key.
Index: musicsqlimport.py
===================================================================
RCS file: /cvsroot/freevo/freevo/helpers/musicsqlimport.py,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** musicsqlimport.py 30 Jun 2003 05:08:13 -0000 1.3
--- musicsqlimport.py 30 Jun 2003 20:08:32 -0000 1.4
***************
*** 52,56 ****
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(33), path VARCHAR(255), filename VARCHAR(255), type
VARCHAR(3), artist VARCHAR(255), title VARCHAR(255), album VARCHAR(255), year
VARCHAR(255), track NUMERIC(3), track_total NUMERIC(3), bpm NUMERIC(3), last_play
float, play_count NUMERIC, start_time VARCHAR, end_time VARCHAR, rating NUMERIC, eq
VARCHAR)")
db.commit()
db.close()
--- 52,56 ----
db = sqlite.connect(DATABASE)
cursor = db.cursor()
! cursor.execute("CREATE TABLE music (id INTEGER PRIMARY KEY, dirtitle
VARCHAR(255), md5 VARCHAR(32) UNIQUE, path VARCHAR(255), filename VARCHAR(255), type
VARCHAR(3), artist VARCHAR(255), title VARCHAR(255), album VARCHAR(255), year
VARCHAR(255), track NUMERIC(3), track_total NUMERIC(3), bpm NUMERIC(3), last_play
float, play_count NUMERIC, start_time VARCHAR, end_time VARCHAR, rating NUMERIC, eq
VARCHAR)")
db.commit()
db.close()
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
Freevo-cvslog mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/freevo-cvslog
