Propozycja zmiany tabelki networks
Witam, wdrażam q-in-q, problem polega na tym....
CREATE TABLE networks ( id integer NOT NULL DEFAULT nextval(('networks_id_seq':: text)::regclass), name character varying(255) NOT NULL DEFAULT ''::character varying, address bigint NOT NULL DEFAULT 0, mask character varying(16) NOT NULL DEFAULT ''::character varying, *interface character varying(16) NOT NULL DEFAULT ''::character varying,* gateway character varying(16) NOT NULL DEFAULT ''::character varying, dns character varying(16) NOT NULL DEFAULT ''::character varying, dns2 character varying(16) NOT NULL DEFAULT ''::character varying, domain character varying(64) NOT NULL DEFAULT ''::character varying, wins character varying(16) NOT NULL DEFAULT ''::character varying, dhcpstart character varying(16) NOT NULL DEFAULT ''::character varying, dhcpend character varying(16) NOT NULL DEFAULT ''::character varying, disabled smallint NOT NULL DEFAULT 0, notes text NOT NULL DEFAULT ''::text, CONSTRAINT networks_pkey PRIMARY KEY (id), CONSTRAINT networks_address_key UNIQUE (address), CONSTRAINT networks_name_key UNIQUE (name) )
chce tam zapisać wartość "bge1:vlan1703:vlan104" - czyli 21 znaków
Proponuje rozszerzyć pole do *varying(25)
*Pozdrawiam Miłosz
uczestnicy (1)
-
Miłosz