home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / get_all_reminders.sql < prev    next >
Encoding:
Text File  |  2004-10-25  |  238 b   |  19 lines
  1. # get all reminder
  2. SELECT
  3.   project_id,
  4.   name,
  5.   remind_age,
  6.   remind_ts,
  7.   email,
  8.   email_subject,
  9.   email_body,
  10.   author,
  11.   responsible,
  12.   assignable,
  13.   state,
  14.   category,
  15.   severity,
  16.   priority
  17. FROM reminder
  18. ORDER BY project_id, name
  19.