Difference between revisions of "VbzCart/tables/ord pull type"
Jump to navigation
Jump to search
(Group field) |
(Group->OptionGroup) |
||
Line 5: | Line 5: | ||
** '''2016-03-06''' | ** '''2016-03-06''' | ||
*** changed '''Notes''' to '''Reason''', because it's actually kind of important | *** changed '''Notes''' to '''Reason''', because it's actually kind of important | ||
− | *** added ''' | + | *** added '''OptionGroup''' field (originally "Group", but that's a reserved word) |
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `ord_pull_type` ( | <mysql>CREATE TABLE `ord_pull_type` ( | ||
− | `ID` | + | `ID` INT NOT NULL AUTO_INCREMENT, |
− | `Name` | + | `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", | + | `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> |
Revision as of 18:35, 6 March 2016
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>