PHP Classes

File: examples/assets/scan.sql

Recommend this page to a friend!
  Classes of Johnny Mast   Redbox PHP Scandir Filter   examples/assets/scan.sql   Download  
File: examples/assets/scan.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Redbox PHP Scandir Filter
Scan files for new or modified files
Author: By
Last change:
Date: 8 years ago
Size: 2,120 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.4.10 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Dec 22, 2015 at 09:33 PM -- Server version: 5.5.42 -- PHP Version: 5.6.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `scan` -- -- -------------------------------------------------------- -- -- Table structure for table `scan` -- CREATE TABLE `scan` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `path` varchar(255) NOT NULL, `scandate` datetime NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `scan` -- INSERT INTO `scan` (`id`, `name`, `path`, `scandate`) VALUES (1, 'a scan', '/Users/johnny/Dropbox/Sites/Redbox/scan/redbox-scan/examples/assets', '2015-12-22 21:29:48'); -- -------------------------------------------------------- -- -- Table structure for table `scanitems` -- CREATE TABLE `scanitems` ( `id` int(11) NOT NULL, `scanid` int(11) NOT NULL, `itemfolder` varchar(255) NOT NULL, `itemname` varchar(255) NOT NULL, `md5hash` varchar(255) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=7131 DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `scan` -- ALTER TABLE `scan` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`); -- -- Indexes for table `scanitems` -- ALTER TABLE `scanitems` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `scan` -- ALTER TABLE `scan` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `scanitems` -- ALTER TABLE `scanitems` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7131; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;