summaryrefslogtreecommitdiff
path: root/nop/models.py
diff options
context:
space:
mode:
authorJohannes Raggam <raggam-nl@adm.at>2011-05-10 15:50:39 (GMT)
committerJohannes Raggam <raggam-nl@adm.at>2011-05-10 15:50:39 (GMT)
commita351418394efd238daf89502fe3e8fd2c8bbe153 (patch)
treef397928ce3ff5f1f5912c65dde493763b937cf1f /nop/models.py
parente564b923dfcb7a65df89f39297ef0ca3dc5e09a0 (diff)
add nop initial app
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']
+