Post by peter.k » Wed May 30, 2012 5:11 pm

Hi

I bought this gift voucher extension

http://www.opencart.com/index.php?route ... order=DESC

In the instructions it says this:

##############################################################################
# STEP 2: Make Database Changes
##############################################################################

****************************************
* MAKE SURE TO BACK UP YOUR DATABASE *
* BEFORE MAKING ANY CHANGES. I AM NOT *
* RESPONSIBLE FOR ANY LOSS OF DATA. *
****************************************

Skip this step if you are upgrading from a previous version of Gift Vouchers.

Execute the following SQL code on your database. Remember to add a table
prefix if you are using one. A copy of this SQL code can be found in
"gift_voucher.sql".

-- START: Gift Voucher SQL Code --

CREATE TABLE `gift_voucher` (
`gift_voucher_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`code` varchar(32) COLLATE utf8_bin NOT NULL,
`balance` decimal(15,4) NOT NULL,
`shipping` int(1) NOT NULL,
`tax` int(1) NOT NULL,
`date_start` date NOT NULL DEFAULT '0000-00-00',
`date_end` date NOT NULL DEFAULT '0000-00-00',
`status` int(1) NOT NULL,
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`gift_voucher_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

CREATE TABLE `gift_voucher_history` (
`gift_voucher_history_id` int(11) NOT NULL AUTO_INCREMENT,
`gift_voucher_id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`amount` decimal(15,4) NOT NULL,
`status` int(1),
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`gift_voucher_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- END: Gift Voucher SQL Code --

What does a table prefix look like?

New member

Posts

Joined
Fri Jan 20, 2012 7:42 pm

Post by MarketInSG » Wed May 30, 2012 6:40 pm

table prefix is the one you defined. How to know if you have one?

1. Access your database via phpmyadmin.
2. View your tables, scroll down to this table, "setting".
3. If your tables has anything infront of it (eg. oc_setting, or xyz_setting, or whatever_setting), that will be the prefix.
(Eg. oc will be prefix, xyz will be prefix, whatever will be prefix respectively for the example above)


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by shiokguy » Fri Jul 13, 2012 10:55 am

Dear All

I am using 1.5.1.1
I am moving hosting...
I have backup my old database using PHPMyAdmin

I installed a new version of 1.5.1.1 in new host..

When I import the DB.. I can the new installation in new host does not have the oc infront of the table for example: -

My old host database table ocadddress, but in the new hosting i see address only.. Now when I imported the old db into the new hosting.. I have 2 table name ocaddress and address..

What happen? What did i do wrong?

Please help and I am kind of desperate

Regards
Shiokguy

New member

Posts

Joined
Wed Jul 13, 2011 3:28 pm
Who is online

Users browsing this forum: Baidu [Spider] and 4 guests