User:FltAdml. Wolf/Awards '07 Project - SQL File
Jump to navigation
Jump to search
View the sample file 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
PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE
Post General Awards Queries Below
PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE