Leaked source code of windows server 2003
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

354 lines
39 KiB

  1. ##################################################################################################################################
  2. # #
  3. # Table: DbParameters #
  4. # #
  5. # Columns #
  6. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  7. # # # # #
  8. # Name # Type # Flags # Description #
  9. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  10. # Name # Text # # Name of the parameter. #
  11. # Value # LongText # Null # Its value. #
  12. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  13. # #
  14. # Indexes #
  15. #----------#---------------------#-----------------------------------------#-----------------------------------------------------#
  16. # # # # #
  17. # Name # Definition # Kind # Description #
  18. #----------#---------------------#-----------------------------------------#-----------------------------------------------------#
  19. # ByName # +Name # Primary & Unique # Used to look up a parameter. #
  20. #----------#---------------------#-----------------------------------------#-----------------------------------------------------#
  21. ##################################################################################################################################
  22. ##################################################################################################################################
  23. # #
  24. # Table: ContentOwners #
  25. # #
  26. # Columns #
  27. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  28. # # # # #
  29. # Name # Type # Flags # Description #
  30. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  31. # DN # Text # # Qualified name of the owner, constructed from the Digital Certificate. #
  32. # ID_owner # AutoNumber # # ID associated with the owner. #
  33. # IsOEM # Bool # # This is an OEM, so it can create nodes. #
  34. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  35. # #
  36. # Indexes #
  37. #------------#-------------------#-----------------------------------------#-----------------------------------------------------#
  38. # # # # #
  39. # Name # Definition # Kind # Description #
  40. #------------#-------------------#-----------------------------------------#-----------------------------------------------------#
  41. # ByVendorID # +DN # Primary & Unique # Used to look up an owner. #
  42. # Owner # +ID_owner # Unique # #
  43. #------------#-------------------#-----------------------------------------#-----------------------------------------------------#
  44. ##################################################################################################################################
  45. ##################################################################################################################################
  46. # #
  47. # Table: SynSets #
  48. # #
  49. # Columns #
  50. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  51. # # # # #
  52. # Name # Type # Flags # Description #
  53. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  54. # Name # Text # # SynSet name. #
  55. # ID_owner # Number # # Owner of the SynSet. #
  56. # ID_synset # Number # Autoincrement # SynSet number. #
  57. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  58. # #
  59. # Indexes #
  60. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  61. # # # # #
  62. # Name # Definition # Kind # Description #
  63. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  64. # ByPair # +Name+ID_owner # Primary & Unique # Used during add/remove. #
  65. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  66. ##################################################################################################################################
  67. ##################################################################################################################################
  68. # #
  69. # Table: HelpImage #
  70. # #
  71. # Columns #
  72. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  73. # # # # #
  74. # Name # Type # Flags # Description #
  75. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  76. # ID_owner # Number # # Owner of the Help Image. #
  77. # File # Text # # Name of the file that is part of the Help Image. #
  78. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  79. # #
  80. # Indexes #
  81. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  82. # # # # #
  83. # Name # Definition # Kind # Description #
  84. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  85. # ByFile # +File # Primary & Unique # Used during add/remove. #
  86. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  87. ##################################################################################################################################
  88. ##################################################################################################################################
  89. # #
  90. # Table: Scope #
  91. # #
  92. # Columns #
  93. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  94. # # # # #
  95. # Name # Type # Flags # Description #
  96. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  97. # ID_owner # Number # # Owner of the scope. #
  98. # ID_scope # Number # Autoincrement # Identifier for the scope. #
  99. # Name # Text # # Name of the application. #
  100. # Category # LongText # # Position in the taxomony. #
  101. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  102. # #
  103. # Indexes #
  104. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  105. # # # # #
  106. # Name # Definition # Kind # Description #
  107. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  108. # ByName # +Name # Primary & Unique # Used to locate a scope. #
  109. # ByScope # +ID_scope # Unique # #
  110. # OwnedScopes # +ID_owner # External to ContentOwners # Used to look up all the scopes of an owner. #
  111. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  112. ##################################################################################################################################
  113. ##################################################################################################################################
  114. # #
  115. # Table: IndexFiles #
  116. # #
  117. # Columns #
  118. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  119. # # # # #
  120. # Name # Type # Flags # Description #
  121. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  122. # ID_owner # Number # # Owner of the HHK. #
  123. # ID_scope # Number # # Scope of the HHK. #
  124. # Storage # LongText # Null # Location and name of the CHM. #
  125. # File # LongText # Null # Name of the HHK file inside the CHM. #
  126. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  127. # #
  128. # Indexes #
  129. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  130. # # # # #
  131. # Name # Definition # Kind # Description #
  132. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  133. # ByScope # +ID_scope # # Used during add/remove. #
  134. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  135. ##################################################################################################################################
  136. ##################################################################################################################################
  137. # #
  138. # Table: FullTextSearch #
  139. # #
  140. # Columns #
  141. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  142. # # # # #
  143. # Name # Type # Flags # Description #
  144. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  145. # ID_owner # Number # # Owner of the CHM. #
  146. # ID_scope # Number # # Scope of the CHM. #
  147. # CHM # LongText # Null # Location and name of the associated CHM. #
  148. # CHQ # LongText # Null # Location and name of the CHQ. #
  149. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  150. # #
  151. # Indexes #
  152. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  153. # # # # #
  154. # Name # Definition # Kind # Description #
  155. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  156. # ByScope # +ID_scope # # Used during add/remove. #
  157. #-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
  158. ##################################################################################################################################
  159. ##################################################################################################################################
  160. # #
  161. # Table: Taxonomy #
  162. # #
  163. # Columns #
  164. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  165. # # # # #
  166. # Name # Type # Flags # Description #
  167. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  168. # ID_node # Number # Autoincrement # Identifier for the node. #
  169. # Pos # Number # # Order in which to display the node. #
  170. # ID_parent # Number # Null # Parent of the current node. #
  171. # ID_owner # Number # # Owner of the node. #
  172. # Entry # Text # # Single component in the taxonomy path. #
  173. # Title # LongText # Null # Display string. #
  174. # Description # LongText # Null # Description of the node. #
  175. # DescriptionURI # LongText # Null # Alternative description of the node, as an HTML page to display. #
  176. # IconURI # LongText # Null # Optional icon for the node. #
  177. # Visible # Bool # # Boolean value to determine whether it should be visible under XMLTOC. #
  178. # Subsite # Bool # # Boolean value to determine whether this is a data island or not. #
  179. # NavModel # Long # # Type of the navigation model. #
  180. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  181. # #
  182. # Indexes #
  183. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  184. # # # # #
  185. # Name # Definition # Kind # Description #
  186. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  187. # SubNode # +ID_parent +Entry # Primary & Unique # Used to locate a node under a certain parent. #
  188. # Children # +ID_parent # External to Taxonomy # Used to find all the subnodes of a specified node. #
  189. # Node # +ID_node # Unique # Used to locate a specific node. #
  190. #----------------#---------------------#-----------------------------------#-----------------------------------------------------#
  191. ##################################################################################################################################
  192. ##################################################################################################################################
  193. # #
  194. # Table: Topics #
  195. # #
  196. # Columns #
  197. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  198. # # # # #
  199. # Name # Type # Flags # Description #
  200. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  201. # ID_topic # Number # Autoincrement # Unique Identified for the topic. #
  202. # ID_node # Number # # Position on the taxonomy. #
  203. # ID_owner # Number # # Owner of the topic. #
  204. # Pos # Number # # Order in which to display the topic. #
  205. # Title # LongText # Null # Display string. #
  206. # URI # LongText # Null # Hyperlink for the contents. #
  207. # Description # LongText # Null # Long description of the topic. #
  208. # IconURI # LongText # Null # Optional icon for the node. #
  209. # Type # Number # # The type of topic. #
  210. # Visible # Bool # # Boolean value to determine whether it should be visible under XMLTOC. #
  211. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  212. # #
  213. # Indexes #
  214. #-----------------#---------------#----------------------------------------#-----------------------------------------------------#
  215. # # # # #
  216. # Name # Definition # Kind # Description #
  217. #-----------------#---------------#----------------------------------------#-----------------------------------------------------#
  218. # SingleTopic # +ID_topic # Primary & Unique # Used during search, to find a topic. #
  219. # TopicsUnderNode # +ID_node # External to Taxonomy # Used to located all the topics under a certain node.#
  220. # ByURI # +URI # # Used to locate the topics for an URL. #
  221. #-----------------#---------------#----------------------------------------#-----------------------------------------------------#
  222. ##################################################################################################################################
  223. ##################################################################################################################################
  224. # #
  225. # Table: Synonyms #
  226. # #
  227. # Columns #
  228. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  229. # # # # #
  230. # Name # Type # Flags # Description #
  231. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  232. # Keyword # Text # # Keyword name. #
  233. # ID_synset # Number # # Synset number. #
  234. # ID_owner # Number # # Owner of the synset. #
  235. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  236. # #
  237. # Indexes #
  238. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  239. # # # # #
  240. # Name # Definition # Kind # Description #
  241. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  242. # ByPair # +Keyword+ID_synset # Primary & Unique # Used to look up the owner of a synset. #
  243. # ByName # +Keyword # # Used to look up the ID of a synset. #
  244. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  245. ##################################################################################################################################
  246. ##################################################################################################################################
  247. # #
  248. # Table: Keywords #
  249. # #
  250. # Columns #
  251. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  252. # # # # #
  253. # Name # Type # Flags # Description #
  254. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  255. # Keyword # Text # # Keyword name. #
  256. # ID_keyword # Number # Autoincrement # Keyword number. #
  257. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  258. # #
  259. # Indexes #
  260. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  261. # # # # #
  262. # Name # Definition # Kind # Description #
  263. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  264. # ByName # +Keyword # Primary & Unique # Used to look up the ID of a keyword. #
  265. #--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
  266. ##################################################################################################################################
  267. ##################################################################################################################################
  268. # #
  269. # Table: Matches #
  270. # #
  271. # Columns #
  272. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  273. # # # # #
  274. # Name # Type # Flags # Description #
  275. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  276. # ID_topic # Number # # External Key into "Topics" table. #
  277. # ID_keyword # Number # # External Key into "Keywords" table. #
  278. # Priority # Number # # To sort results. #
  279. # HHK # Bool # # Boolean value to determine whether it should make it to the Merged HHK. #
  280. #-------------------#------------#-------------------#---------------------------------------------------------------------------#
  281. # #
  282. # Indexes #
  283. #-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
  284. # # # # #
  285. # Name # Definition # Kind # Description #
  286. #-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
  287. # Pair # +ID_keyword +ID_topic # Primary & Unique # Used to locate the topics associated with a keyword.#
  288. # ByKeyword # +ID_keyword # External to Keywords # Used to locate the topics associated with a keyword.#
  289. # ByTopic # +ID_topic # External to Topics # Used to locate the keywords accociated with a topic.#
  290. #-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
  291. ##################################################################################################################################
  292. /////////////////////////////////////////////////////////////////////////////////
  293. // //
  294. // OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD //
  295. // //
  296. /////////////////////////////////////////////////////////////////////////////////
  297. DbParameters:
  298. Name Text
  299. Value LongText
  300. ContentOwners:
  301. OWID AutoNumber
  302. DN Text
  303. NodeOwners:
  304. NOID AutoNumber
  305. OWID Number
  306. SuperKeywords:
  307. KID AutoNumber
  308. EID Number
  309. Keyword Text
  310. Matches:
  311. OID Number External Key into topics database
  312. KID Number Unique Keyword, which was originally submitted for the match.
  313. EID Number Equivalent Keyword ID associated with the match.
  314. HHK Yes/No Boolean value to determine whether it should make it to the Merged HHK
  315. Title LongText Alternative title to be shown
  316. Topics:
  317. OID AutoNumber Unique ID entered when creating this TOC from the parsing process
  318. Category LongText Path to the node in the taxonomy.
  319. Entry Text
  320. URI HyperLink
  321. Title Text
  322. Description LongText
  323. Type Number
  324. OWID Number