dhis2-users team mailing list archive

Thread
Date

Re: Quick way to add missing ISO weeks going back to 2011?

To: Jason Pickering <jason.p.pickering@xxxxxxxxx>
From: Bob Jolliffe <bobjolliffe@xxxxxxxxx>
Date: Wed, 6 Aug 2014 10:48:02 +0100
Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>, Ismail Yusuf <ismailkoleleni@xxxxxxxxx>
In-reply-to: <CADsNmhvypN6GiWXT857c=eHEQD2-syJ5vPOm+mU6C3Nh1tNSMQ@mail.gmail.com>

@Jason, no, sadly, I don't think tcl is more mainstream anymore.  Anyway
attached php, which I know some of the guys in Rwanda use

@Randy, Jason is right about the period type.  I think for the moment you
are going to have to "pretend" that the iso and epi weeks are the same.  We
should really solve this.

In case its at all useful I've attached sql script that inserts all the
weeks from 2000 to 2014 (including 53 week years).  You could edit this and
cut out the years you are interested in.

Bob

On 6 August 2014 06:54, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:

> Hi Randy,
>
> @Bob, yes, Tcl is much more mainstream. :) But as Lars points out, there
> is no need to create these manually if you are just importing data, as they
> will be created automatically anyway.
>
>
>
> @Randy, simply adding a new period type to the periottype table will not
> work. There is a lot of code behind each period , so if the particular
> period which you have is not implemented, then it will have to be
> implemented in Java. Morten has done a lot of work on this lately but this
> period type is not there yet I think.
>
> I am pretty sure this issue has been discussed before on the list, of so
> called "Epi weeks". There have also been requests for other weeks, starting
> on Wednesday as well. As of now, there is no solution for this.
>
> Best regards,
> Jason
>
>
>
>
>
>
>
> On Tue, Aug 5, 2014 at 2:21 PM, Wilson, Randy <rwilson@xxxxxxx> wrote:
>
>> Hi Bob and Jason,
>>
>> Thanks for these quick responses - I also noticed that ISO weeks and
>> Epidemiological weeks are different (the latter start on Sunday and end on
>> Saturday, while the ISO weeks start on Monday).  I tried to create a new
>> periodtype 'EPIWeekly" and all new periods which I imported into the period
>> table on my local machine and then restarted tomcat - no luck!
>>
>> See the error message below. - it seems like my periodtype is unknown to
>> the javascripts that run during startup.
>>
>> * INFO  2014-08-05 14:16:48,158 Executing startup routine [2 of 14,
>> runlevel 2]:
>>  PeriodTypePopulator (DefaultStartupRoutineExecutor.java
>> [localhost-startStop-1]
>> )
>> * ERROR 2014-08-05 14:16:48,228 org.hibernate.WrongClassException: Object
>> with i
>> d: 2627 was not of the specified subclass:
>> org.hisp.dhis.period.PeriodType (Disc
>> riminator: EPIWeekly)
>>
>> Now that we are migrating our disease surveillance system to DHIS-2 we
>> are going to need the epidemiological weeks - and I've got 3 years of
>> Sunday to Saturday data to import.  *Ismail, I guess we need to put this
>> into our generic requirements for IDSR- it will have an impact on quite a
>> few things including import/export which looks for ISO dates.*
>>
>> I suppose I can pretend they are the same for the import process and then
>> work out a way to change later.  The main issue is that the period selector
>> in data entry displays the Week number as well as the start and end dates,
>> otherwise users would never notice.
>>
>> Randy
>>
>>
>> On Tue, Aug 5, 2014 at 1:52 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
>> wrote:
>>
>>> On 5 August 2014 12:04, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>>>
>>>> No nothing better but could rattle something off - in something
>>>> slightly less exotic than R :-)
>>>>
>>>> Two questions mind you (more for developers):
>>>> 1.  I see we have a period_periodid_seq which doesn't seem to be used.
>>>>  I wonder is this a relic which needs to be removed?  Or does it have some
>>>> other use?
>>>> 2.  Its very easy to create duplicate periods which is not nice.
>>>>  Probably we should consider placing a uniqueness constraint on
>>>> periodtype+startdate
>>>>
>>>
>>> To answer my own question, different versions of dhis have treated these
>>> issues differently. So you'd want to be a little careful depending on the
>>> dhis version used.
>>>
>>>
>>>>
>>>>
>>>>  On 5 August 2014 11:49, Jason Pickering <jason.p.pickering@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi Randy,
>>>>> I see Bob just replied but was about to send this and will go ahead,
>>>>> but would wait for a more authoritative answer.
>>>>>
>>>>> Here is an R script  which I have used in the past. It is very basic
>>>>> and does not take into account weeks which might already exist. It simply
>>>>> creates a lot of INSERT statements. You will get errors for those which
>>>>> already exist. It would be fairly easy to do this, but would require having
>>>>> R connected to your postgres database to filter out periods which already
>>>>> exist.
>>>>>
>>>>> Use at your own peril and hopefully Bob has something better.
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>> #require(ISOweek)
>>>>> #Adjust to your needs
>>>>> week.starts<-seq(ISOdate(2011,1,3), ISOdate(2014,8,3), by = "1 week")
>>>>> #Number of seconds in a week
>>>>> week.ends<-week.starts + 518399
>>>>> #Get the week names in case you need it
>>>>> #week.names<-gsub("-","",substring(date2ISOweek(week.starts),0,8))
>>>>>
>>>>> sql<-paste0("INSERT INTO periods
>>>>> (periodid,periodtypeid,startdate,enddate)
>>>>> VALUES(nextval('hibernate_sequence'::regclass),2,","'",as.Date(week.starts),"','",as.Date(week.ends),"');")
>>>>> cat(sql,file="insert_periods.sql)
>>>>>
>>>>>
>>>>> On Tue, Aug 5, 2014 at 12:23 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Randy do you need a script to generate these?
>>>>>>
>>>>>>
>>>>>> On 4 August 2014 17:11, Wilson, Randy <rwilson@xxxxxxx> wrote:
>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>> I thought I saw a posting on inserting periods into the DHIS-2 for
>>>>>>> earlier periods in time, but can't seem to find it any longer.
>>>>>>>
>>>>>>> I need ISO weekly periods going back to 2011. I also notice that
>>>>>>> there are some instances where there are 53 ISO weeks in a year, but that
>>>>>>> does not appear to be an option in DHIS-2.
>>>>>>>
>>>>>>> Can someone advise?
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> *Randy Wilson*
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> *This message and its attachments are confidential and solely for
>>>>>>> the intended recipients. If received in error, please delete them and
>>>>>>> notify the sender via reply e-mail immediately.*
>>>>>>>  _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>>
>> --
>>
>> *Randy Wilson*
>>
>> Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda
>>
>> Integrated Health Systems Strengthening Project
>>
>> Management Sciences for Health, Inc. (MSH)
>>
>> BP 371
>> Kigali, Rwanda
>> +250-788308835
>>
>> Skype Name (wilsonrandy_us)
>>
>> www.msh.org
>> <http://www.msh.org/?utm_source=2012-10-15+MSH+internal+announce+email+signature&utm_campaign=iemailsig&utm_medium=email>
>>
>>
>> *Stronger health systems. Greater health impact.*
>>
>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>
>

Attachment: weeks.php
Description: application/httpd-php

INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-01-03','2000-01-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-01-10','2000-01-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-01-17','2000-01-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-01-24','2000-01-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-01-31','2000-02-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-02-07','2000-02-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-02-14','2000-02-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-02-21','2000-02-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-02-28','2000-03-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-03-06','2000-03-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-03-13','2000-03-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-03-20','2000-03-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-03-27','2000-04-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-04-03','2000-04-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-04-10','2000-04-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-04-17','2000-04-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-04-24','2000-04-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-05-01','2000-05-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-05-08','2000-05-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-05-15','2000-05-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-05-22','2000-05-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-05-29','2000-06-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-06-05','2000-06-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-06-12','2000-06-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-06-19','2000-06-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-06-26','2000-07-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-07-03','2000-07-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-07-10','2000-07-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-07-17','2000-07-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-07-24','2000-07-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-07-31','2000-08-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-08-07','2000-08-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-08-14','2000-08-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-08-21','2000-08-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-08-28','2000-09-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-09-04','2000-09-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-09-11','2000-09-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-09-18','2000-09-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-09-25','2000-10-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-10-02','2000-10-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-10-09','2000-10-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-10-16','2000-10-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-10-23','2000-10-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-10-30','2000-11-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-11-06','2000-11-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-11-13','2000-11-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-11-20','2000-11-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-11-27','2000-12-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-12-04','2000-12-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-12-11','2000-12-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-12-18','2000-12-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2000-12-25','2000-12-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-01-01','2001-01-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-01-08','2001-01-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-01-15','2001-01-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-01-22','2001-01-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-01-29','2001-02-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-02-05','2001-02-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-02-12','2001-02-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-02-19','2001-02-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-02-26','2001-03-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-03-05','2001-03-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-03-12','2001-03-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-03-19','2001-03-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-03-26','2001-04-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-04-02','2001-04-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-04-09','2001-04-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-04-16','2001-04-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-04-23','2001-04-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-04-30','2001-05-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-05-07','2001-05-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-05-14','2001-05-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-05-21','2001-05-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-05-28','2001-06-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-06-04','2001-06-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-06-11','2001-06-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-06-18','2001-06-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-06-25','2001-07-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-07-02','2001-07-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-07-09','2001-07-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-07-16','2001-07-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-07-23','2001-07-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-07-30','2001-08-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-08-06','2001-08-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-08-13','2001-08-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-08-20','2001-08-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-08-27','2001-09-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-09-03','2001-09-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-09-10','2001-09-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-09-17','2001-09-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-09-24','2001-09-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-10-01','2001-10-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-10-08','2001-10-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-10-15','2001-10-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-10-22','2001-10-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-10-29','2001-11-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-11-05','2001-11-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-11-12','2001-11-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-11-19','2001-11-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-11-26','2001-12-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-12-03','2001-12-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-12-10','2001-12-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-12-17','2001-12-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-12-24','2001-12-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2001-12-31','2002-01-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-01-07','2002-01-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-01-14','2002-01-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-01-21','2002-01-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-01-28','2002-02-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-02-04','2002-02-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-02-11','2002-02-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-02-18','2002-02-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-02-25','2002-03-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-03-04','2002-03-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-03-11','2002-03-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-03-18','2002-03-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-03-25','2002-03-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-04-01','2002-04-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-04-08','2002-04-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-04-15','2002-04-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-04-22','2002-04-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-04-29','2002-05-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-05-06','2002-05-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-05-13','2002-05-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-05-20','2002-05-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-05-27','2002-06-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-06-03','2002-06-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-06-10','2002-06-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-06-17','2002-06-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-06-24','2002-06-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-07-01','2002-07-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-07-08','2002-07-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-07-15','2002-07-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-07-22','2002-07-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-07-29','2002-08-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-08-05','2002-08-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-08-12','2002-08-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-08-19','2002-08-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-08-26','2002-09-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-09-02','2002-09-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-09-09','2002-09-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-09-16','2002-09-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-09-23','2002-09-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-09-30','2002-10-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-10-07','2002-10-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-10-14','2002-10-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-10-21','2002-10-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-10-28','2002-11-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-11-04','2002-11-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-11-11','2002-11-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-11-18','2002-11-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-11-25','2002-12-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-12-02','2002-12-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-12-09','2002-12-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-12-16','2002-12-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-12-23','2002-12-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2002-12-30','2003-01-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-01-06','2003-01-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-01-13','2003-01-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-01-20','2003-01-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-01-27','2003-02-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-02-03','2003-02-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-02-10','2003-02-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-02-17','2003-02-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-02-24','2003-03-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-03-03','2003-03-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-03-10','2003-03-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-03-17','2003-03-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-03-24','2003-03-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-03-31','2003-04-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-04-07','2003-04-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-04-14','2003-04-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-04-21','2003-04-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-04-28','2003-05-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-05-05','2003-05-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-05-12','2003-05-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-05-19','2003-05-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-05-26','2003-06-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-06-02','2003-06-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-06-09','2003-06-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-06-16','2003-06-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-06-23','2003-06-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-06-30','2003-07-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-07-07','2003-07-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-07-14','2003-07-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-07-21','2003-07-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-07-28','2003-08-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-08-04','2003-08-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-08-11','2003-08-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-08-18','2003-08-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-08-25','2003-08-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-09-01','2003-09-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-09-08','2003-09-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-09-15','2003-09-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-09-22','2003-09-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-09-29','2003-10-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-10-06','2003-10-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-10-13','2003-10-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-10-20','2003-10-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-10-27','2003-11-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-11-03','2003-11-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-11-10','2003-11-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-11-17','2003-11-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-11-24','2003-11-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-12-01','2003-12-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-12-08','2003-12-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-12-15','2003-12-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-12-22','2003-12-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2003-12-29','2004-01-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-01-05','2004-01-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-01-12','2004-01-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-01-19','2004-01-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-01-26','2004-02-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-02-02','2004-02-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-02-09','2004-02-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-02-16','2004-02-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-02-23','2004-02-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-03-01','2004-03-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-03-08','2004-03-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-03-15','2004-03-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-03-22','2004-03-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-03-29','2004-04-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-04-05','2004-04-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-04-12','2004-04-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-04-19','2004-04-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-04-26','2004-05-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-05-03','2004-05-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-05-10','2004-05-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-05-17','2004-05-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-05-24','2004-05-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-05-31','2004-06-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-06-07','2004-06-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-06-14','2004-06-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-06-21','2004-06-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-06-28','2004-07-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-07-05','2004-07-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-07-12','2004-07-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-07-19','2004-07-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-07-26','2004-08-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-08-02','2004-08-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-08-09','2004-08-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-08-16','2004-08-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-08-23','2004-08-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-08-30','2004-09-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-09-06','2004-09-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-09-13','2004-09-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-09-20','2004-09-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-09-27','2004-10-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-10-04','2004-10-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-10-11','2004-10-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-10-18','2004-10-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-10-25','2004-10-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-11-01','2004-11-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-11-08','2004-11-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-11-15','2004-11-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-11-22','2004-11-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-11-29','2004-12-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-12-06','2004-12-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-12-13','2004-12-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-12-20','2004-12-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2004-12-27','2005-01-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-01-03','2005-01-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-01-10','2005-01-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-01-17','2005-01-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-01-24','2005-01-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-01-31','2005-02-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-02-07','2005-02-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-02-14','2005-02-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-02-21','2005-02-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-02-28','2005-03-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-03-07','2005-03-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-03-14','2005-03-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-03-21','2005-03-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-03-28','2005-04-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-04-04','2005-04-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-04-11','2005-04-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-04-18','2005-04-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-04-25','2005-05-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-05-02','2005-05-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-05-09','2005-05-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-05-16','2005-05-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-05-23','2005-05-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-05-30','2005-06-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-06-06','2005-06-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-06-13','2005-06-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-06-20','2005-06-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-06-27','2005-07-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-07-04','2005-07-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-07-11','2005-07-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-07-18','2005-07-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-07-25','2005-07-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-08-01','2005-08-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-08-08','2005-08-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-08-15','2005-08-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-08-22','2005-08-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-08-29','2005-09-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-09-05','2005-09-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-09-12','2005-09-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-09-19','2005-09-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-09-26','2005-10-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-10-03','2005-10-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-10-10','2005-10-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-10-17','2005-10-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-10-24','2005-10-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-10-31','2005-11-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-11-07','2005-11-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-11-14','2005-11-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-11-21','2005-11-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-11-28','2005-12-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-12-05','2005-12-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-12-12','2005-12-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-12-19','2005-12-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2005-12-26','2006-01-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-01-02','2006-01-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-01-09','2006-01-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-01-16','2006-01-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-01-23','2006-01-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-01-30','2006-02-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-02-06','2006-02-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-02-13','2006-02-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-02-20','2006-02-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-02-27','2006-03-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-03-06','2006-03-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-03-13','2006-03-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-03-20','2006-03-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-03-27','2006-04-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-04-03','2006-04-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-04-10','2006-04-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-04-17','2006-04-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-04-24','2006-04-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-05-01','2006-05-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-05-08','2006-05-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-05-15','2006-05-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-05-22','2006-05-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-05-29','2006-06-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-06-05','2006-06-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-06-12','2006-06-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-06-19','2006-06-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-06-26','2006-07-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-07-03','2006-07-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-07-10','2006-07-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-07-17','2006-07-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-07-24','2006-07-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-07-31','2006-08-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-08-07','2006-08-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-08-14','2006-08-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-08-21','2006-08-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-08-28','2006-09-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-09-04','2006-09-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-09-11','2006-09-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-09-18','2006-09-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-09-25','2006-10-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-10-02','2006-10-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-10-09','2006-10-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-10-16','2006-10-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-10-23','2006-10-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-10-30','2006-11-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-11-06','2006-11-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-11-13','2006-11-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-11-20','2006-11-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-11-27','2006-12-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-12-04','2006-12-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-12-11','2006-12-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-12-18','2006-12-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2006-12-25','2006-12-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-01-01','2007-01-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-01-08','2007-01-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-01-15','2007-01-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-01-22','2007-01-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-01-29','2007-02-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-02-05','2007-02-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-02-12','2007-02-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-02-19','2007-02-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-02-26','2007-03-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-03-05','2007-03-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-03-12','2007-03-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-03-19','2007-03-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-03-26','2007-04-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-04-02','2007-04-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-04-09','2007-04-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-04-16','2007-04-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-04-23','2007-04-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-04-30','2007-05-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-05-07','2007-05-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-05-14','2007-05-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-05-21','2007-05-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-05-28','2007-06-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-06-04','2007-06-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-06-11','2007-06-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-06-18','2007-06-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-06-25','2007-07-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-07-02','2007-07-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-07-09','2007-07-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-07-16','2007-07-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-07-23','2007-07-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-07-30','2007-08-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-08-06','2007-08-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-08-13','2007-08-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-08-20','2007-08-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-08-27','2007-09-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-09-03','2007-09-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-09-10','2007-09-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-09-17','2007-09-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-09-24','2007-09-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-10-01','2007-10-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-10-08','2007-10-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-10-15','2007-10-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-10-22','2007-10-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-10-29','2007-11-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-11-05','2007-11-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-11-12','2007-11-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-11-19','2007-11-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-11-26','2007-12-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-12-03','2007-12-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-12-10','2007-12-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-12-17','2007-12-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-12-24','2007-12-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2007-12-31','2008-01-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-01-07','2008-01-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-01-14','2008-01-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-01-21','2008-01-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-01-28','2008-02-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-02-04','2008-02-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-02-11','2008-02-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-02-18','2008-02-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-02-25','2008-03-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-03-03','2008-03-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-03-10','2008-03-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-03-17','2008-03-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-03-24','2008-03-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-03-31','2008-04-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-04-07','2008-04-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-04-14','2008-04-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-04-21','2008-04-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-04-28','2008-05-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-05-05','2008-05-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-05-12','2008-05-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-05-19','2008-05-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-05-26','2008-06-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-06-02','2008-06-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-06-09','2008-06-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-06-16','2008-06-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-06-23','2008-06-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-06-30','2008-07-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-07-07','2008-07-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-07-14','2008-07-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-07-21','2008-07-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-07-28','2008-08-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-08-04','2008-08-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-08-11','2008-08-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-08-18','2008-08-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-08-25','2008-08-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-09-01','2008-09-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-09-08','2008-09-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-09-15','2008-09-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-09-22','2008-09-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-09-29','2008-10-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-10-06','2008-10-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-10-13','2008-10-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-10-20','2008-10-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-10-27','2008-11-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-11-03','2008-11-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-11-10','2008-11-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-11-17','2008-11-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-11-24','2008-11-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-12-01','2008-12-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-12-08','2008-12-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-12-15','2008-12-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-12-22','2008-12-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2008-12-29','2009-01-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-01-05','2009-01-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-01-12','2009-01-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-01-19','2009-01-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-01-26','2009-02-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-02-02','2009-02-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-02-09','2009-02-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-02-16','2009-02-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-02-23','2009-03-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-03-02','2009-03-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-03-09','2009-03-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-03-16','2009-03-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-03-23','2009-03-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-03-30','2009-04-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-04-06','2009-04-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-04-13','2009-04-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-04-20','2009-04-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-04-27','2009-05-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-05-04','2009-05-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-05-11','2009-05-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-05-18','2009-05-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-05-25','2009-05-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-06-01','2009-06-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-06-08','2009-06-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-06-15','2009-06-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-06-22','2009-06-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-06-29','2009-07-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-07-06','2009-07-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-07-13','2009-07-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-07-20','2009-07-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-07-27','2009-08-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-08-03','2009-08-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-08-10','2009-08-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-08-17','2009-08-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-08-24','2009-08-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-08-31','2009-09-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-09-07','2009-09-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-09-14','2009-09-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-09-21','2009-09-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-09-28','2009-10-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-10-05','2009-10-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-10-12','2009-10-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-10-19','2009-10-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-10-26','2009-11-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-11-02','2009-11-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-11-09','2009-11-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-11-16','2009-11-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-11-23','2009-11-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-11-30','2009-12-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-12-07','2009-12-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-12-14','2009-12-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-12-21','2009-12-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2009-12-28','2010-01-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-01-04','2010-01-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-01-11','2010-01-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-01-18','2010-01-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-01-25','2010-01-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-02-01','2010-02-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-02-08','2010-02-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-02-15','2010-02-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-02-22','2010-02-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-03-01','2010-03-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-03-08','2010-03-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-03-15','2010-03-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-03-22','2010-03-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-03-29','2010-04-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-04-05','2010-04-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-04-12','2010-04-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-04-19','2010-04-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-04-26','2010-05-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-05-03','2010-05-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-05-10','2010-05-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-05-17','2010-05-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-05-24','2010-05-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-05-31','2010-06-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-06-07','2010-06-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-06-14','2010-06-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-06-21','2010-06-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-06-28','2010-07-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-07-05','2010-07-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-07-12','2010-07-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-07-19','2010-07-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-07-26','2010-08-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-08-02','2010-08-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-08-09','2010-08-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-08-16','2010-08-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-08-23','2010-08-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-08-30','2010-09-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-09-06','2010-09-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-09-13','2010-09-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-09-20','2010-09-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-09-27','2010-10-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-10-04','2010-10-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-10-11','2010-10-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-10-18','2010-10-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-10-25','2010-10-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-11-01','2010-11-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-11-08','2010-11-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-11-15','2010-11-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-11-22','2010-11-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-11-29','2010-12-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-12-06','2010-12-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-12-13','2010-12-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-12-20','2010-12-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2010-12-27','2011-01-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-01-03','2011-01-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-01-10','2011-01-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-01-17','2011-01-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-01-24','2011-01-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-01-31','2011-02-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-02-07','2011-02-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-02-14','2011-02-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-02-21','2011-02-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-02-28','2011-03-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-03-07','2011-03-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-03-14','2011-03-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-03-21','2011-03-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-03-28','2011-04-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-04-04','2011-04-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-04-11','2011-04-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-04-18','2011-04-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-04-25','2011-05-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-05-02','2011-05-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-05-09','2011-05-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-05-16','2011-05-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-05-23','2011-05-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-05-30','2011-06-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-06-06','2011-06-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-06-13','2011-06-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-06-20','2011-06-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-06-27','2011-07-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-07-04','2011-07-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-07-11','2011-07-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-07-18','2011-07-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-07-25','2011-07-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-08-01','2011-08-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-08-08','2011-08-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-08-15','2011-08-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-08-22','2011-08-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-08-29','2011-09-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-09-05','2011-09-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-09-12','2011-09-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-09-19','2011-09-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-09-26','2011-10-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-10-03','2011-10-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-10-10','2011-10-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-10-17','2011-10-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-10-24','2011-10-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-10-31','2011-11-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-11-07','2011-11-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-11-14','2011-11-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-11-21','2011-11-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-11-28','2011-12-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-12-05','2011-12-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-12-12','2011-12-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-12-19','2011-12-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2011-12-26','2012-01-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-01-02','2012-01-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-01-09','2012-01-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-01-16','2012-01-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-01-23','2012-01-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-01-30','2012-02-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-02-06','2012-02-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-02-13','2012-02-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-02-20','2012-02-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-02-27','2012-03-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-03-05','2012-03-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-03-12','2012-03-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-03-19','2012-03-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-03-26','2012-04-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-04-02','2012-04-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-04-09','2012-04-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-04-16','2012-04-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-04-23','2012-04-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-04-30','2012-05-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-05-07','2012-05-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-05-14','2012-05-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-05-21','2012-05-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-05-28','2012-06-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-06-04','2012-06-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-06-11','2012-06-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-06-18','2012-06-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-06-25','2012-07-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-07-02','2012-07-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-07-09','2012-07-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-07-16','2012-07-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-07-23','2012-07-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-07-30','2012-08-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-08-06','2012-08-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-08-13','2012-08-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-08-20','2012-08-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-08-27','2012-09-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-09-03','2012-09-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-09-10','2012-09-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-09-17','2012-09-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-09-24','2012-09-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-10-01','2012-10-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-10-08','2012-10-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-10-15','2012-10-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-10-22','2012-10-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-10-29','2012-11-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-11-05','2012-11-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-11-12','2012-11-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-11-19','2012-11-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-11-26','2012-12-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-12-03','2012-12-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-12-10','2012-12-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-12-17','2012-12-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-12-24','2012-12-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2012-12-31','2013-01-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-01-07','2013-01-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-01-14','2013-01-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-01-21','2013-01-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-01-28','2013-02-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-02-04','2013-02-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-02-11','2013-02-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-02-18','2013-02-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-02-25','2013-03-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-03-04','2013-03-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-03-11','2013-03-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-03-18','2013-03-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-03-25','2013-03-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-04-01','2013-04-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-04-08','2013-04-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-04-15','2013-04-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-04-22','2013-04-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-04-29','2013-05-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-05-06','2013-05-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-05-13','2013-05-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-05-20','2013-05-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-05-27','2013-06-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-06-03','2013-06-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-06-10','2013-06-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-06-17','2013-06-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-06-24','2013-06-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-07-01','2013-07-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-07-08','2013-07-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-07-15','2013-07-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-07-22','2013-07-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-07-29','2013-08-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-08-05','2013-08-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-08-12','2013-08-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-08-19','2013-08-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-08-26','2013-09-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-09-02','2013-09-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-09-09','2013-09-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-09-16','2013-09-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-09-23','2013-09-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-09-30','2013-10-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-10-07','2013-10-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-10-14','2013-10-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-10-21','2013-10-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-10-28','2013-11-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-11-04','2013-11-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-11-11','2013-11-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-11-18','2013-11-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-11-25','2013-12-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-12-02','2013-12-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-12-09','2013-12-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-12-16','2013-12-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-12-23','2013-12-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2013-12-30','2014-01-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-01-06','2014-01-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-01-13','2014-01-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-01-20','2014-01-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-01-27','2014-02-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-02-03','2014-02-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-02-10','2014-02-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-02-17','2014-02-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-02-24','2014-03-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-03-03','2014-03-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-03-10','2014-03-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-03-17','2014-03-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-03-24','2014-03-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-03-31','2014-04-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-04-07','2014-04-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-04-14','2014-04-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-04-21','2014-04-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-04-28','2014-05-04');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-05-05','2014-05-11');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-05-12','2014-05-18');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-05-19','2014-05-25');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-05-26','2014-06-01');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-06-02','2014-06-08');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-06-09','2014-06-15');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-06-16','2014-06-22');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-06-23','2014-06-29');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-06-30','2014-07-06');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-07-07','2014-07-13');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-07-14','2014-07-20');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-07-21','2014-07-27');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-07-28','2014-08-03');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-08-04','2014-08-10');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-08-11','2014-08-17');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-08-18','2014-08-24');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-08-25','2014-08-31');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-09-01','2014-09-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-09-08','2014-09-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-09-15','2014-09-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-09-22','2014-09-28');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-09-29','2014-10-05');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-10-06','2014-10-12');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-10-13','2014-10-19');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-10-20','2014-10-26');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-10-27','2014-11-02');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-11-03','2014-11-09');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-11-10','2014-11-16');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-11-17','2014-11-23');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-11-24','2014-11-30');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-12-01','2014-12-07');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-12-08','2014-12-14');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-12-15','2014-12-21');
INSERT INTO period VALUES (nextval('hibernate_sequence'), 2, '2014-12-22','2014-12-28');

References

Quick way to add missing ISO weeks going back to 2011?
From: Wilson, Randy, 2014-08-04
Re: Quick way to add missing ISO weeks going back to 2011?
From: Bob Jolliffe, 2014-08-05
Re: Quick way to add missing ISO weeks going back to 2011?
From: Jason Pickering, 2014-08-05
Re: Quick way to add missing ISO weeks going back to 2011?
From: Bob Jolliffe, 2014-08-05
Re: Quick way to add missing ISO weeks going back to 2011?
From: Bob Jolliffe, 2014-08-05
Re: Quick way to add missing ISO weeks going back to 2011?
From: Wilson, Randy, 2014-08-05
Re: Quick way to add missing ISO weeks going back to 2011?
From: Jason Pickering, 2014-08-06