CREATE TABLE `myf_admin` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL COMMENT '½',
  `pwd` varchar(32) NOT NULL COMMENT '',
  `uname` varchar(30) default NULL COMMENT '',
  `email` varchar(50) NOT NULL COMMENT 'ʼ',
  `logintime` datetime default NULL COMMENT '½ʱ',
  `loginip` varchar(20) default NULL COMMENT 'ϴε½ip',
  `authority` varchar(500) default NULL COMMENT 'Ȩ',
  `createtime` datetime default NULL COMMENT 'ʱ',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='ϵͳԱû';


CREATE TABLE `myf_archives` (
  `id` int(11) NOT NULL auto_increment,
  `typeid` int(11) NOT NULL COMMENT 'Ŀ',
  `typename` varchar(50) default NULL COMMENT 'Ŀ',
  `flag` varchar(50) default NULL COMMENT 'Զ',
  `click` int(11) default '0' COMMENT '',
  `title` varchar(255) NOT NULL COMMENT '',
  `color` char(7) default NULL COMMENT '±ɫ',
  `writer` varchar(50) default NULL COMMENT '',
  `source` varchar(50) default NULL COMMENT 'Դ',
  `jump` varchar(255) default NULL COMMENT 'תַ',
  `litpic` varchar(255) default NULL COMMENT 'ͼ',
  `smallpic` varchar(255) default NULL COMMENT 'ͼ2-Сͼ',
  `tag` varchar(255) default NULL COMMENT '±ǩ',
  `keywords` varchar(255) default NULL COMMENT '¹ؼ',
  `description` varchar(500) default NULL COMMENT '',
  `sendtime` datetime NOT NULL COMMENT 'ʱ',
  `adminid` int(11) default NULL COMMENT '¹Ա',
  `adminname` varchar(30) default NULL COMMENT '¹Ա',
  `body` text COMMENT '',
  `ishtml` tinyint(4) NOT NULL default '0' COMMENT 'Ƿhtml',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='±';

CREATE TABLE `myf_arctype` (
  `id` int(11) NOT NULL auto_increment,
  `topid` int(11) NOT NULL default '0' COMMENT 'Ŀ',
  `sortrank` smallint(6) NOT NULL default '50' COMMENT 'Ŀ',
  `typename` varchar(50) NOT NULL COMMENT 'Ŀ,С',
  `typedir` varchar(50) NOT NULL COMMENT 'Ŀ¼ַ',
  `arcnamerule` varchar(50) default NULL COMMENT 'ҳ',
  `listnamerule` varchar(50) default NULL COMMENT 'бҳ',
  `indexpath` varchar(255) default NULL COMMENT 'ģ·',
  `listpath` varchar(255) default NULL COMMENT 'бҳģ',
  `singlepath` varchar(255) default NULL COMMENT 'ҳģ',
  `archivepath` varchar(255) default NULL COMMENT 'ģ',
  `keywords` varchar(255) default NULL COMMENT 'ؼ',
  `seotitle` varchar(255) default NULL COMMENT 'seo',
  `description` varchar(500) default NULL COMMENT 'Ŀ',
  `typepro` smallint(6) NOT NULL default '0' COMMENT 'Ŀ,0-бҳ1-Ƶ棬2-ⲿ,3-ҳ',
  `dirpos` int(11) default '0' COMMENT 'Ŀ¼λã0-Ŀ¼1-CMSĿ¼',
  `isshow` int(11) default '1' COMMENT 'Ƿʾ0-ʾ1-ʾ',
  `litpic` varchar(255) default NULL COMMENT 'Ŀͼ',
  `body` text COMMENT 'Ŀ',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `typedir` (`typedir`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Ŀ';

CREATE TABLE `myf_flink` (
  `id` int(11) NOT NULL auto_increment,
  `sortrank` smallint(6) NOT NULL default '50',
  `url` varchar(150) NOT NULL COMMENT 'ӵַ',
  `webname` varchar(50) NOT NULL COMMENT 'վ',
  `description` varchar(255) default NULL COMMENT 'վ',
  `logo` varchar(150) default NULL COMMENT 'վlogoַ',
  `dtime` datetime default NULL COMMENT 'ʱ',
  PRIMARY KEY  (`id`),
  KEY `sortrank` (`sortrank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ӱ';

CREATE TABLE `myf_moban` (
  `id` int(11) NOT NULL auto_increment,
  `filename` varchar(255) default NULL COMMENT 'ģhtmlҳ',
  `name` varchar(50) default NULL COMMENT 'ģ',
  `updatetime` datetime default NULL COMMENT 'ʱ',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

CREATE TABLE `myf_sys` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL COMMENT '',
  `value` varchar(500) NOT NULL COMMENT 'ֵ',
  `info` varchar(255) default NULL COMMENT '˵',
  `valuetype` enum('text','string') NOT NULL default 'string',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `un_name` USING BTREE (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='ϵͳ';

CREATE TABLE `myf_tag` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL COMMENT 'ǩ',
  `arcid` int(11) NOT NULL COMMENT '±',
  `typeid` int(11) default NULL COMMENT 'Ŀ',
  `createtime` datetime default NULL COMMENT 'ʱ',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='±ǩ';

