⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 oa.sql

📁 极限OA开源系统
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
  `email` varchar(30) NOT NULL default '',
  `depart` smallint(6) unsigned NOT NULL default '0',
  `duty` smallint(6) unsigned NOT NULL default '0',
  `employtype` tinyint(1) unsigned NOT NULL default '1',
  `postdate` date NOT NULL default '0000-00-00',
  `leftdate` date NOT NULL default '0000-00-00',
  `memo` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='员工表';



#
# Dumping data for table 'oa_employees'
#
INSERT INTO oa_employees VALUES("1","ps2","男","2003-12-09","","","0","0","0","","","","0451-6524139","","mkt@xsp.cn","1","4","0","2003-12-02","0000-00-00","");
INSERT INTO oa_employees VALUES("3","ssst","男","1980-02-25","510721542158442562","四川","30","18","12","add","150001","1111111","0576-5131349","2222222","mkt@xsp.cn","6","2","1","2003-12-19","2005-12-08","");
INSERT INTO oa_employees VALUES("4","xiahb","男","1974-05-15","","台州","26","20","13","浙江省临海市","317000","","0576-5131349","13018826761","mkt@xsp.cn","1","3","1","2003-08-01","0000-00-00","");


#
# Table structure for table 'oa_file'
#

CREATE TABLE `oa_file` (
  `id` int(12) unsigned NOT NULL auto_increment,
  `fid` int(11) unsigned NOT NULL default '0',
  `title` varchar(40) NOT NULL default '',
  `content` text NOT NULL,
  `name` varchar(50) NOT NULL default '',
  `fname` varchar(80) NOT NULL default '',
  `extension` varchar(8) NOT NULL default '',
  `filetype` varchar(20) NOT NULL default '',
  `size` varchar(10) NOT NULL default '0',
  `edit` varchar(40) NOT NULL default '',
  `time` int(11) unsigned NOT NULL default '0',
  `ttime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='文档管理-----文件表';


#
# Table structure for table 'oa_filetemplate'
#

CREATE TABLE `oa_filetemplate` (
  `id` int(12) unsigned NOT NULL auto_increment,
  `type` smallint(6) unsigned NOT NULL default '0',
  `name` varchar(40) NOT NULL default '',
  `content` text NOT NULL,
  `admin` varchar(15) NOT NULL default '',
  `time` int(11) unsigned NOT NULL default '0',
  `ttime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='文档管理-----模板';



#
# Dumping data for table 'oa_filetemplate'
#


#
# Table structure for table 'oa_filetype'
#

CREATE TABLE `oa_filetype` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '0',
  `fig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Table structure for table 'oa_folder'
#

CREATE TABLE `oa_folder` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `des` varchar(250) NOT NULL default '',
  `mid` int(10) unsigned NOT NULL default '0',
  `admin` varchar(15) NOT NULL default '',
  `dorder` smallint(6) NOT NULL default '0',
  `pid` smallint(6) NOT NULL default '-1',
  `plist` varchar(250) NOT NULL default '',
  `outspread` tinyint(1) unsigned NOT NULL default '1',
  `allowaddfolder` tinyint(1) unsigned NOT NULL default '1',
  `alloweditfolder` tinyint(1) unsigned NOT NULL default '1',
  `allowdelfolder` tinyint(1) unsigned NOT NULL default '1',
  `allowdel` tinyint(1) unsigned NOT NULL default '1',
  `ttime` datetime NOT NULL default '2000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='文档管理-----文件夹表';



#
# Dumping data for table 'oa_folder'
#
INSERT INTO oa_folder VALUES("1","0","根目录","","2","admin","1","-1","1,-1","1","1","1","1","1","2003-12-25 00:00:00");
INSERT INTO oa_folder VALUES("2","1","个人文件夹","个人文件专柜","2","admin","1","1","2,1,-1","1","1","1","1","1","2003-12-25 00:00:00");
INSERT INTO oa_folder VALUES("3","2","部门文件夹","分配各部门的文件夹","2","admin","2","1","3,1,-1","0","1","1","1","1","2003-12-25 00:00:00");
INSERT INTO oa_folder VALUES("4","3","公共文件夹","","2","admin","3","1","4,1,-1","1","1","1","1","1","2003-12-25 00:00:00");


#
# Table structure for table 'oa_listday'
#

CREATE TABLE `oa_listday` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(40) default NULL,
  `des` text NOT NULL,
  `executant` text NOT NULL,
  `tdate` date NOT NULL default '0000-00-00',
  `stime` varchar(5) NOT NULL default '',
  `etime` varchar(5) NOT NULL default '',
  `awoke` tinyint(2) unsigned NOT NULL default '0',
  `scope` int(10) NOT NULL default '-1',
  `level` varchar(6) NOT NULL default '',
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `admin` varchar(20) NOT NULL default '',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `log` (`executant`,`des`)
) TYPE=MyISAM COMMENT='日程计划表';


#
# Table structure for table 'oa_members'
#

CREATE TABLE `oa_members` (
  `uid` mediumint(8) unsigned NOT NULL auto_increment,
  `part` smallint(6) unsigned NOT NULL default '0',
  `realname` varchar(30) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `employ` smallint(6) unsigned NOT NULL default '0',
  `email` varchar(60) NOT NULL default '',
  `des` text NOT NULL,
  `fig` tinyint(1) unsigned NOT NULL default '1',
  `newps` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `username` (`username`)
) TYPE=MyISAM COMMENT='会员表';



#
# Dumping data for table 'oa_members'
#
# INSERT INTO oa_members VALUES("2","4","ps2","admin","444bcb3a3fcf8389296c49467f27e1d6","1","admin@domain.cn","技术部门人员","1","0");


#
# Table structure for table 'oa_parts'
#

CREATE TABLE `oa_parts` (
  `id` smallint(4) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '0',
  `des` varchar(100) NOT NULL default '',
  `fig` tinyint(1) unsigned NOT NULL default '1',
  `rights` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='角色表';



#
# Dumping data for table 'oa_parts'
#
INSERT INTO oa_parts VALUES("15","技术工程师","","1","");
INSERT INTO oa_parts VALUES("14","技术总监","技术部门主管，负责技术部门工作","1","");
INSERT INTO oa_parts VALUES("4","总经理","公司负责人，负责全公司的日常经营管理事务","1","a:7:{i:11;a:3:{s:4:\"name\";s:8:\"个人助理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"待办事宜\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:21;a:3:{s:4:\"name\";s:8:\"个人日记\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:31;a:3:{s:4:\"name\";s:6:\"通讯录\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}}}i:21;a:3:{s:4:\"name\";s:8:\"信息交流\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:6:\"公告栏\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:31;a:3:{s:4:\"name\";s:8:\"日常办公\";s:5:\"value\";i:1;s:2:\"vk\";a:2:{i:11;a:3:{s:4:\"name\";s:8:\"计划安排\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"任务管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:41;a:3:{s:4:\"name\";s:8:\"文档管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"文件管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:51;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:61;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"产品管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:31;a:3:{s:4:\"name\";s:8:\"销售报表\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:91;a:3:{s:4:\"name\";s:8:\"系统管理\";s:5:\"value\";i:1;s:2:\"vk\";a:5:{i:11;a:3:{s:4:\"name\";s:8:\"基本信息\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"员工管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:31;a:3:{s:4:\"name\";s:8:\"部门管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:41;a:3:{s:4:\"name\";s:8:\"用户管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:51;a:3:{s:4:\"name\";s:8:\"角色管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}}");
INSERT INTO oa_parts VALUES("5","副总经理","协助公司总经理工作","1","a:7:{i:11;a:3:{s:4:\"name\";s:8:\"个人助理\";s:5:\"value\";i:0;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"待办事宜\";s:5:\"value\";i:0;s:2:\"vs\";s:1:\"-\";}i:21;a:3:{s:4:\"name\";s:8:\"个人日记\";s:5:\"value\";i:0;s:2:\"vs\";s:1:\"-\";}i:31;a:3:{s:4:\"name\";s:6:\"通讯录\";s:5:\"value\";i:0;s:2:\"vs\";s:1:\"-\";}}}i:21;a:3:{s:4:\"name\";s:8:\"信息交流\";s:5:\"value\";i:0;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:6:\"公告栏\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}i:31;a:3:{s:4:\"name\";s:8:\"日常办公\";s:5:\"value\";i:1;s:2:\"vk\";a:2:{i:11;a:3:{s:4:\"name\";s:8:\"计划安排\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"任务管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:41;a:3:{s:4:\"name\";s:8:\"文档管理\";s:5:\"value\";i:0;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"文件管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}i:51;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:0;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}i:61;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:0;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"产品管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:21;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:31;a:3:{s:4:\"name\";s:8:\"销售报表\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}i:91;a:3:{s:4:\"name\";s:8:\"系统管理\";s:5:\"value\";i:0;s:2:\"vk\";a:5:{i:11;a:3:{s:4:\"name\";s:8:\"基本信息\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:21;a:3:{s:4:\"name\";s:8:\"员工管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:31;a:3:{s:4:\"name\";s:8:\"部门管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:41;a:3:{s:4:\"name\";s:8:\"用户管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:51;a:3:{s:4:\"name\";s:8:\"角色管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}}");
INSERT INTO oa_parts VALUES("6","市场总监","市场部负责人，负责市场部的日常运作","1","a:7:{i:11;a:3:{s:4:\"name\";s:8:\"个人助理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"待办事宜\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:21;a:3:{s:4:\"name\";s:8:\"个人日记\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:31;a:3:{s:4:\"name\";s:6:\"通讯录\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}}}i:21;a:3:{s:4:\"name\";s:8:\"信息交流\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:6:\"公告栏\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:31;a:3:{s:4:\"name\";s:8:\"日常办公\";s:5:\"value\";i:1;s:2:\"vk\";a:2:{i:11;a:3:{s:4:\"name\";s:8:\"计划安排\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"任务管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:41;a:3:{s:4:\"name\";s:8:\"文档管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"文件管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:51;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}}}i:61;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"产品管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:31;a:3:{s:4:\"name\";s:8:\"销售报表\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:91;a:3:{s:4:\"name\";s:8:\"系统管理\";s:5:\"value\";i:1;s:2:\"vk\";a:5:{i:11;a:3:{s:4:\"name\";s:8:\"基本信息\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}i:21;a:3:{s:4:\"name\";s:8:\"员工管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}i:31;a:3:{s:4:\"name\";s:8:\"部门管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}i:41;a:3:{s:4:\"name\";s:8:\"用户管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}i:51;a:3:{s:4:\"name\";s:8:\"角色管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}}}}");
INSERT INTO oa_parts VALUES("7","销售经理","","1","a:7:{i:11;a:3:{s:4:\"name\";s:8:\"个人助理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"待办事宜\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:21;a:3:{s:4:\"name\";s:8:\"个人日记\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}i:31;a:3:{s:4:\"name\";s:6:\"通讯录\";s:5:\"value\";i:1;s:2:\"vs\";s:1:\"-\";}}}i:21;a:3:{s:4:\"name\";s:8:\"信息交流\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:6:\"公告栏\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11000\";}}}i:31;a:3:{s:4:\"name\";s:8:\"日常办公\";s:5:\"value\";i:1;s:2:\"vk\";a:2:{i:11;a:3:{s:4:\"name\";s:8:\"计划安排\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"任务管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:41;a:3:{s:4:\"name\";s:8:\"文档管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"文件管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:51;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vk\";a:1:{i:11;a:3:{s:4:\"name\";s:8:\"客户管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:61;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vk\";a:3:{i:11;a:3:{s:4:\"name\";s:8:\"产品管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:21;a:3:{s:4:\"name\";s:8:\"销售管理\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}i:31;a:3:{s:4:\"name\";s:8:\"销售报表\";s:5:\"value\";i:1;s:2:\"vs\";s:5:\"11111\";}}}i:91;a:3:{s:4:\"name\";s:8:\"系统管理\";s:5:\"value\";i:0;s:2:\"vk\";a:5:{i:11;a:3:{s:4:\"name\";s:8:\"基本信息\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:21;a:3:{s:4:\"name\";s:8:\"员工管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:31;a:3:{s:4:\"name\";s:8:\"部门管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:41;a:3:{s:4:\"name\";s:8:\"用户管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}i:51;a:3:{s:4:\"name\";s:8:\"角色管理\";s:5:\"value\";i:0;s:2:\"vs\";s:5:\"00000\";}}}}");
INSERT INTO oa_parts VALUES("8","客服总监","负责客服部门的日常运作","1","");
INSERT INTO oa_parts VALUES("9","客服经理","","1","");
INSERT INTO oa_parts VALUES("10","行政总监","行政部门主管，负责行政事务","1","");
INSERT INTO oa_parts VALUES("11","行政经理","","1","");
INSERT INTO oa_parts VALUES("12","财务总监","财务部门总管，负责公司的财务运营","1","");
INSERT INTO oa_parts VALUES("13","财务经理","","1","");


#
# Table structure for table 'oa_ps'
#

CREATE TABLE `oa_ps` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `public` tinyint(1) NOT NULL default '0',
  `folderid` tinyint(1) NOT NULL default '0',
  `touser` varchar(30) NOT NULL default '',
  `fromuser` varchar(30) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  `messageread` tinyint(1) NOT NULL default '0',
  `readtime` int(10) unsigned NOT NULL default '0',
  `trackoff` tinyint(1) NOT NULL default '1',
  `replyoff` tinyint(1) NOT NULL default '0',
  `deleteyes` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


#
# Table structure for table 'oa_sessions'
#

CREATE TABLE `oa_sessions` (
  `sesskey` varchar(32) NOT NULL default '',
  `expiry` int(11) unsigned NOT NULL default '0',
  `expireref` varchar(64) default NULL,
  `data` text NOT NULL,
  `ssid` varchar(32) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `gid` smallint(1) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `ipband` tinyint(1) NOT NULL default '0',
  `hidden` tinyint(1) NOT NULL default '0',
  `validate` varchar(40) NOT NULL default '',
  `time` int(1) unsigned NOT NULL default '0',
  `ltime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sesskey`)
) TYPE=MyISAM MAX_ROWS=1000 COMMENT='session表';

#
# Table structure for table 'oa_task'
#

CREATE TABLE `oa_task` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '0',
  `des` text NOT NULL,
  `tdate` date NOT NULL default '0000-00-00',
  `stime` varchar(5) NOT NULL default '',
  `tdate2` date NOT NULL default '0000-00-00',
  `etime` varchar(5) NOT NULL default '',
  `awoke` tinyint(2) unsigned NOT NULL default '0',
  `state` varchar(10) NOT NULL default '',
  `plan` tinyint(2) unsigned NOT NULL default '0',
  `executant` text NOT NULL,
  `level` varchar(6) NOT NULL default '',
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `admin` varchar(30) NOT NULL default '',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='任务表';
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -