Changeset 318c2da in osmose-frontend


Ignore:
Timestamp:
Feb 16, 2014 7:25:29 PM (6 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Branches:
master
Children:
034ae3f
Parents:
7ce14d2
git-author:
Jocelyn Jaubert <jocelyn.jaubert@…> (01/12/2013 21:51:24)
git-committer:
Jocelyn Jaubert <jocelyn.jaubert@…> (16/02/2014 19:25:29)
Message:

Add id column to table dynpoi_status

Location:
tools
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed
  • tools/database/schema.sql

    rd0e5d85 r318c2da  
    9999 
    100100-- 
     101-- Name: dynpoi_status_id_seq; Type: SEQUENCE; Schema: public; Owner: - 
     102-- 
     103 
     104CREATE SEQUENCE dynpoi_status_id_seq 
     105    START WITH 1 
     106    INCREMENT BY 1 
     107    NO MINVALUE 
     108    NO MAXVALUE 
     109    CACHE 1; 
     110 
     111 
     112-- 
     113-- Name: dynpoi_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - 
     114-- 
     115 
     116ALTER SEQUENCE dynpoi_status_id_seq OWNED BY dynpoi_status.id; 
     117 
     118 
     119-- 
    101120-- Name: dynpoi_update; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    102121-- 
     
    189208-- 
    190209 
     210ALTER TABLE ONLY dynpoi_status ALTER COLUMN id SET DEFAULT nextval('dynpoi_status_id_seq'::regclass); 
     211 
     212 
     213-- 
     214-- Name: id; Type: DEFAULT; Schema: public; Owner: - 
     215-- 
     216 
    191217ALTER TABLE ONLY marker ALTER COLUMN id SET DEFAULT nextval('marker_id_seq'::regclass); 
    192218 
     
    249275 
    250276-- 
     277-- Name: dynpoi_status_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     278-- 
     279 
     280ALTER TABLE ONLY dynpoi_status 
     281    ADD CONSTRAINT dynpoi_status_id UNIQUE (id); 
     282 
     283 
     284-- 
    251285-- Name: dynpoi_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    252286-- 
  • tools/osmose_common.py

    rfd536c5 r318c2da  
    3737                       (source_id,class_id,sub_class,elems)) 
    3838      PgCursor.execute("""INSERT INTO dynpoi_status 
    39                             (source,class,subclass,elems,date,status,lat,lon,subtitle) 
    40                           SELECT source,class,subclass,elems,NOW(),%s, 
     39                            (id,source,class,subclass,elems,date,status,lat,lon,subtitle) 
     40                          SELECT id,source,class,subclass,elems,NOW(),%s, 
    4141                                 lat,lon,subtitle 
    4242                          FROM marker 
Note: See TracChangeset for help on using the changeset viewer.