cb1ebb8cc07a3db348e599a30a2c24f72ffbee0c
[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 ('qualite', self.gf('django.db.models.fields.CharField')(max_length=3, blank=True, null=True)),
358 ('responsable_genre', self.gf('django.db.models.fields.CharField')(max_length=1, blank=True)),
359 ('responsable_nom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
360 ('responsable_prenom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
361 ('adresse', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
362 ('code_postal', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
363 ('cedex', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
364 ('ville', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
365 ('province', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
366 ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
367 ('fax', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
368 ('url', self.gf('django.db.models.fields.URLField')(max_length=255, null=True, blank=True)),
369 ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
370 ))
371 db.send_create_signal('managedref', ['Etablissement'])
372
373
374 def backwards(self, orm):
375
376 # Deleting model 'Employe'
377 db.delete_table(u'ref_employe')
378
379 # Deleting model 'Authentification'
380 db.delete_table(u'ref_authentification')
381
382 # Deleting model 'Service'
383 db.delete_table(u'ref_service')
384
385 # Deleting model 'PosteType'
386 db.delete_table(u'ref_poste_type')
387
388 # Deleting model 'GroupeArh'
389 db.delete_table(u'ref_groupe_arh')
390
391 # Deleting model 'GroupeDirRegion'
392 db.delete_table(u'ref_groupe_dir_region')
393
394 # Deleting model 'GroupeAdmRegion'
395 db.delete_table(u'ref_groupe_adm_region')
396
397 # Deleting model 'GroupeRespImplantation'
398 db.delete_table(u'ref_groupe_resp_implantation')
399
400 # Deleting model 'GroupeDirProgramme'
401 db.delete_table(u'ref_groupe_dir_programme')
402
403 # Deleting model 'GroupeDirDelegProgrammeReg'
404 db.delete_table(u'ref_groupe_dir_deleg_programme_reg')
405
406 # Deleting model 'GroupeComptable'
407 db.delete_table(u'ref_groupe_comptable')
408
409 # Deleting model 'GroupeComptableRegional'
410 db.delete_table(u'ref_groupe_comptable_regional')
411
412 # Deleting model 'GroupeComptableLocal'
413 db.delete_table(u'ref_groupe_comptable_local')
414
415 # Deleting model 'Discipline'
416 db.delete_table(u'ref_discipline')
417
418 # Deleting model 'Programme'
419 db.delete_table(u'ref_programme')
420
421 # Deleting model 'Projet'
422 db.delete_table(u'ref_projet')
423
424 # Deleting model 'ProjetComposante'
425 db.delete_table(u'ref_projet_composante')
426
427 # Deleting model 'UniteProjet'
428 db.delete_table(u'ref_unite_projet')
429
430 # Deleting model 'ObjectifSpecifique'
431 db.delete_table(u'ref_objectif_specifique')
432
433 # Deleting model 'ObjectifStrategique'
434 db.delete_table(u'ref_objectif_strategique')
435
436 # Deleting model 'Thematique'
437 db.delete_table(u'ref_thematique')
438
439 # Deleting model 'ProjetUp'
440 db.delete_table('managedref_projetup')
441
442 # Deleting model 'Poste'
443 db.delete_table(u'ref_poste')
444
445 # Deleting model 'ProjetPoste'
446 db.delete_table(u'ref_projet_poste')
447
448 # Deleting model 'Region'
449 db.delete_table(u'ref_region')
450
451 # Deleting model 'Bureau'
452 db.delete_table(u'ref_bureau')
453
454 # Deleting model 'Implantation'
455 db.delete_table(u'ref_implantation')
456
457 # Deleting model 'Pays'
458 db.delete_table(u'ref_pays')
459
460 # Deleting model 'Etablissement'
461 db.delete_table(u'ref_etablissement')
462
463
464 models = {
465 'managedref.authentification': {
466 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
467 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
468 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
469 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
470 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
471 },
472 'managedref.bureau': {
473 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
474 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
475 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
476 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
477 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
478 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
479 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
480 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
481 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
482 },
483 'managedref.discipline': {
484 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
485 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
486 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
487 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
488 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
489 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
490 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
491 },
492 'managedref.employe': {
493 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
494 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
495 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
496 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
497 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
498 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
499 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
500 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
501 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
502 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
503 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
504 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
505 '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']"}),
506 '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']"}),
507 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
508 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable_de'", 'blank': 'True', 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
509 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
510 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
511 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
512 },
513 'managedref.etablissement': {
514 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
515 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
516 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
517 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
518 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
519 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
520 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
521 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
522 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
523 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
524 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
525 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
526 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
527 'region': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
528 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
529 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
530 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
531 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
532 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
533 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
534 },
535 'managedref.groupeadmregion': {
536 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
537 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
538 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
539 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
540 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
541 },
542 'managedref.groupearh': {
543 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
544 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
545 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
546 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
547 },
548 'managedref.groupecomptable': {
549 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
550 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
551 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
552 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
553 },
554 'managedref.groupecomptablelocal': {
555 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
556 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
557 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
558 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
559 },
560 'managedref.groupecomptableregional': {
561 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
562 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
563 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
564 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
565 },
566 'managedref.groupedirdelegprogrammereg': {
567 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
568 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
569 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
570 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
571 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
572 },
573 'managedref.groupedirprogramme': {
574 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
575 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
576 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
577 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
578 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
579 },
580 'managedref.groupedirregion': {
581 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
582 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
583 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
584 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
585 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
586 },
587 'managedref.grouperespimplantation': {
588 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
589 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
590 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
591 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
592 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
593 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
594 },
595 'managedref.implantation': {
596 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
597 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
598 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
599 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
600 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
601 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
602 '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']"}),
603 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
604 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
605 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
606 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
607 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
608 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
609 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
610 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
611 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
612 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
613 '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']"}),
614 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
615 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
616 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
617 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
618 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
619 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
620 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
621 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
622 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
623 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
624 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
625 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
626 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
627 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
628 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
629 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
630 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
631 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
632 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
633 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
634 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
635 'modif_date': ('django.db.models.fields.DateField', [], {}),
636 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
637 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
638 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
639 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
640 'remarque': ('django.db.models.fields.TextField', [], {}),
641 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
642 'statut': ('django.db.models.fields.IntegerField', [], {}),
643 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
644 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
645 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
646 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
647 },
648 'managedref.objectifspecifique': {
649 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
650 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
651 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
652 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
653 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
654 },
655 'managedref.objectifstrategique': {
656 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
657 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
658 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
659 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
660 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
661 },
662 'managedref.pays': {
663 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
664 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
665 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}),
666 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
667 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True'}),
668 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
669 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
670 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
671 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
672 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
673 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
674 },
675 'managedref.poste': {
676 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
677 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
678 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
679 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
680 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
681 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
682 },
683 'managedref.postetype': {
684 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
685 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
686 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
687 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
688 },
689 'managedref.programme': {
690 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
691 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
692 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
693 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
694 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
695 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
696 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
697 },
698 'managedref.projet': {
699 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
700 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
701 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
702 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
703 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
704 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
705 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
706 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
707 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
708 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
709 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
710 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
711 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
712 },
713 'managedref.projetcomposante': {
714 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
715 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
716 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
717 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
718 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
719 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
720 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
721 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
722 },
723 'managedref.projetposte': {
724 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
725 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
726 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
727 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
728 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
729 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
730 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
731 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
732 },
733 'managedref.projetup': {
734 'Meta': {'object_name': 'ProjetUp'},
735 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
736 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
737 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
738 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
739 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
740 },
741 'managedref.region': {
742 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
743 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
744 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
745 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
746 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
747 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
748 },
749 'managedref.service': {
750 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
751 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
752 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
753 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
754 },
755 'managedref.thematique': {
756 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
757 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
758 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
759 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
760 },
761 'managedref.uniteprojet': {
762 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
763 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
764 'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'unique': 'True'}),
765 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
766 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
767 }
768 }
769
770 complete_apps = ['managedref']