Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 4687
Line 1... Line 1...
1 
/* Package Details */
 1 
/* Package Details, no release information */
2 
SELECT pv.pv_id,
2 
SELECT pv.pv_id,
3 
	   pkg.pkg_id,
3 
	   pkg.pkg_id,
4 
	   pkg.pkg_name,
4 
	   pkg.pkg_name,
5 
       pv.pkg_version,
5 
       pv.pkg_version,
6 
       pv.v_ext,
6 
       pv.v_ext,
Line 12... Line 12...
12 
       ucr.user_name AS creator,
12 
       ucr.user_name AS creator,
13 
       ucr.user_email AS creator_email,
13 
       ucr.user_email AS creator_email,
14 
       onr.full_name AS owner,
14 
       onr.full_name AS owner,
15 
       onr.user_email AS owner_email,
15 
       onr.user_email AS owner_email,
16 
       pv.dlocked,
 16 
       pv.dlocked,
17 
       rel.proj_id,
- 
 
18 
       rel.rtag_id,
- 
 
19 
       rel.rtag_name,
 - 
 
20 
       rel.product_state_used,
- 
 
21 
       pv.comments,
17 
       pv.comments,
22 
       pv.pkg_label,
18 
       pv.pkg_label,
23 
       pv.src_path,
19 
       pv.src_path,
24 
       pv.pv_description,
20 
       pv.pv_description,
25 
       pv.is_patch,
21 
       pv.is_patch,
Line 35... Line 31...
35 
	   pv.sbom_priority,
 31 
	   pv.sbom_priority,
36 
	pv.ripple_field
 32 
	pv.ripple_field
37 
  FROM package_versions pv,
 33 
  FROM package_versions pv,
38 
       package_versions lpv,
 34 
       package_versions lpv,
39 
       PACKAGES pkg,
 35 
       PACKAGES pkg,
40 
       release_tags rel,
 - 
 
41 
       users umd,
 36 
       users umd,
42 
       users ucr,
 37 
       users ucr,
43 
       users onr
 38 
       users onr
44 
 WHERE pkg.pkg_id = pv.pkg_id
 39 
 WHERE pkg.pkg_id = pv.pkg_id
45 
   AND pv.last_pv_id = lpv.pv_id (+)
 40 
   AND pv.last_pv_id = lpv.pv_id (+)
46 
   AND rel.rtag_id (+) = pv.released_at
 - 
 
47 
   AND umd.user_id (+) = pv.modifier_id
 41 
   AND umd.user_id (+) = pv.modifier_id
48 
   AND ucr.user_id (+) = pv.creator_id
 42 
   AND ucr.user_id (+) = pv.creator_id
49 
   AND onr.user_id (+) = pv.owner_id
 43 
   AND onr.user_id (+) = pv.owner_id
50 
   AND pv.pv_id = :PV_ID
44 
   AND pv.pv_id = :PV_ID
51 

            45