summaryrefslogtreecommitdiff
path: root/nop/models.py
diff options
context:
space:
mode:
Diffstat (limited to 'nop/models.py')
-rw-r--r--nop/models.py36
1 files changed, 36 insertions, 0 deletions
diff --git a/nop/models.py b/nop/models.py
new file mode 100644
index 0000000..8bb87af
--- /dev/null
+++ b/nop/models.py
@@ -0,0 +1,36 @@
+from django.db import models
+
+class Master(models.Model):
+ timestamp = models.BigIntegerField(primary_key=True)
+ cart = models.IntegerField()
+ len = models.IntegerField(null=True, blank=True)
+ showtitle = models.CharField(max_length=765, blank=True)
+ title = models.CharField(max_length=765, blank=True)
+ artist = models.CharField(max_length=765, blank=True)
+ album = models.CharField(max_length=765, blank=True)
+ ismusic = models.IntegerField(null=True, blank=True)
+ class Meta:
+ db_table = u'master'
+ ordering = ['-timestamp']
+
+
+class Standby(models.Model):
+ timestamp = models.BigIntegerField(primary_key=True)
+ cart = models.IntegerField()
+ len = models.IntegerField(null=True, blank=True)
+ showtitle = models.CharField(max_length=765, blank=True)
+ title = models.CharField(max_length=765, blank=True)
+ artist = models.CharField(max_length=765, blank=True)
+ album = models.CharField(max_length=765, blank=True)
+ ismusic = models.IntegerField(null=True, blank=True)
+ class Meta:
+ db_table = u'standby'
+ ordering = ['-timestamp']
+
+class State(models.Model):
+ timestamp = models.BigIntegerField(primary_key=True)
+ state = models.CharField(max_length=96, blank=True)
+ class Meta:
+ db_table = u'state'
+ ordering = ['-timestamp']
+