-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- : 127.0.0.1
-- : 2010  06  24  22:25
-- 汾: 5.0.45
-- PHP 汾: 5.2.5
-- 
-- ݿ: `byart`
-- 

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

-- 
-- Ľṹ `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=2 DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

-- 
-- е `byart_admin`
-- 

INSERT DELAYED IGNORE INTO `byart_admin` (`Id`, `admin_name`, `admin_pass`, `admin_group`, `admin_remark`, `add_date`) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, '', '2010-06-24');

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

-- 
-- Ľṹ `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,
  `art_imgurl` text NOT NULL,
  `art_imgstat` tinyint(1) NOT NULL,
  `art_imgintro` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_article`
-- 


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

-- 
-- Ľṹ `byart_contact`
-- 

DROP TABLE IF EXISTS `byart_contact`;
CREATE TABLE IF NOT EXISTS `byart_contact` (
  `Id` int(11) NOT NULL auto_increment,
  `contact_name` varchar(50) default NULL,
  `contact_person` varchar(20) default NULL,
  `contact_tel` varchar(20) default NULL,
  `contact_address` varchar(100) default NULL,
  `contact_stat` tinyint(1) default '0',
  `idx` varchar(4) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_contact`
-- 


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

-- 
-- Ľṹ `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 DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_down`
-- 


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

-- 
-- Ľṹ `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=2 DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

-- 
-- е `byart_img`
-- 


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

-- 
-- Ľṹ `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 DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_single`
-- 


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

-- 
-- Ľṹ `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_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_url` varchar(200) default NULL COMMENT 'ѡ̳ĿҪ¼ַ',
  `type_list` varchar(4) default NULL,
  `type_check` tinyint(2) default '1',
  `type_remark` varchar(255) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ;

-- 
-- е `byart_type`
-- 

INSERT DELAYED IGNORE INTO `byart_type` (`Id`, `type_name`, `type_stat`, `type_shu`, `type_class`, `type_url`, `type_list`, `type_check`, `type_remark`) VALUES (1, 'aaa', 1, 0, NULL, NULL, NULL, 1, ''),
(2, 'aaa', 2, 1, 3, NULL, NULL, 1, ''),
(3, 'ͼƬ', 2, 1, 5, NULL, NULL, 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`
-- 

