File: create_unit_description.sql

package info (click to toggle)
gnue-forms 0.5.11-2
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 3,384 kB
  • ctags: 1,577
  • sloc: python: 12,904; sql: 579; makefile: 28
file content (11 lines) | stat: -rw-r--r-- 327 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
 
create sequence seq_unit_description_id;

create table unit_description
(
  id                    int4 PRIMARY KEY DEFAULT nextval('seq_unit_description_id'),
  description           varchar(20) NOT NULL
);

grant select,insert,update,delete on unit_description to group inventory;
grant select on unit_description to public;