# history

authuser: admin
ip: 94.68.251.178
sql:
  UPDATE contracts SET type='1', subtype='', title='Remote Support #1',  number='A123456', description='400 Hours of remote admin support', comments='9:00-5:00',  contractorid='6', startdate='1304208000', currentenddate='1336867200',  renewals='#####admin', parentid='', totalcost='500'  WHERE id=1


authuser: admin
ip: 94.68.251.178
sql:
  UPDATE items set itemtypeid='1', function='software firewall', manufacturerid='2', label='', warrinfo='', model='Optiplex 790', sn='123-456', sn2='', sn3='', locationid='1:1', origin='', warrantymonths=36, purchasedate='', purchprice='', dnsname='zeus', userid='1', comments='', maintenanceinfo='', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='0', rackid='-', rackposition='-', rackposdepth='6', usize='-', status='0', macs='', ipv4='10.1.1.1', ipv6='', remadmip='', panelport='', switchid='-', switchport='', ports='0'   WHERE id=1


authuser: admin
ip: 94.68.227.213
sql:
  UPDATE software set invoiceid='', slicenseinfo='',  manufacturerid='5', stitle='Enterprise Linux', sversion='6',  sinfo='', purchdate='1304812800', licqty='1', lictype='0'   WHERE id=1


authuser: admin
ip: 94.68.227.213
sql:
  UPDATE items set itemtypeid='8', function='', manufacturerid='3', label='', warrinfo='', model='Imaginary Router', sn='', sn2='', sn3='', locationid='1', locareaid='', origin='', warrantymonths=48, purchasedate='1282867200', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='10', rackposdepth='6', usize='3', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0'   WHERE id=3


authuser: admin
ip: 94.68.227.213
sql:
  UPDATE users set  username='admin',  userdesc='administrator',  pass='admin',  usertype='1'  WHERE id=1


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE invoices SET vendorid='2', buyerid='7',  number='1234AB-C', description='', date='1327017600' WHERE id=1


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='3', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2'   WHERE id=4


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='Poweredge 2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='3', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2'   WHERE id=4


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='2', rackposdepth='6', usize='4', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0'   WHERE id=5


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='Poweredge 2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='30', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2'   WHERE id=4


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='20', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0'   WHERE id=5


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='28', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0'   WHERE id=5


authuser: admin
ip: 94.68.244.159
sql:
  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='27', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0'   WHERE id=5


authuser: admin
ip: 176.58.152.255
sql:
  UPDATE settings set companytitle='DemoCompany', dateformat='ymd', currency='&euro;', useldap='0', ldap_server='', ldap_dn='', ldap_getusers='', ldap_getusers_filter='', lang='en',  timezone='Europe/Athens' 


