all tables linked with new website

1 files changed, 36 insertions, 0 deletions

diff --git a/spoken_auth/models.py b/spoken_auth/models.py
index b315b2d..431330d 100644
--- a/spoken_auth/models.py
+++ b/spoken_auth/models.py
@@ -12,3 +12,39 @@ class Users(AbstractBaseUser):
     USERNAME_FIELD = 'username'
     class Meta:
         db_table = 'auth_user'
+
+class FossCategory(models.Model):
+    foss = models.CharField(unique=True, max_length = 255)
+    description = models.TextField()
+    status = models.BooleanField(max_length = 2)
+    created = models.DateTimeField(auto_now_add = True)
+    updated = models.DateTimeField(auto_now = True)
+    class Meta:
+        db_table = 'creation_fosscategory'
+
+class Language(models.Model):
+    name = models.CharField(max_length = 255, unique = True)
+    created = models.DateTimeField(auto_now_add = True)
+    updated = models.DateTimeField(auto_now = True)
+    class Meta:
+        db_table = 'creation_language'
+
+class TutorialDetails(models.Model):
+    foss = models.ForeignKey(FossCategory)
+    tutorial = models.CharField(max_length = 255)
+    order = models.IntegerField()
+    created = models.DateTimeField(auto_now_add = True)
+    updated = models.DateTimeField(auto_now = True)
+
+    class Meta:
+        db_table = 'creation_tutorialdetail'
+
+class TutorialResources(models.Model):
+    id = models.IntegerField(primary_key=True)
+    tutorial_detail = models.ForeignKey(TutorialDetails)
+    language = models.ForeignKey(Language)
+    video = models.TextField()
+    status = models.PositiveSmallIntegerField(default = 0)
+
+    class Meta:
+        db_table = 'creation_tutorialresource'