Changeset 688

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

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

  • Run sync_sql_for_cvs.sh
  • sql/dump_initial_data_postgres.sh: Fix a hardcoded reference to rss_url which no longer exists
  • .project: Remove mistakenly commited file in last commit
  • .cvsignore: Add file to avoid previous error
Location:
trunk/wifidog-auth
Files:
1 added
1 removed
4 modified

Legend:

Unmodified
Added
Removed

  • trunk/wifidog-auth

    • Property svn:ignore set to
      *~
      .project
      project.index

  • trunk/wifidog-auth/ChangeLog

    r687 r688  
     12005-08-15 Benoit Grégoire  <bock@step.polymtl.ca> 
     2        * Run sync_sql_for_cvs.sh 
     3        * sql/dump_initial_data_postgres.sh:  Fix a hardcoded reference to rss_url which no longer exists 
     4        * .project:  Remove mistakenly commited file in last commit 
     5        * .cvsignore:  Add file to avoid previous error 
     6         
    172005-08-12 Francois Proulx <francois.proulx@gmail.com> 
    28        * Added missing GisPoint fille to CVS 
    … …  
    1218        * Will add geocode + Google Maps capabilities very soon 
    1319        * Notice : the XML schema will change very soon... 
    14                 * I will try to keep the streetAddress field intact so I won't break backward compat. 
     20        * I will try to keep the streetAddress field intact so I won't break backward compat. 
    1521         
    16222005-08-12 Benoit Grégoire  <bock@step.polymtl.ca> 

  • trunk/wifidog-auth/sql/dump_initial_data_postgres.sh

    r545 r688  
    77pg_dump -a -D --username=wifidog -t venue_types 
    88pg_dump -a -D --username=wifidog -t node_deployment_status 
    9 echo "INSERT INTO nodes (node_id, name, rss_url) VALUES ('default', 'Unknown node', NULL);" 
     9echo "INSERT INTO nodes (node_id, name) VALUES ('default', 'Unknown node');" 
    1010 
    1111pg_dump -a -D --username=wifidog -t schema_info 

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

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