auf/django/references/managedref/migrations/0001_initial.py

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