add package and new to menu

1 files changed, 24 insertions, 2 deletions

diff --git a/python/tbc_www/models.py b/python/tbc_www/models.py
index 04a3bb8..3d284c2 100644
--- a/python/tbc_www/models.py
+++ b/python/tbc_www/models.py
@@ -13,6 +13,16 @@ class Categories(models.Model):
 	def __str__(self):
 		return '%s %s %s %s' % (self.CategoryId, self.Category, self.Active, self.TimeStamp)
 
+class CategoriesMetadata(models.Model):
+	Id =  models.IntegerField(primary_key=True, db_column='id')
+	CategoryId = models.ForeignKey(Categories, db_column='category_id')
+	Checksum = models.CharField(max_length=100, db_column='checksum')
+	Descriptions = models.TextField(db_column='descriptions')
+	class Meta:
+		db_table = 'categories_metadata'
+	def __str__(self):
+		return '%s %s %s %s' % (self.Id, self.CategoryId, self.Checksum, self.Descriptions)
+
 class Repos(models.Model):
 	RepoId = models.IntegerField(primary_key=True, db_column='repo_id')
 	Repo = models.CharField(max_length=100, db_column='repo')
@@ -34,6 +44,16 @@ class Packages(models.Model):
 	def __str__(self):
 		return '%s %s %s %s %s %s %s' % (self.PackageId, self.CategoryId, self.Package, self.RepoId, self.Checksum, self.Active, self.TimeStamp)
 
+class PackagesMetadata(models.Model):
+	Id =  models.IntegerField(primary_key=True, db_column='id')
+	PackageId = models.ForeignKey(Packages, db_column='package_id')
+	Changlog = models.TextField(db_column='changlog')
+	Descriptions = models.TextField(db_column='descriptions')
+	class Meta:
+		db_table = 'packages_metadata'
+	def __str__(self):
+		return '%s %s %s %s' % (self.Id, self.PackageId, self.Changlog, self.Descriptions)
+
 class Ebuilds(models.Model):
 	EbuildId = models.IntegerField(primary_key=True, db_column='ebuild_id')
 	PackageId = models.ForeignKey(Packages, db_column='package_id')
@@ -60,6 +80,8 @@ class BuildLogs(models.Model):
 	BuildLogId = models.IntegerField(primary_key=True, db_column='build_log_id')
 	EbuildId = models.ForeignKey(Ebuilds, db_column='ebuild_id')
 	Fail =  models.BooleanField(db_column='fail')
+	RmQa =  models.BooleanField(db_column='rmqa')
+	Others =  models.BooleanField(db_column='others')
 	SummeryText = models.TextField(db_column='summery_text')
 	LogHash = models.CharField(max_length=100, db_column='log_hash')
 	BugId = models.IntegerField( db_column='bug_id')
@@ -67,14 +89,14 @@ class BuildLogs(models.Model):
 	class Meta:
 		db_table = 'build_logs'
 	def __str__(self):
-		return '%s %s %s %s %s %s %s' % (self.BuildLogId, self.EbuildId, self.Fail, self.SummeryText, self.LogHash, self.BugId, self.TimeStamp)
+		return '%s %s %s %s %s %s %s %s %s' % (self.BuildLogId, self.EbuildId, self.Fail, self.RmQa, self.Others, self.SummeryText, self.LogHash, self.BugId, self.TimeStamp)
 
 class BuildLogsRepomanQa(models.Model):
 	Id = models.IntegerField(primary_key=True, db_column='id')
 	BuildLogId = models.ForeignKey(BuildLogs, db_column='build_log_id')
 	SummeryText = models.TextField(db_column='summery_text')
 	class Meta:
-		db_table = 'build_logs_repoman'
+		db_table = 'build_logs_repoman_qa'
 	def __str__(self):
 		return '%s %s %s' % (self.Id, self.BuildLogId, self.SummeryText)