-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- : localhost:3306
-- : 2008  08  16  14:18
-- 汾: 5.0.45
-- PHP 汾: 5.2.5
-- 
-- ݿ: `shuinew`
-- 

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_admin`
-- 

DROP TABLE IF EXISTS `byart_admin`;
CREATE TABLE IF NOT EXISTS `byart_admin` (
  `Id` int(11) NOT NULL auto_increment,
  `admin_name` varchar(20) default NULL,
  `admin_pass` varchar(32) default NULL,
  `admin_group` tinyint(1) default NULL,
  `admin_remark` varchar(200) default NULL,
  `add_date` date default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=gbk AUTO_INCREMENT=16 ;

-- 
-- е `byart_admin`
-- 

INSERT DELAYED IGNORE INTO `byart_admin` (`Id`, `admin_name`, `admin_pass`, `admin_group`, `admin_remark`, `add_date`) VALUES (14, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 2, '', '2007-02-05'),
(15, 'byqy', 'e10adc3949ba59abbe56e057f20f883e', 1, '', '2008-01-31');

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_article`
-- 

DROP TABLE IF EXISTS `byart_article`;
CREATE TABLE IF NOT EXISTS `byart_article` (
  `Id` int(11) NOT NULL auto_increment,
  `art_title` varchar(80) default NULL,
  `art_content` text,
  `art_typeid` int(11) default NULL,
  `art_pritype` int(11) default NULL,
  `art_typename` varchar(20) default NULL,
  `add_user` varchar(20) default NULL,
  `edit_user` varchar(16) default NULL,
  `add_date` date default NULL,
  `look_time` int(11) default '1',
  `art_typeclass` varchar(3) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=gbk AUTO_INCREMENT=16 ;

-- 
-- е `byart_article`
-- 

INSERT DELAYED IGNORE INTO `byart_article` (`Id`, `art_title`, `art_content`, `art_typeid`, `art_pritype`, `art_typename`, `add_user`, `edit_user`, `add_date`, `look_time`, `art_typeclass`) VALUES (1, 'width:860px;', '<p><font face="Arial"><font face="Arial">width:860px;</font></font></p>', 45, 4, 'Ϣ̬', 'admin', NULL, '2008-04-28', 2, '2'),
(2, 'dfgdfgdfgdfgdfgdfgdfgdfg', '<font face="Arial">dfgdfgdfgdfgdfgdfgdfgdfg</font>', 28, 6, 'ȽԽ', 'admin', NULL, '2008-05-04', 1, '3'),
(3, 'fdfgdfg', 'dgdgdgdfgdg', 38, 36, 'бϢ', 'admin', NULL, '2008-05-04', 1, '3'),
(4, 'ǲǲǲǲǲǲǲǲ', '<font face="Arial">ǲ<font face="Arial">ǲ</font></font>', 44, 36, '¹', 'admin', NULL, '2008-05-27', 2, '2'),
(5, 'ǲǲǲǲǲǲ', '<font face="Arial">ǲ<font face="Arial">ǲ<font face="Arial">ǲ<font face="Arial">ǲ</font></font></font></font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 2, '3'),
(6, 'ǲǲǲǲǲǲǲǲ', 'ʦط', 45, 4, 'Ϣ̬', 'admin', NULL, '2008-05-27', 2, '2'),
(7, 'ǲǲǲǲǲǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 1, '3'),
(8, 'ǲǲǲ', '<font face="Arial">ǲǲǲ<font face="Arial">ǲǲǲ</font></font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 1, '3'),
(9, 'ǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 1, '3'),
(10, 'ǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 1, '3'),
(11, 'ǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 38, 36, 'бϢ', 'admin', NULL, '2008-05-27', 2, '3'),
(12, 'ǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 27, 5, 'ڽ', 'admin', NULL, '2008-05-27', 1, '3'),
(13, 'ǲǲǲ', '<font face="Arial">ǲǲǲ<img height="0" width="0" alt="" src="/UploadFiles/Image/1211899907caedar.jpg" /><img height="600" width="800" alt="" src="/UploadFiles/Image/1211899920fkzdw7.jpg" /></font>', 26, 5, 'ѽ', 'admin', NULL, '2008-05-27', 1, '3'),
(14, 'ǲǲǲǲǲǲǲǲǲ', '<font face="Arial">ǲǲǲ<font face="Arial">ǲǲǲ<img alt="" src="/UploadFiles/Image/1211899955uhm3vk.jpg" /></font></font>', 26, 5, 'ѽ', 'admin', NULL, '2008-05-27', 1, '3'),
(15, 'ǲǲǲǲǲǲǲǲ', '<font face="Arial">ǲǲǲ</font>', 26, 5, 'ѽ', 'admin', NULL, '2008-05-27', 2, '3');

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_down`
-- 

DROP TABLE IF EXISTS `byart_down`;
CREATE TABLE IF NOT EXISTS `byart_down` (
  `Id` int(11) NOT NULL auto_increment,
  `down_title` varchar(200) default NULL,
  `down_url` varchar(100) default NULL,
  `down_content` text,
  `add_user` varchar(40) default NULL,
  `add_date` date default NULL,
  `look_time` int(11) default NULL,
  `down_typeid` int(11) default NULL,
  `down_typename` varchar(40) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

-- 
-- е `byart_down`
-- 

INSERT DELAYED IGNORE INTO `byart_down` (`Id`, `down_title`, `down_url`, `down_content`, `add_user`, `add_date`, `look_time`, `down_typeid`, `down_typename`) VALUES (1, 'ļļļļ', '/UploadFiles/12094339011srx1g.xls', 'KKKKK', 'admin', '2008-04-29', NULL, 34, 'ñ');

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_img`
-- 

DROP TABLE IF EXISTS `byart_img`;
CREATE TABLE IF NOT EXISTS `byart_img` (
  `Id` int(11) NOT NULL auto_increment,
  `img_title` varchar(200) default NULL,
  `img_url` varchar(100) default NULL,
  `img_content` text,
  `add_date` date default NULL,
  `add_user` varchar(20) default NULL,
  `look_time` int(11) default '0',
  `img_stat` tinyint(1) default '0',
  `img_typeid` int(11) default NULL,
  `img_typename` varchar(40) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=gbk AUTO_INCREMENT=35 ;

-- 
-- е `byart_img`
-- 

INSERT DELAYED IGNORE INTO `byart_img` (`Id`, `img_title`, `img_url`, `img_content`, `add_date`, `add_user`, `look_time`, `img_stat`, `img_typeid`, `img_typename`) VALUES (4, 'ĿĿܹ콱', '/UploadFiles/Image/1174308369.jpg', '', '2007-05-11', 'admin', 63, 1, 21, 'ͼƬ'),
(5, '', '/UploadFiles/Image/1174308415.jpg', '', '2007-03-19', 'admin', 57, 1, 21, 'ͼƬ'),
(6, 'ӪͨĿӪƿ', '/UploadFiles/Image/1174308444.jpg', '', '2007-03-19', 'admin', 57, 1, 21, 'ͼƬ'),
(7, '־ֳȫרⷢ', '/UploadFiles/Image/1174308497.jpg', '', '2007-05-14', 'admin', 65, 1, 21, 'ͼƬ'),
(8, 'ϯȫṤ', '/UploadFiles/Image/1174308545.jpg', '', '2007-05-14', 'admin', 37, 1, 21, 'ͼƬ'),
(9, '־ֵίѧҽ', '/UploadFiles/Image/1174308575.jpg', '', '2007-03-19', 'admin', 60, 1, 21, 'ͼƬ'),
(10, '־ֳѧ', '/UploadFiles/Image/1174308612.jpg', '', '2007-05-14', 'admin', 64, 1, 21, 'ͼƬ'),
(11, '־ֳＯŹ˾ֹᾫ', '/UploadFiles/Image/1174308712.jpg', '', '2007-03-19', 'admin', 53, 1, 21, 'ͼƬ'),
(12, '᳡', '/UploadFiles/Image/1174308743.jpg', '', '2007-03-19', 'admin', 71, 1, 21, 'ͼƬ'),
(13, 'ϯ̨', '/UploadFiles/Image/1174308776.jpg', '', '2007-03-19', 'admin', 67, 1, 21, 'ͼƬ'),
(14, '̾쵼ݰָ', '/UploadFiles/Image/1174308811.jpg', '', '2008-01-28', 'admin', 70, 1, 21, 'ͼƬ'),
(3, 'Ƚ콱', '/UploadFiles/Image/1174307584.jpg', '', '2007-03-19', 'admin', 58, 1, 21, 'ͼƬ'),
(22, '־³1', '/UploadFiles/Image/1192978999.jpg', '<font face="Arial">־³1</font>', '2007-10-21', 'admin', 4, 0, 21, 'ͼƬ'),
(21, '³ʩ', '/UploadFiles/Image/1192978833.jpg', '<font face="Arial">³ʩ</font>', '2007-10-21', 'admin', 10, 1, 21, 'ͼƬ'),
(20, '³ʩϼ', '/UploadFiles/Image/1192978494.jpg', '<font face="Arial">³ʩϼ</font>', '2007-10-21', 'admin', 5, 0, 21, 'ͼƬ'),
(23, '־³', '/UploadFiles/Image/1192979152.jpg', '<font face="Arial">־³</font>', '2007-10-21', 'admin', 10, 1, 21, 'ͼƬ'),
(24, '־ĿƬ-׹ཬ豸', '/UploadFiles/Image/1192979264.jpg', '<font face="Arial">־ĿƬ-׹ཬ豸</font>', '2007-10-21', 'admin', 7, 1, 21, 'ͼƬ'),
(25, 'Ŀ-ӴǽĻཬʩֳ', '/UploadFiles/Image/1192979388.jpg', '<font face="Arial">Ŀ-ӴǽĻཬʩֳ</font>', '2007-10-21', 'admin', 13, 1, 21, 'ͼƬ'),
(26, 'Ŀ-ҰӼǽǰΧ̽ཬʩ', '/UploadFiles/Image/1192979438.jpg', '<font face="Arial">Ŀ-ҰӼǽǰΧ̽ཬʩ</font>', '2007-10-21', 'admin', 13, 1, 21, 'ͼƬ'),
(27, 'Ŀ-ཬ¼Ǽֳ', '/UploadFiles/Image/1192979487.jpg', '<font face="Arial">Ŀ-ཬ¼Ǽֳ</font>', '2008-01-28', 'admin', 15, 1, 21, 'ͼƬ'),
(28, 'Ŀ-ӴǽԤཬֳ', '/UploadFiles/Image/1192979560.jpg', '<font face="Arial">Ŀ-ӴǽԤཬֳ</font>', '2007-10-21', 'admin', 9, 0, 21, 'ͼƬ'),
(29, 'Ŀ-Ļˮʯ', '/UploadFiles/Image/1192979617.jpg', '<font face="Arial">Ŀ-Ļˮʯ</font>', '2007-10-21', 'admin', 9, 0, 21, 'ͼƬ'),
(30, 'Ŀ-ҵֳо¼', '/UploadFiles/Image/1192979662.jpg', '<strong style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 12pt; FONT-FAMILY: ; mso-ascii-font-family: ''Times New Roman''; mso-hansi-font-family: ''Times New Roman''; mso-bidi-font-family: ''Times New Roman''; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><strong><font face="">Ŀ-ҵֳо¼</font></strong></span></strong>', '2008-01-28', 'admin', 9, 0, 21, 'ͼƬ'),
(31, '1734m߳ȵĻཬʩ', '/UploadFiles/Image/1192979697.jpg', '<font face="Arial">ĿƬ-1734m߳ȵĻཬʩ</font>', '2008-01-28', 'admin', 11, 1, 21, 'ͼƬ'),
(32, '-󰶰ӼĻ', '/UploadFiles/Image/1192979786.jpg', '<font face="Arial">Ŀ-󰶰ӼĻ</font>', '2008-01-28', 'admin', 10, 1, 21, 'ͼƬ'),
(33, '-ҰӼĻ', '/UploadFiles/Image/1192979926.jpg', '<font face="Arial">Ŀ-ҰӼĻ</font>', '2008-01-28', 'admin', 11, 1, 21, 'ͼƬ');

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_lead`
-- 

DROP TABLE IF EXISTS `byart_lead`;
CREATE TABLE IF NOT EXISTS `byart_lead` (
  `Id` int(11) NOT NULL auto_increment,
  `lead_name` varchar(20) default NULL,
  `lead_work` varchar(250) default NULL,
  `lead_img` varchar(200) default NULL,
  `lead_content` text,
  `add_date` date default NULL,
  `add_user` varchar(20) default NULL,
  `look_time` int(11) default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_lead`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `byart_news`
-- 

DROP TABLE IF EXISTS `byart_news`;
CREATE TABLE IF NOT EXISTS `byart_news` (
  `Id` int(11) NOT NULL auto_increment,
  `news_title` varchar(80) default NULL,
  `news_content` text,
  `add_user` varchar(11) default NULL,
  `edit_user` varchar(16) default NULL,
  `news_type` varchar(20) default NULL,
  `add_date` date default NULL,
  `look_time` int(11) default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_news`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `byart_single`
-- 

DROP TABLE IF EXISTS `byart_single`;
CREATE TABLE IF NOT EXISTS `byart_single` (
  `Id` int(11) NOT NULL auto_increment,
  `type_id` int(11) default NULL,
  `single_item` varchar(100) default NULL,
  `single_content` text,
  `single_user` varchar(20) default NULL,
  `single_date` date default NULL,
  `edit_time` int(11) default NULL COMMENT '༭',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=gbk AUTO_INCREMENT=10 ;

-- 
-- е `byart_single`
-- 

INSERT DELAYED IGNORE INTO `byart_single` (`Id`, `type_id`, `single_item`, `single_content`, `single_user`, `single_date`, `edit_time`) VALUES (1, 11, '־ֽ', '<div><span style="FONT-SIZE: 42pt">\r\n<p><font face="" size="4">&nbsp;&nbsp;&nbsp;&nbsp; ˮʮ̷ֻ־һ֧רҵȫۺ豸Ƚʩḻĵػרҵ飬ӵн貿䷢ĵػʩһʼԴ䷢ĵֺμ׼ʡְ280ˣרҵԱ86ˣи߼ְ13ˣмְ31ˣһĿ6ˡڵֺͱ֧ػͻʩӵȽĻе豸ʩ280̨ࣨף̶ʲֵ2500Ԫɸêêʩ10ס׹ཬ10סŷǽ2ƽסѹཬ3סֱ1.5ϣ׹ע׮2׵ۺʩ<br />\r\n&nbsp;&nbsp;&nbsp;&nbsp; ־ֿɶе͵ֺˮˮ繤̵Ļǽ1.2mС100m崦29mཬ̣̽ᡢĻཬѧཬˮཬ̡ѹཬ硢硢磩߱ԤӦê̡ӹ̣ɳеҵý·ȹ̵ĵʿ̽͵ػ׮⡢ӽˮˮ񣬾йҽ貿䷢Ҽ֤̿顣<br />\r\n־ֽеĵػʩĿӰУɵվ20׹ཬ120mˮվˮཬ̣10.4mҷ־ʩγ10.5kmˮվˮཬԼ8kmһʽѹҹཬ̣޵һʽѹңС춼ʽѹҹཬ̣ཬѹ5Mpaɽںֵվ̻ҽǽȪˮŷǽ͵ܸѹ׮ƺ׸ֽǽ50.5mĴ崨ػƵվĻ̽ཬǵվӻཬΧ߸ཬվཬ̲վӻӵף120mѹѹ6MPaཬ1000KNԤӦêӹ̵ȻСӵվբַǲĻཬNAMLEUKվӹ̴ҦӰӵվ߱1200KN50mѹê10~15mê˼ӹ̹̣վĻཬƵ껬̣õվ̣߱ͭӵվ󰶱֧̣ɶ˳120KVվػݴӶܵĻཬ̽ཬ̣زˮվεȹ̡<br />\r\n&nbsp;&nbsp;&nbsp;&nbsp; ־Ƽķչսԣڻ򲻶չƹӦ¼¹ա»ߣӦñȽϵ͵У̲վСھͷȫ治ȡо͸ŨȶԽҺGINཬգӶվܵཬʩգʽˮʽཬʩգҦӰӵվ߱¸ǲǿ绯ʯײȡTUBEXܼƼӹķ򵹳ΣףܼСھͷĳɹӦڹڹ̹ཬ׷Ϊ࣬ĿǰͬҵоȵλһˮվС춼ˮվʽѹҸѹཬдʽѹҸѹཬʩǹΨһʽѹʩɹרҵʩ顣<br />\r\nҷ־ֳڹ᳹&ldquo;һΪ&rdquo;ҵ񣬽߳Ϊ˿ṩʡЧѧɿķܵ˹˿͵һºδĻ̽УԸۺļʩ豸ǿʩȫȫϵȽĹģʽЯֹԻͣ</font></p>\r\n<p class="wen STYLE1"><font face=""><font size="4"><strong>ʩ</strong>ཬǽ硢޸ظѹཬѧཬê׮׮ȡ</font></font></p>\r\n<p class="wen STYLE1"><font face="" size="4">Ŀǰ־ڽĿУཬƺվբ׼»ײŷǽսկˮվӴӻѧཬվ</font></p>\r\n<p><font face=""><font size="4"><span class="wen STYLE1">ĿУƽһڲǿѦǵվҵվ³բ׻</span><span class="STYLE4"></span></font></font></p>\r\n</span></div>', 'admin', '2008-04-26', NULL),
(2, 13, '־ҵ', '<p><font face="" size="4">˷ǽҪFTPΪ<br />\r\n1VSFFTPʹû½</font></p>\r\n<p><font face="" size="4"> ϵͳSELINUX managermentеbooleanѡFTPµ Allow ftp to read/write files in the user home directories<br />\r\nնִУ<br />\r\nsetsebool -P ftp_home_dir=1&nbsp;&nbsp;&nbsp;&nbsp; //ʹû½ ддP</font></p>\r\n<p><font face="" size="4">&nbsp;</font></p>\r\n<p><font face="" size="4">2ûĿ¼<br />\r\nvsftpd.conf У/etc/vsftpd/vsftpd.conf</font></p>\r\n<p><font face="" size="4">¼һѡ<br />\r\nchroot_local_user=YES</font></p>\r\n<p><font face="" size="4">⼸ѡ<br />\r\nchroot_list_enable=YES<br />\r\nchroot_list_file=/etc/vsftpd/chroot_list</font></p>\r\n<p><br />\r\n<font face="" size="4">һchroot_listŵǣ㲻ʹû½Ŀ¼û</font></p>\r\n<p><font face="" size="4">ȻҲԲô2ôûûĿ¼</font></p>\r\n<p><font face="" size="4">&nbsp;</font></p>\r\n<p><font face="" size="4">2ûʹòͬĿ¼</font></p>\r\n<p><font face="" size="4">vsftpd.conf <br />\r\nguest_username=virtual_user<br />\r\nuser_config_dir=/etc/vsftpd/vsftpd_user_config<br />\r\nuser_sub_token=$USER</font></p>\r\n<p><font face="" size="4">ҽ/etc/vsftpd/vsftpd_user_config/Ŀ¼<br />\r\nĿ¼пԴźûһļļָͬĿ¼ԴﵽͬûʲͬĿ¼Ŀġ<br />\r\nļ룺<br />\r\nlocal_root=/Ŀ¼·<br />\r\n磺<br />\r\nlocal_root=/var/www/html/</font></p>\r\n<p><font face="" size="4">3ҪûͬһĿ¼Ļֱvsftpd.confм local_root=/Ŀ¼·</font></p>\r\n<p><font face="" size="4">&nbsp;</font></p>', 'admin', '2008-04-26', NULL),
(5, NULL, '̹', NULL, NULL, NULL, NULL),
(6, NULL, '־ֽ', NULL, NULL, NULL, NULL),
(7, NULL, '־', NULL, NULL, NULL, NULL),
(8, NULL, '־ҵ', NULL, NULL, NULL, NULL),
(9, NULL, '쵼´', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_src`
-- 

DROP TABLE IF EXISTS `byart_src`;
CREATE TABLE IF NOT EXISTS `byart_src` (
  `Id` int(11) NOT NULL auto_increment,
  `src_title` varchar(200) default NULL COMMENT '˵',
  `src_url` varchar(250) default NULL COMMENT 'ӵַ',
  `src_img` varchar(250) default NULL COMMENT 'ͼƬ',
  `src_type` tinyint(2) default NULL,
  `add_date` date default NULL,
  `add_user` varchar(20) default NULL,
  `src_stat` tinyint(1) default '0' COMMENT 'Ƿҳʾ',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='' AUTO_INCREMENT=1 ;

-- 
-- е `byart_src`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `byart_txl`
-- 

DROP TABLE IF EXISTS `byart_txl`;
CREATE TABLE IF NOT EXISTS `byart_txl` (
  `Id` int(11) NOT NULL auto_increment,
  `txl_danwei` varchar(50) default NULL,
  `txl_ren` varchar(20) default NULL,
  `txl_tel` varchar(20) default NULL,
  `txl_stat` tinyint(1) default '0',
  `idx` varchar(4) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_txl`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `byart_type`
-- 

DROP TABLE IF EXISTS `byart_type`;
CREATE TABLE IF NOT EXISTS `byart_type` (
  `Id` int(11) NOT NULL auto_increment,
  `type_name` varchar(20) default NULL,
  `type_stat` tinyint(1) default NULL COMMENT '״̬1-2-',
  `type_shu` int(11) default NULL COMMENT 'ʹĳĿ',
  `type_class` tinyint(3) default NULL COMMENT 'µԣ1-һ£2-3-4-ͼƬ5-̳Ŀ',
  `type_remark` varchar(200) default NULL COMMENT 'ѡ̳ĿҪ¼ַ',
  `type_list` varchar(4) default NULL,
  `type_check` tinyint(2) default '1',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=gbk AUTO_INCREMENT=47 ;

-- 
-- е `byart_type`
-- 

INSERT DELAYED IGNORE INTO `byart_type` (`Id`, `type_name`, `type_stat`, `type_shu`, `type_class`, `type_remark`, `type_list`, `type_check`) VALUES (1, '־ָſ', 1, 0, NULL, '', '1', 1),
(3, '־ֹ', 1, 0, NULL, '', '2', 1),
(4, '', 1, 0, NULL, '', '3', 1),
(5, '', 1, 0, NULL, '', '4', 1),
(6, 'Ⱥ', 1, 0, NULL, '', '5', 1),
(9, '־̳', 1, 0, NULL, '', '7', 1),
(10, '', 1, 0, NULL, '', '6', 1),
(11, '־ֽ', 2, 1, 1, '', '1', 1),
(12, '־', 2, 1, 1, '', '2', 1),
(13, '־ҵ', 2, 1, 1, '', '3', 1),
(14, '̼', 2, 3, 3, '', '3', 1),
(15, 'Ӫ', 2, 3, 3, '', '1', 1),
(16, 'Դ', 2, 3, 3, '', '5', 1),
(17, '豸', 2, 3, 3, '', '1', 1),
(18, 'ȫ', 2, 3, 3, '', '2', 1),
(19, '籣', 2, 3, 3, '', '7', 1),
(20, 'Ǽ춽', 2, 3, 3, '', '4', 1),
(21, 'ͼƬ', 2, 4, 5, '', '2', 1),
(22, 'Ƶ', 2, 4, 2, '', '4', 1),
(23, 'ļ', 2, 4, 2, '', '3', 1),
(24, '⹤', 2, 5, 3, '', NULL, 1),
(26, 'ѽ', 2, 5, 3, '', NULL, 1),
(27, 'ڽ', 2, 5, 3, '', NULL, 1),
(28, 'ȽԽ', 2, 6, 3, '', NULL, 1),
(29, '', 2, 6, 3, '', NULL, 1),
(30, '', 2, 6, 3, '', NULL, 1),
(31, '', 2, 6, 3, '', NULL, 1),
(32, '鼮', 2, 10, 4, '', NULL, 1),
(33, 'ʩ淶', 2, 10, 4, '', NULL, 1),
(34, 'ñ', 2, 10, 4, '', NULL, 1),
(35, '', 2, 10, 4, '', NULL, 1),
(36, '', 1, 0, NULL, '', '8', 0),
(37, 'бϢ', 2, 36, 3, '', NULL, 0),
(38, 'бϢ', 2, 36, 3, '', NULL, 0),
(44, '¹', 2, 36, 2, '', NULL, 0),
(40, '쵼´', 2, 36, 1, '', NULL, 0),
(41, 'Ͷ', 2, 9, 6, '/bbs/forumdisplay.php?fid=9', NULL, 1),
(42, '', 2, 9, 6, '/bbs/forumdisplay.php?fid=8', NULL, 1),
(43, 'ÿ', 2, 9, 6, '/bbs/forumdisplay.php?fid=6', NULL, 1),
(45, 'Ϣ̬', 2, 4, 2, '', '1', 1);

-- --------------------------------------------------------

-- 
-- Ľṹ `byart_user`
-- 

DROP TABLE IF EXISTS `byart_user`;
CREATE TABLE IF NOT EXISTS `byart_user` (
  `Id` int(11) NOT NULL auto_increment,
  `user_name` varchar(20) default NULL,
  `user_pass` varchar(32) default NULL,
  `user_email` varchar(100) default NULL,
  `user_question` varchar(100) default NULL,
  `user_answer` varchar(100) default NULL,
  `user_sex` tinyint(1) default NULL,
  `user_qq` varchar(11) default NULL,
  `user_brith` date default NULL,
  `user_remark` text,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_user`
-- 

