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

From 118Wiki
Jump to navigation Jump to search
m (Added TOSMA2)
Line 61: Line 61:
----
----
  TOSMA1,Ens.,Emilio Aguinaldo,USS Challenger, 2007  
  TOSMA1,Ens.,Emilio Aguinaldo,USS Challenger, 2007  
  TOSMA1,Lt. JG., Tal Tel-ar,USS Constitution,2007
  TOSMA1,Lt. JG.,Tal Tel-ar,USS Constitution,2007
  TOSMA1,Ens., Tabour Flux,USS Discovery,2007  
  TOSMA1,Ens.,Tabour Flux,USS Discovery,2007  
  TOSMA1,Lt., Cmdr. Sidney Riley,USS Independence,2007  
  TOSMA1,Lt. Cmdr.,Sidney Riley,USS Independence,2007  
  TOSMA1,Lt., Ethan Brice,USS Ronin,2007  
  TOSMA1,Lt.,Ethan Brice,USS Ronin,2007  
  TOSMA1,Lt. Cmdr.,Cura Stone,StarBase 118 Ops,2007  
  TOSMA1,Lt. Cmdr.,Cura Stone,StarBase 118 Ops,2007  
  TOSMA1,Lt. JG.,Will Carrington,USS Ursa Major,2007
  TOSMA1,Lt. JG.,Will Carrington,USS Ursa Major,2007
TOSMA2,Lt. Cmdr.,Victoria Yladro,USS Constitution,2007
TOSMA2Ens.,Grauro Zekyel/Syrak,USS Discovery,2007
TOSMA2Lt.,Allen Cruise,USS Independence,2007
TOSMA2Lt. JG.,Addison Parker,USS Ronin,2007
TOSMA2Ens.,Jarak,StarBase 118 Ops,2007
TOSMA2Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007


----
----

Revision as of 16:42, 4 November 2008

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,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
TOSMA2,Lt. Cmdr.,Victoria Yladro,USS Constitution,2007
TOSMA2Ens.,Grauro Zekyel/Syrak,USS Discovery,2007 
TOSMA2Lt.,Allen Cruise,USS Independence,2007 
TOSMA2Lt. JG.,Addison Parker,USS Ronin,2007 
TOSMA2Ens.,Jarak,StarBase 118 Ops,2007 
TOSMA2Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007