File: OCSCacheFolder-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 (17 lines) | stat: -rw-r--r-- 496 bytes parent folder | download | duplicates (8) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
--
-- (C) 2004-2005 SKYRIX Software AG
-- (C) 2006-2007 Inverse inc.
--

CREATE TABLE @{tableName} (
  	c_uid VARCHAR(255) NOT NULL,
        c_path VARCHAR(255) NOT NULL,
        c_parent_path VARCHAR(255),
        c_type SMALLINT NOT NULL,
        c_creationdate INT NOT NULL,
        c_lastmodified INT NOT NULL,
        c_version INT NOT NULL DEFAULT 0,
        c_deleted SMALLINT NOT NULL DEFAULT 0,
        c_content TEXT,
        CONSTRAINT @{tableName}_pkey PRIMARY KEY (c_uid, c_path)
);