/[openfoncier]/trunk/data/pgsql/v3.2.0-dev.sql
ViewVC logotype

Log of /trunk/data/pgsql/v3.2.0-dev.sql

Parent Directory Parent Directory | Revision Log Revision Log

Sticky Revision:
(Current path doesn't exist after revision 3727)
Revision 738 - (view) (annotate) - [select for diffs]
Modified Mon Nov 19 08:20:45 2012 UTC (12 years, 2 months ago) by mlimic
File length: 37631 byte(s)
Diff to previous 737 
Suppression d'un droit qui est reste pour la table messages qui n'existe plus dans la BD
Revision 737 - (view) (annotate) - [select for diffs]
Modified Mon Nov 19 08:19:29 2012 UTC (12 years, 2 months ago) by mlimic
File length: 37725 byte(s)
Diff to previous 730 
Changement des droits pour la table messages, qui est remplace par la table dossier_message, par des droits pour la table dossier_message
Revision 730 - (view) (annotate) - [select for diffs]
Modified Fri Nov 16 17:25:05 2012 UTC (12 years, 2 months ago) by nhaye
File length: 37704 byte(s)
Diff to previous 725 
Correction d'une erreur de bdd sur le champ dossier_autorisation_type_detaille de la table dossier_autorisation
Revision 725 - (view) (annotate) - [select for diffs]
Modified Fri Nov 16 15:43:07 2012 UTC (12 years, 2 months ago) by nhaye
File length: 37680 byte(s)
Diff to previous 723 
Ajout du champ "a_qualifier" dans la table dossier + régénération
Revision 723 - (view) (annotate) - [select for diffs]
Modified Fri Nov 16 15:04:37 2012 UTC (12 years, 2 months ago) by nhaye
File length: 37589 byte(s)
Diff to previous 721 
Correction d'une erreur de base de données ainsi que de l'objet sur lequel pointe le lien du menu.
Revision 721 - (view) (annotate) - [select for diffs]
Modified Fri Nov 16 14:45:49 2012 UTC (12 years, 2 months ago) by nhaye
File length: 37568 byte(s)
Diff to previous 710 
Modification du menu : changement de l'objet sur lequel on fait la recherche.
Ajout de champs dans la table dossier_autorisation, liaisons avec d'autre table.
Création d'une table de liaison entre la table demandeur et dossier_autorisation.
Régénération
Revision 710 - (view) (annotate) - [select for diffs]
Modified Thu Nov 15 18:06:01 2012 UTC (12 years, 2 months ago) by mlimic
File length: 35866 byte(s)
Diff to previous 703 
Saving the sql statements used to store create the dossier_message table.
Revision 703 - (view) (annotate) - [select for diffs]
Modified Thu Nov 15 16:14:33 2012 UTC (12 years, 2 months ago) by vpihour
File length: 35845 byte(s)
Diff to previous 697 
Ajout d'un champ à la table lien_demande_demandeur pour le pétitionnaire principal
Revision 697 - (view) (annotate) - [select for diffs]
Modified Thu Nov 15 11:39:32 2012 UTC (12 years, 2 months ago) by mlimic
File length: 35811 byte(s)
Diff to previous 694 
Increased the number of chars that can be stored in the field om_parametre.libelle. Previously 20, now 40.
Revision 694 - (view) (annotate) - [select for diffs]
Modified Thu Nov 15 09:36:32 2012 UTC (12 years, 2 months ago) by vpihour
File length: 34679 byte(s)
Diff to previous 693 
Ajout des libelles aux civilités
Revision 693 - (view) (annotate) - [select for diffs]
Modified Thu Nov 15 09:03:18 2012 UTC (12 years, 2 months ago) by vpihour
File length: 34429 byte(s)
Diff to previous 690 
Modification de la table civilite et correction du formulaire de demande
Revision 690 - (view) (annotate) - [select for diffs]
Modified Wed Nov 14 15:34:07 2012 UTC (12 years, 2 months ago) by vpihour
File length: 30883 byte(s)
Diff to previous 689 
Ajout d'une nouvelle table et modification d'une autre
Revision 689 - (view) (annotate) - [select for diffs]
Modified Wed Nov 14 13:51:46 2012 UTC (12 years, 2 months ago) by vpihour
File length: 30303 byte(s)
Diff to previous 688 
Modification d'une table
Revision 688 - (view) (annotate) - [select for diffs]
Modified Wed Nov 14 13:31:14 2012 UTC (12 years, 2 months ago) by vpihour
File length: 30291 byte(s)
Diff to previous 681 
Ajout d'une nouvelle table et modification d'une autre
Revision 681 - (view) (annotate) - [select for diffs]
Modified Wed Nov 14 07:09:49 2012 UTC (12 years, 2 months ago) by fmichon
File length: 29073 byte(s)
Diff to previous 668 
Ajout de la colonne division dans la table dossier
Revision 668 - (view) (annotate) - [select for diffs]
Modified Mon Nov 12 14:42:40 2012 UTC (12 years, 2 months ago) by fmichon
File length: 29002 byte(s)
Diff to previous 656 
Renommage des deux paramètres concernant l'accès externe des services consultés
Revision 656 - (view) (annotate) - [select for diffs]
Modified Sun Nov 11 22:14:37 2012 UTC (12 years, 2 months ago) by fmichon
File length: 28968 byte(s)
Diff to previous 633 
Nouvelle gestion du tableau de bord.
Revision 633 - (view) (annotate) - [select for diffs]
Modified Thu Nov 8 14:06:31 2012 UTC (12 years, 2 months ago) by vpihour
File length: 28275 byte(s)
Diff to previous 632 
Ajout de trois nouvelles tables
Revision 632 - (view) (annotate) - [select for diffs]
Modified Thu Nov 8 13:04:27 2012 UTC (12 years, 2 months ago) by vpihour
File length: 25387 byte(s)
Diff to previous 623 
Ajout de la table demande
Revision 623 - (view) (annotate) - [select for diffs]
Modified Wed Nov 7 15:09:10 2012 UTC (12 years, 2 months ago) by vpihour
File length: 24264 byte(s)
Diff to previous 622 
Données
Revision 622 - (view) (annotate) - [select for diffs]
Modified Wed Nov 7 14:41:45 2012 UTC (12 years, 2 months ago) by vpihour
File length: 24040 byte(s)
Diff to previous 617 
Données concernant les arrondissements et les quartiers de Marseille
Revision 617 - (view) (annotate) - [select for diffs]
Modified Wed Nov 7 12:09:13 2012 UTC (12 years, 2 months ago) by vpihour
File length: 24040 byte(s)
Diff to previous 608 
Ajout de neuf nouvelles tables pour la gestion des demandes
Revision 608 - (view) (annotate) - [select for diffs]
Modified Tue Nov 6 11:02:46 2012 UTC (12 years, 3 months ago) by mlimic
File length: 16333 byte(s)
Diff to previous 605 
table dossier now containts two boolean fields, enjeu_erp and enjeu_urba, instead of one boolean field enjeu
Revision 605 - (view) (annotate) - [select for diffs]
Modified Tue Nov 6 09:36:32 2012 UTC (12 years, 3 months ago) by nhaye
File length: 16351 byte(s)
Diff to previous 603 
Augmentation du nombre de caractères du champs chef de la table direction
Revision 603 - (view) (annotate) - [select for diffs]
Modified Mon Nov 5 18:28:00 2012 UTC (12 years, 3 months ago) by nhaye
File length: 16350 byte(s)
Diff to previous 599 
Ajout des colonnes manquante dans les tables division, direction et instructeur,
agrandissement de libellés à 100 caractères.
Revision 599 - (view) (annotate) - [select for diffs]
Modified Mon Nov 5 16:19:12 2012 UTC (12 years, 3 months ago) by mlimic
File length: 16173 byte(s)
Diff to previous 593 
save
Revision 593 - (view) (annotate) - [select for diffs]
Modified Mon Nov 5 11:38:40 2012 UTC (12 years, 3 months ago) by vpihour
File length: 16113 byte(s)
Diff to previous 586 
Ajout d'un nouveau droit
Revision 586 - (view) (annotate) - [select for diffs]
Modified Fri Nov 2 17:27:11 2012 UTC (12 years, 3 months ago) by mlimic
File length: 15977 byte(s)
Diff to previous 583 
creation of messages table, add of messages tab for the dossier currently opened; bug: some fields are set or reinitalized when the modification to 'lu' is made
Revision 583 - (view) (annotate) - [select for diffs]
Modified Fri Nov 2 16:02:12 2012 UTC (12 years, 3 months ago) by nhaye
File length: 15957 byte(s)
Diff to previous 581 
Ajout de la rubrique "Suivi" au menu, "Retour de consultation" va dans cette rubrique
Revision 581 - (view) (annotate) - [select for diffs]
Modified Fri Nov 2 14:29:10 2012 UTC (12 years, 3 months ago) by mlimic
File length: 15883 byte(s)
Diff to previous 577 
ajout de la table message
Revision 577 - (view) (annotate) - [select for diffs]
Modified Fri Nov 2 10:10:56 2012 UTC (12 years, 3 months ago) by mlimic
File length: 15297 byte(s)
Diff to previous 575 
remove double insert into om_profile from v3.2.0-dev.sql, deleted the constructor from the utils.class.php since now it is the same as that of the om_application.php due to the fact that the login in the MetierManager is now set to 'admin'; moved th function that checks that a date is inside of an inteval into MetierManager
Revision 575 - (view) (annotate) - [select for diffs]
Modified Wed Oct 31 17:04:12 2012 UTC (12 years, 3 months ago) by vpihour
File length: 15376 byte(s)
Diff to previous 571 
Correction de bugs, modification de la base de données
Revision 571 - (view) (annotate) - [select for diffs]
Modified Wed Oct 31 15:16:42 2012 UTC (12 years, 3 months ago) by nhaye
File length: 15156 byte(s)
Diff to previous 563 
Modification du code suite à la modification des nom de fichiers précédement commités.
Revision 563 - (view) (annotate) - [select for diffs]
Modified Wed Oct 31 10:25:25 2012 UTC (12 years, 3 months ago) by vpihour
File length: 15146 byte(s)
Diff to previous 561 
Personnalisation du formulaire d'ajout et du tableau lien entre un instructeur, le type de dossier et la localisation
Revision 561 - (view) (annotate) - [select for diffs]
Modified Wed Oct 31 09:57:15 2012 UTC (12 years, 3 months ago) by nhaye
File length: 14949 byte(s)
Diff to previous 560 
Ajout d'un droit de modification du champs lu,
ce champ est automatiquement mis à false lorsqu'un avis est rendu ou modifié
Revision 560 - (view) (annotate) - [select for diffs]
Modified Tue Oct 30 17:41:31 2012 UTC (12 years, 3 months ago) by mlimic
File length: 14790 byte(s)
Diff to previous 558 
addition of temporary table avis_consultation_tmp that is used to populate table avis_consultation
Revision 558 - (view) (annotate) - [select for diffs]
Modified Tue Oct 30 16:55:55 2012 UTC (12 years, 3 months ago) by vpihour
File length: 13956 byte(s)
Diff to previous 555 
Modification du formulaire d'ajout de paramètrage fonctionnel - affectation
Revision 555 - (view) (annotate) - [select for diffs]
Modified Tue Oct 30 14:05:14 2012 UTC (12 years, 3 months ago) by vpihour
File length: 13688 byte(s)
Diff to previous 554 
Ajout de nouvelles tables
Correction de bug
Revision 554 - (view) (annotate) - [select for diffs]
Modified Tue Oct 30 11:34:29 2012 UTC (12 years, 3 months ago) by nhaye
File length: 12254 byte(s)
Diff to previous 549 
Ajout de l'objet correspondant à l'historique des avis rendus par les services.
Ajout de l'entrée de menu et des droits d'accès à cet objet.
Revision 549 - (view) (annotate) - [select for diffs]
Modified Tue Oct 30 09:42:33 2012 UTC (12 years, 3 months ago) by nhaye
File length: 12128 byte(s)
Diff to previous 546 
Ajout du droit pour le ratachement d'un utilisateur à un service et d'un service à un utilisateur
Revision 546 - (view) (annotate) - [select for diffs]
Modified Mon Oct 29 16:41:09 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11985 byte(s)
Diff to previous 545 
Correction des requètes precedement commitées
Revision 545 - (view) (annotate) - [select for diffs]
Modified Mon Oct 29 16:35:10 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11980 byte(s)
Diff to previous 544 
Suppression des colonnes inutiles de la table om_utilisateur suite à la migration vers la table instructeur
Revision 544 - (view) (annotate) - [select for diffs]
Modified Mon Oct 29 16:25:36 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11830 byte(s)
Diff to previous 538 
Création d'une classe "abstraite" virtual_dbform.class.php
création de la classe demande_encours (accessible aux services),
création de la classe consultation_retour_service (permettant un retour d'avis des services),
ajout d'une méthode d'affichage de dialog box (jquery-ui dialog), fonctionne de la même façon que ajaxIt,
correction des entrées de menu,
ajout des droits necessaires.
Revision 538 - (view) (annotate) - [select for diffs]
Modified Fri Oct 26 09:53:58 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11613 byte(s)
Diff to previous 532 
Correction de la gestion d'erreur des retours de consultation, amélioration du menu et ajout du droits pour accéder aux retours de consultation.
Revision 532 - (view) (annotate) - [select for diffs]
Modified Tue Oct 23 10:43:49 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11535 byte(s)
Diff to previous 520 
Modification de la méthode d'envoi de mail.
Agrandissement du champ valeur de la table om_parametre + régénération
Envoi de notification lors de l'ajout de consultation
Revision 520 - (view) (annotate) - [select for diffs]
Modified Thu Oct 18 15:05:59 2012 UTC (12 years, 3 months ago) by nhaye
File length: 11207 byte(s)
Diff to previous 519 
Modification de clé étrangère de dossier->om_utilisateur pour dossier->instructeur
Régénération
Ajout de la division sur le formulaire dossier
Revision 519 - (view) (annotate) - [select for diffs]
Modified Thu Oct 18 13:22:10 2012 UTC (12 years, 3 months ago) by nhaye
File length: 10928 byte(s)
Diff to previous 517 
Ajout des entrées de menu pour les table d'organisation,
ajout des droits correspondant à ces tables,
ajout de commentaires dans le script de maj.
Revision 517 - (view) (annotate) - [select for diffs]
Modified Thu Oct 18 09:35:21 2012 UTC (12 years, 3 months ago) by nhaye
File length: 10409 byte(s)
Diff to previous 514 
Ajout du parametre d'affichage de la division dans les dossiers
Modification des requètes (pour l'instant commentées : tester sur table instructeur)
Revision 514 - (view) (annotate) - [select for diffs]
Modified Wed Oct 17 16:12:46 2012 UTC (12 years, 3 months ago) by nhaye
File length: 10304 byte(s)
Diff to previous 510 
Ajout des tables instructeur, division, direction,
régénération
Revision 510 - (view) (annotate) - [select for diffs]
Modified Wed Oct 17 11:02:35 2012 UTC (12 years, 3 months ago) by vpihour
File length: 8549 byte(s)
Diff to previous 509 
Mise à jour de la table service et du formulaire
Suppression des fichiers inutiles
Modification des etats pdf dans init.sql
Mise à jour des scripts concernant l'ancienne table avis
Revision 509 - (view) (annotate) - [select for diffs]
Modified Tue Oct 16 16:50:50 2012 UTC (12 years, 3 months ago) by nhaye
File length: 8511 byte(s)
Diff to previous 506 
Ajout de deux entrées de menu,
création des objets correspondants,
ajout de surcharge de tableau, recherche avancée/simple, tri
Ajout d'un champ booleen "enjeu" dans la table dossier,
régénération,
mise en gras des consultations non lues
Mise en forme du formulaire de consultation
Amélioration, nétoyage de méthodes obsolètes
Revision 506 - (view) (annotate) - [select for diffs]
Modified Tue Oct 16 13:52:24 2012 UTC (12 years, 3 months ago) by nhaye
File length: 8372 byte(s)
Diff to previous 502 
Ajout du champs "service" obligatoire
Revision 502 - (view) (annotate) - [select for diffs]
Modified Mon Oct 15 16:22:36 2012 UTC (12 years, 3 months ago) by vpihour
File length: 8318 byte(s)
Diff to previous 501 
Ajout du type de consulation dans les services
Revision 501 - (view) (annotate) - [select for diffs]
Modified Mon Oct 15 09:04:04 2012 UTC (12 years, 3 months ago) by vpihour
File length: 8377 byte(s)
Diff to previous 500 
Modification de tables
Revision 500 - (view) (annotate) - [select for diffs]
Modified Mon Oct 15 08:34:00 2012 UTC (12 years, 3 months ago) by vpihour
File length: 9099 byte(s)
Diff to previous 498 
Ajout de deux champs dans la table service, création d'une nouvelle table et génération des fichiers PHP
Revision 498 - (view) (annotate) - [select for diffs]
Modified Fri Oct 12 16:01:09 2012 UTC (12 years, 3 months ago) by nhaye
File length: 8255 byte(s)
Diff to previous 497 
Ajout d'entrées de menus,
ajout de l'objet consultation en cours,
ajout d'un widget
Revision 497 - (view) (annotate) - [select for diffs]
Modified Fri Oct 12 15:35:11 2012 UTC (12 years, 3 months ago) by vpihour
File length: 7649 byte(s)
Diff to previous 492 
Ajout des modifications pour les consultations
Revision 492 - (view) (annotate) - [select for diffs]
Modified Thu Oct 11 14:13:41 2012 UTC (12 years, 3 months ago) by vpihour
File length: 7294 byte(s)
Diff to previous 489 
Ajout des fichiers générés manquants
Revision 489 - (view) (annotate) - [select for diffs]
Modified Thu Oct 11 08:27:21 2012 UTC (12 years, 3 months ago) by vpihour
File length: 7354 byte(s)
Diff to previous 487 
Modification du fichier v3.2.0-dev.sql
Nouveaux fichiers generes suite a la modification de la base de donnees et correction des personnalisations
Revision 487 - (view) (annotate) - [select for diffs]
Modified Wed Oct 10 09:42:40 2012 UTC (12 years, 3 months ago) by vpihour
File length: 7237 byte(s)
Diff to previous 486 
Modification du fichier v3.2.0-dev.sql
Revision 486 - (view) (annotate) - [select for diffs]
Added Tue Oct 9 16:15:50 2012 UTC (12 years, 3 months ago) by vpihour
File length: 5324 byte(s) 
Ajout du nouveau fichier de migration SQL pour la version 3.2.0

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26