Login   Register  
PHP Classes
elePHPant
Icontem

File: adv_wdt.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 3 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;