f5b21ac33980abf269911fac4e066b05a36e9360
[auf_django_references.git] / auf / django / references / managedref / migrations / 0001_initial.py
1 # encoding: 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 class Migration(SchemaMigration):
8
9 def forwards(self, orm):
10
11 # Adding model 'Employe'
12 db.create_table(u'ref_employe', (
13 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
14 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
15 ('prenom', self.gf('django.db.models.fields.CharField')(max_length=255)),
16 ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='lieu_travail_theorique_de', db_column='implantation', to=orm['managedref.Implantation'])),
17 ('implantation_physique', self.gf('django.db.models.fields.related.ForeignKey')(related_name='lieu_travail_reel_de', db_column='implantation_physique', to=orm['managedref.Implantation'])),
18 ('courriel', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
19 ('genre', self.gf('django.db.models.fields.CharField')(max_length=3)),
20 ('fonction', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
21 ('telephone_poste', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
22 ('telephone_ip', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
23 ('responsable', self.gf('django.db.models.fields.related.ForeignKey')(related_name='responsable_de', blank=True, null=True, db_column='responsable', to=orm['managedref.Employe'])),
24 ('mandat_debut', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
25 ('mandat_fin', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
26 ('date_entree', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
27 ('service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Service'], db_column='service')),
28 ('poste_type_1', self.gf('django.db.models.fields.related.ForeignKey')(related_name='poste_type_1', blank=True, null=True, db_column='poste_type_1', to=orm['managedref.PosteType'])),
29 ('poste_type_2', self.gf('django.db.models.fields.related.ForeignKey')(related_name='poste_type_2', blank=True, null=True, db_column='poste_type_2', to=orm['managedref.PosteType'])),
30 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
31 ))
32 db.send_create_signal('managedref', ['Employe'])
33
34 # Adding model 'Authentification'
35 db.create_table(u'ref_authentification', (
36 ('id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], primary_key=True, db_column='id')),
37 ('courriel', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
38 ('motdepasse', self.gf('django.db.models.fields.CharField')(max_length=255)),
39 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
40 ))
41 db.send_create_signal('managedref', ['Authentification'])
42
43 # Adding model 'Service'
44 db.create_table(u'ref_service', (
45 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
46 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
47 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
48 ))
49 db.send_create_signal('managedref', ['Service'])
50
51 # Adding model 'PosteType'
52 db.create_table(u'ref_poste_type', (
53 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
54 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
55 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
56 ))
57 db.send_create_signal('managedref', ['PosteType'])
58
59 # Adding model 'GroupeArh'
60 db.create_table(u'ref_groupe_arh', (
61 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
62 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
63 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
64 ))
65 db.send_create_signal('managedref', ['GroupeArh'])
66
67 # Adding model 'GroupeDirRegion'
68 db.create_table(u'ref_groupe_dir_region', (
69 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
70 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
71 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
72 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
73 ))
74 db.send_create_signal('managedref', ['GroupeDirRegion'])
75
76 # Adding model 'GroupeAdmRegion'
77 db.create_table(u'ref_groupe_adm_region', (
78 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
79 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
80 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
81 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
82 ))
83 db.send_create_signal('managedref', ['GroupeAdmRegion'])
84
85 # Adding model 'GroupeRespImplantation'
86 db.create_table(u'ref_groupe_resp_implantation', (
87 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
88 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
89 ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='implantation')),
90 ('type', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
91 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
92 ))
93 db.send_create_signal('managedref', ['GroupeRespImplantation'])
94
95 # Adding model 'GroupeDirProgramme'
96 db.create_table(u'ref_groupe_dir_programme', (
97 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
98 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
99 ('service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Service'], db_column='service')),
100 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
101 ))
102 db.send_create_signal('managedref', ['GroupeDirProgramme'])
103
104 # Adding model 'GroupeDirDelegProgrammeReg'
105 db.create_table(u'ref_groupe_dir_deleg_programme_reg', (
106 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
107 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
108 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
109 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
110 ))
111 db.send_create_signal('managedref', ['GroupeDirDelegProgrammeReg'])
112
113 # Adding model 'GroupeComptable'
114 db.create_table(u'ref_groupe_comptable', (
115 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
116 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
117 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
118 ))
119 db.send_create_signal('managedref', ['GroupeComptable'])
120
121 # Adding model 'GroupeComptableRegional'
122 db.create_table(u'ref_groupe_comptable_regional', (
123 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
124 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
125 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
126 ))
127 db.send_create_signal('managedref', ['GroupeComptableRegional'])
128
129 # Adding model 'GroupeComptableLocal'
130 db.create_table(u'ref_groupe_comptable_local', (
131 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
132 ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
133 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
134 ))
135 db.send_create_signal('managedref', ['GroupeComptableLocal'])
136
137 # Adding model 'Discipline'
138 db.create_table(u'ref_discipline', (
139 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
140 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
141 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
142 ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
143 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
144 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
145 ))
146 db.send_create_signal('managedref', ['Discipline'])
147
148 # Adding model 'Programme'
149 db.create_table(u'ref_programme', (
150 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
151 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
152 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
153 ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
154 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
155 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
156 ))
157 db.send_create_signal('managedref', ['Programme'])
158
159 # Adding model 'Projet'
160 db.create_table(u'ref_projet', (
161 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
162 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
163 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
164 ('presentation', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
165 ('partenaires', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
166 ('service', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
167 ('objectif_specifique', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.ObjectifSpecifique'], null=True, db_column='objectif_specifique', blank=True)),
168 ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], null=True, db_column='implantation', blank=True)),
169 ('etablissement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Etablissement'], null=True, db_column='etablissement', blank=True)),
170 ('date_debut', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
171 ('date_fin', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
172 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
173 ))
174 db.send_create_signal('managedref', ['Projet'])
175
176 # Adding model 'ProjetComposante'
177 db.create_table(u'ref_projet_composante', (
178 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
179 ('code', self.gf('django.db.models.fields.CharField')(max_length=10)),
180 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
181 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
182 ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
183 ('projet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Projet'], db_column='projet')),
184 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
185 ))
186 db.send_create_signal('managedref', ['ProjetComposante'])
187
188 # Adding model 'UniteProjet'
189 db.create_table(u'ref_unite_projet', (
190 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
191 ('code', self.gf('django.db.models.fields.CharField')(max_length=10, unique=True)),
192 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
193 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
194 ))
195 db.send_create_signal('managedref', ['UniteProjet'])
196
197 # Adding model 'ObjectifSpecifique'
198 db.create_table(u'ref_objectif_specifique', (
199 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
200 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
201 ('objectif_strategique', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.ObjectifStrategique'], db_column='objectif_strategique')),
202 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
203 ))
204 db.send_create_signal('managedref', ['ObjectifSpecifique'])
205
206 # Adding model 'ObjectifStrategique'
207 db.create_table(u'ref_objectif_strategique', (
208 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
209 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
210 ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
211 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
212 ))
213 db.send_create_signal('managedref', ['ObjectifStrategique'])
214
215 # Adding model 'Thematique'
216 db.create_table(u'ref_thematique', (
217 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
218 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
219 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
220 ))
221 db.send_create_signal('managedref', ['Thematique'])
222
223 # Adding model 'ProjetUp'
224 db.create_table('managedref_projetup', (
225 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
226 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
227 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
228 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
229 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
230 ))
231 db.send_create_signal('managedref', ['ProjetUp'])
232
233 # Adding model 'Poste'
234 db.create_table(u'ref_poste', (
235 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
236 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
237 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
238 ('type', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
239 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
240 ))
241 db.send_create_signal('managedref', ['Poste'])
242
243 # Adding model 'ProjetPoste'
244 db.create_table(u'ref_projet_poste', (
245 ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
246 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
247 ('code_projet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Projet'], to_field='code', db_column='code_projet')),
248 ('code_poste', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Poste'], to_field='code', db_column='code_poste')),
249 ('code_bureau', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Bureau'], to_field='code', db_column='code_bureau')),
250 ('code_programme', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Programme'], to_field='code', db_column='code_programme')),
251 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
252 ))
253 db.send_create_signal('managedref', ['ProjetPoste'])
254
255 # Adding model 'Region'
256 db.create_table(u'ref_region', (
257 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
258 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
259 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255, db_index=True)),
260 ('implantation_bureau', self.gf('django.db.models.fields.related.ForeignKey')(related_name='gere_region', blank=True, null=True, db_column='implantation_bureau', to=orm['managedref.Implantation'])),
261 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
262 ))
263 db.send_create_signal('managedref', ['Region'])
264
265 # Adding model 'Bureau'
266 db.create_table(u'ref_bureau', (
267 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
268 ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
269 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
270 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
271 ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
272 ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='implantation')),
273 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
274 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
275 ))
276 db.send_create_signal('managedref', ['Bureau'])
277
278 # Adding model 'Implantation'
279 db.create_table(u'ref_implantation', (
280 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
281 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
282 ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
283 ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
284 ('type', self.gf('django.db.models.fields.CharField')(max_length=255)),
285 ('bureau_rattachement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='bureau_rattachement')),
286 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
287 ('fuseau_horaire', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
288 ('code_meteo', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
289 ('responsable_implantation', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
290 ('adresse_postale_precision_avant', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
291 ('adresse_postale_no', self.gf('django.db.models.fields.CharField')(max_length=30, null=True, blank=True)),
292 ('adresse_postale_rue', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
293 ('adresse_postale_bureau', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
294 ('adresse_postale_precision', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
295 ('adresse_postale_boite_postale', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
296 ('adresse_postale_ville', self.gf('django.db.models.fields.CharField')(max_length=255)),
297 ('adresse_postale_code_postal', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),
298 ('adresse_postale_code_postal_avant_ville', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
299 ('adresse_postale_region', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
300 ('adresse_postale_pays', self.gf('django.db.models.fields.related.ForeignKey')(related_name='impl_adresse_postale', to_field='code', db_column='adresse_postale_pays', to=orm['managedref.Pays'])),
301 ('adresse_physique_precision_avant', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
302 ('adresse_physique_no', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
303 ('adresse_physique_rue', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
304 ('adresse_physique_bureau', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
305 ('adresse_physique_precision', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
306 ('adresse_physique_ville', self.gf('django.db.models.fields.CharField')(max_length=255)),
307 ('adresse_physique_code_postal', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
308 ('adresse_physique_code_postal_avant_ville', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
309 ('adresse_physique_region', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
310 ('adresse_physique_pays', self.gf('django.db.models.fields.related.ForeignKey')(related_name='impl_adresse_physique', to_field='code', db_column='adresse_physique_pays', to=orm['managedref.Pays'])),
311 ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
312 ('telephone_interne', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
313 ('fax', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
314 ('fax_interne', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
315 ('courriel', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),
316 ('courriel_interne', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),
317 ('url', self.gf('django.db.models.fields.URLField')(max_length=255, blank=True)),
318 ('statut', self.gf('django.db.models.fields.IntegerField')()),
319 ('date_ouverture', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
320 ('date_inauguration', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
321 ('date_extension', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
322 ('date_fermeture', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
323 ('hebergement_etablissement', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
324 ('hebergement_convention', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
325 ('hebergement_convention_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
326 ('remarque', self.gf('django.db.models.fields.TextField')()),
327 ('commentaire', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
328 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
329 ('modif_date', self.gf('django.db.models.fields.DateField')()),
330 ))
331 db.send_create_signal('managedref', ['Implantation'])
332
333 # Adding model 'Pays'
334 db.create_table(u'ref_pays', (
335 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
336 ('code', self.gf('django.db.models.fields.CharField')(max_length=2, unique=True)),
337 ('code_iso3', self.gf('django.db.models.fields.CharField')(max_length=3, unique=True)),
338 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
339 ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
340 ('code_bureau', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Bureau'], to_field='code', null=True, db_column='code_bureau', blank=True)),
341 ('nord_sud', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
342 ('developpement', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
343 ('monnaie', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
344 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
345 ))
346 db.send_create_signal('managedref', ['Pays'])
347
348 # Adding model 'Etablissement'
349 db.create_table(u'ref_etablissement', (
350 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
351 ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
352 ('pays', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to_field='code', db_column='pays', to=orm['managedref.Pays'])),
353 ('region', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='region', to=orm['managedref.Region'])),
354 ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='implantation', to=orm['managedref.Implantation'])),
355 ('membre', self.gf('django.db.models.fields.BooleanField')(default=False)),
356 ('membre_adhesion_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
357 ('responsable_genre', self.gf('django.db.models.fields.CharField')(max_length=1, blank=True)),
358 ('responsable_nom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
359 ('responsable_prenom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
360 ('adresse', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
361 ('code_postal', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
362 ('cedex', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
363 ('ville', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
364 ('province', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
365 ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
366 ('fax', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
367 ('url', self.gf('django.db.models.fields.URLField')(max_length=255, null=True, blank=True)),
368 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
369 ))
370 db.send_create_signal('managedref', ['Etablissement'])
371
372
373 def backwards(self, orm):
374
375 # Deleting model 'Employe'
376 db.delete_table(u'ref_employe')
377
378 # Deleting model 'Authentification'
379 db.delete_table(u'ref_authentification')
380
381 # Deleting model 'Service'
382 db.delete_table(u'ref_service')
383
384 # Deleting model 'PosteType'
385 db.delete_table(u'ref_poste_type')
386
387 # Deleting model 'GroupeArh'
388 db.delete_table(u'ref_groupe_arh')
389
390 # Deleting model 'GroupeDirRegion'
391 db.delete_table(u'ref_groupe_dir_region')
392
393 # Deleting model 'GroupeAdmRegion'
394 db.delete_table(u'ref_groupe_adm_region')
395
396 # Deleting model 'GroupeRespImplantation'
397 db.delete_table(u'ref_groupe_resp_implantation')
398
399 # Deleting model 'GroupeDirProgramme'
400 db.delete_table(u'ref_groupe_dir_programme')
401
402 # Deleting model 'GroupeDirDelegProgrammeReg'
403 db.delete_table(u'ref_groupe_dir_deleg_programme_reg')
404
405 # Deleting model 'GroupeComptable'
406 db.delete_table(u'ref_groupe_comptable')
407
408 # Deleting model 'GroupeComptableRegional'
409 db.delete_table(u'ref_groupe_comptable_regional')
410
411 # Deleting model 'GroupeComptableLocal'
412 db.delete_table(u'ref_groupe_comptable_local')
413
414 # Deleting model 'Discipline'
415 db.delete_table(u'ref_discipline')
416
417 # Deleting model 'Programme'
418 db.delete_table(u'ref_programme')
419
420 # Deleting model 'Projet'
421 db.delete_table(u'ref_projet')
422
423 # Deleting model 'ProjetComposante'
424 db.delete_table(u'ref_projet_composante')
425
426 # Deleting model 'UniteProjet'
427 db.delete_table(u'ref_unite_projet')
428
429 # Deleting model 'ObjectifSpecifique'
430 db.delete_table(u'ref_objectif_specifique')
431
432 # Deleting model 'ObjectifStrategique'
433 db.delete_table(u'ref_objectif_strategique')
434
435 # Deleting model 'Thematique'
436 db.delete_table(u'ref_thematique')
437
438 # Deleting model 'ProjetUp'
439 db.delete_table('managedref_projetup')
440
441 # Deleting model 'Poste'
442 db.delete_table(u'ref_poste')
443
444 # Deleting model 'ProjetPoste'
445 db.delete_table(u'ref_projet_poste')
446
447 # Deleting model 'Region'
448 db.delete_table(u'ref_region')
449
450 # Deleting model 'Bureau'
451 db.delete_table(u'ref_bureau')
452
453 # Deleting model 'Implantation'
454 db.delete_table(u'ref_implantation')
455
456 # Deleting model 'Pays'
457 db.delete_table(u'ref_pays')
458
459 # Deleting model 'Etablissement'
460 db.delete_table(u'ref_etablissement')
461
462
463 models = {
464 'managedref.authentification': {
465 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
466 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
467 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
468 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
469 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
470 },
471 'managedref.bureau': {
472 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
473 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
474 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
475 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
476 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
477 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
478 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
479 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
480 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
481 },
482 'managedref.discipline': {
483 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
484 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
485 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
486 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
487 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
488 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
489 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
490 },
491 'managedref.employe': {
492 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
493 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
494 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
495 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
496 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
497 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
498 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
499 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
500 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
501 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
502 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
503 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
504 'poste_type_1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste_type_1'", 'blank': 'True', 'null': 'True', 'db_column': "'poste_type_1'", 'to': "orm['managedref.PosteType']"}),
505 'poste_type_2': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste_type_2'", 'blank': 'True', 'null': 'True', 'db_column': "'poste_type_2'", 'to': "orm['managedref.PosteType']"}),
506 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
507 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable_de'", 'blank': 'True', 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
508 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
509 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
510 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
511 },
512 'managedref.etablissement': {
513 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
514 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
515 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
516 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
517 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
518 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
519 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
520 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
521 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
522 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
523 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
524 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
525 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
526 'region': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
527 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
528 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
529 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
530 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
531 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
532 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
533 },
534 'managedref.groupeadmregion': {
535 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
536 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
537 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
538 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
539 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
540 },
541 'managedref.groupearh': {
542 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
543 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
544 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
545 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
546 },
547 'managedref.groupecomptable': {
548 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
549 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
550 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
551 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
552 },
553 'managedref.groupecomptablelocal': {
554 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
555 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
556 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
557 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
558 },
559 'managedref.groupecomptableregional': {
560 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
561 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
562 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
563 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
564 },
565 'managedref.groupedirdelegprogrammereg': {
566 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
567 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
568 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
569 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
570 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
571 },
572 'managedref.groupedirprogramme': {
573 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
574 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
575 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
576 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
577 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
578 },
579 'managedref.groupedirregion': {
580 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
581 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
582 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
583 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
584 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
585 },
586 'managedref.grouperespimplantation': {
587 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
588 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
589 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
590 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
591 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
592 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
593 },
594 'managedref.implantation': {
595 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
596 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
597 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
598 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
599 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
600 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
601 'adresse_physique_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_physique'", 'to_field': "'code'", 'db_column': "'adresse_physique_pays'", 'to': "orm['managedref.Pays']"}),
602 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
603 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
604 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
605 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
606 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
607 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
608 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
609 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
610 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
611 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
612 'adresse_postale_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_postale'", 'to_field': "'code'", 'db_column': "'adresse_postale_pays'", 'to': "orm['managedref.Pays']"}),
613 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
614 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
615 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
616 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
617 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
618 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
619 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
620 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
621 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
622 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
623 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
624 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
625 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
626 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
627 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
628 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
629 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
630 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
631 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
632 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
633 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
634 'modif_date': ('django.db.models.fields.DateField', [], {}),
635 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
636 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
637 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
638 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
639 'remarque': ('django.db.models.fields.TextField', [], {}),
640 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
641 'statut': ('django.db.models.fields.IntegerField', [], {}),
642 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
643 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
644 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
645 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
646 },
647 'managedref.objectifspecifique': {
648 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
649 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
650 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
651 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
652 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
653 },
654 'managedref.objectifstrategique': {
655 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
656 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
657 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
658 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
659 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
660 },
661 'managedref.pays': {
662 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
663 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
664 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}),
665 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
666 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True'}),
667 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
668 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
669 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
670 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
671 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
672 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
673 },
674 'managedref.poste': {
675 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
676 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
677 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
678 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
679 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
680 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
681 },
682 'managedref.postetype': {
683 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
684 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
685 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
686 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
687 },
688 'managedref.programme': {
689 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
690 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
691 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
692 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
693 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
694 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
695 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
696 },
697 'managedref.projet': {
698 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
699 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
700 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
701 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
702 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
703 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
704 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
705 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
706 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
707 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
708 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
709 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
710 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
711 },
712 'managedref.projetcomposante': {
713 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
714 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
715 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
716 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
717 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
718 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
719 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
720 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
721 },
722 'managedref.projetposte': {
723 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
724 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
725 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
726 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
727 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
728 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
729 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
730 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
731 },
732 'managedref.projetup': {
733 'Meta': {'object_name': 'ProjetUp'},
734 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
735 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
736 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
737 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
738 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
739 },
740 'managedref.region': {
741 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
742 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
743 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
744 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
745 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
746 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
747 },
748 'managedref.service': {
749 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
750 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
751 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
752 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
753 },
754 'managedref.thematique': {
755 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
756 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
757 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
758 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
759 },
760 'managedref.uniteprojet': {
761 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
762 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
763 'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'unique': 'True'}),
764 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
765 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
766 }
767 }
768
769 complete_apps = ['managedref']