Changeset 579a55b in osmose-frontend


Ignore:
Timestamp:
Jan 24, 2015 8:33:45 PM (5 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Children:
2e8d7c2
Parents:
84b9c95
git-author:
Jocelyn Jaubert <jocelyn.jaubert@…> (23/01/2015 23:06:31)
git-committer:
Jocelyn Jaubert <jocelyn.jaubert@…> (24/01/2015 20:33:45)
Message:

Regenerate schema.sql

Location:
tools/database
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • tools/database/schema.sql

    r318c2da r579a55b  
    5252    menu hstore, 
    5353    levels integer[], 
    54     number integer[] 
    55 ); 
    56  
    57  
    58 -- 
    59 -- Name: dynpoi_source; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    60 -- 
    61  
    62 CREATE TABLE dynpoi_source ( 
    63     source integer NOT NULL, 
    64     update character varying(128), 
    65     contact character varying(256), 
    66     comment character varying(1024) 
     54    number integer[], 
     55    tags character varying[] 
    6756); 
    6857 
     
    7867    count integer 
    7968); 
     69 
     70 
     71-- 
     72-- Name: dynpoi_status_id_seq; Type: SEQUENCE; Schema: public; Owner: - 
     73-- 
     74 
     75CREATE SEQUENCE dynpoi_status_id_seq 
     76    START WITH 1 
     77    INCREMENT BY 1 
     78    NO MINVALUE 
     79    NO MAXVALUE 
     80    CACHE 1; 
    8081 
    8182 
     
    9495    lon numeric(10,7), 
    9596    subtitle hstore, 
    96     id bigint 
    97 ); 
    98  
    99  
    100 -- 
    101 -- Name: dynpoi_status_id_seq; Type: SEQUENCE; Schema: public; Owner: - 
    102 -- 
    103  
    104 CREATE 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  
    116 ALTER SEQUENCE dynpoi_status_id_seq OWNED BY dynpoi_status.id; 
     97    id bigint DEFAULT nextval('dynpoi_status_id_seq'::regclass) 
     98); 
    11799 
    118100 
     
    205187 
    206188-- 
    207 -- Name: id; Type: DEFAULT; Schema: public; Owner: - 
    208 -- 
    209  
    210 ALTER TABLE ONLY dynpoi_status ALTER COLUMN id SET DEFAULT nextval('dynpoi_status_id_seq'::regclass); 
     189-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     190-- 
     191 
     192CREATE TABLE source ( 
     193    id integer NOT NULL, 
     194    country character varying(256), 
     195    analyser character varying(256) 
     196); 
     197 
     198 
     199-- 
     200-- Name: source_password; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     201-- 
     202 
     203CREATE TABLE source_password ( 
     204    source_id integer NOT NULL, 
     205    password character varying(128) 
     206); 
    211207 
    212208 
     
    255251 
    256252-- 
    257 -- Name: dynpoi_source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    258 -- 
    259  
    260 ALTER TABLE ONLY dynpoi_source 
    261     ADD CONSTRAINT dynpoi_source_pkey PRIMARY KEY (source); 
    262  
    263 ALTER TABLE dynpoi_source CLUSTER ON dynpoi_source_pkey; 
    264  
    265  
    266 -- 
    267253-- Name: dynpoi_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    268254-- 
     
    337323 
    338324-- 
    339 -- Name: dynpoi_source_comment_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    340 -- 
    341  
    342 CREATE UNIQUE INDEX dynpoi_source_comment_unique ON dynpoi_source USING btree (comment); 
     325-- Name: source_password_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     326-- 
     327 
     328ALTER TABLE ONLY source_password 
     329    ADD CONSTRAINT source_password_pkey PRIMARY KEY (source_id); 
     330 
     331 
     332-- 
     333-- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     334-- 
     335 
     336ALTER TABLE ONLY source 
     337    ADD CONSTRAINT source_pkey PRIMARY KEY (id); 
    343338 
    344339 
     
    458453 
    459454-- 
     455-- Name: source_password_password; Type: INDEX; Schema: public; Owner: -; Tablespace:  
     456-- 
     457 
     458CREATE UNIQUE INDEX source_password_password ON source_password USING btree (password); 
     459 
     460 
     461-- 
    460462-- Name: dynpoi_class_source_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    461463-- 
    462464 
    463465ALTER TABLE ONLY dynpoi_class 
    464     ADD CONSTRAINT dynpoi_class_source_fkey FOREIGN KEY (source) REFERENCES dynpoi_source(source); 
     466    ADD CONSTRAINT dynpoi_class_source_fkey FOREIGN KEY (source) REFERENCES source(id); 
    465467 
    466468 
     
    470472 
    471473ALTER TABLE ONLY dynpoi_status 
    472     ADD CONSTRAINT dynpoi_status_source_fkey FOREIGN KEY (source) REFERENCES dynpoi_source(source); 
     474    ADD CONSTRAINT dynpoi_status_source_fkey FOREIGN KEY (source) REFERENCES source(id); 
    473475 
    474476 
     
    502504 
    503505ALTER TABLE ONLY marker 
    504     ADD CONSTRAINT marker_source_fkey FOREIGN KEY (source) REFERENCES dynpoi_source(source); 
     506    ADD CONSTRAINT marker_source_fkey FOREIGN KEY (source) REFERENCES source(id); 
    505507 
    506508 
  • tools/database/schema_generate.sh

    r013da24 r579a55b  
    11#! /bin/sh 
    22 
    3 pg_dump -s -O -x -t "marker*|dynpoi_categ|dynpoi_class|dynpoi_item|dynpoi_source|dynpoi_stats|dynpoi_status|dynpoi_update|dynpoi_update_last" osmose > schema.sql 
     3pg_dump -s -O -x -t "marker*|dynpoi_categ|dynpoi_class|dynpoi_item|source|source_password|dynpoi_stats|dynpoi_status|dynpoi_status_id_seq|dynpoi_update|dynpoi_update_last" osmose_frontend > schema.sql 
Note: See TracChangeset for help on using the changeset viewer.