def initialise(application):
sysinfo = application.predefine.sysinfo
sysinfo("public", True, "Allow unregistered users to use the application")
sysinfo("name", 'Reformed Application', "Name of the application")
database = application.database
entity('ticket', database,
Text("title", mandatory = True),
Text("summary", length = 4000),
LookupId("severity", "code", filter_field = "code_type"),
LookupId("priority", "code", filter_field = "code_type"),
DateTime("complete_by"),
Boolean("accepted"),
Created("created_date"),
CreatedBy("created_by"),
title_field = "title",
summary_fields = "summary",
valid_info_tables = "comment role",
)
info_table("comment", database, ## notes for each user
Created("created_date"),
CreatedBy("created_by"),
Text("note", length = 4000),
)
relation("involvement", database,
LookupId("role", "code", filter_field = "code_type"),
Created("created_date"),
CreatedBy("created_by"),
primary_entities = "ticket",
secondary_entities = "user usergroup",
table_type = "system",
)
info_table("role", database, ## notes for each user
Text("name", mandatory = True),
Text("desctiption", length = 2000),
table_type = "system",
)
database.persist()