Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

---

ics:catalogmanager.createtable

Creates a table using ics:catalogmanager.

Syntax

<ics:catalogmanager>
   <ics:argument name="ftcmd" value="createtable" />
   <ics:argument name="tablename" value="table" />
   <ics:argument name="systable" value="no/obj"/>
   <ics:argument name="uploadDir" value="directory" />
   <ics:argument name="aclList" value="acl1,acl2..." />
   <ics:argument name="colnameN" value="name" />
   <ics:argument name="colvalueN" value="value"/>
</ics:catalogmanager>   

Parameters

ftcmd (required)

Value must be set to createtable.

tablename (required)

Name of the table to create.

systable (required)

Allows differentiation between ContentCatalog (systable=no) and ObjectCatalog (systable=obj). The default is ContentCatalog (systable=no).

uploadDir (required)

Server-side folder path to contain uploaded files.

aclList (optional)

Comma-separated list of ACLs. When security is enabled, only members of the ACLs can access content in the table.

colvalueN (required)

Database-specific field type for column.The value of N is 0 (zero) for the first column, 1 for the second column, and so on.

colnameN (required)

Column field name. Each colname parameter corresponds to a column in the table. The value of N is 0 (zero) for the first column, 1 for the second column, and so on.

Description

The createtable command creates a table. The table's primary key field name is defined in the Content Server properties file (futuretense.ini).

Note The default primary key used by CatalogManager is defined in the property cc.contentkey. Unlike a custom property for primary keys, the cc.contentkey property does not restrict the name of the tables that you create. The Object table column, version, is reserved for future use.

errno

The possible values of errno include:

Value	Description
-22	Table already exists.
-105	Database error.

Example

The following example creates a table by name ExampleTable.

<ics:catalogmanager>
    <ics:argument name="ftcmd" value="createtable" />
    <ics:argument name="tablename" value="ExampleTable" />
    <ics:argument name="systable" value="no" />
    <ics:argument name="uploadDir" value="/export/home/public" />
    <ics:argument name="colname0" value="id" />
    <ics:argument name="colvalue0" value="varchar(10) PRIMARY KEY NOT NULL" />
    <ics:argument name="colname1" value="description" />
    <ics:argument name="colvalue1" value="varchar(24)" />
    <ics:argument name="colname2" value="quantity" />
    <ics:argument name="colvalue2" value="int"/>
</ics:catalogmanager>
 

See Also

The following ics:catalogmanager command:

ics:catalogmanager.deletetable

		Home >	Contents >	Index >
	FatWire JSP Tag Reference Copyright 2005 by FatWire Software All rights reserved.