-- $Id$
--
-- (C) 2004 SKYRIX Software AG
--

CREATE SEQUENCE SOGo_folder_info_seq;

CREATE TABLE SOGo_folder_info (
  folderId   INTEGER 
    DEFAULT nextval('SOGo_folder_info_seq')
    NOT NULL 
    PRIMARY KEY,                     -- the primary key
  path       VARCHAR(255)  NOT NULL, -- the full path to the folder 'xyz/Cal'
  rootName   VARCHAR(255)  NOT NULL, -- just the root path (for fast queries)
  folderName VARCHAR(255)  NOT NULL, -- last path component
  location   VARCHAR(2048) NOT NULL, -- URL to database of the folder
  folderType VARCHAR(255)  NOT NULL  -- the folder type ...
);

INSERT INTO SOGo_folder_info 
  ( path, rootname, foldername, location, foldertype ) 
VALUES 
  ( 'helge/Calendar', 'helge', 'Calendar', 
    'http://OGo:OGo@localhost/OGo', 'Appointment' );