VbzCart/tables/cust - Revision history

Woozle at 01:07, 3 July 2019

2019-07-03T01:07:18Z

← Older revision		Revision as of 01:07, 3 July 2019
Line 12:		Line 12:
	** '''2016-06-12''' switching definitions of WhenChanged and WhenUpdated		** '''2016-06-12''' switching definitions of WhenChanged and WhenUpdated
	*** Only one record had WhenUpdated set; very few have WhenChanged set.		*** Only one record had WhenUpdated set; very few have WhenChanged set.
	** '''2019-07-02''' renamed from "core_custs" to "cust" so it will group with the other customer tables		** '''2019-07-02'''
			*** renamed from "core_custs" to "cust" so it will group with the other customer tables
			*** removed NOT NULL constraint on ID_Name because we need to create this record before we create the {{l/vc/table\|cust_names}} record
			**** perhaps we can make this unnecessary later with transactions? but it messes with debugging, even so, so maybe we should just put in a post-creation test to make sure all necessary fields got filled in (log data error if not)
	==SQL==		==SQL==
	<source lang=mysql>CREATE TABLE `cust` (		<source lang=mysql>CREATE TABLE `cust` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Name` INT ~~NOT~~ NULL COMMENT "cust_names.ID of default name",		`ID_Name` INT DEFAULT NULL COMMENT "cust_names.ID of default name",
	`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",		`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",
	`ID_User` INT DEFAULT NULL COMMENT "core_users.ID of user for this customer",		`ID_User` INT DEFAULT NULL COMMENT "core_users.ID of user for this customer",

Woozle at 22:47, 2 July 2019

2019-07-02T22:47:31Z

← Older revision		Revision as of 22:47, 2 July 2019
Line 12:		Line 12:
	** '''2016-06-12''' switching definitions of WhenChanged and WhenUpdated		** '''2016-06-12''' switching definitions of WhenChanged and WhenUpdated
	*** Only one record had WhenUpdated set; very few have WhenChanged set.		*** Only one record had WhenUpdated set; very few have WhenChanged set.
			** '''2019-07-02''' renamed from "core_custs" to "cust" so it will group with the other customer tables
	==SQL==		==SQL==
	<source lang=mysql>CREATE TABLE `~~core_custs~~` (		<source lang=mysql>CREATE TABLE `cust` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",		`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",

Woozle: Woozle moved page VbzCart/tables/core custs to VbzCart/tables/cust: so it groups with the other customer tables

2019-07-02T22:46:18Z

Woozle moved page VbzCart/tables/core custs to VbzCart/tables/cust: so it groups with the other customer tables

← Older revision	Revision as of 22:46, 2 July 2019
(No difference)

Woozle at 20:42, 2 July 2019

2019-07-02T20:42:18Z

← Older revision		Revision as of 20:42, 2 July 2019
Line 13:		Line 13:
	*** Only one record had WhenUpdated set; very few have WhenChanged set.		*** Only one record had WhenUpdated set; very few have WhenChanged set.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `core_custs` (		<source lang=mysql>CREATE TABLE `core_custs` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",		`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",
Line 26:		Line 26:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = ~~MYISAM~~;</~~mysql~~>		ENGINE = InnoDB;</source>

Woozle: WhenUpdated and WhenChanged

2016-06-12T13:06:31Z

WhenUpdated and WhenChanged

← Older revision		Revision as of 13:06, 12 June 2016
Line 4:		Line 4:
	** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.		** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.
	** '''WhenCreated''': This should be NOT NULL on systems with no legacy data		** '''WhenCreated''': This should be NOT NULL on systems with no legacy data
	** '''WhenChanged''': not ~~sure if this field has a purpose; it could be set whenever Notes or ID_Repl are edited, maybe?~~		** '''WhenChanged''': when the contact's dependent records (address, emails, etc.) were last modified (probably not implemented much)
	** '''WhenUpdated''': When this ~~customer~~ was ~~updated (any time new order comes in, even if no contact info changes)~~		** '''WhenUpdated''': When this record was last modified
	* '''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-29''' added '''WhenUpdated''' field		** '''2011-11-29''' added '''WhenUpdated''' field
	** '''2013-10-10''' added '''ID_User''' and '''Title''' fields (see {{vbzcart\|table\|core_users}} for rules)		** '''2013-10-10''' added '''ID_User''' and '''Title''' fields (see {{vbzcart\|table\|core_users}} for rules)
			** '''2016-06-12''' switching definitions of WhenChanged and WhenUpdated
			*** Only one record had WhenUpdated set; very few have WhenChanged set.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `core_custs` (		<mysql>CREATE TABLE `core_custs` (
Line 20:		Line 22:
	`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",		`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",
	`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",		`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",
	`~~WhenChanged~~` DATETIME DEFAULT NULL COMMENT "when this record was last ~~edited~~",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when this record was last updated",
	`~~WhenUpdated~~` DATETIME DEFAULT NULL COMMENT "when this ~~contact~~ was last ~~updated~~",		`WhenChanged` DATETIME DEFAULT NULL COMMENT "when this record's dependent data was last edited",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle: "Title" field

2013-10-10T16:55:21Z

"Title" field

← Older revision		Revision as of 16:55, 10 October 2013
Line 9:		Line 9:
	** '''2009-07-09''' moved to separate wiki page; no design changes		** '''2009-07-09''' moved to separate wiki page; no design changes
	** '''2011-11-29''' added '''WhenUpdated''' field		** '''2011-11-29''' added '''WhenUpdated''' field
	** '''2013-10-10''' added '''ID_User''' ~~field~~ (see {{vbzcart\|table\|core_users}} for rules)		** '''2013-10-10''' added '''ID_User''' and '''Title''' fields (see {{vbzcart\|table\|core_users}} for rules)
	==SQL==		==SQL==
	<mysql>CREATE TABLE `core_custs` (		<mysql>CREATE TABLE `core_custs` (
Line 16:		Line 16:
	`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",		`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",
	`ID_User` INT DEFAULT NULL COMMENT "core_users.ID of user for this customer",		`ID_User` INT DEFAULT NULL COMMENT "core_users.ID of user for this customer",
	`Notes` VARCHAR(255) COMMENT "admin-entered notes about this customer",		`Title` VARCHAR(127) DEFAULT NULL COMMENT "user-entered title for this customer profile",
			`Notes` VARCHAR(255) DEFAULT NULL COMMENT "admin-entered notes about this customer",
	`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",		`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",
	`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",		`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",

Woozle: ID_User

2013-10-10T13:01:45Z

ID_User

← Older revision		Revision as of 13:01, 10 October 2013
Line 9:		Line 9:
	** '''2009-07-09''' moved to separate wiki page; no design changes		** '''2009-07-09''' moved to separate wiki page; no design changes
	** '''2011-11-29''' added '''WhenUpdated''' field		** '''2011-11-29''' added '''WhenUpdated''' field
			** '''2013-10-10''' added '''ID_User''' field (see {{vbzcart\|table\|core_users}} for rules)
	==SQL==		==SQL==
	<mysql>CREATE TABLE `core_custs` (		<mysql>CREATE TABLE `core_custs` (
Line 14:		Line 15:
	`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",		`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",
	`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",		`ID_Addr` INT DEFAULT NULL COMMENT "cust_addrs.ID of default address",
			`ID_User` INT DEFAULT NULL COMMENT "core_users.ID of user for this customer",
	`Notes` VARCHAR(255) COMMENT "admin-entered notes about this customer",		`Notes` VARCHAR(255) COMMENT "admin-entered notes about this customer",
	`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",		`ID_Repl` INT DEFAULT NULL COMMENT "core_custs.ID of replacement",

Woozle: tidying

2013-09-22T14:31:04Z

tidying

← Older revision		Revision as of 14:31, 22 September 2013
Line 10:		Line 10:
	** '''2011-11-29''' added '''WhenUpdated''' field		** '''2011-11-29''' added '''WhenUpdated''' field
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `core_custs` (		<mysql>CREATE TABLE `core_custs` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",		`ID_Name` INT NOT NULL COMMENT "cust_names.ID of default name",
Line 22:		Line 22:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: note about WhenChanged

2011-12-17T17:57:05Z

note about WhenChanged

← Older revision		Revision as of 17:57, 17 December 2011
Line 4:		Line 4:
	** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.		** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.
	** '''WhenCreated''': This should be NOT NULL on systems with no legacy data		** '''WhenCreated''': This should be NOT NULL on systems with no legacy data
			** '''WhenChanged''': not sure if this field has a purpose; it could be set whenever Notes or ID_Repl are edited, maybe?
	** '''WhenUpdated''': When this customer was updated (any time new order comes in, even if no contact info changes)		** '''WhenUpdated''': When this customer was updated (any time new order comes in, even if no contact info changes)
	* '''History''':		* '''History''':

Woozle: WhenUpdated

2011-11-29T22:39:44Z

WhenUpdated

← Older revision		Revision as of 22:39, 29 November 2011
Line 4:		Line 4:
	** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.		** '''ID_Repl''': If non-null, then this customer ID has been consolidated with the customer whose ID is in ID_Repl; whenever/wherever possible, replace occurrences of this ID with the value of the corresponding ID_Repl.
	** '''WhenCreated''': This should be NOT NULL on systems with no legacy data		** '''WhenCreated''': This should be NOT NULL on systems with no legacy data
			** '''WhenUpdated''': When this customer was updated (any time new order comes in, even if no contact info changes)
	* '''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-29''' added '''WhenUpdated''' field
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `core_custs` (		<section begin=sql /><mysql>CREATE TABLE `core_custs` (
Line 15:		Line 17:
	`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",		`WhenCreated` DATETIME /NOT NULL/ COMMENT "when this record was created",
	`WhenChanged` DATETIME DEFAULT NULL COMMENT "when this record was last edited",		`WhenChanged` DATETIME DEFAULT NULL COMMENT "when this record was last edited",
			`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when this contact was last updated",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />