Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Sydney
    Posts
    109
    Plugin Contributions
    0

    Default 3 redundant(?) tables post database upgraded

    So I finally upgraded my 1.38 store to 1.51. The database upgrade gave a lot of messages about not droping tables that don't exist, and not adding tables that already exist, which all seem benign to me.

    But just to be careful I compare the upgraded database to a brand new 1.51 install database, and I found that a brand new database has 96 tables, whereas my upgraded database has 99 tables. The additional tables are:

    customers_wishlist
    nochex_apc_transaction
    nochex_sessions

    For ease of future maintenance, can I simply drop them? Looks like they were created by new 1.38 install and never got used since.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 3 redundant(?) tables post database upgraded

    Yes. If you are not using those tables and if they don't contain any data you wish to preserve, you can drop them.
    .

    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.

 

 

Similar Threads

  1. Altered Database tables in 1.5.x?
    By philip937 in forum Upgrading to 1.5.x
    Replies: 16
    Last Post: 9 Jan 2013, 10:28 PM
  2. Create Database, Tables and Drop Database or Tables
    By elwood cordery in forum General Questions
    Replies: 3
    Last Post: 17 Aug 2009, 04:03 PM
  3. Canada Post module to reading it's tables?
    By Nathfunstuff in forum Addon Shipping Modules
    Replies: 2
    Last Post: 25 Jun 2008, 12:52 PM
  4. How to enable post code matching in Region Tables v1.4.0 as when I...
    By sacotechnology in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 27 Apr 2008, 12:20 PM
  5. Database not upgraded
    By dolfantimmy in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 1 Aug 2007, 05:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR