File: adv_wdt.sql

Recommend this page to a friend!
  Classes of Tomasz Malewski  >  adv_wdt  >  adv_wdt.sql  >  Download  
File: adv_wdt.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL script to create temporary table
Class: adv_wdt
Track changes of pages in a MySQL database
Author: By
Last change:
Date: 9 years ago
Size: 454 bytes
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `adv_wdt` (
  `URL` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `changed` tinyint(1) NOT NULL,
  `checksum` varchar(32) NOT NULL,
  `length` int(6) NOT NULL,
  `margin` int(2) NOT NULL,
  `create_DT` datetime NOT NULL,
  `update_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mailto` varchar(32) NOT NULL,
  PRIMARY KEY (`URL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

For more information send a message to info at phpclasses dot org.