Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
/* Package Details */
2 
SELECT pv.pv_id,
3 
	   pkg.pkg_id,
4 
	   pkg.pkg_name,
5 
       pv.pkg_version,
6 
       pv.v_ext,
7 
       pv.modified_stamp,
8 
       pv.modifier_id,
9 
       umd.user_name modifier,
10 
       umd.user_email AS modifier_email,
11 
       pv.created_stamp,
12 
       ucr.user_name AS creator,
13 
       ucr.user_email AS creator_email,
14 
       onr.full_name AS owner,
15 
       onr.user_email AS owner_email,
16 
       pv.dlocked,
17 
       rel.proj_id,
18 
       rel.rtag_id,
19 
       rel.rtag_name,
20 
       pv.comments,
21 
       pv.pkg_label,
22 
       pv.src_path,
23 
       pv.pv_description,
24 
       pv.is_patch,
25 
       lpv.pkg_version AS previous_version,
26 
       pv.last_pv_id,
27 
	   pv.release_notes_info,
28 
	   pv.is_obsolete,
29 
	   pv.obsolete_comments,
30 
	   pv.build_type,
31 
	   pv.change_type
32 
  FROM package_versions pv,
33 
       package_versions lpv,
34 
       PACKAGES pkg,
35 
       release_tags rel,
36 
       users umd,
37 
       users ucr,
38 
       users onr
39 
 WHERE pkg.pkg_id = pv.pkg_id
40 
   AND pv.last_pv_id = lpv.pv_id (+)
41 
   AND rel.rtag_id (+) = pv.released_at
42 
   AND umd.user_id (+) = pv.modifier_id
43 
   AND ucr.user_id (+) = pv.creator_id
44 
   AND onr.user_id (+) = pv.owner_id
45 
   AND pv.pv_id = :PV_ID