User:FltAdml. Wolf/Awards '07 Project - SQL File
Jump to navigation
Jump to search
- Working file found here: User:FltAdml. Wolf/Awards '07 Project - Cleanup file.
- View the sample for more help.
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