PDA

View Full Version : Tiki -Indonesian Shipping



michael_s
10-19-2008, 10:10 PM
CREATE TABLE IF NOT EXISTS `kurirpos` (
`state` varchar(255) NOT NULL,
`rate1` float(14,2) default '0.00',
`rate2` float(14,2) default '0.00',
`recid` int(8) NOT NULL auto_increment,
`types` varchar(3) NOT NULL default 'REG',
PRIMARY KEY (`recid`),
UNIQUE KEY `kurir_tiki_city` (`city`,`types`)
) ENGINE=MyISAM ;

////-----------.

CREATE TABLE IF NOT EXISTS `kurirpos` (
`state` varchar(255) NOT NULL,
`rate1` float(14,2) default '0.00',
`rate2` float(14,2) default '0.00',
`recid` int(8) NOT NULL auto_increment,
`types` varchar(3) NOT NULL default 'REG',
PRIMARY KEY (`recid`),
UNIQUE KEY `kurir_tiki_state` (`state`,`types`)
) ENGINE=MyISAM ;

sorry for my mistake...



More... (http://addons.oscommerce.com/info/6297)