Show
Ignore:
Timestamp:
11/03/04 13:38:31 (9 years ago)
Author:
benoitg
Message:

2004-11-03 Benoit Gr�goire <bock@…>

  • wifidog/ping/index.php: Log user-agent
  • extensive statistics work
  • sql/wifidog-postgres-schema.sql: Add description field for hotspots and log user-agent
Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r254 r267  
    33-- 
    44 
    5 -- 
    6 -- TOC entry 1 (OID 0) 
     5SET client_encoding = 'LATIN1'; 
     6SET check_function_bodies = false; 
     7 
     8-- 
     9-- TOC entry 2 (OID 0) 
    710-- Name: wifidog; Type: DATABASE; Schema: -; Owner: wifidog 
    811-- 
    … …  
    1316\connect wifidog wifidog 
    1417 
     18SET client_encoding = 'LATIN1'; 
     19SET check_function_bodies = false; 
     20 
    1521SET search_path = public, pg_catalog; 
    1622 
    1723-- 
    18 -- TOC entry 3 (OID 299867) 
     24-- TOC entry 4 (OID 299867) 
    1925-- Name: administrators; Type: TABLE; Schema: public; Owner: wifidog 
    2026-- 
    … …  
    2632 
    2733-- 
    28 -- TOC entry 4 (OID 299872) 
     34-- TOC entry 5 (OID 299872) 
    2935-- Name: token_status; Type: TABLE; Schema: public; Owner: wifidog 
    3036-- 
    … …  
    3642 
    3743-- 
    38 -- TOC entry 5 (OID 299881) 
     44-- TOC entry 6 (OID 299881) 
    3945-- Name: connections; Type: TABLE; Schema: public; Owner: wifidog 
    4046-- 
    … …  
    5864 
    5965-- 
    60 -- TOC entry 6 (OID 299895) 
     66-- TOC entry 7 (OID 299895) 
    6167-- Name: nodes; Type: TABLE; Schema: public; Owner: wifidog 
    6268-- 
    … …  
    6975    last_heartbeat_timestamp timestamp without time zone DEFAULT now(), 
    7076    creation_date date DEFAULT now(), 
    71     home_page_url text 
    72 ); 
    73  
    74  
    75 -- 
    76 -- TOC entry 7 (OID 299906) 
     77    home_page_url text, 
     78    last_heartbeat_user_agent text, 
     79    description text 
     80); 
     81 
     82 
     83-- 
     84-- TOC entry 8 (OID 299906) 
    7785-- Name: users; Type: TABLE; Schema: public; Owner: wifidog 
    7886-- 
    … …  
    9199 
    92100-- 
    93 -- TOC entry 8 (OID 300988) 
     101-- TOC entry 9 (OID 300988) 
    94102-- Name: node_owners; Type: TABLE; Schema: public; Owner: wifidog 
    95103-- 
    … …  
    102110 
    103111-- 
    104 -- TOC entry 12 (OID 300919) 
     112-- TOC entry 13 (OID 300919) 
    105113-- Name: idx_token; Type: INDEX; Schema: public; Owner: wifidog 
    106114-- 
    … …  
    110118 
    111119-- 
    112 -- TOC entry 13 (OID 300920) 
     120-- TOC entry 14 (OID 300920) 
    113121-- Name: idx_token_status_and_user_id; Type: INDEX; Schema: public; Owner: wifidog 
    114122-- 
    … …  
    118126 
    119127-- 
    120 -- TOC entry 9 (OID 299870) 
     128-- TOC entry 10 (OID 299870) 
    121129-- Name: administrators_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    122130-- 
    … …  
    127135 
    128136-- 
    129 -- TOC entry 10 (OID 299874) 
     137-- TOC entry 11 (OID 299874) 
    130138-- Name: token_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    131139-- 
    … …  
    136144 
    137145-- 
    138 -- TOC entry 11 (OID 299889) 
     146-- TOC entry 12 (OID 299889) 
    139147-- Name: connections_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    140148-- 
    … …  
    145153 
    146154-- 
    147 -- TOC entry 14 (OID 299901) 
     155-- TOC entry 15 (OID 299901) 
    148156-- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    149157-- 
    … …  
    154162 
    155163-- 
    156 -- TOC entry 15 (OID 299912) 
     164-- TOC entry 16 (OID 299912) 
    157165-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    158166-- 
    … …  
    163171 
    164172-- 
    165 -- TOC entry 16 (OID 310107) 
     173-- TOC entry 17 (OID 310107) 
    166174-- Name: node_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 
    167175-- 
    … …  
    172180 
    173181-- 
    174 -- TOC entry 18 (OID 299891) 
     182-- TOC entry 19 (OID 299891) 
    175183-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    176184-- 
    … …  
    181189 
    182190-- 
    183 -- TOC entry 17 (OID 299914) 
     191-- TOC entry 18 (OID 299914) 
    184192-- Name: administrators_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    185193-- 
    … …  
    190198 
    191199-- 
    192 -- TOC entry 19 (OID 300909) 
     200-- TOC entry 20 (OID 300909) 
    193201-- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    194202-- 
    … …  
    199207 
    200208-- 
    201 -- TOC entry 20 (OID 300913) 
     209-- TOC entry 21 (OID 300913) 
    202210-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    203211-- 
    … …  
    208216 
    209217-- 
    210 -- TOC entry 21 (OID 310097) 
     218-- TOC entry 22 (OID 310097) 
    211219-- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    212220-- 
    … …  
    217225 
    218226-- 
    219 -- TOC entry 22 (OID 310101) 
     227-- TOC entry 23 (OID 310101) 
    220228-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    221229--