2 -- (C) 2007 Inverse groupe conseil
5 CREATE TABLE SOGo_folder_info (
6 c_folder_id INTEGER PRIMARY KEY,
7 c_path VARCHAR(255) NOT NULL, -- the full path to the folder
8 c_path1 VARCHAR(255) NOT NULL, -- parts (for fast queries)
9 c_path2 VARCHAR(255) NULL, -- parts (for fast queries)
10 c_path3 VARCHAR(255) NULL, -- parts (for fast queries)
11 c_path4 VARCHAR(255) NULL, -- parts (for fast queries)
12 c_foldername VARCHAR(255) NOT NULL, -- last path component
13 c_location VARCHAR(2048) NOT NULL, -- URL to folder
14 c_quick_location VARCHAR(2048) NULL, -- URL to quicktable of folder
15 c_acl_location VARCHAR(2048) NULL, -- URL to quicktable of folder
16 c_folder_type VARCHAR(255) NOT NULL -- the folder type ...
19 CREATE SEQUENCE SOGo_folder_info_seq;
20 CREATE OR REPLACE TRIGGER SOGo_folder_info_autonumber
21 BEFORE INSERT ON SOGo_folder_info FOR EACH ROW
23 IF :new.c_folder_id IS NULL THEN
24 SELECT SOGO_folder_info_seq.nextval INTO :new.c_folder_id FROM DUAL;