Blog TRKStore

selanjutnya kita akan ketambahan tabel untuk upgrade script.

secara manual, dari phpmyadmin :

CREATE TABLE `tampilanspesial` (
`ID` int(10) NOT NULL auto_increment,
`namahalaman` varchar(100) NOT NULL,
`tampil` varchar(10) NOT NULL default ‘no’,
PRIMARY KEY  (`ID`)
) ENGINE=MyISAM   ;

INSERT INTO `tampilanspesial` VALUES (1, ‘home.php’, ‘yes’);
INSERT INTO `tampilanspesial` VALUES (2, ‘cat.php’, ‘yes’);
INSERT INTO `tampilanspesial` VALUES (3, ‘discount_items.php’, ‘no’);
INSERT INTO `tampilanspesial` VALUES (4, ‘contact.php’, ‘no’);
INSERT INTO `tampilanspesial` VALUES (5, ‘new_products.php’, ‘yes’);
INSERT INTO `tampilanspesial` VALUES (6, ‘ongkos.php’, ‘yes’);
INSERT INTO `tampilanspesial` VALUES (7, ’search_results.php’, ‘no’);
INSERT INTO `tampilanspesial` VALUES (8, ‘about_us.php’, ‘no’);
INSERT INTO `tampilanspesial` VALUES (9, ‘cara_order.php’, ‘no’);

secara script,

Continue reading tambahan tabel untuk database →