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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 580 by mlimic, Fri Nov 2 10:10:56 2012 UTC revision 581 by mlimic, Fri Nov 2 14:29:10 2012 UTC
# Line 410  INSERT INTO om_droit VALUES (nextval('om Line 410  INSERT INTO om_droit VALUES (nextval('om
410  ALTER TABLE parcelle ALTER COLUMN parcelle TYPE character varying(20);  ALTER TABLE parcelle ALTER COLUMN parcelle TYPE character varying(20);
411  ALTER TABLE terrain ALTER COLUMN parcelle TYPE character varying(20);  ALTER TABLE terrain ALTER COLUMN parcelle TYPE character varying(20);
412    
413    
414    --
415    -- Messages
416    --
417    
418    -- create sequence for the message ID generation
419    CREATE SEQUENCE message_seq
420        START WITH 1
421        INCREMENT BY 1
422        NO MINVALUE
423        NO MAXVALUE
424        CACHE 1;
425    
426    -- Create table messages
427    CREATE TABLE message (
428        message integer PRIMARY KEY DEFAULT nextval('message_seq'),
429        dossier character varying(12),
430        type character varying(60),
431        emetteur character varying(40),
432        date_envoi DATE NOT NULL,
433        enjeux_erp boolean default FALSE,
434        enjeux_urba boolean default FALSE,
435        lu boolean default FALSE
436    );
437    ALTER SEQUENCE message_seq OWNED BY message.message;
Legend:
Removed from v.580  
changed lines
  Added in v.581
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26