DROP TABLE IF EXISTS `cdb_payset`;
CREATE TABLE `cdb_payset` (
  `groupid` int(5) unsigned NOT NULL,
  `type` tinyint(1) NOT NULL default '1',
  `enable` tinyint(1) NOT NULL default '0',
  `allowrank` tinyint(1) NOT NULL default '0',
  `allowcheck` tinyint(1) NOT NULL default '0',
  `allowview` tinyint(1) NOT NULL default '0',
  `allowforum` tinyint(1) NOT NULL default '0',
  `forum` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0',
  `leaveday` mediumint(8) NOT NULL default '0',
  `group` mediumint(8) NOT NULL default '0',
  `getprice` mediumint(8) NOT NULL default '0',
  `tax` mediumint(8) NOT NULL default '0',
  `up` mediumint(8) NOT NULL default '0',
  `down` mediumint(8) NOT NULL default '0',
  `rank` varchar(255) NOT NULL default '0,0,0,0,0',
  `check` varchar(255) NOT NULL default '0,0,0,0,0',
  `well` varchar(255) NOT NULL default '0,0,0,0,0',
  `top` varchar(255) NOT NULL default '0,0,0,0,0',
  `admin` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `post` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `digest` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `online` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `pageview` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  KEY `groupid` (`groupid`)
)


DROP TABLE IF EXISTS `cdb_paylog`;
CREATE TABLE `cdb_paylog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL,
  `username` varchar(255) NOT NULL default '',
  `timestamp1` int(10) unsigned NOT NULL,
  `timestamp2` int(10) unsigned NOT NULL,
  `staues` int(2) unsigned NOT NULL default '1',
  `type` int(2) unsigned NOT NULL default '1',
  `message` mediumtext NOT NULL,
  `rate` mediumtext NOT NULL,
  `admin` mediumint(8) NOT NULL default '0',
  `post` mediumint(8) NOT NULL default '0',
  `online` mediumint(8) NOT NULL default '0',
  `digest` mediumint(8) NOT NULL default '0',
  `pageview` mediumint(8) NOT NULL default '0',
  `total` int(10) NOT NULL default '0',
  `open` tinyint(1) NOT NULL default '1',
  `forumnum` mediumint(8) NOT NULL default '0',
  `price` mediumint(8) NOT NULL default '0',
  `workpay` mediumint(8) NOT NULL default '0',
  `monthday` varchar(30) NOT NULL default '0',
  `tax` mediumint(8) NOT NULL default '0',
  `groupid` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)


DROP TABLE IF EXISTS `cdb_paylist`;
CREATE TABLE `cdb_paylist` (
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `groupid` mediumint(8) NOT NULL default '0',
  `adminid` mediumint(8) NOT NULL default '0',
  `staues` int(2) NOT NULL default '1',
  `timestamp1` int(10) unsigned NOT NULL,
  `timestamp2` int(10) unsigned NOT NULL,
  `forumnum` mediumint(8) NOT NULL default '0',
  KEY `uid` (`uid`)
)