Versions Compared

Old Version 8

changes.mady.by.user Shaun Forbes

Saved on

compared with

New Version 9

changes.mady.by.user Shaun Forbes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

None

Examples

Code Block
xmlxml
titleBasic SQL Server connection
xml
<spatial:spatialengine id="sqlserver">
  <dbtype>sqlserver</dbtype>
  <host>sqlhost</host>
  <port>1434</port>
  <user>gis</user>
  <passwd>hak0rz</passwd>
  <schema>GIS</schema>
  <minconnection>2</minconnections>
  <validateconnections>true</validateconnections>
</spatial:spatialengine>
sql
Code Block
sql
titleSQL create statement for gt_pk_metadata table
sql
CREATE TABLE gt_pk_metadata (
  table_schema varchar(255),
  table_name varchar(255),
  pk_column varchar(255),
  pk_column_idx int,
  pk_policy varchar(255),
  pk_sequence varchar(255)
)

...