
ALTER TABLE `#@__channeltype` ADD `issystem` SMALLINT DEFAULT '0' NOT NULL, ADD `isshow` SMALLINT DEFAULT '1' NOT NULL ;

ALTER TABLE `#@__member` ADD `upmoney` SMALLINT DEFAULT '0' NOT NULL;

CREATE TABLE `#@__moneyrecord` (
  `ID` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `money` int(11) NOT NULL default '0',
  `dtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
)ENGINE=MyISAM DEFAULT CHARSET=gbk;

CREATE TABLE `#@__plus` (
`aid` INT AUTO_INCREMENT ,
`plusname` VARCHAR( 30 ) NOT NULL ,
`menustring` VARCHAR( 100 ) NOT NULL ,
`writer` VARCHAR( 60 ) NOT NULL ,
PRIMARY KEY ( `aid` ) 
)ENGINE=MyISAM DEFAULT CHARSET=gbk;

CREATE TABLE `#@__plus` (
  `aid` int(11) NOT NULL auto_increment,
  `plusname` varchar(30) NOT NULL default '',
  `menustring` varchar(150) NOT NULL default '',
  `writer` varchar(60) NOT NULL default '',
  `isshow` smallint(6) NOT NULL default '1',
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


INSERT INTO `#@__plus` VALUES (1, 'ļ', '<m:item name=''ļ'' link=''file_manage_main.php'' rank=''10'' target=''main'' />', 'ITͼ', 1);
INSERT INTO `#@__plus` VALUES (2, 'վŷ', '<m:item name=''վŷ'' link=''mynews_main.php'' rank=''5'' target=''main'' />', 'ITͼ', 1);
INSERT INTO `#@__plus` VALUES (3, 'ģ', '<m:item name=''ģ'' link=''friendlink_main.php'' rank=''5'' target=''main'' />', 'ITͼ', 1);
INSERT INTO `#@__plus` VALUES (4, 'Բģ', '<m:item name=''Բģ'' link=''catalog_do.php?dopost=guestbook'' rank=''5'' target=''main'' />', 'ITͼ', 1);
INSERT INTO `#@__plus` VALUES (5, 'ͶƱģ', '<m:item name=''ͶƱģ'' link=''vote_main.php'' rank=''5'' target=''main'' />', 'ITͼ', 1);
INSERT INTO `#@__plus` VALUES (6, '̳չ', '<m:item name=''̳չ'' link=''bbs_addons.php'' rank=''5'' target=''main'' />', 'ITͼ', 1);

CREATE TABLE `#@__admintype` (
  `rank` smallint(6) NOT NULL default '1',
  `typename` varchar(30) NOT NULL default '',
  `cancheck` smallint(6) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


INSERT INTO `#@__admintype` VALUES (1, 'ϢԱ', 0);
INSERT INTO `#@__admintype` VALUES (5, 'ƵԱ', 1);
INSERT INTO `#@__admintype` VALUES (10, 'Ա', 1);
        
        