~# lava-server manage inspectdb # This is an auto-generated Django model module. # You'll have to do the following manually to clean this up: # * Rearrange models' order # * Make sure each model has one field with primary_key=True # * Make sure each ForeignKey has `on_delete` set to the desired behavior. # * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table # Feel free to rename the models, but don't rename db_table values or field names. from django.db import models class AuthGroup(models.Model): name = models.CharField(unique=True, max_length=150) class Meta: managed = False db_table = 'auth_group' class AuthGroupPermissions(models.Model): group = models.ForeignKey(AuthGroup, models.DO_NOTHING) permission = models.ForeignKey('AuthPermission', models.DO_NOTHING) class Meta: managed = False db_table = 'auth_group_permissions' unique_together = (('group', 'permission'),) class AuthPermission(models.Model): name = models.CharField(max_length=255) content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING) codename = models.CharField(max_length=100) class Meta: managed = False db_table = 'auth_permission' unique_together = (('content_type', 'codename'),) class AuthUser(models.Model): password = models.CharField(max_length=128) last_login = models.DateTimeField(blank=True, null=True) is_superuser = models.BooleanField() username = models.CharField(unique=True, max_length=150) first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=150) email = models.CharField(max_length=254) is_staff = models.BooleanField() is_active = models.BooleanField() date_joined = models.DateTimeField() class Meta: managed = False db_table = 'auth_user' class AuthUserGroups(models.Model): user = models.ForeignKey(AuthUser, models.DO_NOTHING) group = models.ForeignKey(AuthGroup, models.DO_NOTHING) class Meta: managed = False db_table = 'auth_user_groups' unique_together = (('user', 'group'),) class AuthUserUserPermissions(models.Model): user = models.ForeignKey(AuthUser, models.DO_NOTHING) permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) class Meta: managed = False db_table = 'auth_user_user_permissions' unique_together = (('user', 'permission'),) class AuthtokenToken(models.Model): key = models.CharField(primary_key=True, max_length=40) created = models.DateTimeField() user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True) class Meta: managed = False db_table = 'authtoken_token' class DjangoAdminLog(models.Model): action_time = models.DateTimeField() object_id = models.TextField(blank=True, null=True) object_repr = models.CharField(max_length=200) action_flag = models.SmallIntegerField() change_message = models.TextField() content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True) user = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'django_admin_log' class DjangoContentType(models.Model): app_label = models.CharField(max_length=100) model = models.CharField(max_length=100) class Meta: managed = False db_table = 'django_content_type' unique_together = (('app_label', 'model'),) class DjangoMigrations(models.Model): app = models.CharField(max_length=255) name = models.CharField(max_length=255) applied = models.DateTimeField() class Meta: managed = False db_table = 'django_migrations' class DjangoSession(models.Model): session_key = models.CharField(primary_key=True, max_length=40) session_data = models.TextField() expire_date = models.DateTimeField() class Meta: managed = False db_table = 'django_session' class DjangoSite(models.Model): domain = models.CharField(unique=True, max_length=100) name = models.CharField(max_length=50) class Meta: managed = False db_table = 'django_site' class LavaResultsAppActiondata(models.Model): action_name = models.CharField(max_length=100) action_level = models.CharField(max_length=32) action_summary = models.CharField(max_length=100) action_description = models.CharField(max_length=200) yaml_line = models.IntegerField(blank=True, null=True) description_line = models.IntegerField(blank=True, null=True) log_section = models.CharField(max_length=50, blank=True, null=True) duration = models.DecimalField(max_digits=8, decimal_places=2, blank=True, null=True) timeout = models.IntegerField(blank=True, null=True) count = models.IntegerField(blank=True, null=True) max_retries = models.IntegerField(blank=True, null=True) meta_type = models.ForeignKey('LavaResultsAppMetatype', models.DO_NOTHING) testcase = models.ForeignKey('LavaResultsAppTestcase', models.DO_NOTHING, blank=True, null=True) testdata = models.ForeignKey('LavaResultsAppTestdata', models.DO_NOTHING, blank=True, null=True) class Meta: managed = False db_table = 'lava_results_app_actiondata' class LavaResultsAppChart(models.Model): name = models.CharField(unique=True, max_length=1024) description = models.TextField(blank=True, null=True) is_published = models.BooleanField() chart_group = models.ForeignKey('LavaResultsAppChartgroup', models.DO_NOTHING, blank=True, null=True) group = models.ForeignKey(AuthGroup, models.DO_NOTHING, blank=True, null=True) owner = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_chart' class LavaResultsAppChartgroup(models.Model): name = models.CharField(unique=True, max_length=1024) class Meta: managed = False db_table = 'lava_results_app_chartgroup' class LavaResultsAppChartquery(models.Model): chart_type = models.CharField(max_length=20) target_goal = models.DecimalField(max_digits=10, decimal_places=5, blank=True, null=True) chart_height = models.IntegerField() is_percentage = models.BooleanField() chart_visibility = models.CharField(max_length=20) xaxis_attribute = models.CharField(max_length=100, blank=True, null=True) representation = models.CharField(max_length=20) relative_index = models.IntegerField() attributes = models.CharField(max_length=200, blank=True, null=True) chart = models.ForeignKey(LavaResultsAppChart, models.DO_NOTHING) query = models.ForeignKey('LavaResultsAppQuery', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_chartquery' class LavaResultsAppChartqueryuser(models.Model): start_date = models.CharField(max_length=20) is_legend_visible = models.BooleanField() is_delta = models.BooleanField() chart_query = models.ForeignKey(LavaResultsAppChartquery, models.DO_NOTHING) user = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_chartqueryuser' unique_together = (('chart_query', 'user'),) class LavaResultsAppMetatype(models.Model): name = models.CharField(max_length=256) metatype = models.IntegerField() class Meta: managed = False db_table = 'lava_results_app_metatype' class LavaResultsAppNamedtestattribute(models.Model): name = models.TextField() value = models.TextField() object_id = models.IntegerField() content_type = models.ForeignKey(DjangoContentType, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_namedtestattribute' unique_together = (('object_id', 'name', 'content_type'),) class LavaResultsAppQuery(models.Model): name = models.CharField(max_length=1024) description = models.TextField(blank=True, null=True) is_published = models.BooleanField() group_by_attribute = models.CharField(max_length=20, blank=True, null=True) target_goal = models.DecimalField(max_digits=10, decimal_places=5, blank=True, null=True) content_type = models.ForeignKey(DjangoContentType, models.DO_NOTHING) group = models.ForeignKey(AuthGroup, models.DO_NOTHING, blank=True, null=True) owner = models.ForeignKey(AuthUser, models.DO_NOTHING) query_group = models.ForeignKey('LavaResultsAppQuerygroup', models.DO_NOTHING, blank=True, null=True) is_changed = models.BooleanField() is_live = models.BooleanField() is_updating = models.BooleanField() last_updated = models.DateTimeField(blank=True, null=True) is_archived = models.BooleanField() limit = models.IntegerField() class Meta: managed = False db_table = 'lava_results_app_query' unique_together = (('owner', 'name'),) class LavaResultsAppQuerycondition(models.Model): field = models.CharField(max_length=50) operator = models.CharField(max_length=20) value = models.CharField(max_length=40) query = models.ForeignKey(LavaResultsAppQuery, models.DO_NOTHING) table = models.ForeignKey(DjangoContentType, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_querycondition' class LavaResultsAppQuerygroup(models.Model): name = models.CharField(unique=True, max_length=1024) class Meta: managed = False db_table = 'lava_results_app_querygroup' class LavaResultsAppQueryomitresult(models.Model): object_id = models.IntegerField() content_type = models.ForeignKey(DjangoContentType, models.DO_NOTHING) query = models.ForeignKey(LavaResultsAppQuery, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_queryomitresult' unique_together = (('object_id', 'query', 'content_type'),) class LavaResultsAppTestcase(models.Model): name = models.TextField() units = models.TextField() result = models.SmallIntegerField() measurement = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) metadata = models.CharField(max_length=4096, blank=True, null=True) logged = models.DateTimeField() suite = models.ForeignKey('LavaResultsAppTestsuite', models.DO_NOTHING) test_set = models.ForeignKey('LavaResultsAppTestset', models.DO_NOTHING, blank=True, null=True) end_log_line = models.IntegerField(blank=True, null=True) start_log_line = models.IntegerField(blank=True, null=True) class Meta: managed = False db_table = 'lava_results_app_testcase' class LavaResultsAppTestdata(models.Model): testjob = models.ForeignKey('LavaSchedulerAppTestjob', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_testdata' class LavaResultsAppTestset(models.Model): name = models.CharField(max_length=200, blank=True, null=True) suite = models.ForeignKey('LavaResultsAppTestsuite', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_testset' class LavaResultsAppTestsuite(models.Model): name = models.CharField(max_length=200, blank=True, null=True) job = models.ForeignKey('LavaSchedulerAppTestjob', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_results_app_testsuite' class LavaSchedulerAppAlias(models.Model): name = models.CharField(primary_key=True, max_length=200) device_type = models.ForeignKey('LavaSchedulerAppDevicetype', models.DO_NOTHING, blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_alias' class LavaSchedulerAppArchitecture(models.Model): name = models.CharField(primary_key=True, max_length=100) class Meta: managed = False db_table = 'lava_scheduler_app_architecture' class LavaSchedulerAppBitwidth(models.Model): width = models.SmallIntegerField(primary_key=True) class Meta: managed = False db_table = 'lava_scheduler_app_bitwidth' class LavaSchedulerAppCore(models.Model): name = models.CharField(primary_key=True, max_length=100) class Meta: managed = False db_table = 'lava_scheduler_app_core' class LavaSchedulerAppDevice(models.Model): hostname = models.CharField(primary_key=True, max_length=200) device_version = models.CharField(max_length=200, blank=True, null=True) description = models.TextField(blank=True, null=True) device_type = models.ForeignKey('LavaSchedulerAppDevicetype', models.DO_NOTHING) last_health_report_job = models.ForeignKey('LavaSchedulerAppTestjob', models.DO_NOTHING, unique=True, blank=True, null=True) physical_group = models.ForeignKey(AuthGroup, models.DO_NOTHING, blank=True, null=True) physical_owner = models.ForeignKey(AuthUser, models.DO_NOTHING, blank=True, null=True) worker_host = models.ForeignKey('LavaSchedulerAppWorker', models.DO_NOTHING, blank=True, null=True) health = models.IntegerField() state = models.IntegerField() is_synced = models.BooleanField() class Meta: managed = False db_table = 'lava_scheduler_app_device' class LavaSchedulerAppDeviceTags(models.Model): device = models.ForeignKey(LavaSchedulerAppDevice, models.DO_NOTHING) tag = models.ForeignKey('LavaSchedulerAppTag', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_device_tags' unique_together = (('device', 'tag'),) class LavaSchedulerAppDevicetype(models.Model): name = models.CharField(primary_key=True, max_length=50) display = models.BooleanField() architecture = models.ForeignKey(LavaSchedulerAppArchitecture, models.DO_NOTHING, blank=True, null=True) bits = models.ForeignKey(LavaSchedulerAppBitwidth, models.DO_NOTHING, blank=True, null=True) core_count = models.SmallIntegerField(blank=True, null=True) cpu_model = models.CharField(max_length=100, blank=True, null=True) processor = models.ForeignKey('LavaSchedulerAppProcessorfamily', models.DO_NOTHING, blank=True, null=True) description = models.TextField(blank=True, null=True) health_denominator = models.IntegerField() health_frequency = models.IntegerField() disable_health_check = models.BooleanField() class Meta: managed = False db_table = 'lava_scheduler_app_devicetype' class LavaSchedulerAppDevicetypeCores(models.Model): devicetype = models.ForeignKey(LavaSchedulerAppDevicetype, models.DO_NOTHING) core = models.ForeignKey(LavaSchedulerAppCore, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_devicetype_cores' unique_together = (('devicetype', 'core'),) class LavaSchedulerAppExtendeduser(models.Model): irc_handle = models.CharField(max_length=40, blank=True, null=True) irc_server = models.CharField(max_length=40, blank=True, null=True) user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True) table_length = models.SmallIntegerField(blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_extendeduser' class LavaSchedulerAppGroupdevicepermission(models.Model): device = models.ForeignKey(LavaSchedulerAppDevice, models.DO_NOTHING) group = models.ForeignKey(AuthGroup, models.DO_NOTHING) permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_groupdevicepermission' unique_together = (('group', 'permission', 'device'),) class LavaSchedulerAppGroupdevicetypepermission(models.Model): devicetype = models.ForeignKey(LavaSchedulerAppDevicetype, models.DO_NOTHING) group = models.ForeignKey(AuthGroup, models.DO_NOTHING) permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_groupdevicetypepermission' unique_together = (('group', 'permission', 'devicetype'),) class LavaSchedulerAppGroupworkerpermission(models.Model): group = models.ForeignKey(AuthGroup, models.DO_NOTHING) permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) worker = models.ForeignKey('LavaSchedulerAppWorker', models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_groupworkerpermission' unique_together = (('group', 'permission', 'worker'),) class LavaSchedulerAppJobfailuretag(models.Model): name = models.CharField(unique=True, max_length=256) description = models.TextField(blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_jobfailuretag' class LavaSchedulerAppNotification(models.Model): type = models.IntegerField(blank=True, null=True) verbosity = models.IntegerField() template = models.TextField(blank=True, null=True) time_sent = models.DateTimeField() query_name = models.TextField(blank=True, null=True) conditions = models.TextField(blank=True, null=True) entity = models.ForeignKey(DjangoContentType, models.DO_NOTHING, blank=True, null=True) query_owner = models.ForeignKey(AuthUser, models.DO_NOTHING, blank=True, null=True) test_job = models.ForeignKey('LavaSchedulerAppTestjob', models.DO_NOTHING, unique=True) blacklist = models.TextField(blank=True, null=True) # This field type is a guess. class Meta: managed = False db_table = 'lava_scheduler_app_notification' class LavaSchedulerAppNotificationcallback(models.Model): url = models.TextField(blank=True, null=True) method = models.IntegerField(blank=True, null=True) token = models.TextField(blank=True, null=True) dataset = models.IntegerField(blank=True, null=True) content_type = models.IntegerField(blank=True, null=True) notification = models.ForeignKey(LavaSchedulerAppNotification, models.DO_NOTHING) header = models.CharField(max_length=64) class Meta: managed = False db_table = 'lava_scheduler_app_notificationcallback' class LavaSchedulerAppNotificationrecipient(models.Model): email = models.TextField(blank=True, null=True) irc_handle = models.TextField(blank=True, null=True) irc_server = models.TextField(blank=True, null=True) status = models.IntegerField() method = models.IntegerField() notification = models.ForeignKey(LavaSchedulerAppNotification, models.DO_NOTHING) user = models.ForeignKey(AuthUser, models.DO_NOTHING, blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_notificationrecipient' unique_together = (('user', 'notification', 'method'),) class LavaSchedulerAppProcessorfamily(models.Model): name = models.CharField(primary_key=True, max_length=100) class Meta: managed = False db_table = 'lava_scheduler_app_processorfamily' class LavaSchedulerAppRemoteartifactsauth(models.Model): name = models.CharField(max_length=100) token = models.CharField(max_length=100) user = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_remoteartifactsauth' unique_together = (('name', 'user'),) class LavaSchedulerAppTag(models.Model): name = models.CharField(unique=True, max_length=50) description = models.TextField(blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_tag' class LavaSchedulerAppTestjob(models.Model): is_public = models.BooleanField() sub_id = models.CharField(max_length=200) target_group = models.CharField(max_length=64, blank=True, null=True) description = models.CharField(max_length=200, blank=True, null=True) health_check = models.BooleanField() submit_time = models.DateTimeField() start_time = models.DateTimeField(blank=True, null=True) end_time = models.DateTimeField(blank=True, null=True) priority = models.IntegerField() definition = models.TextField() original_definition = models.TextField() multinode_definition = models.TextField() failure_comment = models.TextField(blank=True, null=True) actual_device = models.ForeignKey(LavaSchedulerAppDevice, models.DO_NOTHING, blank=True, null=True) requested_device_type = models.ForeignKey(LavaSchedulerAppDevicetype, models.DO_NOTHING, blank=True, null=True) submitter = models.ForeignKey(AuthUser, models.DO_NOTHING) pipeline_compatibility = models.IntegerField() health = models.IntegerField() state = models.IntegerField() token = models.CharField(max_length=32) queue_timeout = models.BigIntegerField(blank=True, null=True) class Meta: managed = False db_table = 'lava_scheduler_app_testjob' class LavaSchedulerAppTestjobFailureTags(models.Model): testjob = models.ForeignKey(LavaSchedulerAppTestjob, models.DO_NOTHING) jobfailuretag = models.ForeignKey(LavaSchedulerAppJobfailuretag, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_testjob_failure_tags' unique_together = (('testjob', 'jobfailuretag'),) class LavaSchedulerAppTestjobTags(models.Model): testjob = models.ForeignKey(LavaSchedulerAppTestjob, models.DO_NOTHING) tag = models.ForeignKey(LavaSchedulerAppTag, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_testjob_tags' unique_together = (('testjob', 'tag'),) class LavaSchedulerAppTestjobViewingGroups(models.Model): testjob = models.ForeignKey(LavaSchedulerAppTestjob, models.DO_NOTHING) group = models.ForeignKey(AuthGroup, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_testjob_viewing_groups' unique_together = (('testjob', 'group'),) class LavaSchedulerAppTestjobuser(models.Model): is_favorite = models.BooleanField() test_job = models.ForeignKey(LavaSchedulerAppTestjob, models.DO_NOTHING) user = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'lava_scheduler_app_testjobuser' unique_together = (('test_job', 'user'),) class LavaSchedulerAppWorker(models.Model): hostname = models.CharField(primary_key=True, max_length=200) description = models.TextField(blank=True, null=True) health = models.IntegerField() state = models.IntegerField() last_ping = models.DateTimeField() job_limit = models.IntegerField() version = models.CharField(max_length=50, blank=True, null=True) master_version_notified = models.CharField(max_length=50, blank=True, null=True) token = models.CharField(max_length=32) class Meta: managed = False db_table = 'lava_scheduler_app_worker' class LinaroDjangoXmlrpcAuthtoken(models.Model): secret = models.CharField(unique=True, max_length=128) description = models.TextField() created_on = models.DateTimeField() last_used_on = models.DateTimeField(blank=True, null=True) user = models.ForeignKey(AuthUser, models.DO_NOTHING) class Meta: managed = False db_table = 'linaro_django_xmlrpc_authtoken'