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

From 118Wiki
Jump to navigation Jump to search
(Added Barclay)
Line 73: Line 73:
  TOSMA2,Ens.,Jarak,StarBase 118 Ops,2007  
  TOSMA2,Ens.,Jarak,StarBase 118 Ops,2007  
  TOSMA2,Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007  
  TOSMA2,Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007  
 
barclay,Lt. Cmdr.,Danzia,USS Challenger,2007 
barclay,Lt.,Rode Mitchell,USS Discovery,2007 
barclay,Lt. JG.,Daniel Wood,USS Independence,2007 
barclay,Lt. JG.,William Rogers,USS Ronin,2007 
barclay,Lt.,Jacen Fanel,StarBase 118 Ops,2007 
barclay,Ens.,Robert “Do” Long,USS Ursa Major,2007
----
----

Revision as of 16:58, 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
TOSMA2,Ens.,Grauro Zekyel/Syrak,USS Discovery,2007 
TOSMA2,Lt.,Allen Cruise,USS Independence,2007 
TOSMA2,Lt. JG.,Addison Parker,USS Ronin,2007 
TOSMA2,Ens.,Jarak,StarBase 118 Ops,2007 
TOSMA2,Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007 
barclay,Lt. Cmdr.,Danzia,USS Challenger,2007  
barclay,Lt.,Rode Mitchell,USS Discovery,2007  
barclay,Lt. JG.,Daniel Wood,USS Independence,2007  
barclay,Lt. JG.,William Rogers,USS Ronin,2007  
barclay,Lt.,Jacen Fanel,StarBase 118 Ops,2007  
barclay,Ens.,Robert “Do” Long,USS Ursa Major,2007