User:FltAdml. Wolf/Awards '07 Project - SQL File

From 118Wiki
< User:FltAdml. Wolf
Revision as of 16:34, 4 November 2008 by Toni (talk | contribs) (Added TOSMA1)
Jump to navigation Jump to search

List of Awards Names

Duty Post Awards

  • strange = First Officer: The Strange Medallion
  • cochrane = Science: The Cochrane Award
  • sextant = Helm: The Pilot's Sextant
  • phoenix = Engineering: The Phoenix Award
  • prantares = Medical: The Prantares Ribbon
  • yar = Security: The Natasha Yar Pin
  • voyager = Operations: The Voyager Medallion
  • valiant = Counseling: The Order of the Valiant Heart
  • sisko = Tactical: Captain Sisko Tactical Cross

General Awards

  • barclay = The Barclay Bead
  • bplot = B-Plot Award
  • kalendra = The Kalendra Award
  • merria = The Merria Medallion
  • nebula = The Nebula Bar
  • neelix = The Neelix Award
  • purplestar = The Purple Star
  • sarpeidon = Sarpeidon Award
  • scotty = The Scotty Cross
  • sheathed = The Sheathed Sword
  • silver = The Silver Palm
  • TOSMA1 = The Order of StarFleet Merit and Achievement First Class (TOSMA I)
  • TOSMA2 = The Order of StarFleet Merit and Achievement Second Class (TOSMA II)
  • xalor = The Xalor Clan Xifilis Award
  • data = Data Artistic Award

The query

Format

[Award Code],[Rank Abbreviation w/period],[Character Name],[Ship],2007

Example

  • General: barclay,Lt. Cmdr.,John Graves,USS Triumphant,2006
  • Duty Post: sisko,Lt.,Rode Mitchell,Ops,2005

Post Duty Post Queries Below - DONE, and ONLINE!

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE


cochrane,Lt. Cmdr.,Stephen Carmody,USS Ursa Major,2007 
sextant,Ens., Alex Swift,USS Challenger,2007
phoenix,Lt. JG.,Seph 647,USS Constitution,2007 
prantares,Lt. Cmdr., Julia Harden,StarBase 118 Ops,2007
yar,Lt. JG.,Tal Tel-ar,USS Constitution,2007 
voyager,Lt. Cmdr.,Toni Turner,USS Challenger,2007 
valiant,Lt. Cmdr., Emirry MacGowan,USS Constitution,2007
sisko,Lt.,Rode Mitchell,Discovery-B,2007









Post General Awards Queries Below

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE


TOSMA1,

TOSMA1,Ens.,Emilio Aguinaldo,USS Challenger, 2007 
TOSMA1,Lt. JG., Tal Tel-ar,USS Constitution,2007
TOSMA1,Ens., Tabour Flux,USS Discovery,2007 
TOSMA1,Lt., Cmdr. Sidney Riley,USS Independence,2007 
TOSMA1,Lt., Ethan Brice,USS Ronin,2007 
TOSMA1,Lt. Cmdr.,Cura Stone,StarBase 118 Ops,2007 
TOSMA1,Lt. JG.,Will Carrington,USS Ursa Major,2007