Update KRYPT05212007A: Post-Update Database Changes

No SQL statements nececessary.

In the event the demo store items reappear in your store, you can execute these statements to remove the demo store entries:

  • DELETE FROM ccp0_prod WHERE id='DESKTOP1001' OR id='DESKTOP1002' OR id='DESKTOP1003' OR id='DESKTOP1004' OR id='HDD1005' OR id='HDD1006' OR id='HDD1007' OR id='MONITOR1008' OR id='MONITOR1009' OR id='BUILD1001'
  • DELETE FROM ccp0_cat WHERE id='BuildYourOwn' OR id='PCs' OR id='DeskPCs' OR id='GamePCs' OR id='HDD' OR id='scsiHDD' OR id='pcmciaHDD' OR id='eideHDD' OR id='MONITOR'
  • DELETE FROM ccp0_prodoptions WHERE id='pc_sechdd' OR id='build_cpu' OR id='build_hdd' OR id='build_memory' OR id='build_cdrom' OR id='build_soundcard' OR id='build_videocard' OR id='build_specins'
  • DELETE FROM ccp0_prodoptionsel WHERE id='pc_sechdd.none' OR id='build_cpu.1.0' OR id='build_cpu.900' OR id='build_cpu.1.2' OR id='build_cpu.1.4' OR id='build_cpu.1.6' OR id='build_hdd.10' OR id='build_hdd.20' OR id='build_hdd.40' OR id='build_hdd.80' OR id='pc_sechdd.20' OR id='pc_sechdd.40' OR id='pc_sechdd.80' OR id='build_memory.128' OR id='build_memory.64' OR id='build_memory.256' OR id='build_memory.512' OR id='build_cdrom.24cd' OR id='build_cdrom.16cd' OR id='build_cdrom.48cd' OR id='build_cdrom.6rw' OR id='build_cdrom.24rw' OR id='build_cdrom.12dvd' OR id='build_cdrom.24dvd' OR id='build_soundcard.32' OR id='build_soundcard.16' OR id='build_soundcard.64' OR id='build_videocard.16' OR id='build_videocard.8' OR id='build_videocard.32agp' OR id='build_videocard.32pci'
  • DELETE FROM ccp0_dynforms WHERE id='feedback'
  • DELETE FROM ccp0_dynformfields WHERE id='feedback.fname' OR id='feedback.lname' OR id='feedback.email' OR id='feedback.phone' OR id='feedback.orderstatus' OR id='feedback.ordernum' OR id='feedback.whereheard' OR id='feedback.contact' OR id='feedback.comments'
© 1999-Present Kryptronic, Inc. All rights reserved worldwide. Kryptronic, the Kryptronic logo and all Kryptronic software names and logos are trademarks of Kryptronic, Inc. All Kryptronic software is copyrighted and the intellectual property of Kryptronic, Inc. All Kryptronic software is developed and distributed under license by Kryptronic, Inc.