err.no Git - scalable-opengroupware.org/blob - OGoContentStore/sql/folderinfo-create.sqlite

   1 --
   2 -- (C) 2005 SKYRIX Software AG
   3 --
   4 -- TODO:
   5 --   add a unique constraints on path
   6
   7 DROP TABLE SOGo_folder_info;
   8
   9 CREATE TABLE SOGo_folder_info (
  10   c_folder_id      INTEGER PRIMARY KEY,
  11   c_path           VARCHAR(255)  NOT NULL, /* the full path to the folder */
  12   c_path1          VARCHAR(255)  NOT NULL, /* parts (for fast queries) */
  13   c_path2          VARCHAR(255)  NULL,     /* parts (for fast queries) */
  14   c_path3          VARCHAR(255)  NULL,     /* parts (for fast queries) */
  15   c_path4          VARCHAR(255)  NULL,     /* parts (for fast queries) */
  16   c_foldername     VARCHAR(255)  NOT NULL, /* last path component */
  17   c_location       VARCHAR(2048) NOT NULL, /* URL to folder */
  18   c_quick_location VARCHAR(2048) NULL,     /* URL to quicktable of folder */
  19   c_folder_type    VARCHAR(255)  NOT NULL  /* the folder type ... */
  20 );
  21
  22 INSERT INTO SOGo_folder_info
  23   ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
  24     c_location, c_quick_location, c_folder_type )
  25 VALUES
  26   ( '/Users',
  27     'Users',
  28     NULL,
  29     NULL,
  30     NULL,
  31     'Users',
  32     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_user_folder_blob',
  33     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_user_folder_quick',
  34     'Container' );
  35
  36 INSERT INTO SOGo_folder_info
  37   ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
  38     c_location, c_quick_location, c_folder_type )
  39 VALUES
  40   ( '/Users/helge',
  41     'Users',
  42     'helge',
  43     NULL,
  44     NULL,
  45     'helge',
  46     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_user_folder_blob',
  47     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_user_folder_quick',
  48     'Container' );
  49
  50 INSERT INTO SOGo_folder_info
  51   ( c_path, c_path1, c_path2, c_path3, c_path4, c_foldername,
  52     c_location, c_quick_location, c_folder_type )
  53 VALUES
  54   ( '/Users/helge/Calendar',
  55     'Users',
  56     'helge',
  57     'Calendar',
  58      NULL,
  59     'Calendar',
  60     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_helge_privcal_blob',
  61     'sqlite://localhost/tmp/sogo-registry.sqlite/SOGo_helge_privcal_quick',
  62     'Appointment' );