VbzCart/tables/cust phones - Revision history

Woozle: note about WhenUpd

2011-11-23T13:20:50Z

note about WhenUpd

← Older revision		Revision as of 13:20, 23 November 2011
Line 3:		Line 3:
	** '''2009-07-09''' moved to separate wiki page; no design changes		** '''2009-07-09''' moved to separate wiki page; no design changes
	** '''2011-11-23''' added WhenEnt, WhenUpd		** '''2011-11-23''' added WhenEnt, WhenUpd
			* '''Notes''':
			** (2011-11-23) Possibly WhenUpd should be removed and replaced with one or both of:
			*** WhenCnf (when confirmed) -- stamp whenever a new order is received that contains this email
			*** WhenEdt (when edited) -- stamp whenever an admin saves the record
			**: same for {{vbzcart/table\|cust_emails}} and {{vbzcart/table\|cust_names}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cust_phones` (		<section begin=sql /><mysql>CREATE TABLE `cust_phones` (

Woozle: added WhenEnt, WhenUpd

2011-11-23T13:09:35Z

added WhenEnt, WhenUpd

← Older revision		Revision as of 13:09, 23 November 2011
Line 2:		Line 2:
	* '''History''':		* '''History''':
	** '''2009-07-09''' moved to separate wiki page; no design changes		** '''2009-07-09''' moved to separate wiki page; no design changes
			** '''2011-11-23''' added WhenEnt, WhenUpd
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cust_phones` (		<section begin=sql /><mysql>CREATE TABLE `cust_phones` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Cust` INT COMMENT "core_custs.ID",		`WhenEnt` DATETIME NOT NULL COMMENT "date when record was first created",
	`Name` VARCHAR(31) COMMENT "human-assigned name (home, work...)",		`WhenUpd` DATETIME DEFAULT NULL COMMENT "date when record was last updated",
	`Phone` VARCHAR(31) COMMENT "phone number as entered/corrected",		`ID_Cust` INT COMMENT "core_custs.ID",
	`PhoneSrch` VARCHAR(31) COMMENT "Phone number in searchable form (no delimiters, no prefixes)",		`Name` VARCHAR(31) COMMENT "human-assigned name (home, work...)",
	`Descr` VARCHAR(63) COMMENT "any other notes (best times, etc.)",		`Phone` VARCHAR(31) COMMENT "phone number as entered/corrected",
	`isActive` BOOL DEFAULT FALSE,		`PhoneSrch` VARCHAR(31) COMMENT "Phone number in searchable form (no delimiters, no prefixes)",
			`Descr` VARCHAR(63) COMMENT "any other notes (best times, etc.)",
			`isActive` BOOL DEFAULT FALSE,
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: moved from "customer tables" page

2009-07-09T19:36:26Z

moved from "customer tables" page

New page

==About==
* '''History''':
** '''2009-07-09''' moved to separate wiki page; no design changes
==SQL==
<section begin=sql /><mysql>CREATE TABLE `cust_phones` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Cust` INT COMMENT "core_custs.ID",
`Name` VARCHAR(31) COMMENT "human-assigned name (home, work...)",
`Phone` VARCHAR(31) COMMENT "phone number as entered/corrected",
`PhoneSrch` VARCHAR(31) COMMENT "Phone number in searchable form (no delimiters, no prefixes)",
`Descr` VARCHAR(63) COMMENT "any other notes (best times, etc.)",
`isActive` BOOL DEFAULT FALSE,
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />