sql.txt

1.增加了近40项后台核心设置

DROP TABLE IF EXISTS `xydw_admin`;
CREATE TABLE IF NOT EXISTS `xydw_admin` (
  `aid` tinyint(3) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `passwd` varchar(40) NOT NULL default '',
  `type` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM PACK_KEYS=0;

DROP TABLE IF EXISTS `xydw_adminset`;
CREATE TABLE IF NOT EXISTS `xydw_adminset` (
  `asid` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `action` varchar(50) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  `adminip` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`asid`)
) TYPE=MyISAM PACK_KEYS=0;

DROP TABLE IF EXISTS `xydw_ads`;
CREATE TABLE IF NOT EXISTS `xydw_ads` (
  `name` varchar(100) NOT NULL default '',
  `value` text NOT NULL,
  `type` enum('0','1') NOT NULL default '1',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_art`;
CREATE TABLE IF NOT EXISTS `xydw_art` (
  `wid` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `color` varchar(10) NOT NULL default '',
  `author` varchar(100) NOT NULL default '',
  `laiyuan` varchar(255) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `lid` tinyint(2) NOT NULL default '0',
  `date` int(10) NOT NULL default '0',
  `visit` int(10) NOT NULL default '0',
  `good` tinyint(1) NOT NULL default '0',
  `up` varchar(255) NOT NULL default '0',
  `newsurl` varchar(100) NOT NULL default '',
  `html` enum('0','1') NOT NULL default '0',
  `ubb` enum('0','1') NOT NULL default '0',
  `last` int(10) NOT NULL default '0',
  `zhuanti` tinyint(3) unsigned NOT NULL default '0',
  `xianshi` tinyint(1) unsigned NOT NULL default '1',
  `comment` smallint(5) unsigned NOT NULL default '0',
  `fen` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`wid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_comment`;
CREATE TABLE IF NOT EXISTS `xydw_comment` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `wid` int(10) unsigned NOT NULL default '0',
  `author` varchar(255) NOT NULL default '',
  `fen` tinyint(1) unsigned NOT NULL default '0',
  `comment` mediumtext NOT NULL,
  `xianshi` tinyint(1) unsigned NOT NULL default '1',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_lanmu`;
CREATE TABLE IF NOT EXISTS `xydw_lanmu` (
  `lid` tinyint(2) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `type` enum('1','2') NOT NULL default '1',
  `kind` tinyint(2) NOT NULL default '0',
  `lup` tinyint(2) NOT NULL default '0',
  `setright` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`lid`)
) TYPE=MyISAM PACK_KEYS=0;

DROP TABLE IF EXISTS `xydw_link`;
CREATE TABLE IF NOT EXISTS `xydw_link` (
  `ljid` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `logo` varchar(100) NOT NULL default '',
  `js` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ljid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_person_lanmu`;
CREATE TABLE IF NOT EXISTS `xydw_person_lanmu` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `target` enum('0','1') NOT NULL default '0',
  `kind` tinyint(3) unsigned NOT NULL default '0',
  `type` enum('1','2') NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_person_pic`;
CREATE TABLE IF NOT EXISTS `xydw_person_pic` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `showpage` varchar(20) NOT NULL default '',
  `lids` varchar(255) NOT NULL default '',
  `num` tinyint(3) unsigned NOT NULL default '0',
  `h` tinyint(3) unsigned NOT NULL default '0',
  `height` tinyint(3) unsigned NOT NULL default '0',
  `width` tinyint(3) unsigned NOT NULL default '0',
  `len` tinyint(3) unsigned NOT NULL default '0',
  `type` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_root`;
CREATE TABLE IF NOT EXISTS `xydw_root` (
  `name` varchar(100) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_styles`;
CREATE TABLE IF NOT EXISTS `xydw_styles` (
  `sid` tinyint(3) unsigned NOT NULL auto_increment,
  `stylename` varchar(20) NOT NULL default '',
  `htmlpath` varchar(50) NOT NULL default '',
  `imgpath` varchar(50) NOT NULL default '',
  `tablewidth` varchar(4) NOT NULL default '',
  `tablecolor` varchar(7) NOT NULL default '',
  `bcolor` varchar(7) NOT NULL default '',
  `hcolor` varchar(7) NOT NULL default '',
  `acolor` varchar(7) NOT NULL default '',
  `icolor` varchar(7) NOT NULL default '',
  `hbcolor` varchar(7) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM PACK_KEYS=0;

DROP TABLE IF EXISTS `xydw_up`;
CREATE TABLE IF NOT EXISTS `xydw_up` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `wid` int(10) unsigned NOT NULL default '0',
  `type` enum('0','1') NOT NULL default '0',
  `tempname` varchar(100) NOT NULL default '',
  `savename` varchar(100) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_votes`;
CREATE TABLE IF NOT EXISTS `xydw_votes` (
  `name` varchar(10) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `selects` text NOT NULL,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `xianshi` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `xydw_zhuanti`;
CREATE TABLE IF NOT EXISTS `xydw_zhuanti` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


INSERT INTO `xydw_root` VALUES ('adminset', '200');
INSERT INTO `xydw_root` VALUES ('sitename', '心雨动网');
INSERT INTO `xydw_root` VALUES ('siteurl', 'http://localhost/my/112');
INSERT INTO `xydw_root` VALUES ('email', '[e-mail]');
INSERT INTO `xydw_root` VALUES ('close', '1');
INSERT INTO `xydw_root` VALUES ('closetxt', '网站升级中');
INSERT INTO `xydw_root` VALUES ('dstyle', '1');
INSERT INTO `xydw_root` VALUES ('first', '6');
INSERT INTO `xydw_root` VALUES ('indexname', '');
INSERT INTO `xydw_root` VALUES ('ishtml', '0');
INSERT INTO `xydw_root` VALUES ('htmltime', '10');
INSERT INTO `xydw_root` VALUES ('obstart', '0');
INSERT INTO `xydw_root` VALUES ('newtime', '10');
INSERT INTO `xydw_root` VALUES ('newcolor', '#FF0000');
INSERT INTO `xydw_root` VALUES ('artlen', '');
INSERT INTO `xydw_root` VALUES ('leftlen', '20');
INSERT INTO `xydw_root` VALUES ('rightlen', '30');
INSERT INTO `xydw_root` VALUES ('listb', '10');
INSERT INTO `xydw_root` VALUES ('lists', '30');
INSERT INTO `xydw_root` VALUES ('post', '1');
INSERT INTO `xydw_root` VALUES ('newimg', '');
INSERT INTO `xydw_root` VALUES ('usehtml', '1');
INSERT INTO `xydw_root` VALUES ('useubb', '1');
INSERT INTO `xydw_root` VALUES ('usefla', '1');
INSERT INTO `xydw_root` VALUES ('htmlonline', '');
INSERT INTO `xydw_root` VALUES ('comment', '1');
INSERT INTO `xydw_root` VALUES ('commentlen', '500');
INSERT INTO `xydw_root` VALUES ('commentlist', '5');
INSERT INTO `xydw_root` VALUES ('alls', '');
INSERT INTO `xydw_root` VALUES ('updir', 'up');
INSERT INTO `xydw_root` VALUES ('upweight', '1000');
INSERT INTO `xydw_root` VALUES ('uplast', 'gif|jpg|png|php|htm|zip|rar');
INSERT INTO `xydw_root` VALUES ('commentubb', '1');
INSERT INTO `xydw_root` VALUES ('listg', '10');
INSERT INTO `xydw_root` VALUES ('listh', '10');
INSERT INTO `xydw_root` VALUES ('listn', '10');
INSERT INTO `xydw_root` VALUES ('commentlists', '30');
INSERT INTO `xydw_root` VALUES ('zhuanti', '5');
INSERT INTO `xydw_root` VALUES ('commenttime', '3');
INSERT INTO `xydw_root` VALUES ('timelimit', '');
INSERT INTO `xydw_root` VALUES ('postlen', '1');
INSERT INTO `xydw_root` VALUES ('pconnect', '0');

INSERT INTO `xydw_styles` VALUES (1, 'xydw', 'xydw', 'xydw', '760', '#CCCCCC', '#FFFFFF', '#FFFFFF', '#000000', '#FFFFFF', '#EDF8FE');

INSERT INTO `xydw_person_pic` VALUES (1, 'index', '0', 5, 1, 100, 120, 0, '1');

INSERT INTO `xydw_lanmu` VALUES (1, '默认分类', '1', 0, 0, '');

INSERT INTO `xydw_lanmu` VALUES (2, '心雨程序', '2', 1, 0, '');