Subversion Repositories DevTools

Rev

Rev 5506 | Rev 6612 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 5929
Line 1... Line 1...
1 
/* Package Details, no release information */
 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,
7 
       pv.modified_stamp,
7 
       pv.modified_stamp,
8 
       pv.modifier_id,
 8 
       pv.modifier_id,
9 
       umd.user_name modifier,
9 
       umd.user_name modifier,
10 
       umd.user_email AS modifier_email,
10 
       umd.user_email AS modifier_email,
11 
       pv.created_stamp,
 11 
       pv.created_stamp,
- 
 
 12 
       pv.creator_id,
12 
       ucr.user_name AS creator,
13 
       ucr.user_name AS creator,
13 
       ucr.user_email AS creator_email,
14 
       ucr.user_email AS creator_email,
- 
 
 15 
       pv.owner_id,
14 
       onr.full_name AS owner,
16 
       onr.full_name AS owner,
15 
       onr.user_email AS owner_email,
17 
       onr.user_email AS owner_email,
16 
       pv.dlocked,
 18 
       pv.dlocked,
17 
       pv.comments,
19 
       pv.comments,
18 
       pv.pkg_label,
20 
       pv.pkg_label,
19 
       pv.src_path,
21 
       pv.src_path,
20 
       pv.pv_description,
22 
       pv.pv_description,
21 
       pv.is_patch,
23 
       pv.is_patch,
22 
       lpv.pkg_version AS previous_version,
24 
       lpv.pkg_version AS previous_version,
23 
       pv.last_pv_id,
 25 
       pv.last_pv_id,
24 
	   pv.release_notes_info,
 26 
       pv.release_notes_info,
25 
	   pv.is_obsolete,
 27 
       pv.is_obsolete,
26 
	   pv.obsolete_comments,
 28 
       pv.obsolete_comments,
27 
	   pv.build_type,
 29 
       pv.build_type,
28 
	   pv.change_type,
 30 
       pv.change_type,
29 
	   pv.bs_id,
 31 
       pv.bs_id,
30 
	   pv.is_deployable,
 32 
       pv.is_deployable,
31 
	   pv.sbom_priority,
 33 
       pv.sbom_priority,
32 
	   pv.ripple_field
 34 
       pv.ripple_field
33 
  FROM package_versions pv,
 35 
  FROM package_versions pv,
34 
       package_versions lpv,
 36 
       package_versions lpv,
35 
       PACKAGES pkg,
 37 
       PACKAGES pkg,
36 
       users umd,
 38 
       users umd,
37 
       users ucr,
 39 
       users ucr,