<tms>
	<table name = "tms.usercategories">
		<data usercategory = "Administrator" isadmin="1" />
		<data usercategory = "User" isadmin="0" />
		<data usercategory = "Guest" isadmin="0" />				
	</table>
	
	<table name = "tms.users">
		<data username = "administrator" passwrd = "$2a$10$b8rAOA3zCtVHsULufrjijuViRwucWv0GxC0BIgoV4T1ZDDgHg7vGS" firstname = "Default" lastname = "Administrator" activated = "1" usercategoryid = "1" />		
	</table>		
	
	<!-- 
		The following describes the fieldtypeid of a field.
		
		Index Field = 1
		Text Attribute Field = 2
		Preset Attribute Field = 3
		Text Record Field = 4
		Synonymn Field = 5
		Text SubAttribute Field = 6
		Preset SubAttribute Field = 7
		
		The following describes the fielddatatypeid of a field
		
		Plain Text = 1
		Integer = 2
		Floating-point Number = 3
		HTML Hyperlink = 4
		XML = 5
		Formula = 6
	-->		 	
	<table name = "tms.fields">
		<data fieldname = "English" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "9" />
		<data fieldname = "International scientific term" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "10" />
		<data fieldname = "Afrikaans" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "11" />
		<data fieldname = "IsiZulu" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "12" />
		<data fieldname = "IsiXhosa" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "13" />
		<data fieldname = "Siswati" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "14" />
		<data fieldname = "IsiNdebele" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "15" />
		<data fieldname = "Setswana" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "16" />
		<data fieldname = "Sepedi" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "17" />
		<data fieldname = "Sesotho" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "18" />
		<data fieldname = "Tshivenḓa" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "19" />
		<data fieldname = "Xitsonga" fieldtypeid = "1" fielddatatypeid = "1" maxlength = "100" sortindex = "20" />		
		<data fieldname = "Definition" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "36" />
		<data fieldname = "Source-definition" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "37" />
		<data fieldname = "Example sentence" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "38" />
		<data fieldname = "Collocation" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "40" />
		<data fieldname = "Time label" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "41" />						
		<data fieldname = "Note" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "29" />
		<data fieldname = "Plural" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "30" />
		<data fieldname = "Full form" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "31" />
		<data fieldname = "Research note" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "32" />
		<data fieldname = "Source publication" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "33" />
		<data fieldname = "TOT source" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "34" />
		<data fieldname = "Text" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "39" />
		<data fieldname = "Editing note" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "250" sortindex = "42" />		
		<data fieldname = "Context" fieldtypeid = "2" fielddatatypeid = "1" maxlength = "100" sortindex = "35" />
		<data fieldname = "Formula" fieldtypeid = "2" fielddatatypeid = "6" maxlength = "100" sortindex = "28" />
		<data fieldname = "Image" fieldtypeid = "2" fielddatatypeid = "4" maxlength = "250" sortindex = "44" />
		<data fieldname = "Sound" fieldtypeid = "2" fielddatatypeid = "4" maxlength = "250" sortindex = "45" />
		<data fieldname = "Part of speech" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "10" sortindex = "21" />
		<data fieldname = "Category" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "22" />
		<data fieldname = "Geographical usage" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "23" />
		<data fieldname = "Origin" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "24" />
		<data fieldname = "Term acceptability" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "25" />		
		<data fieldname = "Register" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "26" />
		<data fieldname = "Term status" fieldtypeid = "3" fielddatatypeid = "1" maxlength = "50" sortindex = "27" />
		<data fieldname = "Admin" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "250" sortindex = "1" />
		<data fieldname = "Subject" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "100" sortindex = "2" />
		<data fieldname = "Note to manager" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "250" sortindex = "3" />
		<data fieldname = "Keyword" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "100" sortindex = "5" />
		<data fieldname = "Publication" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "250" sortindex = "7" />
		<data fieldname = "Client/Dept" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "100" sortindex = "8" />
		<data fieldname = "Record editing note" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "250" sortindex = "4" />
		<data fieldname = "Project" fieldtypeid = "4" fielddatatypeid = "1" maxlength = "250" sortindex = "6" />
		<data fieldname = "Synonym" fieldtypeid = "5" fielddatatypeid = "1" maxlength = "100" sortindex = "43" />		
		<data fieldname = "Note" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "100" sortindex = "52" />
		<data fieldname = "Plural" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "100" sortindex = "53" />
		<data fieldname = "Full form" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "100" sortindex = "54" />
		<data fieldname = "Research note" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "250" sortindex = "55" />
		<data fieldname = "Source publication" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "250" sortindex = "56" />
		<data fieldname = "TOT source" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "250" sortindex = "57" />
		<data fieldname = "Text" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "250" sortindex = "58" />
		<data fieldname = "Editing note" fieldtypeid = "6" fielddatatypeid = "1" maxlength = "250" sortindex = "59" />
		<data fieldname = "Category" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "46" />
		<data fieldname = "Geographical usage" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "47" />
		<data fieldname = "Origin" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "48" />
		<data fieldname = "Term acceptability" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "49" />
		<data fieldname = "Register" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "50" />
		<data fieldname = "Term status" fieldtypeid = "7" fielddatatypeid = "1" maxlength = "50" sortindex = "51" />		
	</table>
	
	<table name = "tms.presetfields">
		<data presetfieldname = "None" fieldid = "30"/>
		<data presetfieldname = "None" fieldid = "31"/>
		<data presetfieldname = "None" fieldid = "32"/>
		<data presetfieldname = "None" fieldid = "33"/>
		<data presetfieldname = "None" fieldid = "34"/>
		<data presetfieldname = "None" fieldid = "35"/>
		<data presetfieldname = "None" fieldid = "36"/>
		<data presetfieldname = "None" fieldid = "54"/>
		<data presetfieldname = "None" fieldid = "55"/>
		<data presetfieldname = "None" fieldid = "56"/>
		<data presetfieldname = "None" fieldid = "57"/>
		<data presetfieldname = "None" fieldid = "58"/>
		<data presetfieldname = "None" fieldid = "59"/>
		<data presetfieldname = "n." fieldid = "30"/>
		<data presetfieldname = "adj." fieldid = "30"/>
		<data presetfieldname = "adv." fieldid = "30"/>
		<data presetfieldname = "v." fieldid = "30"/>
		<data presetfieldname = "Abbreviation" fieldid = "31"/>
		<data presetfieldname = "Acronym" fieldid = "31"/>
		<data presetfieldname = "Short form" fieldid = "31"/>
		<data presetfieldname = "Full form" fieldid = "31"/>
		<data presetfieldname = "Variant" fieldid = "31"/>
		<data presetfieldname = "Diminutive" fieldid = "31"/>
		<data presetfieldname = "Singular" fieldid = "31"/>
		<data presetfieldname = "Plural" fieldid = "31"/>
		<data presetfieldname = "Circumscription" fieldid = "31"/>
		<data presetfieldname = "United States" fieldid = "32"/>
		<data presetfieldname = "Great Britain" fieldid = "32"/>
		<data presetfieldname = "Europe" fieldid = "32"/>
		<data presetfieldname = "Republic of South Africa" fieldid = "32"/>
		<data presetfieldname = "Eastern Cape" fieldid = "32"/>
		<data presetfieldname = "Free State" fieldid = "32"/>
		<data presetfieldname = "Gauteng" fieldid = "32"/>
		<data presetfieldname = "KwaZulu-Natal" fieldid = "32"/>
		<data presetfieldname = "Mpumalanga" fieldid = "32"/>
		<data presetfieldname = "Northern Cape" fieldid = "32"/>
		<data presetfieldname = "Northern Province" fieldid = "32"/>
		<data presetfieldname = "North West Province" fieldid = "32"/>
		<data presetfieldname = "Western Cape" fieldid = "32"/>
		<data presetfieldname = "Afrikaans" fieldid = "33"/>
		<data presetfieldname = "English" fieldid = "33"/>
		<data presetfieldname = "French" fieldid = "33"/>
		<data presetfieldname = "German" fieldid = "33"/>
		<data presetfieldname = "Greek" fieldid = "33"/>
		<data presetfieldname = "Greek/Latin" fieldid = "33"/>
		<data presetfieldname = "Latin" fieldid = "33"/>
		<data presetfieldname = "Spanish" fieldid = "33"/>
		<data presetfieldname = "Preferred" fieldid = "34"/>
		<data presetfieldname = "Recommended" fieldid = "34"/>
		<data presetfieldname = "Not recommended" fieldid = "34"/>
		<data presetfieldname = "Superseded" fieldid = "34"/>
		<data presetfieldname = "Deprecated" fieldid = "34"/>
		<data presetfieldname = "Seldom used" fieldid = "34"/>
		<data presetfieldname = "Obsolete" fieldid = "34"/>
		<data presetfieldname = "Obsolescent" fieldid = "34"/>
		<data presetfieldname = "Historic" fieldid = "34"/>
		<data presetfieldname = "Archaic" fieldid = "34"/>
		<data presetfieldname = "Standardised" fieldid = "34"/>		
		<data presetfieldname = "Technical" fieldid = "35"/>		
		<data presetfieldname = "Neutral" fieldid = "35"/>		
		<data presetfieldname = "Standard" fieldid = "35"/>		
		<data presetfieldname = "Less formal" fieldid = "35"/>		
		<data presetfieldname = "Colloquial" fieldid = "35"/>		
		<data presetfieldname = "Jargon" fieldid = "35"/>		
		<data presetfieldname = "Slang" fieldid = "35"/>		
		<data presetfieldname = "Vulgar" fieldid = "35"/>		
		<data presetfieldname = "Obscene" fieldid = "35"/>		
		<data presetfieldname = "Taboo" fieldid = "35"/>		
		<data presetfieldname = "Offensive" fieldid = "35"/>		
		<data presetfieldname = "Derogatory" fieldid = "35"/>		
		<data presetfieldname = "Pejorative" fieldid = "35"/>		
		<data presetfieldname = "Rural" fieldid = "35"/>		
		<data presetfieldname = "Urban" fieldid = "35"/>		
		<data presetfieldname = "Unverified" fieldid = "36"/>		
		<data presetfieldname = "Verified" fieldid = "36"/>		
		<data presetfieldname = "Abbreviation" fieldid = "54"/>		
		<data presetfieldname = "Acronym" fieldid = "54"/>		
		<data presetfieldname = "Short form" fieldid = "54"/>		
		<data presetfieldname = "Full form" fieldid = "54"/>		
		<data presetfieldname = "Variant" fieldid = "54"/>		
		<data presetfieldname = "Diminutive" fieldid = "54"/>		
		<data presetfieldname = "Singular" fieldid = "54"/>		
		<data presetfieldname = "Plural" fieldid = "54"/>		
		<data presetfieldname = "Circumscription" fieldid = "54"/>		
		<data presetfieldname = "United States" fieldid = "55"/>		
		<data presetfieldname = "Great Britain" fieldid = "55"/>		
		<data presetfieldname = "Europe" fieldid = "55"/>		
		<data presetfieldname = "Republic of South Africa" fieldid = "55"/>		
		<data presetfieldname = "Eastern Cape" fieldid = "55"/>		
		<data presetfieldname = "Free State" fieldid = "55"/>		
		<data presetfieldname = "Gauteng" fieldid = "55"/>		
		<data presetfieldname = "KwaZulu-Natal" fieldid = "55"/>		
		<data presetfieldname = "Mpumalanga" fieldid = "55"/>		
		<data presetfieldname = "Northern Cape" fieldid = "55"/>		
		<data presetfieldname = "Northern Province" fieldid = "55"/>		
		<data presetfieldname = "North West Province" fieldid = "55"/>		
		<data presetfieldname = "Western Cape" fieldid = "55"/>	
		<data presetfieldname = "Afrikaans" fieldid = "56"/>
		<data presetfieldname = "English" fieldid = "56"/>
		<data presetfieldname = "French" fieldid = "56"/>
		<data presetfieldname = "German" fieldid = "56"/>
		<data presetfieldname = "Greek" fieldid = "56"/>
		<data presetfieldname = "Greek/Latin" fieldid = "56"/>
		<data presetfieldname = "Latin" fieldid = "56"/>
		<data presetfieldname = "Spanish" fieldid = "56"/>		
		<data presetfieldname = "Preferred" fieldid = "57"/>
		<data presetfieldname = "Recommended" fieldid = "57"/>
		<data presetfieldname = "Not recommended" fieldid = "57"/>
		<data presetfieldname = "Superseded" fieldid = "57"/>
		<data presetfieldname = "Deprecated" fieldid = "57"/>
		<data presetfieldname = "Seldom used" fieldid = "57"/>
		<data presetfieldname = "Obsolete" fieldid = "57"/>
		<data presetfieldname = "Obsolescent" fieldid = "57"/>
		<data presetfieldname = "Historic" fieldid = "57"/>
		<data presetfieldname = "Archaic" fieldid = "57"/>
		<data presetfieldname = "Standardised" fieldid = "57"/>	
		<data presetfieldname = "Technical" fieldid = "58"/>		
		<data presetfieldname = "Neutral" fieldid = "58"/>		
		<data presetfieldname = "Standard" fieldid = "58"/>		
		<data presetfieldname = "Less formal" fieldid = "58"/>		
		<data presetfieldname = "Colloquial" fieldid = "58"/>		
		<data presetfieldname = "Jargon" fieldid = "58"/>		
		<data presetfieldname = "Slang" fieldid = "58"/>		
		<data presetfieldname = "Vulgar" fieldid = "58"/>		
		<data presetfieldname = "Obscene" fieldid = "58"/>		
		<data presetfieldname = "Taboo" fieldid = "58"/>		
		<data presetfieldname = "Offensive" fieldid = "58"/>		
		<data presetfieldname = "Derogatory" fieldid = "58"/>		
		<data presetfieldname = "Pejorative" fieldid = "58"/>		
		<data presetfieldname = "Rural" fieldid = "58"/>		
		<data presetfieldname = "Urban" fieldid = "58"/>	
		<data presetfieldname = "Unverified" fieldid = "59"/>		
		<data presetfieldname = "Verified" fieldid = "59"/>		
	</table>
</tms>