45 lines
8.3 KiB
PHP
45 lines
8.3 KiB
PHP
<?php
|
||
$this->E_D("DROP TABLE IF EXISTS `db_file`;");
|
||
$this->E_C("CREATE TABLE `db_file` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '文件ID',
|
||
`pubid` bigint(15) NOT NULL COMMENT '关联信息id',
|
||
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '原始文件名',
|
||
`savename` varchar(255) NOT NULL DEFAULT '' COMMENT '保存名称',
|
||
`smallpath` varchar(255) DEFAULT NULL COMMENT '缩略图路径',
|
||
`filepath` varchar(255) NOT NULL COMMENT '完整的路径',
|
||
`savepath` varchar(255) NOT NULL DEFAULT '' COMMENT '文件保存路径',
|
||
`ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀',
|
||
`mime` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型',
|
||
`size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
|
||
`md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
|
||
`sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
|
||
`location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置',
|
||
`create_time` int(10) unsigned NOT NULL COMMENT '上传时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `uk_md5` (`md5`) USING BTREE
|
||
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='文件表'");
|
||
$this->E_D("replace into `db_file` values('1','1529993393','松鼠.jpg','5b31b892aeb50.jpg','/d/image/20180626/small_5b31b892aeb50.jpg','/d/image/20180626/5b31b892aeb50.jpg','20180626/','jpg','','206280','ff6f15a2bca6c03d89c65baf2d67c2a8','b7e10586582d6eb8bd19b0f7524116855df41c09','0','1529985170');");
|
||
$this->E_D("replace into `db_file` values('2','1529993393','兔子.jpg','5b31b892c6638.jpg','/d/image/20180626/small_5b31b892c6638.jpg','/d/image/20180626/5b31b892c6638.jpg','20180626/','jpg','','364705','9eb20297cdc1e35f965a4d03c9cd7dc6','93b9fca3138ac7e7a218971f4b3888db6b5ded44','0','1529985170');");
|
||
$this->E_D("replace into `db_file` values('3','1556179204','48553a80d60349d7aa469038eb39a3fa_out.pdf','5cf0c2d705c30.pdf','','/d/file/20190531/5cf0c2d705c30.pdf','20190531/','pdf','','195067','6b8877906fb46099324a91e2ba8ef1c5','8d9e8c6351b73cf21d2ce4e0437024d6b870507e','0','1559282391');");
|
||
$this->E_D("replace into `db_file` values('4','1559290646','591bdf7a25f08.mp4','5cf0cdd2a7620.mp4','','/d/video/20190531/5cf0cdd2a7620.mp4','20190531/','mp4','','8457688','b8b57844285f7fdbf33239a92f1d0701','29ba2bfbf670012a8356cab56e29c3b91ceffbe0','0','1559285202');");
|
||
$this->E_D("replace into `db_file` values('5','15646507279237','可爱狗.jpg','5d109d1e1f400.jpg','/d/image/20190624/small_5d109d1e1f400.jpg','/d/image/20190624/5d109d1e1f400.jpg','20190624/','jpg','','217253','ee8cf536926062e4b005fe66a8b68768','4c9ce5d6c52ae9131c043555e83b3e8cab6fe95b','0','1564651190');");
|
||
$this->E_D("replace into `db_file` values('6','1561372143','马（2）.jpg','5d109d2f689d4.jpg','/d/image/20190624/small_5d109d2f689d4.jpg','/d/image/20190624/5d109d2f689d4.jpg','20190624/','jpg','','138722','83b7a0aaefe9a4a08a0ada117c57232a','028c3cf02946b3306adff453738707cf8e4a961c','0','1561369903');");
|
||
$this->E_D("replace into `db_file` values('7','1561372143','php study.pdf','5d109d509d97c.pdf','','/d/file/20190624/5d109d509d97c.pdf','20190624/','pdf','','370149','b2c26952b24fba36850aa32d81ded9d3','c322488edfc51417fa74dd5486c3b7eb1c662d8d','0','1561369936');");
|
||
$this->E_D("replace into `db_file` values('8','1561373407','0b3a07842b08498a8c5843f575b6dd6d.jpg','5d109f3a9e340.jpg','/d/image/20190624/small_5d109f3a9e340.jpg','/d/image/20190624/5d109f3a9e340.jpg','20190624/','jpg','','83334','a1f074a5e7bdbd52977f7cd16c8e8a78','f0a7a081d0c4a23726e6a92135bb90e837b25a7a','0','1561370426');");
|
||
$this->E_D("replace into `db_file` values('9','15646507279237','马.jpg','5d42afa817700.jpg','/d/image/20190801/small_5d42afa817700.jpg','/d/image/20190801/5d42afa817700.jpg','20190801/','jpg','','476666','44f594c5322ddc80789eedc2b8b48564','b0dba389e3dd094774e5c7faf6ff2b1d6e16527f','0','1564651432');");
|
||
$this->E_D("replace into `db_file` values('21','198907164','党建风采-数据导入结构.xls','5d494a3831830.xls','','/d/file/20190806/5d494a3831830.xls','20190806/','xls','','80384','f423021c1a88ea9faf63aa4a0385eedf','6022c8355f110253b757063b7217922079825acf','0','1565084216');");
|
||
$this->E_D("replace into `db_file` values('22','15650842507216','bcfccc7a30d00c0743a744bc010f2b9f4.png','','/d/image/20190806/small_f2be59aa181a632e819ba097d0967f541.png','/d/image/20190806/bcfccc7a30d00c0743a744bc010f2b9f4.png','20190806','png','','43531','c03197e900c2ae16cb10019210be4acc','5b33a9ab55add089dfba43f42c1c2a0550f3fa48','0','1565084250');");
|
||
$this->E_D("replace into `db_file` values('52','15675705019247','timg.jpg','5d6f3a4ae86c0.jpg','/d/image/20190904/small_5d6f3a4ae86c0.jpg','/d/image/20190904/5d6f3a4ae86c0.jpg','20190904/','jpg','','49885','124ac04f532b6bb2ad2cc4f6a2505907','aaa3ccd13faa6767f3b23ee859411af73fdeac41','0','1567570506');");
|
||
$this->E_D("replace into `db_file` values('53','15670805003280',' ','15689504815d8448d18fe585.71504354.jpeg','/d/image/20190920/small_15689504815d8448d18fe585.71504354.jpeg','/d/image/20190920/15689504815d8448d18fe585.71504354.jpeg','','jpeg','','358186','946a5623fb6384fd17f029275ecc8c40','cdda83bc1b261490eb278dd8af969da6451ea8c2','0','1568950481');");
|
||
$this->E_D("replace into `db_file` values('54','15670805003280',' ','15689504825d8448d2600b87.42003647.gif','/d/image/20190920/small_15689504825d8448d2600b87.42003647.gif','/d/image/20190920/15689504825d8448d2600b87.42003647.gif','','gif','','4792696','f919bb0712f6b23f2255d7ec93d9c57d','bc72bda6b1509ab8060a22196cc44362ef627dc9','0','1568950486');");
|
||
$this->E_D("replace into `db_file` values('55','15693032323454','马（2）.jpg','5d89aad56dab0.jpg','/d/image/20190924/small_5d89aad56dab0.jpg','/d/image/20190924/5d89aad56dab0.jpg','20190924/','jpg','','28419','de35eacd13df92eb8806c9b158baf374','0330bc7b874a60a5d5fdc52b8bb022a0d9e234bd','0','1569303253');");
|
||
$this->E_D("replace into `db_file` values('56','15693032323454','马.jpg','5d89aae750dc0.jpg','/d/image/20190924/small_5d89aae750dc0.jpg','/d/image/20190924/5d89aae750dc0.jpg','20190924/','jpg','','59023','30a0e687772e5e505a2c8a64485bf2b8','c7b0ad110dce488dd767665485d76f2e5c16d42e','0','1569303271');");
|
||
$this->E_D("replace into `db_file` values('57','15693032323454','1569303323','15693033255d89ab1d302509.14528804.jpeg','/d/image/20190924/small_15693033255d89ab1d302509.14528804.jpeg','/d/image/20190924/15693033255d89ab1d302509.14528804.jpeg','','jpeg','','385349','742254c66d82ee9051dd1bfc72c3c2eb','aec496ed1574ef2fa0658c81f22b0362321add65','0','1569303325');");
|
||
$this->E_D("replace into `db_file` values('58','15693087298929','O1CN01T9Gzxl1IOugDwXhyh_!!2616970884.jpg_430x430q90.jpg','5d89c059eba50.jpg','/d/image/20190924/small_5d89c059eba50.jpg','/d/image/20190924/5d89c059eba50.jpg','20190924/','jpg','','17756','007c027dbdfde691b431bb2bc00775ba','f9557cb0f6c1750d7874bed436ebcc75781b5c04','0','1569308761');");
|
||
$this->E_D("replace into `db_file` values('59','15693087298929','1569308808','15693088095d89c08929cc07.30001630.jpeg','/d/image/20190924/small_15693088095d89c08929cc07.30001630.jpeg','/d/image/20190924/15693088095d89c08929cc07.30001630.jpeg','','jpeg','','1007000','82f58bdf286f2f51748d086b04a913b4','5a4b0c98f6d229cd435ab7f2c2aed34f0a5e8506','0','1569308809');");
|
||
$this->E_D("replace into `db_file` values('60','15716335419608','微信截图_20191022102709','15717116035dae6a736ca488.13192629.png','/d/image/20191022/small_15717116035dae6a736ca488.13192629.png','/d/image/20191022/15717116035dae6a736ca488.13192629.png','','png','','402366','4901fbea36700821b30c29db8e553ab0','ce03b399f11785306e71d224866a814d2711312a','0','1571711603');");
|
||
$this->E_D("replace into `db_file` values('61','15772660414765','bg13.jpg','5e05a5de756e8.jpg','/d/image/20191227/small_5e05a5de756e8.jpg','/d/image/20191227/5e05a5de756e8.jpg','20191227/','jpg','','23221','13f5a448147dee1891c0af291b8a9cd2','495a8965645c899fd9946d9d9ba164c854fdd1cd','0','1577428446');");
|
||
$this->E_D("replace into `db_file` values('64','15772682703204','name2.jpg','5e1e6af2d7de8.jpg','/d/image/20200115/small_5e1e6af2d7de8.jpg','/d/image/20200115/5e1e6af2d7de8.jpg','20200115/','jpg','','2656','c43f9993f2765e34f9aaa672bbd2fc35','bbd2658845de67f220505db46110605980fdc95d','0','1579052045');");
|
||
$this->E_D("replace into `db_file` values('66','15772682703204','name1.jpg','5e1e6c08396c0.jpg','/d/image/20200115/small_5e1e6c08396c0.jpg','/d/image/20200115/5e1e6c08396c0.jpg','20200115/','jpg','','2656','c43f9993f2765e34f9aaa672bbd2fc35','bbd2658845de67f220505db46110605980fdc95d','0','1579052049');");
|
||
|
||
?>
|