ejb-modeler-schema.xml~2~

一个很不错的电子商务后台管理系统 这是一个电子商务网站的后台管理系统 要运行此系统必须具备以下条件 1.首先要把SNSQL文本中的SQL脚本确保在SQL Server中执行 2.包Se

<?xml version="1.0" encoding="UTF-8"?>
<schema-root-node name="DataSources" node-type="0" status="0">
  <schema-connection-node name="snshop" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="shop" driver="weblogic.jdbc.sqlserver.SQLServerDriver" file="null-object" password="xian" sql-schema="null-object" url="jdbc:bea:sqlserver://localhost:1433" use-data-source="true" username="xian" all-schemas="true" all-views="true">
    <schema-table-node name="city" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="cid" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="city" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="cno" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="corder" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="5" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="sheng" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="dtproperties" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="id" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int identity" is-primary-key="true" />
      <schema-column-node name="lvalue" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="-4" ordinal="6" precision="-1" scale="-1" vendor-type-name="image" is-primary-key="false" />
      <schema-column-node name="objectid" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="property" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="3" precision="64" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="uvalue" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="255" scale="-1" vendor-type-name="nvarchar" is-primary-key="false" />
      <schema-column-node name="value" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="version" node-type="2" status="0" col-default="(0)" is-nullable="NO " java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="manager" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="admin" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="1" precision="25" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="popedom" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="pwd" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="omit" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="sid" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="sname" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="2" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
      <schema-column-node name="sno" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="sorder" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="sysconstraints" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="actions" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="6" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="colid" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="3" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
      <schema-column-node name="constid" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="error" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="id" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="spare1" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="-6" ordinal="4" precision="-1" scale="-1" vendor-type-name="tinyint" is-primary-key="false" />
      <schema-column-node name="status" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="5" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="syssegments" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="name" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="2" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="segment" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="status" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="userInfo" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="address" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="age" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="email" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="password" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="realName" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="15" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="sex" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="username" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="1" precision="25" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="userType" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="youBian" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="8" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
  </schema-connection-node>
</schema-root-node>