/apps/survey/migrations/0002_auto__add_localprofile__add_localflusurvey.py

https://github.com/asdahlborg/epiwork-website
Python | 199 lines | 183 code | 11 blank | 5 comment | 0 complexity | 153221aad6e6b6f79d79d271a8a1a462 MD5 | raw file
    

  1. # encoding: utf-8
    2. 

  2. import datetime
    3. 

  3. from south.db import db
    4. 

  4. from south.v2 import SchemaMigration
    5. 

  5. from django.db import models
    6. 

  6. 

  7. class Migration(SchemaMigration):
    8. 

  8. 

  9.     def forwards(self, orm):
    10. 

  10.         
    11. 

  11.         # Adding model 'LocalProfile'
    12. 

  12.         db.create_table('survey_localprofile', (
    13. 

  13.             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
    14. 

  14.             ('surveyuser', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['survey.SurveyUser'], unique=True)),
    15. 

  15.             ('sq_num_season', self.gf('django.db.models.fields.SmallIntegerField')(null=True)),
    16. 

  16.             ('sq_num_total', self.gf('django.db.models.fields.SmallIntegerField')(null=True)),
    17. 

  17.             ('sq_date_first', self.gf('django.db.models.fields.DateField')(null=True)),
    18. 

  18.             ('sq_date_last', self.gf('django.db.models.fields.DateField')(null=True)),
    19. 

  19.             ('birth_date', self.gf('django.db.models.fields.DateField')()),
    20. 

  20.             ('zip_code', self.gf('django.db.models.fields.CharField')(max_length=5)),
    21. 

  21.             ('region', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
    22. 

  22.             ('gender', self.gf('django.db.models.fields.CharField')(max_length=1)),
    23. 

  23.             ('a_family', self.gf('django.db.models.fields.SmallIntegerField')()),
    24. 

  24.             ('a_smoker', self.gf('django.db.models.fields.CharField')(max_length=1)),
    25. 

  25.             ('a_vaccine_prev_seasonal', self.gf('django.db.models.fields.CharField')(max_length=1)),
    26. 

  26.             ('a_vaccine_prev_swine', self.gf('django.db.models.fields.CharField')(max_length=1)),
    27. 

  27.             ('a_vaccine_current', self.gf('django.db.models.fields.CharField')(max_length=1)),
    28. 

  28.         ))
    29. 

  29.         db.send_create_signal('survey', ['LocalProfile'])
    30. 

  30. 

  31.         # Adding model 'LocalFluSurvey'
    32. 

  32.         db.create_table('survey_localflusurvey', (
    33. 

  33.             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
    34. 

  34.             ('surveyuser', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['survey.SurveyUser'])),
    35. 

  35.             ('date', self.gf('django.db.models.fields.DateTimeField')()),
    36. 

  36.             ('status', self.gf('django.db.models.fields.CharField')(max_length=8)),
    37. 

  37.             ('age_user', self.gf('django.db.models.fields.SmallIntegerField')()),
    38. 

  38.             ('data', self.gf('django.db.models.fields.TextField')()),
    39. 

  39.             ('survey_id', self.gf('django.db.models.fields.CharField')(max_length=50)),
    40. 

  40.         ))
    41. 

  41.         db.send_create_signal('survey', ['LocalFluSurvey'])
    42. 

  42. 

  43. 

  44.     def backwards(self, orm):
    45. 

  45.         
    46. 

  46.         # Deleting model 'LocalProfile'
    47. 

  47.         db.delete_table('survey_localprofile')
    48. 

  48. 

  49.         # Deleting model 'LocalFluSurvey'
    50. 

  50.         db.delete_table('survey_localflusurvey')
    51. 

  51. 

  52. 

  53.     models = {
    54. 

  54.         'auth.group': {
    55. 

  55.             'Meta': {'object_name': 'Group'},
    56. 

  56.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    57. 

  57.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
    58. 

  58.             'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
    59. 

  59.         },
    60. 

  60.         'auth.permission': {
    61. 

  61.             'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
    62. 

  62.             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    63. 

  63.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
    64. 

  64.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    65. 

  65.             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
    66. 

  66.         },
    67. 

  67.         'auth.user': {
    68. 

  68.             'Meta': {'object_name': 'User'},
    69. 

  69.             'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    70. 

  70.             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
    71. 

  71.             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
    72. 

  72.             'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
    73. 

  73.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    74. 

  74.             'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    75. 

  75.             'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    76. 

  76.             'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    77. 

  77.             'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    78. 

  78.             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
    79. 

  79.             'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
    80. 

  80.             'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
    81. 

  81.             'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
    82. 

  82.         },
    83. 

  83.         'contenttypes.contenttype': {
    84. 

  84.             'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
    85. 

  85.             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    86. 

  86.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    87. 

  87.             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    88. 

  88.             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
    89. 

  89.         },
    90. 

  90.         'survey.extraresponse': {
    91. 

  91.             'Meta': {'object_name': 'ExtraResponse'},
    92. 

  92.             'data': ('django.db.models.fields.TextField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
    93. 

  93.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    94. 

  94.             'participation': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['survey.Participation']", 'null': 'True'}),
    95. 

  95.             'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']"})
    96. 

  96.         },
    97. 

  97.         'survey.lastresponse': {
    98. 

  98.             'Meta': {'object_name': 'LastResponse'},
    99. 

  99.             'data': ('django.db.models.fields.TextField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
    100. 

  100.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    101. 

  101.             'participation': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['survey.Participation']", 'null': 'True'}),
    102. 

  102.             'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']", 'unique': 'True'})
    103. 

  103.         },
    104. 

  104.         'survey.localflusurvey': {
    105. 

  105.             'Meta': {'object_name': 'LocalFluSurvey'},
    106. 

  106.             'age_user': ('django.db.models.fields.SmallIntegerField', [], {}),
    107. 

  107.             'data': ('django.db.models.fields.TextField', [], {}),
    108. 

  108.             'date': ('django.db.models.fields.DateTimeField', [], {}),
    109. 

  109.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    110. 

  110.             'status': ('django.db.models.fields.CharField', [], {'max_length': '8'}),
    111. 

  111.             'survey_id': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    112. 

  112.             'surveyuser': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']"})
    113. 

  113.         },
    114. 

  114.         'survey.localprofile': {
    115. 

  115.             'Meta': {'object_name': 'LocalProfile'},
    116. 

  116.             'a_family': ('django.db.models.fields.SmallIntegerField', [], {}),
    117. 

  117.             'a_smoker': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
    118. 

  118.             'a_vaccine_current': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
    119. 

  119.             'a_vaccine_prev_seasonal': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
    120. 

  120.             'a_vaccine_prev_swine': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
    121. 

  121.             'birth_date': ('django.db.models.fields.DateField', [], {}),
    122. 

  122.             'gender': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
    123. 

  123.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    124. 

  124.             'region': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
    125. 

  125.             'sq_date_first': ('django.db.models.fields.DateField', [], {'null': 'True'}),
    126. 

  126.             'sq_date_last': ('django.db.models.fields.DateField', [], {'null': 'True'}),
    127. 

  127.             'sq_num_season': ('django.db.models.fields.SmallIntegerField', [], {'null': 'True'}),
    128. 

  128.             'sq_num_total': ('django.db.models.fields.SmallIntegerField', [], {'null': 'True'}),
    129. 

  129.             'surveyuser': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']", 'unique': 'True'}),
    130. 

  130.             'zip_code': ('django.db.models.fields.CharField', [], {'max_length': '5'})
    131. 

  131.         },
    132. 

  132.         'survey.localresponse': {
    133. 

  133.             'Meta': {'object_name': 'LocalResponse'},
    134. 

  134.             'answers': ('django.db.models.fields.TextField', [], {}),
    135. 

  135.             'date': ('django.db.models.fields.DateTimeField', [], {}),
    136. 

  136.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    137. 

  137.             'survey_id': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    138. 

  138.             'user_id': ('django.db.models.fields.CharField', [], {'max_length': '36'})
    139. 

  139.         },
    140. 

  140.         'survey.participation': {
    141. 

  141.             'Meta': {'object_name': 'Participation'},
    142. 

  142.             'date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
    143. 

  143.             'epidb_id': ('django.db.models.fields.CharField', [], {'max_length': '36', 'null': 'True'}),
    144. 

  144.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    145. 

  145.             'previous_participation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.Participation']", 'null': 'True'}),
    146. 

  146.             'previous_participation_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
    147. 

  147.             'survey': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.Survey']"}),
    148. 

  148.             'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']"})
    149. 

  149.         },
    150. 

  150.         'survey.profile': {
    151. 

  151.             'Meta': {'object_name': 'Profile'},
    152. 

  152.             'created': ('django.db.models.fields.DateTimeField', [], {'default': 'None', 'null': 'True'}),
    153. 

  153.             'data': ('django.db.models.fields.TextField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
    154. 

  154.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    155. 

  155.             'survey': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['survey.Survey']", 'null': 'True'}),
    156. 

  156.             'updated': ('django.db.models.fields.DateTimeField', [], {'default': 'None', 'null': 'True'}),
    157. 

  157.             'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']", 'unique': 'True'}),
    158. 

  158.             'valid': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
    159. 

  159.         },
    160. 

  160.         'survey.profilesendqueue': {
    161. 

  161.             'Meta': {'object_name': 'ProfileSendQueue'},
    162. 

  162.             'answers': ('django.db.models.fields.TextField', [], {}),
    163. 

  163.             'date': ('django.db.models.fields.DateTimeField', [], {}),
    164. 

  164.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    165. 

  165.             'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.SurveyUser']"}),
    166. 

  166.             'survey_id': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    167. 

  167.             'user_id': ('django.db.models.fields.CharField', [], {'max_length': '36'})
    168. 

  168.         },
    169. 

  169.         'survey.responsesendqueue': {
    170. 

  170.             'Meta': {'object_name': 'ResponseSendQueue'},
    171. 

  171.             'answers': ('django.db.models.fields.TextField', [], {}),
    172. 

  172.             'date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
    173. 

  173.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    174. 

  174.             'participation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.Participation']"}),
    175. 

  175.             'survey_id': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    176. 

  176.             'user_id': ('django.db.models.fields.CharField', [], {'max_length': '36'})
    177. 

  177.         },
    178. 

  178.         'survey.survey': {
    179. 

  179.             'Meta': {'object_name': 'Survey'},
    180. 

  180.             'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
    181. 

  181.             'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
    182. 

  182.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    183. 

  183.             'specification': ('django.db.models.fields.TextField', [], {}),
    184. 

  184.             'survey_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '50'}),
    185. 

  185.             'title': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
    186. 

  186.             'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
    187. 

  187.         },
    188. 

  188.         'survey.surveyuser': {
    189. 

  189.             'Meta': {'object_name': 'SurveyUser'},
    190. 

  190.             'global_id': ('django.db.models.fields.CharField', [], {'default': "'83aac21f-dc32-44d9-894d-54f72337a890'", 'unique': 'True', 'max_length': '36'}),
    191. 

  191.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    192. 

  192.             'last_participation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['survey.Participation']", 'null': 'True'}),
    193. 

  193.             'last_participation_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
    194. 

  194.             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    195. 

  195.             'user': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.User']", 'symmetrical': 'False'})
    196. 

  196.         }
    197. 

  197.     }
    198. 

  198. 

  199.     complete_apps = ['survey']
    200.