Update of /cvsroot/freevo/freevo/lib/pyepg
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31373/lib/pyepg
Modified Files:
epg_schema.sql
Log Message:
-Remove admin table in favour of versioning table.
-Update the DB version to 0.1.1.
-create index programs_title on programs (title):
This makes text searches on title, as used in favorites checking, much faster.
Index: epg_schema.sql
===================================================================
RCS file: /cvsroot/freevo/freevo/lib/pyepg/epg_schema.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** epg_schema.sql 14 Feb 2005 15:12:56 -0000 1.5
--- epg_schema.sql 24 Mar 2005 17:54:25 -0000 1.6
***************
*** 1,8 ****
! drop table admin;
! create table admin (
! version text primary key
);
! insert into admin (version) values ("0.1.0");
drop table channels;
--- 1,9 ----
! drop table versioning;
! create table versioning (
! thing text primary key,
! version text,
);
! insert into versioning (thing, version) values ("sql", "0.1.1");
drop table channels;
***************
*** 43,46 ****
--- 44,48 ----
create index programs_start on programs (start);
create index programs_stop on programs (stop);
+ create index programs_title on programs (title);
drop table categories;
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Freevo-cvslog mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/freevo-cvslog
