Test 123 - История изменений

Sirmax в 13:55, 28 сентября 2012

2012-09-28T13:55:08Z

← Предыдущая		Версия 13:55, 28 сентября 2012
Строка 1:		Строка 1:
		+	[[Категория:Notes]]
		+	[[Категория:Abills]]
	=Тут заметки о переезде.=		=Тут заметки о переезде.=
	==Дополнительные функции==		==Дополнительные функции==

Sirmax: /* view_dhcp_config_authorized_pools_mac */

2011-11-02T16:22:04Z

view_dhcp_config_authorized_pools_mac

← Предыдущая		Версия 16:22, 2 ноября 2011
Строка 171:		Строка 171:
	'__switch__',		'__switch__',
	mac_ntoa(dhcphosts_hosts_new.nas),		mac_ntoa(dhcphosts_hosts_new.nas),
−	'"; default-lease-time ~~300~~; max-lease-time ~~300~~; }') AS pool	+	'"; default-lease-time 36000; max-lease-time 72000; }') AS pool
	FROM		FROM
	( dhcphosts_networks_vlans join dhcphosts_hosts_new on ((dhcphosts_networks_vlans.vlan = dhcphosts_hosts_new.vid))		( dhcphosts_networks_vlans join dhcphosts_hosts_new on ((dhcphosts_networks_vlans.vlan = dhcphosts_hosts_new.vid))
Строка 182:		Строка 182:
	WHERE ( bills.deposit > 0 );		WHERE ( bills.deposit > 0 );
	</PRE>		</PRE>
−

	===view_dhcp_config_authorized_nopay_classes_mac===		===view_dhcp_config_authorized_nopay_classes_mac===

Sirmax: /* view_dhcp_config_generic_classes */

2011-10-29T12:55:17Z

view_dhcp_config_generic_classes

@@ Строка 249: / Строка 249: @@
 ) AS class
 from dhcphosts_networks_vlans;
 </PRE>

Sirmax: /* mac_ntoa */

2011-10-29T12:53:31Z

mac_ntoa

@@ Строка 25: / Строка 25: @@
 INTO res;
 RETURN res;
 END
 //

Sirmax: /* view_dhcp_config_authorized_nopay_classes_mac */

2011-10-29T12:52:52Z

view_dhcp_config_authorized_nopay_classes_mac

@@ Строка 218: / Строка 218: @@
 bills on ((users.bill_id = bills.id))
 WHERE ( bills.deposit <= 0 );
 </PRE>

Sirmax: /* view_dhcp_config_authorized_nopay_classes_mac */

2011-10-29T12:44:29Z

view_dhcp_config_authorized_nopay_classes_mac

← Предыдущая		Версия 12:44, 29 октября 2011
Строка 214:		Строка 214:
	dhcphosts_networks on (dhcphosts_networks.id = dhcphosts_networks_vlans.id ))		dhcphosts_networks on (dhcphosts_networks.id = dhcphosts_networks_vlans.id ))
	join		join
−	users on((users.uid = ~~dhcphosts_hosts~~.uid))	+	users on((users.uid = dhcphosts_hosts_new.uid))
	join		join
	bills on ((users.bill_id = bills.id))		bills on ((users.bill_id = bills.id))

Sirmax: /* view_dhcp_config_authorized_nopay_classes_mac */

2011-10-29T12:43:31Z

view_dhcp_config_authorized_nopay_classes_mac

← Предыдущая		Версия 12:43, 29 октября 2011
Строка 175:		Строка 175:
	CREATE VIEW view_dhcp_config_authorized_nopay_classes_mac		CREATE VIEW view_dhcp_config_authorized_nopay_classes_mac
	AS		AS
		+	SELECT
−	select
	dhcphosts_networks.id AS network,		dhcphosts_networks.id AS network,
−	inet_ntoa(~~dhcphosts_hosts~~.ip) AS ip,	+	inet_ntoa(dhcphosts_hosts_new.ip) AS ip,
	dhcphosts_networks_vlans.vlan AS vlan,		dhcphosts_networks_vlans.vlan AS vlan,
−	~~dhcphosts_hosts~~.mac AS mac,	+	dhcphosts_hosts_new.mac AS mac,
−	~~dhcphosts_hosts~~.ports AS port,	+	dhcphosts_hosts_new.ports AS port,
−	mac_ntoa(~~dhcphosts_hosts~~.nas) AS switch,	+	mac_ntoa(dhcphosts_hosts_new.nas) AS switch,
	concat(		concat(
	'match_vlan__',		'match_vlan__',
	dhcphosts_networks_vlans.vlan,		dhcphosts_networks_vlans.vlan,
	'__port__',		'__port__',
−	~~dhcphosts_hosts~~.ports,	+	dhcphosts_hosts_new.ports,
	'__MAC__',		'__MAC__',
−	~~dhcphosts_hosts~~.mac,	+	dhcphosts_hosts_new.mac,
	'__switch__',		'__switch__',
−	mac_ntoa(~~dhcphosts_hosts~~.nas)) AS classname,	+	mac_ntoa(dhcphosts_hosts_new.nas)) AS classname,
	concat(		concat(
	'class "match_vlan__',		'class "match_vlan__',
	dhcphosts_networks_vlans.vlan,		dhcphosts_networks_vlans.vlan,
	'__port__',		'__port__',
−	~~dhcphosts_hosts~~.ports,	+	dhcphosts_hosts_new.ports,
−	'__MAC__',~~dhcphosts_hosts~~.mac,	+	'__MAC__',dhcphosts_hosts_new.mac,
	'__switch__',		'__switch__',
−	mac_ntoa(~~dhcphosts_hosts~~.nas),	+	mac_ntoa(dhcphosts_hosts_new.nas),
	'" { match if ( binary-to-ascii(10, 16, "", substring(option agent.circuit-id, 2, 2)) = "',		'" { match if ( binary-to-ascii(10, 16, "", substring(option agent.circuit-id, 2, 2)) = "',
	dhcphosts_networks_vlans.vlan,		dhcphosts_networks_vlans.vlan,
	'" and binary-to-ascii(10, 8, "", substring(option agent.circuit-id, 5, 1)) = "',		'" and binary-to-ascii(10, 8, "", substring(option agent.circuit-id, 5, 1)) = "',
−	~~dhcphosts_hosts~~.ports,	+	dhcphosts_hosts_new.ports,
	'" and binary-to-ascii(16, 8, ":", substring(hardware, 1, 6)) = "',		'" and binary-to-ascii(16, 8, ":", substring(hardware, 1, 6)) = "',
−	~~dhcphosts_hosts~~.mac,	+	dhcphosts_hosts_new.mac,
	'" and binary-to-ascii(16, 8, ":",substring(option agent.remote-id, 2, 15)) = "',		'" and binary-to-ascii(16, 8, ":",substring(option agent.remote-id, 2, 15)) = "',
−	mac_ntoa(`~~dhcphosts_hosts~~`.`nas`),	+	mac_ntoa(`dhcphosts_hosts_new`.`nas`),
	_utf8'" );}')		_utf8'" );}')
	AS class		AS class
	FROM		FROM
−	( dhcphosts_networks_vlans join ~~dhcphosts_hosts~~ on ((dhcphosts_networks_vlans.vlan = ~~dhcphosts_hosts~~.vid))	+	( dhcphosts_networks_vlans join dhcphosts_hosts_new on ((dhcphosts_networks_vlans.vlan = dhcphosts_hosts_new.vid))
	join		join
	dhcphosts_networks on (dhcphosts_networks.id = dhcphosts_networks_vlans.id ))		dhcphosts_networks on (dhcphosts_networks.id = dhcphosts_networks_vlans.id ))

Sirmax: /* view_dhcp_config_authorized_pools_mac */

2011-10-29T12:42:06Z

view_dhcp_config_authorized_pools_mac

@@ Строка 167: / Строка 167: @@
 bills on ((users.bill_id = bills.id))
 WHERE ( bills.deposit > 0 );
 </PRE>

Sirmax: /* view_dhcp_config_authorized_pools */

2011-10-29T12:39:24Z

view_dhcp_config_authorized_pools

@@ Строка 134: / Строка 134: @@
 </PRE>
 <PRE>
 DROP VIEW view_dhcp_config_authorized_pools_mac;

Sirmax: /* view_dhcp_config_authorized_pools */

2011-10-29T12:38:51Z

view_dhcp_config_authorized_pools

@@ Строка 157: / Строка 157: @@
 '__switch__',inet_ntoa(dhcphosts_hosts_new.nas),
 '"; default-lease-time 600; max-lease-time 1200; }') AS pool
 FROM
 ( dhcphosts_networks_vlans join dhcphosts_hosts_new on ((dhcphosts_networks_vlans.vlan = dhcphosts_hosts_new.vid))