...
None
Examples
| Code Block |
|---|
| xml |
|---|
| xml | linenumbers | true
|---|
| title | Basic SQL Server connection |
|---|
|
<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>
|
| Code Block |
|---|
| sql |
|---|
| sql |
|---|
| title | SQL create statement for gt_pk_metadata table |
|---|
|
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)
)
|
pk_policy can be 'assigned', 'sequence' or 'autogenerated' depending upon how the key column value is generated. The pk_sequence value only need to be set if the policy is 'sequence'.