User:FltAdml. Wolf/Awards '07 Project - SQL File: Difference between revisions
Jump to navigation
Jump to search
m (→Post Duty Post Queries Below: Done!) |
(Added TOSMA1) |
||
Line 60: | Line 60: | ||
PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE | 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 | |||
---- | ---- |
Revision as of 16:34, 4 November 2008
- 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, 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