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
Last revisionBoth sides next revision
v5:dictionary:column_attributes [2016/04/03 01:09] – mnewnhamv5:dictionary:column_attributes [2016/04/03 01:34] – [ENUM] mnewnham
Line 2: Line 2:
 ====== 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 confirm 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: 
Line 60: Line 57:
 </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 81:
 </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 94: Line 91:
 </WRAP> </WRAP>
 ==== INDEX ==== ==== INDEX ====
-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 109:
 **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 123:
 </WRAP> </WRAP>
 ==== UNSIGNED ==== ==== UNSIGNED ====
 +Creates an unsigned integer.
v5/dictionary/column_attributes.txt · Last modified: 2022/09/02 04:11 by mnewnham