def __init__(self):
clientid = PkNum('clientid')
clientid.set_fk('clients')
name = PkName('name')
value = Text('value')
cols = [clientid, name, value]
Table.__init__(self, 'clientdata', cols)
def __init__(self):
taskid = PkNum('taskid')
taskid.set_auto_increment('task_ident')
name = Name('name')
desc = Text('description')
cols = [taskid, name, desc]
Table.__init__(self, 'tasks', cols)
def __init__(self):
idcol = PkNum('fileid')
idcol.set_auto_increment('textfile_ident')
mcol = Name('md5size')
mcol.constraint.unique = True
dcol = Text('data')
columns = [idcol, mcol, dcol]
Table.__init__(self, 'textfiles', columns)
def __init__(self):
idcol = PkNum('fileid')
idcol.set_auto_increment('textfile_ident')
mcol = Name('md5size')
mcol.constraint.unique = True
dcol = Text('data')
columns = [idcol, mcol, dcol]
Table.__init__(self, 'textfiles', columns)
def __init__(self, idcol, idtable, name):
id_ = PkNum(idcol)
id_.set_fk(idtable)
tagname = PkName('tag')
tagname.set_fk('tagnames')
tagval = Text('value')
cols = [id_, tagname, tagval]
Table.__init__(self, name, cols)
def __init__(self):
troubleid = PkNum('troubleid')
troubleid.set_fk('troubles')
actionid = AutoId('actionid', 'troubleaction_ident', pk=True)
instatus = Name('instatus')
outstatus = Name('outstatus')
action = Name('action')
workdone = Text('workdone')
posted = Now('posted')
cols = [troubleid, actionid, instatus, outstatus, action, workdone, posted]
Table.__init__(self, 'troubleaction', cols)
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):
taskid = PkNum('taskid')
taskid.set_fk('tasks')
locationid = PkNum('locationid')
locationid.set_fk('locations', 'locationid')
Table.__init__(self, 'locationtask', [taskid, locationid])
def __init__(self):
taskid = PkNum('taskid')
taskid.set_fk('tasks')
clientid = PkNum('clientid')
clientid.set_fk('clients')
Table.__init__(self, 'clienttask', [taskid, clientid])
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])
