Changeset 634 in tmcsimulator


Ignore:
Timestamp:
02/25/2021 10:00:55 AM (5 years ago)
Author:
jdalbey
Message:

LCS implement #252 Add logging for new closures and status updates

Location:
branches/LCSv2
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • branches/LCSv2/controllers/default.py

    r626 r634  
    11# added comments for testing 
    22# Constants 
     3kLogfile = "samplelogfile.txt" 
     4kSimtimefile = "sim_elapsedtime.json" 
    35hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] 
    46hwyDirections = ['','NB', 'SB', 'NB/SB','EB','WB','EB/WB'] 
    5 # Names to appeaer in the username dropdown box 
     7# Names to appear in the username dropdown box 
    68users = [] 
    79# Show the login page 
    … …  
    189191            fieldname = "s"+session.statustype[0:4]+"time" 
    190192            db(db.closures.closureid == session.statustype[4:]).update(**{fieldname:now.strftime("%H%M")}) 
     193            # Log the update to external file 
     194            logmessage = getSimTime() + " LCS status update: " + session.username + ", " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " " + "\n" 
     195            text_file = open(kLogfile, "a") 
     196            text_file.write(logmessage) 
     197            text_file.close() 
    191198        else: 
    192199            msg = "error because only checking one box is allowed." 
    … …  
    201208    else: 
    202209        return "" 
     210 
     211# Fetch simulation time and format it into a timestamp 
     212def getSimTime(): 
     213    import json,datetime 
     214    try: 
     215        jsontime = json.load(open(kSimtimefile,'r')) 
     216        currentSimTime = jsontime["elapsedtime"] 
     217        timestamp = str(datetime.timedelta(seconds = int(currentSimTime))) 
     218        return timestamp 
     219    except: 
     220        # Fallback if missing file, use current time  
     221        now = datetime.datetime.today() 
     222        return now.strftime("%H:%M:%S") 
    203223 
    204224# Create a new record 
    … …  
    296316        newrec = db.closures.insert(closureid=newID, lognum=newLognum, route=form.vars.route, direction=form.vars.direction, facility=form.vars.facility, startcounty=form.vars.startcounty, endcounty=form.vars.endcounty, startlocation=form.vars.startlocation, endlocation=form.vars.endlocation, startdate=form.vars.startdate, enddate=form.vars.enddate, starttime=form.vars.starttime+form.vars.starttimemin, endtime=form.vars.endtime+form.vars.endtimemin, closuretype=form.vars.closuretype, closedlanes=selectedlanes, worktype=form.vars.worktype, estdelay=form.vars.estdelay, tmpcozeep=getCheckbox(form.vars.cozeep), tmpdetour=getCheckbox(form.vars.detour), supervisor=supervisor_name, fieldrep=fieldrep_name, s1097date='', s1098date='', s1022date='' ) 
    297317        session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 
     318        # Log the new closure to external file. Username, closureID, route, dir, type of closure, type of work 
     319        logmessage = getSimTime() + " LCS new closure: " + session.username + ", " + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ', ' + form.vars.worktype + "\n" 
     320        text_file = open(kLogfile, "a") 
     321        text_file.write(logmessage) 
     322        text_file.close() 
    298323        redirect(URL('search.html')) 
    299324    return dict(form=form) 

  • branches/LCSv2/controllers/default.py.bak

    r626 r634  
    11# added comments for testing 
    22# Constants 
     3kLogfile = "samplelogfile.txt" 
     4kSimtimefile = "sim_elapsedtime.json" 
    35hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605'] 
    46hwyDirections = ['','NB', 'SB', 'NB/SB','EB','WB','EB/WB'] 
    5 # Names to appeaer in the username dropdown box 
     7# Names to appear in the username dropdown box 
    68users = [] 
    79# Show the login page 
    … …  
    189191            fieldname = "s"+session.statustype[0:4]+"time" 
    190192            db(db.closures.closureid == session.statustype[4:]).update(**{fieldname:now.strftime("%H%M")}) 
     193            # Log the update to external file 
     194            logmessage = getSimTime() + " LCS status update: " + session.statustype[4:] + ", " + session.statustype[0:4] + ", " + session.statuser + " " + "\n" 
     195            text_file = open(kLogfile, "a") 
     196            text_file.write(logmessage) 
     197            text_file.close() 
    191198        else: 
    192199            msg = "error because only checking one box is allowed." 
    … …  
    201208    else: 
    202209        return "" 
     210 
     211# Fetch simulation time and format it into a timestamp 
     212def getSimTime(): 
     213    import json,datetime 
     214    try: 
     215        jsontime = json.load(open(kSimtimefile,'r')) 
     216        currentSimTime = jsontime["elapsedtime"] 
     217        timestamp = str(datetime.timedelta(seconds = int(currentSimTime))) 
     218        return timestamp 
     219    except: 
     220        # Fallback if missing file, use current time  
     221        now = datetime.datetime.today() 
     222        return now.strftime("%H:%M:%S") 
    203223 
    204224# Create a new record 
    … …  
    296316        newrec = db.closures.insert(closureid=newID, lognum=newLognum, route=form.vars.route, direction=form.vars.direction, facility=form.vars.facility, startcounty=form.vars.startcounty, endcounty=form.vars.endcounty, startlocation=form.vars.startlocation, endlocation=form.vars.endlocation, startdate=form.vars.startdate, enddate=form.vars.enddate, starttime=form.vars.starttime+form.vars.starttimemin, endtime=form.vars.endtime+form.vars.endtimemin, closuretype=form.vars.closuretype, closedlanes=selectedlanes, worktype=form.vars.worktype, estdelay=form.vars.estdelay, tmpcozeep=getCheckbox(form.vars.cozeep), tmpdetour=getCheckbox(form.vars.detour), supervisor=supervisor_name, fieldrep=fieldrep_name, s1097date='', s1098date='', s1022date='' ) 
    297317        session.flash = 'New lane closure added: ' + newID + ' ' + newLognum + ': ' + selectedlanes 
     318        # Log the new closure to external file. Username, closureID, route, dir, type of closure, type of work 
     319        logmessage = getSimTime() + " LCS new closure: " + session.username + newID + '.' + newLognum + ', ' + form.vars.route + form.vars.direction + ', ' + form.vars.closuretype + ', ' + form.vars.worktype + "\n" 
     320        text_file = open(kLogfile, "a") 
     321        text_file.write(logmessage) 
     322        text_file.close() 
    298323        redirect(URL('search.html')) 
    299324    return dict(form=form) 
    … …  
    303328    form = FORM("Press this button to reset the closure database to its original state at the start of a simulation.",BR(), 
    304329                "Warning: this will delete all the current closures.",BR(), 
     330                "Import filename is 'db_closures_start.csv'.",BR(), 
    305331                INPUT(_value="Reset Database", _type='submit', _class="btn btn-primary btn-default")) 
    306332    if form.process().accepted: 
    … …  
    308334        with open('db_closures_start.csv', 'rb') as dumpfile: 
    309335            db.closures.import_from_csv_file(dumpfile)  # import from starting state 
     336        session.flash = 'Closure database has been reset' 
    310337        redirect(URL('search.html')) 
    311338    return dict(form=form) 

  • branches/LCSv2/databases/sql.log

    r627 r634  
    4969449694DELETE FROM sqlite_sequence WHERE name='crew' 
    4969549695success! 
     49696DELETE FROM "supervisors"; 
     49697DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49698success! 
     49699DELETE FROM "streets"; 
     49700DELETE FROM sqlite_sequence WHERE name='streets' 
     49701success! 
     49702DELETE FROM "crew"; 
     49703DELETE FROM sqlite_sequence WHERE name='crew' 
     49704success! 
     49705DELETE FROM "supervisors"; 
     49706DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49707success! 
     49708DELETE FROM "streets"; 
     49709DELETE FROM sqlite_sequence WHERE name='streets' 
     49710success! 
     49711DELETE FROM "crew"; 
     49712DELETE FROM sqlite_sequence WHERE name='crew' 
     49713success! 
     49714DELETE FROM "supervisors"; 
     49715DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49716success! 
     49717DELETE FROM "streets"; 
     49718DELETE FROM sqlite_sequence WHERE name='streets' 
     49719success! 
     49720DELETE FROM "crew"; 
     49721DELETE FROM sqlite_sequence WHERE name='crew' 
     49722success! 
     49723DELETE FROM "supervisors"; 
     49724DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49725success! 
     49726DELETE FROM "streets"; 
     49727DELETE FROM sqlite_sequence WHERE name='streets' 
     49728success! 
     49729DELETE FROM "crew"; 
     49730DELETE FROM sqlite_sequence WHERE name='crew' 
     49731success! 
     49732DELETE FROM "supervisors"; 
     49733DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49734success! 
     49735DELETE FROM "streets"; 
     49736DELETE FROM sqlite_sequence WHERE name='streets' 
     49737success! 
     49738DELETE FROM "crew"; 
     49739DELETE FROM sqlite_sequence WHERE name='crew' 
     49740success! 
     49741DELETE FROM "supervisors"; 
     49742DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49743success! 
     49744DELETE FROM "streets"; 
     49745DELETE FROM sqlite_sequence WHERE name='streets' 
     49746success! 
     49747DELETE FROM "crew"; 
     49748DELETE FROM sqlite_sequence WHERE name='crew' 
     49749success! 
     49750DELETE FROM "supervisors"; 
     49751DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49752success! 
     49753DELETE FROM "streets"; 
     49754DELETE FROM sqlite_sequence WHERE name='streets' 
     49755success! 
     49756DELETE FROM "crew"; 
     49757DELETE FROM sqlite_sequence WHERE name='crew' 
     49758success! 
     49759DELETE FROM "supervisors"; 
     49760DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49761success! 
     49762DELETE FROM "streets"; 
     49763DELETE FROM sqlite_sequence WHERE name='streets' 
     49764success! 
     49765DELETE FROM "crew"; 
     49766DELETE FROM sqlite_sequence WHERE name='crew' 
     49767success! 
     49768DELETE FROM "supervisors"; 
     49769DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49770success! 
     49771DELETE FROM "streets"; 
     49772DELETE FROM sqlite_sequence WHERE name='streets' 
     49773success! 
     49774DELETE FROM "crew"; 
     49775DELETE FROM sqlite_sequence WHERE name='crew' 
     49776success! 
     49777DELETE FROM "supervisors"; 
     49778DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49779success! 
     49780DELETE FROM "streets"; 
     49781DELETE FROM sqlite_sequence WHERE name='streets' 
     49782success! 
     49783DELETE FROM "crew"; 
     49784DELETE FROM sqlite_sequence WHERE name='crew' 
     49785success! 
     49786DELETE FROM "supervisors"; 
     49787DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49788success! 
     49789DELETE FROM "streets"; 
     49790DELETE FROM sqlite_sequence WHERE name='streets' 
     49791success! 
     49792DELETE FROM "crew"; 
     49793DELETE FROM sqlite_sequence WHERE name='crew' 
     49794success! 
     49795DELETE FROM "supervisors"; 
     49796DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49797success! 
     49798DELETE FROM "streets"; 
     49799DELETE FROM sqlite_sequence WHERE name='streets' 
     49800success! 
     49801DELETE FROM "crew"; 
     49802DELETE FROM sqlite_sequence WHERE name='crew' 
     49803success! 
     49804DELETE FROM "supervisors"; 
     49805DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49806success! 
     49807DELETE FROM "streets"; 
     49808DELETE FROM sqlite_sequence WHERE name='streets' 
     49809success! 
     49810DELETE FROM "crew"; 
     49811DELETE FROM sqlite_sequence WHERE name='crew' 
     49812success! 
     49813DELETE FROM "supervisors"; 
     49814DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49815success! 
     49816DELETE FROM "streets"; 
     49817DELETE FROM sqlite_sequence WHERE name='streets' 
     49818success! 
     49819DELETE FROM "crew"; 
     49820DELETE FROM sqlite_sequence WHERE name='crew' 
     49821success! 
     49822DELETE FROM "supervisors"; 
     49823DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49824success! 
     49825DELETE FROM "streets"; 
     49826DELETE FROM sqlite_sequence WHERE name='streets' 
     49827success! 
     49828DELETE FROM "crew"; 
     49829DELETE FROM sqlite_sequence WHERE name='crew' 
     49830success! 
     49831DELETE FROM "supervisors"; 
     49832DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49833success! 
     49834DELETE FROM "streets"; 
     49835DELETE FROM sqlite_sequence WHERE name='streets' 
     49836success! 
     49837DELETE FROM "crew"; 
     49838DELETE FROM sqlite_sequence WHERE name='crew' 
     49839success! 
     49840DELETE FROM "supervisors"; 
     49841DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49842success! 
     49843DELETE FROM "streets"; 
     49844DELETE FROM sqlite_sequence WHERE name='streets' 
     49845success! 
     49846DELETE FROM "crew"; 
     49847DELETE FROM sqlite_sequence WHERE name='crew' 
     49848success! 
     49849DELETE FROM "supervisors"; 
     49850DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49851success! 
     49852DELETE FROM "streets"; 
     49853DELETE FROM sqlite_sequence WHERE name='streets' 
     49854success! 
     49855DELETE FROM "crew"; 
     49856DELETE FROM sqlite_sequence WHERE name='crew' 
     49857success! 
     49858DELETE FROM "supervisors"; 
     49859DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49860success! 
     49861DELETE FROM "streets"; 
     49862DELETE FROM sqlite_sequence WHERE name='streets' 
     49863success! 
     49864DELETE FROM "crew"; 
     49865DELETE FROM sqlite_sequence WHERE name='crew' 
     49866success! 
     49867DELETE FROM "supervisors"; 
     49868DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49869success! 
     49870DELETE FROM "streets"; 
     49871DELETE FROM sqlite_sequence WHERE name='streets' 
     49872success! 
     49873DELETE FROM "crew"; 
     49874DELETE FROM sqlite_sequence WHERE name='crew' 
     49875success! 
     49876DELETE FROM "supervisors"; 
     49877DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49878success! 
     49879DELETE FROM "streets"; 
     49880DELETE FROM sqlite_sequence WHERE name='streets' 
     49881success! 
     49882DELETE FROM "crew"; 
     49883DELETE FROM sqlite_sequence WHERE name='crew' 
     49884success! 
     49885DELETE FROM "supervisors"; 
     49886DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49887success! 
     49888DELETE FROM "streets"; 
     49889DELETE FROM sqlite_sequence WHERE name='streets' 
     49890success! 
     49891DELETE FROM "crew"; 
     49892DELETE FROM sqlite_sequence WHERE name='crew' 
     49893success! 
     49894DELETE FROM "supervisors"; 
     49895DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49896success! 
     49897DELETE FROM "streets"; 
     49898DELETE FROM sqlite_sequence WHERE name='streets' 
     49899success! 
     49900DELETE FROM "crew"; 
     49901DELETE FROM sqlite_sequence WHERE name='crew' 
     49902success! 
     49903DELETE FROM "supervisors"; 
     49904DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49905success! 
     49906DELETE FROM "streets"; 
     49907DELETE FROM sqlite_sequence WHERE name='streets' 
     49908success! 
     49909DELETE FROM "crew"; 
     49910DELETE FROM sqlite_sequence WHERE name='crew' 
     49911success! 
     49912DELETE FROM "supervisors"; 
     49913DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49914success! 
     49915DELETE FROM "streets"; 
     49916DELETE FROM sqlite_sequence WHERE name='streets' 
     49917success! 
     49918DELETE FROM "crew"; 
     49919DELETE FROM sqlite_sequence WHERE name='crew' 
     49920success! 
     49921DELETE FROM "supervisors"; 
     49922DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49923success! 
     49924DELETE FROM "streets"; 
     49925DELETE FROM sqlite_sequence WHERE name='streets' 
     49926success! 
     49927DELETE FROM "crew"; 
     49928DELETE FROM sqlite_sequence WHERE name='crew' 
     49929success! 
     49930DELETE FROM "supervisors"; 
     49931DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49932success! 
     49933DELETE FROM "streets"; 
     49934DELETE FROM sqlite_sequence WHERE name='streets' 
     49935success! 
     49936DELETE FROM "crew"; 
     49937DELETE FROM sqlite_sequence WHERE name='crew' 
     49938success! 
     49939DELETE FROM "supervisors"; 
     49940DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49941success! 
     49942DELETE FROM "streets"; 
     49943DELETE FROM sqlite_sequence WHERE name='streets' 
     49944success! 
     49945DELETE FROM "crew"; 
     49946DELETE FROM sqlite_sequence WHERE name='crew' 
     49947success! 
     49948DELETE FROM "supervisors"; 
     49949DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49950success! 
     49951DELETE FROM "streets"; 
     49952DELETE FROM sqlite_sequence WHERE name='streets' 
     49953success! 
     49954DELETE FROM "crew"; 
     49955DELETE FROM sqlite_sequence WHERE name='crew' 
     49956success! 
     49957DELETE FROM "supervisors"; 
     49958DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49959success! 
     49960DELETE FROM "streets"; 
     49961DELETE FROM sqlite_sequence WHERE name='streets' 
     49962success! 
     49963DELETE FROM "crew"; 
     49964DELETE FROM sqlite_sequence WHERE name='crew' 
     49965success! 
     49966DELETE FROM "supervisors"; 
     49967DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49968success! 
     49969DELETE FROM "streets"; 
     49970DELETE FROM sqlite_sequence WHERE name='streets' 
     49971success! 
     49972DELETE FROM "crew"; 
     49973DELETE FROM sqlite_sequence WHERE name='crew' 
     49974success! 
     49975DELETE FROM "supervisors"; 
     49976DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49977success! 
     49978DELETE FROM "streets"; 
     49979DELETE FROM sqlite_sequence WHERE name='streets' 
     49980success! 
     49981DELETE FROM "crew"; 
     49982DELETE FROM sqlite_sequence WHERE name='crew' 
     49983success! 
     49984DELETE FROM "supervisors"; 
     49985DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49986success! 
     49987DELETE FROM "streets"; 
     49988DELETE FROM sqlite_sequence WHERE name='streets' 
     49989success! 
     49990DELETE FROM "crew"; 
     49991DELETE FROM sqlite_sequence WHERE name='crew' 
     49992success! 
     49993DELETE FROM "supervisors"; 
     49994DELETE FROM sqlite_sequence WHERE name='supervisors' 
     49995success! 
     49996DELETE FROM "streets"; 
     49997DELETE FROM sqlite_sequence WHERE name='streets' 
     49998success! 
     49999DELETE FROM "crew"; 
     50000DELETE FROM sqlite_sequence WHERE name='crew' 
     50001success! 
     50002DELETE FROM "supervisors"; 
     50003DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50004success! 
     50005DELETE FROM "streets"; 
     50006DELETE FROM sqlite_sequence WHERE name='streets' 
     50007success! 
     50008DELETE FROM "crew"; 
     50009DELETE FROM sqlite_sequence WHERE name='crew' 
     50010success! 
     50011DELETE FROM "supervisors"; 
     50012DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50013success! 
     50014DELETE FROM "streets"; 
     50015DELETE FROM sqlite_sequence WHERE name='streets' 
     50016success! 
     50017DELETE FROM "crew"; 
     50018DELETE FROM sqlite_sequence WHERE name='crew' 
     50019success! 
     50020DELETE FROM "supervisors"; 
     50021DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50022success! 
     50023DELETE FROM "streets"; 
     50024DELETE FROM sqlite_sequence WHERE name='streets' 
     50025success! 
     50026DELETE FROM "crew"; 
     50027DELETE FROM sqlite_sequence WHERE name='crew' 
     50028success! 
     50029DELETE FROM "supervisors"; 
     50030DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50031success! 
     50032DELETE FROM "streets"; 
     50033DELETE FROM sqlite_sequence WHERE name='streets' 
     50034success! 
     50035DELETE FROM "crew"; 
     50036DELETE FROM sqlite_sequence WHERE name='crew' 
     50037success! 
     50038DELETE FROM "supervisors"; 
     50039DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50040success! 
     50041DELETE FROM "streets"; 
     50042DELETE FROM sqlite_sequence WHERE name='streets' 
     50043success! 
     50044DELETE FROM "crew"; 
     50045DELETE FROM sqlite_sequence WHERE name='crew' 
     50046success! 
     50047DELETE FROM "supervisors"; 
     50048DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50049success! 
     50050DELETE FROM "streets"; 
     50051DELETE FROM sqlite_sequence WHERE name='streets' 
     50052success! 
     50053DELETE FROM "crew"; 
     50054DELETE FROM sqlite_sequence WHERE name='crew' 
     50055success! 
     50056DELETE FROM "supervisors"; 
     50057DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50058success! 
     50059DELETE FROM "streets"; 
     50060DELETE FROM sqlite_sequence WHERE name='streets' 
     50061success! 
     50062DELETE FROM "crew"; 
     50063DELETE FROM sqlite_sequence WHERE name='crew' 
     50064success! 
     50065DELETE FROM "supervisors"; 
     50066DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50067success! 
     50068DELETE FROM "streets"; 
     50069DELETE FROM sqlite_sequence WHERE name='streets' 
     50070success! 
     50071DELETE FROM "crew"; 
     50072DELETE FROM sqlite_sequence WHERE name='crew' 
     50073success! 
     50074DELETE FROM "supervisors"; 
     50075DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50076success! 
     50077DELETE FROM "streets"; 
     50078DELETE FROM sqlite_sequence WHERE name='streets' 
     50079success! 
     50080DELETE FROM "crew"; 
     50081DELETE FROM sqlite_sequence WHERE name='crew' 
     50082success! 
     50083DELETE FROM "supervisors"; 
     50084DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50085success! 
     50086DELETE FROM "streets"; 
     50087DELETE FROM sqlite_sequence WHERE name='streets' 
     50088success! 
     50089DELETE FROM "crew"; 
     50090DELETE FROM sqlite_sequence WHERE name='crew' 
     50091success! 
     50092DELETE FROM "supervisors"; 
     50093DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50094success! 
     50095DELETE FROM "streets"; 
     50096DELETE FROM sqlite_sequence WHERE name='streets' 
     50097success! 
     50098DELETE FROM "crew"; 
     50099DELETE FROM sqlite_sequence WHERE name='crew' 
     50100success! 
     50101DELETE FROM "supervisors"; 
     50102DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50103success! 
     50104DELETE FROM "streets"; 
     50105DELETE FROM sqlite_sequence WHERE name='streets' 
     50106success! 
     50107DELETE FROM "crew"; 
     50108DELETE FROM sqlite_sequence WHERE name='crew' 
     50109success! 
     50110DELETE FROM "supervisors"; 
     50111DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50112success! 
     50113DELETE FROM "streets"; 
     50114DELETE FROM sqlite_sequence WHERE name='streets' 
     50115success! 
     50116DELETE FROM "crew"; 
     50117DELETE FROM sqlite_sequence WHERE name='crew' 
     50118success! 
     50119DELETE FROM "supervisors"; 
     50120DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50121success! 
     50122DELETE FROM "streets"; 
     50123DELETE FROM sqlite_sequence WHERE name='streets' 
     50124success! 
     50125DELETE FROM "crew"; 
     50126DELETE FROM sqlite_sequence WHERE name='crew' 
     50127success! 
     50128DELETE FROM "supervisors"; 
     50129DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50130success! 
     50131DELETE FROM "streets"; 
     50132DELETE FROM sqlite_sequence WHERE name='streets' 
     50133success! 
     50134DELETE FROM "crew"; 
     50135DELETE FROM sqlite_sequence WHERE name='crew' 
     50136success! 
     50137DELETE FROM "supervisors"; 
     50138DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50139success! 
     50140DELETE FROM "streets"; 
     50141DELETE FROM sqlite_sequence WHERE name='streets' 
     50142success! 
     50143DELETE FROM "crew"; 
     50144DELETE FROM sqlite_sequence WHERE name='crew' 
     50145success! 
     50146DELETE FROM "supervisors"; 
     50147DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50148success! 
     50149DELETE FROM "streets"; 
     50150DELETE FROM sqlite_sequence WHERE name='streets' 
     50151success! 
     50152DELETE FROM "crew"; 
     50153DELETE FROM sqlite_sequence WHERE name='crew' 
     50154success! 
     50155DELETE FROM "supervisors"; 
     50156DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50157success! 
     50158DELETE FROM "streets"; 
     50159DELETE FROM sqlite_sequence WHERE name='streets' 
     50160success! 
     50161DELETE FROM "crew"; 
     50162DELETE FROM sqlite_sequence WHERE name='crew' 
     50163success! 
     50164DELETE FROM "supervisors"; 
     50165DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50166success! 
     50167DELETE FROM "streets"; 
     50168DELETE FROM sqlite_sequence WHERE name='streets' 
     50169success! 
     50170DELETE FROM "crew"; 
     50171DELETE FROM sqlite_sequence WHERE name='crew' 
     50172success! 
     50173DELETE FROM "supervisors"; 
     50174DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50175success! 
     50176DELETE FROM "streets"; 
     50177DELETE FROM sqlite_sequence WHERE name='streets' 
     50178success! 
     50179DELETE FROM "crew"; 
     50180DELETE FROM sqlite_sequence WHERE name='crew' 
     50181success! 
     50182DELETE FROM "supervisors"; 
     50183DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50184success! 
     50185DELETE FROM "streets"; 
     50186DELETE FROM sqlite_sequence WHERE name='streets' 
     50187success! 
     50188DELETE FROM "crew"; 
     50189DELETE FROM sqlite_sequence WHERE name='crew' 
     50190success! 
     50191DELETE FROM "supervisors"; 
     50192DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50193success! 
     50194DELETE FROM "streets"; 
     50195DELETE FROM sqlite_sequence WHERE name='streets' 
     50196success! 
     50197DELETE FROM "crew"; 
     50198DELETE FROM sqlite_sequence WHERE name='crew' 
     50199success! 
     50200DELETE FROM "supervisors"; 
     50201DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50202success! 
     50203DELETE FROM "streets"; 
     50204DELETE FROM sqlite_sequence WHERE name='streets' 
     50205success! 
     50206DELETE FROM "crew"; 
     50207DELETE FROM sqlite_sequence WHERE name='crew' 
     50208success! 
     50209DELETE FROM "supervisors"; 
     50210DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50211success! 
     50212DELETE FROM "streets"; 
     50213DELETE FROM sqlite_sequence WHERE name='streets' 
     50214success! 
     50215DELETE FROM "crew"; 
     50216DELETE FROM sqlite_sequence WHERE name='crew' 
     50217success! 
     50218DELETE FROM "supervisors"; 
     50219DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50220success! 
     50221DELETE FROM "streets"; 
     50222DELETE FROM sqlite_sequence WHERE name='streets' 
     50223success! 
     50224DELETE FROM "crew"; 
     50225DELETE FROM sqlite_sequence WHERE name='crew' 
     50226success! 
     50227DELETE FROM "supervisors"; 
     50228DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50229success! 
     50230DELETE FROM "streets"; 
     50231DELETE FROM sqlite_sequence WHERE name='streets' 
     50232success! 
     50233DELETE FROM "crew"; 
     50234DELETE FROM sqlite_sequence WHERE name='crew' 
     50235success! 
     50236DELETE FROM "supervisors"; 
     50237DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50238success! 
     50239DELETE FROM "streets"; 
     50240DELETE FROM sqlite_sequence WHERE name='streets' 
     50241success! 
     50242DELETE FROM "crew"; 
     50243DELETE FROM sqlite_sequence WHERE name='crew' 
     50244success! 
     50245DELETE FROM "supervisors"; 
     50246DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50247success! 
     50248DELETE FROM "streets"; 
     50249DELETE FROM sqlite_sequence WHERE name='streets' 
     50250success! 
     50251DELETE FROM "crew"; 
     50252DELETE FROM sqlite_sequence WHERE name='crew' 
     50253success! 
     50254DELETE FROM "supervisors"; 
     50255DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50256success! 
     50257DELETE FROM "streets"; 
     50258DELETE FROM sqlite_sequence WHERE name='streets' 
     50259success! 
     50260DELETE FROM "crew"; 
     50261DELETE FROM sqlite_sequence WHERE name='crew' 
     50262success! 
     50263DELETE FROM "supervisors"; 
     50264DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50265success! 
     50266DELETE FROM "streets"; 
     50267DELETE FROM sqlite_sequence WHERE name='streets' 
     50268success! 
     50269DELETE FROM "crew"; 
     50270DELETE FROM sqlite_sequence WHERE name='crew' 
     50271success! 
     50272DELETE FROM "supervisors"; 
     50273DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50274success! 
     50275DELETE FROM "streets"; 
     50276DELETE FROM sqlite_sequence WHERE name='streets' 
     50277success! 
     50278DELETE FROM "crew"; 
     50279DELETE FROM sqlite_sequence WHERE name='crew' 
     50280success! 
     50281DELETE FROM "supervisors"; 
     50282DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50283success! 
     50284DELETE FROM "streets"; 
     50285DELETE FROM sqlite_sequence WHERE name='streets' 
     50286success! 
     50287DELETE FROM "crew"; 
     50288DELETE FROM sqlite_sequence WHERE name='crew' 
     50289success! 
     50290DELETE FROM "supervisors"; 
     50291DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50292success! 
     50293DELETE FROM "streets"; 
     50294DELETE FROM sqlite_sequence WHERE name='streets' 
     50295success! 
     50296DELETE FROM "crew"; 
     50297DELETE FROM sqlite_sequence WHERE name='crew' 
     50298success! 
     50299DELETE FROM "supervisors"; 
     50300DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50301success! 
     50302DELETE FROM "streets"; 
     50303DELETE FROM sqlite_sequence WHERE name='streets' 
     50304success! 
     50305DELETE FROM "crew"; 
     50306DELETE FROM sqlite_sequence WHERE name='crew' 
     50307success! 
     50308DELETE FROM "supervisors"; 
     50309DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50310success! 
     50311DELETE FROM "streets"; 
     50312DELETE FROM sqlite_sequence WHERE name='streets' 
     50313success! 
     50314DELETE FROM "crew"; 
     50315DELETE FROM sqlite_sequence WHERE name='crew' 
     50316success! 
     50317DELETE FROM "supervisors"; 
     50318DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50319success! 
     50320DELETE FROM "streets"; 
     50321DELETE FROM sqlite_sequence WHERE name='streets' 
     50322success! 
     50323DELETE FROM "crew"; 
     50324DELETE FROM sqlite_sequence WHERE name='crew' 
     50325success! 
     50326DELETE FROM "supervisors"; 
     50327DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50328success! 
     50329DELETE FROM "streets"; 
     50330DELETE FROM sqlite_sequence WHERE name='streets' 
     50331success! 
     50332DELETE FROM "crew"; 
     50333DELETE FROM sqlite_sequence WHERE name='crew' 
     50334success! 
     50335DELETE FROM "supervisors"; 
     50336DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50337success! 
     50338DELETE FROM "streets"; 
     50339DELETE FROM sqlite_sequence WHERE name='streets' 
     50340success! 
     50341DELETE FROM "crew"; 
     50342DELETE FROM sqlite_sequence WHERE name='crew' 
     50343success! 
     50344DELETE FROM "supervisors"; 
     50345DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50346success! 
     50347DELETE FROM "streets"; 
     50348DELETE FROM sqlite_sequence WHERE name='streets' 
     50349success! 
     50350DELETE FROM "crew"; 
     50351DELETE FROM sqlite_sequence WHERE name='crew' 
     50352success! 
     50353DELETE FROM "supervisors"; 
     50354DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50355success! 
     50356DELETE FROM "streets"; 
     50357DELETE FROM sqlite_sequence WHERE name='streets' 
     50358success! 
     50359DELETE FROM "crew"; 
     50360DELETE FROM sqlite_sequence WHERE name='crew' 
     50361success! 
     50362DELETE FROM "supervisors"; 
     50363DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50364success! 
     50365DELETE FROM "streets"; 
     50366DELETE FROM sqlite_sequence WHERE name='streets' 
     50367success! 
     50368DELETE FROM "crew"; 
     50369DELETE FROM sqlite_sequence WHERE name='crew' 
     50370success! 
     50371DELETE FROM "supervisors"; 
     50372DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50373success! 
     50374DELETE FROM "streets"; 
     50375DELETE FROM sqlite_sequence WHERE name='streets' 
     50376success! 
     50377DELETE FROM "crew"; 
     50378DELETE FROM sqlite_sequence WHERE name='crew' 
     50379success! 
     50380DELETE FROM "supervisors"; 
     50381DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50382success! 
     50383DELETE FROM "streets"; 
     50384DELETE FROM sqlite_sequence WHERE name='streets' 
     50385success! 
     50386DELETE FROM "crew"; 
     50387DELETE FROM sqlite_sequence WHERE name='crew' 
     50388success! 
     50389DELETE FROM "supervisors"; 
     50390DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50391success! 
     50392DELETE FROM "streets"; 
     50393DELETE FROM sqlite_sequence WHERE name='streets' 
     50394success! 
     50395DELETE FROM "crew"; 
     50396DELETE FROM sqlite_sequence WHERE name='crew' 
     50397success! 
     50398DELETE FROM "supervisors"; 
     50399DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50400success! 
     50401DELETE FROM "streets"; 
     50402DELETE FROM sqlite_sequence WHERE name='streets' 
     50403success! 
     50404DELETE FROM "crew"; 
     50405DELETE FROM sqlite_sequence WHERE name='crew' 
     50406success! 
     50407DELETE FROM "supervisors"; 
     50408DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50409success! 
     50410DELETE FROM "streets"; 
     50411DELETE FROM sqlite_sequence WHERE name='streets' 
     50412success! 
     50413DELETE FROM "crew"; 
     50414DELETE FROM sqlite_sequence WHERE name='crew' 
     50415success! 
     50416DELETE FROM "supervisors"; 
     50417DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50418success! 
     50419DELETE FROM "streets"; 
     50420DELETE FROM sqlite_sequence WHERE name='streets' 
     50421success! 
     50422DELETE FROM "crew"; 
     50423DELETE FROM sqlite_sequence WHERE name='crew' 
     50424success! 
     50425DELETE FROM "supervisors"; 
     50426DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50427success! 
     50428DELETE FROM "streets"; 
     50429DELETE FROM sqlite_sequence WHERE name='streets' 
     50430success! 
     50431DELETE FROM "crew"; 
     50432DELETE FROM sqlite_sequence WHERE name='crew' 
     50433success! 
     50434DELETE FROM "supervisors"; 
     50435DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50436success! 
     50437DELETE FROM "streets"; 
     50438DELETE FROM sqlite_sequence WHERE name='streets' 
     50439success! 
     50440DELETE FROM "crew"; 
     50441DELETE FROM sqlite_sequence WHERE name='crew' 
     50442success! 
     50443DELETE FROM "supervisors"; 
     50444DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50445success! 
     50446DELETE FROM "streets"; 
     50447DELETE FROM sqlite_sequence WHERE name='streets' 
     50448success! 
     50449DELETE FROM "crew"; 
     50450DELETE FROM sqlite_sequence WHERE name='crew' 
     50451success! 
     50452DELETE FROM "supervisors"; 
     50453DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50454success! 
     50455DELETE FROM "streets"; 
     50456DELETE FROM sqlite_sequence WHERE name='streets' 
     50457success! 
     50458DELETE FROM "crew"; 
     50459DELETE FROM sqlite_sequence WHERE name='crew' 
     50460success! 
     50461DELETE FROM "supervisors"; 
     50462DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50463success! 
     50464DELETE FROM "streets"; 
     50465DELETE FROM sqlite_sequence WHERE name='streets' 
     50466success! 
     50467DELETE FROM "crew"; 
     50468DELETE FROM sqlite_sequence WHERE name='crew' 
     50469success! 
     50470DELETE FROM "supervisors"; 
     50471DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50472success! 
     50473DELETE FROM "streets"; 
     50474DELETE FROM sqlite_sequence WHERE name='streets' 
     50475success! 
     50476DELETE FROM "crew"; 
     50477DELETE FROM sqlite_sequence WHERE name='crew' 
     50478success! 
     50479DELETE FROM "supervisors"; 
     50480DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50481success! 
     50482DELETE FROM "streets"; 
     50483DELETE FROM sqlite_sequence WHERE name='streets' 
     50484success! 
     50485DELETE FROM "crew"; 
     50486DELETE FROM sqlite_sequence WHERE name='crew' 
     50487success! 
     50488DELETE FROM "supervisors"; 
     50489DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50490success! 
     50491DELETE FROM "streets"; 
     50492DELETE FROM sqlite_sequence WHERE name='streets' 
     50493success! 
     50494DELETE FROM "crew"; 
     50495DELETE FROM sqlite_sequence WHERE name='crew' 
     50496success! 
     50497DELETE FROM "supervisors"; 
     50498DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50499success! 
     50500DELETE FROM "streets"; 
     50501DELETE FROM sqlite_sequence WHERE name='streets' 
     50502success! 
     50503DELETE FROM "crew"; 
     50504DELETE FROM sqlite_sequence WHERE name='crew' 
     50505success! 
     50506DELETE FROM "supervisors"; 
     50507DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50508success! 
     50509DELETE FROM "streets"; 
     50510DELETE FROM sqlite_sequence WHERE name='streets' 
     50511success! 
     50512DELETE FROM "crew"; 
     50513DELETE FROM sqlite_sequence WHERE name='crew' 
     50514success! 
     50515DELETE FROM "supervisors"; 
     50516DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50517success! 
     50518DELETE FROM "streets"; 
     50519DELETE FROM sqlite_sequence WHERE name='streets' 
     50520success! 
     50521DELETE FROM "crew"; 
     50522DELETE FROM sqlite_sequence WHERE name='crew' 
     50523success! 
     50524DELETE FROM "supervisors"; 
     50525DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50526success! 
     50527DELETE FROM "streets"; 
     50528DELETE FROM sqlite_sequence WHERE name='streets' 
     50529success! 
     50530DELETE FROM "crew"; 
     50531DELETE FROM sqlite_sequence WHERE name='crew' 
     50532success! 
     50533DELETE FROM "supervisors"; 
     50534DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50535success! 
     50536DELETE FROM "streets"; 
     50537DELETE FROM sqlite_sequence WHERE name='streets' 
     50538success! 
     50539DELETE FROM "crew"; 
     50540DELETE FROM sqlite_sequence WHERE name='crew' 
     50541success! 
     50542DELETE FROM "supervisors"; 
     50543DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50544success! 
     50545DELETE FROM "streets"; 
     50546DELETE FROM sqlite_sequence WHERE name='streets' 
     50547success! 
     50548DELETE FROM "crew"; 
     50549DELETE FROM sqlite_sequence WHERE name='crew' 
     50550success! 
     50551DELETE FROM "supervisors"; 
     50552DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50553success! 
     50554DELETE FROM "streets"; 
     50555DELETE FROM sqlite_sequence WHERE name='streets' 
     50556success! 
     50557DELETE FROM "crew"; 
     50558DELETE FROM sqlite_sequence WHERE name='crew' 
     50559success! 
     50560DELETE FROM "supervisors"; 
     50561DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50562success! 
     50563DELETE FROM "streets"; 
     50564DELETE FROM sqlite_sequence WHERE name='streets' 
     50565success! 
     50566DELETE FROM "crew"; 
     50567DELETE FROM sqlite_sequence WHERE name='crew' 
     50568success! 
     50569DELETE FROM "supervisors"; 
     50570DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50571success! 
     50572DELETE FROM "streets"; 
     50573DELETE FROM sqlite_sequence WHERE name='streets' 
     50574success! 
     50575DELETE FROM "crew"; 
     50576DELETE FROM sqlite_sequence WHERE name='crew' 
     50577success! 
     50578DELETE FROM "supervisors"; 
     50579DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50580success! 
     50581DELETE FROM "streets"; 
     50582DELETE FROM sqlite_sequence WHERE name='streets' 
     50583success! 
     50584DELETE FROM "crew"; 
     50585DELETE FROM sqlite_sequence WHERE name='crew' 
     50586success! 
     50587DELETE FROM "supervisors"; 
     50588DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50589success! 
     50590DELETE FROM "streets"; 
     50591DELETE FROM sqlite_sequence WHERE name='streets' 
     50592success! 
     50593DELETE FROM "crew"; 
     50594DELETE FROM sqlite_sequence WHERE name='crew' 
     50595success! 
     50596DELETE FROM "supervisors"; 
     50597DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50598success! 
     50599DELETE FROM "streets"; 
     50600DELETE FROM sqlite_sequence WHERE name='streets' 
     50601success! 
     50602DELETE FROM "crew"; 
     50603DELETE FROM sqlite_sequence WHERE name='crew' 
     50604success! 
     50605DELETE FROM "supervisors"; 
     50606DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50607success! 
     50608DELETE FROM "streets"; 
     50609DELETE FROM sqlite_sequence WHERE name='streets' 
     50610success! 
     50611DELETE FROM "crew"; 
     50612DELETE FROM sqlite_sequence WHERE name='crew' 
     50613success! 
     50614DELETE FROM "supervisors"; 
     50615DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50616success! 
     50617DELETE FROM "streets"; 
     50618DELETE FROM sqlite_sequence WHERE name='streets' 
     50619success! 
     50620DELETE FROM "crew"; 
     50621DELETE FROM sqlite_sequence WHERE name='crew' 
     50622success! 
     50623DELETE FROM "supervisors"; 
     50624DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50625success! 
     50626DELETE FROM "streets"; 
     50627DELETE FROM sqlite_sequence WHERE name='streets' 
     50628success! 
     50629DELETE FROM "crew"; 
     50630DELETE FROM sqlite_sequence WHERE name='crew' 
     50631success! 
     50632DELETE FROM "supervisors"; 
     50633DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50634success! 
     50635DELETE FROM "streets"; 
     50636DELETE FROM sqlite_sequence WHERE name='streets' 
     50637success! 
     50638DELETE FROM "crew"; 
     50639DELETE FROM sqlite_sequence WHERE name='crew' 
     50640success! 
     50641DELETE FROM "supervisors"; 
     50642DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50643success! 
     50644DELETE FROM "streets"; 
     50645DELETE FROM sqlite_sequence WHERE name='streets' 
     50646success! 
     50647DELETE FROM "crew"; 
     50648DELETE FROM sqlite_sequence WHERE name='crew' 
     50649success! 
     50650DELETE FROM "supervisors"; 
     50651DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50652success! 
     50653DELETE FROM "streets"; 
     50654DELETE FROM sqlite_sequence WHERE name='streets' 
     50655success! 
     50656DELETE FROM "crew"; 
     50657DELETE FROM sqlite_sequence WHERE name='crew' 
     50658success! 
     50659DELETE FROM "supervisors"; 
     50660DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50661success! 
     50662DELETE FROM "streets"; 
     50663DELETE FROM sqlite_sequence WHERE name='streets' 
     50664success! 
     50665DELETE FROM "crew"; 
     50666DELETE FROM sqlite_sequence WHERE name='crew' 
     50667success! 
     50668DELETE FROM "supervisors"; 
     50669DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50670success! 
     50671DELETE FROM "streets"; 
     50672DELETE FROM sqlite_sequence WHERE name='streets' 
     50673success! 
     50674DELETE FROM "crew"; 
     50675DELETE FROM sqlite_sequence WHERE name='crew' 
     50676success! 
     50677DELETE FROM "supervisors"; 
     50678DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50679success! 
     50680DELETE FROM "streets"; 
     50681DELETE FROM sqlite_sequence WHERE name='streets' 
     50682success! 
     50683DELETE FROM "crew"; 
     50684DELETE FROM sqlite_sequence WHERE name='crew' 
     50685success! 
     50686DELETE FROM "supervisors"; 
     50687DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50688success! 
     50689DELETE FROM "streets"; 
     50690DELETE FROM sqlite_sequence WHERE name='streets' 
     50691success! 
     50692DELETE FROM "crew"; 
     50693DELETE FROM sqlite_sequence WHERE name='crew' 
     50694success! 
     50695DELETE FROM "supervisors"; 
     50696DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50697success! 
     50698DELETE FROM "streets"; 
     50699DELETE FROM sqlite_sequence WHERE name='streets' 
     50700success! 
     50701DELETE FROM "crew"; 
     50702DELETE FROM sqlite_sequence WHERE name='crew' 
     50703success! 
     50704DELETE FROM "supervisors"; 
     50705DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50706success! 
     50707DELETE FROM "streets"; 
     50708DELETE FROM sqlite_sequence WHERE name='streets' 
     50709success! 
     50710DELETE FROM "crew"; 
     50711DELETE FROM sqlite_sequence WHERE name='crew' 
     50712success! 
     50713DELETE FROM "supervisors"; 
     50714DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50715success! 
     50716DELETE FROM "streets"; 
     50717DELETE FROM sqlite_sequence WHERE name='streets' 
     50718success! 
     50719DELETE FROM "crew"; 
     50720DELETE FROM sqlite_sequence WHERE name='crew' 
     50721success! 
     50722DELETE FROM "supervisors"; 
     50723DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50724success! 
     50725DELETE FROM "streets"; 
     50726DELETE FROM sqlite_sequence WHERE name='streets' 
     50727success! 
     50728DELETE FROM "crew"; 
     50729DELETE FROM sqlite_sequence WHERE name='crew' 
     50730success! 
     50731DELETE FROM "supervisors"; 
     50732DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50733success! 
     50734DELETE FROM "streets"; 
     50735DELETE FROM sqlite_sequence WHERE name='streets' 
     50736success! 
     50737DELETE FROM "crew"; 
     50738DELETE FROM sqlite_sequence WHERE name='crew' 
     50739success! 
     50740DELETE FROM "supervisors"; 
     50741DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50742success! 
     50743DELETE FROM "streets"; 
     50744DELETE FROM sqlite_sequence WHERE name='streets' 
     50745success! 
     50746DELETE FROM "crew"; 
     50747DELETE FROM sqlite_sequence WHERE name='crew' 
     50748success! 
     50749DELETE FROM "supervisors"; 
     50750DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50751success! 
     50752DELETE FROM "streets"; 
     50753DELETE FROM sqlite_sequence WHERE name='streets' 
     50754success! 
     50755DELETE FROM "crew"; 
     50756DELETE FROM sqlite_sequence WHERE name='crew' 
     50757success! 
     50758DELETE FROM "supervisors"; 
     50759DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50760success! 
     50761DELETE FROM "streets"; 
     50762DELETE FROM sqlite_sequence WHERE name='streets' 
     50763success! 
     50764DELETE FROM "crew"; 
     50765DELETE FROM sqlite_sequence WHERE name='crew' 
     50766success! 
     50767DELETE FROM "supervisors"; 
     50768DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50769success! 
     50770DELETE FROM "streets"; 
     50771DELETE FROM sqlite_sequence WHERE name='streets' 
     50772success! 
     50773DELETE FROM "crew"; 
     50774DELETE FROM sqlite_sequence WHERE name='crew' 
     50775success! 
     50776DELETE FROM "supervisors"; 
     50777DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50778success! 
     50779DELETE FROM "streets"; 
     50780DELETE FROM sqlite_sequence WHERE name='streets' 
     50781success! 
     50782DELETE FROM "crew"; 
     50783DELETE FROM sqlite_sequence WHERE name='crew' 
     50784success! 
     50785DELETE FROM "supervisors"; 
     50786DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50787success! 
     50788DELETE FROM "streets"; 
     50789DELETE FROM sqlite_sequence WHERE name='streets' 
     50790success! 
     50791DELETE FROM "crew"; 
     50792DELETE FROM sqlite_sequence WHERE name='crew' 
     50793success! 
     50794DELETE FROM "supervisors"; 
     50795DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50796success! 
     50797DELETE FROM "streets"; 
     50798DELETE FROM sqlite_sequence WHERE name='streets' 
     50799success! 
     50800DELETE FROM "crew"; 
     50801DELETE FROM sqlite_sequence WHERE name='crew' 
     50802success! 
     50803DELETE FROM "supervisors"; 
     50804DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50805success! 
     50806DELETE FROM "streets"; 
     50807DELETE FROM sqlite_sequence WHERE name='streets' 
     50808success! 
     50809DELETE FROM "crew"; 
     50810DELETE FROM sqlite_sequence WHERE name='crew' 
     50811success! 
     50812DELETE FROM "supervisors"; 
     50813DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50814success! 
     50815DELETE FROM "streets"; 
     50816DELETE FROM sqlite_sequence WHERE name='streets' 
     50817success! 
     50818DELETE FROM "crew"; 
     50819DELETE FROM sqlite_sequence WHERE name='crew' 
     50820success! 
     50821DELETE FROM "supervisors"; 
     50822DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50823success! 
     50824DELETE FROM "streets"; 
     50825DELETE FROM sqlite_sequence WHERE name='streets' 
     50826success! 
     50827DELETE FROM "crew"; 
     50828DELETE FROM sqlite_sequence WHERE name='crew' 
     50829success! 
     50830DELETE FROM "supervisors"; 
     50831DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50832success! 
     50833DELETE FROM "streets"; 
     50834DELETE FROM sqlite_sequence WHERE name='streets' 
     50835success! 
     50836DELETE FROM "crew"; 
     50837DELETE FROM sqlite_sequence WHERE name='crew' 
     50838success! 
     50839DELETE FROM "supervisors"; 
     50840DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50841success! 
     50842DELETE FROM "streets"; 
     50843DELETE FROM sqlite_sequence WHERE name='streets' 
     50844success! 
     50845DELETE FROM "crew"; 
     50846DELETE FROM sqlite_sequence WHERE name='crew' 
     50847success! 
     50848DELETE FROM "supervisors"; 
     50849DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50850success! 
     50851DELETE FROM "streets"; 
     50852DELETE FROM sqlite_sequence WHERE name='streets' 
     50853success! 
     50854DELETE FROM "crew"; 
     50855DELETE FROM sqlite_sequence WHERE name='crew' 
     50856success! 
     50857DELETE FROM "supervisors"; 
     50858DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50859success! 
     50860DELETE FROM "streets"; 
     50861DELETE FROM sqlite_sequence WHERE name='streets' 
     50862success! 
     50863DELETE FROM "crew"; 
     50864DELETE FROM sqlite_sequence WHERE name='crew' 
     50865success! 
     50866DELETE FROM "supervisors"; 
     50867DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50868success! 
     50869DELETE FROM "streets"; 
     50870DELETE FROM sqlite_sequence WHERE name='streets' 
     50871success! 
     50872DELETE FROM "crew"; 
     50873DELETE FROM sqlite_sequence WHERE name='crew' 
     50874success! 
     50875DELETE FROM "supervisors"; 
     50876DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50877success! 
     50878DELETE FROM "streets"; 
     50879DELETE FROM sqlite_sequence WHERE name='streets' 
     50880success! 
     50881DELETE FROM "crew"; 
     50882DELETE FROM sqlite_sequence WHERE name='crew' 
     50883success! 
     50884DELETE FROM "supervisors"; 
     50885DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50886success! 
     50887DELETE FROM "streets"; 
     50888DELETE FROM sqlite_sequence WHERE name='streets' 
     50889success! 
     50890DELETE FROM "crew"; 
     50891DELETE FROM sqlite_sequence WHERE name='crew' 
     50892success! 
     50893DELETE FROM "supervisors"; 
     50894DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50895success! 
     50896DELETE FROM "streets"; 
     50897DELETE FROM sqlite_sequence WHERE name='streets' 
     50898success! 
     50899DELETE FROM "crew"; 
     50900DELETE FROM sqlite_sequence WHERE name='crew' 
     50901success! 
     50902DELETE FROM "supervisors"; 
     50903DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50904success! 
     50905DELETE FROM "streets"; 
     50906DELETE FROM sqlite_sequence WHERE name='streets' 
     50907success! 
     50908DELETE FROM "crew"; 
     50909DELETE FROM sqlite_sequence WHERE name='crew' 
     50910success! 
     50911DELETE FROM "supervisors"; 
     50912DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50913success! 
     50914DELETE FROM "streets"; 
     50915DELETE FROM sqlite_sequence WHERE name='streets' 
     50916success! 
     50917DELETE FROM "crew"; 
     50918DELETE FROM sqlite_sequence WHERE name='crew' 
     50919success! 
     50920DELETE FROM "supervisors"; 
     50921DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50922success! 
     50923DELETE FROM "streets"; 
     50924DELETE FROM sqlite_sequence WHERE name='streets' 
     50925success! 
     50926DELETE FROM "crew"; 
     50927DELETE FROM sqlite_sequence WHERE name='crew' 
     50928success! 
     50929DELETE FROM "supervisors"; 
     50930DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50931success! 
     50932DELETE FROM "streets"; 
     50933DELETE FROM sqlite_sequence WHERE name='streets' 
     50934success! 
     50935DELETE FROM "crew"; 
     50936DELETE FROM sqlite_sequence WHERE name='crew' 
     50937success! 
     50938DELETE FROM "supervisors"; 
     50939DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50940success! 
     50941DELETE FROM "streets"; 
     50942DELETE FROM sqlite_sequence WHERE name='streets' 
     50943success! 
     50944DELETE FROM "crew"; 
     50945DELETE FROM sqlite_sequence WHERE name='crew' 
     50946success! 
     50947DELETE FROM "supervisors"; 
     50948DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50949success! 
     50950DELETE FROM "streets"; 
     50951DELETE FROM sqlite_sequence WHERE name='streets' 
     50952success! 
     50953DELETE FROM "crew"; 
     50954DELETE FROM sqlite_sequence WHERE name='crew' 
     50955success! 
     50956DELETE FROM "supervisors"; 
     50957DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50958success! 
     50959DELETE FROM "streets"; 
     50960DELETE FROM sqlite_sequence WHERE name='streets' 
     50961success! 
     50962DELETE FROM "crew"; 
     50963DELETE FROM sqlite_sequence WHERE name='crew' 
     50964success! 
     50965DELETE FROM "supervisors"; 
     50966DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50967success! 
     50968DELETE FROM "streets"; 
     50969DELETE FROM sqlite_sequence WHERE name='streets' 
     50970success! 
     50971DELETE FROM "crew"; 
     50972DELETE FROM sqlite_sequence WHERE name='crew' 
     50973success! 
     50974DELETE FROM "supervisors"; 
     50975DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50976success! 
     50977DELETE FROM "streets"; 
     50978DELETE FROM sqlite_sequence WHERE name='streets' 
     50979success! 
     50980DELETE FROM "crew"; 
     50981DELETE FROM sqlite_sequence WHERE name='crew' 
     50982success! 
     50983DELETE FROM "supervisors"; 
     50984DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50985success! 
     50986DELETE FROM "streets"; 
     50987DELETE FROM sqlite_sequence WHERE name='streets' 
     50988success! 
     50989DELETE FROM "crew"; 
     50990DELETE FROM sqlite_sequence WHERE name='crew' 
     50991success! 
     50992DELETE FROM "supervisors"; 
     50993DELETE FROM sqlite_sequence WHERE name='supervisors' 
     50994success! 
     50995DELETE FROM "streets"; 
     50996DELETE FROM sqlite_sequence WHERE name='streets' 
     50997success! 
     50998DELETE FROM "crew"; 
     50999DELETE FROM sqlite_sequence WHERE name='crew' 
     51000success! 
     51001DELETE FROM "supervisors"; 
     51002DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51003success! 
     51004DELETE FROM "streets"; 
     51005DELETE FROM sqlite_sequence WHERE name='streets' 
     51006success! 
     51007DELETE FROM "crew"; 
     51008DELETE FROM sqlite_sequence WHERE name='crew' 
     51009success! 
     51010DELETE FROM "supervisors"; 
     51011DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51012success! 
     51013DELETE FROM "streets"; 
     51014DELETE FROM sqlite_sequence WHERE name='streets' 
     51015success! 
     51016DELETE FROM "crew"; 
     51017DELETE FROM sqlite_sequence WHERE name='crew' 
     51018success! 
     51019DELETE FROM "supervisors"; 
     51020DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51021success! 
     51022DELETE FROM "streets"; 
     51023DELETE FROM sqlite_sequence WHERE name='streets' 
     51024success! 
     51025DELETE FROM "crew"; 
     51026DELETE FROM sqlite_sequence WHERE name='crew' 
     51027success! 
     51028DELETE FROM "supervisors"; 
     51029DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51030success! 
     51031DELETE FROM "streets"; 
     51032DELETE FROM sqlite_sequence WHERE name='streets' 
     51033success! 
     51034DELETE FROM "crew"; 
     51035DELETE FROM sqlite_sequence WHERE name='crew' 
     51036success! 
     51037DELETE FROM "supervisors"; 
     51038DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51039success! 
     51040DELETE FROM "streets"; 
     51041DELETE FROM sqlite_sequence WHERE name='streets' 
     51042success! 
     51043DELETE FROM "crew"; 
     51044DELETE FROM sqlite_sequence WHERE name='crew' 
     51045success! 
     51046DELETE FROM "supervisors"; 
     51047DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51048success! 
     51049DELETE FROM "streets"; 
     51050DELETE FROM sqlite_sequence WHERE name='streets' 
     51051success! 
     51052DELETE FROM "crew"; 
     51053DELETE FROM sqlite_sequence WHERE name='crew' 
     51054success! 
     51055DELETE FROM "supervisors"; 
     51056DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51057success! 
     51058DELETE FROM "streets"; 
     51059DELETE FROM sqlite_sequence WHERE name='streets' 
     51060success! 
     51061DELETE FROM "crew"; 
     51062DELETE FROM sqlite_sequence WHERE name='crew' 
     51063success! 
     51064DELETE FROM "supervisors"; 
     51065DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51066success! 
     51067DELETE FROM "streets"; 
     51068DELETE FROM sqlite_sequence WHERE name='streets' 
     51069success! 
     51070DELETE FROM "crew"; 
     51071DELETE FROM sqlite_sequence WHERE name='crew' 
     51072success! 
     51073DELETE FROM "supervisors"; 
     51074DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51075success! 
     51076DELETE FROM "streets"; 
     51077DELETE FROM sqlite_sequence WHERE name='streets' 
     51078success! 
     51079DELETE FROM "crew"; 
     51080DELETE FROM sqlite_sequence WHERE name='crew' 
     51081success! 
     51082DELETE FROM "supervisors"; 
     51083DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51084success! 
     51085DELETE FROM "streets"; 
     51086DELETE FROM sqlite_sequence WHERE name='streets' 
     51087success! 
     51088DELETE FROM "crew"; 
     51089DELETE FROM sqlite_sequence WHERE name='crew' 
     51090success! 
     51091DELETE FROM "supervisors"; 
     51092DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51093success! 
     51094DELETE FROM "streets"; 
     51095DELETE FROM sqlite_sequence WHERE name='streets' 
     51096success! 
     51097DELETE FROM "crew"; 
     51098DELETE FROM sqlite_sequence WHERE name='crew' 
     51099success! 
     51100DELETE FROM "supervisors"; 
     51101DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51102success! 
     51103DELETE FROM "streets"; 
     51104DELETE FROM sqlite_sequence WHERE name='streets' 
     51105success! 
     51106DELETE FROM "crew"; 
     51107DELETE FROM sqlite_sequence WHERE name='crew' 
     51108success! 
     51109DELETE FROM "supervisors"; 
     51110DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51111success! 
     51112DELETE FROM "streets"; 
     51113DELETE FROM sqlite_sequence WHERE name='streets' 
     51114success! 
     51115DELETE FROM "crew"; 
     51116DELETE FROM sqlite_sequence WHERE name='crew' 
     51117success! 
     51118DELETE FROM "supervisors"; 
     51119DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51120success! 
     51121DELETE FROM "streets"; 
     51122DELETE FROM sqlite_sequence WHERE name='streets' 
     51123success! 
     51124DELETE FROM "crew"; 
     51125DELETE FROM sqlite_sequence WHERE name='crew' 
     51126success! 
     51127DELETE FROM "supervisors"; 
     51128DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51129success! 
     51130DELETE FROM "streets"; 
     51131DELETE FROM sqlite_sequence WHERE name='streets' 
     51132success! 
     51133DELETE FROM "crew"; 
     51134DELETE FROM sqlite_sequence WHERE name='crew' 
     51135success! 
     51136DELETE FROM "supervisors"; 
     51137DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51138success! 
     51139DELETE FROM "streets"; 
     51140DELETE FROM sqlite_sequence WHERE name='streets' 
     51141success! 
     51142DELETE FROM "crew"; 
     51143DELETE FROM sqlite_sequence WHERE name='crew' 
     51144success! 
     51145DELETE FROM "supervisors"; 
     51146DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51147success! 
     51148DELETE FROM "streets"; 
     51149DELETE FROM sqlite_sequence WHERE name='streets' 
     51150success! 
     51151DELETE FROM "crew"; 
     51152DELETE FROM sqlite_sequence WHERE name='crew' 
     51153success! 
     51154DELETE FROM "supervisors"; 
     51155DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51156success! 
     51157DELETE FROM "streets"; 
     51158DELETE FROM sqlite_sequence WHERE name='streets' 
     51159success! 
     51160DELETE FROM "crew"; 
     51161DELETE FROM sqlite_sequence WHERE name='crew' 
     51162success! 
     51163DELETE FROM "supervisors"; 
     51164DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51165success! 
     51166DELETE FROM "streets"; 
     51167DELETE FROM sqlite_sequence WHERE name='streets' 
     51168success! 
     51169DELETE FROM "crew"; 
     51170DELETE FROM sqlite_sequence WHERE name='crew' 
     51171success! 
     51172DELETE FROM "supervisors"; 
     51173DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51174success! 
     51175DELETE FROM "streets"; 
     51176DELETE FROM sqlite_sequence WHERE name='streets' 
     51177success! 
     51178DELETE FROM "crew"; 
     51179DELETE FROM sqlite_sequence WHERE name='crew' 
     51180success! 
     51181DELETE FROM "supervisors"; 
     51182DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51183success! 
     51184DELETE FROM "streets"; 
     51185DELETE FROM sqlite_sequence WHERE name='streets' 
     51186success! 
     51187DELETE FROM "crew"; 
     51188DELETE FROM sqlite_sequence WHERE name='crew' 
     51189success! 
     51190DELETE FROM "supervisors"; 
     51191DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51192success! 
     51193DELETE FROM "streets"; 
     51194DELETE FROM sqlite_sequence WHERE name='streets' 
     51195success! 
     51196DELETE FROM "crew"; 
     51197DELETE FROM sqlite_sequence WHERE name='crew' 
     51198success! 
     51199DELETE FROM "supervisors"; 
     51200DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51201success! 
     51202DELETE FROM "streets"; 
     51203DELETE FROM sqlite_sequence WHERE name='streets' 
     51204success! 
     51205DELETE FROM "crew"; 
     51206DELETE FROM sqlite_sequence WHERE name='crew' 
     51207success! 
     51208DELETE FROM "supervisors"; 
     51209DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51210success! 
     51211DELETE FROM "streets"; 
     51212DELETE FROM sqlite_sequence WHERE name='streets' 
     51213success! 
     51214DELETE FROM "crew"; 
     51215DELETE FROM sqlite_sequence WHERE name='crew' 
     51216success! 
     51217DELETE FROM "supervisors"; 
     51218DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51219success! 
     51220DELETE FROM "streets"; 
     51221DELETE FROM sqlite_sequence WHERE name='streets' 
     51222success! 
     51223DELETE FROM "crew"; 
     51224DELETE FROM sqlite_sequence WHERE name='crew' 
     51225success! 
     51226DELETE FROM "supervisors"; 
     51227DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51228success! 
     51229DELETE FROM "streets"; 
     51230DELETE FROM sqlite_sequence WHERE name='streets' 
     51231success! 
     51232DELETE FROM "crew"; 
     51233DELETE FROM sqlite_sequence WHERE name='crew' 
     51234success! 
     51235DELETE FROM "supervisors"; 
     51236DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51237success! 
     51238DELETE FROM "streets"; 
     51239DELETE FROM sqlite_sequence WHERE name='streets' 
     51240success! 
     51241DELETE FROM "crew"; 
     51242DELETE FROM sqlite_sequence WHERE name='crew' 
     51243success! 
     51244DELETE FROM "supervisors"; 
     51245DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51246success! 
     51247DELETE FROM "streets"; 
     51248DELETE FROM sqlite_sequence WHERE name='streets' 
     51249success! 
     51250DELETE FROM "crew"; 
     51251DELETE FROM sqlite_sequence WHERE name='crew' 
     51252success! 
     51253DELETE FROM "supervisors"; 
     51254DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51255success! 
     51256DELETE FROM "streets"; 
     51257DELETE FROM sqlite_sequence WHERE name='streets' 
     51258success! 
     51259DELETE FROM "crew"; 
     51260DELETE FROM sqlite_sequence WHERE name='crew' 
     51261success! 
     51262DELETE FROM "supervisors"; 
     51263DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51264success! 
     51265DELETE FROM "streets"; 
     51266DELETE FROM sqlite_sequence WHERE name='streets' 
     51267success! 
     51268DELETE FROM "crew"; 
     51269DELETE FROM sqlite_sequence WHERE name='crew' 
     51270success! 
     51271DELETE FROM "supervisors"; 
     51272DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51273success! 
     51274DELETE FROM "streets"; 
     51275DELETE FROM sqlite_sequence WHERE name='streets' 
     51276success! 
     51277DELETE FROM "crew"; 
     51278DELETE FROM sqlite_sequence WHERE name='crew' 
     51279success! 
     51280DELETE FROM "supervisors"; 
     51281DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51282success! 
     51283DELETE FROM "streets"; 
     51284DELETE FROM sqlite_sequence WHERE name='streets' 
     51285success! 
     51286DELETE FROM "crew"; 
     51287DELETE FROM sqlite_sequence WHERE name='crew' 
     51288success! 
     51289DELETE FROM "supervisors"; 
     51290DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51291success! 
     51292DELETE FROM "streets"; 
     51293DELETE FROM sqlite_sequence WHERE name='streets' 
     51294success! 
     51295DELETE FROM "crew"; 
     51296DELETE FROM sqlite_sequence WHERE name='crew' 
     51297success! 
     51298DELETE FROM "supervisors"; 
     51299DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51300success! 
     51301DELETE FROM "streets"; 
     51302DELETE FROM sqlite_sequence WHERE name='streets' 
     51303success! 
     51304DELETE FROM "crew"; 
     51305DELETE FROM sqlite_sequence WHERE name='crew' 
     51306success! 
     51307DELETE FROM "supervisors"; 
     51308DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51309success! 
     51310DELETE FROM "streets"; 
     51311DELETE FROM sqlite_sequence WHERE name='streets' 
     51312success! 
     51313DELETE FROM "crew"; 
     51314DELETE FROM sqlite_sequence WHERE name='crew' 
     51315success! 
     51316DELETE FROM "supervisors"; 
     51317DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51318success! 
     51319DELETE FROM "streets"; 
     51320DELETE FROM sqlite_sequence WHERE name='streets' 
     51321success! 
     51322DELETE FROM "crew"; 
     51323DELETE FROM sqlite_sequence WHERE name='crew' 
     51324success! 
     51325DELETE FROM "supervisors"; 
     51326DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51327success! 
     51328DELETE FROM "streets"; 
     51329DELETE FROM sqlite_sequence WHERE name='streets' 
     51330success! 
     51331DELETE FROM "crew"; 
     51332DELETE FROM sqlite_sequence WHERE name='crew' 
     51333success! 
     51334DELETE FROM "supervisors"; 
     51335DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51336success! 
     51337DELETE FROM "streets"; 
     51338DELETE FROM sqlite_sequence WHERE name='streets' 
     51339success! 
     51340DELETE FROM "crew"; 
     51341DELETE FROM sqlite_sequence WHERE name='crew' 
     51342success! 
     51343DELETE FROM "supervisors"; 
     51344DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51345success! 
     51346DELETE FROM "streets"; 
     51347DELETE FROM sqlite_sequence WHERE name='streets' 
     51348success! 
     51349DELETE FROM "crew"; 
     51350DELETE FROM sqlite_sequence WHERE name='crew' 
     51351success! 
     51352DELETE FROM "supervisors"; 
     51353DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51354success! 
     51355DELETE FROM "streets"; 
     51356DELETE FROM sqlite_sequence WHERE name='streets' 
     51357success! 
     51358DELETE FROM "crew"; 
     51359DELETE FROM sqlite_sequence WHERE name='crew' 
     51360success! 
     51361DELETE FROM "supervisors"; 
     51362DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51363success! 
     51364DELETE FROM "streets"; 
     51365DELETE FROM sqlite_sequence WHERE name='streets' 
     51366success! 
     51367DELETE FROM "crew"; 
     51368DELETE FROM sqlite_sequence WHERE name='crew' 
     51369success! 
     51370DELETE FROM "supervisors"; 
     51371DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51372success! 
     51373DELETE FROM "streets"; 
     51374DELETE FROM sqlite_sequence WHERE name='streets' 
     51375success! 
     51376DELETE FROM "crew"; 
     51377DELETE FROM sqlite_sequence WHERE name='crew' 
     51378success! 
     51379DELETE FROM "supervisors"; 
     51380DELETE FROM sqlite_sequence WHERE name='supervisors' 
     51381success! 
     51382DELETE FROM "streets"; 
     51383DELETE FROM sqlite_sequence WHERE name='streets' 
     51384success! 
     51385DELETE FROM "crew"; 
     51386DELETE FROM sqlite_sequence WHERE name='crew' 
     51387success! 

  • branches/LCSv2/progress.log

    r627 r634  
    13131313[2020-08-30 15:35:46] EDIT LCSv2/controllers/default.py: 2 
    13141314[2020-08-30 15:41:37] EDIT LCSv2/views/default/help.html: 0 
     1315[2021-02-24 15:23:52] EDIT LCSv2/controllers/default.py: 3 
     1316[2021-02-24 15:30:10] EDIT LCSv2/controllers/default.py: 1 
     1317[2021-02-25 09:01:45] EDIT LCSv2/controllers/default.py: 1 
     1318[2021-02-25 09:20:35] EDIT LCSv2/controllers/default.py: 4 
     1319[2021-02-25 09:23:26] EDIT LCSv2/controllers/default.py: 1 
     1320[2021-02-25 09:27:46] EDIT LCSv2/controllers/default.py: 1 
     1321[2021-02-25 09:30:39] EDIT LCSv2/controllers/default.py: 4 
     1322[2021-02-25 09:32:16] EDIT LCSv2/controllers/default.py: 0 
     1323[2021-02-25 09:36:05] EDIT LCSv2/controllers/default.py: 3 
     1324[2021-02-25 09:47:06] EDIT LCSv2/controllers/default.py: 5 
     1325[2021-02-25 09:51:43] EDIT LCSv2/controllers/default.py: 0 
     1326[2021-02-25 09:56:07] EDIT LCSv2/controllers/default.py: 0 
Note: See TracChangeset for help on using the changeset viewer.