PHP Classes

File: create_db.sql

Recommend this page to a friend!
  Classes of Dmitry Stroganov   PHP File Change Scanner   create_db.sql   Download  
File: create_db.sql
Role: Auxiliary data
Content type: text/plain
Description: Script to create mysql db and table
Class: PHP File Change Scanner
Scan directories to detect modified files
Author: By
Last change:
Date: 8 years ago
Size: 923 bytes


Class file image Download
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 utf8 */; -- -- Database: `scanner` -- CREATE DATABASE IF NOT EXISTS `scanner` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `scanner`; -- -------------------------------------------------------- -- -- Table structure for table `scanner` -- CREATE TABLE IF NOT EXISTS `scanner` ( `path` text NOT NULL, `date` int(11) NOT NULL, `hash` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!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 */;