Revision 57670
Added by Michele Artini over 4 years ago
| schema.sql | ||
|---|---|---|
| 1 | 1 |
DROP VIEW organizations_view; |
| 2 | 2 |
DROP VIEW organizations_simple_view; |
| 3 | 3 |
DROP VIEW users_view; |
| 4 |
DROP VIEW warnings_view;
|
|
| 4 |
DROP VIEW conflicts_view;
|
|
| 5 | 5 |
|
| 6 | 6 |
DROP TABLE IF EXISTS other_ids; |
| 7 | 7 |
DROP TABLE IF EXISTS other_names; |
| ... | ... | |
| 195 | 195 |
GROUP BY u.email, u.valid, u.role |
| 196 | 196 |
ORDER BY u.email; |
| 197 | 197 |
|
| 198 |
CREATE VIEW warnings_view AS SELECT
|
|
| 198 |
CREATE VIEW conflicts_view AS SELECT
|
|
| 199 | 199 |
o1.id AS id_1, |
| 200 | 200 |
o1.name AS name_1, |
| 201 | 201 |
o1.type AS type_1, |
Also available in: Unified diff
warning -> conflicts