Skip to content
Snippets Groups Projects
Select Git revision
  • 5092926d97c34f4da2f1e1fb5a6af51e214f4d0c
  • master default protected
  • cleanup_fixtures
  • add-openvox
  • freebsd-14
  • remove-legacy-top-scope-syntax
  • rel430
  • tests
  • revert-363-augeas-module-cleanup
  • release-4.1.0
  • puppet8
  • relax-dependencies
  • rel400
  • mode
  • puppet7
  • release-3.1.0
  • freebsd13
  • freebsd11
  • stdlib
  • centos
  • fedora
  • v5.1.0
  • v5.0.0
  • v4.5.0
  • v4.4.0
  • v4.3.0
  • v4.2.1
  • v4.2.0
  • v4.1.0
  • v4.0.0
  • v3.1.0
  • v3.0.0
  • v2.0.0
  • 1.12.0
  • 1.11.0
  • 1.10.0
  • 1.9.0
  • 1.8.0
  • 1.7.0
  • 1.6.0
  • 1.5.0
41 results

files.pp

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    001_tables.sql 1.49 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,
        namespace varchar(1024),
        engine varchar(64) default 'default' not null,
        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);