mdyudAvf

1DROP TABLE IF EXISTS `avisos`;
2CREATE TABLE IF NOT EXISTS `avisos` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `data` varchar(10) DEFAULT NULL,
5  `aviso` text,
6  PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=latin1;
8
9
10
11DROP TABLE IF EXISTS `changelog`;
12CREATE TABLE IF NOT EXISTS `changelog` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `plugin` text,
15  `data` text,
16  `update_info` text,
17  PRIMARY KEY (`id`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1;
19
20DROP TABLE IF EXISTS `loja`;
21CREATE TABLE IF NOT EXISTS `loja` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `nome` varchar(255) DEFAULT NULL,
24  `descricao` text,
25  `preco` int(11) DEFAULT NULL,
26  `categoria` text,
27  `imagem` varchar(255) NOT NULL DEFAULT 'https://i.imgur.com/ceubPUo.png',
28  `autor` text,
29  `versao` varchar(20) DEFAULT NULL,
30  `button` text,
31  PRIMARY KEY (`id`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1;
33
34
35
36DROP TABLE IF EXISTS `usuarios`;
37CREATE TABLE IF NOT EXISTS `usuarios` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `usuario` varchar(255) DEFAULT NULL,
40  `senha` varchar(255) DEFAULT NULL,
41  `ip` varchar(255) DEFAULT NULL,
42  `acesso` varchar(255) DEFAULT '0',
43  `status` varchar(255) DEFAULT '0',
44  PRIMARY KEY (`id`)
45) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
46
47
48INSERT INTO `usuarios` (`id`, `usuario`, `senha`, `ip`, `acesso`, `status`) VALUES
49(1, 'zlDeath', '99eaca327b60f335738f20936254f430', '::1', '3', '0');
50
51DROP TABLE IF EXISTS `usuarios_plugins`;
52CREATE TABLE IF NOT EXISTS `usuarios_plugins` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `plugin` text,
55  `usuario` text,
56  `licenca` varchar(65) DEFAULT NULL,
57  `ip` varchar(20) DEFAULT NULL,
58  PRIMARY KEY (`id`)
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61
62
63DROP TABLE IF EXISTS `vendas`;
64CREATE TABLE IF NOT EXISTS `vendas` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `usuario` varchar(255) DEFAULT NULL,
67  `plugin` text,
68  `data` text,
69  `status` text,
70  `preference_id` varchar(500) DEFAULT NULL,
71  `external_reference` int(200) DEFAULT NULL,
72  PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=latin1;