gistfile1.diff

--- dso_development_directories.sql
+++ (clipboard)
@@ -12,101 +12,15 @@
   `full_path` varchar(250) default NULL,
   PRIMARY KEY  (`id`),
   KEY `fk_d_parish` (`parish_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=196 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;
 
 insert into `directories` values('1',null,'',null,'0','/'),
- ('2','1','organizations',null,'0','/organizations'),
- ('6','1','system_archive',null,'0','/system_archive'),
- ('7','1','Welcoming',null,'0','/Welcoming'),
  ('8','1','Who we are',null,'0','/Who we are'),
  ('9','1','How we work',null,'0','/How we work'),
  ('10','1','What we do',null,'0','/What we do'),
  ('11','1','Why we do what we do',null,'0','/Why we do what we do'),
- ('12','2','all-saints-cincinnati',null,'6','/organizations/all-saints-cincinnati'),
- ('13','2','all-saints-portsmouth',null,'7','/organizations/all-saints-portsmouth'),
- ('14','2','all-saints-new-albany',null,'8','/organizations/all-saints-new-albany'),
- ('15','2','ascension-holy-trinity-cincinn',null,'9','/organizations/ascension-holy-trinity-cincinn'),
- ('16','2','calvary-cincinnati',null,'10','/organizations/calvary-cincinnati'),
- ('17','2','christ-church-cathedral-cincin',null,'11','/organizations/christ-church-cathedral-cincin'),
- ('18','2','christ-glendale',null,'12','/organizations/christ-glendale'),
- ('19','2','christ-dayton',null,'13','/organizations/christ-dayton'),
- ('20','2','christ-springfield',null,'14','/organizations/christ-springfield'),
- ('21','2','christ-xenia',null,'15','/organizations/christ-xenia'),
- ('22','2','christ-ironton',null,'16','/organizations/christ-ironton'),
- ('23','2','church-of-our-saviour-mechanic',null,'17','/organizations/church-of-our-saviour-mechanic'),
- ('24','2','church-of-our-saviour-cincinna',null,'18','/organizations/church-of-our-saviour-cincinna'),
- ('25','2','church-of-the-advent-cincinnat',null,'19','/organizations/church-of-the-advent-cincinnat'),
- ('26','2','church-of-the-ascension-middle',null,'20','/organizations/church-of-the-ascension-middle'),
- ('27','2','epiphany-nelsonville',null,'21','/organizations/epiphany-nelsonville'),
- ('28','2','church-of-the-epiphany-urbana',null,'22','/organizations/church-of-the-epiphany-urbana'),
- ('29','2','church-of-the-good-samaritan-a',null,'23','/organizations/church-of-the-good-samaritan-a'),
- ('30','2','church-of-the-good-shepherd-at',null,'24','/organizations/church-of-the-good-shepherd-at'),
- ('31','2','church-of-the-redeemer-cincinn',null,'25','/organizations/church-of-the-redeemer-cincinn'),
- ('32','2','grace-cincinnati',null,'26','/organizations/grace-cincinnati'),
- ('33','2','grace-pomeroy',null,'27','/organizations/grace-pomeroy'),
- ('34','2','holy-spirit-cincinnati',null,'28','/organizations/holy-spirit-cincinnati'),
- ('35','2','holy-trinity-cincinnati',null,'29','/organizations/holy-trinity-cincinnati'),
- ('36','2','holy-trinity-oxford',null,'30','/organizations/holy-trinity-oxford'),
- ('37','2','indian-hill-cincinnati',null,'31','/organizations/indian-hill-cincinnati'),
- ('38','2','st-albans-columbus',null,'32','/organizations/st-albans-columbus'),
- ('39','2','st-andrews-dayton',null,'33','/organizations/st-andrews-dayton'),
- ('40','2','st-andrews-cincinnati',null,'34','/organizations/st-andrews-cincinnati'),
- ('41','2','st-andrews-pickerington',null,'35','/organizations/st-andrews-pickerington'),
- ('42','2','st-andrews-washington-court-ho',null,'36','/organizations/st-andrews-washington-court-ho'),
- ('43','2','st-annes-west-chester',null,'37','/organizations/st-annes-west-chester'),
- ('44','2','st-barnabas-cincinnati',null,'38','/organizations/st-barnabas-cincinnati'),
- ('45','2','st-christophers-fairborn',null,'39','/organizations/st-christophers-fairborn'),
- ('46','2','st-cyprian-of-carthage-columbu',null,'40','/organizations/st-cyprian-of-carthage-columbu'),
- ('47','2','st-edwards-columbus',null,'41','/organizations/st-edwards-columbus'),
- ('48','2','st-francis-springboro',null,'42','/organizations/st-francis-springboro'),
- ('49','2','st-georges-dayton',null,'43','/organizations/st-georges-dayton'),
- ('50','2','st-james-cincinnati',null,'44','/organizations/st-james-cincinnati'),
- ('51','2','st-james-columbus',null,'45','/organizations/st-james-columbus'),
- ('52','2','st-james-zanesville',null,'46','/organizations/st-james-zanesville'),
- ('53','2','st-james-piqua',null,'47','/organizations/st-james-piqua'),
- ('54','2','st-johns-lancaster',null,'48','/organizations/st-johns-lancaster'),
- ('55','2','st-johns-columbus',null,'49','/organizations/st-johns-columbus'),
- ('56','2','st-johns-cambridge',null,'50','/organizations/st-johns-cambridge'),
- ('57','2','st-johns-worthington',null,'51','/organizations/st-johns-worthington'),
- ('58','2','st-luke-cincinnati',null,'52','/organizations/st-luke-cincinnati'),
- ('59','2','st-luke-granville',null,'53','/organizations/st-luke-granville'),
- ('60','2','st-luke-marietta',null,'54','/organizations/st-luke-marietta'),
- ('61','2','st-margarets-dayton',null,'55','/organizations/st-margarets-dayton'),
- ('62','2','st-marks-dayton',null,'56','/organizations/st-marks-dayton'),
- ('63','2','st-marks-columbus',null,'57','/organizations/st-marks-columbus'),
- ('64','2','st-mary-magdalene-maineville',null,'58','/organizations/st-mary-magdalene-maineville'),
- ('65','2','st-marys-waynesville',null,'59','/organizations/st-marys-waynesville'),
- ('66','2','st-marys-hillsboro',null,'60','/organizations/st-marys-hillsboro'),
- ('67','2','st-matthews-westerville',null,'61','/organizations/st-matthews-westerville'),
- ('68','2','st-patricks-dublin',null,'62','/organizations/st-patricks-dublin'),
- ('69','2','st-patricks-lebanon',null,'63','/organizations/st-patricks-lebanon'),
- ('70','2','st-pauls-logan',null,'64','/organizations/st-pauls-logan'),
- ('71','2','st-pauls-martins-ferry',null,'65','/organizations/st-pauls-martins-ferry'),
- ('72','2','st-pauls-greenville',null,'66','/organizations/st-pauls-greenville'),
- ('73','2','st-pauls-dayton',null,'67','/organizations/st-pauls-dayton'),
- ('74','2','st-pauls-chillicothe',null,'68','/organizations/st-pauls-chillicothe'),
- ('75','2','st-peters-delaware',null,'69','/organizations/st-peters-delaware'),
- ('76','2','st-peters-gallipolis',null,'70','/organizations/st-peters-gallipolis'),
- ('77','2','st-philips-circleville',null,'71','/organizations/st-philips-circleville'),
- ('78','2','st-philips-cincinnati',null,'72','/organizations/st-philips-cincinnati'),
- ('79','2','st-philips-columbus',null,'73','/organizations/st-philips-columbus'),
- ('80','2','st-simon-of-cyrene-cincinnati',null,'74','/organizations/st-simon-of-cyrene-cincinnati'),
- ('81','2','st-stephens-cincinnati',null,'75','/organizations/st-stephens-cincinnati'),
- ('82','2','st-stephens-columbus',null,'76','/organizations/st-stephens-columbus'),
- ('83','2','st-thomas-terrace-park',null,'77','/organizations/st-thomas-terrace-park'),
- ('84','2','st-timothy-cincinnati',null,'78','/organizations/st-timothy-cincinnati'),
- ('85','2','the-bishops-center-columbus',null,'79','/organizations/the-bishops-center-columbus'),
- ('86','2','trinity-bellaire',null,'80','/organizations/trinity-bellaire'),
- ('87','2','trinity-columbus',null,'81','/organizations/trinity-columbus'),
- ('88','2','trinity-london',null,'82','/organizations/trinity-london'),
- ('89','2','trinity-mc-arthur',null,'83','/organizations/trinity-mc-arthur'),
- ('90','2','trinity-hamilton',null,'84','/organizations/trinity-hamilton'),
- ('91','2','trinity-newark',null,'85','/organizations/trinity-newark'),
- ('92','2','trinity-troy',null,'86','/organizations/trinity-troy'),
  ('93','1','Where We Are',null,'0','/Where We Are'),
  ('94','1','When Things Are',null,'0','/When Things Are'),
- ('95','2','parishhealth',null,'91','/organizations/parishhealth'),
- ('96','2','supplyclergy',null,'92','/organizations/supplyclergy'),
  ('97','2','retiredclergy',null,'93','/organizations/retiredclergy'),
  ('98','2','deacons',null,'94','/organizations/deacons'),
  ('99','2','eco-cluster',null,'95','/organizations/eco-cluster'),
@@ -147,15 +61,10 @@
  ('137','79','Youth',null,'73','/organizations/st-philips-columbus/Youth'),
  ('138','79','Calendar',null,'73','/organizations/st-philips-columbus/Calendar'),
  ('139','79','Communicant',null,'73','/organizations/st-philips-columbus/Communicant'),
- ('140','79','Contact Us',null,'73','/organizations/st-philips-columbus/Contact Us'),
  ('141','79','Maps and Directions',null,'73','/organizations/st-philips-columbus/Maps and Directions'),
  ('142','22','What\'s New',null,'16','/organizations/christ-ironton/What\'s New'),
  ('144','32','test site',null,'26','/organizations/grace-cincinnati/test site'),
  ('146','55','Worship',null,'49','/organizations/st-johns-columbus/Worship'),
- ('147','55','Community Ministries',null,'49','/organizations/st-johns-columbus/Community Ministries'),
- ('148','55','Calendar',null,'49','/organizations/st-johns-columbus/Calendar'),
- ('149','55','Newsletters',null,'49','/organizations/st-johns-columbus/Newsletters'),
- ('150','55','Activities and Events',null,'49','/organizations/st-johns-columbus/Activities and Events'),
  ('151','2','youth',null,'104','/organizations/youth'),
  ('152','151','Genesis Retreat Program',null,'104','/organizations/youth/Genesis Retreat Program'),
  ('153','151','Exodus Retreat Program',null,'104','/organizations/youth/Exodus Retreat Program'),
@@ -164,31 +73,15 @@
  ('156','151','Resources',null,'104','/organizations/youth/Resources'),
  ('157','2','transfiguration',null,'105','/organizations/transfiguration'),
  ('163','38','Music',null,'32','/organizations/st-albans-columbus/Music'),
- ('164','38','Formation',null,'32','/organizations/st-albans-columbus/Formation'),
  ('165','2','anglicanacademy',null,'106','/organizations/anglicanacademy'),
  ('166','27','OUTREACH',null,'21','/organizations/epiphany-nelsonville/OUTREACH'),
  ('167','27','PRIEST\'S PAGES',null,'21','/organizations/epiphany-nelsonville/PRIEST\'S PAGES'),
  ('168','27','HISTORY',null,'21','/organizations/epiphany-nelsonville/HISTORY'),
  ('169','27','COMMUNITY',null,'21','/organizations/epiphany-nelsonville/COMMUNITY'),
- ('170','82','students',null,'76','/organizations/st-stephens-columbus/students'),
  ('171','2','goodearth',null,'107','/organizations/goodearth'),
- ('172','26','Youth',null,'20','/organizations/church-of-the-ascension-middle/Youth'),
  ('173','42','ABOUT ST. ANDREW\'S',null,'36','/organizations/st-andrews-washington-court-ho/ABOUT ST. ANDREW\'S'),
- ('174','42','WORSHIP',null,'36','/organizations/st-andrews-washington-court-ho/WORSHIP'),
  ('180','32','Mission Council/Vestry Minutes',null,'26','/organizations/grace-cincinnati/Mission Council/Vestry Minutes'),
  ('181','32','eGraceNotes Newsletter',null,'26','/organizations/grace-cincinnati/eGraceNotes Newsletter'),
- ('183','42','FELLOWSHIP',null,'36','/organizations/st-andrews-washington-court-ho/FELLOWSHIP'),
- ('184','42','CHRISTIAN FORMATION',null,'36','/organizations/st-andrews-washington-court-ho/CHRISTIAN FORMATION'),
- ('185','42','PASTORAL CARE',null,'36','/organizations/st-andrews-washington-court-ho/PASTORAL CARE'),
- ('186','42','GLOBAL AND COMMUNITY OUTREACH',null,'36','/organizations/st-andrews-washington-court-ho/GLOBAL AND COMMUNITY OUTREACH'),
- ('187','42','EVANGELISM AND CHURCH GROWTH',null,'36','/organizations/st-andrews-washington-court-ho/EVANGELISM AND CHURCH GROWTH'),
- ('188','42','PICTURE GALLERY',null,'36','/organizations/st-andrews-washington-court-ho/PICTURE GALLERY'),
- ('189','42','CALENDAR',null,'36','/organizations/st-andrews-washington-court-ho/CALENDAR'),
- ('190','42','NEWS',null,'36','/organizations/st-andrews-washington-court-ho/NEWS'),
- ('191','42','VICAR\'S BLOG',null,'36','/organizations/st-andrews-washington-court-ho/VICAR\'S BLOG'),
- ('192','42','YOUTH PAGE',null,'36','/organizations/st-andrews-washington-court-ho/YOUTH PAGE'),
- ('193','42','CHILDREN\'S PAGE',null,'36','/organizations/st-andrews-washington-court-ho/CHILDREN\'S PAGE'),
- ('194','42','ONLINE MEDITATIONS & DEVOTIONS',null,'36','/organizations/st-andrews-washington-court-ho/ONLINE MEDITATIONS & DEVOTIONS'),
- ('195','60','vine',null,'54','/organizations/st-luke-marietta/vine');
+ ('196','1','system_archive',null,'0','/system_archive');
 
 SET FOREIGN_KEY_CHECKS = 1;