2 -- (C) 2004-2005 SKYRIX Software AG
5 -- add a unique constraints on path
7 CREATE SEQUENCE SOGo_folder_info_seq;
9 DROP TABLE SOGo_folder_info;
11 CREATE TABLE SOGo_folder_info (
13 DEFAULT nextval('SOGo_folder_info_seq')
15 PRIMARY KEY, -- the primary key
16 c_path VARCHAR(255) NOT NULL, -- the full path to the folder
17 c_path1 VARCHAR(255) NOT NULL, -- parts (for fast queries)
18 c_path2 VARCHAR(255) NULL, -- parts (for fast queries)
19 c_path3 VARCHAR(255) NULL, -- parts (for fast queries)
20 c_path4 VARCHAR(255) NULL, -- parts (for fast queries)
21 c_foldername VARCHAR(255) NOT NULL, -- last path component
22 c_location VARCHAR(2048) NOT NULL, -- URL to folder
23 c_quick_location VARCHAR(2048) NULL, -- URL to quicktable of folder
24 c_acl_location VARCHAR(2048) NULL, -- URL to quicktable of folder
25 c_folder_type VARCHAR(255) NOT NULL -- the folder type ...
28 INSERT INTO SOGo_folder_info
29 ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
30 c_location, c_quick_location, c_folder_type )
38 'http://OGo:OGo@localhost:5432/OGo/SOGo_user_folder',
39 'http://OGo:OGo@localhost:5432/OGo/SOGo_user_folder_quick',
40 'http://OGo:OGo@localhost:5432/OGo/SOGo_user_folder_acl',