Changeset 1250

Show
Ignore:
Timestamp:
07/12/07 16:16:45 (6 years ago)
Author:
benoitg
Message:

Last commit was incomplete for some reason.

Location:
trunk/wifidog-auth
Files:
5 modified
1 moved

Legend:

Unmodified
Added
Removed

  • trunk/wifidog-auth/CHANGELOG

    r1248 r1250  
     12007-06-12  Benoit Grégoire  <bock@step.polymtl.ca> 
     2        -This is a behemoth "the road to 1.0"  commit.  I've been working on this for 6 months,  
     3        and it's reached the point where others can help.  Those are very far reaching changes, please 
     4        notify me if anything isn't working right (and im sure I can't have caught everything). 
     5    * Completely revamp exception handling, all exceptions are now trapped and handled centrally. 
     6    * Major changes in the login process to allow repeating a request after a time out or missing permission exception. 
     7    * New user roles architecture,  as described in https://dev.wifidog.org/wiki/doc/developer/UserRolesArchitecture 
     8        Mostly complete.  Missing parts are Content stakeholders, system roles and "su" functionnality.  
     9        I need help replacing all the DEPRECATED* methods.  Please read the wiki page above for instructions. 
     10        * generic_object_admin.php:  More work towards making it generic once again. 
     11        * GenericDataObject:  New class.  Eventually, most classes should extend this, instead of directly implementing GenericObject 
     12        * Menu.php:  Finally a uniform Menuing system to replace the mismatch of links that made wifidog  
     13        impossible to navigate.  It's not very sophisticated yet, but it IS permission aware 
     14        Loosely inspired from Drupal's menuing system.  HTML is slightly modified "Son of suckerfish",  
     15        so will be easy to style (althouh I haven't had time yet). 
     16        Actual menus are added in the hook_menu methods of each class. 
     17        * VirtualHost.php:  Finally properly split off Virtual Hosts, and make Server a singleton. 
     18        * install.php:  Do the bare minimum changes so it's still possible to setup a wifidog auth server. 
     19        However, install.php still needs 1- A good overhaull, 2- A way to install sample databases instead of the minimal one. 
     20        -Other changes 
     21    * Unbreak signup link for non-javascript enabled devices 
     22        * FlickrPhotostream:  Check CURL, which is a mandatory dependency of Flickr 
     23    * AbstractDb:  Improve debuging features 
     24    * *:getObject():  Hopefully improve performance of class caching by making sure  
     25    that we do not manipulate different objects.  Otherwise copies would be generated as soon as we change properties, wasting much memory. 
     26        * Add dependency check for XSL module for hotspot_status.php. 
     27        * Some work towards respecting the coding style: http://dev.wifidog.org/wiki/doc/developer/CodingStandard 
     28        * wifidog/admin/index.php:  Delete admin page.  There is no longuer a concept of a separate admin section.  Menu will depend on your access level. 
     29 
    1302007-07-11  Benoit Gréoire  <bock@step.polymtl.ca> 
    231        * path_defines_url_content.php: Fix #348 
    … …  
    534        * wifidog/signup.php:  Notify the user of the allowed characters. 
    635        * Add Bulgarian translation from "Nikola Petrov" <nvp.online A T gmail.com> 
    7         * config_available_languages:  Centralise the list there so that there is only one to modify everytime we add a translation 
    8          
     36        * config_available_languages:  Centralize the list there so that there is only one to modify everytime we add a translation 
     37 
    9382007-06-12  Benoit Gréoire  <bock@step.polymtl.ca> 
    1039        * IE6 layout workarounds (not perfect, but better) 

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

    r1176 r1250  
    44 
    55pg_dump -a -D --username=wifidog -t token_status 
    6  
    76pg_dump -a -D --username=wifidog -t venue_types 
    87pg_dump -a -D --username=wifidog -t node_deployment_status 
    98pg_dump -a -D --username=wifidog -t content_available_display_areas 
    109pg_dump -a -D --username=wifidog -t content_available_display_pages 
    11 echo "INSERT INTO networks (network_id, is_default_network, network_authenticator_class, network_authenticator_params) VALUES ('default-network', true, 'AuthenticatorLocalUser', '\'default-network\'');"; 
     10pg_dump -a -D --username=wifidog -t stakeholder_types 
     11 
     12echo "INSERT INTO networks (network_id, network_authenticator_class, network_authenticator_params) VALUES ('default-network', 'AuthenticatorLocalUser', '\'default-network\'');"; 
    1213echo "INSERT INTO nodes (network_id, node_id, gw_id, name) VALUES ('default-network', 'default', 'default', 'My first node');" 
    13 echo "INSERT INTO servers (server_id, is_default_server, name) VALUES ('localhost', true, default);" 
     14echo "INSERT INTO virtual_hosts (virtual_host_id, hostname, default_network) VALUES ('DEFAULT_VHOST', 'localhost', 'default-network');"; 
     15echo "INSERT INTO server (server_id, default_virtual_host) VALUES ('SERVER_ID', 'DEFAULT_VHOST');"; 
     16echo "INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_SYSADMIN', 'Server');"; 
     17echo "INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_SYSADMIN', 'Network');"; 
    1418 
    1519pg_dump -a -D --username=wifidog -t schema_info 

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

    r1146 r1250  
    1313read delete_confirm 
    1414if [ $delete_confirm = "y" -o $delete_confirm = "Y" ] ; then 
    15 cmd="dropdb -U $USERNAME $DATABASE_NAME"  
     15cmd="dropdb -U $SUPERUSER $DATABASE_NAME"  
    1616echo $cmd 
    1717$cmd 
    … …  
    5252 
    5353 
    54 echo "Do I need to Adding the plpgsql language to database (as the admin user)? (y/n)" 
     54echo "Do I need to add the plpgsql language to database (as the admin user)? (y/n)" 
    5555read add_plpgsql_confirm 
    5656if [ $add_plpgsql_confirm = "y" -o $add_plpgsql_confirm = "Y" ] ; then 

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

    r1176 r1250  
    55 
    66SET client_encoding = 'UTF8'; 
    7 SET check_function_bodies = false; 
    8 SET client_min_messages = warning; 
     7SET standard_conforming_strings = off; 
     8SET check_function_bodies = false; 
     9SET client_min_messages = warning; 
     10SET escape_string_warning = off; 
    911 
    1012SET search_path = public, pg_catalog; 
    … …  
    2830 
    2931SET client_encoding = 'UTF8'; 
    30 SET check_function_bodies = false; 
    31 SET client_min_messages = warning; 
     32SET standard_conforming_strings = off; 
     33SET check_function_bodies = false; 
     34SET client_min_messages = warning; 
     35SET escape_string_warning = off; 
    3236 
    3337SET search_path = public, pg_catalog; 
    … …  
    8286 
    8387SET client_encoding = 'UTF8'; 
    84 SET check_function_bodies = false; 
    85 SET client_min_messages = warning; 
     88SET standard_conforming_strings = off; 
     89SET check_function_bodies = false; 
     90SET client_min_messages = warning; 
     91SET escape_string_warning = off; 
    8692 
    8793SET search_path = public, pg_catalog; 
    … …  
    108114 
    109115SET client_encoding = 'UTF8'; 
    110 SET check_function_bodies = false; 
    111 SET client_min_messages = warning; 
     116SET standard_conforming_strings = off; 
     117SET check_function_bodies = false; 
     118SET client_min_messages = warning; 
     119SET escape_string_warning = off; 
    112120 
    113121SET search_path = public, pg_catalog; 
    … …  
    139147 
    140148SET client_encoding = 'UTF8'; 
    141 SET check_function_bodies = false; 
    142 SET client_min_messages = warning; 
     149SET standard_conforming_strings = off; 
     150SET check_function_bodies = false; 
     151SET client_min_messages = warning; 
     152SET escape_string_warning = off; 
    143153 
    144154SET search_path = public, pg_catalog; 
    … …  
    157167-- 
    158168 
    159 INSERT INTO networks (network_id, is_default_network, network_authenticator_class, network_authenticator_params) VALUES ('default-network', true, 'AuthenticatorLocalUser', '\'default-network\''); 
     169-- 
     170-- PostgreSQL database dump 
     171-- 
     172 
     173SET client_encoding = 'UTF8'; 
     174SET standard_conforming_strings = off; 
     175SET check_function_bodies = false; 
     176SET client_min_messages = warning; 
     177SET escape_string_warning = off; 
     178 
     179SET search_path = public, pg_catalog; 
     180 
     181-- 
     182-- Data for Name: stakeholder_types; Type: TABLE DATA; Schema: public; Owner: wifidog 
     183-- 
     184 
     185INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Node'); 
     186INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Network'); 
     187INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Server'); 
     188INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Content'); 
     189 
     190 
     191-- 
     192-- PostgreSQL database dump complete 
     193-- 
     194 
     195INSERT INTO networks (network_id, network_authenticator_class, network_authenticator_params) VALUES ('default-network', 'AuthenticatorLocalUser', '\'default-network\''); 
    160196INSERT INTO nodes (network_id, node_id, gw_id, name) VALUES ('default-network', 'default', 'default', 'My first node'); 
    161 INSERT INTO servers (server_id, is_default_server, name) VALUES ('localhost', true, default); 
    162 -- 
    163 -- PostgreSQL database dump 
    164 -- 
    165  
    166 SET client_encoding = 'UTF8'; 
    167 SET check_function_bodies = false; 
    168 SET client_min_messages = warning; 
     197INSERT INTO virtual_hosts (virtual_host_id, hostname, default_network) VALUES ('DEFAULT_VHOST', 'localhost', 'default-network'); 
     198INSERT INTO server (server_id, default_virtual_host) VALUES ('SERVER_ID', 'DEFAULT_VHOST'); 
     199INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_SYSADMIN', 'Server'); 
     200INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_SYSADMIN', 'Network'); 
     201-- 
     202-- PostgreSQL database dump 
     203-- 
     204 
     205SET client_encoding = 'UTF8'; 
     206SET standard_conforming_strings = off; 
     207SET check_function_bodies = false; 
     208SET client_min_messages = warning; 
     209SET escape_string_warning = off; 
    169210 
    170211SET search_path = public, pg_catalog; 
    … …  
    174215-- 
    175216 
    176 INSERT INTO schema_info (tag, value) VALUES ('schema_version', '53'); 
    177  
    178  
    179 -- 
    180 -- PostgreSQL database dump complete 
    181 -- 
    182  
    183 -- 
    184 -- PostgreSQL database dump 
    185 -- 
    186  
    187 SET client_encoding = 'UTF8'; 
    188 SET check_function_bodies = false; 
    189 SET client_min_messages = warning; 
     217INSERT INTO schema_info (tag, value) VALUES ('schema_version', '54'); 
     218 
     219 
     220-- 
     221-- PostgreSQL database dump complete 
     222-- 
     223 
     224-- 
     225-- PostgreSQL database dump 
     226-- 
     227 
     228SET client_encoding = 'UTF8'; 
     229SET standard_conforming_strings = off; 
     230SET check_function_bodies = false; 
     231SET client_min_messages = warning; 
     232SET escape_string_warning = off; 
    190233 
    191234SET search_path = public, pg_catalog; 

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

    r1176 r1250  
    44 
    55SET client_encoding = 'UTF8'; 
     6SET standard_conforming_strings = off; 
    67SET check_function_bodies = false; 
    78SET client_min_messages = warning; 
    8  
    9 -- 
    10 -- Name: wifidog; Type: DATABASE; Schema: -; Owner: wifidog 
     9SET escape_string_warning = off; 
     10 
     11-- 
     12-- Name: wifidog; Type: DATABASE; Schema: -; Owner: - 
    1113-- 
    1214 
    … …  
    1719 
    1820SET client_encoding = 'UTF8'; 
     21SET standard_conforming_strings = off; 
    1922SET check_function_bodies = false; 
    2023SET client_min_messages = warning; 
    21  
    22 -- 
    23 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres 
     24SET escape_string_warning = off; 
     25 
     26-- 
     27-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: - 
    2428-- 
    2529 
    … …  
    2731 
    2832 
     33-- 
     34-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - 
     35-- 
     36 
     37CREATE PROCEDURAL LANGUAGE plpgsql; 
     38 
     39 
    2940SET search_path = public, pg_catalog; 
    3041 
    … …  
    3445 
    3546-- 
    36 -- Name: administrators; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    37 -- 
    38  
    39 CREATE TABLE administrators ( 
    40     user_id character varying(45) DEFAULT ''::character varying NOT NULL 
    41 ); 
    42  
    43  
    44 -- 
    45 -- Name: connections; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     47-- Name: connections; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    4648-- 
    4749 
    4850CREATE TABLE connections ( 
    49     conn_id serial NOT NULL, 
     51    conn_id integer NOT NULL, 
    5052    token character varying(32) DEFAULT ''::character varying NOT NULL, 
    5153    token_status character varying(10) DEFAULT 'UNUSED'::character varying NOT NULL, 
    … …  
    6466 
    6567-- 
    66 -- Name: content; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     68-- Name: connections_conn_id_seq; Type: SEQUENCE; Schema: public; Owner: - 
     69-- 
     70 
     71CREATE SEQUENCE connections_conn_id_seq 
     72    INCREMENT BY 1 
     73    NO MAXVALUE 
     74    NO MINVALUE 
     75    CACHE 1; 
     76 
     77 
     78-- 
     79-- Name: connections_conn_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - 
     80-- 
     81 
     82ALTER SEQUENCE connections_conn_id_seq OWNED BY connections.conn_id; 
     83 
     84 
     85-- 
     86-- Name: content; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    6787-- 
    6888 
    … …  
    83103 
    84104-- 
    85 -- Name: content_available_display_areas; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     105-- Name: content_available_display_areas; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    86106-- 
    87107 
    … …  
    92112 
    93113-- 
    94 -- Name: content_available_display_pages; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     114-- Name: content_available_display_pages; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    95115-- 
    96116 
    … …  
    103123 
    104124-- 
    105 -- Name: content_clickthrough_log; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     125-- Name: content_clickthrough_log; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    106126-- 
    107127 
    … …  
    121141 
    122142-- 
    123 -- Name: content_display_log; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     143-- Name: content_display_log; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    124144-- 
    125145 
    … …  
    135155 
    136156-- 
    137 -- Name: content_embedded_content; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     157-- Name: content_embedded_content; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    138158-- 
    139159 
    … …  
    148168 
    149169-- 
    150 -- Name: content_file; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     170-- Name: content_file; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    151171-- 
    152172 
    … …  
    163183 
    164184-- 
    165 -- Name: content_file_image; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     185-- Name: content_file_image; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    166186-- 
    167187 
    … …  
    175195 
    176196-- 
    177 -- Name: content_flickr_photostream; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     197-- Name: content_flickr_photostream; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    178198-- 
    179199 
    … …  
    204224 
    205225-- 
    206 -- Name: content_group; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     226-- Name: content_group; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    207227-- 
    208228 
    … …  
    218238 
    219239-- 
    220 -- Name: content_group_element; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     240-- Name: content_group_element; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    221241-- 
    222242 
    … …  
    233253 
    234254-- 
    235 -- Name: content_group_element_has_allowed_nodes; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     255-- Name: content_group_element_has_allowed_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    236256-- 
    237257 
    … …  
    244264 
    245265-- 
    246 -- Name: content_has_owners; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     266-- Name: content_has_owners; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    247267-- 
    248268 
    … …  
    256276 
    257277-- 
    258 -- Name: content_iframe; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     278-- Name: content_iframe; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    259279-- 
    260280 
    … …  
    270290 
    271291-- 
    272 -- Name: content_key_value_pairs; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     292-- Name: content_key_value_pairs; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    273293-- 
    274294 
    … …  
    283303 
    284304-- 
    285 -- Name: content_langstring_entries; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     305-- Name: content_langstring_entries; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    286306-- 
    287307 
    … …  
    295315 
    296316-- 
    297 -- Name: content_rss_aggregator; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     317-- Name: content_rss_aggregator; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    298318-- 
    299319 
    … …  
    310330 
    311331-- 
    312 -- Name: content_rss_aggregator_feeds; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     332-- Name: content_rss_aggregator_feeds; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    313333-- 
    314334 
    … …  
    325345 
    326346-- 
    327 -- Name: content_shoutbox_messages; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     347-- Name: content_shoutbox_messages; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    328348-- 
    329349 
    … …  
    338358 
    339359-- 
    340 -- Name: content_type_filters; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     360-- Name: content_type_filters; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    341361-- 
    342362 
    … …  
    352372 
    353373-- 
    354 -- Name: locales; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     374-- Name: locales; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    355375-- 
    356376 
    … …  
    361381 
    362382-- 
    363 -- Name: network_has_content; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     383-- Name: network_has_content; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    364384-- 
    365385 
    … …  
    377397 
    378398-- 
    379 -- Name: network_has_profile_templates; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     399-- Name: network_has_profile_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    380400-- 
    381401 
    … …  
    386406 
    387407 
     408-- 
     409-- Name: stakeholders; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     410-- 
     411 
     412CREATE TABLE stakeholders ( 
     413    user_id text NOT NULL, 
     414    role_id text NOT NULL, 
     415    object_id text NOT NULL, 
     416    CONSTRAINT user_has_roles_objct_id_not_empty_string CHECK ((object_id <> ''::text)) 
     417); 
     418 
     419 
     420-- 
     421-- Name: network_stakeholders; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     422-- 
     423 
     424CREATE TABLE network_stakeholders ( 
     425) 
     426INHERITS (stakeholders); 
     427 
     428 
    388429SET default_with_oids = true; 
    389430 
    390431-- 
    391 -- Name: network_stakeholders; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    392 -- 
    393  
    394 CREATE TABLE network_stakeholders ( 
    395     network_id text NOT NULL, 
    396     user_id character varying(45) NOT NULL, 
    397     is_admin boolean DEFAULT false NOT NULL, 
    398     is_stat_viewer boolean DEFAULT false NOT NULL 
    399 ); 
    400  
    401  
    402 -- 
    403 -- Name: networks; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     432-- Name: networks; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    404433-- 
    405434 
    … …  
    408437    network_authenticator_class text NOT NULL, 
    409438    network_authenticator_params text, 
    410     is_default_network boolean DEFAULT false NOT NULL, 
    411439    name text DEFAULT 'Unnamed network'::text NOT NULL, 
    412440    creation_date date DEFAULT now() NOT NULL, 
    … …  
    433461 
    434462-- 
    435 -- Name: node_deployment_status; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     463-- Name: node_deployment_status; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    436464-- 
    437465 
    … …  
    444472 
    445473-- 
    446 -- Name: node_has_content; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     474-- Name: node_has_content; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    447475-- 
    448476 
    … …  
    457485 
    458486 
    459 -- 
    460 -- Name: node_stakeholders; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     487SET default_with_oids = false; 
     488 
     489-- 
     490-- Name: node_stakeholders; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    461491-- 
    462492 
    463493CREATE TABLE node_stakeholders ( 
    464     node_id character varying(32) NOT NULL, 
    465     user_id character varying(45) NOT NULL, 
    466     is_owner boolean DEFAULT false NOT NULL, 
    467     is_tech_officer boolean DEFAULT false NOT NULL 
    468 ); 
    469  
    470  
    471 -- 
    472 -- Name: nodes; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     494) 
     495INHERITS (stakeholders); 
     496 
     497 
     498SET default_with_oids = true; 
     499 
     500-- 
     501-- Name: nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    473502-- 
    474503 
    … …  
    510539 
    511540-- 
    512 -- Name: profile_fields; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     541-- Name: permissions; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     542-- 
     543 
     544CREATE TABLE permissions ( 
     545    permission_id text NOT NULL, 
     546    stakeholder_type_id text NOT NULL, 
     547    CONSTRAINT permission_rules_id_not_empty_string CHECK ((permission_id <> ''::text)) 
     548); 
     549 
     550 
     551-- 
     552-- Name: profile_fields; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    513553-- 
    514554 
    … …  
    523563 
    524564-- 
    525 -- Name: profile_template_fields; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     565-- Name: profile_template_fields; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    526566-- 
    527567 
    … …  
    538578 
    539579-- 
    540 -- Name: profile_templates; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     580-- Name: profile_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    541581-- 
    542582 
    … …  
    549589 
    550590-- 
    551 -- Name: profiles; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     591-- Name: profiles; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    552592-- 
    553593 
    … …  
    560600 
    561601 
     602-- 
     603-- Name: role_has_permissions; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     604-- 
     605 
     606CREATE TABLE role_has_permissions ( 
     607    role_id text NOT NULL, 
     608    permission_id text NOT NULL 
     609); 
     610 
     611 
     612-- 
     613-- Name: roles; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     614-- 
     615 
     616CREATE TABLE roles ( 
     617    role_id text NOT NULL, 
     618    role_description_content_id text, 
     619    is_system_role boolean DEFAULT false NOT NULL, 
     620    stakeholder_type_id text NOT NULL, 
     621    role_creation_date timestamp without time zone DEFAULT now(), 
     622    CONSTRAINT roles_rules_id_not_empty_string CHECK ((role_id <> ''::text)) 
     623); 
     624 
     625 
    562626SET default_with_oids = true; 
    563627 
    564628-- 
    565 -- Name: schema_info; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     629-- Name: schema_info; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    566630-- 
    567631 
    … …  
    572636 
    573637 
    574 -- 
    575 -- Name: servers; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
    576 -- 
    577  
    578 CREATE TABLE servers ( 
     638SET default_with_oids = false; 
     639 
     640-- 
     641-- Name: server; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     642-- 
     643 
     644CREATE TABLE server ( 
    579645    server_id text NOT NULL, 
    580     is_default_server boolean DEFAULT false NOT NULL, 
    581     name text DEFAULT 'Unnamed server'::text NOT NULL, 
    582646    creation_date date DEFAULT now() NOT NULL, 
    583     hostname text DEFAULT 'localhost'::text NOT NULL, 
    584     ssl_available boolean DEFAULT false NOT NULL, 
    585     gmaps_api_key text, 
    586     CONSTRAINT servers_hostname CHECK ((name <> ''::text)), 
    587     CONSTRAINT servers_name CHECK ((name <> ''::text)) 
    588 ); 
    589  
    590  
    591 -- 
    592 -- Name: token_status; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     647    default_virtual_host text NOT NULL 
     648); 
     649 
     650 
     651-- 
     652-- Name: server_stakeholders; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     653-- 
     654 
     655CREATE TABLE server_stakeholders ( 
     656) 
     657INHERITS (stakeholders); 
     658 
     659 
     660-- 
     661-- Name: stakeholder_types; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     662-- 
     663 
     664CREATE TABLE stakeholder_types ( 
     665    stakeholder_type_id text NOT NULL, 
     666    CONSTRAINT stakeholder_types_id_not_empty_string CHECK ((stakeholder_type_id <> ''::text)) 
     667); 
     668 
     669 
     670SET default_with_oids = true; 
     671 
     672-- 
     673-- Name: token_status; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    593674-- 
    594675 
    … …  
    599680 
    600681-- 
    601 -- Name: user_has_content; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     682-- Name: user_has_content; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    602683-- 
    603684 
    … …  
    612693 
    613694-- 
    614 -- Name: user_has_profiles; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     695-- Name: user_has_profiles; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    615696-- 
    616697 
    … …  
    624705 
    625706-- 
    626 -- Name: users; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     707-- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    627708-- 
    628709 
    … …  
    645726 
    646727-- 
    647 -- Name: venue_types; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     728-- Name: venue_types; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    648729-- 
    649730 
    … …  
    654735 
    655736-- 
    656 -- Name: venues; Type: TABLE; Schema: public; Owner: wifidog; Tablespace:  
     737-- Name: venues; Type: TABLE; Schema: public; Owner: -; Tablespace:  
    657738-- 
    658739 
    … …  
    664745 
    665746-- 
    666 -- Name: administrators_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
    667 -- 
    668  
    669 ALTER TABLE ONLY administrators 
    670     ADD CONSTRAINT administrators_pkey PRIMARY KEY (user_id); 
    671  
    672  
    673 -- 
    674 -- Name: connections_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     747-- Name: virtual_hosts; Type: TABLE; Schema: public; Owner: -; Tablespace:  
     748-- 
     749 
     750CREATE TABLE virtual_hosts ( 
     751    virtual_host_id text NOT NULL, 
     752    hostname text NOT NULL, 
     753    creation_date date DEFAULT now() NOT NULL, 
     754    ssl_available boolean DEFAULT false NOT NULL, 
     755    gmaps_api_key text, 
     756    default_network text NOT NULL, 
     757    CONSTRAINT virtual_hosts_hostname_check CHECK ((hostname <> ''::text)) 
     758); 
     759 
     760 
     761-- 
     762-- Name: conn_id; Type: DEFAULT; Schema: public; Owner: - 
     763-- 
     764 
     765ALTER TABLE connections ALTER COLUMN conn_id SET DEFAULT nextval('connections_conn_id_seq'::regclass); 
     766 
     767 
     768-- 
     769-- Name: connections_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    675770-- 
    676771 
    … …  
    680775 
    681776-- 
    682 -- Name: content_available_display_areas_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     777-- Name: content_available_display_areas_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    683778-- 
    684779 
    … …  
    688783 
    689784-- 
    690 -- Name: content_clickthrough_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     785-- Name: content_clickthrough_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    691786-- 
    692787 
    … …  
    696791 
    697792-- 
    698 -- Name: content_display_location_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     793-- Name: content_display_location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    699794-- 
    700795 
    … …  
    704799 
    705800-- 
    706 -- Name: content_display_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     801-- Name: content_display_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    707802-- 
    708803 
    … …  
    712807 
    713808-- 
    714 -- Name: content_group_element_has_allowed_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     809-- Name: content_group_element_has_allowed_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    715810-- 
    716811 
    … …  
    720815 
    721816-- 
    722 -- Name: content_group_element_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     817-- Name: content_group_element_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    723818-- 
    724819 
    … …  
    728823 
    729824-- 
    730 -- Name: content_group_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     825-- Name: content_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    731826-- 
    732827 
    … …  
    736831 
    737832-- 
    738 -- Name: content_has_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     833-- Name: content_has_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    739834-- 
    740835 
    … …  
    744839 
    745840-- 
    746 -- Name: content_key_value_pairs_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     841-- Name: content_key_value_pairs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    747842-- 
    748843 
    … …  
    752847 
    753848-- 
    754 -- Name: content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     849-- Name: content_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    755850-- 
    756851 
    … …  
    760855 
    761856-- 
    762 -- Name: content_rss_aggregator_feeds_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     857-- Name: content_rss_aggregator_feeds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    763858-- 
    764859 
    … …  
    768863 
    769864-- 
    770 -- Name: content_rss_aggregator_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     865-- Name: content_rss_aggregator_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    771866-- 
    772867 
    … …  
    776871 
    777872-- 
    778 -- Name: content_shoutbox_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     873-- Name: content_shoutbox_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    779874-- 
    780875 
    … …  
    784879 
    785880-- 
    786 -- Name: content_type_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     881-- Name: content_type_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    787882-- 
    788883 
    … …  
    792887 
    793888-- 
    794 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     889-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    795890-- 
    796891 
    … …  
    800895 
    801896-- 
    802 -- Name: flickr_photostream_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     897-- Name: flickr_photostream_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    803898-- 
    804899 
    … …  
    808903 
    809904-- 
    810 -- Name: iframes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     905-- Name: iframes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    811906-- 
    812907 
    … …  
    816911 
    817912-- 
    818 -- Name: langstring_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     913-- Name: langstring_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    819914-- 
    820915 
    … …  
    824919 
    825920-- 
    826 -- Name: locales_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     921-- Name: locales_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    827922-- 
    828923 
    … …  
    832927 
    833928-- 
    834 -- Name: network_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     929-- Name: network_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    835930-- 
    836931 
    … …  
    840935 
    841936-- 
    842 -- Name: network_has_profile_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     937-- Name: network_has_profile_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    843938-- 
    844939 
    … …  
    848943 
    849944-- 
    850 -- Name: network_stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     945-- Name: network_stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    851946-- 
    852947 
    853948ALTER TABLE ONLY network_stakeholders 
    854     ADD CONSTRAINT network_stakeholders_pkey PRIMARY KEY (network_id, user_id); 
    855  
    856  
    857 -- 
    858 -- Name: networks_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     949    ADD CONSTRAINT network_stakeholders_pkey PRIMARY KEY (user_id, role_id, object_id); 
     950 
     951 
     952-- 
     953-- Name: networks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    859954-- 
    860955 
    … …  
    864959 
    865960-- 
    866 -- Name: node_deployment_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     961-- Name: node_deployment_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    867962-- 
    868963 
    … …  
    872967 
    873968-- 
    874 -- Name: node_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     969-- Name: node_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    875970-- 
    876971 
    … …  
    880975 
    881976-- 
    882 -- Name: node_stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     977-- Name: node_stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    883978-- 
    884979 
    885980ALTER TABLE ONLY node_stakeholders 
    886     ADD CONSTRAINT node_stakeholders_pkey PRIMARY KEY (node_id, user_id); 
    887  
    888  
    889 -- 
    890 -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     981    ADD CONSTRAINT node_stakeholders_pkey PRIMARY KEY (user_id, role_id, object_id); 
     982 
     983 
     984-- 
     985-- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    891986-- 
    892987 
    … …  
    896991 
    897992-- 
    898 -- Name: pictures_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     993-- Name: permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     994-- 
     995 
     996ALTER TABLE ONLY permissions 
     997    ADD CONSTRAINT permissions_pkey PRIMARY KEY (permission_id); 
     998 
     999 
     1000-- 
     1001-- Name: pictures_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    8991002-- 
    9001003 
    … …  
    9041007 
    9051008-- 
    906 -- Name: profile_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1009-- Name: profile_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9071010-- 
    9081011 
    … …  
    9121015 
    9131016-- 
    914 -- Name: profile_template_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1017-- Name: profile_template_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9151018-- 
    9161019 
    … …  
    9201023 
    9211024-- 
    922 -- Name: profile_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1025-- Name: profile_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9231026-- 
    9241027 
    … …  
    9281031 
    9291032-- 
    930 -- Name: profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1033-- Name: profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9311034-- 
    9321035 
    … …  
    9361039 
    9371040-- 
    938 -- Name: schema_info_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1041-- Name: role_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1042-- 
     1043 
     1044ALTER TABLE ONLY role_has_permissions 
     1045    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (role_id, permission_id); 
     1046 
     1047 
     1048-- 
     1049-- Name: roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1050-- 
     1051 
     1052ALTER TABLE ONLY roles 
     1053    ADD CONSTRAINT roles_pkey PRIMARY KEY (role_id); 
     1054 
     1055 
     1056-- 
     1057-- Name: schema_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9391058-- 
    9401059 
    … …  
    9441063 
    9451064-- 
    946 -- Name: servers_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
    947 -- 
    948  
    949 ALTER TABLE ONLY servers 
    950     ADD CONSTRAINT servers_pkey PRIMARY KEY (server_id); 
    951  
    952  
    953 -- 
    954 -- Name: token_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1065-- Name: server_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1066-- 
     1067 
     1068ALTER TABLE ONLY server 
     1069    ADD CONSTRAINT server_pkey PRIMARY KEY (server_id); 
     1070 
     1071 
     1072-- 
     1073-- Name: server_stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1074-- 
     1075 
     1076ALTER TABLE ONLY server_stakeholders 
     1077    ADD CONSTRAINT server_stakeholders_pkey PRIMARY KEY (user_id, role_id, object_id); 
     1078 
     1079 
     1080-- 
     1081-- Name: stakeholder_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1082-- 
     1083 
     1084ALTER TABLE ONLY stakeholder_types 
     1085    ADD CONSTRAINT stakeholder_types_pkey PRIMARY KEY (stakeholder_type_id); 
     1086 
     1087 
     1088-- 
     1089-- Name: stakeholders_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1090-- 
     1091 
     1092ALTER TABLE ONLY stakeholders 
     1093    ADD CONSTRAINT stakeholders_pkey PRIMARY KEY (user_id, role_id, object_id); 
     1094 
     1095 
     1096-- 
     1097-- Name: token_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9551098-- 
    9561099 
    … …  
    9601103 
    9611104-- 
    962 -- Name: user_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1105-- Name: user_has_content_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9631106-- 
    9641107 
    … …  
    9681111 
    9691112-- 
    970 -- Name: user_has_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1113-- Name: user_has_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9711114-- 
    9721115 
    … …  
    9761119 
    9771120-- 
    978 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1121-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9791122-- 
    9801123 
    … …  
    9841127 
    9851128-- 
    986 -- Name: venue_types_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog; Tablespace:  
     1129-- Name: venue_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
    9871130-- 
    9881131 
    … …  
    9921135 
    9931136-- 
    994 -- Name: idx_connections_node_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1137-- Name: virtual_hosts_hostname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1138-- 
     1139 
     1140ALTER TABLE ONLY virtual_hosts 
     1141    ADD CONSTRAINT virtual_hosts_hostname_key UNIQUE (hostname); 
     1142 
     1143 
     1144-- 
     1145-- Name: virtual_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:  
     1146-- 
     1147 
     1148ALTER TABLE ONLY virtual_hosts 
     1149    ADD CONSTRAINT virtual_hosts_pkey PRIMARY KEY (virtual_host_id); 
     1150 
     1151 
     1152-- 
     1153-- Name: idx_connections_node_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    9951154-- 
    9961155 
    … …  
    9991158 
    10001159-- 
    1001 -- Name: idx_connections_user_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1160-- Name: idx_connections_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10021161-- 
    10031162 
    … …  
    10061165 
    10071166-- 
    1008 -- Name: idx_connections_user_mac; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1167-- Name: idx_connections_user_mac; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10091168-- 
    10101169 
    … …  
    10131172 
    10141173-- 
    1015 -- Name: idx_content_group_element_content_group_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1174-- Name: idx_content_group_element_content_group_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10161175-- 
    10171176 
    … …  
    10201179 
    10211180-- 
    1022 -- Name: idx_content_group_element_valid_from_timestamp; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1181-- Name: idx_content_group_element_valid_from_timestamp; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10231182-- 
    10241183 
    … …  
    10271186 
    10281187-- 
    1029 -- Name: idx_content_group_element_valid_until_timestamp; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1188-- Name: idx_content_group_element_valid_until_timestamp; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10301189-- 
    10311190 
    … …  
    10341193 
    10351194-- 
    1036 -- Name: idx_gw_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1195-- Name: idx_gw_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10371196-- 
    10381197 
    … …  
    10411200 
    10421201-- 
    1043 -- Name: idx_token; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1202-- Name: idx_token; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10441203-- 
    10451204 
    … …  
    10481207 
    10491208-- 
    1050 -- Name: idx_token_status_and_user_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1209-- Name: idx_token_status_and_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10511210-- 
    10521211 
    … …  
    10551214 
    10561215-- 
    1057 -- Name: idx_unique_username_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1216-- Name: idx_unique_username_and_account_origin; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10581217-- 
    10591218 
    … …  
    10621221 
    10631222-- 
    1064 -- Name: profile_template_fields_semantic_id; Type: INDEX; Schema: public; Owner: wifidog; Tablespace:  
     1223-- Name: profile_template_fields_semantic_id; Type: INDEX; Schema: public; Owner: -; Tablespace:  
    10651224-- 
    10661225 
    … …  
    10691228 
    10701229-- 
    1071 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1230-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    10721231-- 
    10731232 
    … …  
    10771236 
    10781237-- 
    1079 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1238-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    10801239-- 
    10811240 
    … …  
    10851244 
    10861245-- 
    1087 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1246-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    10881247-- 
    10891248 
    … …  
    10931252 
    10941253-- 
    1095 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1254-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    10961255-- 
    10971256 
    … …  
    11011260 
    11021261-- 
    1103 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1262-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11041263-- 
    11051264 
    … …  
    11091268 
    11101269-- 
    1111 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1270-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11121271-- 
    11131272 
    … …  
    11171276 
    11181277-- 
    1119 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1278-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11201279-- 
    11211280 
    … …  
    11251284 
    11261285-- 
    1127 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1286-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11281287-- 
    11291288 
    … …  
    11331292 
    11341293-- 
    1135 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1294-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11361295-- 
    11371296 
    … …  
    11411300 
    11421301-- 
    1143 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1302-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11441303-- 
    11451304 
    … …  
    11491308 
    11501309-- 
    1151 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1310-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11521311-- 
    11531312 
    … …  
    11571316 
    11581317-- 
    1159 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1318-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11601319-- 
    11611320 
    … …  
    11651324 
    11661325-- 
    1167 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1326-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11681327-- 
    11691328 
    … …  
    11731332 
    11741333-- 
    1175 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1334-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11761335-- 
    11771336 
    … …  
    11811340 
    11821341-- 
    1183 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1342-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11841343-- 
    11851344 
    … …  
    11891348 
    11901349-- 
    1191 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1350-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: - 
    11921351-- 
    11931352 
    … …  
    11971356 
    11981357-- 
    1199 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1358-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12001359-- 
    12011360 
    … …  
    12051364 
    12061365-- 
    1207 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1366-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12081367-- 
    12091368 
    … …  
    12131372 
    12141373-- 
    1215 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1374-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12161375-- 
    12171376 
    … …  
    12211380 
    12221381-- 
    1223 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1382-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12241383-- 
    12251384 
    … …  
    12291388 
    12301389-- 
    1231 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1390-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12321391-- 
    12331392 
    … …  
    12371396 
    12381397-- 
    1239 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1398-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12401399-- 
    12411400 
    … …  
    12451404 
    12461405-- 
    1247 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1406-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12481407-- 
    12491408 
    … …  
    12531412 
    12541413-- 
    1255 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1414-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12561415-- 
    12571416 
    … …  
    12611420 
    12621421-- 
    1263 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1422-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12641423-- 
    12651424 
    … …  
    12691428 
    12701429-- 
    1271 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1430-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12721431-- 
    12731432 
    … …  
    12771436 
    12781437-- 
    1279 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1438-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12801439-- 
    12811440 
    … …  
    12851444 
    12861445-- 
    1287 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1446-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12881447-- 
    12891448 
    … …  
    12931452 
    12941453-- 
    1295 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1454-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: - 
    12961455-- 
    12971456 
    … …  
    13011460 
    13021461-- 
    1303 -- Name: $5; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1462-- Name: $5; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13041463-- 
    13051464 
    … …  
    13091468 
    13101469-- 
    1311 -- Name: account_origin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1470-- Name: account_origin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13121471-- 
    13131472 
    … …  
    13171476 
    13181477-- 
    1319 -- Name: administrators_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1320 -- 
    1321  
    1322 ALTER TABLE ONLY administrators 
    1323     ADD CONSTRAINT administrators_ibfk_1 FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    1324  
    1325  
    1326 -- 
    1327 -- Name: content_clickthrough_log_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1478-- Name: content_clickthrough_log_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13281479-- 
    13291480 
    … …  
    13331484 
    13341485-- 
    1335 -- Name: content_clickthrough_log_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1486-- Name: content_clickthrough_log_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13361487-- 
    13371488 
    … …  
    13411492 
    13421493-- 
    1343 -- Name: content_clickthrough_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1494-- Name: content_clickthrough_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13441495-- 
    13451496 
    … …  
    13491500 
    13501501-- 
    1351 -- Name: content_key_value_pairs_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1502-- Name: content_key_value_pairs_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13521503-- 
    13531504 
    … …  
    13571508 
    13581509-- 
    1359 -- Name: content_shoutbox_messages_author_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1510-- Name: content_shoutbox_messages_author_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13601511-- 
    13611512 
    … …  
    13651516 
    13661517-- 
    1367 -- Name: content_shoutbox_messages_message_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1518-- Name: content_shoutbox_messages_message_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13681519-- 
    13691520 
    … …  
    13731524 
    13741525-- 
    1375 -- Name: content_shoutbox_messages_origin_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1526-- Name: content_shoutbox_messages_origin_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13761527-- 
    13771528 
    … …  
    13811532 
    13821533-- 
    1383 -- Name: content_shoutbox_messages_shoutbox_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1534-- Name: content_shoutbox_messages_shoutbox_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13841535-- 
    13851536 
    … …  
    13891540 
    13901541-- 
    1391 -- Name: display_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1542-- Name: display_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    13921543-- 
    13931544 
    … …  
    13971548 
    13981549-- 
    1399 -- Name: display_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1550-- Name: display_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14001551-- 
    14011552 
    … …  
    14051556 
    14061557-- 
    1407 -- Name: fk_network; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1558-- Name: fk_network; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14081559-- 
    14091560 
    14101561ALTER TABLE ONLY network_stakeholders 
    1411     ADD CONSTRAINT fk_network FOREIGN KEY (network_id) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    1412  
    1413  
    1414 -- 
    1415 -- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1562    ADD CONSTRAINT fk_network FOREIGN KEY (object_id) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1563 
     1564 
     1565-- 
     1566-- Name: fk_network; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1567-- 
     1568 
     1569ALTER TABLE ONLY server_stakeholders 
     1570    ADD CONSTRAINT fk_network FOREIGN KEY (object_id) REFERENCES server(server_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1571 
     1572 
     1573-- 
     1574-- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14161575-- 
    14171576 
    … …  
    14211580 
    14221581-- 
    1423 -- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1582-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14241583-- 
    14251584 
    … …  
    14291588 
    14301589-- 
    1431 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1590-- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1591-- 
     1592 
     1593ALTER TABLE ONLY node_stakeholders 
     1594    ADD CONSTRAINT fk_nodes FOREIGN KEY (object_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1595 
     1596 
     1597-- 
     1598-- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14321599-- 
    14331600 
    … …  
    14371604 
    14381605-- 
    1439 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1440 -- 
    1441  
    1442 ALTER TABLE ONLY node_stakeholders 
    1443     ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    1444  
    1445  
    1446 -- 
    1447 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1448 -- 
    1449  
    1450 ALTER TABLE ONLY network_stakeholders 
    1451     ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    1452  
    1453  
    1454 -- 
    1455 -- Name: fk_venue_types; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1606-- Name: fk_venue_types; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14561607-- 
    14571608 
    … …  
    14611612 
    14621613-- 
    1463 -- Name: flickr_photostream_content_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1614-- Name: flickr_photostream_content_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14641615-- 
    14651616 
    … …  
    14691620 
    14701621-- 
    1471 -- Name: network_has_profile_templates_network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1622-- Name: network_has_profile_templates_network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14721623-- 
    14731624 
    … …  
    14771628 
    14781629-- 
    1479 -- Name: network_has_profile_templates_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1630-- Name: network_has_profile_templates_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14801631-- 
    14811632 
    … …  
    14851636 
    14861637-- 
    1487 -- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1638-- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14881639-- 
    14891640 
    … …  
    14931644 
    14941645-- 
    1495 -- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1646-- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    14961647-- 
    14971648 
    … …  
    15011652 
    15021653-- 
    1503 -- Name: nodes_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
    1504 -- 
    1505  
    1506 ALTER TABLE ONLY node_stakeholders 
    1507     ADD CONSTRAINT nodes_fkey FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 
    1508  
    1509  
    1510 -- 
    1511 -- Name: profile_fields_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1654-- Name: permissions_stakeholder_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1655-- 
     1656 
     1657ALTER TABLE ONLY permissions 
     1658    ADD CONSTRAINT permissions_stakeholder_type_id_fkey FOREIGN KEY (stakeholder_type_id) REFERENCES stakeholder_types(stakeholder_type_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1659 
     1660 
     1661-- 
     1662-- Name: profile_fields_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15121663-- 
    15131664 
    … …  
    15171668 
    15181669-- 
    1519 -- Name: profile_fields_profile_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1670-- Name: profile_fields_profile_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15201671-- 
    15211672 
    … …  
    15251676 
    15261677-- 
    1527 -- Name: profile_fields_profile_template_field_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1678-- Name: profile_fields_profile_template_field_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15281679-- 
    15291680 
    … …  
    15331684 
    15341685-- 
    1535 -- Name: profile_template_fields_admin_label_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1686-- Name: profile_template_fields_admin_label_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15361687-- 
    15371688 
    … …  
    15411692 
    15421693-- 
    1543 -- Name: profile_template_fields_content_type_filter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1694-- Name: profile_template_fields_content_type_filter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15441695-- 
    15451696 
    … …  
    15491700 
    15501701-- 
    1551 -- Name: profile_template_fields_display_label_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1702-- Name: profile_template_fields_display_label_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15521703-- 
    15531704 
    … …  
    15571708 
    15581709-- 
    1559 -- Name: profile_template_fields_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1710-- Name: profile_template_fields_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15601711-- 
    15611712 
    … …  
    15651716 
    15661717-- 
    1567 -- Name: profiles_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1718-- Name: profiles_profile_template_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15681719-- 
    15691720 
    … …  
    15731724 
    15741725-- 
    1575 -- Name: user_has_profiles_profile_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1726-- Name: role_has_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1727-- 
     1728 
     1729ALTER TABLE ONLY role_has_permissions 
     1730    ADD CONSTRAINT role_has_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1731 
     1732 
     1733-- 
     1734-- Name: role_has_permissions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1735-- 
     1736 
     1737ALTER TABLE ONLY role_has_permissions 
     1738    ADD CONSTRAINT role_has_permissions_role_id_fkey FOREIGN KEY (role_id) REFERENCES roles(role_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1739 
     1740 
     1741-- 
     1742-- Name: roles_role_description_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1743-- 
     1744 
     1745ALTER TABLE ONLY roles 
     1746    ADD CONSTRAINT roles_role_description_content_id_fkey FOREIGN KEY (role_description_content_id) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE SET NULL; 
     1747 
     1748 
     1749-- 
     1750-- Name: roles_stakeholder_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1751-- 
     1752 
     1753ALTER TABLE ONLY roles 
     1754    ADD CONSTRAINT roles_stakeholder_type_id_fkey FOREIGN KEY (stakeholder_type_id) REFERENCES stakeholder_types(stakeholder_type_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1755 
     1756 
     1757-- 
     1758-- Name: server_default_virtual_host_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1759-- 
     1760 
     1761ALTER TABLE ONLY server 
     1762    ADD CONSTRAINT server_default_virtual_host_fkey FOREIGN KEY (default_virtual_host) REFERENCES virtual_hosts(virtual_host_id) ON UPDATE CASCADE ON DELETE RESTRICT; 
     1763 
     1764 
     1765-- 
     1766-- Name: stakeholders_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1767-- 
     1768 
     1769ALTER TABLE ONLY stakeholders 
     1770    ADD CONSTRAINT stakeholders_role_id_fkey FOREIGN KEY (role_id) REFERENCES roles(role_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1771 
     1772 
     1773-- 
     1774-- Name: stakeholders_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1775-- 
     1776 
     1777ALTER TABLE ONLY stakeholders 
     1778    ADD CONSTRAINT stakeholders_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 
     1779 
     1780 
     1781-- 
     1782-- Name: user_has_profiles_profile_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15761783-- 
    15771784 
    … …  
    15811788 
    15821789-- 
    1583 -- Name: user_has_profiles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 
     1790-- Name: user_has_profiles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
    15841791-- 
    15851792 
    … …  
    15891796 
    15901797-- 
     1798-- Name: virtual_hosts_default_network_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - 
     1799-- 
     1800 
     1801ALTER TABLE ONLY virtual_hosts 
     1802    ADD CONSTRAINT virtual_hosts_default_network_fkey FOREIGN KEY (default_network) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE RESTRICT; 
     1803 
     1804 
     1805-- 
    15911806-- PostgreSQL database dump complete 
    15921807--