Файл: WMR/bonus.sql
Строк: 36
CREATE TABLE IF NOT EXISTS `e_wmbonus2` (
`id` int(11) NOT NULL
auto_increment,
`trid` int(11) NOT NULL,
`wmid` text NOT NULL,
`purse` text NOT NULL,
`date` datetime NOT NULL,
`update` datetime
NOT NULL,
`amount` float NOT NULL COMMENT 'Total user amount',
`ip`
text NOT NULL,
`payments` int(11) NOT NULL COMMENT 'Total user
payments',
`ref_amount` float NOT NULL COMMENT 'Total referral
amount',
`ref_payments` int(11) NOT NULL COMMENT 'Total ref payments',
`ref` text NOT NULL COMMENT 'Referral',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=49 ;
CREATE
TABLE IF NOT EXISTS `e_wmbonus2adv` (
`id` int(11) NOT NULL
auto_increment,
`wmid` text NOT NULL,
`date` datetime NOT NULL
COMMENT 'First Pay Date',
`update` datetime NOT NULL COMMENT 'Last Pay
Date',
`paycount` int(11) NOT NULL COMMENT 'Pay Counter',
`type`
int(11) NOT NULL COMMENT 'Adv Type',
`text` text NOT NULL COMMENT 'Text
Adv or image url',
`url` text NOT NULL COMMENT 'site url',
`counter`
int(11) NOT NULL COMMENT 'Clicks or Shows of adv counter',
`counter_total` int(11) NOT NULL COMMENT 'Clicks or Shows of adv counter
(total)',
`active` tinyint(4) NOT NULL COMMENT 'adv activation',
`ban` tinyint(4) NOT NULL COMMENT 'BAN THIS TYPE OF ADV FOR ANY WMID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=98 ;