Index: /branches/LCSv1/views/default/results.html.bak
===================================================================
--- /branches/LCSv1/views/default/results.html.bak	(revision 593)
+++ /branches/LCSv1/views/default/results.html.bak	(revision 595)
@@ -25,5 +25,5 @@
       lineout += "<td>" + fields[4] + " " + fields[5] +"</td>"; // req date-time
       lineout += "<td>" + fields[10] + " " + fields[11] +"</td>"; // status date-time
-      lineout += "</tr></table>"
+      lineout += "</tr>"
   }
   // Is there a 1022 status?
Index: /branches/LCSv1/views/default/results.html
===================================================================
--- /branches/LCSv1/views/default/results.html	(revision 593)
+++ /branches/LCSv1/views/default/results.html	(revision 595)
@@ -49,45 +49,4 @@
 <br>
 Number of records found: {{=count}}
-<br>
-{{if (count > 0):}}
-<!-- 
-<form action="statuslist.html" enctype="multipart/form-data" method="post">
-    <input type="submit" value="show status form" />
-    <button class="w2p-form-button" onclick="window.location=&#x27;/HLD/default/showhistory&#x27;;return false">show history</button><br>
-    <table border="1" cellpadding="5">
-        <tr>
-        <th></th>
-        <th>DTM<br>Area</th>
-        <th>Closure ID / <br>Log No.</th>
-        <th>Route &amp; Dir /<br>Type of Closure</th>
-        <th>Start Date<br>End Date<br>Est. Delay</th>
-        <th>Facility</th>
-        <th>Limits</th>
-        <th>Work<br>Description</th>
-        <th>TMP</th>
-        <th>Requestor/<br>Radio Call No.</th>
-        </tr>
-{{for hwy in highways:}}
-        <tr>
-        <td><INPUT type="checkbox" name="ckb1" value="{{=hwy.closureid}}"/></td>
-        <td align="center">{{=hwy.closureid[0]}}</td>
-        <td align="center">{{=hwy.closureid}}<BR><HR>{{=hwy.lognum}}</td>
-        <td align="center">{{=hwy.route}}&nbsp;{{=hwy.direction}}<BR><HR>{{=hwy.closuretype}}</td>
-        <td align="center">{{=hwy.startdate}}<BR><HR>{{=hwy.enddate}}<BR><HR>{{=hwy.estdelay}}</td>
-        {{=TD(hwy.facility)}}
-        <td align="center">{{=hwy.startlocation}}<BR><HR>{{=hwy.endlocation}}</td>
-        {{=TD(hwy.worktype)}}
-            <td align="center">{{=hwy.tmpcozeep}}<BR>{{=hwy.tmpdetour}}</td>
-        {{=TD(hwy.supervisor)}}
-{{pass}}
-        </tr>
-    </table>
-    <div style="display:none;">
-        <input name="_formkey" type="hidden" value="8138fabc-b5fc-4787-9f49-80e9ac931cf2" />
-        <input name="_formname" type="hidden" value="default" />
-    </div>
-</form>
--->
-{{pass}}
 <HR>
 <table border="1" cellpadding="5">
Index: /branches/LCSv1/controllers/default.py
===================================================================
--- /branches/LCSv1/controllers/default.py	(revision 593)
+++ /branches/LCSv1/controllers/default.py	(revision 595)
@@ -28,5 +28,5 @@
 # Display a search form
 def search():
-    form = FORM(LABEL('ClosureID/Log:',_for='closureid', _class="label"), INPUT(_name='closureid',_size='7'),INPUT(_name='lognum',_size='3'),XML('&nbsp;&nbsp;&nbsp;'), LABEL('Route: ',_for='route', _class="label"), SELECT(hwys,_name='route'), XML('&nbsp;&nbsp;&nbsp;'), LABEL('Direction: ',_for='direction', _class="label"), SELECT(hwyDirections,_name='direction'), BR(),BR(),LABEL('Dates:',_for='startdate', _class="label") ,INPUT(_name='startdate',_class='date'), XML('&nbsp;&nbsp;&nbsp;'), LABEL('  to:',_for='enddate', _class="label"), INPUT(_name='enddate'),'(MMDDYYYY)',BR(),BR(),INPUT(_type='submit', _class="submit-button btn btn-primary"))
+    form = FORM(LABEL('ClosureID/Log:',_for='closureid', _class="label"), INPUT(_name='closureid',_size='7'),INPUT(_name='lognum',_size='3'),XML('&nbsp;&nbsp;&nbsp;'), LABEL('Route: ',_for='route', _class="label"), SELECT(hwys,_name='route'), XML('&nbsp;&nbsp;&nbsp;'), LABEL('Direction: ',_for='direction', _class="label"), SELECT(hwyDirections,_name='direction'), BR(),BR(),LABEL('Dates:',_for='startdate', _class="label") ,INPUT(_name='startdate',_class='date'), XML('&nbsp;&nbsp;&nbsp;'), LABEL('  to:',_for='enddate', _class="label"), INPUT(_name='enddate',_class='date'),BR(),BR(),INPUT(_type='submit', _class="submit-button btn btn-primary"))
     if form.process().accepted:
         # Put the form fields into the session variables
@@ -61,7 +61,7 @@
         # Each row contains a form with two buttons and columns with fields from database
         multiform.append(TR(TD(
-                    XML("<button onclick=showPopup(\'"),statusfields,XML("\')>View History</button>"),BR(),
+                    XML("<button class='submit-button' onclick=showPopup(\'"),statusfields,XML("\')>View History</button>"),BR(),
                     FORM(
-                          INPUT(_type='submit',_name='btn2',_value='Show Status Form'),
+                          INPUT(_type='submit',_name='btn2',_value='Show Status Form',_class="submit-button" ),
                           INPUT(_type='hidden',_name='row',_value=row.closureid))),
                           TD(row.closureid[0]),TD(row.closureid,HR(),row.lognum), TD(row.route,' ',row.direction,HR(),row.closuretype), TD(row.startdate,' ',formatTime(row.starttime),HR(),row.enddate,' ',formatTime(row.endtime),HR(),row.estdelay), TD(row.facility),TD(row.startlocation,HR(),row.endlocation), TD(row.worktype), TD(row.tmpcozeep,BR(),row.tmpdetour), TD(row.supervisor,HR(),db(db.supervisors.name == row.supervisor).select().first().radiocallnum) )) 
@@ -89,5 +89,5 @@
                 TABLE(THEAD(TR(TH('Closure ID/',BR(),'Log No.'),TH('Route & Dir',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Requestor/',BR(),'Radio Call No.'),TH('Status'))),
                     [TR(TD(row.closureid,HR(),row.lognum),TD(row.route,' ',row.direction,HR(),row.closuretype),TD(row.startdate,HR(),row.enddate,HR(),row.estdelay),TD(row.supervisor,BR(),db(db.supervisors.name == row.supervisor).select().first().radiocallnum),TD(LABEL('1097'), INPUT(_type='checkbox', _name='statustype', _value='1097'+row.closureid),LABEL('1098'), INPUT(_type='checkbox', _name='statustype', _value='1098'+row.closureid),LABEL('1022'), INPUT(_type='checkbox', _name='statustype', _value='1022'+row.closureid),BR(), LABEL('Statuser:'),INPUT(_name='statuser',_size='9'))) for row in closedItems],
-                    _border='1', _cellpadding='5'),INPUT(_type='submit',_value="submit status form"),)
+                    _border='1', _cellpadding='5'),INPUT(_type='submit',_value="submit status form",_class="submit-button"),)
         
     else:
@@ -156,5 +156,5 @@
            'Date Range:',BR(),
            LABEL('From',_for='startdate'),INPUT(_name='startdate',_size='8',_class='date'), XML('&nbsp;&nbsp;&nbsp;'), 
-           LABEL('to:',_for='enddate'), INPUT(_name='enddate',_size='8',_class='date'),'(MMDDYYYY)',XML('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'), 
+           LABEL('to:',_for='enddate'), INPUT(_name='enddate',_size='8',_class='date'),XML('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'), 
            LABEL('Times',_for='starttime'),SELECT(hournames,_name='starttime'), 
            LABEL(':',_for='starttimemin'),SELECT('','00','15','30','45','59',_name='starttimemin'), XML('&nbsp;&nbsp;'), 
@@ -172,5 +172,5 @@
                      TD(SELECT(supervisors,_name='fieldrep')))),
     TABLE(TR(TD('Meeting Place/CHP Contact'),TD('Reason for Closure'),TD('Additional Remarks / Detour ')), 
-                  TR(TD(INPUT(_name='meeting')),TD(INPUT(_name='reason')),TD(INPUT(_name='remarks',_size='40'))) ), BR(), 
+                  TR(TD(INPUT(_name='meeting')),TD(INPUT(_name='reason',_size='40')),TD(INPUT(_name='remarks',_size='40'))) ), BR(), 
             INPUT(_type='submit',_value='Submit Closure'),XML('\n'),SELECT(streetlookup,_name='stlookup', _id='stlookup', _class='hideme')) 
     if form.process().accepted:
Index: /branches/LCSv1/progress.log
===================================================================
--- /branches/LCSv1/progress.log	(revision 594)
+++ /branches/LCSv1/progress.log	(revision 595)
@@ -1047,2 +1047,3 @@
 [2020-03-19 16:05:40] EDIT Multiform/controllers/default.py: -5
 [2020-03-19 16:17:33] EDIT LCSv1/views/default/statusAck.html: 0
+[2020-03-20 15:20:38] EDIT LCSv1/views/default/results.html: -41
Index: /branches/LCSv1/databases/sql.log
===================================================================
--- /branches/LCSv1/databases/sql.log	(revision 594)
+++ /branches/LCSv1/databases/sql.log	(revision 595)
@@ -16675,2 +16675,416 @@
 DELETE FROM sqlite_sequence WHERE name='streets'
 success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!
+DELETE FROM "supervisors";
+DELETE FROM sqlite_sequence WHERE name='supervisors'
+success!
+DELETE FROM "streets";
+DELETE FROM sqlite_sequence WHERE name='streets'
+success!