Changeset 523 for trunk/wifidog-auth/sql/wifidog-postgres-schema.sql
- Timestamp:
- 03/31/05 21:05:33 (8 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/wifidog-auth/sql/wifidog-postgres-schema.sql
r514 r523 102 102 username text, 103 103 account_origin text, 104 CONSTRAINT check_email_not_empty CHECK (((email)::text <> ''::text)),105 104 CONSTRAINT check_user_not_empty CHECK (((user_id)::text <> ''::text)) 106 105 ); … … 177 176 178 177 -- 179 -- TOC entry 2 2(OID 133192)178 -- TOC entry 21 (OID 133192) 180 179 -- Name: idx_unique_username_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog 181 180 -- 182 181 183 182 CREATE UNIQUE INDEX idx_unique_username_and_account_origin ON users USING btree (username, account_origin); 184 185 186 --187 -- TOC entry 21 (OID 140367)188 -- Name: idx_unique_email_and_account_origin; Type: INDEX; Schema: public; Owner: wifidog189 --190 191 CREATE UNIQUE INDEX idx_unique_email_and_account_origin ON users USING btree (email, account_origin);192 183 193 184 … … 229 220 230 221 -- 231 -- TOC entry 2 3(OID 133114)222 -- TOC entry 22 (OID 133114) 232 223 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 233 224 -- … … 238 229 239 230 -- 240 -- TOC entry 2 4(OID 133116)231 -- TOC entry 23 (OID 133116) 241 232 -- Name: node_owners_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 242 233 -- … … 247 238 248 239 -- 249 -- TOC entry 2 5(OID 133118)240 -- TOC entry 24 (OID 133118) 250 241 -- Name: node_deployment_status_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 251 242 -- … … 256 247 257 248 -- 258 -- TOC entry 2 6(OID 133120)249 -- TOC entry 25 (OID 133120) 259 250 -- Name: venue_types_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 260 251 -- … … 265 256 266 257 -- 267 -- TOC entry 2 7(OID 133122)258 -- TOC entry 26 (OID 133122) 268 259 -- Name: schema_info_pkey; Type: CONSTRAINT; Schema: public; Owner: wifidog 269 260 -- … … 274 265 275 266 -- 276 -- TOC entry 2 9(OID 133124)267 -- TOC entry 28 (OID 133124) 277 268 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 278 269 -- … … 283 274 284 275 -- 285 -- TOC entry 2 8(OID 133128)276 -- TOC entry 27 (OID 133128) 286 277 -- Name: administrators_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 287 278 -- … … 292 283 293 284 -- 294 -- TOC entry 30(OID 133132)285 -- TOC entry 29 (OID 133132) 295 286 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 296 287 -- … … 301 292 302 293 -- 303 -- TOC entry 3 1(OID 133136)294 -- TOC entry 30 (OID 133136) 304 295 -- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 305 296 -- … … 310 301 311 302 -- 312 -- TOC entry 3 4(OID 133140)303 -- TOC entry 33 (OID 133140) 313 304 -- Name: fk_users; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 314 305 -- … … 319 310 320 311 -- 321 -- TOC entry 3 5(OID 133144)312 -- TOC entry 34 (OID 133144) 322 313 -- Name: fk_nodes; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 323 314 -- … … 328 319 329 320 -- 330 -- TOC entry 3 2(OID 133148)321 -- TOC entry 31 (OID 133148) 331 322 -- Name: fk_node_deployment_status; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 332 323 -- … … 337 328 338 329 -- 339 -- TOC entry 3 3(OID 133152)330 -- TOC entry 32 (OID 133152) 340 331 -- Name: fk_venue_types; Type: FK CONSTRAINT; Schema: public; Owner: wifidog 341 332 --
