File: OCSAcl-postgresql.sql

package info (click to toggle)
sogo 5.12.4-1.2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 103,828 kB
  • sloc: objc: 122,550; javascript: 75,288; sh: 2,352; ansic: 2,055; perl: 861; python: 777; sql: 307; makefile: 187; php: 43; xml: 27
file content (14 lines) | stat: -rw-r--r-- 364 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
--
-- (C) 2004-2005 SKYRIX Software AG
-- (C) 2006-2007 Inverse inc.
--

CREATE TABLE @{tableName} (
	c_folder_id INTEGER NOT NULL,
	c_object VARCHAR(255) NOT NULL,
  	c_uid VARCHAR(255) NOT NULL,
  	c_role VARCHAR(80) NOT NULL
);

CREATE INDEX @{tableName}_c_folder_id_idx ON @{tableName}(c_folder_id);
CREATE INDEX @{tableName}_c_uid_idx ON @{tableName}(c_uid);