////////////////////////////////////////////////////
//
// WebDAV Schema for databases before 74.03.09
//
// Statements described here have to be used 
// only with databases befor 74.03.09!
//
// To execute following statements please use
// SQL Studio and Web SQL respectively.
//
// This script contains following sections:
//
// - WebDAV Schema drop
// - WEBDAV Schema for an ASCII database
// - WEBDAV Schema for an UNICODE database
// - WEBDAV Schema Init
//
// Depending on your database type you have to
// use the statements from the section
// "WEBDAV Schema for an ASCII database" or
// "WEBDAV Schema for an UNICODE database".
// The UNICODE statements have to be uncommented
// before use.
//
// In both cases you have to execute statements from
// the section "WEBDAV Schema Init"
//
// To drop the WebDAV schema you can use statments
// from the section "WebDAV Schema drop".
// The drop statements have to be uncommented
// before use.
//
////////////////////////////////////////////////////

////////////////////////////////////////////////////
//
// WebDAV Schema drop
//
////////////////////////////////////////////////////

// Drop Table WEBDAV_CONTAINER
// 
// Drop Table WEBDAV_INODE
// 
// Drop Table WEBDAV_NAME_SPACE
// 
// Drop Table WEBDAV_PROPERTY_MANAGEMENT
// 
// Drop Table WEBDAV_PROPERTY

////////////////////////////////////////////////////
//
// WebDAV Schema drop - End
//
////////////////////////////////////////////////////

////////////////////////////////////////////////////
//
// WEBDAV Schema for an ASCII database
//
////////////////////////////////////////////////////

Create Table WEBDAV_CONTAINER
(
   CId				Char(24)   Byte,
   Short_Content	Char(8000) Byte,
   Content			Long       Byte,

   Primary Key (Cid)
)

//

Create Table WEBDAV_INODE (
   Pid              Char(24)		Byte        ,
   Cid              Char(24)		Byte        ,
   Name             Char(998)                   ,
   State			Fixed(2)		Default 0	,
   CompressedLength Fixed(10)		Default 0   ,

   Primary Key (Pid, Name)                      ,


   Constraint WEBDAV_INODE_X Unique (Cid)
)

//

Create Table WEBDAV_NAME_SPACE (
    Id         Char(24)    Byte,
    Name_Space Char(1000)      ,
    
    Primary Key (Name_Space),
    Constraint WEBDAV_NAME_SPACE_X Unique (Id)
)

//

Create Table WEBDAV_PROPERTY_MANAGEMENT (
   Id                Char(24)   Byte,
   Name_Space_Id     Char(24)   Byte,
   Name_Prefix       Char(800)      ,
   Name              Char(4000)     ,

   Primary Key (Name_Space_Id, Name_Prefix)
)

//

Create Table WEBDAV_PROPERTY (
   CId                  Char(24)  Byte,

   Property_Id          Char(24)  Byte,
   Property_Short_Value Char(900)     ,
   Property_Long_Value  Long      Byte
)

//

Create Index WEBDAV_PROPERTY_X1 On WEBDAV_PROPERTY (Property_Id, CId)

//

Create Index WEBDAV_PROPERTY_X2 On WEBDAV_PROPERTY (Cid DESC)


////////////////////////////////////////////////////
//
// WEBDAV Schema for an ASCII database - End
//
////////////////////////////////////////////////////




////////////////////////////////////////////////////
//
// WEBDAV Schema for an UNICODE database
//
////////////////////////////////////////////////////

//Create Table WEBDAV_CONTAINER
//(
//   CId				Char(24)   Byte,
//   Short_Content	Char(8000) Byte,
//   Content			Long       Byte,
//
//   Primary Key (Cid)
//)

//

//Create Table WEBDAV_INODE (
//   Pid              Char(24)		Byte        ,
//   Cid              Char(24)		Byte        ,
//   Name             Char(499)                   ,
//   State			Fixed(2)		Default 0	,
//   CompressedLength Fixed(10)		Default 0   ,
//
//   Primary Key (Pid, Name)                      ,
//
//
//   Constraint WEBDAV_INODE_X Unique (Cid)
//)

//

//Create Table WEBDAV_NAME_SPACE (
//    Id         Char(24)    Byte,
//    Name_Space Char(499)      ,
//    
//    Primary Key (Name_Space),
//    Constraint WEBDAV_NAME_SPACE_X Unique (Id)
//)

//

//Create Table WEBDAV_PROPERTY_MANAGEMENT (
//   Id                Char(24)   Byte,
//   Name_Space_Id     Char(24)   Byte,
//   Name_Prefix       Char(400)      ,
//   Name              Char(2000)     ,
//
//   Primary Key (Name_Space_Id, Name_Prefix)
//)

//

Create Table WEBDAV_PROPERTY (
   CId                  Char(24)  Byte,

   Property_Id          Char(24)  Byte,
   Property_Short_Value Char(450)     ,
   Property_Long_Value  Long      Byte
)

//

//Create Index WEBDAV_PROPERTY_X1 On WEBDAV_PROPERTY (Property_Id, CId)

//

//Create Index WEBDAV_PROPERTY_X2 On WEBDAV_PROPERTY (Cid DESC)

////////////////////////////////////////////////////
//
// WEBDAV Schema for an UNICODE database - End
//
////////////////////////////////////////////////////

////////////////////////////////////////////////////
//
// WEBDAV Schema Init
//
// Following statements have to be inserted for
// ASCII and UNICODE databases
//
////////////////////////////////////////////////////

//
// Initial name space
//
Insert into WEBDAV_NAME_SPACE Set
  Id = X'000000000000000000000000000000000000000000000001',
  Name_Space = 'DAV:'


//
// Initial property types
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000001',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'displayname'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000002',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'resourcetype'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000003',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'getcontenttype'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000004',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'getcontentlength'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000005',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'getlastmodified'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000006',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'lockdiscovery'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000006',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'lockid'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000007',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'lockowner'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000008',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'locktype'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'000000000000000000000000000000000000000000000009',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'lockscope'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'00000000000000000000000000000000000000000000000A',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'locktimeout'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'00000000000000000000000000000000000000000000000B',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'lockdepth'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'00000000000000000000000000000000000000000000000C',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'supportedlock'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'00000000000000000000000000000000000000000000000D',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'docclassid'
//
Insert into WEBDAV_PROPERTY_MANAGEMENT Set
  Id = X'00000000000000000000000000000000000000000000000E',
  Name_Space_Id = X'000000000000000000000000000000000000000000000001',
  Name_Prefix = 'parsestate'

//
// Initial properties for ROOT
//
Insert into WEBDAV_PROPERTY Set
  CId = X'000000000000000000000000000000000000000000000000',
  Property_Id = X'000000000000000000000000000000000000000000000001',
  Property_Short_Value = '/'
//
Insert into WEBDAV_PROPERTY Set
  CId = X'000000000000000000000000000000000000000000000000',
  Property_Id = X'000000000000000000000000000000000000000000000002',
  Property_Short_Value = 'collection'
//
Insert into WEBDAV_PROPERTY Set
  CId = X'000000000000000000000000000000000000000000000000',
  Property_Id = X'000000000000000000000000000000000000000000000003',
  Property_Short_Value = 'sapdbwww/directory'
//
Insert into WEBDAV_PROPERTY Set
  CId = X'000000000000000000000000000000000000000000000000',
  Property_Id = X'000000000000000000000000000000000000000000000004',
  Property_Short_Value = '0'
//
Insert into WEBDAV_PROPERTY Set
  CId = X'000000000000000000000000000000000000000000000000',
  Property_Id = X'000000000000000000000000000000000000000000000005',
  Property_Short_Value = TIMESTAMP

////////////////////////////////////////////////////
//
// WebDAV Schema for databases before 74.03.09 - End
//
////////////////////////////////////////////////////
