File: create_company.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 (18 lines) | stat: -rw-r--r-- 449 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
create sequence seq_company_id;
create table company
(
  uid		int4 PRIMARY KEY DEFAULT nextval('seq_company_id'),
  name		varchar(60) NOT NULL,
  addr1		varchar(60) NOT NULL,
  addr2		varchar(60),
  city		varchar(40) NOT NULL,
  state		varchar(2) NOT NULL,
  zip		varchar(10) NOT NULL,
  phone		varchar(20),
  fax		varchar(20),
  create_date	timestamp,
  modified_date	timestamp
);


grant select,insert,update,delete on company to group inventory;