|
1 |
# -*- coding: utf-8 -*-
|
|
2 |
import datetime
|
|
3 |
from south.db import db
|
|
4 |
from south.v2 import SchemaMigration
|
|
5 |
from django.db import models
|
|
6 |
|
|
7 |
|
|
8 |
class Migration(SchemaMigration):
|
|
9 |
|
|
10 |
def forwards(self, orm):
|
|
11 |
# Adding model 'Machine'
|
|
12 |
db.create_table('robocrm_machine', (
|
|
13 |
('type', self.gf('django.db.models.fields.CharField')(max_length=20)),
|
|
14 |
('id', self.gf('django.db.models.fields.CharField')(max_length=10, primary_key=True)),
|
|
15 |
('maint', self.gf('django.db.models.fields.BooleanField')(default=False)),
|
|
16 |
('dstart', self.gf('django.db.models.fields.DateTimeField')()),
|
|
17 |
('dend', self.gf('django.db.models.fields.DateTimeField')()),
|
|
18 |
))
|
|
19 |
db.send_create_signal('robocrm', ['Machine'])
|
|
20 |
|
|
21 |
# Adding model 'RoboUser'
|
|
22 |
db.create_table('robocrm_robouser', (
|
|
23 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
|
|
24 |
('user', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True)),
|
|
25 |
('rfid', self.gf('django.db.models.fields.DecimalField')(max_digits=10, decimal_places=0)),
|
|
26 |
('cell', self.gf('django.db.models.fields.DecimalField')(max_digits=10, decimal_places=0)),
|
|
27 |
('class_level', self.gf('django.db.models.fields.CharField')(default='FR', max_length=2)),
|
|
28 |
('grad_year', self.gf('django.db.models.fields.DecimalField')(max_digits=4, decimal_places=0)),
|
|
29 |
('major', self.gf('django.db.models.fields.CharField')(max_length=20)),
|
|
30 |
('sec_major_one', self.gf('django.db.models.fields.CharField')(max_length=20)),
|
|
31 |
('sec_major_two', self.gf('django.db.models.fields.CharField')(max_length=20)),
|
|
32 |
('club_rank', self.gf('django.db.models.fields.CharField')(default='JM', max_length=2)),
|
|
33 |
('dues_paid', self.gf('django.db.models.fields.DateField')()),
|
|
34 |
('tshirt_rec', self.gf('django.db.models.fields.BooleanField')(default=False)),
|
|
35 |
('bench_status', self.gf('django.db.models.fields.CharField')(default='GD', max_length=2)),
|
|
36 |
('shop_status', self.gf('django.db.models.fields.CharField')(default='GD', max_length=2)),
|
|
37 |
))
|
|
38 |
db.send_create_signal('robocrm', ['RoboUser'])
|
|
39 |
|
|
40 |
# Adding M2M table for field machines on 'RoboUser'
|
|
41 |
db.create_table('robocrm_robouser_machines', (
|
|
42 |
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
|
|
43 |
('robouser', models.ForeignKey(orm['robocrm.robouser'], null=False)),
|
|
44 |
('machine', models.ForeignKey(orm['robocrm.machine'], null=False))
|
|
45 |
))
|
|
46 |
db.create_unique('robocrm_robouser_machines', ['robouser_id', 'machine_id'])
|
|
47 |
|
|
48 |
# Adding model 'Project'
|
|
49 |
db.create_table('robocrm_project', (
|
|
50 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
|
|
51 |
('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
|
|
52 |
('primuser', self.gf('django.db.models.fields.related.ForeignKey')(related_name='pri+', to=orm['robocrm.RoboUser'])),
|
|
53 |
('charge', self.gf('django.db.models.fields.BooleanField')(default=False)),
|
|
54 |
))
|
|
55 |
db.send_create_signal('robocrm', ['Project'])
|
|
56 |
|
|
57 |
# Adding M2M table for field users on 'Project'
|
|
58 |
db.create_table('robocrm_project_users', (
|
|
59 |
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
|
|
60 |
('project', models.ForeignKey(orm['robocrm.project'], null=False)),
|
|
61 |
('robouser', models.ForeignKey(orm['robocrm.robouser'], null=False))
|
|
62 |
))
|
|
63 |
db.create_unique('robocrm_project_users', ['project_id', 'robouser_id'])
|
|
64 |
|
|
65 |
# Adding model 'RoboResource'
|
|
66 |
db.create_table('robocrm_roboresource', (
|
|
67 |
('type', self.gf('django.db.models.fields.CharField')(max_length=30)),
|
|
68 |
('id', self.gf('django.db.models.fields.CharField')(max_length=20, primary_key=True)),
|
|
69 |
('checked_out', self.gf('django.db.models.fields.BooleanField')(default=False)),
|
|
70 |
('user', self.gf('django.db.models.fields.related.ForeignKey')(related_name='u+', to=orm['robocrm.RoboUser'])),
|
|
71 |
('time_out', self.gf('django.db.models.fields.DateTimeField')()),
|
|
72 |
('time_due', self.gf('django.db.models.fields.DateTimeField')()),
|
|
73 |
('officer', self.gf('django.db.models.fields.related.ForeignKey')(related_name='o+', to=orm['robocrm.RoboUser'])),
|
|
74 |
))
|
|
75 |
db.send_create_signal('robocrm', ['RoboResource'])
|
|
76 |
|
|
77 |
# Adding model 'Event'
|
|
78 |
db.create_table('robocrm_event', (
|
|
79 |
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
|
|
80 |
('type', self.gf('django.db.models.fields.CharField')(max_length=30)),
|
|
81 |
('tstart', self.gf('django.db.models.fields.DateTimeField')()),
|
|
82 |
('tend', self.gf('django.db.models.fields.DateTimeField')()),
|
|
83 |
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['robocrm.RoboUser'])),
|
|
84 |
('succ', self.gf('django.db.models.fields.BooleanField')(default=False)),
|
|
85 |
('imgurl', self.gf('django.db.models.fields.URLField')(max_length=200)),
|
|
86 |
('machine', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['robocrm.Machine'])),
|
|
87 |
('project', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['robocrm.Project'])),
|
|
88 |
('matuse', self.gf('django.db.models.fields.TextField')()),
|
|
89 |
))
|
|
90 |
db.send_create_signal('robocrm', ['Event'])
|
|
91 |
|
|
92 |
|
|
93 |
def backwards(self, orm):
|
|
94 |
# Deleting model 'Machine'
|
|
95 |
db.delete_table('robocrm_machine')
|
|
96 |
|
|
97 |
# Deleting model 'RoboUser'
|
|
98 |
db.delete_table('robocrm_robouser')
|
|
99 |
|
|
100 |
# Removing M2M table for field machines on 'RoboUser'
|
|
101 |
db.delete_table('robocrm_robouser_machines')
|
|
102 |
|
|
103 |
# Deleting model 'Project'
|
|
104 |
db.delete_table('robocrm_project')
|
|
105 |
|
|
106 |
# Removing M2M table for field users on 'Project'
|
|
107 |
db.delete_table('robocrm_project_users')
|
|
108 |
|
|
109 |
# Deleting model 'RoboResource'
|
|
110 |
db.delete_table('robocrm_roboresource')
|
|
111 |
|
|
112 |
# Deleting model 'Event'
|
|
113 |
db.delete_table('robocrm_event')
|
|
114 |
|
|
115 |
|
|
116 |
models = {
|
|
117 |
'auth.group': {
|
|
118 |
'Meta': {'object_name': 'Group'},
|
|
119 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
120 |
'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
|
|
121 |
'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
|
|
122 |
},
|
|
123 |
'auth.permission': {
|
|
124 |
'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
|
|
125 |
'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
|
|
126 |
'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
|
|
127 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
128 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
|
|
129 |
},
|
|
130 |
'auth.user': {
|
|
131 |
'Meta': {'object_name': 'User'},
|
|
132 |
'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
|
|
133 |
'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
|
|
134 |
'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
|
|
135 |
'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
|
|
136 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
137 |
'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
|
|
138 |
'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
139 |
'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
140 |
'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
|
|
141 |
'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
|
|
142 |
'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
|
|
143 |
'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
|
|
144 |
'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
|
|
145 |
},
|
|
146 |
'contenttypes.contenttype': {
|
|
147 |
'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
|
|
148 |
'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
|
|
149 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
150 |
'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
|
|
151 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
|
|
152 |
},
|
|
153 |
'robocrm.event': {
|
|
154 |
'Meta': {'object_name': 'Event'},
|
|
155 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
156 |
'imgurl': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
|
|
157 |
'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['robocrm.Machine']"}),
|
|
158 |
'matuse': ('django.db.models.fields.TextField', [], {}),
|
|
159 |
'project': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['robocrm.Project']"}),
|
|
160 |
'succ': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
161 |
'tend': ('django.db.models.fields.DateTimeField', [], {}),
|
|
162 |
'tstart': ('django.db.models.fields.DateTimeField', [], {}),
|
|
163 |
'type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
|
|
164 |
'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['robocrm.RoboUser']"})
|
|
165 |
},
|
|
166 |
'robocrm.machine': {
|
|
167 |
'Meta': {'object_name': 'Machine'},
|
|
168 |
'dend': ('django.db.models.fields.DateTimeField', [], {}),
|
|
169 |
'dstart': ('django.db.models.fields.DateTimeField', [], {}),
|
|
170 |
'id': ('django.db.models.fields.CharField', [], {'max_length': '10', 'primary_key': 'True'}),
|
|
171 |
'maint': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
172 |
'type': ('django.db.models.fields.CharField', [], {'max_length': '20'})
|
|
173 |
},
|
|
174 |
'robocrm.project': {
|
|
175 |
'Meta': {'object_name': 'Project'},
|
|
176 |
'charge': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
177 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
178 |
'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
|
|
179 |
'primuser': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'pri+'", 'to': "orm['robocrm.RoboUser']"}),
|
|
180 |
'users': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'u+'", 'symmetrical': 'False', 'to': "orm['robocrm.RoboUser']"})
|
|
181 |
},
|
|
182 |
'robocrm.roboresource': {
|
|
183 |
'Meta': {'object_name': 'RoboResource'},
|
|
184 |
'checked_out': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
185 |
'id': ('django.db.models.fields.CharField', [], {'max_length': '20', 'primary_key': 'True'}),
|
|
186 |
'officer': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'o+'", 'to': "orm['robocrm.RoboUser']"}),
|
|
187 |
'time_due': ('django.db.models.fields.DateTimeField', [], {}),
|
|
188 |
'time_out': ('django.db.models.fields.DateTimeField', [], {}),
|
|
189 |
'type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
|
|
190 |
'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'u+'", 'to': "orm['robocrm.RoboUser']"})
|
|
191 |
},
|
|
192 |
'robocrm.robouser': {
|
|
193 |
'Meta': {'object_name': 'RoboUser'},
|
|
194 |
'bench_status': ('django.db.models.fields.CharField', [], {'default': "'GD'", 'max_length': '2'}),
|
|
195 |
'cell': ('django.db.models.fields.DecimalField', [], {'max_digits': '10', 'decimal_places': '0'}),
|
|
196 |
'class_level': ('django.db.models.fields.CharField', [], {'default': "'FR'", 'max_length': '2'}),
|
|
197 |
'club_rank': ('django.db.models.fields.CharField', [], {'default': "'JM'", 'max_length': '2'}),
|
|
198 |
'dues_paid': ('django.db.models.fields.DateField', [], {}),
|
|
199 |
'grad_year': ('django.db.models.fields.DecimalField', [], {'max_digits': '4', 'decimal_places': '0'}),
|
|
200 |
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
|
|
201 |
'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['robocrm.Machine']", 'symmetrical': 'False'}),
|
|
202 |
'major': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
|
|
203 |
'rfid': ('django.db.models.fields.DecimalField', [], {'max_digits': '10', 'decimal_places': '0'}),
|
|
204 |
'sec_major_one': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
|
|
205 |
'sec_major_two': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
|
|
206 |
'shop_status': ('django.db.models.fields.CharField', [], {'default': "'GD'", 'max_length': '2'}),
|
|
207 |
'tshirt_rec': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
|
|
208 |
'user': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['auth.User']", 'unique': 'True'})
|
|
209 |
}
|
|
210 |
}
|
|
211 |
|
|
212 |
complete_apps = ['robocrm']
|