Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pv.pv_id,
2 
	   pkg.pkg_name,
3 
	   pv.pkg_version,
4 
	   lm.full_name AS modifier,
5 
       lm.user_email AS modifier_email,
6 
	   pv.modified_stamp,
7 
	   own.full_name AS owner,
8 
       own.user_email AS owner_email,
9 
	   pv.pkg_label,
10 
	   pv.src_path,
11 
       pv.comments reason,
12 
	   pv.pv_overview long_desc,
13 
       pv.pv_description short_desc
14 
  FROM PACKAGES pkg, package_versions pv, users lm, users own
15 
 WHERE pv.pkg_id = pkg.pkg_id
16 
   AND pv.modifier_id = lm.user_id
17 
   AND pv.owner_id = own.user_id
18 
   AND pv.pv_id = :PV_ID