2 CREATE SEQUENCE netsuite_stock_id_seq
8 ALTER TABLE netsuite_stock_id_seq
10 GRANT ALL ON TABLE netsuite_stock_id_seq TO admin;
11 GRANT ALL ON TABLE netsuite_stock_id_seq TO xtrole;
14 CREATE TABLE netsuite_stock
16 id integer NOT NULL DEFAULT nextval(('netsuite_stock_id_seq'::text)::regclass),
26 amount_hkd numeric(14,2),
27 CONSTRAINT netsuite_stock_id_pkey PRIMARY KEY (id )
33 GRANT ALL ON TABLE netsuite_stock TO admin;
34 GRANT ALL ON TABLE netsuite_stock TO xtrole;
36 ALTER TABLE netsuite_stock ADD COLUMN txline INTEGER DEFAULT 0;
38 CREATE INDEX netsuite_stock_trans_date_indx
43 CREATE INDEX netsuite_stock_location_id_indx
48 CREATE INDEX netsuite_stock_item_id_indx