Allow same MAC addresses in different networks

[sebschrader]

Currently duplicate MAC addresses for dhcphost are rejected:

hades/templates/schema.sql.j2

Line 283 in 8fb471c

CREATE MATERIALIZED VIEW dhcphost AS

It seems, that dnsmasq is fine with duplicate MAC addresses, as long as they are in different subnets:

https://github.com/dnsmasq/dnsmasq/blob/ce5732e84fc46d7f99c152f736cfb4ef5ec98a01/src/dhcp-common.c#L292

If that's the case, we should allow that, because duplicate MAC addresses can happen, if users move.

[sebschrader]

Fixed in 2ec2219

[lukasjuhrich]

Not quite fixed:

hades/templates/schema.sql.j2

Lines 792 to 796 in 2ec2219

	--
	-- Name: auth_dhcp_host_MAC_idx; Type: INDEX; Schema: public; Owner: {{ constants.DATABASE_USER }}
	--
	CREATE UNIQUE INDEX "auth_dhcp_host_MAC_idx" ON auth_dhcp_host USING btree ("MAC");

This index still prevents multiple MAC addresses.