Changeset 790
- Timestamp:
- 04/07/08 00:00:17 (5 months ago)
- Files:
-
- trunk/database/structure.sql (modified) (1 diff)
- trunk/database/structure_with_drop.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/database/structure.sql
r789 r790 1000 1000 1001 1001 CREATE VIEW medias AS 1002 SELECT dmedias.key, dmedias.name, distribution.version, dmedias.arch, dmedias.branch, dmedias.vendor, distribution.editor AS distrib, dmedias.vendor AS team, dmedias.distribution FROM (dmedias JOIN distribution ON ((distribution.key = dmedias.distribution)));1002 SELECT dmedias.key, dmedias.name, distribution.version, dmedias.arch, dmedias.branch, dmedias.vendor, distribution.editor AS distrib, dmedias.vendor AS team, dmedias.distribution, distribution.release FROM (dmedias JOIN distribution ON ((distribution.key = dmedias.distribution))); 1003 1003 1004 1004 trunk/database/structure_with_drop.sql
r789 r790 1425 1425 1426 1426 CREATE VIEW medias AS 1427 SELECT dmedias.key, dmedias.name, distribution.version, dmedias.arch, dmedias.branch, dmedias.vendor, distribution.editor AS distrib, dmedias.vendor AS team, dmedias.distribution FROM (dmedias JOIN distribution ON ((distribution.key = dmedias.distribution)));1427 SELECT dmedias.key, dmedias.name, distribution.version, dmedias.arch, dmedias.branch, dmedias.vendor, distribution.editor AS distrib, dmedias.vendor AS team, dmedias.distribution, distribution.release FROM (dmedias JOIN distribution ON ((distribution.key = dmedias.distribution))); 1428 1428 1429 1429
