· 6 years ago · May 20, 2019, 06:00 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : localhost
5Source Server Version : 50521
6Source Host : localhost:3306
7Source Database : site
8
9Target Server Type : MYSQL
10Target Server Version : 50521
11File Encoding : 65001
12
13Date: 2014-11-17 18:51:37
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `banneds`
20-- ----------------------------
21DROP TABLE IF EXISTS `Banneds`;
22CREATE TABLE `Banneds` (
23 `Id` int(11) NOT NULL AUTO_INCREMENT,
24 `Acc_Id` int(11) NOT NULL,
25 `By` int(11) NOT NULL,
26 `When` datetime NOT NULL,
27 `To` datetime NOT NULL,
28 `Why` text COLLATE latin2_bin NOT NULL,
29 PRIMARY KEY (`Id`)
30) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
31
32-- ----------------------------
33-- Records of banneds
34-- ----------------------------
35
36-- ----------------------------
37-- Table structure for `cashbill_used`
38-- ----------------------------
39DROP TABLE IF EXISTS `cashbill_used`;
40CREATE TABLE `cashbill_used` (
41 `Id` int(11) NOT NULL,
42 `Code` varchar(255) COLLATE utf8_bin NOT NULL,
43 `UsedBy` varchar(255) COLLATE utf8_bin NOT NULL,
44 `UsedWhen` datetime NOT NULL
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
46
47-- ----------------------------
48-- Records of cashbill_used
49-- ----------------------------
50
51
52-- ----------------------------
53-- Table structure for `events`
54-- ----------------------------
55DROP TABLE IF EXISTS `Events`;
56CREATE TABLE `Events` (
57 `Id` int(11) NOT NULL AUTO_INCREMENT,
58 `When` datetime NOT NULL,
59 `Description` text COLLATE utf8_bin NOT NULL,
60 `By` varchar(20) COLLATE utf8_bin NOT NULL,
61 PRIMARY KEY (`Id`)
62) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
63
64-- ----------------------------
65-- Table structure for `is_log`
66-- ----------------------------
67DROP TABLE IF EXISTS `is_log`;
68CREATE TABLE `is_log` (
69 `Id` int(11) NOT NULL,
70 `ItemId` int(11) NOT NULL,
71 `AccountId` int(11) NOT NULL,
72 `Left` int(11) NOT NULL,
73 `When` datetime NOT NULL,
74 `Success` int(1) NOT NULL,
75 `IP` varchar(15) COLLATE utf8_bin NOT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
77
78-- ----------------------------
79-- Records of is_log
80-- ----------------------------
81
82-- ----------------------------
83-- Table structure for `itemshop_items`
84-- ----------------------------
85DROP TABLE IF EXISTS `ItemShop_items`;
86CREATE TABLE `ItemShop_items` (
87 `Id` int(11) NOT NULL AUTO_INCREMENT,
88 `Menu_ID` int(11) NOT NULL,
89 `Name` varchar(100) COLLATE latin2_bin NOT NULL,
90 `Content` text COLLATE latin2_bin NOT NULL,
91 `Cena` int(11) NOT NULL,
92 `Item_ID` int(100) DEFAULT NULL,
93 `count` int(100) DEFAULT NULL,
94 `imagepath` varchar(100) COLLATE latin2_bin DEFAULT NULL,
95 `Buys` int(11) NOT NULL,
96 PRIMARY KEY (`Id`)
97) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
98
99
100-- ----------------------------
101-- Table structure for `itemshop_menu`
102-- ----------------------------
103DROP TABLE IF EXISTS `ItemShop_menu`;
104CREATE TABLE `ItemShop_menu` (
105 `Id` int(11) NOT NULL AUTO_INCREMENT,
106 `Name` varchar(100) COLLATE latin2_bin NOT NULL,
107 PRIMARY KEY (`Id`)
108) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
109
110-- ----------------------------
111-- Table structure for `news`
112-- ----------------------------
113DROP TABLE IF EXISTS `news`;
114CREATE TABLE `news` (
115 `Id` int(11) NOT NULL AUTO_INCREMENT,
116 `tytul` varchar(100) COLLATE latin2_bin NOT NULL,
117 `tresc` text COLLATE latin2_bin NOT NULL,
118 `autor` varchar(100) COLLATE latin2_bin NOT NULL,
119 `data` datetime NOT NULL,
120 `edited` datetime DEFAULT NULL,
121 `editedby` varchar(100) COLLATE latin2_bin DEFAULT NULL,
122 PRIMARY KEY (`Id`)
123) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
124
125-- ----------------------------
126-- Table structure for `packages`
127-- ----------------------------
128DROP TABLE IF EXISTS `Packages`;
129CREATE TABLE `Packages` (
130 `Id` int(11) NOT NULL AUTO_INCREMENT,
131 `Name` varchar(255) COLLATE latin2_bin NOT NULL,
132 `Options` varchar(255) COLLATE latin2_bin NOT NULL,
133 `PackageOn` int(11) NOT NULL,
134 `Cena` int(11) NOT NULL,
135 PRIMARY KEY (`Id`)
136) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
137
138-- ----------------------------
139-- Records of packages
140-- ----------------------------
141
142-- ----------------------------
143-- Table structure for `przelew`
144-- ----------------------------
145DROP TABLE IF EXISTS `Przelew`;
146CREATE TABLE `Przelew` (
147 `Id` int(11) NOT NULL,
148 `Kod` varchar(100) NOT NULL,
149 `Wartosc` int(11) NOT NULL,
150 `Monety` int(11) NOT NULL,
151 `Wykorzystany` int(255) NOT NULL DEFAULT '0',
152 `Kiedy` datetime DEFAULT NULL,
153 `Przez` int(11) DEFAULT NULL
154) ENGINE=InnoDB DEFAULT CHARSET=latin2;
155
156-- ----------------------------
157-- Records of przelew
158-- ----------------------------
159
160-- ----------------------------
161-- Table structure for `sm_log`
162-- ----------------------------
163DROP TABLE IF EXISTS `SM_log`;
164CREATE TABLE `SM_log` (
165 `Id` int(11) NOT NULL,
166 `Kod` varchar(15) COLLATE latin2_bin DEFAULT NULL,
167 `Wartosc` float NOT NULL,
168 `Kto` int(11) NOT NULL,
169 `Kiedy` datetime NOT NULL,
170 `Przez` enum('Przelew','SMS','PayPal') COLLATE latin2_bin NOT NULL
171) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
172
173-- ----------------------------
174-- Records of sm_log
175-- ----------------------------
176
177-- ----------------------------
178-- Table structure for `support`
179-- ----------------------------
180DROP TABLE IF EXISTS `Support`;
181CREATE TABLE `Support` (
182 `Id` int(11) NOT NULL AUTO_INCREMENT,
183 `Who` varchar(100) COLLATE latin2_bin NOT NULL,
184 `Title` varchar(100) COLLATE latin2_bin NOT NULL,
185 `Content` text COLLATE latin2_bin NOT NULL,
186 `IP` varchar(100) COLLATE latin2_bin NOT NULL,
187 `When` datetime NOT NULL,
188 `Open` enum('True','False') COLLATE latin2_bin NOT NULL,
189 `Last_answer` datetime NOT NULL,
190 PRIMARY KEY (`Id`)
191) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
192
193-- ----------------------------
194-- Records of support
195-- ----------------------------
196
197-- ----------------------------
198-- Table structure for `support_answers`
199-- ----------------------------
200DROP TABLE IF EXISTS `Support_answers`;
201CREATE TABLE `Support_answers` (
202 `Id` int(11) NOT NULL AUTO_INCREMENT,
203 `Ticket_Id` int(11) NOT NULL,
204 `Who` varchar(100) COLLATE latin2_bin NOT NULL,
205 `Content` text COLLATE latin2_bin NOT NULL,
206 `When` datetime NOT NULL,
207 PRIMARY KEY (`Id`)
208) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
209
210-- ----------------------------
211-- Records of support_answers
212-- ----------------------------
213
214-- ----------------------------
215-- Table structure for `traffic`
216-- ----------------------------
217DROP TABLE IF EXISTS `Traffic`;
218CREATE TABLE `Traffic` (
219 `IP` varchar(15) COLLATE latin2_bin NOT NULL,
220 `Income_Date` datetime NOT NULL,
221 `LastTime_Date` datetime NOT NULL,
222 `Shows` int(11) NOT NULL,
223 `AccountId` int(11) NOT NULL DEFAULT '0'
224) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_bin;
225
226
227ALTER TABLE account.account ADD `confirmedtoken` VARCHAR( 100 ) CHARACTER SET latin2 COLLATE latin2_bin NOT NULL AFTER `email`;
228ALTER TABLE account.account ADD `coins` int( 100 ) NOT NULL DEFAULT 0 AFTER `cash`;
229ALTER TABLE account.account ADD `actived` ENUM ('Y','N') CHARACTER SET latin2 COLLATE latin2_bin NOT NULL DEFAULT 'Y' AFTER `confirmedtoken`;