ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:setactualtype

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
v5:dictionary:setactualtype [2017/05/15 16:46] – [Usage] adjust formatting, fix typo dregadv5:dictionary:setactualtype [2017/07/22 18:39] (current) – mnewnham
Line 29: Line 29:
 $dict->setActualType('D','DATE'); $dict->setActualType('D','DATE');
 </code> </code>
-In the second example, we will create a new actual types so that we can use the ADOdb dictionary function to create tables containing geospatial information.+In the second example, we will create a new **actual type** so that we can use the ADOdb dictionary function to create tables containing geospatial information.
  
 <code php> <code php>
Line 41: Line 41:
  * Add 2 new columns to table  * Add 2 new columns to table
 */ */
-$columns = 'GEODATA G, POINTDATA P'; +$columns = 'GEODATA_COL G, POINTDATA_COL P'; 
-$sqlarray = $dict->addColumnSql('POSITION',$columns);+$sqlarray = $dict->addColumnSql('POSITION_TABLE',$columns);
    
 print_r($sqlarray); print_r($sqlarray);
Line 50: Line 50:
 Array Array
 ( (
- [0] => ALTER TABLE POSITION ADD GEODATA GEOMETRY + [0] => ALTER TABLE POSITION_TABLE ADD GEODATA_COL GEOMETRY 
- [1] => ALTER TABLE POSITION ADD POINTDATA POINT+ [1] => ALTER TABLE POSITION_TABLE ADD POINTDATA_COL POINT
 ) )
 */ */
v5/dictionary/setactualtype.txt · Last modified: 2017/07/22 18:39 by mnewnham