Show
Ignore:
Timestamp:
10/06/05 21:10:14 (8 years ago)
Author:
fproulx
Message:

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

  • Translated some error message in SQL abstraction
  • Cleaned up error messages when starting from scratch
  • Added link to install script, when the database is empty.
  • Fixed initial data dump script
Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r768 r789  
    2828 
    2929SET search_path = public, pg_catalog; 
    30  
    31 -- 
    32 -- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres 
    33 -- 
    34  
    35 CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler 
    36     AS '$libdir/plpgsql', 'plpgsql_call_handler' 
    37     LANGUAGE c; 
    38  
    39  
    40 -- 
    41 -- Name: plpgsql_validator(oid); Type: FUNCTION; Schema: public; Owner: postgres 
    42 -- 
    43  
    44 CREATE FUNCTION plpgsql_validator(oid) RETURNS void 
    45     AS '$libdir/plpgsql', 'plpgsql_validator' 
    46     LANGUAGE c; 
    47  
    48  
    49 -- 
    50 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:  
    51 -- 
    52  
    53 CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler VALIDATOR plpgsql_validator; 
    54  
    5530 
    5631SET default_tablespace = ''; 
    … …  
    326301    allow_splash_only_nodes boolean DEFAULT false NOT NULL, 
    327302    allow_custom_portal_redirect boolean DEFAULT false NOT NULL, 
    328     CONSTRAINT networks_name_check CHECK ((name <> ''::text)), 
    329     CONSTRAINT networks_network_authenticator_class_check CHECK ((network_authenticator_class <> ''::text)), 
    330     CONSTRAINT networks_validation_email_from_address_check CHECK ((validation_email_from_address <> ''::text)) 
     303    CONSTRAINT networks_name CHECK ((name <> ''::text)), 
     304    CONSTRAINT networks_network_authenticator_class CHECK ((network_authenticator_class <> ''::text)), 
     305    CONSTRAINT networks_validation_email_from_address CHECK ((validation_email_from_address <> ''::text)) 
    331306); 
    332307 
    … …  
    417392 
    418393-- 
    419 -- Name: real_first_conn_table_name_3df89c20e8b80f2d145c27ef641713ae; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    420 -- 
    421  
    422 CREATE TABLE real_first_conn_table_name_3df89c20e8b80f2d145c27ef641713ae ( 
    423     conn_id integer 
    424 ); 
    425  
    426  
    427 -- 
    428394-- Name: schema_info; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    429395-- 
    … …  
    723689 
    724690-- 
    725 -- Name: idx_connections_node_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
    726 -- 
    727  
    728 CREATE INDEX idx_connections_node_id ON connections USING btree (node_id); 
    729  
    730  
    731 -- 
    732 -- Name: idx_connections_user_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
    733 -- 
    734  
    735 CREATE INDEX idx_connections_user_id ON connections USING btree (user_id); 
    736  
    737  
    738 -- 
    739 -- Name: idx_connections_user_mac; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
    740 -- 
    741  
    742 CREATE INDEX idx_connections_user_mac ON connections USING btree (user_mac); 
    743  
    744  
    745 -- 
    746691-- Name: idx_content_group_element_content_group_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
    747692-- 
    … …  
    908853 
    909854-- 
     855-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     856-- 
     857 
     858ALTER TABLE ONLY network_stakeholders 
     859    ADD CONSTRAINT "$1" FOREIGN KEY (network_id) REFERENCES networks(network_id); 
     860 
     861 
     862-- 
    910863-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    911864-- 
    … …  
    980933 
    981934-- 
     935-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     936-- 
     937 
     938ALTER TABLE ONLY network_stakeholders 
     939    ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id); 
     940 
     941 
     942-- 
    982943-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    983944-- 
    … …  
    10921053 
    10931054-- 
    1094 -- Name: network_stakeholders_network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1095 -- 
    1096  
    1097 ALTER TABLE ONLY network_stakeholders 
    1098     ADD CONSTRAINT network_stakeholders_network_id_fkey FOREIGN KEY (network_id) REFERENCES networks(network_id); 
    1099  
    1100  
    1101 -- 
    1102 -- Name: network_stakeholders_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1103 -- 
    1104  
    1105 ALTER TABLE ONLY network_stakeholders 
    1106     ADD CONSTRAINT network_stakeholders_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); 
    1107  
    1108  
    1109 -- 
    11101055-- PostgreSQL database dump complete 
    11111056--