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']