Changeset 1090 for trunk/wifidog-auth/sql/wifidog-postgres-schema.sql
- Timestamp:
- 09/06/06 09:01:54 (7 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/wifidog-auth/sql/wifidog-postgres-schema.sql
r1024 r1090 73 73 description text, 74 74 project_info text, 75 sponsor_info text,76 75 creation_timestamp timestamp without time zone DEFAULT now(), 77 76 is_persistent boolean DEFAULT false, 78 77 long_description text, 78 title_is_displayed boolean DEFAULT true NOT NULL, 79 79 CONSTRAINT content_type_not_empty_string CHECK ((content_type <> ''::text)) 80 80 ); 81 81 82 83 SET default_with_oids = false;84 82 85 83 -- … … 92 90 93 91 94 SET default_with_oids = true;95 96 92 -- 97 93 -- Name: content_available_display_pages; Type: TABLE; Schema: public; Owner: wifidog; Tablespace: … … 102 98 ); 103 99 100 101 SET default_with_oids = false; 102 103 -- 104 -- Name: content_clickthrough_log; Type: TABLE; Schema: public; Owner: wifidog; Tablespace: 105 -- 106 107 CREATE TABLE content_clickthrough_log ( 108 user_id text, 109 content_id text NOT NULL, 110 clickthrough_timestamp timestamp without time zone DEFAULT now() NOT NULL, 111 node_id text NOT NULL, 112 destination_url text NOT NULL, 113 CONSTRAINT content_clickthrough_log_destination_url_check CHECK ((destination_url <> ''::text)) 114 ); 115 116 117 SET default_with_oids = true; 104 118 105 119 -- … … 140 154 url text, 141 155 data_blob oid, 142 local_binary_size bigint 156 local_binary_size bigint, 157 creation_date timestamp without time zone DEFAULT now(), 158 last_update_date timestamp without time zone DEFAULT now() 143 159 ); 144 160 … … 151 167 pictures_id text NOT NULL, 152 168 width integer, 153 height integer 169 height integer, 170 hyperlink_url text 154 171 ); 155 172 … … 209 226 display_order integer DEFAULT 1, 210 227 displayed_content_id text, 211 force_only_allowed_node boolean 228 force_only_allowed_node boolean, 229 valid_from_timestamp timestamp without time zone, 230 valid_until_timestamp timestamp without time zone 212 231 ); 213 232 … … 342 361 gmaps_initial_zoom_level integer, 343 362 gmaps_map_type text DEFAULT 'G_NORMAL_MAP'::text NOT NULL, 344 CONSTRAINT networks_gmaps_map_type_check CHECK ((gmaps_map_type <> ''::text)), 363 theme_pack text, 364 CONSTRAINT networks_gmaps_map_type CHECK ((gmaps_map_type <> ''::text)), 345 365 CONSTRAINT networks_name CHECK ((name <> ''::text)), 346 366 CONSTRAINT networks_network_authenticator_class CHECK ((network_authenticator_class <> ''::text)), … … 435 455 436 456 437 SET default_with_oids = false;438 439 457 -- 440 458 -- Name: servers; Type: TABLE; Schema: public; Owner: wifidog; Tablespace: … … 449 467 ssl_available boolean DEFAULT false NOT NULL, 450 468 gmaps_api_key text, 451 CONSTRAINT servers_name_check CHECK ((name <> ''::text)), 452 CONSTRAINT servers_name_check1 CHECK ((name <> ''::text)) 453 ); 454 455 456 SET default_with_oids = true; 469 CONSTRAINT servers_hostname CHECK ((name <> ''::text)), 470 CONSTRAINT servers_name CHECK ((name <> ''::text)) 471 ); 472 457 473 458 474 -- … … 493 509 website text, 494 510 prefered_locale text, 495 CONSTRAINT check_account_origin_not_empty CHECK ((account_origin <> ''::text)),496 511 CONSTRAINT check_user_not_empty CHECK (((user_id)::text <> ''::text)) 497 512 ); … … 796 811 797 812 -- 813 -- Name: idx_content_group_element_valid_from_timestamp; Type: INDEX; Schema: public; Owner: wifidog; Tablespace: 814 -- 815 816 CREATE INDEX idx_content_group_element_valid_from_timestamp ON content_group_element USING btree (valid_from_timestamp); 817 818 819 -- 820 -- Name: idx_content_group_element_valid_until_timestamp; Type: INDEX; Schema: public; Owner: wifidog; Tablespace: 821 -- 822 823 CREATE INDEX idx_content_group_element_valid_until_timestamp ON content_group_element USING btree (valid_until_timestamp); 824 825 826 -- 798 827 -- Name: idx_token; Type: INDEX; Schema: public; Owner: wifidog; Tablespace: 799 828 -- … … 945 974 946 975 -- 947 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog948 --949 950 ALTER TABLE ONLY network_stakeholders951 ADD CONSTRAINT "$1" FOREIGN KEY (network_id) REFERENCES networks(network_id);952 953 954 --955 976 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 956 977 -- … … 1020 1041 -- 1021 1042 1022 ALTER TABLE ONLY node_stakeholders 1023 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id); 1024 1025 1026 -- 1027 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1028 -- 1029 1030 ALTER TABLE ONLY network_stakeholders 1031 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id); 1043 ALTER TABLE ONLY network_has_content 1044 ADD CONSTRAINT "$2" FOREIGN KEY (display_area) REFERENCES content_available_display_areas(display_area) ON UPDATE CASCADE ON DELETE CASCADE; 1032 1045 1033 1046 … … 1057 1070 1058 1071 -- 1059 -- Name: $ 4; Type: FK CONSTRAINT; Schema: public; Owner: wifidog1060 -- 1061 1062 ALTER TABLE ONLY content1063 ADD CONSTRAINT "$ 4" FOREIGN KEY (sponsor_info) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE RESTRICT;1072 -- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1073 -- 1074 1075 ALTER TABLE ONLY node_has_content 1076 ADD CONSTRAINT "$3" FOREIGN KEY (display_area) REFERENCES content_available_display_areas(display_area) ON UPDATE CASCADE ON DELETE CASCADE; 1064 1077 1065 1078 … … 1077 1090 1078 1091 ALTER TABLE ONLY users 1079 ADD CONSTRAINT account_origin_fkey FOREIGN KEY (account_origin) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE RESTRICT;1092 ADD CONSTRAINT account_origin_fkey FOREIGN KEY (account_origin) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE CASCADE; 1080 1093 1081 1094 … … 1089 1102 1090 1103 -- 1104 -- Name: content_clickthrough_log_content_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1105 -- 1106 1107 ALTER TABLE ONLY content_clickthrough_log 1108 ADD CONSTRAINT content_clickthrough_log_content_id_fkey FOREIGN KEY (content_id) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE CASCADE; 1109 1110 1111 -- 1112 -- Name: content_clickthrough_log_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1113 -- 1114 1115 ALTER TABLE ONLY content_clickthrough_log 1116 ADD CONSTRAINT content_clickthrough_log_node_id_fkey FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 1117 1118 1119 -- 1120 -- Name: content_clickthrough_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1121 -- 1122 1123 ALTER TABLE ONLY content_clickthrough_log 1124 ADD CONSTRAINT content_clickthrough_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 1125 1126 1127 -- 1091 1128 -- Name: display_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1092 1129 -- … … 1105 1142 1106 1143 -- 1144 -- Name: fk_network; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1145 -- 1146 1147 ALTER TABLE ONLY network_stakeholders 1148 ADD CONSTRAINT fk_network FOREIGN KEY (network_id) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE CASCADE; 1149 1150 1151 -- 1107 1152 -- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1108 1153 -- … … 1117 1162 1118 1163 ALTER TABLE ONLY connections 1119 ADD CONSTRAINT fk_nodes FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE RESTRICT;1164 ADD CONSTRAINT fk_nodes FOREIGN KEY (node_id) REFERENCES nodes(node_id) ON UPDATE CASCADE ON DELETE CASCADE; 1120 1165 1121 1166 … … 1125 1170 1126 1171 ALTER TABLE ONLY connections 1127 ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE RESTRICT; 1172 ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 1173 1174 1175 -- 1176 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1177 -- 1178 1179 ALTER TABLE ONLY node_stakeholders 1180 ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 1181 1182 1183 -- 1184 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1185 -- 1186 1187 ALTER TABLE ONLY network_stakeholders 1188 ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE; 1128 1189 1129 1190 … … 1145 1206 1146 1207 -- 1147 -- Name: network_has_content_display_area_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog1148 --1149 1150 ALTER TABLE ONLY network_has_content1151 ADD CONSTRAINT network_has_content_display_area_fkey FOREIGN KEY (display_area) REFERENCES content_available_display_areas(display_area) ON UPDATE CASCADE ON DELETE CASCADE;1152 1153 1154 --1155 -- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog1156 --1157 1158 ALTER TABLE ONLY nodes1159 ADD CONSTRAINT network_id_fkey FOREIGN KEY (network_id) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE RESTRICT;1160 1161 1162 --1163 1208 -- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1164 1209 -- … … 1169 1214 1170 1215 -- 1171 -- Name: n ode_has_content_display_area_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog1172 -- 1173 1174 ALTER TABLE ONLY node _has_content1175 ADD CONSTRAINT n ode_has_content_display_area_fkey FOREIGN KEY (display_area) REFERENCES content_available_display_areas(display_area) ON UPDATE CASCADE ON DELETE CASCADE;1216 -- Name: network_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 1217 -- 1218 1219 ALTER TABLE ONLY nodes 1220 ADD CONSTRAINT network_id_fkey FOREIGN KEY (network_id) REFERENCES networks(network_id) ON UPDATE CASCADE ON DELETE CASCADE; 1176 1221 1177 1222
