PHPIndex

SET NAMES utf8;
CREATE TABLE `io_file_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `fileID` bigint(20) unsigned NOT NULL COMMENT '文件id',
  `key` varchar(255) NOT NULL COMMENT '存储key',
  `value` text NOT NULL COMMENT '对应值',
  `createTime` int(11) unsigned NOT NULL COMMENT '创建时间',
  `modifyTime` int(11) unsigned NOT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fileID_key` (`fileID`,`key`),
  KEY `fileID` (`fileID`),
  KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文件扩展表';

CREATE TABLE `io_file_contents` (
  `fileID` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件ID',
  `content` mediumtext NOT NULL COMMENT '文本文件内容',
  `createTime` int(11) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`fileID`),
  KEY `createTime` (`createTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文件id';

CREATE TABLE `share_report` (
	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
	`shareID` bigint(20) unsigned NOT NULL COMMENT '分享id',
	`title` varchar(255) NOT NULL COMMENT '分享标题',
	`sourceID` bigint(20) unsigned NOT NULL COMMENT '举报资源id',
	`fileID` bigint(20) unsigned NOT NULL COMMENT '举报文件id,文件夹则该处为0',
	`userID` bigint(20) unsigned NOT NULL COMMENT '举报用户id',
	`type` tinyint(3) unsigned NOT NULL COMMENT '举报类型 (1-侵权,2-色情,3-暴力,4-政治,5-其他)',
	`desc` text NOT NULL COMMENT '举报原因（其他）描述',
	`status` tinyint(3) unsigned NOT NULL COMMENT '处理状态(0-未处理,1-已处理,2-取消分享,3-禁止分享)',
	`createTime` int(11) unsigned NOT NULL COMMENT '创建时间',
	`modifyTime` int(11) unsigned NOT NULL COMMENT '最后修改时间',
	PRIMARY KEY (`id`),
	KEY `shareID` (`shareID`),
	KEY `sourceID` (`sourceID`),
	KEY `fileID` (`fileID`),
	KEY `userID` (`userID`),
	KEY `type` (`type`),
	KEY `modifyTime` (`modifyTime`),
	KEY `createTime` (`createTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='分享举报表';

ALTER TABLE `share` ADD `url` varchar(255) NOT NULL COMMENT '分享别名,替代shareHash' AFTER `sourceID`;
ALTER TABLE `share` ADD INDEX `url` (`url`);
ALTER TABLE `share` ADD `sourcePath` varchar(1024) NOT NULL COMMENT '分享文档路径' AFTER `sourceID`;
ALTER TABLE `share` ADD INDEX `sourcePath` (`sourcePath`);

ALTER TABLE `user_fav` CHANGE `path` `path` varchar(2048) NOT NULL COMMENT '收藏路径,tag时则为sourceID' AFTER `name`;

CREATE TABLE "io_file_meta" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "fileID" integer NOT NULL,
  "key" text(255) NOT NULL,
  "value" text NOT NULL,
  "createTime" integer NOT NULL,
  "modifyTime" integer NOT NULL
);
-- index io_file_meta:
CREATE INDEX 'idx_io_file_meta_primary_key' ON 'io_file_meta' ("id");
CREATE UNIQUE INDEX 'idx_io_file_meta_fileID_key' ON 'io_file_meta' ("fileID","key");
CREATE INDEX 'idx_io_file_meta_fileID' ON 'io_file_meta' ("fileID");
CREATE INDEX 'idx_io_file_meta_key' ON 'io_file_meta' ("key");

CREATE TABLE "io_file_contents" (
  "fileID" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "content" mediumtext NOT NULL,
  "createTime" integer NOT NULL
);
-- index io_file_contents:
CREATE INDEX 'idx_io_file_contents_primary_key' ON 'io_file_contents' ("fileID");
CREATE INDEX 'idx_io_file_contents_createTime' ON 'io_file_contents' ("createTime");

CREATE TABLE "share_report" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "shareID" integer NOT NULL,
  "title" text(255) NOT NULL,
  "sourceID" integer NOT NULL,
  "fileID" integer NOT NULL,
  "userID" integer NOT NULL,
  "type" smallint NOT NULL,
  "desc" text NOT NULL,
  "status" smallint NOT NULL,
  "createTime" integer NOT NULL,
  "modifyTime" integer NOT NULL
);
-- index share_report:
CREATE INDEX 'idx_share_report_primary_key' ON 'share_report' ("id");
CREATE INDEX 'idx_share_report_shareID' ON 'share_report' ("shareID");
CREATE INDEX 'idx_share_report_sourceID' ON 'share_report' ("sourceID");
CREATE INDEX 'idx_share_report_fileID' ON 'share_report' ("fileID");
CREATE INDEX 'idx_share_report_userID' ON 'share_report' ("userID");
CREATE INDEX 'idx_share_report_type' ON 'share_report' ("type");
CREATE INDEX 'idx_share_report_modifyTime' ON 'share_report' ("modifyTime");
CREATE INDEX 'idx_share_report_createTime' ON 'share_report' ("createTime");

ALTER TABLE "share" ADD "url" text(1024) NULL;
CREATE INDEX 'idx_share_url' ON 'share' ("url");

ALTER TABLE 'share' ADD 'sourcePath' text(1024) NULL;
CREATE INDEX 'idx_share_sourcePath' ON 'share' ("sourcePath");