I'd like to add a simple timestamp column to the end of the customers table. I know *how* to do it, but just thought I'd check and see if anyone know a reason *not* to do it. I don't want to break anything that would depend on there being a certain number of columns or something silly like that.
Thread: Adding field to customers table
Results 1 to 5 of 5
-
26 Oct 2010, 11:49 PM #1
New Zenner
- Join Date
- Aug 2008
- Posts
- 33
- Plugin Contributions
- 0
Adding field to customers table
-
26 Oct 2010, 11:53 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Adding field to customers table
Why?
What's this "timestamp" for?
There's already a last_modified column which is a timestamp indicating the last change..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
27 Oct 2010, 12:04 AM #3
New Zenner
- Join Date
- Aug 2008
- Posts
- 33
- Plugin Contributions
- 0
Re: Adding field to customers table
The field would be for when the record was created (aka when the account was created). In one case, I wanted to use an external newsletter mailing and wanted to pull customers who created accounts and opted-in since the previous mailing. In another case, I just wondered how many accounts were created this month or that month.
So would that break anything?
-
27 Oct 2010, 12:19 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Adding field to customers table
It's a waste of your time. Why make the database schema more complicated and more to maintain needlessly?
There's already a date-created and last-modified date stored for each customer record: just do a join on customers and customers_info and you'll have all that information..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
27 Oct 2010, 12:58 AM #5
New Zenner
- Join Date
- Aug 2008
- Posts
- 33
- Plugin Contributions
- 0
Re: Adding field to customers table
"That data is already being captured in customers_info" is what I needed to hear. thanx.
Originally Posted by DrByte
Similar Threads
-
v151 Adding a Custom field to the products table
By jimmie in forum General QuestionsReplies: 4Last Post: 17 Sep 2013, 11:14 PM -
Adding Custom Field to Customer Table
By experimenter in forum General QuestionsReplies: 3Last Post: 26 Sep 2008, 08:36 PM -
Adding field to categories_description table
By 0101101011 in forum Setting Up Categories, Products, AttributesReplies: 0Last Post: 13 Aug 2007, 05:56 PM -
Adding field to products_description table
By IncrediBody in forum General QuestionsReplies: 2Last Post: 14 Sep 2006, 05:18 AM
Bookmarks