3 -- (C) 2004 SKYRIX Software AG
6 -- add a unique constraints on path
8 CREATE SEQUENCE SOGo_folder_info_seq;
10 DROP TABLE SOGo_folder_info;
12 CREATE TABLE SOGo_folder_info (
14 DEFAULT nextval('SOGo_folder_info_seq')
16 PRIMARY KEY, -- the primary key
17 c_path VARCHAR(255) NOT NULL, -- the full path to the folder
18 c_path1 VARCHAR(255) NOT NULL, -- parts (for fast queries)
19 c_path2 VARCHAR(255) NULL, -- parts (for fast queries)
20 c_path3 VARCHAR(255) NULL, -- parts (for fast queries)
21 c_path4 VARCHAR(255) NULL, -- parts (for fast queries)
22 c_foldername VARCHAR(255) NOT NULL, -- last path component
23 c_location VARCHAR(2048) NOT NULL, -- URL to folder
24 c_quick_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',
42 INSERT INTO SOGo_folder_info
43 ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
44 c_location, c_quick_location, c_folder_type )
52 'http://OGo:OGo@localhost:5432/OGo/SOGo_user_folder',
53 'http://OGo:OGo@localhost:5432/OGo/SOGo_user_folder_quick',
56 INSERT INTO SOGo_folder_info
57 ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
58 c_location, c_quick_location, c_folder_type )
60 ( '/Users/helge/Calendar',
66 'http://OGo:OGo@localhost:5432/OGo/SOGo_helge_privcal',
67 'http://OGo:OGo@localhost:5432/OGo/SOGo_helge_privcal_quick',