Login   Register  
PHP Classes
elePHPant
Icontem

File: mysql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 2005-07-29 20:26
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';