· 6 years ago · Nov 19, 2019, 08:36 PM
1-- Table structure for catalog_gift_nuxuser
2-- ----------------------------
3DROP TABLE IF EXISTS `catalog_gift_nuxuser`;
4CREATE TABLE `catalog_gift_nuxuser` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `type` enum('seasonal','badge','item','sell','purchase','scissors','paper','rock','diamonds') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'item',
7 `page_type` int(11) NOT NULL,
8 `reward_icon` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
9 `reward_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
10 `reward_productdata` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
11 `reward_data` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
12 PRIMARY KEY (`id`) USING BTREE
13) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
14
15-- ----------------------------
16-- Records of catalog_gift_nuxuser
17-- ----------------------------
18INSERT INTO `catalog_gift_nuxuser` VALUES (1, 'rock', 4, 'album1584/STONE.gif', 'Piedra', 'MAMUT', '1');
19INSERT INTO `catalog_gift_nuxuser` VALUES (2, 'paper', 4, 'album1584/PAPER.gif', 'Papel', 'DUCK', '2');
20INSERT INTO `catalog_gift_nuxuser` VALUES (3, 'scissors', 4, 'album1584/CROCO.gif', 'Tijera', 'CROCO', '3');