3 from south
.db
import db
4 from south
.v2
import SchemaMigration
5 from django
.db
import models
7 class Migration(SchemaMigration
):
9 def forwards(self
, orm
):
11 # Adding model 'Evaluateur'
12 db
.create_table('recrutement_evaluateur', (
13 ('id', self
.gf('django.db.models.fields.AutoField')(primary_key
=True)),
14 ('user', self
.gf('django.db.models.fields.related.ForeignKey')(to
=orm
['auth.User'], unique
=True)),
16 db
.send_create_signal('recrutement', ['Evaluateur'])
18 # Adding M2M table for field offres_emploi on 'Evaluateur'
19 db
.create_table('recrutement_evaluateur_offres_emploi', (
20 ('id', models
.AutoField(verbose_name
='ID', primary_key
=True, auto_created
=True)),
21 ('evaluateur', models
.ForeignKey(orm
['recrutement.evaluateur'], null
=False)),
22 ('offreemploi', models
.ForeignKey(orm
['emploi.offreemploi'], null
=False))
24 db
.create_unique('recrutement_evaluateur_offres_emploi', ['evaluateur_id', 'offreemploi_id'])
26 # Adding model 'CandidatEvaluation'
27 db
.create_table('recrutement_candidatevaluation', (
28 ('candidat', self
.gf('django.db.models.fields.related.ForeignKey')(related_name
='+', db_column
='candidat', to
=orm
['emploi.Candidat'])),
29 ('commentaire', self
.gf('django.db.models.fields.TextField')(default
='Aucun', null
=True, blank
=True)),
30 ('note', self
.gf('django.db.models.fields.IntegerField')(null
=True, blank
=True)),
31 ('date', self
.gf('django.db.models.fields.DateField')(auto_now_add
=True, blank
=True)),
32 ('evaluateur', self
.gf('django.db.models.fields.related.ForeignKey')(related_name
='+', db_column
='evaluateur', to
=orm
['recrutement.Evaluateur'])),
33 ('id', self
.gf('django.db.models.fields.AutoField')(primary_key
=True)),
35 db
.send_create_signal('recrutement', ['CandidatEvaluation'])
37 # Adding model 'CourrielTemplate'
38 db
.create_table('recrutement_courrieltemplate', (
39 ('plain_text', self
.gf('django.db.models.fields.TextField')()),
40 ('html', self
.gf('tinymce.models.HTMLField')()),
41 ('sujet', self
.gf('django.db.models.fields.CharField')(max_length
=100)),
42 ('id', self
.gf('django.db.models.fields.AutoField')(primary_key
=True)),
43 ('nom_modele', self
.gf('django.db.models.fields.CharField')(max_length
=100)),
45 db
.send_create_signal('recrutement', ['CourrielTemplate'])
47 # Adding model 'CandidatCourriel'
48 db
.create_table('recrutement_candidatcourriel', (
49 ('plain_text', self
.gf('django.db.models.fields.TextField')(blank
=True)),
50 ('html', self
.gf('tinymce.models.HTMLField')(null
=True, blank
=True)),
51 ('sujet', self
.gf('django.db.models.fields.CharField')(max_length
=255, blank
=True)),
52 ('id', self
.gf('django.db.models.fields.AutoField')(primary_key
=True)),
53 ('template', self
.gf('django.db.models.fields.related.ForeignKey')(related_name
='+', db_column
='template', to
=orm
['recrutement.CourrielTemplate'])),
55 db
.send_create_signal('recrutement', ['CandidatCourriel'])
57 # Adding M2M table for field candidats on 'CandidatCourriel'
58 db
.create_table('recrutement_candidatcourriel_candidats', (
59 ('id', models
.AutoField(verbose_name
='ID', primary_key
=True, auto_created
=True)),
60 ('candidatcourriel', models
.ForeignKey(orm
['recrutement.candidatcourriel'], null
=False)),
61 ('candidat', models
.ForeignKey(orm
['recrutement.candidat'], null
=False))
63 db
.create_unique('recrutement_candidatcourriel_candidats', ['candidatcourriel_id', 'candidat_id'])
66 def backwards(self
, orm
):
68 # Deleting model 'Evaluateur'
69 db
.delete_table('recrutement_evaluateur')
71 # Removing M2M table for field offres_emploi on 'Evaluateur'
72 db
.delete_table('recrutement_evaluateur_offres_emploi')
74 # Deleting model 'CandidatEvaluation'
75 db
.delete_table('recrutement_candidatevaluation')
77 # Deleting model 'CourrielTemplate'
78 db
.delete_table('recrutement_courrieltemplate')
80 # Deleting model 'CandidatCourriel'
81 db
.delete_table('recrutement_candidatcourriel')
83 # Removing M2M table for field candidats on 'CandidatCourriel'
84 db
.delete_table('recrutement_candidatcourriel_candidats')
89 'Meta': {'object_name': 'Group'},
90 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
91 'name': ('django.db.models.fields.CharField', [], {'max_length': '80', 'unique': 'True'}),
92 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
95 'Meta': {'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
96 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
97 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
98 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
99 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
102 'Meta': {'object_name': 'User'},
103 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
104 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
105 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
106 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
107 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
108 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
109 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
110 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
111 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
112 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
113 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
114 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
115 'username': ('django.db.models.fields.CharField', [], {'max_length': '30', 'unique': 'True'})
117 'contenttypes.contenttype': {
118 'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
119 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
120 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
121 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
122 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
124 'datamaster_modeles.bureau': {
125 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
126 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
127 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
128 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
129 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
130 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
131 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
132 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
133 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"})
135 'datamaster_modeles.implantation': {
136 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
137 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
138 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
139 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
140 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
141 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
142 'adresse_physique_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_physique'", 'to_field': "'code'", 'db_column': "'adresse_physique_pays'", 'to': "orm['datamaster_modeles.Pays']"}),
143 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
144 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
145 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
146 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
147 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
148 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
149 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
150 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
151 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
152 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
153 'adresse_postale_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_postale'", 'to_field': "'code'", 'db_column': "'adresse_postale_pays'", 'to': "orm['datamaster_modeles.Pays']"}),
154 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
155 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
156 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
157 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
158 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
159 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
160 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
161 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
162 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
163 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
164 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
165 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
166 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
167 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
168 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
169 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
170 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
171 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
172 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
173 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
174 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
175 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
176 'modif_date': ('django.db.models.fields.DateField', [], {}),
177 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
178 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
179 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
180 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"}),
181 'remarque': ('django.db.models.fields.TextField', [], {}),
182 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
183 'statut': ('django.db.models.fields.IntegerField', [], {}),
184 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
185 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
186 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
187 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
189 'datamaster_modeles.pays': {
190 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'"},
191 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
192 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}),
193 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
194 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True', 'blank': 'True'}),
195 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
196 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
197 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
198 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
199 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
200 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"})
202 'datamaster_modeles.region': {
203 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
204 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
205 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
206 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
207 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'db_column': "'implantation_bureau'", 'to': "orm['datamaster_modeles.Implantation']"}),
208 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
211 'Meta': {'object_name': 'Candidat'},
212 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
213 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
214 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
215 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
216 'domaine_professionnel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
217 'email': ('django.db.models.fields.EmailField', [], {'max_length': '255'}),
218 'employeur_actuel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
219 'etat_province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
220 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
221 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
222 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
223 'niveau_diplome': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
224 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
225 'nombre_dependant': ('django.db.models.fields.IntegerField', [], {}),
226 'offre_emploi': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'offre_emploi'", 'to': "orm['emploi.OffreEmploi']"}),
227 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'pays'", 'to': "orm['datamaster_modeles.Pays']"}),
228 'poste_actuel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
229 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
230 'situation_famille': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
231 'statut': ('django.db.models.fields.CharField', [], {'default': "'NOUV'", 'max_length': '4'}),
232 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
233 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255'})
235 'emploi.offreemploi': {
236 'Meta': {'object_name': 'OffreEmploi'},
237 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
238 'bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'db_column': "'bureau'"}),
239 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
240 'date_limite': ('django.db.models.fields.DateField', [], {}),
241 'debut_affectation': ('django.db.models.fields.DateField', [], {}),
242 'description': ('django.db.models.fields.TextField', [], {}),
243 'duree_affectation': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
244 'est_affiche': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
245 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
246 'lieu_affectation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
247 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
248 'poste': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
249 'poste_nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
250 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"}),
251 'renumeration': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
252 'resume': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
253 'statut': ('django.db.models.fields.CharField', [], {'default': "'NOUV'", 'max_length': '4'})
255 'recrutement.candidat': {
256 'Meta': {'object_name': 'Candidat', 'db_table': "'emploi_candidat'", '_ormbases': ['emploi.Candidat']}
258 'recrutement.candidatcourriel': {
259 'Meta': {'object_name': 'CandidatCourriel'},
260 'candidats': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['emploi.Candidat']", 'symmetrical': 'False'}),
261 'html': ('tinymce.models.HTMLField', [], {'null': 'True', 'blank': 'True'}),
262 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
263 'plain_text': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
264 'sujet': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
265 'template': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'template'", 'to': "orm['recrutement.CourrielTemplate']"})
267 'recrutement.candidatevaluation': {
268 'Meta': {'object_name': 'CandidatEvaluation'},
269 'candidat': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'candidat'", 'to': "orm['emploi.Candidat']"}),
270 'commentaire': ('django.db.models.fields.TextField', [], {'default': "'Aucun'", 'null': 'True', 'blank': 'True'}),
271 'date': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
272 'evaluateur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'evaluateur'", 'to': "orm['recrutement.Evaluateur']"}),
273 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
274 'note': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
276 'recrutement.courrieltemplate': {
277 'Meta': {'object_name': 'CourrielTemplate'},
278 'html': ('tinymce.models.HTMLField', [], {}),
279 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
280 'nom_modele': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
281 'plain_text': ('django.db.models.fields.TextField', [], {}),
282 'sujet': ('django.db.models.fields.CharField', [], {'max_length': '100'})
284 'recrutement.evaluateur': {
285 'Meta': {'object_name': 'Evaluateur'},
286 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
287 'offres_emploi': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'evaluateurs'", 'blank': 'True', 'to': "orm['emploi.OffreEmploi']"}),
288 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'unique': 'True'})
292 complete_apps
= ['recrutement']