Changeset 689

Show
Ignore:
Timestamp:
08/15/05 16:16:06 (8 years ago)
Author:
benoitg
Message:

2005-08-15 Benoit Gr�goire <bock@…>

  • Re-Run sync_sql_for_cvs.sh, did not run to completion last time.
Location:
trunk/wifidog-auth
Files:
3 modified

Legend:

Unmodified
Added
Removed

  • trunk/wifidog-auth/ChangeLog

    r688 r689  
     12005-08-15 Benoit Grégoire  <bock@step.polymtl.ca> 
     2        * Re-Run sync_sql_for_cvs.sh, did not run to completion last time. 
     3 
    142005-08-15 Benoit Grégoire  <bock@step.polymtl.ca> 
    25        * Run sync_sql_for_cvs.sh 

  • trunk/wifidog-auth/sql/wifidog-postgres-initial-data.sql

    r688 r689  
    11\connect wifidog; 
    22BEGIN; 
     3-- 
     4-- PostgreSQL database dump 
     5-- 
     6 
     7SET client_encoding = 'UNICODE'; 
     8SET check_function_bodies = false; 
     9SET client_min_messages = warning; 
     10 
     11SET search_path = public, pg_catalog; 
     12 
     13-- 
     14-- Data for Name: token_status; Type: TABLE DATA; Schema: public; Owner: wifidog 
     15-- 
     16 
     17INSERT INTO token_status (token_status) VALUES ('UNUSED'); 
     18INSERT INTO token_status (token_status) VALUES ('INUSE'); 
     19INSERT INTO token_status (token_status) VALUES ('USED'); 
     20 
     21 
     22-- 
     23-- PostgreSQL database dump complete 
     24-- 
     25 
     26-- 
     27-- PostgreSQL database dump 
     28-- 
     29 
     30SET client_encoding = 'UNICODE'; 
     31SET check_function_bodies = false; 
     32SET client_min_messages = warning; 
     33 
     34SET search_path = public, pg_catalog; 
     35 
     36-- 
     37-- Data for Name: venue_types; Type: TABLE DATA; Schema: public; Owner: wifidog 
     38-- 
     39 
     40INSERT INTO venue_types (venue_type) VALUES ('Airline'); 
     41INSERT INTO venue_types (venue_type) VALUES ('Airport Terminal/Lounge'); 
     42INSERT INTO venue_types (venue_type) VALUES ('Bus Station'); 
     43INSERT INTO venue_types (venue_type) VALUES ('Business/Conference Center'); 
     44INSERT INTO venue_types (venue_type) VALUES ('Cafe/Coffee Shop'); 
     45INSERT INTO venue_types (venue_type) VALUES ('Camp Ground'); 
     46INSERT INTO venue_types (venue_type) VALUES ('Community Network'); 
     47INSERT INTO venue_types (venue_type) VALUES ('Convention Center'); 
     48INSERT INTO venue_types (venue_type) VALUES ('Cruise Ship'); 
     49INSERT INTO venue_types (venue_type) VALUES ('Copy Center/Business Services'); 
     50INSERT INTO venue_types (venue_type) VALUES ('Entertainment Venues'); 
     51INSERT INTO venue_types (venue_type) VALUES ('Gas/Petrol Station'); 
     52INSERT INTO venue_types (venue_type) VALUES ('Hospital'); 
     53INSERT INTO venue_types (venue_type) VALUES ('Hotel'); 
     54INSERT INTO venue_types (venue_type) VALUES ('Internet Cafe'); 
     55INSERT INTO venue_types (venue_type) VALUES ('Kiosk'); 
     56INSERT INTO venue_types (venue_type) VALUES ('Library'); 
     57INSERT INTO venue_types (venue_type) VALUES ('Marina/Harbour'); 
     58INSERT INTO venue_types (venue_type) VALUES ('Motorway Travel Center/TruckStop'); 
     59INSERT INTO venue_types (venue_type) VALUES ('Office Building/Complex'); 
     60INSERT INTO venue_types (venue_type) VALUES ('Other'); 
     61INSERT INTO venue_types (venue_type) VALUES ('Park'); 
     62INSERT INTO venue_types (venue_type) VALUES ('Pay Phone/Booth'); 
     63INSERT INTO venue_types (venue_type) VALUES ('Port/Ferry Terminal'); 
     64INSERT INTO venue_types (venue_type) VALUES ('Residential Housing/Apt Bldg'); 
     65INSERT INTO venue_types (venue_type) VALUES ('Restaurant/Bar/Pub'); 
     66INSERT INTO venue_types (venue_type) VALUES ('School/University'); 
     67INSERT INTO venue_types (venue_type) VALUES ('Shopping Center'); 
     68INSERT INTO venue_types (venue_type) VALUES ('Sports Arena/Venue'); 
     69INSERT INTO venue_types (venue_type) VALUES ('Store/Retail Shop'); 
     70INSERT INTO venue_types (venue_type) VALUES ('Train'); 
     71INSERT INTO venue_types (venue_type) VALUES ('Train/Rail Station'); 
     72INSERT INTO venue_types (venue_type) VALUES ('Water Travel'); 
     73INSERT INTO venue_types (venue_type) VALUES ('Wi-Fi Zone'); 
     74 
     75 
     76-- 
     77-- PostgreSQL database dump complete 
     78-- 
     79 
     80-- 
     81-- PostgreSQL database dump 
     82-- 
     83 
     84SET client_encoding = 'UNICODE'; 
     85SET check_function_bodies = false; 
     86SET client_min_messages = warning; 
     87 
     88SET search_path = public, pg_catalog; 
     89 
     90-- 
     91-- Data for Name: node_deployment_status; Type: TABLE DATA; Schema: public; Owner: wifidog 
     92-- 
     93 
     94INSERT INTO node_deployment_status (node_deployment_status) VALUES ('DEPLOYED'); 
     95INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_PLANNING'); 
     96INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_TESTING'); 
     97INSERT INTO node_deployment_status (node_deployment_status) VALUES ('NON_WIFIDOG_NODE'); 
     98INSERT INTO node_deployment_status (node_deployment_status) VALUES ('PERMANENTLY_CLOSED'); 
     99INSERT INTO node_deployment_status (node_deployment_status) VALUES ('TEMPORARILY_CLOSED'); 
     100 
     101 
     102-- 
     103-- PostgreSQL database dump complete 
     104-- 
     105 
     106INSERT INTO nodes (node_id, name) VALUES ('default', 'Unknown node'); 
     107-- 
     108-- PostgreSQL database dump 
     109-- 
     110 
     111SET client_encoding = 'UNICODE'; 
     112SET check_function_bodies = false; 
     113SET client_min_messages = warning; 
     114 
     115SET search_path = public, pg_catalog; 
     116 
     117-- 
     118-- Data for Name: schema_info; Type: TABLE DATA; Schema: public; Owner: wifidog 
     119-- 
     120 
     121INSERT INTO schema_info (tag, value) VALUES ('schema_version', '23'); 
     122 
     123 
     124-- 
     125-- PostgreSQL database dump complete 
     126-- 
     127 
     128-- 
     129-- PostgreSQL database dump 
     130-- 
     131 
     132SET client_encoding = 'UNICODE'; 
     133SET check_function_bodies = false; 
     134SET client_min_messages = warning; 
     135 
     136SET search_path = public, pg_catalog; 
     137 
     138-- 
     139-- Data for Name: locales; Type: TABLE DATA; Schema: public; Owner: wifidog 
     140-- 
     141 
     142INSERT INTO locales (locales_id) VALUES ('fr'); 
     143INSERT INTO locales (locales_id) VALUES ('en'); 
     144 
     145 
     146-- 
     147-- PostgreSQL database dump complete 
     148-- 
     149 
     150COMMIT; 

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

    r685 r689  
    308308 
    309309-- 
     310-- Name: node_tech_officers; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     311-- 
     312 
     313CREATE TABLE node_tech_officers ( 
     314    node_id character varying(32) NOT NULL, 
     315    user_id character varying(45) NOT NULL 
     316); 
     317 
     318 
     319-- 
    310320-- Name: nodes; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    311321-- 
    … …  
    321331    description text, 
    322332    map_url text, 
    323     street_address text, 
    324333    public_phone_number text, 
    325334    public_email text, 
    … …  
    331340    quota_reset_day_of_month integer, 
    332341    latitude numeric(16,6), 
    333     longitude numeric(16,6) 
     342    longitude numeric(16,6), 
     343    civic_number text, 
     344    street_name text, 
     345    city text, 
     346    province text, 
     347    country text, 
     348    postal_code text 
    334349); 
    335350 
    … …  
    572587 
    573588-- 
     589-- Name: node_tech_officers_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     590-- 
     591 
     592ALTER TABLE ONLY node_tech_officers 
     593    ADD CONSTRAINT node_tech_officers_pkey PRIMARY KEY (node_id, user_id); 
     594 
     595 
     596-- 
    574597-- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
    575598-- 
    … …  
    952975 
    953976-- 
     977-- Name: node_tech_officers_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     978-- 
     979 
     980ALTER TABLE ONLY node_tech_officers 
     981    ADD CONSTRAINT node_tech_officers_node_id_fkey FOREIGN KEY (node_id) REFERENCES nodes(node_id); 
     982 
     983 
     984-- 
     985-- Name: node_tech_officers_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     986-- 
     987 
     988ALTER TABLE ONLY node_tech_officers 
     989    ADD CONSTRAINT node_tech_officers_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); 
     990 
     991 
     992-- 
    954993-- PostgreSQL database dump complete 
    955994--