-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- : localhost:3306
-- : 2008  02  02  21:48
-- 汾: 5.0.45
-- PHP 汾: 5.2.5
-- 
-- ݿ: `byarticle`
-- 

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

-- 
-- Ľṹ `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_type` 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',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_article`
-- 


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

-- 
-- Ľṹ `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,
  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_type` varchar(40) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_img`
-- 


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

-- 
-- Ľṹ `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_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_id` tinyint(1) default NULL,
  `type_name` varchar(20) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `byart_type`
-- 


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

-- 
-- Ľṹ `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`
-- 

