Update of /cvsroot/freevo/kaa/epg/src
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32511
Modified Files:
schema.py
Log Message:
update schema
Index: schema.py
===================================================================
RCS file: /cvsroot/freevo/kaa/epg/src/schema.py,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** schema.py 28 Jun 2005 17:00:30 -0000 1.2
--- schema.py 21 Aug 2005 13:57:12 -0000 1.3
***************
*** 30,34 ****
#
-----------------------------------------------------------------------------
! __all__ = [ 'schema', 'update' ]
# the complete schema
--- 30,47 ----
#
-----------------------------------------------------------------------------
! __all__ = [ 'ID', 'CHANNEL_ID', 'START', 'STOP', 'TITLE', 'EPISODE',
'SUBTITLE',
! 'DESCRIPTION', 'RATING', 'ORIGINAL_AIRDATE' ]
!
! # program table index
! ID = 0
! CHANNEL_ID = 1
! START = 2
! STOP = 3
! TITLE = 4
! EPISODE = 5
! SUBTITLE = 6
! DESCRIPTION = 7
! RATING = 8
! ORIGINAL_AIRDATE = 9
# the complete schema
***************
*** 39,43 ****
version text
);
! insert into versioning (thing, version) values ("sql", "0.1.1");
create table channels (
--- 52,56 ----
version text
);
! insert into versioning (thing, version) values ("sql", "0.2");
create table channels (
***************
*** 128,139 ****
);
'''
-
- # internal update list between versions
- update = {
- '0.1.1': '''
- drop table admin;
- create table versioning (thing text primary key, version text);
- insert into versioning (thing, version) values ("sql", "0.1.1");
- create index p_title on programs (title);
- '''
- }
--- 141,142 ----
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Freevo-cvslog mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/freevo-cvslog
