Skip to content
Snippets Groups Projects
Select Git revision
  • 4cbbeba79f1ea09a54028fa4705fd40fa066ed2d
  • master default
  • php8.2-docker-services
  • 6.x
  • laminas
  • bertrand.gauthier-master-patch-70311
  • bertrand.gauthier-master-patch-87168
  • laminas_migration
  • sqlite
  • 4.0.0
  • 3.2.1
  • 3.2.0
  • 3.1.0
  • 3.0.0
  • 1.0.1
  • 1.0.0
16 results

Module.php

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    001_tables.sql 1.41 KiB
    -- TABLE DES MACROS
    
    create table unicaen_renderer_macro
    (
        id serial not null constraint unicaen_document_macro_pk primary key,
        code varchar(256) not null,
        description text,
        variable_name varchar(256) not null,
        methode_name varchar(256) not null
    );
    create unique index unicaen_document_macro_code_uindex on unicaen_renderer_macro (code);
    create unique index unicaen_document_macro_id_uindex on unicaen_renderer_macro (id);
    
    -- TABLE DES TEMPLATES
    
    create table unicaen_renderer_template
    (
        id serial not null constraint unicaen_document_template_pk primary key,
        code varchar(256) not null,
        description text,
        document_type varchar(256) not null,
        document_sujet text not null,
        document_corps text not null,
        document_css text
    );
    create unique index unicaen_document_template_code_uindex on unicaen_renderer_template (code);
    create unique index unicaen_document_template_id_uindex on unicaen_renderer_template (id);
    
    -- TABLE DES RENDU
    create table unicaen_renderer_rendu
    (
        id serial not null constraint unicaen_document_rendu_pk primary key,
        template_id int default null
            constraint unicaen_document_rendu_template_id_fk
                references unicaen_renderer_template
                on delete set null,
        date_generation timestamp not null,
        sujet text not null,
        corps text not null
    );
    create unique index unicaen_document_rendu_id_uindex on unicaen_renderer_template (id);