--
-- Selected TOC Entries:
--
DROP INDEX stage_route_permission_key;
DROP INDEX stage_route_id_key;
DROP INDEX ls_document_stag_permission_key;
DROP INDEX register_product_key;
DROP INDEX bodymore_id_key;
DROP INDEX ls_document_id_key;
DROP INDEX serialnum_numbers_key;
DROP INDEX serialnum_product_key;
DROP INDEX serialnum_deleted_key;
DROP INDEX serialnum_id_key;
DROP INDEX ls_register_permission_key;
DROP INDEX docisp_body_key;
DROP INDEX docisp_id_key;
DROP INDEX preference_nameuser_key;
DROP INDEX preference_id_key;
DROP INDEX class_deleted_key;
DROP INDEX class_id_key;
DROP INDEX product_class_key;
DROP INDEX product_deleted_key;
DROP INDEX product_id_key;
DROP INDEX file_productid_key;
DROP INDEX file_id_key;
DROP INDEX register_type_key;
DROP INDEX register_id_key;
DROP INDEX docdepart_document_key;
DROP INDEX queue_body_key;
DROP INDEX documentlink2_key;
DROP INDEX documentlink1_key;
DROP INDEX preserve_body_key;
DROP INDEX preserve_product_key;
DROP INDEX preserve_id_key;
DROP INDEX deficit_idpr_key;
DROP INDEX deficit_body_key;
DROP INDEX deficit_id_key;
DROP INDEX body_document_key;
DROP INDEX body_deleted_key;
DROP INDEX body_id_key;
DROP INDEX document_id_key;
DROP INDEX document_insdate_key;
DROP INDEX document_number_key;
DROP INDEX document_typeflag_key;
DROP INDEX document_type_key;
DROP INDEX document_closed_key;
DROP INDEX document_deleted_key;
DROP INDEX permission_passwdlsperm_key;
DROP INDEX permission_passwd_key;
DROP INDEX passwd_lp_key;
DROP INDEX passwd_deleted_key;
DROP INDEX passwd_id_key;
DROP INDEX moving_productdoc_key;
DROP INDEX moving_id_key;
DROP INDEX agent_deleted_key;
DROP INDEX agent_id_key;
DROP INDEX ls_target_id_key;
DROP INDEX ls_result_deleted_key;
DROP INDEX spec_deleted_key;
DROP INDEX spec_id_key;
DROP INDEX ls_deficit_id_key;
DROP INDEX presence_productisp_key;
DROP INDEX measure_id_key;
DROP TABLE ls_permission;
DROP TABLE stage_route;
DROP SEQUENCE stage_route_id_seq;
DROP TABLE ls_document_stage;
DROP VIEW specify;
DROP TABLE bodymore;
DROP TABLE ls_razdel;
DROP TABLE ls_document;
DROP SEQUENCE ls_document_id_seq;
DROP TABLE serialnum;
DROP SEQUENCE serialnum_id_seq;
DROP TABLE ls_register;
DROP TABLE docisp;
DROP TABLE preference;
DROP SEQUENCE preference_id_seq;
DROP TABLE class;
DROP SEQUENCE class_id_seq;
DROP TABLE product;
DROP SEQUENCE product_id_seq;
DROP TABLE docmore;
DROP TABLE file;
DROP SEQUENCE file_id_seq;
DROP TABLE register;
DROP SEQUENCE register_id_seq;
DROP TABLE docdepart;
DROP TABLE queue;
DROP TABLE documentlink;
DROP TABLE preserve;
DROP TABLE deficit;
DROP TABLE body;
DROP SEQUENCE body_id_seq;
DROP SEQUENCE spis_seq;
DROP SEQUENCE reclam_seq;
DROP SEQUENCE order_seq;
DROP SEQUENCE deficit5_seq;
DROP SEQUENCE deficit4_seq;
DROP SEQUENCE deficit3_seq;
DROP SEQUENCE deficit2_seq;
DROP SEQUENCE deficit1_seq;
DROP SEQUENCE deficit0_seq;
DROP SEQUENCE rasxod_seq;
DROP SEQUENCE prixod_seq;
DROP TABLE document;
DROP SEQUENCE document_id_seq;
DROP TABLE permission;
DROP TABLE passwd;
DROP SEQUENCE passwd_id_seq;
DROP TABLE moving;
DROP SEQUENCE moving_id_seq;
DROP FUNCTION presence_update ();
DROP PROCEDURAL LANGUAGE 'plpgsql';
DROP FUNCTION plpgsql_call_handler ();
DROP VIEW recipient;
DROP VIEW supplier;
DROP TABLE agent;
DROP SEQUENCE agent_id_seq;
DROP TABLE ls_target;
DROP SEQUENCE ls_target_id_seq;
DROP TABLE ls_result;
DROP TABLE spec;
DROP TABLE ls_deficit;
DROP TABLE presence;
DROP TABLE measure;
DROP SEQUENCE ls_deficit_id_seq;
DROP SEQUENCE measure_id_seq;
--
-- TOC Entry ID 2 (OID 63276)
--
-- Name: measure_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE measure_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 4 (OID 63278)
--
-- Name: ls_deficit_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE ls_deficit_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 67 (OID 63280)
--
-- Name: measure Type: TABLE Owner: keeper
--

CREATE TABLE measure (
	id integer DEFAULT nextval('measure_id_seq'::text) NOT NULL,
	name text,
	integer boolean DEFAULT 't'::bool
);

--
-- TOC Entry ID 68 (OID 63280)
--
-- Name: measure Type: ACL Owner: 
--

REVOKE ALL on measure from PUBLIC;
GRANT ALL on measure to keeper;
GRANT SELECT on measure to customer;

--
-- TOC Entry ID 70 (OID 63285)
--
-- Name: presence Type: TABLE Owner: keeper
--

CREATE TABLE presence (
	insdate bigint,
	product integer NOT NULL,
	price numeric(9,2) DEFAULT 0,
	qty real DEFAULT 0,
	isp character(2)
);

--
-- TOC Entry ID 71 (OID 63285)
--
-- Name: presence Type: ACL Owner: 
--

REVOKE ALL on presence from PUBLIC;
GRANT ALL on presence to keeper;
GRANT SELECT on presence to customer;

--
-- TOC Entry ID 73 (OID 63287)
--
-- Name: ls_deficit Type: TABLE Owner: keeper
--

CREATE TABLE ls_deficit (
	id integer DEFAULT nextval('ls_deficit_id_seq'::text) NOT NULL,
	name text
);

--
-- TOC Entry ID 74 (OID 63287)
--
-- Name: ls_deficit Type: ACL Owner: 
--

REVOKE ALL on ls_deficit from PUBLIC;
GRANT ALL on ls_deficit to keeper;
GRANT SELECT on ls_deficit to customer;

--
-- TOC Entry ID 76 (OID 63292)
--
-- Name: spec Type: TABLE Owner: keeper
--

CREATE TABLE spec (
	id integer,
	component integer,
	qty real,
	note text,
	deleted boolean DEFAULT 'f'::bool,
	push integer,
	pop integer,
	isp character(2),
	razdel integer,
	ispcom character(2),
	pos integer,
	is_complect boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 77 (OID 63292)
--
-- Name: spec Type: ACL Owner: 
--

REVOKE ALL on spec from PUBLIC;
GRANT ALL on spec to keeper;
GRANT SELECT on spec to customer;

--
-- TOC Entry ID 79 (OID 63297)
--
-- Name: ls_result Type: TABLE Owner: keeper
--

CREATE TABLE ls_result (
	id integer,
	name text,
	deleted boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 80 (OID 63297)
--
-- Name: ls_result Type: ACL Owner: 
--

REVOKE ALL on ls_result from PUBLIC;
GRANT ALL on ls_result to keeper;
GRANT SELECT on ls_result to customer;

--
-- TOC Entry ID 6 (OID 63302)
--
-- Name: ls_target_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE ls_target_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 82 (OID 63304)
--
-- Name: ls_target Type: TABLE Owner: keeper
--

CREATE TABLE ls_target (
	id integer DEFAULT nextval('"ls_target_id_seq"'::text) NOT NULL,
	name text
);

--
-- TOC Entry ID 83 (OID 63304)
--
-- Name: ls_target Type: ACL Owner: 
--

REVOKE ALL on ls_target from PUBLIC;
GRANT ALL on ls_target to keeper;
GRANT SELECT on ls_target to customer;

--
-- TOC Entry ID 8 (OID 63309)
--
-- Name: agent_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE agent_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 85 (OID 63311)
--
-- Name: agent Type: TABLE Owner: keeper
--

CREATE TABLE agent (
	id integer DEFAULT nextval('"agent_id_seq"'::text) NOT NULL,
	insdate bigint,
	name text,
	tel text,
	city text,
	address text,
	data text,
	recipient boolean DEFAULT 'f'::bool,
	deleted boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 86 (OID 63311)
--
-- Name: agent Type: ACL Owner: 
--

REVOKE ALL on agent from PUBLIC;
GRANT ALL on agent to keeper;
GRANT SELECT on agent to customer;

--
-- TOC Entry ID 88 (OID 63318)
--
-- Name: supplier Type: VIEW Owner: keeper
--

CREATE VIEW supplier as SELECT agent.id, agent.insdate, agent.name, agent.tel, agent.city, agent.address, agent.data FROM agent WHERE ((NOT agent.recipient) AND (NOT agent.deleted));

--
-- TOC Entry ID 89 (OID 63321)
--
-- Name: recipient Type: VIEW Owner: keeper
--

CREATE VIEW recipient as SELECT agent.id, agent.insdate, agent.name, agent.tel, agent.city, agent.address, agent.data FROM agent WHERE (agent.recipient AND (NOT agent.deleted));

--
-- TOC Entry ID 226 (OID 63322)
--
-- Name: plpgsql_call_handler () Type: FUNCTION Owner: keeper
--

CREATE FUNCTION plpgsql_call_handler () RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';

--
-- TOC Entry ID 227 (OID 63323)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL';

--
-- TOC Entry ID 228 (OID 63324)
--
-- Name: presence_update () Type: FUNCTION Owner: keeper
--

CREATE FUNCTION presence_update () RETURNS opaque AS '
declare
-- prec   record;
begin

 if new.product isnull then
  raise exception ''  '';
 end if;

 if new.product < 0 then
  raise exception ''  (%)     '', new.product;
 end if;

 if new.qty < 0 then
  raise exception '' (%)     '', new.qty;
 end if;

 if new.price < 0 then
  raise exception ''  (%)     '', new.price;
 end if;

 new.insdate := extract(epoch from timestamp ''now'');
 return new;
end;
' LANGUAGE 'plpgsql';

--
-- TOC Entry ID 10 (OID 63325)
--
-- Name: moving_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE moving_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 90 (OID 63327)
--
-- Name: moving Type: TABLE Owner: keeper
--

CREATE TABLE moving (
	id integer DEFAULT nextval('"moving_id_seq"'::text) NOT NULL,
	product integer,
	isp character(2),
	document integer,
	qty real,
	qtyp real,
	price real,
	note text,
	qtyl real
);

--
-- TOC Entry ID 91 (OID 63327)
--
-- Name: moving Type: ACL Owner: 
--

REVOKE ALL on moving from PUBLIC;
GRANT ALL on moving to keeper;
GRANT SELECT on moving to customer;

--
-- TOC Entry ID 12 (OID 63332)
--
-- Name: passwd_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE passwd_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 93 (OID 63334)
--
-- Name: passwd Type: TABLE Owner: keeper
--

CREATE TABLE passwd (
	id integer DEFAULT nextval('"passwd_id_seq"'::text) NOT NULL,
	name text,
	note text,
	login text,
	passwd text,
	deleted boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 95 (OID 63339)
--
-- Name: permission Type: TABLE Owner: keeper
--

CREATE TABLE permission (
	passwd integer,
	lsperm integer
);

--
-- TOC Entry ID 96 (OID 63339)
--
-- Name: permission Type: ACL Owner: 
--

REVOKE ALL on permission from PUBLIC;
GRANT ALL on permission to keeper;
GRANT SELECT on permission to customer;

--
-- TOC Entry ID 14 (OID 63341)
--
-- Name: document_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE document_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 98 (OID 63343)
--
-- Name: document Type: TABLE Owner: keeper
--

CREATE TABLE document (
	id integer DEFAULT nextval('"document_id_seq"'::text) NOT NULL,
	type integer,
	insdate bigint,
	carrydate bigint,
	proddate bigint,
	closedate bigint,
	closedate2 bigint,
	product integer,
	qty integer,
	recipient integer,
	categ integer,
	operator integer,
	operator2 integer,
	sum numeric(9,2),
	flag integer,
	note text,
	closed boolean DEFAULT 'f'::bool,
	deleted boolean DEFAULT 'f'::bool,
	number integer
);

--
-- TOC Entry ID 99 (OID 63343)
--
-- Name: document Type: ACL Owner: 
--

REVOKE ALL on document from PUBLIC;
GRANT ALL on document to keeper;
GRANT SELECT on document to customer;

--
-- TOC Entry ID 16 (OID 63348)
--
-- Name: prixod_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE prixod_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 19 (OID 63350)
--
-- Name: rasxod_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE rasxod_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 22 (OID 63352)
--
-- Name: deficit0_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit0_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 25 (OID 63354)
--
-- Name: deficit1_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit1_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 28 (OID 63356)
--
-- Name: deficit2_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit2_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 31 (OID 63358)
--
-- Name: deficit3_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit3_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 34 (OID 63360)
--
-- Name: deficit4_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit4_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 37 (OID 63362)
--
-- Name: deficit5_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE deficit5_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 40 (OID 63364)
--
-- Name: order_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE order_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 43 (OID 63366)
--
-- Name: reclam_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE reclam_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 46 (OID 63368)
--
-- Name: spis_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE spis_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 49 (OID 63370)
--
-- Name: body_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE body_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 101 (OID 63372)
--
-- Name: body Type: TABLE Owner: keeper
--

CREATE TABLE body (
	id integer DEFAULT nextval('"body_id_seq"'::text) NOT NULL,
	insdate bigint,
	product integer,
	isp character(2),
	price numeric(9,2),
	qty real,
	qtyr real,
	sum numeric(9,2),
	document integer,
	supplier integer,
	result integer DEFAULT 0,
	razdel integer,
	deleted boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 102 (OID 63372)
--
-- Name: body Type: ACL Owner: 
--

REVOKE ALL on body from PUBLIC;
GRANT ALL on body to keeper;
GRANT SELECT on body to customer;

--
-- TOC Entry ID 104 (OID 63374)
--
-- Name: deficit Type: TABLE Owner: keeper
--

CREATE TABLE deficit (
	id integer,
	product integer,
	isp character(2),
	qty real,
	reserve real DEFAULT 0,
	insdate bigint,
	body integer
);

--
-- TOC Entry ID 105 (OID 63374)
--
-- Name: deficit Type: ACL Owner: 
--

REVOKE ALL on deficit from PUBLIC;
GRANT ALL on deficit to keeper;
GRANT SELECT on deficit to customer;

--
-- TOC Entry ID 107 (OID 63376)
--
-- Name: preserve Type: TABLE Owner: keeper
--

CREATE TABLE preserve (
	insdate bigint,
	id integer,
	product integer,
	isp character(2),
	qty real,
	checked boolean DEFAULT 'f'::bool,
	body integer
);

--
-- TOC Entry ID 108 (OID 63376)
--
-- Name: preserve Type: ACL Owner: 
--

REVOKE ALL on preserve from PUBLIC;
GRANT ALL on preserve to keeper;
GRANT SELECT on preserve to customer;

--
-- TOC Entry ID 110 (OID 63378)
--
-- Name: documentlink Type: TABLE Owner: keeper
--

CREATE TABLE documentlink (
	document1 integer,
	document2 integer,
	operator integer,
	insdate bigint,
	product integer,
	qty real,
	sum numeric(9,2)
);

--
-- TOC Entry ID 111 (OID 63378)
--
-- Name: documentlink Type: ACL Owner: 
--

REVOKE ALL on documentlink from PUBLIC;
GRANT ALL on documentlink to keeper;
GRANT SELECT on documentlink to customer;

--
-- TOC Entry ID 113 (OID 63380)
--
-- Name: queue Type: TABLE Owner: keeper
--

CREATE TABLE queue (
	body integer,
	queue text
);

--
-- TOC Entry ID 114 (OID 63380)
--
-- Name: queue Type: ACL Owner: 
--

REVOKE ALL on queue from PUBLIC;
GRANT ALL on queue to keeper;
GRANT SELECT on queue to customer;

--
-- TOC Entry ID 116 (OID 63385)
--
-- Name: docdepart Type: TABLE Owner: keeper
--

CREATE TABLE docdepart (
	document integer,
	otd integer
);

--
-- TOC Entry ID 117 (OID 63385)
--
-- Name: docdepart Type: ACL Owner: 
--

REVOKE ALL on docdepart from PUBLIC;
GRANT ALL on docdepart to keeper;
GRANT SELECT on docdepart to customer;

--
-- TOC Entry ID 51 (OID 63387)
--
-- Name: register_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE register_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 119 (OID 63389)
--
-- Name: register Type: TABLE Owner: keeper
--

CREATE TABLE register (
	id integer DEFAULT nextval('"register_id_seq"'::text) NOT NULL,
	type integer,
	insdate bigint,
	product integer,
	qty real,
	document integer,
	recipient integer,
	operator integer,
	target integer,
	isp character(2)
);

--
-- TOC Entry ID 120 (OID 63389)
--
-- Name: register Type: ACL Owner: 
--

REVOKE ALL on register from PUBLIC;
GRANT ALL on register to keeper;
GRANT SELECT on register to customer;

--
-- TOC Entry ID 53 (OID 63391)
--
-- Name: file_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE file_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 122 (OID 63393)
--
-- Name: file Type: TABLE Owner: keeper
--

CREATE TABLE file (
	id integer DEFAULT nextval('"file_id_seq"'::text) NOT NULL,
	passwd integer NOT NULL,
	product integer NOT NULL,
	qty real NOT NULL,
	insdate bigint,
	target integer,
	document integer,
	isp character(2)
);

--
-- TOC Entry ID 123 (OID 63393)
--
-- Name: file Type: ACL Owner: 
--

REVOKE ALL on file from PUBLIC;
GRANT ALL on file to keeper;
GRANT SELECT on file to customer;

--
-- TOC Entry ID 125 (OID 63395)
--
-- Name: docmore Type: TABLE Owner: keeper
--

CREATE TABLE docmore (
	id integer,
	docdef integer,
	doczay integer,
	recipient integer,
	passwd integer,
	target integer,
	client integer
);

--
-- TOC Entry ID 126 (OID 63395)
--
-- Name: docmore Type: ACL Owner: 
--

REVOKE ALL on docmore from PUBLIC;
GRANT ALL on docmore to keeper;
GRANT SELECT on docmore to customer;

--
-- TOC Entry ID 55 (OID 63397)
--
-- Name: product_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE product_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 128 (OID 63399)
--
-- Name: product Type: TABLE Owner: keeper
--

CREATE TABLE product (
	id integer DEFAULT nextval('"product_id_seq"'::text) NOT NULL,
	class integer,
	name text,
	kobm text,
	measure integer DEFAULT 1,
	standard boolean DEFAULT 't'::bool,
	deleted boolean DEFAULT 'f'::bool,
	form character(4),
	prim text
);

--
-- TOC Entry ID 129 (OID 63399)
--
-- Name: product Type: ACL Owner: 
--

REVOKE ALL on product from PUBLIC;
GRANT ALL on product to keeper;
GRANT SELECT on product to customer;

--
-- TOC Entry ID 57 (OID 63404)
--
-- Name: class_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE class_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 131 (OID 63406)
--
-- Name: class Type: TABLE Owner: keeper
--

CREATE TABLE class (
	id integer DEFAULT nextval('class_id_seq'::text) NOT NULL,
	super integer,
	name text,
	deleted boolean DEFAULT 'f'::bool,
	noclass boolean DEFAULT 'f'::bool,
	noproduct boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 132 (OID 63406)
--
-- Name: class Type: ACL Owner: 
--

REVOKE ALL on class from PUBLIC;
GRANT ALL on class to keeper;
GRANT SELECT on class to customer;

--
-- TOC Entry ID 59 (OID 63414)
--
-- Name: preference_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE preference_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 134 (OID 63416)
--
-- Name: preference Type: TABLE Owner: keeper
--

CREATE TABLE preference (
	id integer DEFAULT nextval('"preference_id_seq"'::text) NOT NULL,
	userid integer,
	insdate bigint,
	name text,
	value text
);

--
-- TOC Entry ID 135 (OID 63416)
--
-- Name: preference Type: ACL Owner: 
--

REVOKE ALL on preference from PUBLIC;
GRANT ALL on preference to keeper;
GRANT SELECT on preference to customer;

--
-- TOC Entry ID 137 (OID 63421)
--
-- Name: docisp Type: TABLE Owner: keeper
--

CREATE TABLE docisp (
	id integer,
	body integer,
	isp character(2)
);

--
-- TOC Entry ID 138 (OID 63421)
--
-- Name: docisp Type: ACL Owner: 
--

REVOKE ALL on docisp from PUBLIC;
GRANT ALL on docisp to keeper;
GRANT SELECT on docisp to customer;

--
-- TOC Entry ID 140 (OID 63423)
--
-- Name: ls_register Type: TABLE Owner: keeper
--

CREATE TABLE ls_register (
	id integer NOT NULL,
	name text,
	permission integer,
	otd text,
	Constraint ls_register_pkey Primary Key (id)
);

--
-- TOC Entry ID 141 (OID 63423)
--
-- Name: ls_register Type: ACL Owner: 
--

REVOKE ALL on ls_register from PUBLIC;
GRANT ALL on ls_register to keeper;
GRANT SELECT on ls_register to customer;

--
-- TOC Entry ID 61 (OID 63429)
--
-- Name: serialnum_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE serialnum_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 143 (OID 63431)
--
-- Name: serialnum Type: TABLE Owner: keeper
--

CREATE TABLE serialnum (
	id integer DEFAULT nextval('"serialnum_id_seq"'::text) NOT NULL,
	product integer,
	isp character(2),
	serialnum text,
	invnum text,
	body integer,
	note text,
	deleted boolean DEFAULT 'f'::bool
);

--
-- TOC Entry ID 144 (OID 63431)
--
-- Name: serialnum Type: ACL Owner: 
--

REVOKE ALL on serialnum from PUBLIC;
GRANT ALL on serialnum to keeper;
GRANT SELECT on serialnum to customer;

--
-- TOC Entry ID 63 (OID 63436)
--
-- Name: ls_document_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE ls_document_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

--
-- TOC Entry ID 146 (OID 63438)
--
-- Name: ls_document Type: TABLE Owner: keeper
--

CREATE TABLE ls_document (
	id integer DEFAULT nextval('"ls_document_id_seq"'::text) NOT NULL,
	name text,
	title text,
	color text
);

--
-- TOC Entry ID 147 (OID 63438)
--
-- Name: ls_document Type: ACL Owner: 
--

REVOKE ALL on ls_document from PUBLIC;
GRANT ALL on ls_document to keeper;
GRANT SELECT on ls_document to customer;

--
-- TOC Entry ID 149 (OID 64234)
--
-- Name: ls_razdel Type: TABLE Owner: keeper
--

CREATE TABLE ls_razdel (
	id integer NOT NULL,
	name text,
	Constraint ls_razdel_pkey Primary Key (id)
);

--
-- TOC Entry ID 150 (OID 64234)
--
-- Name: ls_razdel Type: ACL Owner: 
--

REVOKE ALL on ls_razdel from PUBLIC;
GRANT ALL on ls_razdel to keeper;
GRANT SELECT on ls_razdel to customer;

--
-- TOC Entry ID 152 (OID 64248)
--
-- Name: bodymore Type: TABLE Owner: keeper
--

CREATE TABLE bodymore (
	id integer,
	insdate timestamp with time zone DEFAULT 'now',
	type integer,
	flag integer,
	operator integer,
	comment text,
	qty real,
	state integer
);

--
-- TOC Entry ID 153 (OID 64248)
--
-- Name: bodymore Type: ACL Owner: 
--

REVOKE ALL on bodymore from PUBLIC;
GRANT ALL on bodymore to keeper;
GRANT SELECT on bodymore to customer;

--
-- TOC Entry ID 155 (OID 425868)
--
-- Name: specify Type: VIEW Owner: keeper
--

CREATE VIEW specify as SELECT b.id, b.component, a.name, a.kobm, b.qty, m.name AS measure, b.note, b.deleted, a.standard, b.push, b.pop, b.isp, b.razdel, b.ispcom, b.pos, b.is_complect FROM product a, spec b, measure m WHERE ((a.id = b.component) AND (m.id = a.measure));

--
-- TOC Entry ID 156 (OID 425868)
--
-- Name: specify Type: ACL Owner: 
--

REVOKE ALL on specify from PUBLIC;
GRANT ALL on specify to keeper;
GRANT SELECT on specify to customer;

--
-- TOC Entry ID 157 (OID 555517)
--
-- Name: ls_document_stage Type: TABLE Owner: keeper
--

CREATE TABLE ls_document_stage (
	type integer NOT NULL,
	flag integer NOT NULL,
	name text,
	short text,
	color text,
	permission integer,
	protected boolean DEFAULT 't'::bool,
	dgroup boolean DEFAULT 't'::bool NOT NULL,
	Constraint type_flag_dgroup Primary Key (type, flag, dgroup)
);

--
-- TOC Entry ID 158 (OID 555517)
--
-- Name: ls_document_stage Type: ACL Owner: 
--

REVOKE ALL on ls_document_stage from PUBLIC;
GRANT ALL on ls_document_stage to keeper;
GRANT SELECT on ls_document_stage to customer;

--
-- TOC Entry ID 65 (OID 555554)
--
-- Name: stage_route_id_seq Type: SEQUENCE Owner: keeper
--

CREATE SEQUENCE stage_route_id_seq start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;

--
-- TOC Entry ID 160 (OID 555556)
--
-- Name: stage_route Type: TABLE Owner: keeper
--

CREATE TABLE stage_route (
	id integer DEFAULT nextval('"stage_route_id_seq"'::text) NOT NULL,
	type1 integer NOT NULL,
	flag1 integer NOT NULL,
	type2 integer NOT NULL,
	flag2 integer NOT NULL,
	name text,
	permission smallint,
	Constraint type12_flag12 Primary Key (type1, flag1, type2, flag2)
);

--
-- TOC Entry ID 161 (OID 555556)
--
-- Name: stage_route Type: ACL Owner: 
--

REVOKE ALL on stage_route from PUBLIC;
GRANT ALL on stage_route to keeper;
GRANT SELECT on stage_route to customer;

--
-- TOC Entry ID 163 (OID 555657)
--
-- Name: ls_permission Type: TABLE Owner: keeper
--

CREATE TABLE ls_permission (
	id integer NOT NULL,
	insdate timestamp with time zone DEFAULT 'now',
	name text,
	Constraint ls_permission_pkey Primary Key (id)
);

--
-- TOC Entry ID 164 (OID 555657)
--
-- Name: ls_permission Type: ACL Owner: 
--

REVOKE ALL on ls_permission from PUBLIC;
GRANT ALL on ls_permission to keeper;
GRANT SELECT on ls_permission to customer;

--
-- Data for TOC Entry ID 229 (OID 63280)
--
-- Name: measure Type: TABLE DATA Owner: keeper
--


COPY measure FROM stdin;
1		t
2		f
3		f
4		f
5	.	f
\.
--
-- Data for TOC Entry ID 230 (OID 63285)
--
-- Name: presence Type: TABLE DATA Owner: keeper
--


COPY presence FROM stdin;
1000541164	175	1.55	0	\N
1000543557	823	0.20	0	\N
1007881706	1323	11869.20	0	\N
1007881706	1274	12091.72	0	\N
1003284020	211	9.48	0	\N
1004699695	1037	5635.20	0	\N
1003284021	256	43.49	0	\N
1004699695	904	9146.82	0	\N
1003284023	241	\N	0	\N
1000449404	635	10.58	0	\N
1004705352	643	0.32	0	\N
1000381002	745	1.60	0	\N
1000381438	523	0.39	0	\N
1000383163	607	1.90	0	\N
1000383210	594	2.02	0	\N
1000383282	511	0.50	0	\N
1000442707	179	8.20	0	\N
1000442739	618	6.90	0	\N
1004614512	891	\N	0	\N
1000444503	210	2.21	0	\N
1004614636	1105	\N	0	\N
1000448395	209	18.00	0	\N
1000360528	634	1.12	0	\N
994305769	265	\N	0	\N
1004937709	682	0.20	0	\N
1004937710	357	0.20	0	\N
1000369143	521	1.98	0	\N
1003284018	297	0.00	0	\N
1004699145	393	3.98	0	\N
1004699145	286	8.00	0	\N
1004699180	787	3.24	0	\N
1004699180	396	20.00	0	\N
1011024792	1269	12288.60	0	\N
1000900466	443	122.00	0	\N
1000900466	544	122.05	0	\N
1000900466	552	215.11	0	\N
1003284018	269	\N	0	\N
1003284018	237	\N	0	\N
1003284018	444	1.17	0	\N
1011452057	1032	0.00	0	\N
1011452057	1239	50.00	9.3	\N
1013844330	1111	0.48	92	\N
\.
--
-- Data for TOC Entry ID 231 (OID 63287)
--
-- Name: ls_deficit Type: TABLE DATA Owner: keeper
--


COPY ls_deficit FROM stdin;
1	0
2	1000
3	2000
4	3000
5	4000
6	5000
\.
--
-- Data for TOC Entry ID 232 (OID 63292)
--
-- Name: spec Type: TABLE DATA Owner: keeper
--


COPY spec FROM stdin;
1525	634	3		f	0	0	* 	15	  	\N	f
1525	179	5		f	\N	\N	* 	15	\N	\N	f
1525	552	1		f	\N	\N	* 	15	\N	\N	f
1525	1111	4		f	\N	\N	* 	14	\N	\N	f
1525	823	4		f	\N	\N	* 	14	\N	\N	f
1525	1032	10		f	\N	\N	* 	14	\N	\N	f
1525	1239	0.35		f	\N	\N	* 	17	\N	\N	f
1525	1527	1		f	\N	\N	* 	11	\N	\N	f
1525	1526	1		f	\N	\N	* 	11	\N	\N	f
1525	444	0.7		f	\N	\N	* 	17	  	\N	f
\.
--
-- Data for TOC Entry ID 233 (OID 63297)
--
-- Name: ls_result Type: TABLE DATA Owner: keeper
--


COPY ls_result FROM stdin;
0	  	f
1		f
2	 	f
\.
--
-- Data for TOC Entry ID 234 (OID 63304)
--
-- Name: ls_target Type: TABLE DATA Owner: keeper
--


COPY ls_target FROM stdin;
1	
2	
3	
4	 
5	 
6	
\.
--
-- Data for TOC Entry ID 235 (OID 63311)
--
-- Name: agent Type: TABLE DATA Owner: keeper
--


COPY agent FROM stdin;
1	967387502	----	---	---	---	\N	f	f
2	969806530	 	999-9999		 , 0	\N	f	f
3	971283792	 				\N	f	f
4	0	 	\N	\N	\N	\N	f	f
\.
--
-- Data for TOC Entry ID 236 (OID 63327)
--
-- Name: moving Type: TABLE DATA Owner: keeper
--


COPY moving FROM stdin;
1	634	  	9	0	0	1.12	\N	\N
2	179	  	9	0	0	8.2	\N	\N
3	552	  	9	0	0	215.11	\N	\N
4	1111	  	9	0	0	0	\N	\N
5	823	  	9	0	0	0.2	\N	\N
6	1032	  	9	0	0	0	\N	\N
7	1239	  	9	10	0	50	\N	\N
8	444	  	9	0	0	1.17	\N	\N
9	1269	  	11	0	0	12288.6	\N	\N
10	1111	  	13	92	8	0.48	\N	\N
\.
--
-- Data for TOC Entry ID 237 (OID 63334)
--
-- Name: passwd Type: TABLE DATA Owner: keeper
--


COPY passwd FROM stdin;
1		  	1	2	f
2			3	4	f
\.
--
-- Data for TOC Entry ID 238 (OID 63339)
--
-- Name: permission Type: TABLE DATA Owner: keeper
--


COPY permission FROM stdin;
1	1
1	2
1	3
1	4
1	5
1	6
1	8
1	9
1	10
1	11
1	91
1	92
1	93
1	94
1	96
1	97
1	102
1	21
1	22
1	23
1	24
1	25
1	26
1	27
1	28
1	101
1	111
1	104
1	105
1	106
1	107
1	110
1	113
1	108
1	109
1	131
1	114
1	115
1	116
1	117
1	119
1	118
1	120
1	124
1	123
1	122
1	121
1	130
1	132
1	201
1	202
1	203
1	204
1	205
1	206
1	207
1	208
1	209
1	212
1	213
1	214
1	216
1	215
1	222
1	223
1	224
1	225
1	226
1	227
1	228
1	217
1	218
1	219
1	220
1	221
1	229
1	211
1	231
1	232
\.
--
-- Data for TOC Entry ID 239 (OID 63343)
--
-- Name: document Type: TABLE DATA Owner: keeper
--


COPY document FROM stdin;
4	4	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	\N	2	 	f	f	\N
5	4	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	\N	5	 	f	f	\N
7	4	1011024628	\N	\N	\N	\N	\N	\N	\N	\N	1	\N	12288.60	1		f	t	\N
9	2	1011452057	\N	\N	\N	\N	1525	2	\N	1	1	\N	\N	1		f	f	1
10	4	1013446601	\N	\N	\N	\N	\N	\N	\N	\N	1	\N	0.00	1		f	t	\N
8	4	1011024792	\N	\N	\N	\N	\N	\N	\N	\N	1	1	12288.60	3	\N	f	f	1
11	3	1013446667	\N	\N	\N	\N	0	0	1	\N	1	1	12288.60	7	\N	f	f	1
12	1	1013446761	\N	\N	\N	\N	\N	\N	\N	\N	1	\N	82.00	1		f	t	\N
2	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	0.00	3	   	f	f	\N
3	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	48.00	4	  	f	f	\N
1	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	34.00	2		f	f	\N
13	1	1013844284	\N	\N	\N	\N	\N	\N	\N	\N	1	1	48.00	9		f	f	1
6	5	\N	\N	\N	\N	\N	\N	\N	\N	\N	999999	\N	\N	1	  	f	f	\N
\.
--
-- Data for TOC Entry ID 240 (OID 63372)
--
-- Name: body Type: TABLE DATA Owner: keeper
--


COPY body FROM stdin;
2	1011452057	634	  	1.12	6	0	\N	9	\N	0	15	f
3	1011452058	179	  	8.20	10	0	\N	9	\N	0	15	f
4	1011452058	552	  	215.11	2	0	\N	9	\N	0	15	f
6	1011452059	823	  	0.20	8	0	\N	9	\N	0	14	f
7	1011452059	1032	  	\N	20	0	\N	9	\N	0	14	f
8	1011452059	1239	  	50.00	0.7	0	\N	9	\N	0	17	f
9	1011452059	444	  	1.17	1.4	0	\N	9	\N	0	17	f
10	1013446601	1324	  	0.00	2	0	0.00	4	1	0	16	f
11	1013446668	1269	\N	12288.60	1	\N	12288.60	11	\N	0	\N	f
1	1011024629	1269	  	12288.60	1	1	12288.60	8	1	0	16	f
13	1013446761	823	\N	0.34	100	\N	34.00	1	1	0	\N	f
12	1013446761	1111	\N	0.48	100	100	48.00	13	1	1	\N	f
5	1011452058	1111	  	\N	8	0	\N	9	\N	0	14	f
\.
--
-- Data for TOC Entry ID 241 (OID 63374)
--
-- Name: deficit Type: TABLE DATA Owner: keeper
--


COPY deficit FROM stdin;
9	634	\N	6	0	1011452058	2
9	179	\N	10	0	1011452058	3
9	552	\N	2	0	1011452058	4
9	823	\N	8	0	1011452059	6
9	1032	\N	20	0	1011452059	7
9	444	\N	1.4	0	1011452059	9
4	1324	\N	2	0	1013446601	10
\.
--
-- Data for TOC Entry ID 242 (OID 63376)
--
-- Name: preserve Type: TABLE DATA Owner: keeper
--


COPY preserve FROM stdin;
1011452058	9	634	\N	0	f	2
1011452058	9	179	\N	0	f	3
1011452058	9	552	\N	0	f	4
1011452059	9	823	\N	0	f	6
1011452059	9	1032	\N	0	f	7
1011452059	9	1239	\N	0.7	f	8
1011452059	9	444	\N	0	f	9
1011024793	8	1269	\N	0	f	1
1011452059	9	1111	\N	8	f	5
\.
--
-- Data for TOC Entry ID 243 (OID 63378)
--
-- Name: documentlink Type: TABLE DATA Owner: keeper
--


COPY documentlink FROM stdin;
8	11	1	1013446668	\N	\N	12288.60
13	9	1	1013844331	1111	8	3.84
\.
--
-- Data for TOC Entry ID 244 (OID 63380)
--
-- Name: queue Type: TABLE DATA Owner: keeper
--


COPY queue FROM stdin;
12	,9
13	,9
\.
--
-- Data for TOC Entry ID 245 (OID 63385)
--
-- Name: docdepart Type: TABLE DATA Owner: keeper
--


COPY docdepart FROM stdin;
\.
--
-- Data for TOC Entry ID 246 (OID 63389)
--
-- Name: register Type: TABLE DATA Owner: keeper
--


COPY register FROM stdin;
\.
--
-- Data for TOC Entry ID 247 (OID 63393)
--
-- Name: file Type: TABLE DATA Owner: keeper
--


COPY file FROM stdin;
1	1	1269	1	1013446693	6	11	\N
\.
--
-- Data for TOC Entry ID 248 (OID 63395)
--
-- Name: docmore Type: TABLE DATA Owner: keeper
--


COPY docmore FROM stdin;
11	\N	8	\N	1	6	\N
\.
--
-- Data for TOC Entry ID 249 (OID 63399)
--
-- Name: product Type: TABLE DATA Owner: keeper
--


COPY product FROM stdin;
175	43	 2522	3.362.029	1	t	f	    	
634	43	 2510	3.362.096	1	t	f	    	\N
1269	13	 HP LJ 1100		1	t	f	    	
1323	14	 Epson FX800		1	t	f	    	
269	91	  -120 750	 23436-83	2	t	f	    	
787	85	 BLS-2		1	t	f	    	\N
396	85	 DRB-9FA		1	t	f	    	\N
916	24	 	8.1	1	t	f	    	
1274	15	 Lexmark Z51		1	t	f	    	
237	91	        0.02	 6500-64	2	t	f	    	\N
904	24	 	PC107	1	t	f	    	
1032	33	 24	10299-80	1	t	f	    	\N
1324	16	 Panasonic KX-T 7565 W		1	t	f	    	
1276	16	 Siemens Euro 802		1	t	f	    	
607	19	 2-29-0.125-51.1  1%-	0.467.130 	1	t	f	    	\N
978	33	 1.6x5.32.139	12643-80	1	t	f	    	\N
265	33	 2-8.37.10	10299-80	1	t	f	    	\N
511	19	 2-33-0.125-100  5%-	0.467.173	1	t	f	    	\N
544	27	 PIC16C65A(B)-20I/P	MTI DS30234A	1	t	f	    	\N
443	27	 PIC16C65A-20I/P	MicroChip	1	t	f	    	\N
552	27	 PIC16F877-20I/P	MicroChip	1	t	f	    	\N
297	64	  RC-34		2	t	f	    	\N
955	64	 -2 10x0.2	16-705.403-85	2	t	f	    	\N
211	65	   0.12	16-505.185-79	2	t	f	    	\N
256	65	   0.35	16-505.437-82	2	t	f	    	\N
241	65	 -2 0.18	 7262-78	2	t	f	    	\N
179	18	 10-17-1-47-1600  10%	0.460.107	1	t	f	    	\N
618	18	 10-17-47-180  5%	0.460.107	1	t	f	    	\N
635	18	 53-1-20-10  20%	0.464.044	1	t	f	    	\N
1069	84	 6-6gx16.36.019	1491-80	1	t	f	    	\N
1111	84	 6-6gx20.36	1491-80	1	t	f	    	\N
1070	84	 8-6gx20.36.019	1491-80	1	t	f	    	\N
823	50	 M2.5-6H.5.013	5927-70	1	t	f	    	\N
891	50	 4-6.04.016	5916-70	1	t	f	    	\N
725	86	 2.5 .04.013	10450-78	1	t	f	    	\N
1105	86	 4.01.016	11371-78	1	t	f	    	\N
1034	86	 6.65.019	6402-70	1	t	f	    	\N
682	48	 2.5-6g- 6.36.013	17473-80	1	t	f	    	\N
357	48	 3-6g-10.36.016	17473-80	1	t	f	    	\N
1071	48	 6-6gx16.36.019	17475-80	1	t	f	    	\N
745	43	 1N5819	DC Components Co	1	t	f	    	\N
1036	11	 LG	StudioWorks 55i	1	t	f	    	\N
1037	11	 Samsung	SyncMaster 15GLe	1	t	f	    	\N
1525	51	 352	352.023	1	f	f	    	
1239	64	 C 301		2	t	f	    	
1527	5	    352		1	f	f	A4  	
1526	5	    352		1	f	f	A3  	
444	91	  4795	Zweckform	2	t	f	    	
393	85	 BH-10		1	t	f	    	\N
286	85	 IDC BH-34S		1	t	f	    	\N
521	89	 2133	3.362.805	1	t	f	    	\N
756	89	 815	3.362.027	1	t	f	    	\N
643	89	 409		1	t	f	    	\N
523	17	 3102	0.336.122	1	t	f	    	\N
209	17	 313	0.336.131	1	t	f	    	\N
210	17	 814	0.336.184	1	t	f	    	\N
594	19	 2-29-0.125-1.5  1%-	0.467.130 	1	t	f	    	\N
\.
--
-- Data for TOC Entry ID 250 (OID 63406)
--
-- Name: class Type: TABLE DATA Owner: keeper
--


COPY class FROM stdin;
2	\N		f	f	t
29	10	 	f	t	f
30	10	 	f	t	f
28	10	 	f	t	f
87	10	 	f	t	f
8	2		f	f	t
21	8		f	t	f
20	8		f	t	f
3	\N		f	f	t
55	3		f	f	f
56	3	 -	f	f	t
59	56		f	t	f
60	56	.	f	t	f
61	56		f	t	f
22	8		f	t	f
9	2		f	t	f
64	58		f	t	f
65	58		f	t	f
66	58		f	t	f
17	53		f	t	f
19	53		f	t	f
25	53		f	f	t
82	55	.	f	t	f
10	2		f	f	t
77	56		f	t	f
27	25		f	t	f
26	25		f	t	f
51	2		f	t	f
58	3	- 	f	f	t
24	55		f	t	f
80	69		f	f	t
79	69	.	f	f	f
54	3		f	f	t
53	3		f	f	f
83	54		f	f	f
1	\N	------	f	t	f
4	\N		f	f	t
69	4	.	f	f	f
70	4		f	f	f
71	4		f	f	f
72	4		f	f	f
73	4	.	f	f	f
74	4	/	f	f	f
75	4	.	f	f	f
5	\N		f	t	f
6	69		f	t	f
7	80		f	t	f
11	80		f	t	f
12	69		f	f	f
13	12		f	t	f
14	12		f	t	f
15	12		f	t	f
16	69		f	t	f
23	54		f	f	f
86	23		f	t	f
84	23		f	t	f
50	23		f	t	f
48	23		f	t	f
31	23		f	t	f
32	23		f	t	f
33	23		f	t	f
34	23		f	t	f
35	54		f	f	f
36	54		f	t	f
37	54		f	t	f
38	54		f	f	f
39	55	 	f	t	f
40	53		f	t	f
41	94	 	f	t	f
42	93		f	t	f
43	53		f	t	f
44	93		f	t	f
45	53		f	t	f
46	53	 	f	t	f
47	53	 	f	f	f
49	47		f	t	f
52	47	 	f	t	f
57	47		f	t	f
62	47		f	t	f
63	53	 	f	f	f
76	53		f	t	f
78	53		f	t	f
81	53		f	t	f
85	53		f	t	f
88	53		f	t	f
90	53		f	t	f
91	56		f	t	f
92	56		f	f	f
93	3	 	f	f	f
94	93		f	f	f
95	94	 	f	t	f
67	63		f	t	f
68	63		f	t	f
89	53		f	t	f
18	53		f	t	f
\.
--
-- Data for TOC Entry ID 251 (OID 63416)
--
-- Name: preference Type: TABLE DATA Owner: keeper
--


COPY preference FROM stdin;
13	1	1026394888	grbyclass	on
1	1	1026394888	columnname	on
2	1	1026394888	columnkobm	on
3	1	1026394888	columntotl	on
11	1	1026394888	columnpres	on
4	1	1026394888	columnqty	on
5	1	1026394888	columnprc	on
6	1	1026394888	columnS	on
7	1	1026394888	columnD	on
14	1	1026394888	columnspc	on
12	1	1026394902	pagesize	100
\.
--
-- Data for TOC Entry ID 252 (OID 63421)
--
-- Name: docisp Type: TABLE DATA Owner: keeper
--


COPY docisp FROM stdin;
\.
--
-- Data for TOC Entry ID 253 (OID 63423)
--
-- Name: ls_register Type: TABLE DATA Owner: keeper
--


COPY ls_register FROM stdin;
1	 ,   	21	
2	 ,    1	22	 1
3	 ,    2	23	 2
4	 ,    3	24	 3
5	 ,    4	25	 4
6	 ,    5	26	 5
7	 ,    6	27	 6
8	 ,    7	28	 7
9	  	\N	\N
\.
--
-- Data for TOC Entry ID 254 (OID 63431)
--
-- Name: serialnum Type: TABLE DATA Owner: keeper
--


COPY serialnum FROM stdin;
\.
--
-- Data for TOC Entry ID 255 (OID 63438)
--
-- Name: ls_document Type: TABLE DATA Owner: keeper
--


COPY ls_document FROM stdin;
1		 	green
2		 	red
3		 	darkcyan
4		  	blue
5		 	black
6		 	magenta
7		 	grey
\.
--
-- Data for TOC Entry ID 256 (OID 64234)
--
-- Name: ls_razdel Type: TABLE DATA Owner: keeper
--


COPY ls_razdel FROM stdin;
11	
12	
13	 
14	
15	 
16	 
17	
18	
\.
--
-- Data for TOC Entry ID 257 (OID 64248)
--
-- Name: bodymore Type: TABLE DATA Owner: keeper
--


COPY bodymore FROM stdin;
\.
--
-- Data for TOC Entry ID 258 (OID 555517)
--
-- Name: ls_document_stage Type: TABLE DATA Owner: keeper
--


COPY ls_document_stage FROM stdin;
1	1				201	f	t
1	2	   	 		202	f	f
1	3	   	 .		203	t	f
1	4	  	.		204	t	f
1	5	  	 		205	f	t
1	6	   	 		206	t	t
1	7	  	  .		207	f	t
1	8	    	 		208	f	t
1	9				209	t	t
2	0	 			212	f	t
2	1	 			213	f	t
2	2	 			214	f	t
2	3	 			216	t	t
2	5	 			215	t	t
3	1				222	f	t
3	2	   	  .		223	f	t
3	3	  	 		224	f	t
3	4	  	  .		225	f	t
3	5	   	 .		226	t	t
3	6	    	  .		227	f	t
3	7				228	t	t
4	1	 			217	f	t
4	2	  			218	f	f
4	3				219	t	t
4	4	 			220	f	t
4	5	 			221	t	f
6	1				211	t	t
6	1		 		229	t	f
7	1				231	f	t
7	2				232	t	t
\.
--
-- Data for TOC Entry ID 259 (OID 555556)
--
-- Name: stage_route Type: TABLE DATA Owner: keeper
--


COPY stage_route FROM stdin;
1	1	1	1	2	  .	101
2	1	2	0	0		102
3	1	4	1	5	      	104
4	1	5	1	6	  	105
5	1	5	1	7	  	106
6	1	5	1	8	  	107
7	1	8	1	6		108
8	1	8	1	7	 	109
9	1	6	1	9	   	110
10	1	3	6	1	 	111
11	1	7	1	5	  	113
12	2	0	2	1	  	131
13	2	1	2	5	 	114
14	4	1	4	2	 	133
15	4	2	4	4	 	134
16	4	2	4	5		135
17	4	4	4	3	  	130
18	3	1	3	2	  	115
19	3	2	3	3	  	116
20	3	2	3	4	  	117
21	3	3	3	5	  	118
22	3	3	3	4	  	119
23	3	3	3	6	  	120
24	3	6	3	5		121
25	3	6	3	4	 	122
26	3	5	3	7	 	123
27	3	4	3	2	  	124
28	7	1	7	2	  	132
\.
--
-- Data for TOC Entry ID 260 (OID 555657)
--
-- Name: ls_permission Type: TABLE DATA Owner: keeper
--


COPY ls_permission FROM stdin;
1	2002-09-18 00:06:02.489126+07	:  
2	2002-09-18 00:06:02.519106+07	:   (  " ")
3	2002-09-18 00:06:02.54225+07	:  
4	2002-09-18 00:06:02.565402+07	:  
5	2002-09-18 00:06:02.588401+07	:   
6	2002-09-18 00:06:02.611739+07	:  
8	2002-09-18 00:06:02.636377+07	:   dbf
9	2002-09-18 00:06:02.65839+07	:  
10	2002-09-18 00:06:02.681256+07	:  
11	2002-09-18 00:06:02.721115+07	:     
12	2002-09-18 00:06:02.750773+07	:   
13	2002-09-18 00:06:02.773925+07	:   
91	2002-09-18 00:06:02.797139+07	:  
92	2002-09-18 00:06:02.82026+07	:  
93	2002-09-18 00:06:02.84342+07	: 
94	2002-09-18 00:06:02.86665+07	:   
96	2002-09-18 00:06:02.889759+07	:  
97	2002-09-18 00:06:02.916074+07	:  
21	2002-09-18 00:06:02.951985+07	: 
22	2002-09-18 00:06:02.951985+07	:  1
23	2002-09-18 00:06:02.951985+07	:  2
24	2002-09-18 00:06:02.951985+07	:  3
25	2002-09-18 00:06:02.951985+07	:  4
26	2002-09-18 00:06:02.951985+07	:  5
27	2002-09-18 00:06:02.951985+07	:  6
28	2002-09-18 00:06:02.951985+07	:  7
101	2002-09-18 00:06:02.983245+07	.: :   .
104	2002-09-18 00:06:02.983245+07	.: :       
105	2002-09-18 00:06:02.983245+07	.: :   
106	2002-09-18 00:06:02.983245+07	.: :   
107	2002-09-18 00:06:02.983245+07	.: :   
108	2002-09-18 00:06:02.983245+07	.: : 
109	2002-09-18 00:06:02.983245+07	.: :  
110	2002-09-18 00:06:02.983245+07	.: :    
111	2002-09-18 00:06:02.983245+07	.: :  
113	2002-09-18 00:06:02.983245+07	.: :   
131	2002-09-18 00:06:02.983245+07	.: :   
114	2002-09-18 00:06:02.983245+07	.: :  
133	2002-09-18 00:06:02.983245+07	.: :  
134	2002-09-18 00:06:02.983245+07	.: :  
135	2002-09-18 00:06:02.983245+07	.: : 
130	2002-09-18 00:06:02.983245+07	.: :   
115	2002-09-18 00:06:02.983245+07	.: :   
116	2002-09-18 00:06:02.983245+07	.: :   
117	2002-09-18 00:06:02.983245+07	.: :   
118	2002-09-18 00:06:02.983245+07	.: :   
119	2002-09-18 00:06:02.983245+07	.: :   
120	2002-09-18 00:06:02.983245+07	.: :   
121	2002-09-18 00:06:02.983245+07	.: : 
122	2002-09-18 00:06:02.983245+07	.: :  
123	2002-09-18 00:06:02.983245+07	.: :  
124	2002-09-18 00:06:02.983245+07	.: :   
132	2002-09-18 00:06:02.983245+07	.: :   
201	2002-09-18 00:06:03.018946+07	 .: : 
202	2002-09-18 00:06:03.018946+07	 .: :    
203	2002-09-18 00:06:03.018946+07	 .: :    
204	2002-09-18 00:06:03.018946+07	 .: :   
205	2002-09-18 00:06:03.018946+07	 .: :   
206	2002-09-18 00:06:03.018946+07	 .: :    
207	2002-09-18 00:06:03.018946+07	 .: :   
208	2002-09-18 00:06:03.018946+07	 .: :     
209	2002-09-18 00:06:03.018946+07	 .: : 
212	2002-09-18 00:06:03.018946+07	 .: :  
213	2002-09-18 00:06:03.018946+07	 .: :  
214	2002-09-18 00:06:03.018946+07	 .: :  
216	2002-09-18 00:06:03.018946+07	 .: :  
215	2002-09-18 00:06:03.018946+07	 .: :  
222	2002-09-18 00:06:03.018946+07	 .: : 
223	2002-09-18 00:06:03.018946+07	 .: :    
224	2002-09-18 00:06:03.018946+07	 .: :   
225	2002-09-18 00:06:03.018946+07	 .: :   
226	2002-09-18 00:06:03.018946+07	 .: :    
227	2002-09-18 00:06:03.018946+07	 .: :     
228	2002-09-18 00:06:03.018946+07	 .: : 
217	2002-09-18 00:06:03.018946+07	 .: :  
218	2002-09-18 00:06:03.018946+07	 .: :   
219	2002-09-18 00:06:03.018946+07	 .: : 
220	2002-09-18 00:06:03.018946+07	 .: :  
221	2002-09-18 00:06:03.018946+07	 .: :  
211	2002-09-18 00:06:03.018946+07	 .: : 
229	2002-09-18 00:06:03.018946+07	 .: : 
231	2002-09-18 00:06:03.018946+07	 .: : 
232	2002-09-18 00:06:03.018946+07	 .: : 
102	2002-09-18 00:06:02.983245+07	.: .: / 
\.
--
-- TOC Entry ID 166 (OID 64008)
--
-- Name: measure_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX measure_id_key ON measure USING btree (id);

--
-- TOC Entry ID 167 (OID 64009)
--
-- Name: presence_productisp_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX presence_productisp_key ON presence USING btree (product, isp);

--
-- TOC Entry ID 168 (OID 64010)
--
-- Name: ls_deficit_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX ls_deficit_id_key ON ls_deficit USING btree (id);

--
-- TOC Entry ID 169 (OID 64011)
--
-- Name: spec_id_key Type: INDEX Owner: keeper
--

CREATE INDEX spec_id_key ON spec USING btree (id);

--
-- TOC Entry ID 170 (OID 64012)
--
-- Name: spec_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX spec_deleted_key ON spec USING btree (deleted);

--
-- TOC Entry ID 171 (OID 64013)
--
-- Name: ls_result_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX ls_result_deleted_key ON ls_result USING btree (deleted);

--
-- TOC Entry ID 172 (OID 64014)
--
-- Name: ls_target_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX ls_target_id_key ON ls_target USING btree (id);

--
-- TOC Entry ID 173 (OID 64015)
--
-- Name: agent_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX agent_id_key ON agent USING btree (id);

--
-- TOC Entry ID 174 (OID 64016)
--
-- Name: agent_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX agent_deleted_key ON agent USING btree (deleted);

--
-- TOC Entry ID 175 (OID 64017)
--
-- Name: moving_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX moving_id_key ON moving USING btree (id);

--
-- TOC Entry ID 176 (OID 64018)
--
-- Name: moving_productdoc_key Type: INDEX Owner: keeper
--

CREATE INDEX moving_productdoc_key ON moving USING btree (product, document);

--
-- TOC Entry ID 177 (OID 64019)
--
-- Name: passwd_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX passwd_id_key ON passwd USING btree (id);

--
-- TOC Entry ID 178 (OID 64020)
--
-- Name: passwd_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX passwd_deleted_key ON passwd USING btree (deleted);

--
-- TOC Entry ID 179 (OID 64021)
--
-- Name: passwd_lp_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX passwd_lp_key ON passwd USING btree (login, passwd, deleted);

--
-- TOC Entry ID 180 (OID 64022)
--
-- Name: permission_passwd_key Type: INDEX Owner: keeper
--

CREATE INDEX permission_passwd_key ON permission USING btree (passwd);

--
-- TOC Entry ID 181 (OID 64023)
--
-- Name: permission_passwdlsperm_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX permission_passwdlsperm_key ON permission USING btree (passwd, lsperm);

--
-- TOC Entry ID 182 (OID 64024)
--
-- Name: document_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX document_deleted_key ON document USING btree (deleted);

--
-- TOC Entry ID 183 (OID 64025)
--
-- Name: document_closed_key Type: INDEX Owner: keeper
--

CREATE INDEX document_closed_key ON document USING btree (closed);

--
-- TOC Entry ID 184 (OID 64026)
--
-- Name: document_type_key Type: INDEX Owner: keeper
--

CREATE INDEX document_type_key ON document USING btree ("type");

--
-- TOC Entry ID 185 (OID 64027)
--
-- Name: document_typeflag_key Type: INDEX Owner: keeper
--

CREATE INDEX document_typeflag_key ON document USING btree ("type", flag);

--
-- TOC Entry ID 186 (OID 64028)
--
-- Name: document_number_key Type: INDEX Owner: keeper
--

CREATE INDEX document_number_key ON document USING btree (number);

--
-- TOC Entry ID 187 (OID 64029)
--
-- Name: document_insdate_key Type: INDEX Owner: keeper
--

CREATE INDEX document_insdate_key ON document USING btree (insdate);

--
-- TOC Entry ID 188 (OID 64030)
--
-- Name: document_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX document_id_key ON document USING btree (id);

--
-- TOC Entry ID 189 (OID 64031)
--
-- Name: body_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX body_id_key ON body USING btree (id);

--
-- TOC Entry ID 190 (OID 64032)
--
-- Name: body_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX body_deleted_key ON body USING btree (deleted);

--
-- TOC Entry ID 191 (OID 64033)
--
-- Name: body_document_key Type: INDEX Owner: keeper
--

CREATE INDEX body_document_key ON body USING btree (document);

--
-- TOC Entry ID 192 (OID 64034)
--
-- Name: deficit_id_key Type: INDEX Owner: keeper
--

CREATE INDEX deficit_id_key ON deficit USING btree (id);

--
-- TOC Entry ID 193 (OID 64035)
--
-- Name: deficit_body_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX deficit_body_key ON deficit USING btree (body);

--
-- TOC Entry ID 194 (OID 64036)
--
-- Name: deficit_idpr_key Type: INDEX Owner: keeper
--

CREATE INDEX deficit_idpr_key ON deficit USING btree (id, product);

--
-- TOC Entry ID 195 (OID 64037)
--
-- Name: preserve_id_key Type: INDEX Owner: keeper
--

CREATE INDEX preserve_id_key ON preserve USING btree (id);

--
-- TOC Entry ID 196 (OID 64038)
--
-- Name: preserve_product_key Type: INDEX Owner: keeper
--

CREATE INDEX preserve_product_key ON preserve USING btree (product);

--
-- TOC Entry ID 197 (OID 64039)
--
-- Name: preserve_body_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX preserve_body_key ON preserve USING btree (body);

--
-- TOC Entry ID 198 (OID 64040)
--
-- Name: documentlink1_key Type: INDEX Owner: keeper
--

CREATE INDEX documentlink1_key ON documentlink USING btree (document1);

--
-- TOC Entry ID 199 (OID 64041)
--
-- Name: documentlink2_key Type: INDEX Owner: keeper
--

CREATE INDEX documentlink2_key ON documentlink USING btree (document2);

--
-- TOC Entry ID 200 (OID 64042)
--
-- Name: queue_body_key Type: INDEX Owner: keeper
--

CREATE INDEX queue_body_key ON queue USING btree (body);

--
-- TOC Entry ID 201 (OID 64043)
--
-- Name: docdepart_document_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX docdepart_document_key ON docdepart USING btree (document);

--
-- TOC Entry ID 202 (OID 64044)
--
-- Name: register_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX register_id_key ON register USING btree (id);

--
-- TOC Entry ID 203 (OID 64045)
--
-- Name: register_type_key Type: INDEX Owner: keeper
--

CREATE INDEX register_type_key ON register USING btree ("type");

--
-- TOC Entry ID 204 (OID 64046)
--
-- Name: file_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX file_id_key ON file USING btree (id);

--
-- TOC Entry ID 205 (OID 64047)
--
-- Name: file_productid_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX file_productid_key ON file USING btree (passwd, product);

--
-- TOC Entry ID 206 (OID 64048)
--
-- Name: product_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX product_id_key ON product USING btree (id);

--
-- TOC Entry ID 207 (OID 64049)
--
-- Name: product_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX product_deleted_key ON product USING btree (deleted);

--
-- TOC Entry ID 208 (OID 64050)
--
-- Name: product_class_key Type: INDEX Owner: keeper
--

CREATE INDEX product_class_key ON product USING btree (class);

--
-- TOC Entry ID 209 (OID 64051)
--
-- Name: class_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX class_id_key ON class USING btree (id);

--
-- TOC Entry ID 210 (OID 64052)
--
-- Name: class_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX class_deleted_key ON class USING btree (deleted);

--
-- TOC Entry ID 211 (OID 64053)
--
-- Name: preference_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX preference_id_key ON preference USING btree (id);

--
-- TOC Entry ID 212 (OID 64054)
--
-- Name: preference_nameuser_key Type: INDEX Owner: keeper
--

CREATE INDEX preference_nameuser_key ON preference USING btree (userid, name);

--
-- TOC Entry ID 213 (OID 64055)
--
-- Name: docisp_id_key Type: INDEX Owner: keeper
--

CREATE INDEX docisp_id_key ON docisp USING btree (id);

--
-- TOC Entry ID 214 (OID 64056)
--
-- Name: docisp_body_key Type: INDEX Owner: keeper
--

CREATE INDEX docisp_body_key ON docisp USING btree (body);

--
-- TOC Entry ID 215 (OID 64057)
--
-- Name: ls_register_permission_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX ls_register_permission_key ON ls_register USING btree (permission);

--
-- TOC Entry ID 216 (OID 64058)
--
-- Name: serialnum_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX serialnum_id_key ON serialnum USING btree (id);

--
-- TOC Entry ID 217 (OID 64059)
--
-- Name: serialnum_deleted_key Type: INDEX Owner: keeper
--

CREATE INDEX serialnum_deleted_key ON serialnum USING btree (deleted);

--
-- TOC Entry ID 218 (OID 64060)
--
-- Name: serialnum_product_key Type: INDEX Owner: keeper
--

CREATE INDEX serialnum_product_key ON serialnum USING btree (product);

--
-- TOC Entry ID 219 (OID 64061)
--
-- Name: serialnum_numbers_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX serialnum_numbers_key ON serialnum USING btree (serialnum, invnum);

--
-- TOC Entry ID 220 (OID 64062)
--
-- Name: ls_document_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX ls_document_id_key ON ls_document USING btree (id);

--
-- TOC Entry ID 221 (OID 64259)
--
-- Name: bodymore_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX bodymore_id_key ON bodymore USING btree (id);

--
-- TOC Entry ID 222 (OID 417665)
--
-- Name: register_product_key Type: INDEX Owner: keeper
--

CREATE INDEX register_product_key ON register USING btree (product);

--
-- TOC Entry ID 223 (OID 555523)
--
-- Name: ls_document_stag_permission_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX ls_document_stag_permission_key ON ls_document_stage USING btree (permission);

--
-- TOC Entry ID 224 (OID 555562)
--
-- Name: stage_route_id_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX stage_route_id_key ON stage_route USING btree (id);

--
-- TOC Entry ID 225 (OID 555563)
--
-- Name: stage_route_permission_key Type: INDEX Owner: keeper
--

CREATE UNIQUE INDEX stage_route_permission_key ON stage_route USING btree (permission);

--
-- TOC Entry ID 261 (OID 64067)
--
-- Name: presence_update Type: TRIGGER Owner: keeper
--

CREATE TRIGGER presence_update BEFORE INSERT OR UPDATE ON presence  FOR EACH ROW EXECUTE PROCEDURE presence_update ();

--
-- TOC Entry ID 271 (OID 64069)
--
-- Name: "RI_ConstraintTrigger_64068" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER permission_passwd AFTER INSERT OR UPDATE ON permission  FROM passwd NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('permission_passwd', 'permission', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 267 (OID 64071)
--
-- Name: "RI_ConstraintTrigger_64070" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER permission_passwd AFTER DELETE ON passwd  FROM permission NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('permission_passwd', 'permission', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 268 (OID 64073)
--
-- Name: "RI_ConstraintTrigger_64072" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER permission_passwd AFTER UPDATE ON passwd  FROM permission NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_upd" ('permission_passwd', 'permission', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 280 (OID 64075)
--
-- Name: "RI_ConstraintTrigger_64074" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_id AFTER INSERT OR UPDATE ON docmore  FROM document NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_id', 'docmore', 'document', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 272 (OID 64077)
--
-- Name: "RI_ConstraintTrigger_64076" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_id AFTER DELETE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('docmore_id', 'docmore', 'document', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 273 (OID 64079)
--
-- Name: "RI_ConstraintTrigger_64078" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_id AFTER UPDATE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_upd" ('docmore_id', 'docmore', 'document', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 281 (OID 64081)
--
-- Name: "RI_ConstraintTrigger_64080" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_docdef AFTER INSERT OR UPDATE ON docmore  FROM document NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_docdef', 'docmore', 'document', 'UNSPECIFIED', 'docdef', 'id');

--
-- TOC Entry ID 274 (OID 64083)
--
-- Name: "RI_ConstraintTrigger_64082" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_docdef AFTER DELETE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_del" ('docmore_docdef', 'docmore', 'document', 'UNSPECIFIED', 'docdef', 'id');

--
-- TOC Entry ID 275 (OID 64085)
--
-- Name: "RI_ConstraintTrigger_64084" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_docdef AFTER UPDATE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_upd" ('docmore_docdef', 'docmore', 'document', 'UNSPECIFIED', 'docdef', 'id');

--
-- TOC Entry ID 282 (OID 64087)
--
-- Name: "RI_ConstraintTrigger_64086" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_doczay AFTER INSERT OR UPDATE ON docmore  FROM document NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_doczay', 'docmore', 'document', 'UNSPECIFIED', 'doczay', 'id');

--
-- TOC Entry ID 276 (OID 64089)
--
-- Name: "RI_ConstraintTrigger_64088" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_doczay AFTER DELETE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_del" ('docmore_doczay', 'docmore', 'document', 'UNSPECIFIED', 'doczay', 'id');

--
-- TOC Entry ID 277 (OID 64091)
--
-- Name: "RI_ConstraintTrigger_64090" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_doczay AFTER UPDATE ON document  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_upd" ('docmore_doczay', 'docmore', 'document', 'UNSPECIFIED', 'doczay', 'id');

--
-- TOC Entry ID 283 (OID 64093)
--
-- Name: "RI_ConstraintTrigger_64092" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_passwd AFTER INSERT OR UPDATE ON docmore  FROM passwd NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_passwd', 'docmore', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 269 (OID 64095)
--
-- Name: "RI_ConstraintTrigger_64094" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_passwd AFTER DELETE ON passwd  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_del" ('docmore_passwd', 'docmore', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 270 (OID 64097)
--
-- Name: "RI_ConstraintTrigger_64096" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_passwd AFTER UPDATE ON passwd  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_upd" ('docmore_passwd', 'docmore', 'passwd', 'UNSPECIFIED', 'passwd', 'id');

--
-- TOC Entry ID 284 (OID 64099)
--
-- Name: "RI_ConstraintTrigger_64098" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_target AFTER INSERT OR UPDATE ON docmore  FROM ls_target NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_target', 'docmore', 'ls_target', 'UNSPECIFIED', 'target', 'id');

--
-- TOC Entry ID 263 (OID 64101)
--
-- Name: "RI_ConstraintTrigger_64100" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_target AFTER DELETE ON ls_target  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_del" ('docmore_target', 'docmore', 'ls_target', 'UNSPECIFIED', 'target', 'id');

--
-- TOC Entry ID 264 (OID 64103)
--
-- Name: "RI_ConstraintTrigger_64102" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_target AFTER UPDATE ON ls_target  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_upd" ('docmore_target', 'docmore', 'ls_target', 'UNSPECIFIED', 'target', 'id');

--
-- TOC Entry ID 285 (OID 64105)
--
-- Name: "RI_ConstraintTrigger_64104" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_recipient AFTER INSERT OR UPDATE ON docmore  FROM agent NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('docmore_recipient', 'docmore', 'agent', 'UNSPECIFIED', 'client', 'id');

--
-- TOC Entry ID 265 (OID 64107)
--
-- Name: "RI_ConstraintTrigger_64106" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_recipient AFTER DELETE ON agent  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_del" ('docmore_recipient', 'docmore', 'agent', 'UNSPECIFIED', 'client', 'id');

--
-- TOC Entry ID 266 (OID 64109)
--
-- Name: "RI_ConstraintTrigger_64108" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER docmore_recipient AFTER UPDATE ON agent  FROM docmore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_restrict_upd" ('docmore_recipient', 'docmore', 'agent', 'UNSPECIFIED', 'client', 'id');

--
-- TOC Entry ID 286 (OID 64111)
--
-- Name: "RI_ConstraintTrigger_64110" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER presence_product AFTER DELETE ON product  FROM presence NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('presence_product', 'presence', 'product', 'UNSPECIFIED', 'product', 'id');

--
-- TOC Entry ID 287 (OID 64113)
--
-- Name: "RI_ConstraintTrigger_64112" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER presence_product AFTER UPDATE ON product  FROM presence NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_upd" ('presence_product', 'presence', 'product', 'UNSPECIFIED', 'product', 'id');

--
-- TOC Entry ID 262 (OID 64115)
--
-- Name: "RI_ConstraintTrigger_64114" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER presence_product AFTER INSERT OR UPDATE ON presence  FROM product NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('presence_product', 'presence', 'product', 'UNSPECIFIED', 'product', 'id');

--
-- TOC Entry ID 288 (OID 64117)
--
-- Name: "RI_ConstraintTrigger_64116" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER presence_product AFTER DELETE ON product  FROM presence NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('presence_product', 'presence', 'product', 'UNSPECIFIED', 'product', 'id');

--
-- TOC Entry ID 289 (OID 64119)
--
-- Name: "RI_ConstraintTrigger_64118" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER presence_product AFTER UPDATE ON product  FROM presence NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_upd" ('presence_product', 'presence', 'product', 'UNSPECIFIED', 'product', 'id');

--
-- TOC Entry ID 290 (OID 64254)
--
-- Name: "RI_ConstraintTrigger_64253" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER bodymore_id AFTER INSERT OR UPDATE ON bodymore  FROM body NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bodymore_id', 'bodymore', 'body', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 278 (OID 64256)
--
-- Name: "RI_ConstraintTrigger_64255" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER bodymore_id AFTER DELETE ON body  FROM bodymore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_del" ('bodymore_id', 'bodymore', 'body', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 279 (OID 64258)
--
-- Name: "RI_ConstraintTrigger_64257" Type: TRIGGER Owner: keeper
--

CREATE CONSTRAINT TRIGGER bodymore_id AFTER UPDATE ON body  FROM bodymore NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_cascade_upd" ('bodymore_id', 'bodymore', 'body', 'UNSPECIFIED', 'id', 'id');

--
-- TOC Entry ID 3 (OID 63276)
--
-- Name: measure_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('measure_id_seq', 5, true);

--
-- TOC Entry ID 5 (OID 63278)
--
-- Name: ls_deficit_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('ls_deficit_id_seq', 6, true);

--
-- TOC Entry ID 7 (OID 63302)
--
-- Name: ls_target_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('ls_target_id_seq', 6, true);

--
-- TOC Entry ID 9 (OID 63309)
--
-- Name: agent_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('agent_id_seq', 6, true);

--
-- TOC Entry ID 11 (OID 63325)
--
-- Name: moving_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('moving_id_seq', 10, true);

--
-- TOC Entry ID 13 (OID 63332)
--
-- Name: passwd_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('passwd_id_seq', 2, true);

--
-- TOC Entry ID 15 (OID 63341)
--
-- Name: document_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('document_id_seq', 13, true);

--
-- TOC Entry ID 17 (OID 63348)
--
-- Name: prixod_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('prixod_seq', 1, true);

--
-- TOC Entry ID 20 (OID 63350)
--
-- Name: rasxod_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('rasxod_seq', 1, true);

--
-- TOC Entry ID 23 (OID 63352)
--
-- Name: deficit0_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit0_seq', 1, true);

--
-- TOC Entry ID 26 (OID 63354)
--
-- Name: deficit1_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit1_seq', 1, false);

--
-- TOC Entry ID 29 (OID 63356)
--
-- Name: deficit2_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit2_seq', 1, false);

--
-- TOC Entry ID 32 (OID 63358)
--
-- Name: deficit3_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit3_seq', 1, false);

--
-- TOC Entry ID 35 (OID 63360)
--
-- Name: deficit4_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit4_seq', 1, false);

--
-- TOC Entry ID 38 (OID 63362)
--
-- Name: deficit5_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('deficit5_seq', 1, false);

--
-- TOC Entry ID 41 (OID 63364)
--
-- Name: order_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('order_seq', 1, true);

--
-- TOC Entry ID 44 (OID 63366)
--
-- Name: reclam_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('reclam_seq', 1, false);

--
-- TOC Entry ID 47 (OID 63368)
--
-- Name: spis_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('spis_seq', 1, false);

--
-- TOC Entry ID 50 (OID 63370)
--
-- Name: body_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('body_id_seq', 13, true);

--
-- TOC Entry ID 52 (OID 63387)
--
-- Name: register_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('register_id_seq', 1, false);

--
-- TOC Entry ID 54 (OID 63391)
--
-- Name: file_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('file_id_seq', 1, true);

--
-- TOC Entry ID 56 (OID 63397)
--
-- Name: product_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('product_id_seq', 1527, true);

--
-- TOC Entry ID 58 (OID 63404)
--
-- Name: class_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('class_id_seq', 100, true);

--
-- TOC Entry ID 60 (OID 63414)
--
-- Name: preference_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('preference_id_seq', 14, true);

--
-- TOC Entry ID 62 (OID 63429)
--
-- Name: serialnum_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('serialnum_id_seq', 1, false);

--
-- TOC Entry ID 64 (OID 63436)
--
-- Name: ls_document_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('ls_document_id_seq', 1, false);

--
-- TOC Entry ID 66 (OID 555554)
--
-- Name: stage_route_id_seq Type: SEQUENCE SET Owner: keeper
--

SELECT setval ('stage_route_id_seq', 28, true);

--
-- TOC Entry ID 69 (OID 63280)
--
-- Name: TABLE measure Type: COMMENT Owner: 
--

COMMENT ON TABLE measure IS ' ';

--
-- TOC Entry ID 72 (OID 63285)
--
-- Name: TABLE presence Type: COMMENT Owner: 
--

COMMENT ON TABLE presence IS '  ';

--
-- TOC Entry ID 75 (OID 63287)
--
-- Name: TABLE ls_deficit Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_deficit IS ' ';

--
-- TOC Entry ID 78 (OID 63292)
--
-- Name: TABLE spec Type: COMMENT Owner: 
--

COMMENT ON TABLE spec IS '';

--
-- TOC Entry ID 81 (OID 63297)
--
-- Name: TABLE ls_result Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_result IS '  ';

--
-- TOC Entry ID 84 (OID 63304)
--
-- Name: TABLE ls_target Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_target IS ' ';

--
-- TOC Entry ID 87 (OID 63311)
--
-- Name: TABLE agent Type: COMMENT Owner: 
--

COMMENT ON TABLE agent IS '  ';

--
-- TOC Entry ID 92 (OID 63327)
--
-- Name: TABLE moving Type: COMMENT Owner: 
--

COMMENT ON TABLE moving IS '  ';

--
-- TOC Entry ID 94 (OID 63334)
--
-- Name: TABLE passwd Type: COMMENT Owner: 
--

COMMENT ON TABLE passwd IS '    ';

--
-- TOC Entry ID 97 (OID 63339)
--
-- Name: TABLE permission Type: COMMENT Owner: 
--

COMMENT ON TABLE permission IS '  ';

--
-- TOC Entry ID 100 (OID 63343)
--
-- Name: TABLE document Type: COMMENT Owner: 
--

COMMENT ON TABLE document IS '  - ,   ';

--
-- TOC Entry ID 18 (OID 63348)
--
-- Name: SEQUENCE prixod_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE prixod_seq IS '   ';

--
-- TOC Entry ID 21 (OID 63350)
--
-- Name: SEQUENCE rasxod_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE rasxod_seq IS '   ';

--
-- TOC Entry ID 24 (OID 63352)
--
-- Name: SEQUENCE deficit0_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit0_seq IS '  /  0';

--
-- TOC Entry ID 27 (OID 63354)
--
-- Name: SEQUENCE deficit1_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit1_seq IS '  /  1';

--
-- TOC Entry ID 30 (OID 63356)
--
-- Name: SEQUENCE deficit2_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit2_seq IS '  /  2';

--
-- TOC Entry ID 33 (OID 63358)
--
-- Name: SEQUENCE deficit3_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit3_seq IS '  /  3';

--
-- TOC Entry ID 36 (OID 63360)
--
-- Name: SEQUENCE deficit4_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit4_seq IS '  /  4';

--
-- TOC Entry ID 39 (OID 63362)
--
-- Name: SEQUENCE deficit5_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE deficit5_seq IS '  /  5';

--
-- TOC Entry ID 42 (OID 63364)
--
-- Name: SEQUENCE order_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE order_seq IS '  ';

--
-- TOC Entry ID 45 (OID 63366)
--
-- Name: SEQUENCE reclam_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE reclam_seq IS '   ';

--
-- TOC Entry ID 48 (OID 63368)
--
-- Name: SEQUENCE spis_seq Type: COMMENT Owner: 
--

COMMENT ON SEQUENCE spis_seq IS '   ';

--
-- TOC Entry ID 103 (OID 63372)
--
-- Name: TABLE body Type: COMMENT Owner: 
--

COMMENT ON TABLE body IS '  ()';

--
-- TOC Entry ID 106 (OID 63374)
--
-- Name: TABLE deficit Type: COMMENT Owner: 
--

COMMENT ON TABLE deficit IS '     ';

--
-- TOC Entry ID 109 (OID 63376)
--
-- Name: TABLE preserve Type: COMMENT Owner: 
--

COMMENT ON TABLE preserve IS '      ';

--
-- TOC Entry ID 112 (OID 63378)
--
-- Name: TABLE documentlink Type: COMMENT Owner: 
--

COMMENT ON TABLE documentlink IS '  - ';

--
-- TOC Entry ID 115 (OID 63380)
--
-- Name: TABLE queue Type: COMMENT Owner: 
--

COMMENT ON TABLE queue IS '    ';

--
-- TOC Entry ID 118 (OID 63385)
--
-- Name: TABLE docdepart Type: COMMENT Owner: 
--

COMMENT ON TABLE docdepart IS ',    ';

--
-- TOC Entry ID 121 (OID 63389)
--
-- Name: TABLE register Type: COMMENT Owner: 
--

COMMENT ON TABLE register IS ' ';

--
-- TOC Entry ID 124 (OID 63393)
--
-- Name: TABLE file Type: COMMENT Owner: 
--

COMMENT ON TABLE file IS ' ';

--
-- TOC Entry ID 127 (OID 63395)
--
-- Name: TABLE docmore Type: COMMENT Owner: 
--

COMMENT ON TABLE docmore IS '.  (, )';

--
-- TOC Entry ID 130 (OID 63399)
--
-- Name: TABLE product Type: COMMENT Owner: 
--

COMMENT ON TABLE product IS ' ';

--
-- TOC Entry ID 133 (OID 63406)
--
-- Name: TABLE class Type: COMMENT Owner: 
--

COMMENT ON TABLE class IS '  ';

--
-- TOC Entry ID 136 (OID 63416)
--
-- Name: TABLE preference Type: COMMENT Owner: 
--

COMMENT ON TABLE preference IS '  ';

--
-- TOC Entry ID 139 (OID 63421)
--
-- Name: TABLE docisp Type: COMMENT Owner: 
--

COMMENT ON TABLE docisp IS '   ';

--
-- TOC Entry ID 142 (OID 63423)
--
-- Name: TABLE ls_register Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_register IS ' ';

--
-- TOC Entry ID 145 (OID 63431)
--
-- Name: TABLE serialnum Type: COMMENT Owner: 
--

COMMENT ON TABLE serialnum IS '   ';

--
-- TOC Entry ID 148 (OID 63438)
--
-- Name: TABLE ls_document Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_document IS '  ';

--
-- TOC Entry ID 151 (OID 64234)
--
-- Name: TABLE ls_razdel Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_razdel IS '   ';

--
-- TOC Entry ID 154 (OID 64248)
--
-- Name: TABLE bodymore Type: COMMENT Owner: 
--

COMMENT ON TABLE bodymore IS '    ';

--
-- TOC Entry ID 159 (OID 555517)
--
-- Name: TABLE ls_document_stage Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_document_stage IS ' ';

--
-- TOC Entry ID 162 (OID 555556)
--
-- Name: TABLE stage_route Type: COMMENT Owner: 
--

COMMENT ON TABLE stage_route IS '       ()';

--
-- TOC Entry ID 165 (OID 555657)
--
-- Name: TABLE ls_permission Type: COMMENT Owner: 
--

COMMENT ON TABLE ls_permission IS '  ';

