31 lines
1.1 KiB
SQL
31 lines
1.1 KiB
SQL
use amh;
|
|
CREATE TABLE IF NOT EXISTS `module_hyproxy` (
|
|
`hyproxy_id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`server_name` varchar(255) NOT NULL,
|
|
`index` varchar(255) NOT NULL,
|
|
`header_host` varchar(255) NOT NULL,
|
|
`proxy_pass` varchar(255) NOT NULL,
|
|
`proxy_cache` int(1) NOT NULL,
|
|
`status` varchar(16) NOT NULL,
|
|
`time` int(10) NOT NULL,
|
|
PRIMARY KEY (`hyproxy_id`),
|
|
UNIQUE KEY `server_name` (`server_name`),
|
|
KEY `proxy_pass` (`proxy_pass`),
|
|
KEY `status` (`status`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
|
|
|
|
CREATE TABLE IF NOT EXISTS `module_hyproxy_cache` (
|
|
`hyproxy_id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`hyproxy_file` varchar(45) NOT NULL,
|
|
`hyproxy_key` varchar(300) NOT NULL,
|
|
`hyproxy_http_s` varchar(5) NOT NULL,
|
|
`hyproxy_type` varchar(30) NOT NULL,
|
|
`hyproxy_size` varchar(10) NOT NULL,
|
|
`hyproxy_time` datetime NOT NULL,
|
|
PRIMARY KEY (`hyproxy_id`),
|
|
UNIQUE KEY `file` (`hyproxy_file`),
|
|
KEY `key` (`hyproxy_key`),
|
|
KEY `http_s` (`hyproxy_http_s`),
|
|
KEY `type` (`hyproxy_type`),
|
|
KEY `size` (`hyproxy_size`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |