CREATE OR REPLACE VIEW network_client AS
 SELECT full_network_client.id_nc, full_network_client.ip, full_network_client.name, full_network_client.secret, full_network_client.enforced, full_network_client.domain, full_network_client.creation
   FROM full_network_client
  WHERE full_network_client.deleted = false AND full_network_client.id_nc > 0;

ALTER TABLE network_client OWNER TO postgres;
GRANT ALL ON TABLE network_client TO postgres;
GRANT ALL ON TABLE network_client TO "wikid-sens";
GRANT ALL ON TABLE network_client TO timecop;

ALTER TABLE network_client ALTER COLUMN id_nc SET DEFAULT nextval(('"network_client_id_nc_seq"'::text)::regclass);
ALTER TABLE network_client ALTER COLUMN creation SET DEFAULT now();


-- Rule: network_client_delete_rule ON network_client

-- DROP RULE network_client_delete_rule ON network_client;

CREATE OR REPLACE RULE network_client_delete_rule AS
    ON DELETE TO network_client DO INSTEAD  UPDATE full_network_client SET deleted = true
  WHERE full_network_client.id_nc = old.id_nc;

-- Rule: network_client_insert_rule ON network_client

-- DROP RULE network_client_insert_rule ON network_client;

CREATE OR REPLACE RULE network_client_insert_rule AS
    ON INSERT TO network_client DO INSTEAD  INSERT INTO full_network_client (id_nc, ip, name, secret, enforced, domain, creation, deleted)
  VALUES (new.id_nc, new.ip, new.name, new.secret, new.enforced, new.domain, new.creation, false);

-- Rule: network_client_update_rule ON network_client

-- DROP RULE network_client_update_rule ON network_client;

CREATE OR REPLACE RULE network_client_update_rule AS
    ON UPDATE TO network_client DO INSTEAD  UPDATE full_network_client SET id_nc = new.id_nc, ip = new.ip, name = new.name, secret = new.secret, enforced = new.enforced, domain = new.domain, creation = new.creation
  WHERE full_network_client.id_nc = old.id_nc;