PHP Classes

File: mysql.sql

Recommend this page to a friend!
  Classes of YP   Proxier   mysql.sql   Download  
File: mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: db table
Class: Proxier
Retrieve proxy lists and store them in a database
Author: By
Last change: Fixed a bug in table creatin query
Date: 18 years ago
Size: 891 bytes
 

Contents

Class file image Download
CREATE TABLE `wf_proxier` ( `ip` varchar(15) NOT NULL default '', `port` int(6) unsigned NOT NULL default '0', `type` enum('0','1','2') NOT NULL default '0', `status` enum('0','1') default NULL, `active` enum('0','1') NOT NULL default '0', `time_added` int(11) unsigned NOT NULL default '0', `time_checked` int(11) unsigned NOT NULL default '0', `time_used` int(11) unsigned default NULL, `speed` float default NULL, UNIQUE KEY `ip` (`ip`), KEY `type` (`type`), KEY `time_used` (`time_used`), KEY `speed` (`speed`), KEY `active` (`active`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; INSERT `wf_proxier` SET `ip`='last_list', `status`='0';