Difference between revisions of "VbzCart/tables/ord pull type"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(New page: ==About== * '''Used by''': {{vbzcart|table|ord_pull}} * '''History''': ** '''2009-07-09''' adapted from MS Access (was: [Order Pull Types]) ==SQL== <section begin=sql /><mysql>CREATE TABLE...)
 
m
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{hdr/status/obsolete|This table (ord_pull_type) has been replaced by {{l/vbzcart/table|ord_hold_type}}.}}
 
==About==
 
==About==
 
* '''Used by''': {{vbzcart|table|ord_pull}}
 
* '''Used by''': {{vbzcart|table|ord_pull}}
 
* '''History''':
 
* '''History''':
 
** '''2009-07-09''' adapted from MS Access (was: [Order Pull Types])
 
** '''2009-07-09''' adapted from MS Access (was: [Order Pull Types])
 +
** '''2016-03-06'''
 +
*** changed '''Notes''' to '''Reason''', because it's actually kind of important
 +
*** added '''OptionGroup''' field (originally "Group", but that's a reserved word)
 
==SQL==
 
==SQL==
−
<section begin=sql /><mysql>CREATE TABLE `ord_pull_type` (
+
<mysql>CREATE TABLE `ord_pull_type` (
−
   `ID`   INT              NOT NULL AUTO_INCREMENT,
+
   `ID`           INT              NOT NULL AUTO_INCREMENT,
−
   `Name` VARCHAR(31)      NOT NULL COMMENT "brief name for this pull type",
+
   `Name`         VARCHAR(31)      NOT NULL COMMENT "brief name for this pull type",
−
   `Notes` VARCHAR(255) DEFAULT NULL COMMENT "usage notes",
+
   `Reason`       VARCHAR(255) DEFAULT NULL COMMENT "reason why this type would be used",
 +
  `OptionGroup`  VARCHAR(45)  DEFAULT NULL COMMENT "Optional grouping for drop-down lists",
 
PRIMARY KEY(`ID`)
 
PRIMARY KEY(`ID`)
 
)
 
)
 
ENGINE = MYISAM;</mysql>
 
ENGINE = MYISAM;</mysql>
−
<section end=sql />
 

Latest revision as of 11:14, 2 June 2017

This documentation is obsolete, and is being kept solely for archival purposes.
This table (ord_pull_type) has been replaced by ord_hold_type.

About

  • Used by: ord_pull
  • History:
    • 2009-07-09 adapted from MS Access (was: [Order Pull Types])
    • 2016-03-06
      • changed Notes to Reason, because it's actually kind of important
      • added OptionGroup field (originally "Group", but that's a reserved word)

SQL

<mysql>CREATE TABLE `ord_pull_type` ( 

 `ID`           INT              NOT NULL AUTO_INCREMENT,
 `Name`         VARCHAR(31)      NOT NULL COMMENT "brief name for this pull type",
 `Reason`       VARCHAR(255) DEFAULT NULL COMMENT "reason why this type would be used",
 `OptionGroup`  VARCHAR(45)  DEFAULT NULL COMMENT "Optional grouping for drop-down lists",

PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/ord_pull_type&oldid=22687"