reinit_slide.sql

来自「jetspeed源代码」· SQL 代码 · 共 47 行

delete from revisioncontent;
delete from property;
delete from label;
delete from revision;
delete from branches;
delete from latestrevisions;
delete from workingrevision;
delete from revisions;
delete from locks;
delete from permissions;
delete from links;
delete from children;
delete from objects;

insert into objects values('/catalog', 'org.apache.slide.structure.SubjectNode');
insert into revisions values('/catalog', 0, '1.0');
insert into revision values('/catalog', '1.0', 'main');
insert into latestrevisions values('/catalog', 'main', '1.0');


insert into property values (
'/catalog', '1.0',    'logicalName'   ,    'home'          ,                               'DAV:'    ,       '0', 0 ) ; 
insert into property values (
'/catalog', '1.0' ,   'resourceClassName', 'org.apache.jetspeed.om.cms.slide.SlideCatalog', 'DAV:'   ,        '0',0) ;        
insert into property values (
'/catalog', '1.0'  ,  'source'   ,        null    ,                                           'DAV:' ,          '0',0) ;        
insert into property values (
'/catalog', '1.0' ,   'parentUri'    ,     null,                             'DAV:'      ,     '0',0);         
insert into property values (
'/catalog', '1.0' ,   'getlastmodified' ,  'Tue, 12 Nov 2002 21:54:11 GMT'    ,             'DAV:'   ,        '0',0) ;        
insert into property values (
'/catalog', '1.0'  ,  'resourcetype'   ,   '<collection/>'           ,                      'DAV:'        ,   '1',0) ;        
insert into property values (
'/catalog', '1.0'  ,  'getcontentlength' , '0'       ,                                      'DAV:'      ,     '0',0) ;        
insert into property values (
'/catalog', '1.0' ,   'creationdate'   ,  '2002-11-12T21:54:11Z'        ,                  'DAV:'   ,        '0',0 ) ;       
insert into property values (
'/catalog', '1.0'   , 'title' ,            'Home'    ,                                     'DAV:'      ,     '0',0) ;        
insert into property values (
'/catalog', '1.0'  ,  'displayname'    ,   'Home'           ,                              'DAV:'  ,         '0',0);     



//  '+/users/turbine/groups/jetspeed' : reference to a group (Slide syntax)
//  '/users/turbine/users/christophe' : reference to a user (Slide syntax)
insert into permissions values ('/catalog', null, '/users/turbine/users/turbine', '/actions', 1, null);