def __init__(self):
idcol = AutoId('locationid', 'location_ident')
name = PkName('name')
name.constraint.default = 'main office'
addressid = PkNum('addressid')
addressid.set_fk('addresses', 'addressid')
isp = PkName('isp')
conn = PkName('connection')
ip = PkName('ip')
static = Bool('static')
static.constraint.pk = True
serviced = Bool('serviced')
serviced.constraint.pk = True
cols = [idcol, name, addressid, isp, conn, ip, static, serviced]
Table.__init__(self, 'locations', cols)
def __init__(self):
clientid = PkNum('clientid')
clientid.set_fk('clients')
ticketid = PkNum('ticketid')
ticketid.set_fk('tickets')
status = Name('status')
Table.__init__(self, 'client_tickets', [clientid, ticketid, status])
def __init__(self):
ticketid = PkNum('ticketid')
ticketid.set_fk('tickets')
status = Name('status')
Table.__init__(self, 'ticketstatus', [ticketid, status])
def __init__(self):
actionid = PkNum('actionid')
actionid.set_fk('ticketactions', 'actionid')
parent = PkNum('parent')
parent.set_fk('ticketactions')
Table.__init__(self, 'ticketactionparent', [actionid, parent])
def __init__(self):
idcol = PkNum('clientid')
idcol.set_auto_increment('client_ident')
client = Name('client')
client.constraint.unique = True
Table.__init__(self, 'clients', [idcol, client])
