root / crm / robocrm / migrations / 0002_auto__add_machine__add_robouser__add_project__add_roboresource__add_ev.py @ 7646a522
History | View | Annotate | Download (13.6 KB)
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']
|