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

CREATE TABLE @{tableName} (
	c_folder_id INT NOT NULL,
	c_name VARCHAR (255),
	c_content TEXT NOT NULL,
	c_creationdate INT NOT NULL,
	c_lastmodified INT NOT NULL,
	c_version INT NOT NULL,
	c_deleted INT NULL,
	CONSTRAINT @{tableName}_pkey PRIMARY KEY (c_folder_id, c_name)
);