PgKxRENe

1DROP TABLE IF EXISTS `page_saved`;
2CREATE TABLE `page_saved` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `Type` int(11) DEFAULT NULL,
5  `Sphaera1` int(11) DEFAULT NULL,
6  `Sphaera2` int(11) DEFAULT NULL,
7  `Sphaera3` int(11) DEFAULT NULL,
8  `Sphaera4` int(11) DEFAULT NULL,
9  `Sphaera5` int(11) DEFAULT NULL,
10  `Sphaera6` int(11) DEFAULT NULL,
11  `Sphaera7` int(11) DEFAULT NULL,
12  `Sphaera8` int(11) DEFAULT NULL,
13  `Sphaera9` int(11) DEFAULT NULL,
14  `Pagina` int(11) DEFAULT NULL,
15  `pid` int(11) DEFAULT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19-- ----------------------------
20-- Records of page_saved
21-- ----------------------------
22
23-- ----------------------------
24-- Table structure for sphaera_pages
25-- ----------------------------
26DROP TABLE IF EXISTS `sphaera_pages`;
27CREATE TABLE `sphaera_pages` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `pid` int(11) DEFAULT NULL,
30  `page` varchar(255) DEFAULT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- ----------------------------
35-- Records of sphaera_pages
36-- ----------------------------
37
38-- ----------------------------
39-- Table structure for sphaeras
40-- ----------------------------
41DROP TABLE IF EXISTS `sphaeras`;
42CREATE TABLE `sphaeras` (
43  `pid` int(11) NOT NULL AUTO_INCREMENT,
44  `vnum` int(11) DEFAULT NULL,
45  PRIMARY KEY (`pid`)
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48-- ----------------------------
49-- Records of sphaeras
50-- ----------------------------
51
52-- ----------------------------
53-- Table structure for sphaeras_bonus
54-- ----------------------------
55DROP TABLE IF EXISTS `sphaeras_bonus`;
56CREATE TABLE `sphaeras_bonus` (
57  `id` int(11) NOT NULL AUTO_INCREMENT,
58  `pid` int(11) DEFAULT NULL,
59  `vnum` int(11) DEFAULT NULL,
60  `affect` int(11) DEFAULT NULL,
61  `cant` int(11) DEFAULT NULL,
62  `duration` int(11) DEFAULT NULL,
63  PRIMARY KEY (`id`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66-- ----------------------------
67-- Records of sphaeras_bonus
68-- ----------------------------
69
70-- ----------------------------
71-- Table structure for sphaeras_reg
72-- ----------------------------
73DROP TABLE IF EXISTS `sphaeras_reg`;
74CREATE TABLE `sphaeras_reg` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `pid` int(11) DEFAULT NULL,
77  PRIMARY KEY (`id`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80-- ----------------------------
81-- Records of sphaeras_reg