Data Base Scripts (createLog.sql-0.1) | 2009-05-22 15:46 |
- <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
- <xs:schema version="1.0" xmlns:ns1="http://www.loveapple.cn/common/services/entities" xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:import namespace="http://www.loveapple.cn/common/services/entities" schemaLocation="schema/entities/entities.xsd"/>
- <xs:complexType name="admingstratorGroup">
- <xs:sequence>
- <xs:element name="createDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="creator" type="xs:long" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="administrator">
- <xs:sequence>
- <xs:element name="createDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="creator" type="xs:long" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="frontId" type="xs:long" minOccurs="0"/>
- <xs:element name="groupId" type="xs:long" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="passwd" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="category">
- <xs:sequence>
- <xs:element name="defaultPath" type="xs:string" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="modelId" type="xs:int" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="templateId" type="xs:long" minOccurs="0"/>
- <xs:element name="title" type="xs:string" minOccurs="0"/>
- <xs:element name="typeId" type="xs:long" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="categoryContentsMapping">
- <xs:sequence>
- <xs:element name="category" type="category" minOccurs="0"/>
- <xs:element name="categoryId" type="xs:long" minOccurs="0"/>
- <xs:element name="categoryList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
- <xs:element name="contents" type="contents" minOccurs="0"/>
- <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
- <xs:element name="contentsList" type="contents" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="order" type="xs:int" minOccurs="0"/>
- <xs:element name="update" type="xs:dateTime" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="contents">
- <xs:sequence>
- <xs:element name="accessKey" type="xs:string" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="modelId" type="xs:int" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="templateId" type="xs:long" minOccurs="0"/>
- <xs:element name="title" type="xs:string" minOccurs="0"/>
- <xs:element name="perContentsId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="categoryMapping">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="subCategory" type="category" minOccurs="0"/>
- <xs:element name="subId" type="xs:long" minOccurs="0"/>
- <xs:element name="subList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
- <xs:element name="superCategory" type="category" minOccurs="0"/>
- <xs:element name="superId" type="xs:long" minOccurs="0"/>
- <xs:element name="superList" type="category" nillable="true" minOccurs="0" maxOccurs="unbounded"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="categoryType">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="order" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="contentsBody">
- <xs:sequence>
- <xs:element name="body" type="xs:string" minOccurs="0"/>
- <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="pager" type="xs:int" minOccurs="0"/>
- <xs:element name="tags" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="contentsComment">
- <xs:sequence>
- <xs:element name="commentBodyId" type="xs:long" minOccurs="0"/>
- <xs:element name="commentbody" type="xs:string" minOccurs="0"/>
- <xs:element name="creator" type="xs:long" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="customTag">
- <xs:sequence>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="node" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="script" type="xs:string" minOccurs="0"/>
- <xs:element name="update" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="file">
- <xs:sequence>
- <xs:element name="contentsId" type="xs:long" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- <xs:element name="path" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="serviceId" type="xs:long" minOccurs="0"/>
- <xs:element name="typeId" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="fileType">
- <xs:sequence>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="extension" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="htmlTagMst">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:int" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="options" type="xs:string" minOccurs="0"/>
- <xs:element name="status" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="keyword">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="liking">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="likingBook">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="isbn" type="xs:string" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="likingBookMapping">
- <xs:sequence>
- <xs:element name="likingBookId" type="xs:long" minOccurs="0"/>
- <xs:element name="profileId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="likingMapping">
- <xs:sequence>
- <xs:element name="likingId" type="xs:long" minOccurs="0"/>
- <xs:element name="profileId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="likingMovesMapping">
- <xs:sequence>
- <xs:element name="likingMoviesId" type="xs:long" minOccurs="0"/>
- <xs:element name="profileId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="likingMovies">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="youTubeId" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="member">
- <xs:sequence>
- <xs:element name="creatorId" type="xs:long" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="loginDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="mail" type="xs:string" minOccurs="0"/>
- <xs:element name="modelId" type="xs:int" minOccurs="0"/>
- <xs:element name="msn" type="xs:string" minOccurs="0"/>
- <xs:element name="nickName" type="xs:string" minOccurs="0"/>
- <xs:element name="passwd" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="qqNo" type="xs:string" minOccurs="0"/>
- <xs:element name="registerDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="unicKey" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="memberAttributeItemMaster">
- <xs:sequence>
- <xs:element name="attributeId" type="xs:long" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="item" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="memberAttributeMaster">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="type" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="memberAttributeValue">
- <xs:sequence>
- <xs:element name="attributeId" type="xs:long" minOccurs="0"/>
- <xs:element name="attributeItemId" type="xs:long" minOccurs="0"/>
- <xs:element name="memberId" type="xs:long" minOccurs="0"/>
- <xs:element name="value" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="memberGroup">
- <xs:sequence>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="memberGroupMapping">
- <xs:sequence>
- <xs:element name="groupId" type="xs:long" minOccurs="0"/>
- <xs:element name="memberId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="modelMst">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:int" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="moduleList">
- <xs:sequence>
- <xs:element name="fileId" type="xs:long" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="pluginId" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="permission">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:int" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="pluginList">
- <xs:sequence>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="memberId" type="xs:long" minOccurs="0"/>
- <xs:element name="pluginId" type="xs:long" minOccurs="0"/>
- <xs:element name="status" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="version" type="xs:double" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="pluginRegistory">
- <xs:sequence>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="status" type="xs:string" minOccurs="0"/>
- <xs:element name="title" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- <xs:element name="version" type="xs:double" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="profile">
- <xs:sequence>
- <xs:element name="addressArea" type="xs:string" minOccurs="0"/>
- <xs:element name="addressCity" type="xs:string" minOccurs="0"/>
- <xs:element name="addressOther1" type="xs:string" minOccurs="0"/>
- <xs:element name="addressOther2" type="xs:string" minOccurs="0"/>
- <xs:element name="familyName" type="xs:string" minOccurs="0"/>
- <xs:element name="firstName" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="memberId" type="xs:long" minOccurs="0"/>
- <xs:element name="middleName" type="xs:string" minOccurs="0"/>
- <xs:element name="sign" type="xs:string" minOccurs="0"/>
- <xs:element name="zipCode" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="serviceMst">
- <xs:sequence>
- <xs:element name="attribute1" type="xs:string" minOccurs="0"/>
- <xs:element name="attribute2" type="xs:string" minOccurs="0"/>
- <xs:element name="attribute3" type="xs:string" minOccurs="0"/>
- <xs:element name="attributeName1" type="xs:string" minOccurs="0"/>
- <xs:element name="attributeName2" type="xs:string" minOccurs="0"/>
- <xs:element name="attributeName3" type="xs:string" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="mail" type="xs:string" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="order" type="xs:int" minOccurs="0"/>
- <xs:element name="owner" type="xs:long" minOccurs="0"/>
- <xs:element name="passwd" type="xs:string" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="siteConfig">
- <xs:sequence>
- <xs:element name="connectionScheme" type="xs:string" minOccurs="0"/>
- <xs:element name="contentsIndexPath" type="xs:string" minOccurs="0"/>
- <xs:element name="detail" type="xs:string" minOccurs="0"/>
- <xs:element name="localArea" type="xs:string" minOccurs="0"/>
- <xs:element name="localDocumentRoot" type="xs:string" minOccurs="0"/>
- <xs:element name="localLang" type="xs:string" minOccurs="0"/>
- <xs:element name="memberId" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="publicKeyFilePath" type="xs:string" minOccurs="0"/>
- <xs:element name="remoteDocumentRoot" type="xs:string" minOccurs="0"/>
- <xs:element name="remoteHost" type="xs:string" minOccurs="0"/>
- <xs:element name="timeZone" type="xs:string" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- <xs:complexType name="template">
- <xs:sequence>
- <xs:element name="body" type="xs:string" minOccurs="0"/>
- <xs:element name="deleteFlg" type="xs:string" minOccurs="0"/>
- <xs:element name="id" type="xs:long" minOccurs="0"/>
- <xs:element name="name" type="xs:string" minOccurs="0"/>
- <xs:element name="order" type="xs:int" minOccurs="0"/>
- <xs:element name="permission" type="xs:int" minOccurs="0"/>
- <xs:element name="type" type="xs:int" minOccurs="0"/>
- <xs:element name="updateDate" type="xs:dateTime" minOccurs="0"/>
- <xs:element name="updator" type="xs:long" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- </xs:schema>
[ページ情報]
更新日時: 2008-12-05 14:50:19, 更新者: loveapple
[ライセンス]
GNU Free Documentation License
[権限]
表示:無制限, 編集:メンバー, 削除/設定:文書編集者