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 | 7646a522 | Julian Binder | # -*- 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'] |