Skip to content
Snippets Groups Projects
Select Git revision
  • 324f28f7fc639bc28b7afb4e66985bcfc47606c9
  • master default protected
  • 5.x
  • ll-php8-bs5
  • release_5_bs5
  • ll-php8
  • 4.x
  • laminas_migration
  • release_1.0.0.2
  • release_4.0.0
  • release_3.2.8
  • bootstrap4_migration
  • 1.0.0.3
  • 6.0.7
  • 6.0.6
  • 6.0.5
  • 6.0.4
  • 6.0.3
  • 6.0.2
  • 6.0.1
  • 5.1.1
  • 6.0.0
  • 5.1.0
  • 5.0.0
  • 4.0.2
  • 3.2.11
  • 4.0.1
  • 3.2.10
  • 4.0.0
  • 1.0.0.2
  • 3.2.9
  • 3.2.8
32 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);