--- /dev/null
+from django.contrib import admin
+from auf.django.references import models as ref
+
+admin.site.register(ref.Region)
+admin.site.register(ref.Bureau)
+admin.site.register(ref.Implantation)
+admin.site.register(ref.Pays)
+admin.site.register(ref.Etablissement)
+++ /dev/null
-from django.contrib import admin
-from auf.django.references.managedref import models as ref
-
-admin.site.register(ref.Region)
-admin.site.register(ref.Bureau)
-admin.site.register(ref.Implantation)
-admin.site.register(ref.Pays)
-admin.site.register(ref.Etablissement)
+++ /dev/null
-# encoding: utf-8
-import datetime
-from south.db import db
-from south.v2 import SchemaMigration
-from django.db import models
-
-class Migration(SchemaMigration):
-
- def forwards(self, orm):
-
- # Adding model 'Employe'
- db.create_table(u'ref_employe', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('prenom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='lieu_travail_theorique_de', db_column='implantation', to=orm['managedref.Implantation'])),
- ('implantation_physique', self.gf('django.db.models.fields.related.ForeignKey')(related_name='lieu_travail_reel_de', db_column='implantation_physique', to=orm['managedref.Implantation'])),
- ('courriel', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('genre', self.gf('django.db.models.fields.CharField')(max_length=3)),
- ('fonction', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('telephone_poste', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('telephone_ip', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('responsable', self.gf('django.db.models.fields.related.ForeignKey')(related_name='responsable_de', blank=True, null=True, db_column='responsable', to=orm['managedref.Employe'])),
- ('mandat_debut', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('mandat_fin', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('date_entree', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Service'], db_column='service')),
- ('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'])),
- ('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'])),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Employe'])
-
- # Adding model 'Authentification'
- db.create_table(u'ref_authentification', (
- ('id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], primary_key=True, db_column='id')),
- ('courriel', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('motdepasse', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Authentification'])
-
- # Adding model 'Service'
- db.create_table(u'ref_service', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Service'])
-
- # Adding model 'PosteType'
- db.create_table(u'ref_poste_type', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['PosteType'])
-
- # Adding model 'GroupeArh'
- db.create_table(u'ref_groupe_arh', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeArh'])
-
- # Adding model 'GroupeDirRegion'
- db.create_table(u'ref_groupe_dir_region', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeDirRegion'])
-
- # Adding model 'GroupeAdmRegion'
- db.create_table(u'ref_groupe_adm_region', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeAdmRegion'])
-
- # Adding model 'GroupeRespImplantation'
- db.create_table(u'ref_groupe_resp_implantation', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='implantation')),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeRespImplantation'])
-
- # Adding model 'GroupeDirProgramme'
- db.create_table(u'ref_groupe_dir_programme', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Service'], db_column='service')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeDirProgramme'])
-
- # Adding model 'GroupeDirDelegProgrammeReg'
- db.create_table(u'ref_groupe_dir_deleg_programme_reg', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeDirDelegProgrammeReg'])
-
- # Adding model 'GroupeComptable'
- db.create_table(u'ref_groupe_comptable', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeComptable'])
-
- # Adding model 'GroupeComptableRegional'
- db.create_table(u'ref_groupe_comptable_regional', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeComptableRegional'])
-
- # Adding model 'GroupeComptableLocal'
- db.create_table(u'ref_groupe_comptable_local', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Employe'], db_column='employe')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['GroupeComptableLocal'])
-
- # Adding model 'Discipline'
- db.create_table(u'ref_discipline', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Discipline'])
-
- # Adding model 'Programme'
- db.create_table(u'ref_programme', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Programme'])
-
- # Adding model 'Projet'
- db.create_table(u'ref_projet', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('presentation', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('partenaires', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('service', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('objectif_specifique', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.ObjectifSpecifique'], null=True, db_column='objectif_specifique', blank=True)),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], null=True, db_column='implantation', blank=True)),
- ('etablissement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Etablissement'], null=True, db_column='etablissement', blank=True)),
- ('date_debut', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('date_fin', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Projet'])
-
- # Adding model 'ProjetComposante'
- db.create_table(u'ref_projet_composante', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('projet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Projet'], db_column='projet')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['ProjetComposante'])
-
- # Adding model 'UniteProjet'
- db.create_table(u'ref_unite_projet', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=10, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['UniteProjet'])
-
- # Adding model 'ObjectifSpecifique'
- db.create_table(u'ref_objectif_specifique', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('objectif_strategique', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.ObjectifStrategique'], db_column='objectif_strategique')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['ObjectifSpecifique'])
-
- # Adding model 'ObjectifStrategique'
- db.create_table(u'ref_objectif_strategique', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['ObjectifStrategique'])
-
- # Adding model 'Thematique'
- db.create_table(u'ref_thematique', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Thematique'])
-
- # Adding model 'ProjetUp'
- db.create_table('managedref_projetup', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['ProjetUp'])
-
- # Adding model 'Poste'
- db.create_table(u'ref_poste', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Poste'])
-
- # Adding model 'ProjetPoste'
- db.create_table(u'ref_projet_poste', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('code_projet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Projet'], to_field='code', db_column='code_projet')),
- ('code_poste', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Poste'], to_field='code', db_column='code_poste')),
- ('code_bureau', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Bureau'], to_field='code', db_column='code_bureau')),
- ('code_programme', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Programme'], to_field='code', db_column='code_programme')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['ProjetPoste'])
-
- # Adding model 'Region'
- db.create_table(u'ref_region', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255, db_index=True)),
- ('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'])),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Region'])
-
- # Adding model 'Bureau'
- db.create_table(u'ref_bureau', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=255, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='implantation')),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Bureau'])
-
- # Adding model 'Implantation'
- db.create_table(u'ref_implantation', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_court', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('bureau_rattachement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Implantation'], db_column='bureau_rattachement')),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('fuseau_horaire', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('code_meteo', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('responsable_implantation', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
- ('adresse_postale_precision_avant', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse_postale_no', self.gf('django.db.models.fields.CharField')(max_length=30, null=True, blank=True)),
- ('adresse_postale_rue', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse_postale_bureau', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse_postale_precision', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse_postale_boite_postale', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse_postale_ville', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('adresse_postale_code_postal', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),
- ('adresse_postale_code_postal_avant_ville', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
- ('adresse_postale_region', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('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'])),
- ('adresse_physique_precision_avant', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('adresse_physique_no', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
- ('adresse_physique_rue', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('adresse_physique_bureau', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('adresse_physique_precision', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('adresse_physique_ville', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('adresse_physique_code_postal', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
- ('adresse_physique_code_postal_avant_ville', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
- ('adresse_physique_region', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('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'])),
- ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('telephone_interne', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('fax', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('fax_interne', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('courriel', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),
- ('courriel_interne', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),
- ('url', self.gf('django.db.models.fields.URLField')(max_length=255, blank=True)),
- ('statut', self.gf('django.db.models.fields.IntegerField')()),
- ('date_ouverture', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('date_inauguration', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('date_extension', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('date_fermeture', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('hebergement_etablissement', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('hebergement_convention', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
- ('hebergement_convention_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('remarque', self.gf('django.db.models.fields.TextField')()),
- ('commentaire', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ('modif_date', self.gf('django.db.models.fields.DateField')()),
- ))
- db.send_create_signal('managedref', ['Implantation'])
-
- # Adding model 'Pays'
- db.create_table(u'ref_pays', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(max_length=2, unique=True)),
- ('code_iso3', self.gf('django.db.models.fields.CharField')(max_length=3, unique=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['managedref.Region'], db_column='region')),
- ('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)),
- ('nord_sud', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('developpement', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('monnaie', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Pays'])
-
- # Adding model 'Etablissement'
- db.create_table(u'ref_etablissement', (
- ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('pays', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to_field='code', db_column='pays', to=orm['managedref.Pays'])),
- ('region', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='region', to=orm['managedref.Region'])),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='implantation', to=orm['managedref.Implantation'])),
- ('membre', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ('membre_adhesion_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('qualite', self.gf('django.db.models.fields.CharField')(max_length=3, blank=True, null=True)),
- ('responsable_genre', self.gf('django.db.models.fields.CharField')(max_length=1, blank=True)),
- ('responsable_nom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('responsable_prenom', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('adresse', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('code_postal', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
- ('cedex', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)),
- ('ville', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('province', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('telephone', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('fax', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
- ('url', self.gf('django.db.models.fields.URLField')(max_length=255, null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('managedref', ['Etablissement'])
-
-
- def backwards(self, orm):
-
- # Deleting model 'Employe'
- db.delete_table(u'ref_employe')
-
- # Deleting model 'Authentification'
- db.delete_table(u'ref_authentification')
-
- # Deleting model 'Service'
- db.delete_table(u'ref_service')
-
- # Deleting model 'PosteType'
- db.delete_table(u'ref_poste_type')
-
- # Deleting model 'GroupeArh'
- db.delete_table(u'ref_groupe_arh')
-
- # Deleting model 'GroupeDirRegion'
- db.delete_table(u'ref_groupe_dir_region')
-
- # Deleting model 'GroupeAdmRegion'
- db.delete_table(u'ref_groupe_adm_region')
-
- # Deleting model 'GroupeRespImplantation'
- db.delete_table(u'ref_groupe_resp_implantation')
-
- # Deleting model 'GroupeDirProgramme'
- db.delete_table(u'ref_groupe_dir_programme')
-
- # Deleting model 'GroupeDirDelegProgrammeReg'
- db.delete_table(u'ref_groupe_dir_deleg_programme_reg')
-
- # Deleting model 'GroupeComptable'
- db.delete_table(u'ref_groupe_comptable')
-
- # Deleting model 'GroupeComptableRegional'
- db.delete_table(u'ref_groupe_comptable_regional')
-
- # Deleting model 'GroupeComptableLocal'
- db.delete_table(u'ref_groupe_comptable_local')
-
- # Deleting model 'Discipline'
- db.delete_table(u'ref_discipline')
-
- # Deleting model 'Programme'
- db.delete_table(u'ref_programme')
-
- # Deleting model 'Projet'
- db.delete_table(u'ref_projet')
-
- # Deleting model 'ProjetComposante'
- db.delete_table(u'ref_projet_composante')
-
- # Deleting model 'UniteProjet'
- db.delete_table(u'ref_unite_projet')
-
- # Deleting model 'ObjectifSpecifique'
- db.delete_table(u'ref_objectif_specifique')
-
- # Deleting model 'ObjectifStrategique'
- db.delete_table(u'ref_objectif_strategique')
-
- # Deleting model 'Thematique'
- db.delete_table(u'ref_thematique')
-
- # Deleting model 'ProjetUp'
- db.delete_table('managedref_projetup')
-
- # Deleting model 'Poste'
- db.delete_table(u'ref_poste')
-
- # Deleting model 'ProjetPoste'
- db.delete_table(u'ref_projet_poste')
-
- # Deleting model 'Region'
- db.delete_table(u'ref_region')
-
- # Deleting model 'Bureau'
- db.delete_table(u'ref_bureau')
-
- # Deleting model 'Implantation'
- db.delete_table(u'ref_implantation')
-
- # Deleting model 'Pays'
- db.delete_table(u'ref_pays')
-
- # Deleting model 'Etablissement'
- db.delete_table(u'ref_etablissement')
-
-
- models = {
- 'managedref.authentification': {
- 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
- 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.bureau': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.discipline': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.employe': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
- 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- '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']"}),
- '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']"}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable_de'", 'blank': 'True', 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
- 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.etablissement': {
- 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
- 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
- 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
- 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.groupeadmregion': {
- 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupearh': {
- 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptable': {
- 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptablelocal': {
- 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptableregional': {
- 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupedirdelegprogrammereg': {
- 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupedirprogramme': {
- 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
- },
- 'managedref.groupedirregion': {
- 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.grouperespimplantation': {
- 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.implantation': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- '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']"}),
- 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
- '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']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'modif_date': ('django.db.models.fields.DateField', [], {}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
- 'remarque': ('django.db.models.fields.TextField', [], {}),
- 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.IntegerField', [], {}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.objectifspecifique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
- },
- 'managedref.objectifstrategique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.pays': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.poste': {
- 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.postetype': {
- 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.programme': {
- 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.projet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
- 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.projetcomposante': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
- },
- 'managedref.projetposte': {
- 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
- 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
- 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
- },
- 'managedref.projetup': {
- 'Meta': {'object_name': 'ProjetUp'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.region': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'blank': 'True', 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
- },
- 'managedref.service': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.thematique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.uniteprojet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'unique': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- }
- }
-
- complete_apps = ['managedref']
+++ /dev/null
-# encoding: utf-8
-import datetime
-from south.db import db
-from south.v2 import SchemaMigration
-from django.db import models
-
-class Migration(SchemaMigration):
-
- def forwards(self, orm):
-
- # Adding field 'Etablissement.statut'
- db.add_column(u'ref_etablissement', 'statut', self.gf('django.db.models.fields.CharField')(max_length=1, null=True, blank=True), keep_default=False)
-
- # Adding field 'Etablissement.date_modification'
- db.add_column(u'ref_etablissement', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True), keep_default=False)
-
- # Adding field 'Etablissement.commentaire'
- db.add_column(u'ref_etablissement', 'commentaire', self.gf('django.db.models.fields.TextField')(default='', blank=True), keep_default=False)
-
-
- def backwards(self, orm):
-
- # Deleting field 'Etablissement.statut'
- db.delete_column(u'ref_etablissement', 'statut')
-
- # Deleting field 'Etablissement.date_modification'
- db.delete_column(u'ref_etablissement', 'date_modification')
-
- # Deleting field 'Etablissement.commentaire'
- db.delete_column(u'ref_etablissement', 'commentaire')
-
-
- models = {
- 'managedref.authentification': {
- 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
- 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.bureau': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.discipline': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.employe': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
- 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'poste_type_1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_1'", 'null': 'True', 'db_column': "'poste_type_1'", 'to': "orm['managedref.PosteType']"}),
- 'poste_type_2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_2'", 'null': 'True', 'db_column': "'poste_type_2'", 'to': "orm['managedref.PosteType']"}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsable_de'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
- 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.etablissement': {
- 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
- 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
- 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'qualite': ('django.db.models.fields.CharField', [], {'max_length': '3', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
- 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
- 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.groupeadmregion': {
- 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupearh': {
- 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptable': {
- 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptablelocal': {
- 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptableregional': {
- 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupedirdelegprogrammereg': {
- 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupedirprogramme': {
- 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
- },
- 'managedref.groupedirregion': {
- 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.grouperespimplantation': {
- 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.implantation': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- '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']"}),
- 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
- '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']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'modif_date': ('django.db.models.fields.DateField', [], {}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
- 'remarque': ('django.db.models.fields.TextField', [], {}),
- 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.IntegerField', [], {}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.objectifspecifique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
- },
- 'managedref.objectifstrategique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.pays': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.poste': {
- 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.postetype': {
- 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.programme': {
- 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.projet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
- 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.projetcomposante': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
- },
- 'managedref.projetposte': {
- 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
- 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
- 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
- },
- 'managedref.projetup': {
- 'Meta': {'object_name': 'ProjetUp'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.region': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'gere_region'", 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
- },
- 'managedref.service': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.thematique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.uniteprojet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- }
- }
-
- complete_apps = ['managedref']
+++ /dev/null
-# encoding: utf-8
-import datetime
-from south.db import db
-from south.v2 import SchemaMigration
-from django.db import models
-
-class Migration(SchemaMigration):
-
- def forwards(self, orm):
- db.alter_column('ref_etablissement', 'implantation', models.ForeignKey(
- orm['managedref.Implantation'], db_column='implantation',
- related_name='+', blank=True, null=True
- ))
-
- def backwards(self, orm):
- pass
-
-
- models = {
- 'managedref.authentification': {
- 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
- 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.bureau': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.discipline': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.employe': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
- 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'poste_type_1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_1'", 'null': 'True', 'db_column': "'poste_type_1'", 'to': "orm['managedref.PosteType']"}),
- 'poste_type_2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_2'", 'null': 'True', 'db_column': "'poste_type_2'", 'to': "orm['managedref.PosteType']"}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsable_de'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
- 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.etablissement': {
- 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
- 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
- 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'qualite': ('django.db.models.fields.CharField', [], {'max_length': '3', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
- 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
- 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.groupeadmregion': {
- 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupearh': {
- 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptable': {
- 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptablelocal': {
- 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptableregional': {
- 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupedirdelegprogrammereg': {
- 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupedirprogramme': {
- 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
- },
- 'managedref.groupedirregion': {
- 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.grouperespimplantation': {
- 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.implantation': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- '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']"}),
- 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
- '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']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'modif_date': ('django.db.models.fields.DateField', [], {}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
- 'remarque': ('django.db.models.fields.TextField', [], {}),
- 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.IntegerField', [], {}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.objectifspecifique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
- },
- 'managedref.objectifstrategique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.pays': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.poste': {
- 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.postetype': {
- 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.programme': {
- 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.projet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
- 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.projetcomposante': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
- },
- 'managedref.projetposte': {
- 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
- 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
- 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
- },
- 'managedref.projetup': {
- 'Meta': {'object_name': 'ProjetUp'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.region': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'gere_region'", 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
- },
- 'managedref.service': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.thematique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.uniteprojet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- }
- }
-
- complete_apps = ['managedref']
+++ /dev/null
-# encoding: utf-8
-import datetime
-from south.db import db
-from south.v2 import SchemaMigration
-from django.db import models
-
-class Migration(SchemaMigration):
-
- def forwards(self, orm):
-
- # Adding field 'Etablissement.responsable_fonction'
- db.add_column(u'ref_etablissement', 'responsable_fonction', self.gf('django.db.models.fields.CharField')(default='', max_length=255, blank=True), keep_default=False)
-
-
- def backwards(self, orm):
-
- # Deleting field 'Etablissement.responsable_fonction'
- db.delete_column(u'ref_etablissement', 'responsable_fonction')
-
-
- models = {
- 'managedref.authentification': {
- 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
- 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.bureau': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.discipline': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.employe': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
- 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'poste_type_1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_1'", 'null': 'True', 'db_column': "'poste_type_1'", 'to': "orm['managedref.PosteType']"}),
- 'poste_type_2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_2'", 'null': 'True', 'db_column': "'poste_type_2'", 'to': "orm['managedref.PosteType']"}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsable_de'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
- 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.etablissement': {
- 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
- 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
- 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'qualite': ('django.db.models.fields.CharField', [], {'max_length': '3', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
- 'responsable_fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
- 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.groupeadmregion': {
- 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupearh': {
- 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptable': {
- 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptablelocal': {
- 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptableregional': {
- 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupedirdelegprogrammereg': {
- 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupedirprogramme': {
- 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
- },
- 'managedref.groupedirregion': {
- 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.grouperespimplantation': {
- 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.implantation': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- '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']"}),
- 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
- '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']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'modif_date': ('django.db.models.fields.DateField', [], {}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
- 'remarque': ('django.db.models.fields.TextField', [], {}),
- 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.IntegerField', [], {}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.objectifspecifique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
- },
- 'managedref.objectifstrategique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.pays': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.poste': {
- 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.postetype': {
- 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.programme': {
- 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.projet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
- 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.projetcomposante': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
- },
- 'managedref.projetposte': {
- 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
- 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
- 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
- },
- 'managedref.projetup': {
- 'Meta': {'object_name': 'ProjetUp'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.region': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'gere_region'", 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
- },
- 'managedref.service': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.thematique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.uniteprojet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'references.bureau': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'", '_ormbases': ['managedref.Bureau'], 'proxy': 'True'}
- },
- 'references.employe': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'", '_ormbases': ['managedref.Employe'], 'proxy': 'True'}
- },
- 'references.etablissement': {
- 'Meta': {'managed': 'False', 'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'", '_ormbases': ['managedref.Etablissement'], 'proxy': 'True'}
- },
- 'references.implantation': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'", '_ormbases': ['managedref.Implantation'], 'proxy': 'True'}
- },
- 'references.objectifspecifique': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'", '_ormbases': ['managedref.ObjectifSpecifique'], 'proxy': 'True'}
- },
- 'references.objectifstrategique': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'", '_ormbases': ['managedref.ObjectifStrategique'], 'proxy': 'True'}
- },
- 'references.pays': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'", '_ormbases': ['managedref.Pays'], 'proxy': 'True'}
- },
- 'references.poste': {
- 'Meta': {'managed': 'False', 'object_name': 'Poste', 'db_table': "u'ref_poste'", '_ormbases': ['managedref.Poste'], 'proxy': 'True'}
- },
- 'references.postetype': {
- 'Meta': {'managed': 'False', 'object_name': 'PosteType', 'db_table': "u'ref_poste_type'", '_ormbases': ['managedref.PosteType'], 'proxy': 'True'}
- },
- 'references.programme': {
- 'Meta': {'managed': 'False', 'object_name': 'Programme', 'db_table': "u'ref_programme'", '_ormbases': ['managedref.Programme'], 'proxy': 'True'}
- },
- 'references.projet': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'", '_ormbases': ['managedref.Projet'], 'proxy': 'True'}
- },
- 'references.region': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'", '_ormbases': ['managedref.Region'], 'proxy': 'True'}
- },
- 'references.service': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'", '_ormbases': ['managedref.Service'], 'proxy': 'True'}
- }
- }
-
- complete_apps = ['managedref']
+++ /dev/null
-# encoding: utf-8
-import datetime
-from south.db import db
-from south.v2 import SchemaMigration
-from django.db import models
-
-class Migration(SchemaMigration):
-
- def forwards(self, orm):
-
- # Adding field 'Etablissement.description'
- db.add_column(u'ref_etablissement', 'description', self.gf('django.db.models.fields.TextField')(default='', blank=True), keep_default=False)
-
- # Adding field 'Etablissement.historique'
- db.add_column(u'ref_etablissement', 'historique', self.gf('django.db.models.fields.TextField')(default='', blank=True), keep_default=False)
-
-
- def backwards(self, orm):
-
- # Deleting field 'Etablissement.description'
- db.delete_column(u'ref_etablissement', 'description')
-
- # Deleting field 'Etablissement.historique'
- db.delete_column(u'ref_etablissement', 'historique')
-
-
- models = {
- 'managedref.authentification': {
- 'Meta': {'ordering': "['id']", 'object_name': 'Authentification', 'db_table': "u'ref_authentification'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'primary_key': 'True', 'db_column': "'id'"}),
- 'motdepasse': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.bureau': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.discipline': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Discipline', 'db_table': "u'ref_discipline'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.employe': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'courriel': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_theorique_de'", 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'implantation_physique': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'lieu_travail_reel_de'", 'db_column': "'implantation_physique'", 'to': "orm['managedref.Implantation']"}),
- 'mandat_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'mandat_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'poste_type_1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_1'", 'null': 'True', 'db_column': "'poste_type_1'", 'to': "orm['managedref.PosteType']"}),
- 'poste_type_2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste_type_2'", 'null': 'True', 'db_column': "'poste_type_2'", 'to': "orm['managedref.PosteType']"}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsable_de'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['managedref.Employe']"}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"}),
- 'telephone_ip': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'telephone_poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.etablissement': {
- 'Meta': {'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
- 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'cedex': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'historique': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'implantation'", 'to': "orm['managedref.Implantation']"}),
- 'membre': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'membre_adhesion_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'pays'", 'to': "orm['managedref.Pays']"}),
- 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'qualite': ('django.db.models.fields.CharField', [], {'max_length': '3', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'+'", 'null': 'True', 'db_column': "'region'", 'to': "orm['managedref.Region']"}),
- 'responsable_fonction': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'blank': 'True'}),
- 'responsable_nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'responsable_prenom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.groupeadmregion': {
- 'Meta': {'object_name': 'GroupeAdmRegion', 'db_table': "u'ref_groupe_adm_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupearh': {
- 'Meta': {'object_name': 'GroupeArh', 'db_table': "u'ref_groupe_arh'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptable': {
- 'Meta': {'object_name': 'GroupeComptable', 'db_table': "u'ref_groupe_comptable'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptablelocal': {
- 'Meta': {'object_name': 'GroupeComptableLocal', 'db_table': "u'ref_groupe_comptable_local'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupecomptableregional': {
- 'Meta': {'object_name': 'GroupeComptableRegional', 'db_table': "u'ref_groupe_comptable_regional'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
- },
- 'managedref.groupedirdelegprogrammereg': {
- 'Meta': {'object_name': 'GroupeDirDelegProgrammeReg', 'db_table': "u'ref_groupe_dir_deleg_programme_reg'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.groupedirprogramme': {
- 'Meta': {'object_name': 'GroupeDirProgramme', 'db_table': "u'ref_groupe_dir_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Service']", 'db_column': "'service'"})
- },
- 'managedref.groupedirregion': {
- 'Meta': {'object_name': 'GroupeDirRegion', 'db_table': "u'ref_groupe_dir_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.grouperespimplantation': {
- 'Meta': {'object_name': 'GroupeRespImplantation', 'db_table': "u'ref_groupe_resp_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'implantation'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.implantation': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
- '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']"}),
- 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
- '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']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
- 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'modif_date': ('django.db.models.fields.DateField', [], {}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"}),
- 'remarque': ('django.db.models.fields.TextField', [], {}),
- 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'statut': ('django.db.models.fields.IntegerField', [], {}),
- 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.objectifspecifique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_strategique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifStrategique']", 'db_column': "'objectif_strategique'"})
- },
- 'managedref.objectifstrategique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.pays': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'null': 'True', 'db_column': "'code_bureau'", 'blank': 'True'}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Region']", 'db_column': "'region'"})
- },
- 'managedref.poste': {
- 'Meta': {'object_name': 'Poste', 'db_table': "u'ref_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.postetype': {
- 'Meta': {'object_name': 'PosteType', 'db_table': "u'ref_poste_type'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.programme': {
- 'Meta': {'object_name': 'Programme', 'db_table': "u'ref_programme'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.projet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'etablissement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Etablissement']", 'null': 'True', 'db_column': "'etablissement'", 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Implantation']", 'null': 'True', 'db_column': "'implantation'", 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'objectif_specifique': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.ObjectifSpecifique']", 'null': 'True', 'db_column': "'objectif_specifique'", 'blank': 'True'}),
- 'partenaires': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'presentation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'service': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'managedref.projetcomposante': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'ProjetComposante', 'db_table': "u'ref_projet_composante'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'db_column': "'projet'"})
- },
- 'managedref.projetposte': {
- 'Meta': {'object_name': 'ProjetPoste', 'db_table': "u'ref_projet_poste'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Poste']", 'to_field': "'code'", 'db_column': "'code_poste'"}),
- 'code_programme': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Programme']", 'to_field': "'code'", 'db_column': "'code_programme'"}),
- 'code_projet': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['managedref.Projet']", 'to_field': "'code'", 'db_column': "'code_projet'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'})
- },
- 'managedref.projetup': {
- 'Meta': {'object_name': 'ProjetUp'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
- },
- 'managedref.region': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
- 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'gere_region'", 'null': 'True', 'db_column': "'implantation_bureau'", 'to': "orm['managedref.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
- },
- 'managedref.service': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.thematique': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'Thematique', 'db_table': "u'ref_thematique'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'managedref.uniteprojet': {
- 'Meta': {'ordering': "['nom']", 'object_name': 'UniteProjet', 'db_table': "u'ref_unite_projet'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'references.bureau': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Bureau', 'db_table': "u'ref_bureau'", '_ormbases': ['managedref.Bureau'], 'proxy': 'True'}
- },
- 'references.employe': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Employe', 'db_table': "u'ref_employe'", '_ormbases': ['managedref.Employe'], 'proxy': 'True'}
- },
- 'references.etablissement': {
- 'Meta': {'managed': 'False', 'ordering': "['pays__nom', 'nom']", 'object_name': 'Etablissement', 'db_table': "u'ref_etablissement'", '_ormbases': ['managedref.Etablissement'], 'proxy': 'True'}
- },
- 'references.implantation': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'", '_ormbases': ['managedref.Implantation'], 'proxy': 'True'}
- },
- 'references.objectifspecifique': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'ObjectifSpecifique', 'db_table': "u'ref_objectif_specifique'", '_ormbases': ['managedref.ObjectifSpecifique'], 'proxy': 'True'}
- },
- 'references.objectifstrategique': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'ObjectifStrategique', 'db_table': "u'ref_objectif_strategique'", '_ormbases': ['managedref.ObjectifStrategique'], 'proxy': 'True'}
- },
- 'references.pays': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Pays', 'db_table': "u'ref_pays'", '_ormbases': ['managedref.Pays'], 'proxy': 'True'}
- },
- 'references.poste': {
- 'Meta': {'managed': 'False', 'object_name': 'Poste', 'db_table': "u'ref_poste'", '_ormbases': ['managedref.Poste'], 'proxy': 'True'}
- },
- 'references.postetype': {
- 'Meta': {'managed': 'False', 'object_name': 'PosteType', 'db_table': "u'ref_poste_type'", '_ormbases': ['managedref.PosteType'], 'proxy': 'True'}
- },
- 'references.programme': {
- 'Meta': {'managed': 'False', 'object_name': 'Programme', 'db_table': "u'ref_programme'", '_ormbases': ['managedref.Programme'], 'proxy': 'True'}
- },
- 'references.projet': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Projet', 'db_table': "u'ref_projet'", '_ormbases': ['managedref.Projet'], 'proxy': 'True'}
- },
- 'references.region': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Region', 'db_table': "u'ref_region'", '_ormbases': ['managedref.Region'], 'proxy': 'True'}
- },
- 'references.service': {
- 'Meta': {'managed': 'False', 'ordering': "['nom']", 'object_name': 'Service', 'db_table': "u'ref_service'", '_ormbases': ['managedref.Service'], 'proxy': 'True'}
- }
- }
-
- complete_apps = ['managedref']
+++ /dev/null
-# encoding: utf-8
-
-from django.db import models
-
-
-class ActifsManager(models.Manager):
- """
- Manager pour ``ActifsModel``.
- """
-
- def get_query_set(self):
- return super(ActifsManager, self).get_query_set().filter(actif=True)
-
-
-class ActifsModel(models.Model):
- """
- Modèle faisant la gestion des objets actifs/inactifs.
-
- Le manager par défaut ne liste que les objets actifs. Pour avoir tous
- les objets, utiliser le manager ``avec_inactifs``.
- """
- actif = models.BooleanField(default=True, editable=False)
-
- # Managers
- objects = ActifsManager()
- avec_inactifs = models.Manager()
-
- class Meta:
- abstract = True
-
-
-class Employe(ActifsModel):
- """
- Personne en contrat d'employé (CDD ou CDI) à l'AUF
- """
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- prenom = models.CharField(max_length=255)
- implantation = models.ForeignKey(
- 'references.Implantation',
- db_column='implantation',
- related_name='lieu_travail_theorique_de'
- )
- implantation_physique = models.ForeignKey(
- 'references.Implantation',
- db_column='implantation_physique',
- related_name='lieu_travail_reel_de'
- )
- courriel = models.CharField(max_length=255, null=True, blank=True)
- genre = models.CharField(max_length=3)
- fonction = models.CharField(max_length=255, null=True, blank=True)
- telephone_poste = models.CharField(max_length=255, null=True, blank=True)
- telephone_ip = models.CharField(max_length=255, null=True, blank=True)
- responsable = models.ForeignKey(
- 'references.Employe',
- db_column='responsable',
- related_name='responsable_de',
- null=True, blank=True
- )
- mandat_debut = models.DateField(null=True, blank=True)
- mandat_fin = models.DateField(null=True, blank=True)
- date_entree = models.DateField(null=True, blank=True)
- service = models.ForeignKey('references.Service', db_column='service')
- poste_type_1 = models.ForeignKey(
- 'references.PosteType',
- null=True, blank=True,
- db_column='poste_type_1',
- related_name='poste_type_1'
- )
- poste_type_2 = models.ForeignKey(
- 'references.PosteType',
- null=True, blank=True,
- db_column='poste_type_2',
- related_name='poste_type_2'
- )
-
- class Meta:
- db_table = u'ref_employe'
- ordering = ['nom']
-
- def __unicode__(self):
- return u"%s, %s [%d]" % (self.nom, self.prenom, self.id)
-
-
-class Authentification(ActifsModel):
- """Authentification"""
- id = models.ForeignKey(
- 'references.Employe', primary_key=True, db_column='id'
- )
- courriel = models.CharField(max_length=255, unique=True)
- motdepasse = models.CharField(max_length=255)
-
- class Meta:
- db_table = u'ref_authentification'
- ordering = ['id']
-
- def __unicode__(self):
- return u"%s [%d]" % (self.courriel, self.id)
-
-
-class Service(ActifsModel):
- """Services (donnée de référence, source: SGRH).
- """
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
-
- class Meta:
- db_table = u'ref_service'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s (%s)" % (self.nom, self.id)
-
-
-class PosteType(ActifsModel):
- """Postes types (donnée de référence, source: SGRH).
- """
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
-
- class Meta:
- db_table = u'ref_poste_type'
-
- def __unicode__(self):
- return "%s (%s)" % (self.nom, self.id)
-
-
-class GroupeArh(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
-
- class Meta:
- db_table = u'ref_groupe_arh'
-
-
-class GroupeDirRegion(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
- region = models.ForeignKey('references.Region', db_column='region')
-
- class Meta:
- db_table = u'ref_groupe_dir_region'
-
-
-class GroupeAdmRegion(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
- region = models.ForeignKey('references.Region', db_column='region')
-
- class Meta:
- db_table = u'ref_groupe_adm_region'
-
-
-class GroupeRespImplantation(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
- implantation = models.ForeignKey(
- 'references.Implantation', db_column='implantation'
- )
- type = models.CharField(max_length=255, blank=True, null=True)
-
- class Meta:
- db_table = u'ref_groupe_resp_implantation'
-
-
-class GroupeDirProgramme(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
- service = models.ForeignKey('references.Service', db_column='service')
-
- class Meta:
- db_table = u'ref_groupe_dir_programme'
-
-
-class GroupeDirDelegProgrammeReg(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
- region = models.ForeignKey('references.Region', db_column='region')
-
- class Meta:
- db_table = u'ref_groupe_dir_deleg_programme_reg'
-
-
-class GroupeComptable(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
-
- class Meta:
- db_table = u'ref_groupe_comptable'
-
-
-class GroupeComptableRegional(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
-
- class Meta:
- db_table = u'ref_groupe_comptable_regional'
-
-
-class GroupeComptableLocal(ActifsModel):
- id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('references.Employe', db_column='employe')
-
- class Meta:
- db_table = u'ref_groupe_comptable_local'
-
-
-class Discipline(ActifsModel):
- """ ATTENTION: DÉSUET
- Discipline (donnée de référence, source: SQI).
- Une discipline est une catégorie de savoirs scientifiques.
- Le conseil scientifique fixe la liste des disciplines.
- """
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- nom_long = models.CharField(max_length=255, blank=True)
- nom_court = models.CharField(max_length=255, blank=True)
-
- class Meta:
- db_table = u'ref_discipline'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.code, self.nom)
-
-
-class Programme(ActifsModel):
- """ ATTENTION: DÉSUET
- Programme (donnée de référence, source: SQI).
- Structure interne par laquelle l'AUF exécute ses projets et activités,
- dispense ses produits et ses services.
- """
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- nom_long = models.CharField(max_length=255, blank=True)
- nom_court = models.CharField(max_length=255, blank=True)
-
- class Meta:
- db_table = u'ref_programme'
-
- def __unicode__(self):
- return "%s - %s" % (self.code, self.nom)
-
-
-#PROGRAMMATION QUADRIENNALLE
-
-class Projet(ActifsModel):
- """Projet (donnée de référence, source: programmation-quadriennalle).
- """
- SERVICE_CHOICES = (
- ('1',
- "Direction de la langue et de la communication scientifique "
- "en français"),
- ('2', "Direction du développement et de la valorisation"),
- ('3',
- "Direction de l'innovation pédagogique et de l'économie "
- "de la connaissance"),
- ('4', "Direction du renforcement des capacités scientifiques"),
- )
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- presentation = models.TextField(null=True, blank=True)
- partenaires = models.TextField(null=True, blank=True)
- service = models.CharField(
- max_length=255, choices=SERVICE_CHOICES, blank=True, null=True
- )
- objectif_specifique = models.ForeignKey(
- 'references.ObjectifSpecifique',
- blank=True, null=True,
- db_column='objectif_specifique'
- )
- implantation = models.ForeignKey('references.Implantation', null=True,
- blank=True, db_column='implantation')
- etablissement = models.ForeignKey('references.Etablissement', null=True,
- blank=True, db_column='etablissement')
- date_debut = models.DateField(null=True, blank=True)
- date_fin = models.DateField(null=True, blank=True)
-
- class Meta:
- db_table = u'ref_projet'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.code, self.nom)
-
-
-class ProjetComposante(ActifsModel):
- """Composantes des projets (source: programmation-quadriennalle)
- """
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=10)
- nom = models.CharField(max_length=255)
- nom_court = models.CharField(max_length=255, null=True, blank=True)
- description = models.TextField(null=True, blank=True)
- projet = models.ForeignKey('references.Projet', db_column='projet')
-
- class Meta:
- db_table = u'ref_projet_composante'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.code, self.nom)
-
-
-class UniteProjet(ActifsModel):
- """Unités de projet (source: programmation-quadriennalle)
- """
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=10, unique=True)
- nom = models.CharField(max_length=255)
-
- class Meta:
- db_table = u'ref_unite_projet'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.code, self.nom)
-
-
-class ObjectifSpecifique(ActifsModel):
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- objectif_strategique = models.ForeignKey('references.ObjectifStrategique',
- db_column='objectif_strategique')
-
- class Meta:
- db_table = u'ref_objectif_specifique'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.id, self.nom)
-
-
-class ObjectifStrategique(ActifsModel):
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- description = models.TextField(null=True, blank=True)
-
- class Meta:
- db_table = u'ref_objectif_strategique'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.id, self.nom)
-
-
-class Thematique(ActifsModel):
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
-
- class Meta:
- db_table = u'ref_thematique'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.id, self.nom)
-
-
-class ProjetUp(ActifsModel):
- """Projet-unité de projet (source: coda)
- => codes budgétaires
- """
- id = models.AutoField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- nom_court = models.CharField(max_length=255, blank=True)
-
-
-class Poste(ActifsModel):
- """ ATTENTION: DÉSUET
- Poste (donnée de référence, source: CODA).
- Un poste est une catégorie destinée à venir raffiner un projet.
- """
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- type = models.CharField(max_length=255, blank=True)
-
- class Meta:
- db_table = u'ref_poste'
-
- def __unicode__(self):
- return "%s - %s (%s)" % (self.code, self.nom, self.type)
-
-
-class ProjetPoste(ActifsModel):
- """
- ATTENTION: DÉSUET
- Projet-poste (donnée de référence, source: CODA).
- Un projet-poste consiste en une raffinement d'un projet par un poste
- (budgétaire). Subdivision utile pour le suivi budgétaire et comptable.
- """
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=255, unique=True)
- code_projet = models.ForeignKey(
- 'references.Projet', to_field='code', db_column='code_projet'
- )
- code_poste = models.ForeignKey(
- 'references.Poste', to_field='code', db_column='code_poste'
- )
- code_bureau = models.ForeignKey(
- 'references.Bureau', to_field='code', db_column='code_bureau'
- )
- code_programme = models.ForeignKey(
- 'references.Programme', to_field='code', db_column='code_programme'
- )
-
- class Meta:
- db_table = u'ref_projet_poste'
-
- def __unicode__(self):
- return "%s" % (self.code)
-
-
-class Region(ActifsModel):
- """Région (donnée de référence, source: referentiels_spip).
- Une région est une subdivision géographique du monde pour la gestion de
- l'AUF.
- """
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255, db_index=True)
- implantation_bureau = models.ForeignKey(
- 'references.Implantation', db_column='implantation_bureau',
- related_name='gere_region', null=True, blank=True
- )
-
- class Meta:
- db_table = u'ref_region'
- ordering = ['nom']
- verbose_name = u"région"
- verbose_name_plural = u"régions"
-
- def __unicode__(self):
- return "%s (%s)" % (self.nom, self.code)
-
-
-class Bureau(ActifsModel):
- """
- Bureau (donnée de référence, source: SQI).
-
- Référence legacy entre la notion de région et celle d'implantation
- responsable des régions et du central.
-
- Un bureau est :
- - soit le bureau régional d'une région (implantations de type 'Bureau')
- - soit la notion unique de Service central pour les 2 implantations
- centrales (implantations de type 'Service central' et 'Siege').
-
- Ne pas confondre avec les seuls 'bureaux régionaux'.
- """
- code = models.CharField(max_length=255, unique=True)
- nom = models.CharField(max_length=255)
- nom_court = models.CharField(max_length=255, blank=True)
- nom_long = models.CharField(max_length=255, blank=True)
- implantation = models.ForeignKey(
- 'references.Implantation', db_column='implantation'
- )
- region = models.ForeignKey('references.Region', db_column='region')
-
- class Meta:
- db_table = u'ref_bureau'
- ordering = ['nom']
- verbose_name = u"bureau"
- verbose_name_plural = u"bureaux"
-
- def __unicode__(self):
- return "%s (%s)" % (self.nom, self.code)
-
-
-class Implantation(ActifsModel):
- """
- Implantation (donnée de référence, source: Implantus)
-
- Une implantation est un endroit où l'AUF est présente et offre des
- services spécifiques. Deux implantations peuvent être au même endroit
- physique.
- """
- STATUT_CHOICES = (
- (0, u'Fermée ou jamais ouverte'),
- (1, u'Ouverte'),
- (2, u'Ouverture imminente'),
- (3, u'En projet')
- )
-
- nom = models.CharField(max_length=255)
- nom_court = models.CharField(max_length=255, blank=True)
- nom_long = models.CharField(max_length=255, blank=True)
- type = models.CharField(max_length=255)
- bureau_rattachement = models.ForeignKey(
- 'references.Implantation', db_column='bureau_rattachement'
- )
- region = models.ForeignKey('references.Region', db_column='region')
- fuseau_horaire = models.CharField(max_length=255, blank=True)
- code_meteo = models.CharField(max_length=255, blank=True)
- # responsable
- responsable_implantation = models.IntegerField(null=True, blank=True)
- # adresse postale
- adresse_postale_precision_avant = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_no = models.CharField(max_length=30, blank=True, null=True)
- adresse_postale_rue = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_bureau = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_precision = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_boite_postale = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_ville = models.CharField(max_length=255)
- adresse_postale_code_postal = models.CharField(
- max_length=20, blank=True, null=True
- )
- adresse_postale_code_postal_avant_ville = models.NullBooleanField()
- adresse_postale_region = models.CharField(
- max_length=255, blank=True, null=True
- )
- adresse_postale_pays = models.ForeignKey(
- 'references.Pays', to_field='code',
- db_column='adresse_postale_pays',
- related_name='impl_adresse_postale'
- )
- # adresse physique
- adresse_physique_precision_avant = models.CharField(
- max_length=255, blank=True
- )
- adresse_physique_no = models.CharField(max_length=30, blank=True)
- adresse_physique_rue = models.CharField(max_length=255, blank=True)
- adresse_physique_bureau = models.CharField(max_length=255, blank=True)
- adresse_physique_precision = models.CharField(max_length=255, blank=True)
- adresse_physique_ville = models.CharField(max_length=255)
- adresse_physique_code_postal = models.CharField(max_length=30, blank=True)
- adresse_physique_code_postal_avant_ville = models.NullBooleanField()
- adresse_physique_region = models.CharField(max_length=255, blank=True)
- adresse_physique_pays = models.ForeignKey(
- 'references.Pays', to_field='code',
- db_column='adresse_physique_pays',
- related_name='impl_adresse_physique'
- )
- # autres coordonnées
- telephone = models.CharField(max_length=255, blank=True)
- telephone_interne = models.CharField(max_length=255, blank=True)
- fax = models.CharField(max_length=255, blank=True)
- fax_interne = models.CharField(max_length=255, blank=True)
- courriel = models.EmailField(blank=True)
- courriel_interne = models.EmailField(blank=True)
- url = models.URLField(verify_exists=False, max_length=255, blank=True)
- # traitement
- statut = models.IntegerField(choices=STATUT_CHOICES)
- date_ouverture = models.DateField(null=True, blank=True)
- date_inauguration = models.DateField(null=True, blank=True)
- date_extension = models.DateField(null=True, blank=True)
- date_fermeture = models.DateField(null=True, blank=True)
- hebergement_etablissement = models.CharField(max_length=255, blank=True)
- hebergement_convention = models.NullBooleanField()
- hebergement_convention_date = models.DateField(null=True, blank=True)
- remarque = models.TextField()
- commentaire = models.CharField(max_length=255, blank=True)
- # meta
- modif_date = models.DateField()
-
- class Managers:
-
- class Ouvertes(ActifsManager):
-
- def get_query_set(self):
- return super(Implantation.Managers.Ouvertes, self) \
- .get_query_set() \
- .filter(statut=1)
-
- objects = ActifsManager()
- ouvertes = Managers.Ouvertes()
-
- class Meta:
- db_table = u'ref_implantation'
- ordering = ['nom']
-
- def __unicode__(self):
- return "%s (%d)" % (self.nom, self.id)
-
-
-class Pays(ActifsModel):
- """
- Pays (donnée de référence, source: SQI).
-
- Liste AUF basée sur la liste ISO-3166-1.
- """
- code = models.CharField(max_length=2, unique=True)
- code_iso3 = models.CharField(max_length=3, unique=True)
- nom = models.CharField(max_length=255)
- region = models.ForeignKey('references.Region', db_column='region')
- code_bureau = models.ForeignKey('references.Bureau', to_field='code',
- db_column='code_bureau', blank=True,
- null=True)
- nord_sud = models.CharField(max_length=255, blank=True, null=True)
- developpement = models.CharField(max_length=255, blank=True, null=True)
- monnaie = models.CharField(max_length=255, blank=True, null=True)
-
- class Meta:
- db_table = u'ref_pays'
- ordering = ['nom']
- verbose_name = u"pays"
- verbose_name_plural = u"pays"
-
- def __unicode__(self):
- return "%s (%s)" % (self.nom, self.code)
-
-
-class EtablissementBase(ActifsModel):
- """
- Établissement (donnée de référence, source: GDE).
-
- Un établissement peut être une université, un centre de recherche, un
- réseau d'établissement... Un établissement peut être membre de l'AUF ou
- non.
- """
- MEMBRE_STATUT_CHOICES = (
- ('T', 'Titulaire'),
- ('A', 'Associé'),
- ('C', 'Candidat'),
- )
- QUALITE_CHOICES = (
- ('ESR', "Établissement d'enseignement supérieur et de recherche"),
- ('CIR', "Centre ou institution de recherche"),
- ('RES', "Réseau"),
- )
-
- # Infos de base
- nom = models.CharField(max_length=255)
- pays = models.ForeignKey(
- 'references.Pays', to_field='code', db_column='pays',
- related_name='+'
- )
- region = models.ForeignKey(
- 'references.Region', db_column='region', blank=True, null=True,
- related_name='+', verbose_name='région'
- )
- implantation = models.ForeignKey(
- 'references.Implantation', db_column='implantation',
- related_name='+', blank=True, null=True
- )
- description = models.TextField(blank=True)
- historique = models.TextField(blank=True)
-
- # Membership
- membre = models.BooleanField()
- membre_adhesion_date = models.DateField(null=True, blank=True,
- verbose_name="date d'adhésion")
- statut = models.CharField(max_length=1, choices=MEMBRE_STATUT_CHOICES,
- blank=True, null=True)
- qualite = models.CharField(max_length=3, choices=QUALITE_CHOICES,
- verbose_name="qualité", blank=True,
- null=True)
-
- # Responsable
- responsable_genre = models.CharField(
- max_length=1, blank=True, verbose_name='genre'
- )
- responsable_nom = models.CharField(
- max_length=255, blank=True, verbose_name='nom'
- )
- responsable_prenom = models.CharField(
- max_length=255, blank=True, verbose_name='prénom'
- )
- responsable_fonction = models.CharField(
- max_length=255, blank=True, verbose_name='fonction'
- )
-
- # Adresse
- adresse = models.CharField(max_length=255, blank=True)
- code_postal = models.CharField(max_length=20, blank=True,
- verbose_name='code postal')
- cedex = models.CharField(max_length=20, blank=True, verbose_name='CEDEX')
- ville = models.CharField(max_length=255, blank=True)
- province = models.CharField(max_length=255, blank=True)
- telephone = models.CharField(max_length=255, blank=True,
- verbose_name='téléphone')
- fax = models.CharField(max_length=255, blank=True)
- url = models.URLField(verify_exists=False, max_length=255, null=True,
- blank=True, verbose_name='URL')
-
- # Meta-données
- date_modification = models.DateField(verbose_name='date de modification',
- blank=True, null=True)
- commentaire = models.TextField(blank=True)
-
- class Meta:
- abstract = True
- ordering = ['pays__nom', 'nom']
-
- def __unicode__(self):
- return "%s - %s" % (self.pays.nom, self.nom)
-
-
-class Etablissement(EtablissementBase):
-
- class Meta(EtablissementBase.Meta):
- db_table = u'ref_etablissement'
# -=- encoding: utf-8 -=-
+from django.conf import settings
from django.db import models
-from auf.django.references.managedref import models as managedref
+MANAGED = getattr(settings, 'AUF_REFERENCES_MANAGED', False)
-### Proxies vers les modèles dans managedref
+### Gestion des actifs/inactifs
-class Pays(managedref.Pays):
+class ActifsManager(models.Manager):
+ """
+ Manager pour ``ActifsModel``.
+ """
+
+ def get_query_set(self):
+ return super(ActifsManager, self).get_query_set().filter(actif=True)
- class Meta:
- proxy = True
- managed = False
+class ActifsModel(models.Model):
+ """
+ Modèle faisant la gestion des objets actifs/inactifs.
-class Region(managedref.Region):
+ Le manager par défaut ne liste que les objets actifs. Pour avoir tous
+ les objets, utiliser le manager ``avec_inactifs``.
+ """
+ actif = models.BooleanField(default=True, editable=False)
+
+ # Managers
+ objects = ActifsManager()
+ avec_inactifs = models.Manager()
class Meta:
- proxy = True
- managed = False
+ abstract = True
-class Bureau(managedref.Bureau):
+### Modèles pour les données de référence
+
+class Employe(ActifsModel):
+ """
+ Personne en contrat d'employé (CDD ou CDI) à l'AUF
+ """
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
+ prenom = models.CharField(max_length=255)
+ implantation = models.ForeignKey(
+ 'references.Implantation',
+ db_column='implantation',
+ related_name='lieu_travail_theorique_de'
+ )
+ implantation_physique = models.ForeignKey(
+ 'references.Implantation',
+ db_column='implantation_physique',
+ related_name='lieu_travail_reel_de'
+ )
+ courriel = models.CharField(max_length=255, null=True, blank=True)
+ genre = models.CharField(max_length=3)
+ fonction = models.CharField(max_length=255, null=True, blank=True)
+ telephone_poste = models.CharField(max_length=255, null=True, blank=True)
+ telephone_ip = models.CharField(max_length=255, null=True, blank=True)
+ responsable = models.ForeignKey(
+ 'references.Employe',
+ db_column='responsable',
+ related_name='responsable_de',
+ null=True, blank=True
+ )
+ mandat_debut = models.DateField(null=True, blank=True)
+ mandat_fin = models.DateField(null=True, blank=True)
+ date_entree = models.DateField(null=True, blank=True)
+ service = models.ForeignKey('references.Service', db_column='service')
+ poste_type_1 = models.ForeignKey(
+ 'references.PosteType',
+ null=True, blank=True,
+ db_column='poste_type_1',
+ related_name='poste_type_1'
+ )
+ poste_type_2 = models.ForeignKey(
+ 'references.PosteType',
+ null=True, blank=True,
+ db_column='poste_type_2',
+ related_name='poste_type_2'
+ )
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_employe'
+ ordering = ['nom']
+ managed = MANAGED
+ def __unicode__(self):
+ return u"%s, %s [%d]" % (self.nom, self.prenom, self.id)
-class Implantation(managedref.Implantation):
+
+class Authentification(ActifsModel):
+ """Authentification"""
+ id = models.ForeignKey(
+ 'references.Employe', primary_key=True, db_column='id'
+ )
+ courriel = models.CharField(max_length=255, unique=True)
+ motdepasse = models.CharField(max_length=255)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_authentification'
+ ordering = ['id']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return u"%s [%d]" % (self.courriel, self.id)
-class Etablissement(managedref.Etablissement):
+class Service(ActifsModel):
+ """Services (donnée de référence, source: SGRH).
+ """
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_service'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s (%s)" % (self.nom, self.id)
-class Employe(managedref.Employe):
+class PosteType(ActifsModel):
+ """Postes types (donnée de référence, source: SGRH).
+ """
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_poste_type'
+ managed = MANAGED
+ def __unicode__(self):
+ return "%s (%s)" % (self.nom, self.id)
-class Authentification(managedref.Authentification):
+
+class GroupeArh(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_arh'
+ managed = MANAGED
-class Service(managedref.Service):
+class GroupeDirRegion(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_dir_region'
+ managed = MANAGED
-class PosteType(managedref.PosteType):
+class GroupeAdmRegion(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_adm_region'
+ managed = MANAGED
-class GroupeArh(managedref.GroupeArh):
+class GroupeRespImplantation(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ implantation = models.ForeignKey(
+ 'references.Implantation', db_column='implantation'
+ )
+ type = models.CharField(max_length=255, blank=True, null=True)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_resp_implantation'
+ managed = MANAGED
-class GroupeDirRegion(managedref.GroupeDirRegion):
+class GroupeDirProgramme(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ service = models.ForeignKey('references.Service', db_column='service')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_dir_programme'
+ managed = MANAGED
-class GroupeAdmRegion(managedref.GroupeAdmRegion):
+class GroupeDirDelegProgrammeReg(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_dir_deleg_programme_reg'
+ managed = MANAGED
-class GroupeRespImplantation(managedref.GroupeRespImplantation):
+class GroupeComptable(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_comptable'
+ managed = MANAGED
-class GroupeDirProgramme(managedref.GroupeDirProgramme):
+class GroupeComptableRegional(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_comptable_regional'
+ managed = MANAGED
-class GroupeDirDelegProgrammeReg(managedref.GroupeDirDelegProgrammeReg):
+class GroupeComptableLocal(ActifsModel):
+ id = models.AutoField(primary_key=True)
+ employe = models.ForeignKey('references.Employe', db_column='employe')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_groupe_comptable_local'
+ managed = MANAGED
+
+class Discipline(ActifsModel):
+ """ ATTENTION: DÉSUET
+ Discipline (donnée de référence, source: SQI).
+ Une discipline est une catégorie de savoirs scientifiques.
+ Le conseil scientifique fixe la liste des disciplines.
+ """
-class GroupeComptable(managedref.GroupeComptable):
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ nom_long = models.CharField(max_length=255, blank=True)
+ nom_court = models.CharField(max_length=255, blank=True)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_discipline'
+ ordering = ['nom']
+ managed = MANAGED
+ def __unicode__(self):
+ return "%s - %s" % (self.code, self.nom)
-class GroupeComptableRegional(managedref.GroupeComptableRegional):
- class Meta:
- proxy = True
- managed = False
+class Programme(ActifsModel):
+ """ ATTENTION: DÉSUET
+ Programme (donnée de référence, source: SQI).
+ Structure interne par laquelle l'AUF exécute ses projets et activités,
+ dispense ses produits et ses services.
+ """
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ nom_long = models.CharField(max_length=255, blank=True)
+ nom_court = models.CharField(max_length=255, blank=True)
-class GroupeComptableLocal(managedref.GroupeComptableLocal):
+ class Meta:
+ db_table = u'ref_programme'
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s" % (self.code, self.nom)
+
+
+#PROGRAMMATION QUADRIENNALLE
+
+class Projet(ActifsModel):
+ """Projet (donnée de référence, source: programmation-quadriennalle).
+ """
+ SERVICE_CHOICES = (
+ ('1',
+ "Direction de la langue et de la communication scientifique "
+ "en français"),
+ ('2', "Direction du développement et de la valorisation"),
+ ('3',
+ "Direction de l'innovation pédagogique et de l'économie "
+ "de la connaissance"),
+ ('4', "Direction du renforcement des capacités scientifiques"),
+ )
+
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ presentation = models.TextField(null=True, blank=True)
+ partenaires = models.TextField(null=True, blank=True)
+ service = models.CharField(
+ max_length=255, choices=SERVICE_CHOICES, blank=True, null=True
+ )
+ objectif_specifique = models.ForeignKey(
+ 'references.ObjectifSpecifique',
+ blank=True, null=True,
+ db_column='objectif_specifique'
+ )
+ implantation = models.ForeignKey('references.Implantation', null=True,
+ blank=True, db_column='implantation')
+ etablissement = models.ForeignKey('references.Etablissement', null=True,
+ blank=True, db_column='etablissement')
+ date_debut = models.DateField(null=True, blank=True)
+ date_fin = models.DateField(null=True, blank=True)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_projet'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s" % (self.code, self.nom)
-class Discipline(managedref.Discipline):
+class ProjetComposante(ActifsModel):
+ """Composantes des projets (source: programmation-quadriennalle)
+ """
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=10)
+ nom = models.CharField(max_length=255)
+ nom_court = models.CharField(max_length=255, null=True, blank=True)
+ description = models.TextField(null=True, blank=True)
+ projet = models.ForeignKey('references.Projet', db_column='projet')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_projet_composante'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s" % (self.code, self.nom)
-class Programme(managedref.Programme):
+class UniteProjet(ActifsModel):
+ """Unités de projet (source: programmation-quadriennalle)
+ """
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=10, unique=True)
+ nom = models.CharField(max_length=255)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_unite_projet'
+ ordering = ['nom']
+ managed = MANAGED
+ def __unicode__(self):
+ return "%s - %s" % (self.code, self.nom)
-class Projet(managedref.Projet):
+
+class ObjectifSpecifique(ActifsModel):
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
+ objectif_strategique = models.ForeignKey('references.ObjectifStrategique',
+ db_column='objectif_strategique')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_objectif_specifique'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s" % (self.id, self.nom)
-class ProjetComposante(managedref.ProjetComposante):
+class ObjectifStrategique(ActifsModel):
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
+ description = models.TextField(null=True, blank=True)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_objectif_strategique'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s" % (self.id, self.nom)
-class UniteProjet(managedref.UniteProjet):
+class Thematique(ActifsModel):
+ id = models.IntegerField(primary_key=True)
+ nom = models.CharField(max_length=255)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_thematique'
+ ordering = ['nom']
+ managed = MANAGED
+ def __unicode__(self):
+ return "%s - %s" % (self.id, self.nom)
-class ObjectifSpecifique(managedref.ObjectifSpecifique):
+
+class ProjetUp(ActifsModel):
+ """Projet-unité de projet (source: coda)
+ => codes budgétaires
+ """
+ id = models.AutoField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ nom_court = models.CharField(max_length=255, blank=True)
class Meta:
- proxy = True
- managed = False
+ managed = MANAGED
+
+class Poste(ActifsModel):
+ """ ATTENTION: DÉSUET
+ Poste (donnée de référence, source: CODA).
+ Un poste est une catégorie destinée à venir raffiner un projet.
+ """
-class ObjectifStrategique(managedref.ObjectifStrategique):
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ type = models.CharField(max_length=255, blank=True)
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_poste'
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s - %s (%s)" % (self.code, self.nom, self.type)
+
+
+class ProjetPoste(ActifsModel):
+ """
+ ATTENTION: DÉSUET
+ Projet-poste (donnée de référence, source: CODA).
+ Un projet-poste consiste en une raffinement d'un projet par un poste
+ (budgétaire). Subdivision utile pour le suivi budgétaire et comptable.
+ """
+
+ id = models.IntegerField(primary_key=True)
+ code = models.CharField(max_length=255, unique=True)
+ code_projet = models.ForeignKey(
+ 'references.Projet', to_field='code', db_column='code_projet'
+ )
+ code_poste = models.ForeignKey(
+ 'references.Poste', to_field='code', db_column='code_poste'
+ )
+ code_bureau = models.ForeignKey(
+ 'references.Bureau', to_field='code', db_column='code_bureau'
+ )
+ code_programme = models.ForeignKey(
+ 'references.Programme', to_field='code', db_column='code_programme'
+ )
+ class Meta:
+ db_table = u'ref_projet_poste'
+ managed = MANAGED
-class Thematique(managedref.Thematique):
+ def __unicode__(self):
+ return "%s" % (self.code)
- class Meta:
- proxy = True
- managed = False
+class Region(ActifsModel):
+ """Région (donnée de référence, source: referentiels_spip).
+ Une région est une subdivision géographique du monde pour la gestion de
+ l'AUF.
+ """
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255, db_index=True)
+ implantation_bureau = models.ForeignKey(
+ 'references.Implantation', db_column='implantation_bureau',
+ related_name='gere_region', null=True, blank=True
+ )
-class ProjetUp(managedref.ProjetUp):
+ class Meta:
+ db_table = u'ref_region'
+ ordering = ['nom']
+ verbose_name = u"région"
+ verbose_name_plural = u"régions"
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s (%s)" % (self.nom, self.code)
+
+
+class Bureau(ActifsModel):
+ """
+ Bureau (donnée de référence, source: SQI).
+
+ Référence legacy entre la notion de région et celle d'implantation
+ responsable des régions et du central.
+
+ Un bureau est :
+ - soit le bureau régional d'une région (implantations de type 'Bureau')
+ - soit la notion unique de Service central pour les 2 implantations
+ centrales (implantations de type 'Service central' et 'Siege').
+
+ Ne pas confondre avec les seuls 'bureaux régionaux'.
+ """
+ code = models.CharField(max_length=255, unique=True)
+ nom = models.CharField(max_length=255)
+ nom_court = models.CharField(max_length=255, blank=True)
+ nom_long = models.CharField(max_length=255, blank=True)
+ implantation = models.ForeignKey(
+ 'references.Implantation', db_column='implantation'
+ )
+ region = models.ForeignKey('references.Region', db_column='region')
class Meta:
- proxy = True
- managed = False
+ db_table = u'ref_bureau'
+ ordering = ['nom']
+ verbose_name = u"bureau"
+ verbose_name_plural = u"bureaux"
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s (%s)" % (self.nom, self.code)
+
+
+class Implantation(ActifsModel):
+ """
+ Implantation (donnée de référence, source: Implantus)
+
+ Une implantation est un endroit où l'AUF est présente et offre des
+ services spécifiques. Deux implantations peuvent être au même endroit
+ physique.
+ """
+ STATUT_CHOICES = (
+ (0, u'Fermée ou jamais ouverte'),
+ (1, u'Ouverte'),
+ (2, u'Ouverture imminente'),
+ (3, u'En projet')
+ )
+
+ nom = models.CharField(max_length=255)
+ nom_court = models.CharField(max_length=255, blank=True)
+ nom_long = models.CharField(max_length=255, blank=True)
+ type = models.CharField(max_length=255)
+ bureau_rattachement = models.ForeignKey(
+ 'references.Implantation', db_column='bureau_rattachement'
+ )
+ region = models.ForeignKey('references.Region', db_column='region')
+ fuseau_horaire = models.CharField(max_length=255, blank=True)
+ code_meteo = models.CharField(max_length=255, blank=True)
+ # responsable
+ responsable_implantation = models.IntegerField(null=True, blank=True)
+ # adresse postale
+ adresse_postale_precision_avant = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_no = models.CharField(max_length=30, blank=True, null=True)
+ adresse_postale_rue = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_bureau = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_precision = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_boite_postale = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_ville = models.CharField(max_length=255)
+ adresse_postale_code_postal = models.CharField(
+ max_length=20, blank=True, null=True
+ )
+ adresse_postale_code_postal_avant_ville = models.NullBooleanField()
+ adresse_postale_region = models.CharField(
+ max_length=255, blank=True, null=True
+ )
+ adresse_postale_pays = models.ForeignKey(
+ 'references.Pays', to_field='code',
+ db_column='adresse_postale_pays',
+ related_name='impl_adresse_postale'
+ )
+ # adresse physique
+ adresse_physique_precision_avant = models.CharField(
+ max_length=255, blank=True
+ )
+ adresse_physique_no = models.CharField(max_length=30, blank=True)
+ adresse_physique_rue = models.CharField(max_length=255, blank=True)
+ adresse_physique_bureau = models.CharField(max_length=255, blank=True)
+ adresse_physique_precision = models.CharField(max_length=255, blank=True)
+ adresse_physique_ville = models.CharField(max_length=255)
+ adresse_physique_code_postal = models.CharField(max_length=30, blank=True)
+ adresse_physique_code_postal_avant_ville = models.NullBooleanField()
+ adresse_physique_region = models.CharField(max_length=255, blank=True)
+ adresse_physique_pays = models.ForeignKey(
+ 'references.Pays', to_field='code',
+ db_column='adresse_physique_pays',
+ related_name='impl_adresse_physique'
+ )
+ # autres coordonnées
+ telephone = models.CharField(max_length=255, blank=True)
+ telephone_interne = models.CharField(max_length=255, blank=True)
+ fax = models.CharField(max_length=255, blank=True)
+ fax_interne = models.CharField(max_length=255, blank=True)
+ courriel = models.EmailField(blank=True)
+ courriel_interne = models.EmailField(blank=True)
+ url = models.URLField(verify_exists=False, max_length=255, blank=True)
+ # traitement
+ statut = models.IntegerField(choices=STATUT_CHOICES)
+ date_ouverture = models.DateField(null=True, blank=True)
+ date_inauguration = models.DateField(null=True, blank=True)
+ date_extension = models.DateField(null=True, blank=True)
+ date_fermeture = models.DateField(null=True, blank=True)
+ hebergement_etablissement = models.CharField(max_length=255, blank=True)
+ hebergement_convention = models.NullBooleanField()
+ hebergement_convention_date = models.DateField(null=True, blank=True)
+ remarque = models.TextField()
+ commentaire = models.CharField(max_length=255, blank=True)
+ # meta
+ modif_date = models.DateField()
+
+ class Managers:
+
+ class Ouvertes(ActifsManager):
+
+ def get_query_set(self):
+ return super(Implantation.Managers.Ouvertes, self) \
+ .get_query_set() \
+ .filter(statut=1)
+
+ objects = ActifsManager()
+ ouvertes = Managers.Ouvertes()
+ class Meta:
+ db_table = u'ref_implantation'
+ ordering = ['nom']
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s (%d)" % (self.nom, self.id)
+
+
+class Pays(ActifsModel):
+ """
+ Pays (donnée de référence, source: SQI).
+
+ Liste AUF basée sur la liste ISO-3166-1.
+ """
+ code = models.CharField(max_length=2, unique=True)
+ code_iso3 = models.CharField(max_length=3, unique=True)
+ nom = models.CharField(max_length=255)
+ region = models.ForeignKey('references.Region', db_column='region')
+ code_bureau = models.ForeignKey('references.Bureau', to_field='code',
+ db_column='code_bureau', blank=True,
+ null=True)
+ nord_sud = models.CharField(max_length=255, blank=True, null=True)
+ developpement = models.CharField(max_length=255, blank=True, null=True)
+ monnaie = models.CharField(max_length=255, blank=True, null=True)
-class Poste(managedref.Poste):
+ class Meta:
+ db_table = u'ref_pays'
+ ordering = ['nom']
+ verbose_name = u"pays"
+ verbose_name_plural = u"pays"
+ managed = MANAGED
+
+ def __unicode__(self):
+ return "%s (%s)" % (self.nom, self.code)
+
+
+class _Etablissement(ActifsModel):
+ """
+ Superclasse pour les modèles ``Etablissement`` et ``EtablissementBase``
+ """
+ MEMBRE_STATUT_CHOICES = (
+ ('T', 'Titulaire'),
+ ('A', 'Associé'),
+ ('C', 'Candidat'),
+ )
+ QUALITE_CHOICES = (
+ ('ESR', "Établissement d'enseignement supérieur et de recherche"),
+ ('CIR', "Centre ou institution de recherche"),
+ ('RES', "Réseau"),
+ )
+
+ # Infos de base
+ nom = models.CharField(max_length=255)
+ pays = models.ForeignKey(
+ 'references.Pays', to_field='code', db_column='pays',
+ related_name='+'
+ )
+ region = models.ForeignKey(
+ 'references.Region', db_column='region', blank=True, null=True,
+ related_name='+', verbose_name='région'
+ )
+ implantation = models.ForeignKey(
+ 'references.Implantation', db_column='implantation',
+ related_name='+', blank=True, null=True
+ )
+ description = models.TextField(blank=True)
+ historique = models.TextField(blank=True)
+
+ # Membership
+ membre = models.BooleanField()
+ membre_adhesion_date = models.DateField(null=True, blank=True,
+ verbose_name="date d'adhésion")
+ statut = models.CharField(max_length=1, choices=MEMBRE_STATUT_CHOICES,
+ blank=True, null=True)
+ qualite = models.CharField(max_length=3, choices=QUALITE_CHOICES,
+ verbose_name="qualité", blank=True,
+ null=True)
+
+ # Responsable
+ responsable_genre = models.CharField(
+ max_length=1, blank=True, verbose_name='genre'
+ )
+ responsable_nom = models.CharField(
+ max_length=255, blank=True, verbose_name='nom'
+ )
+ responsable_prenom = models.CharField(
+ max_length=255, blank=True, verbose_name='prénom'
+ )
+ responsable_fonction = models.CharField(
+ max_length=255, blank=True, verbose_name='fonction'
+ )
+
+ # Adresse
+ adresse = models.CharField(max_length=255, blank=True)
+ code_postal = models.CharField(max_length=20, blank=True,
+ verbose_name='code postal')
+ cedex = models.CharField(max_length=20, blank=True, verbose_name='CEDEX')
+ ville = models.CharField(max_length=255, blank=True)
+ province = models.CharField(max_length=255, blank=True)
+ telephone = models.CharField(max_length=255, blank=True,
+ verbose_name='téléphone')
+ fax = models.CharField(max_length=255, blank=True)
+ url = models.URLField(verify_exists=False, max_length=255, null=True,
+ blank=True, verbose_name='URL')
+
+ # Meta-données
+ date_modification = models.DateField(verbose_name='date de modification',
+ blank=True, null=True)
+ commentaire = models.TextField(blank=True)
class Meta:
- proxy = True
- managed = False
+ abstract = True
+ ordering = ['pays__nom', 'nom']
+ managed = MANAGED
+ def __unicode__(self):
+ return "%s - %s" % (self.pays.nom, self.nom)
-class ProjetPoste(managedref.ProjetPoste):
- class Meta:
- proxy = True
- managed = False
+class Etablissement(_Etablissement):
+ """
+ Établissement (donnée de référence, source: GDE).
+ Un établissement peut être une université, un centre de recherche, un
+ réseau d'établissement... Un établissement peut être membre de l'AUF ou
+ non.
+ """
+ class Meta(_Etablissement.Meta):
+ db_table = u'ref_etablissement'
+ managed = MANAGED
-### Modèles abstraits
-class EtablissementBase(managedref.EtablissementBase):
+class EtablissementBase(_Etablissement):
+ """
+ Modèle de base pour créer des établissements locaux pouvant être
+ liés à des établissements des données de référence.
+ """
ref = models.OneToOneField(Etablissement, blank=True, null=True,
related_name='%(app_label)s_%(class)s')
auf.recipe.django
pysqlite
pyyaml
- south
[django]
recipe = auf.recipe.django
from setuptools import setup, find_packages
name = 'auf.django.references'
-version = '0.13'
+version = '0.14'
setup(
name=name,
'django.contrib.sessions',
'django.contrib.admin',
'django.contrib.staticfiles',
- 'south',
'auf.django.references',
- 'auf.django.references.managedref',
'tests.universite',
'tests.simpletests',
)
STATIC_URL = '/static/'
TEMPLATE_DIRS = (os.path.join(os.path.dirname(__file__), 'templates'),)
+
+SECRET_KEY = 'not-secret'
+
+AUF_REFERENCES_MANAGED = True
-- model: managedref.region
+- model: references.region
pk: 1
fields:
code: A
nom: Amériques
-- model: managedref.region
+- model: references.region
pk: 2
fields:
code: EO
nom: "Europe de l'Ouest"
-- model: managedref.pays
+- model: references.pays
pk: 1
fields:
code: CA
code_iso3: CAN
nom: Canada
region: 1
-- model: managedref.pays
+- model: references.pays
pk: 2
fields:
code: FR
code_iso3: FRA
nom: France
region: 2
-- model: managedref.etablissement
+- model: references.etablissement
pk: 1
fields:
nom: "Université de Montréal"