ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:column_attributes

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:dictionary:column_attributes [2016/04/03 01:10] – [INDEX] mnewnhamv5:dictionary:column_attributes [2024/08/31 16:26] (current) – multiple column definitions separated by comma dregad
Line 1: Line 1:
 ======= Dictionary Column Attributes ======= ======= Dictionary Column Attributes =======
 ====== Description ====== ====== Description ======
-When creating a column in a table using the dictionary methods, the information provided must confirm to the following specification. Each column created has a number of mandatory and optional parameters. +When creating a column in a table using the dictionary methods, the information provided must conform to the following specification. Each column created has a number of mandatory and optional parameters. 
--------------------------------- +
-<WRAP right info 300px> +
-$fields is a string, not an array +
-</WRAP>+
 ====== Basic Syntax ====== ====== Basic Syntax ======
 +
 The basic syntax of the attributes is as follows:  The basic syntax of the attributes is as follows: 
  
-  * All the information for the column must occur on a single line. +  * All the information for a given column must occur on a single line. 
 +  * Multiple columns definitions must be separated by a comma '',''
   * The line ending may be a newline or carriage return/newline combination.    * The line ending may be a newline or carriage return/newline combination. 
   * Each attribute must be separated by at least one tab or space.    * Each attribute must be separated by at least one tab or space. 
Line 41: Line 40:
 =======  Attributes ===== =======  Attributes =====
 ===== Column Name ===== ===== Column Name =====
-  * The column name must conform to any database specific standards related to naming and length. +  * The column name must conform to any database specific standards related to naming and length. If the name contains spaces, then it should be surrounded by backticks '' `col with spaces` ''. Note that this is an internal designator, and does not represent the character used by the database in SQL statements.                                                          
- +
 ===== Meta Attributes ===== ===== Meta Attributes =====
   * The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5:dictionary:metatype|metaType]] descriptions, not the database definition for the type.   * The column attributes in terms of type and length **must** be specified in terms of ADODb [[v5:dictionary:metatype|metaType]] descriptions, not the database definition for the type.
Line 60: Line 58:
 </WRAP> </WRAP>
 ==== CONSTRAINT ==== ==== CONSTRAINT ====
 +Adds a constraint to column. The syntax for the constraint must be defined as required by the database.
 -------------------------- --------------------------
 <WRAP right box 150px> <WRAP right box 150px>
Line 84: Line 82:
 </WRAP> </WRAP>
 ==== ENUM ==== ==== ENUM ====
-In databases that support the ENUM datatype, append a parenthesized, quoted list of enum values +In databases that support the //**ENUM**// datatype, append a parenthesized, quoted list of enum values 
   ENUM('lions','tigers','halibut')   ENUM('lions','tigers','halibut')
      
Line 96: Line 94:
 Creates a single column index using the same name as the column, with 'idx_' prepended to the name, e.g. a column of name ''column1'' will create an index of name ''idx_column1''. Creates a single column index using the same name as the column, with 'idx_' prepended to the name, e.g. a column of name ''column1'' will create an index of name ''idx_column1''.
 ------------------------------- -------------------------------
-==== KEY ==== 
  
---------------------------------+<WRAP right box 150px> 
 +** Usage: Any ** 
 +</WRAP>
 ==== NOQUOTE ==== ==== NOQUOTE ====
 +Prevents ADOdb from applying the normal quoting rules to tables, columns and indexes. For example, a column name that contains a special character such as  //**some-column**// will be automatically quoted to **//'some-column'//**. This tag prevents the behavior.
 -------------------------------- --------------------------------
 <WRAP right box 150px> <WRAP right box 150px>
Line 111: Line 110:
 **Usage: Column** **Usage: Column**
 </WRAP> </WRAP>
-==== PRIMARY ====+==== PRIMARY or KEY ====
 Indicates if the column is part of the [[wp>Unique Key|Primary Key]] of the table. Indicates if the column is part of the [[wp>Unique Key|Primary Key]] of the table.
 --------------------------- ---------------------------
Line 125: Line 124:
 </WRAP> </WRAP>
 ==== UNSIGNED ==== ==== UNSIGNED ====
 +Creates an unsigned integer.
v5/dictionary/column_attributes.1459638628.txt.gz · Last modified: (external edit)