/*==============================================================*/
/* DBMS name:      MySQL 5.0                                    */
/* Created on:     2015/7/17 14:51:06                           */
/*==============================================================*/


drop table if exists BL_Admins;

drop table if exists BL_Configs;

drop table if exists BL_Materials;

/*==============================================================*/
/* Table: BL_Admins                                             */
/*==============================================================*/
create table BL_Admins
(
   Id                   int unsigned not null auto_increment,
   Account              varchar(20) not null,
   Password             varchar(32) not null,
   Nick                 varchar(20),
   Email                varchar(50),
   Status               tinyint(1) not null comment '0-禁用   1-启用',
   primary key (Id)
);

insert into BL_Admins(Account,Password,Nick,Email,Status) values('admin','256484B4241F6A9A9EC40D50EDF90A61','admin','admin@admin.com',1);

/*==============================================================*/
/* Table: BL_Configs                                            */
/*==============================================================*/
create table BL_Configs
(
   Id                   int unsigned not null auto_increment,
   Name                 varchar(25) not null,
   Value                text not null,
   primary key (Id)
);

insert into BL_Configs(Name,Value) values('WeixinType','0');
insert into BL_Configs(Name,Value) values('WeixinToken','');
insert into BL_Configs(Name,Value) values('WeixinEncodingAESKey','');
insert into BL_Configs(Name,Value) values('WeixinAppId','');
insert into BL_Configs(Name,Value) values('WeixinAppSecret','');

/*==============================================================*/
/* Table: BL_Materials                                          */
/*==============================================================*/
create table BL_Materials
(
   Id                   int unsigned not null auto_increment,
   Mid                  int(15) unsigned not null,
   Type                 tinyint(1) unsigned not null comment '1-文本素材   2-图文素材',
   Title                varchar(64) not null,
   Description          varchar(120),
   PicUrl               varchar(100),
   Content              text not null,
   AddDate              datetime not null,
   primary key (Id)
);