Show
Ignore:
Timestamp:
05/01/05 00:12:27 (8 years ago)
Author:
benoitg
Message:

2005-04-30 Francois Proulx <francois.proulx@…>

  • Updated sync_sql_for_cvs.sh
Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/wifidog-auth/sql/wifidog-postgres-schema.sql

    r545 r606  
    2222 
    2323-- 
    24 -- TOC entry 5 (OID 192397) 
     24-- TOC entry 5 (OID 706679) 
    2525-- Name: administrators; Type: TABLE; Schema: public; Owner: wifidog 
    2626-- 
    … …  
    3232 
    3333-- 
    34 -- TOC entry 6 (OID 192400) 
     34-- TOC entry 6 (OID 706682) 
    3535-- Name: token_status; Type: TABLE; Schema: public; Owner: wifidog 
    3636-- 
    … …  
    4242 
    4343-- 
    44 -- TOC entry 7 (OID 192404) 
     44-- TOC entry 7 (OID 706686) 
    4545-- Name: connections; Type: TABLE; Schema: public; Owner: wifidog 
    4646-- 
    … …  
    6464 
    6565-- 
    66 -- TOC entry 8 (OID 192410) 
     66-- TOC entry 8 (OID 706692) 
    6767-- Name: nodes; Type: TABLE; Schema: public; Owner: wifidog 
    6868-- 
    … …  
    8989 
    9090-- 
    91 -- TOC entry 9 (OID 192420) 
     91-- TOC entry 9 (OID 706702) 
    9292-- Name: users; Type: TABLE; Schema: public; Owner: wifidog 
    9393-- 
    … …  
    112112 
    113113-- 
    114 -- TOC entry 10 (OID 192430) 
     114-- TOC entry 10 (OID 706713) 
    115115-- Name: node_owners; Type: TABLE; Schema: public; Owner: wifidog 
    116116-- 
    … …  
    123123 
    124124-- 
    125 -- TOC entry 11 (OID 192432) 
     125-- TOC entry 11 (OID 706715) 
    126126-- Name: node_deployment_status; Type: TABLE; Schema: public; Owner: wifidog 
    127127-- 
    … …  
    133133 
    134134-- 
    135 -- TOC entry 12 (OID 192434) 
     135-- TOC entry 12 (OID 706717) 
    136136-- Name: venue_types; Type: TABLE; Schema: public; Owner: wifidog 
    137137-- 
    … …  
    143143 
    144144-- 
    145 -- TOC entry 13 (OID 192439) 
     145-- TOC entry 13 (OID 706722) 
    146146-- Name: venues; Type: TABLE; Schema: public; Owner: wifidog 
    147147-- 
    … …  
    154154 
    155155-- 
    156 -- TOC entry 14 (OID 192444) 
     156-- TOC entry 14 (OID 706727) 
    157157-- Name: schema_info; Type: TABLE; Schema: public; Owner: wifidog 
    158158-- 
    … …  
    165165 
    166166-- 
    167 -- TOC entry 15 (OID 214063) 
     167-- TOC entry 15 (OID 728649) 
    168168-- Name: locales; Type: TABLE; Schema: public; Owner: wifidog 
    169169-- 
    … …  
    175175 
    176176-- 
    177 -- TOC entry 16 (OID 214077) 
     177-- TOC entry 16 (OID 728663) 
    178178-- Name: content; Type: TABLE; Schema: public; Owner: wifidog 
    179179-- 
    … …  
    187187    sponsor_info text, 
    188188    creation_timestamp timestamp without time zone DEFAULT now(), 
     189    is_persistent boolean DEFAULT false, 
    189190    CONSTRAINT content_type_not_empty_string CHECK ((content_type <> ''::text)) 
    190191); 
    … …  
    192193 
    193194-- 
    194 -- TOC entry 17 (OID 214102) 
     195-- TOC entry 17 (OID 728688) 
    195196-- Name: content_has_owners; Type: TABLE; Schema: public; Owner: wifidog 
    196197-- 
    … …  
    205206 
    206207-- 
    207 -- TOC entry 18 (OID 214118) 
     208-- TOC entry 18 (OID 728704) 
    208209-- Name: langstring_entries; Type: TABLE; Schema: public; Owner: wifidog 
    209210-- 
    … …  
    218219 
    219220-- 
    220 -- TOC entry 19 (OID 214134) 
     221-- TOC entry 19 (OID 728720) 
    221222-- Name: content_group; Type: TABLE; Schema: public; Owner: wifidog 
    222223-- 
    … …  
    226227    is_artistic_content boolean DEFAULT false NOT NULL, 
    227228    is_locative_content boolean DEFAULT false NOT NULL, 
    228     content_selection_mode text 
    229 ); 
    230  
    231  
    232 -- 
    233 -- TOC entry 20 (OID 214145) 
     229    content_changes_on_mode text DEFAULT 'ALWAYS'::text NOT NULL, 
     230    content_ordering_mode text DEFAULT 'RANDOM'::text NOT NULL, 
     231    display_num_elements integer DEFAULT 1 NOT NULL, 
     232    allow_repeat text DEFAULT 'YES'::text NOT NULL, 
     233    CONSTRAINT display_at_least_one_element CHECK ((display_num_elements > 0)) 
     234); 
     235 
     236 
     237-- 
     238-- TOC entry 20 (OID 728733) 
    234239-- Name: content_group_element; Type: TABLE; Schema: public; Owner: wifidog 
    235240-- 
    … …  
    245250 
    246251-- 
    247 -- TOC entry 21 (OID 214166) 
    248 -- Name: content_group_element_portal_display_log; Type: TABLE; Schema: public; Owner: wifidog 
    249 -- 
    250  
    251 CREATE TABLE content_group_element_portal_display_log ( 
    252     user_id text NOT NULL, 
     252-- TOC entry 21 (OID 728754) 
     253-- Name: content_group_element_has_allowed_nodes; Type: TABLE; Schema: public; Owner: wifidog 
     254-- 
     255 
     256CREATE TABLE content_group_element_has_allowed_nodes ( 
    253257    content_group_element_id text NOT NULL, 
    254     display_timestamp timestamp without time zone DEFAULT now() NOT NULL, 
    255     node_id text 
    256 ); 
    257  
    258  
    259 -- 
    260 -- TOC entry 22 (OID 214186) 
     258    node_id text NOT NULL, 
     259    allowed_since timestamp without time zone DEFAULT now() 
     260); 
     261 
     262 
     263-- 
     264-- TOC entry 22 (OID 728790) 
    261265-- Name: user_has_content; Type: TABLE; Schema: public; Owner: wifidog 
    262266-- 
    … …  
    270274 
    271275-- 
    272 -- TOC entry 23 (OID 214202) 
     276-- TOC entry 23 (OID 728806) 
    273277-- Name: node_has_content; Type: TABLE; Schema: public; Owner: wifidog 
    274278-- 
    … …  
    282286 
    283287-- 
    284 -- TOC entry 24 (OID 214218) 
     288-- TOC entry 24 (OID 728822) 
    285289-- Name: network_has_content; Type: TABLE; Schema: public; Owner: wifidog 
    286290-- 
    … …  
    294298 
    295299-- 
    296 -- TOC entry 25 (OID 214271) 
    297 -- Name: content_group_element_has_allowed_nodes; Type: TABLE; Schema: public; Owner: wifidog 
    298 -- 
    299  
    300 CREATE TABLE content_group_element_has_allowed_nodes ( 
    301     content_group_element_id text NOT NULL, 
     300-- TOC entry 25 (OID 741741) 
     301-- Name: flickr_photostream; Type: TABLE; Schema: public; Owner: wifidog 
     302-- 
     303 
     304CREATE TABLE flickr_photostream ( 
     305    flickr_photostream_id text NOT NULL, 
     306    api_key text, 
     307    photo_selection_mode text DEFAULT 'PSM_GROUP'::text NOT NULL, 
     308    user_id text, 
     309    user_name text, 
     310    tags text, 
     311    tag_mode character varying(10) DEFAULT 'any'::character varying, 
     312    group_id text, 
     313    random boolean DEFAULT true NOT NULL, 
     314    min_taken_date timestamp without time zone, 
     315    max_taken_date timestamp without time zone, 
     316    photo_batch_size integer DEFAULT 10, 
     317    photo_count integer DEFAULT 1, 
     318    display_title boolean DEFAULT true NOT NULL, 
     319    display_description boolean DEFAULT false NOT NULL, 
     320    display_tags boolean DEFAULT false NOT NULL, 
     321    preferred_size text 
     322); 
     323 
     324 
     325-- 
     326-- TOC entry 26 (OID 741760) 
     327-- Name: files; Type: TABLE; Schema: public; Owner: wifidog 
     328-- 
     329 
     330CREATE TABLE files ( 
     331    files_id text NOT NULL, 
     332    filename text, 
     333    mime_type text, 
     334    binary_data bytea, 
     335    remote_size bigint, 
     336    url text 
     337); 
     338 
     339 
     340-- 
     341-- TOC entry 27 (OID 741767) 
     342-- Name: embedded_content; Type: TABLE; Schema: public; Owner: wifidog 
     343-- 
     344 
     345CREATE TABLE embedded_content ( 
     346    embedded_content_id text NOT NULL, 
     347    embedded_file_id text, 
     348    fallback_content_id text, 
     349    parameters text, 
     350    attributes text 
     351); 
     352 
     353 
     354-- 
     355-- TOC entry 28 (OID 741772) 
     356-- Name: content_display_log; Type: TABLE; Schema: public; Owner: wifidog 
     357-- 
     358 
     359CREATE TABLE content_display_log ( 
     360    user_id text NOT NULL, 
     361    content_id text NOT NULL, 
     362    first_display_timestamp timestamp without time zone DEFAULT now() NOT NULL, 
    302363    node_id text NOT NULL, 
    303     allowed_since timestamp without time zone DEFAULT now() 
    304 ); 
    305  
    306  
    307 -- 
    308 -- TOC entry 29 (OID 214009) 
     364    last_display_timestamp timestamp without time zone DEFAULT now() NOT NULL 
     365); 
     366 
     367 
     368-- 
     369-- TOC entry 32 (OID 728596) 
    309370-- Name: idx_token; Type: INDEX; Schema: public; Owner: wifidog 
    310371-- 
    … …  
    314375 
    315376-- 
    316 -- TOC entry 30 (OID 214010) 
     377-- TOC entry 33 (OID 728597) 
    317378-- Name: idx_token_status_and_user_id; Type: INDEX; Schema: public; Owner: wifidog 
    318379-- 
    … …  
    322383 
    323384-- 
    324 -- TOC entry 32 (OID 214011) 
     385-- TOC entry 35 (OID 728598) 
    325386-- Name: idx_unique_username_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog 
    326387-- 
    … …  
    330391 
    331392-- 
    332 -- TOC entry 44 (OID 214165) 
     393-- TOC entry 47 (OID 728753) 
    333394-- Name: idx_content_group_element_content_group_id; Type: INDEX; Schema: public; Owner: wifidog 
    334395-- 
    … …  
    338399 
    339400-- 
    340 -- TOC entry 26 (OID 214012) 
     401-- TOC entry 29 (OID 728599) 
    341402-- Name: administrators_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    342403-- 
    … …  
    347408 
    348409-- 
    349 -- TOC entry 27 (OID 214014) 
     410-- TOC entry 30 (OID 728601) 
    350411-- Name: token_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    351412-- 
    … …  
    356417 
    357418-- 
    358 -- TOC entry 28 (OID 214016) 
     419-- TOC entry 31 (OID 728603) 
    359420-- Name: connections_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    360421-- 
    … …  
    365426 
    366427-- 
    367 -- TOC entry 31 (OID 214018) 
     428-- TOC entry 34 (OID 728605) 
    368429-- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    369430-- 
    … …  
    374435 
    375436-- 
    376 -- TOC entry 33 (OID 214020) 
     437-- TOC entry 36 (OID 728607) 
    377438-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    378439-- 
    … …  
    383444 
    384445-- 
    385 -- TOC entry 34 (OID 214022) 
     446-- TOC entry 37 (OID 728609) 
    386447-- Name: node_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    387448-- 
    … …  
    392453 
    393454-- 
    394 -- TOC entry 35 (OID 214024) 
     455-- TOC entry 38 (OID 728611) 
    395456-- Name: node_deployment_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    396457-- 
    … …  
    401462 
    402463-- 
    403 -- TOC entry 36 (OID 214026) 
     464-- TOC entry 39 (OID 728613) 
    404465-- Name: venue_types_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    405466-- 
    … …  
    410471 
    411472-- 
    412 -- TOC entry 37 (OID 214028) 
     473-- TOC entry 40 (OID 728615) 
    413474-- Name: schema_info_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    414475-- 
    … …  
    419480 
    420481-- 
    421 -- TOC entry 38 (OID 214068) 
     482-- TOC entry 41 (OID 728654) 
    422483-- Name: locales_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    423484-- 
    … …  
    428489 
    429490-- 
    430 -- TOC entry 39 (OID 214084) 
     491-- TOC entry 42 (OID 728670) 
    431492-- Name: content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    432493-- 
    … …  
    437498 
    438499-- 
    439 -- TOC entry 40 (OID 214108) 
     500-- TOC entry 43 (OID 728694) 
    440501-- Name: content_has_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    441502-- 
    … …  
    446507 
    447508-- 
    448 -- TOC entry 41 (OID 214124) 
     509-- TOC entry 44 (OID 728710) 
    449510-- Name: langstring_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    450511-- 
    … …  
    455516 
    456517-- 
    457 -- TOC entry 42 (OID 214139) 
     518-- TOC entry 45 (OID 728727) 
    458519-- Name: content_group_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    459520-- 
    … …  
    464525 
    465526-- 
    466 -- TOC entry 43 (OID 214151) 
     527-- TOC entry 46 (OID 728739) 
    467528-- Name: content_group_element_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    468529-- 
    … …  
    473534 
    474535-- 
    475 -- TOC entry 45 (OID 214172) 
    476 -- Name: content_group_element_portal_display_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    477 -- 
    478  
    479 ALTER TABLE ONLY content_group_element_portal_display_log 
    480     ADD CONSTRAINT content_group_element_portal_display_log_pkey PRIMARY KEY (user_id, content_group_element_id, display_timestamp); 
    481  
    482  
    483 -- 
    484 -- TOC entry 46 (OID 214192) 
     536-- TOC entry 48 (OID 728760) 
     537-- Name: content_group_element_has_allowed_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
     538-- 
     539 
     540ALTER TABLE ONLY content_group_element_has_allowed_nodes 
     541    ADD CONSTRAINT content_group_element_has_allowed_nodes_pkey PRIMARY KEY (content_group_element_id, node_id); 
     542 
     543 
     544-- 
     545-- TOC entry 49 (OID 728796) 
    485546-- Name: user_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    486547-- 
    … …  
    491552 
    492553-- 
    493 -- TOC entry 47 (OID 214208) 
     554-- TOC entry 50 (OID 728812) 
    494555-- Name: node_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    495556-- 
    … …  
    500561 
    501562-- 
    502 -- TOC entry 48 (OID 214224) 
     563-- TOC entry 51 (OID 728828) 
    503564-- Name: network_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    504565-- 
    … …  
    509570 
    510571-- 
    511 -- TOC entry 49 (OID 214277) 
    512 -- Name: content_group_element_has_allowed_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    513 -- 
    514  
    515 ALTER TABLE ONLY content_group_element_has_allowed_nodes 
    516     ADD CONSTRAINT content_group_element_has_allowed_nodes_pkey PRIMARY KEY (content_group_element_id, node_id); 
    517  
    518  
    519 -- 
    520 -- TOC entry 51 (OID 214030) 
     572-- TOC entry 52 (OID 741754) 
     573-- Name: flickr_photostream_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
     574-- 
     575 
     576ALTER TABLE ONLY flickr_photostream 
     577    ADD CONSTRAINT flickr_photostream_pkey PRIMARY KEY (flickr_photostream_id); 
     578 
     579 
     580-- 
     581-- TOC entry 53 (OID 741765) 
     582-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
     583-- 
     584 
     585ALTER TABLE ONLY files 
     586    ADD CONSTRAINT files_pkey PRIMARY KEY (files_id); 
     587 
     588 
     589-- 
     590-- TOC entry 54 (OID 741779) 
     591-- Name: content_group_element_portal_display_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
     592-- 
     593 
     594ALTER TABLE ONLY content_display_log 
     595    ADD CONSTRAINT content_group_element_portal_display_log_pkey PRIMARY KEY (user_id, content_id, node_id); 
     596 
     597 
     598-- 
     599-- TOC entry 56 (OID 728617) 
    521600-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    522601-- 
    … …  
    527606 
    528607-- 
    529 -- TOC entry 50 (OID 214034) 
     608-- TOC entry 55 (OID 728621) 
    530609-- Name: administrators_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    531610-- 
    … …  
    536615 
    537616-- 
    538 -- TOC entry 52 (OID 214038) 
     617-- TOC entry 57 (OID 728625) 
    539618-- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    540619-- 
    … …  
    545624 
    546625-- 
    547 -- TOC entry 53 (OID 214042) 
     626-- TOC entry 58 (OID 728629) 
    548627-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    549628-- 
    … …  
    554633 
    555634-- 
    556 -- TOC entry 57 (OID 214046) 
     635-- TOC entry 62 (OID 728633) 
    557636-- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    558637-- 
    … …  
    563642 
    564643-- 
    565 -- TOC entry 58 (OID 214050) 
     644-- TOC entry 63 (OID 728637) 
    566645-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    567646-- 
    … …  
    572651 
    573652-- 
    574 -- TOC entry 54 (OID 214054) 
     653-- TOC entry 59 (OID 728641) 
    575654-- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    576655-- 
    … …  
    581660 
    582661-- 
    583 -- TOC entry 55 (OID 214058) 
     662-- TOC entry 60 (OID 728645) 
    584663-- Name: fk_venue_types; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    585664-- 
    … …  
    590669 
    591670-- 
    592 -- TOC entry 56 (OID 214073) 
     671-- TOC entry 61 (OID 728659) 
    593672-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    594673-- 
    … …  
    599678 
    600679-- 
    601 -- TOC entry 59 (OID 214086) 
     680-- TOC entry 64 (OID 728672) 
    602681-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    603682-- 
    … …  
    608687 
    609688-- 
    610 -- TOC entry 60 (OID 214090) 
     689-- TOC entry 65 (OID 728676) 
    611690-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    612691-- 
    … …  
    617696 
    618697-- 
    619 -- TOC entry 61 (OID 214094) 
     698-- TOC entry 66 (OID 728680) 
    620699-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    621700-- 
    … …  
    626705 
    627706-- 
    628 -- TOC entry 62 (OID 214098) 
     707-- TOC entry 67 (OID 728684) 
    629708-- Name: $4; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    630709-- 
    … …  
    635714 
    636715-- 
    637 -- TOC entry 63 (OID 214110) 
     716-- TOC entry 68 (OID 728696) 
    638717-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    639718-- 
    … …  
    644723 
    645724-- 
    646 -- TOC entry 64 (OID 214114) 
     725-- TOC entry 69 (OID 728700) 
    647726-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    648727-- 
    … …  
    653732 
    654733-- 
    655 -- TOC entry 65 (OID 214126) 
     734-- TOC entry 70 (OID 728712) 
    656735-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    657736-- 
    … …  
    662741 
    663742-- 
    664 -- TOC entry 66 (OID 214130) 
     743-- TOC entry 71 (OID 728716) 
    665744-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    666745-- 
    … …  
    671750 
    672751-- 
    673 -- TOC entry 67 (OID 214141) 
     752-- TOC entry 72 (OID 728729) 
    674753-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    675754-- 
    … …  
    680759 
    681760-- 
    682 -- TOC entry 68 (OID 214153) 
     761-- TOC entry 73 (OID 728741) 
    683762-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    684763-- 
    … …  
    689768 
    690769-- 
    691 -- TOC entry 69 (OID 214157) 
     770-- TOC entry 74 (OID 728745) 
    692771-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    693772-- 
    … …  
    698777 
    699778-- 
    700 -- TOC entry 70 (OID 214161) 
     779-- TOC entry 75 (OID 728749) 
    701780-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    702781-- 
    … …  
    707786 
    708787-- 
    709 -- TOC entry 71 (OID 214174) 
    710 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    711 -- 
    712  
    713 ALTER TABLE ONLY content_group_element_portal_display_log 
    714     ADD CONSTRAINT "$1" FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    715  
    716  
    717 -- 
    718 -- TOC entry 72 (OID 214178) 
     788-- TOC entry 76 (OID 728762) 
     789-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     790-- 
     791 
     792ALTER TABLE ONLY content_group_element_has_allowed_nodes 
     793    ADD CONSTRAINT "$1" FOREIGN KEY (content_group_element_id) REFERENCES content_group_element(content_group_element_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     794 
     795 
     796-- 
     797-- TOC entry 77 (OID 728766) 
    719798-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    720799-- 
    721800 
    722 ALTER TABLE ONLY content_group_element_portal_display_log 
    723     ADD CONSTRAINT "$2" FOREIGN KEY (content_group_element_id) REFERENCES content_group_element(content_group_element_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    724  
    725  
    726 -- 
    727 -- TOC entry 73 (OID 214182) 
    728 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    729 -- 
    730  
    731 ALTER TABLE ONLY content_group_element_portal_display_log 
    732     ADD CONSTRAINT "$3" FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    733  
    734  
    735 -- 
    736 -- TOC entry 74 (OID 214194) 
     801ALTER TABLE ONLY content_group_element_has_allowed_nodes 
     802    ADD CONSTRAINT "$2" FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     803 
     804 
     805-- 
     806-- TOC entry 78 (OID 728798) 
    737807-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    738808-- 
    … …  
    743813 
    744814-- 
    745 -- TOC entry 75 (OID 214198) 
     815-- TOC entry 79 (OID 728802) 
    746816-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    747817-- 
    … …  
    752822 
    753823-- 
    754 -- TOC entry 76 (OID 214210) 
     824-- TOC entry 80 (OID 728814) 
    755825-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    756826-- 
    … …  
    761831 
    762832-- 
    763 -- TOC entry 77 (OID 214214) 
     833-- TOC entry 81 (OID 728818) 
    764834-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    765835-- 
    … …  
    770840 
    771841-- 
    772 -- TOC entry 78 (OID 214226) 
     842-- TOC entry 82 (OID 728830) 
    773843-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    774844-- 
    … …  
    779849 
    780850-- 
    781 -- TOC entry 79 (OID 214279) 
    782 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    783 -- 
    784  
    785 ALTER TABLE ONLY content_group_element_has_allowed_nodes 
    786     ADD CONSTRAINT "$1" FOREIGN KEY (content_group_element_id) REFERENCES content_group_element(content_group_element_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    787  
    788  
    789 -- 
    790 -- TOC entry 80 (OID 214283) 
     851-- TOC entry 84 (OID 741781) 
     852-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     853-- 
     854 
     855ALTER TABLE ONLY content_display_log 
     856    ADD CONSTRAINT "$1" FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     857 
     858 
     859-- 
     860-- TOC entry 85 (OID 741785) 
    791861-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    792862-- 
    793863 
    794 ALTER TABLE ONLY content_group_element_has_allowed_nodes 
    795     ADD CONSTRAINT "$2" FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     864ALTER TABLE ONLY content_display_log 
     865    ADD CONSTRAINT "$2" FOREIGN KEY (content_id) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     866 
     867 
     868-- 
     869-- TOC entry 86 (OID 741789) 
     870-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     871-- 
     872 
     873ALTER TABLE ONLY content_display_log 
     874    ADD CONSTRAINT "$3" FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     875 
     876 
     877-- 
     878-- TOC entry 83 (OID 741866) 
     879-- Name: flickr_photostream_content_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     880-- 
     881 
     882ALTER TABLE ONLY flickr_photostream 
     883    ADD CONSTRAINT flickr_photostream_content_fkey FOREIGN KEY (flickr_photostream_id) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    796884 
    797885