最新リリース情報

Data Base Scripts (createLog.sql-0.1)2009-05-22 15:46

最近の更新

2009-06-14
2009-06-04
2009-04-16
2009-02-04
2009-01-16
2008-12-05
2008-09-09
2008-09-01
2008-08-28
2008-06-12
2008-05-19
2008-05-13
2008-04-24
2008-04-21
2008-04-17
2008-04-16

編集

Outline
  1. XML Schema

XML Schema

  1. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  2. <xs:schema version="1.0" xmlns:ns1="http://www.loveapple.cn/common/services/entities" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  3. <xs:import namespace="http://www.loveapple.cn/common/services/entities" schemaLocation="schema/entities/entities.xsd"/>
  4. <xs:complexType name="admingstratorGroup">
  5. <xs:sequence>
  6. <xs:element name="createDate" type="xs:dateTime" minOccurs="0"/>
  7. <xs:element name="creator" type="xs:long" minOccurs="0"/>
  8. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  9. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  10. <xs:element name="id" type="xs:long" minOccurs="0"/>
  11. <xs:element name="name" type="xs:string" minOccurs="0"/>
  12. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  13. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  14. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  15. </xs:sequence>
  16. </xs:complexType>
  17. <xs:complexType name="administrator">
  18. <xs:sequence>
  19. <xs:element name="createDate" type="xs:dateTime" minOccurs="0"/>
  20. <xs:element name="creator" type="xs:long" minOccurs="0"/>
  21. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  22. <xs:element name="frontId" type="xs:long" minOccurs="0"/>
  23. <xs:element name="groupId" type="xs:long" minOccurs="0"/>
  24. <xs:element name="id" type="xs:long" minOccurs="0"/>
  25. <xs:element name="name" type="xs:string" minOccurs="0"/>
  26. <xs:element name="passwd" type="xs:string" minOccurs="0"/>
  27. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  28. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  29. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  30. </xs:sequence>
  31. </xs:complexType>
  32. <xs:complexType name="category">
  33. <xs:sequence>
  34. <xs:element name="defaultPath" type="xs:string" minOccurs="0"/>
  35. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  36. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  37. <xs:element name="id" type="xs:long" minOccurs="0"/>
  38. <xs:element name="modelId" type="xs:int" minOccurs="0"/>
  39. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  40. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  41. <xs:element name="templateId" type="xs:long" minOccurs="0"/>
  42. <xs:element name="title" type="xs:string" minOccurs="0"/>
  43. <xs:element name="typeId" type="xs:long" minOccurs="0"/>
  44. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  45. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  46. </xs:sequence>
  47. </xs:complexType>
  48. <xs:complexType name="categoryContentsMapping">
  49. <xs:sequence>
  50. <xs:element name="category" type="category" minOccurs="0"/>
  51. <xs:element name="categoryId" type="xs:long" minOccurs="0"/>
  52. <xs:element name="categoryList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
  53. <xs:element name="contents" type="contents" minOccurs="0"/>
  54. <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
  55. <xs:element name="contentsList" type="contents" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
  56. <xs:element name="id" type="xs:long" minOccurs="0"/>
  57. <xs:element name="order" type="xs:int" minOccurs="0"/>
  58. <xs:element name="update" type="xs:dateTime" minOccurs="0"/>
  59. </xs:sequence>
  60. </xs:complexType>
  61. <xs:complexType name="contents">
  62. <xs:sequence>
  63. <xs:element name="accessKey" type="xs:string" minOccurs="0"/>
  64. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  65. <xs:element name="id" type="xs:long" minOccurs="0"/>
  66. <xs:element name="modelId" type="xs:int" minOccurs="0"/>
  67. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  68. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  69. <xs:element name="templateId" type="xs:long" minOccurs="0"/>
  70. <xs:element name="title" type="xs:string" minOccurs="0"/>
  71. <xs:element name="perContentsId" type="xs:long" minOccurs="0"/>
  72. </xs:sequence>
  73. </xs:complexType>
  74. <xs:complexType name="categoryMapping">
  75. <xs:sequence>
  76. <xs:element name="id" type="xs:long" minOccurs="0"/>
  77. <xs:element name="subCategory" type="category" minOccurs="0"/>
  78. <xs:element name="subId" type="xs:long" minOccurs="0"/>
  79. <xs:element name="subList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
  80. <xs:element name="superCategory" type="category" minOccurs="0"/>
  81. <xs:element name="superId" type="xs:long" minOccurs="0"/>
  82. <xs:element name="superList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
  83. </xs:sequence>
  84. </xs:complexType>
  85. <xs:complexType name="categoryType">
  86. <xs:sequence>
  87. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  88. <xs:element name="id" type="xs:long" minOccurs="0"/>
  89. <xs:element name="name" type="xs:string" minOccurs="0"/>
  90. <xs:element name="order" type="xs:int" minOccurs="0"/>
  91. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  92. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  93. </xs:sequence>
  94. </xs:complexType>
  95. <xs:complexType name="contentsBody">
  96. <xs:sequence>
  97. <xs:element name="body" type="xs:string" minOccurs="0"/>
  98. <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
  99. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  100. <xs:element name="id" type="xs:long" minOccurs="0"/>
  101. <xs:element name="pager" type="xs:int" minOccurs="0"/>
  102. <xs:element name="tags" type="xs:string" minOccurs="0"/>
  103. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  104. </xs:sequence>
  105. </xs:complexType>
  106. <xs:complexType name="contentsComment">
  107. <xs:sequence>
  108. <xs:element name="commentBodyId" type="xs:long" minOccurs="0"/>
  109. <xs:element name="commentbody" type="xs:string" minOccurs="0"/>
  110. <xs:element name="creator" type="xs:long" minOccurs="0"/>
  111. <xs:element name="id" type="xs:long" minOccurs="0"/>
  112. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  113. </xs:sequence>
  114. </xs:complexType>
  115. <xs:complexType name="customTag">
  116. <xs:sequence>
  117. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  118. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  119. <xs:element name="id" type="xs:long" minOccurs="0"/>
  120. <xs:element name="name" type="xs:string" minOccurs="0"/>
  121. <xs:element name="node" type="xs:string" minOccurs="0"/>
  122. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  123. <xs:element name="script" type="xs:string" minOccurs="0"/>
  124. <xs:element name="update" type="xs:dateTime" minOccurs="0"/>
  125. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  126. </xs:sequence>
  127. </xs:complexType>
  128. <xs:complexType name="file">
  129. <xs:sequence>
  130. <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
  131. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  132. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  133. <xs:element name="id" type="xs:long" minOccurs="0"/>
  134. <xs:element name="name" type="xs:string" minOccurs="0"/>
  135. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  136. <xs:element name="path" type="xs:string" minOccurs="0"/>
  137. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  138. <xs:element name="serviceId" type="xs:long" minOccurs="0"/>
  139. <xs:element name="typeId" type="xs:int" minOccurs="0"/>
  140. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  141. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  142. </xs:sequence>
  143. </xs:complexType>
  144. <xs:complexType name="fileType">
  145. <xs:sequence>
  146. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  147. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  148. <xs:element name="extension" type="xs:string" minOccurs="0"/>
  149. <xs:element name="id" type="xs:int" minOccurs="0"/>
  150. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  151. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  152. </xs:sequence>
  153. </xs:complexType>
  154. <xs:complexType name="htmlTagMst">
  155. <xs:sequence>
  156. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  157. <xs:element name="id" type="xs:int" minOccurs="0"/>
  158. <xs:element name="name" type="xs:string" minOccurs="0"/>
  159. <xs:element name="options" type="xs:string" minOccurs="0"/>
  160. <xs:element name="status" type="xs:int" minOccurs="0"/>
  161. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  162. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  163. </xs:sequence>
  164. </xs:complexType>
  165. <xs:complexType name="keyword">
  166. <xs:sequence>
  167. <xs:element name="id" type="xs:long" minOccurs="0"/>
  168. <xs:element name="name" type="xs:string" minOccurs="0"/>
  169. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  170. </xs:sequence>
  171. </xs:complexType>
  172. <xs:complexType name="liking">
  173. <xs:sequence>
  174. <xs:element name="id" type="xs:long" minOccurs="0"/>
  175. <xs:element name="name" type="xs:string" minOccurs="0"/>
  176. </xs:sequence>
  177. </xs:complexType>
  178. <xs:complexType name="likingBook">
  179. <xs:sequence>
  180. <xs:element name="id" type="xs:long" minOccurs="0"/>
  181. <xs:element name="isbn" type="xs:string" minOccurs="0"/>
  182. <xs:element name="name" type="xs:string" minOccurs="0"/>
  183. </xs:sequence>
  184. </xs:complexType>
  185. <xs:complexType name="likingBookMapping">
  186. <xs:sequence>
  187. <xs:element name="likingBookId" type="xs:long" minOccurs="0"/>
  188. <xs:element name="profileId" type="xs:long" minOccurs="0"/>
  189. </xs:sequence>
  190. </xs:complexType>
  191. <xs:complexType name="likingMapping">
  192. <xs:sequence>
  193. <xs:element name="likingId" type="xs:long" minOccurs="0"/>
  194. <xs:element name="profileId" type="xs:long" minOccurs="0"/>
  195. </xs:sequence>
  196. </xs:complexType>
  197. <xs:complexType name="likingMovesMapping">
  198. <xs:sequence>
  199. <xs:element name="likingMoviesId" type="xs:long" minOccurs="0"/>
  200. <xs:element name="profileId" type="xs:long" minOccurs="0"/>
  201. </xs:sequence>
  202. </xs:complexType>
  203. <xs:complexType name="likingMovies">
  204. <xs:sequence>
  205. <xs:element name="id" type="xs:long" minOccurs="0"/>
  206. <xs:element name="name" type="xs:string" minOccurs="0"/>
  207. <xs:element name="youTubeId" type="xs:string" minOccurs="0"/>
  208. </xs:sequence>
  209. </xs:complexType>
  210. <xs:complexType name="member">
  211. <xs:sequence>
  212. <xs:element name="creatorId" type="xs:long" minOccurs="0"/>
  213. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  214. <xs:element name="id" type="xs:long" minOccurs="0"/>
  215. <xs:element name="loginDate" type="xs:dateTime" minOccurs="0"/>
  216. <xs:element name="mail" type="xs:string" minOccurs="0"/>
  217. <xs:element name="modelId" type="xs:int" minOccurs="0"/>
  218. <xs:element name="msn" type="xs:string" minOccurs="0"/>
  219. <xs:element name="nickName" type="xs:string" minOccurs="0"/>
  220. <xs:element name="passwd" type="xs:string" minOccurs="0"/>
  221. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  222. <xs:element name="qqNo" type="xs:string" minOccurs="0"/>
  223. <xs:element name="registerDate" type="xs:dateTime" minOccurs="0"/>
  224. <xs:element name="unicKey" type="xs:string" minOccurs="0"/>
  225. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  226. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  227. </xs:sequence>
  228. </xs:complexType>
  229. <xs:complexType name="memberAttributeItemMaster">
  230. <xs:sequence>
  231. <xs:element name="attributeId" type="xs:long" minOccurs="0"/>
  232. <xs:element name="id" type="xs:long" minOccurs="0"/>
  233. <xs:element name="item" type="xs:string" minOccurs="0"/>
  234. </xs:sequence>
  235. </xs:complexType>
  236. <xs:complexType name="memberAttributeMaster">
  237. <xs:sequence>
  238. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  239. <xs:element name="id" type="xs:long" minOccurs="0"/>
  240. <xs:element name="name" type="xs:string" minOccurs="0"/>
  241. <xs:element name="type" type="xs:string" minOccurs="0"/>
  242. </xs:sequence>
  243. </xs:complexType>
  244. <xs:complexType name="memberAttributeValue">
  245. <xs:sequence>
  246. <xs:element name="attributeId" type="xs:long" minOccurs="0"/>
  247. <xs:element name="attributeItemId" type="xs:long" minOccurs="0"/>
  248. <xs:element name="memberId" type="xs:long" minOccurs="0"/>
  249. <xs:element name="value" type="xs:string" minOccurs="0"/>
  250. </xs:sequence>
  251. </xs:complexType>
  252. <xs:complexType name="memberGroup">
  253. <xs:sequence>
  254. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  255. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  256. <xs:element name="id" type="xs:long" minOccurs="0"/>
  257. <xs:element name="name" type="xs:string" minOccurs="0"/>
  258. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  259. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  260. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  261. </xs:sequence>
  262. </xs:complexType>
  263. <xs:complexType name="memberGroupMapping">
  264. <xs:sequence>
  265. <xs:element name="groupId" type="xs:long" minOccurs="0"/>
  266. <xs:element name="memberId" type="xs:long" minOccurs="0"/>
  267. </xs:sequence>
  268. </xs:complexType>
  269. <xs:complexType name="modelMst">
  270. <xs:sequence>
  271. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  272. <xs:element name="id" type="xs:int" minOccurs="0"/>
  273. <xs:element name="name" type="xs:string" minOccurs="0"/>
  274. </xs:sequence>
  275. </xs:complexType>
  276. <xs:complexType name="moduleList">
  277. <xs:sequence>
  278. <xs:element name="fileId" type="xs:long" minOccurs="0"/>
  279. <xs:element name="id" type="xs:long" minOccurs="0"/>
  280. <xs:element name="pluginId" type="xs:long" minOccurs="0"/>
  281. </xs:sequence>
  282. </xs:complexType>
  283. <xs:complexType name="permission">
  284. <xs:sequence>
  285. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  286. <xs:element name="id" type="xs:int" minOccurs="0"/>
  287. <xs:element name="name" type="xs:string" minOccurs="0"/>
  288. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  289. </xs:sequence>
  290. </xs:complexType>
  291. <xs:complexType name="pluginList">
  292. <xs:sequence>
  293. <xs:element name="id" type="xs:long" minOccurs="0"/>
  294. <xs:element name="memberId" type="xs:long" minOccurs="0"/>
  295. <xs:element name="pluginId" type="xs:long" minOccurs="0"/>
  296. <xs:element name="status" type="xs:string" minOccurs="0"/>
  297. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  298. <xs:element name="version" type="xs:double" minOccurs="0"/>
  299. </xs:sequence>
  300. </xs:complexType>
  301. <xs:complexType name="pluginRegistory">
  302. <xs:sequence>
  303. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  304. <xs:element name="id" type="xs:long" minOccurs="0"/>
  305. <xs:element name="name" type="xs:string" minOccurs="0"/>
  306. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  307. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  308. <xs:element name="status" type="xs:string" minOccurs="0"/>
  309. <xs:element name="title" type="xs:string" minOccurs="0"/>
  310. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  311. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  312. <xs:element name="version" type="xs:double" minOccurs="0"/>
  313. </xs:sequence>
  314. </xs:complexType>
  315. <xs:complexType name="profile">
  316. <xs:sequence>
  317. <xs:element name="addressArea" type="xs:string" minOccurs="0"/>
  318. <xs:element name="addressCity" type="xs:string" minOccurs="0"/>
  319. <xs:element name="addressOther1" type="xs:string" minOccurs="0"/>
  320. <xs:element name="addressOther2" type="xs:string" minOccurs="0"/>
  321. <xs:element name="familyName" type="xs:string" minOccurs="0"/>
  322. <xs:element name="firstName" type="xs:string" minOccurs="0"/>
  323. <xs:element name="id" type="xs:long" minOccurs="0"/>
  324. <xs:element name="memberId" type="xs:long" minOccurs="0"/>
  325. <xs:element name="middleName" type="xs:string" minOccurs="0"/>
  326. <xs:element name="sign" type="xs:string" minOccurs="0"/>
  327. <xs:element name="zipCode" type="xs:string" minOccurs="0"/>
  328. </xs:sequence>
  329. </xs:complexType>
  330. <xs:complexType name="serviceMst">
  331. <xs:sequence>
  332. <xs:element name="attribute1" type="xs:string" minOccurs="0"/>
  333. <xs:element name="attribute2" type="xs:string" minOccurs="0"/>
  334. <xs:element name="attribute3" type="xs:string" minOccurs="0"/>
  335. <xs:element name="attributeName1" type="xs:string" minOccurs="0"/>
  336. <xs:element name="attributeName2" type="xs:string" minOccurs="0"/>
  337. <xs:element name="attributeName3" type="xs:string" minOccurs="0"/>
  338. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  339. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  340. <xs:element name="id" type="xs:long" minOccurs="0"/>
  341. <xs:element name="mail" type="xs:string" minOccurs="0"/>
  342. <xs:element name="name" type="xs:string" minOccurs="0"/>
  343. <xs:element name="order" type="xs:int" minOccurs="0"/>
  344. <xs:element name="owner" type="xs:long" minOccurs="0"/>
  345. <xs:element name="passwd" type="xs:string" minOccurs="0"/>
  346. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  347. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  348. </xs:sequence>
  349. </xs:complexType>
  350. <xs:complexType name="siteConfig">
  351. <xs:sequence>
  352. <xs:element name="connectionScheme" type="xs:string" minOccurs="0"/>
  353. <xs:element name="contentsIndexPath" type="xs:string" minOccurs="0"/>
  354. <xs:element name="detail" type="xs:string" minOccurs="0"/>
  355. <xs:element name="localArea" type="xs:string" minOccurs="0"/>
  356. <xs:element name="localDocumentRoot" type="xs:string" minOccurs="0"/>
  357. <xs:element name="localLang" type="xs:string" minOccurs="0"/>
  358. <xs:element name="memberId" type="xs:long" minOccurs="0"/>
  359. <xs:element name="name" type="xs:string" minOccurs="0"/>
  360. <xs:element name="publicKeyFilePath" type="xs:string" minOccurs="0"/>
  361. <xs:element name="remoteDocumentRoot" type="xs:string" minOccurs="0"/>
  362. <xs:element name="remoteHost" type="xs:string" minOccurs="0"/>
  363. <xs:element name="timeZone" type="xs:string" minOccurs="0"/>
  364. </xs:sequence>
  365. </xs:complexType>
  366. <xs:complexType name="template">
  367. <xs:sequence>
  368. <xs:element name="body" type="xs:string" minOccurs="0"/>
  369. <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
  370. <xs:element name="id" type="xs:long" minOccurs="0"/>
  371. <xs:element name="name" type="xs:string" minOccurs="0"/>
  372. <xs:element name="order" type="xs:int" minOccurs="0"/>
  373. <xs:element name="permission" type="xs:int" minOccurs="0"/>
  374. <xs:element name="type" type="xs:int" minOccurs="0"/>
  375. <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
  376. <xs:element name="updator" type="xs:long" minOccurs="0"/>
  377. </xs:sequence>
  378. </xs:complexType>
  379. </xs:schema>