· 8 years ago · Jan 04, 2018, 09:06 PM
1CREATE TABLE IF NOT EXISTS `ruletka_deposit` (
2`id` int(11) NOT NULL,
3 `user_id` int(11) NOT NULL,
4 `amount` int(11) NOT NULL,
5 `hash` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
6 `offerID` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
7 `state` int(11) NOT NULL DEFAULT '0',
8 `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
9 `items` text COLLATE utf8_unicode_ci NOT NULL,
10 `amount_clear` double(10,2) DEFAULT '0.00',
11 `bot` int(11) NOT NULL DEFAULT '0',
12 `appid` int(11) NOT NULL DEFAULT '730'
13) ENGINE=InnoDB AUTO_INCREMENT=99613 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
14
15--
16-- Indeksy dla zrzutów tabel
17--
18
19--
20-- Indexes for table `ruletka_deposit`
21--
22ALTER TABLE `ruletka_deposit`
23 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);