--
-- Host: localhost    Database: wlcm
-- ------------------------------------------------------


--
-- Table structure for table `adminuser_role`
--

CREATE TABLE `adminuser_role` (
  `adminuser_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`adminuser_id`,`role_id`),
  KEY `adminuser_role_role_id_foreign` (`role_id`),
  CONSTRAINT `adminuser_role_adminuser_id_foreign` FOREIGN KEY (`adminuser_id`) REFERENCES `adminusers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `adminuser_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adminuser_role`
--

INSERT INTO `adminuser_role` VALUES (4,1),(4,2),(5,1),(5,2),(6,1),(7,2),(8,2),(9,2),(10,2),(11,2);

--
-- Table structure for table `affiliation_types`
--

CREATE TABLE `affiliation_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `affiliation_types`
--

INSERT INTO `affiliation_types` VALUES (1,'AA','2018-05-03 03:01:39','2018-05-03 03:01:39'),(2,'Al-Anon','2018-05-03 03:01:39','2018-05-03 03:01:39'),(3,'Alateen','2020-10-31 02:57:16','2020-10-31 02:57:16'),(4,'ACA','2020-10-31 02:57:16','2020-10-31 02:57:16'),(5,'AA/Al-Anon','2020-10-31 02:57:16','2020-10-31 02:57:16'),(6,'Guest','2020-10-31 02:57:16','2020-10-31 02:57:16'),(7,'Spanish AA','2023-10-01 23:16:02','2023-10-01 23:16:02'),(8,'Spanish Al-Anon','2023-10-01 23:16:02','2023-10-01 23:16:02');

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `user_id` int(11) DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `announcement` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` VALUES (2,0,NULL,NULL,'Tip: <a class=\"underline\" href=\"/user/profile\">Verify your phone</a> to get text reminders for meetings','2023-01-25 08:34:33','2023-09-21 18:58:58'),(3,0,12,'2023-01-28 18:47:07','Bob: FSYA User Specific announcements are working','2023-01-27 14:42:09','2023-01-28 18:47:07');

--
-- Table structure for table `area_meeting_tsml`
--

CREATE TABLE `area_meeting_tsml` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `start_at` time NOT NULL,
  `day` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `region` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `sub_district` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `website_2` varchar(255) DEFAULT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `venmo` varchar(255) DEFAULT NULL,
  `square` varchar(255) DEFAULT NULL,
  `paypal` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `group_notes` varchar(255) DEFAULT NULL,
  `contact_1_name` varchar(255) DEFAULT NULL,
  `contact_1_email` varchar(255) DEFAULT NULL,
  `contact_1_phone` varchar(255) DEFAULT NULL,
  `contact_2_name` varchar(255) DEFAULT NULL,
  `contact_2_email` varchar(255) DEFAULT NULL,
  `contact_2_phone` varchar(255) DEFAULT NULL,
  `contact_3_name` varchar(255) DEFAULT NULL,
  `contact_3_email` varchar(255) DEFAULT NULL,
  `contact_3_phone` varchar(255) DEFAULT NULL,
  `last_contact` varchar(255) DEFAULT NULL,
  `conference_url` varchar(255) DEFAULT NULL,
  `conference_url_notes` varchar(255) DEFAULT NULL,
  `conference_phone` varchar(255) DEFAULT NULL,
  `conference_phone_notes` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `data_source` varchar(255) DEFAULT NULL,
  `updated` varchar(255) DEFAULT NULL,
  `tsml_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area_meeting_tsml`
--

INSERT INTO `area_meeting_tsml` VALUES (1,'05:30:00','Thursday','Thursday Women\'s Serenity','','','Pismo Beach',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42'),(2,'05:30:00','Monday','Monday Open Hearts','','','Arroyo Grande',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42'),(3,'05:30:00','Monday','Monday Morning Cayucos','','','Cayucos',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42'),(4,'05:30:00','Thursday','Thursday, SLO Courage to Change','','','San Luis Obispo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42'),(5,'05:30:00','Monday','Ojai AFG','','','Ojai',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42'),(6,'05:30:00','Monday','AFG Works','','','Ojai',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,'','',NULL,'','','2023-12-07 03:24:42','2023-12-07 03:24:42');

--
-- Table structure for table `area_meeting_tsml_import`
--

CREATE TABLE `area_meeting_tsml_import` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `start_at` time NOT NULL,
  `day` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `region` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `sub_district` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `website_2` varchar(255) DEFAULT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `venmo` varchar(255) DEFAULT NULL,
  `square` varchar(255) DEFAULT NULL,
  `paypal` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `group_notes` varchar(255) DEFAULT NULL,
  `contact_1_name` varchar(255) DEFAULT NULL,
  `contact_1_email` varchar(255) DEFAULT NULL,
  `contact_1_phone` varchar(255) DEFAULT NULL,
  `contact_2_name` varchar(255) DEFAULT NULL,
  `contact_2_email` varchar(255) DEFAULT NULL,
  `contact_2_phone` varchar(255) DEFAULT NULL,
  `contact_3_name` varchar(255) DEFAULT NULL,
  `contact_3_email` varchar(255) DEFAULT NULL,
  `contact_3_phone` varchar(255) DEFAULT NULL,
  `last_contact` varchar(255) DEFAULT NULL,
  `conference_url` varchar(255) DEFAULT NULL,
  `conference_url_notes` varchar(255) DEFAULT NULL,
  `conference_phone` varchar(255) DEFAULT NULL,
  `conference_phone_notes` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `data_source` varchar(255) DEFAULT NULL,
  `updated` varchar(255) DEFAULT NULL,
  `tsml_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area_meeting_tsml_import`
--


--
-- Table structure for table `area_meetings`
--

CREATE TABLE `area_meetings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `start_at` time DEFAULT NULL,
  `meeting_type_id` int(11) NOT NULL DEFAULT 1,
  `affiliation_type_id` int(11) NOT NULL DEFAULT 1,
  `location_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=587 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `area_meetings`
--

INSERT INTO `area_meetings` VALUES (1,'Valley Club - Grapevine Book Study','valley-club-grapevine-book-study',0,'05:30:00',12,1,56,NULL,NULL),(2,'As Bill Sees It','as-bill-sees-it-5',1,'06:00:00',12,1,41,NULL,NULL),(3,'Winners Attitude Adjustment','winners-attitude-adjustment-7',0,'07:00:00',12,1,87,NULL,NULL),(4,'New Attitude','new-attitude-4',0,'07:00:00',12,1,12,NULL,NULL),(5,'Doing the Deal Step Study Men','doing-the-deal-step-study',0,'07:00:00',12,1,24,NULL,NULL),(6,'New Day Zooming - Closed, Men Men','new-day-zooming-closed-men-7',0,'07:00:00',12,1,46,NULL,NULL),(7,'Shakers Zoom Participation','shakers-zoom-participation',0,'07:00:00',12,1,34,NULL,NULL),(8,'A Gathering Of Men Men','a-gathering-of-men-7',0,'07:00:00',12,1,79,NULL,NULL),(9,'Shakers Speaker and Participation','shakers-speaker-and-participation-2',0,'07:00:00',12,1,35,NULL,NULL),(10,'Unit A - Eye Opener','unit-a-eye-opener',0,'07:00:00',12,1,50,NULL,NULL),(11,'Valley Club - Participation','valley-club-eye-opener',0,'07:00:00',12,1,56,NULL,NULL),(12,'The End Of The Line - Men\'s Stag','the-end-of-the-line-mens-stag-7',0,'07:15:00',12,1,33,NULL,NULL),(13,'Spiritual Discussion','spiritual-discussion-5',0,'08:00:00',12,1,26,NULL,NULL),(14,'11th Step Participation','11th-step-participation',0,'08:00:00',12,1,90,NULL,NULL),(15,'Tales of Two Cities','tales-of-two-cities',0,'09:00:00',12,1,67,NULL,NULL),(16,'Rule 62','rule-62-7',0,'09:00:00',12,1,66,NULL,NULL),(17,'Sunday Morning Speaker','sunday-morning-speaker',0,'09:00:00',12,1,71,NULL,NULL),(18,'Beeman Park','beeman-park-6',0,'09:00:00',12,1,78,NULL,NULL),(19,'Shakers 12 & 12','shakers-12-12',0,'09:00:00',12,1,35,NULL,NULL),(20,'Unit A - All-R-Welcomed Book Study','unit-a-12',0,'09:00:00',12,1,101,NULL,NULL),(21,'Unit A - Just for Today (aka Wild West)','unit-a-6',0,'09:00:00',12,1,50,NULL,NULL),(22,'Burbank Meditation and Discussion','burbank-meditation-and-discussion',0,'09:00:00',12,1,18,NULL,NULL),(23,'Valley Club - Sunday AM Speaker','valley-club-sunday-am-speaker',0,'09:00:00',12,1,56,NULL,NULL),(24,'Speakeasy','speakeasy-7',0,'09:30:00',12,1,66,NULL,NULL),(25,'Canoga Park Sunday Speaker','canoga-park-sunday-speaker',0,'10:00:00',12,1,25,NULL,NULL),(26,'Hole in the Sky - Womens Stag Women','newcomers-big-book-study',0,'10:30:00',12,1,41,NULL,NULL),(27,'Squirrelly on Sunday','squirrelly-on-sunday-2',0,'10:30:00',12,1,31,NULL,NULL),(28,'Women\'s Wake Up Call Book Study Women','womens-wake-up-call-book-study',0,'11:00:00',12,1,44,NULL,NULL),(29,'Pacoima Beginners Participation','pacoima-beginners-participation',0,'11:00:00',12,1,57,NULL,NULL),(30,'Speaker','speaker-5',0,'11:00:00',12,1,65,NULL,NULL),(31,'Woodley Park Big Book Study','woodly-park-big-book-study',0,'11:30:00',12,1,64,NULL,NULL),(32,'LGBTQIA Meditation & Discussion','lgbtqia-meditation-discussion',0,'18:00:00',12,1,66,NULL,NULL),(33,'Moorpark','moorpark-2',0,'18:00:00',12,1,77,NULL,NULL),(34,'Spirit of Studio 12 Laugh-In','spirit-of-studio-12-laugh-in',0,'18:00:00',12,1,46,NULL,NULL),(35,'Big Book Study','big-book-study-4',0,'18:00:00',12,1,56,NULL,NULL),(36,'Hole in the Sky - Big Book Study','hole-in-the-sky-big-book-study-3',0,'12:30:00',12,1,27,NULL,NULL),(37,'Valley Club - Discussion','valley-club-discussion-3',0,'15:00:00',12,1,56,NULL,NULL),(38,'Freedom (Spanish)','freedom-spanish',0,'15:30:00',12,1,65,NULL,NULL),(39,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-7',0,'16:00:00',12,1,66,NULL,NULL),(40,'Unit A - Women\'s Book Study Women','unit-a-womens-book-study',0,'16:00:00',12,1,50,NULL,NULL),(41,'Hole in the Sky - Participation','hole-in-the-sky-meeting-at-hits',0,'16:30:00',12,1,26,NULL,NULL),(42,'Participation','participation-14',0,'16:30:00',12,1,26,NULL,NULL),(43,'W.A.R.G. Newcomers Meeting','w-a-r-g-newcomers-meeting',0,'16:30:00',12,1,80,NULL,NULL),(44,'Men\'s Stag 12 & 12 Men','mens-stag-12-12',0,'17:00:00',12,1,65,NULL,NULL),(45,'Burbank Round Robin','burbank-round-robin',0,'17:00:00',12,1,20,NULL,NULL),(46,'Pacoima Participation','pacoima-participation-8',0,'17:30:00',12,1,57,NULL,NULL),(47,'Sunday Speaker','sunday-speaker-3',0,'18:00:00',12,1,41,NULL,NULL),(48,'Sunday on Strathern','sunday-on-strathern',0,'18:00:00',12,1,60,NULL,NULL),(49,'How It Works','how-it-works-8',0,'18:00:00',12,1,44,NULL,NULL),(50,'Just the Black Print Big Book Study','just-the-black-print-big-book-study',0,'18:00:00',12,1,85,NULL,NULL),(51,'Unit A - A Piece of Serenity','unit-a-a-piece-of-serenity',0,'18:00:00',12,1,50,NULL,NULL),(52,'Fellowship Of The Spirit Big Book Study','fellowship-of-the-spirit-big-book-study',0,'18:00:00',12,1,73,NULL,NULL),(53,'Big Book Study Participation','big-book-study-participation',0,'18:00:00',12,1,56,NULL,NULL),(54,'Live & Let Live Speaker (LGBTQ)','live-let-live-speaker-gay',0,'18:30:00',12,1,77,NULL,NULL),(55,'Young People','young-people',0,'18:30:00',12,1,38,NULL,NULL),(56,'WH Action Speaker/Participation','wh-action-speaker-participation',0,'18:30:00',12,1,96,NULL,NULL),(57,'Toluca Lake Speaker','toluca-lake-speaker',0,'19:00:00',12,1,12,NULL,NULL),(58,'Hope Through Sharing - Leader/Discussion','hope-through-sharing-leader-discussion',0,'19:00:00',12,1,9,NULL,NULL),(59,'Hills Have Eyez','hills-have-eyez',0,'19:00:00',12,1,14,NULL,NULL),(60,'As Bill Sees It','as-bill-sees-it-7',0,'19:00:00',12,1,15,NULL,NULL),(61,'Glendale Recovery for Newcomers','glendale-recovery-for-newcomers',0,'19:00:00',12,1,34,NULL,NULL),(62,'The Glum Nots Speaker','the-glum-not-speaker',0,'19:00:00',12,1,68,NULL,NULL),(63,'All in or All out','all-in-or-all-out',0,'19:00:00',12,1,64,NULL,NULL),(64,'Grateful Camels Men','grateful-camels',0,'19:00:00',12,1,65,NULL,NULL),(65,'Speaker','speaker-2',0,'19:00:00',12,1,65,NULL,NULL),(66,'Burbank Step Study','burbank-step-study',0,'19:00:00',12,1,20,NULL,NULL),(67,'Sunday Speaker','sunday-speaker-4',0,'19:30:00',12,1,24,NULL,NULL),(68,'Beginners Candlelight Discussion','beginners-candlelight-discussion-2',0,'19:30:00',12,1,100,NULL,NULL),(69,'Back to Basics','back-to-basics',0,'20:00:00',12,1,56,NULL,NULL),(70,'Burbank Promises Candlelight Speaker/Participation','burbank-promises-candlelight-speaker-participation',0,'21:00:00',12,1,20,NULL,NULL),(71,'Valley Club - Big Book Study/Participation','valley-club-big-book-study-participation',1,'05:30:00',12,1,56,NULL,NULL),(72,'Big Book','big-book',1,'06:00:00',12,1,41,NULL,NULL),(73,'WAA On Awakening','waa-on-awakening',1,'06:30:00',12,1,48,NULL,NULL),(74,'The Solution Meeting - Men Men','the-solution-meeting-closed-men',1,'06:45:00',12,1,24,NULL,NULL),(75,'Spiritual Discussion','spiritual-discussion',1,'06:45:00',12,1,26,NULL,NULL),(76,'Winners Attitude Adjustment','winners-attitude-adjustment',1,'07:00:00',12,1,87,NULL,NULL),(77,'Attitude Adjustment','attitude-adjustment',1,'07:00:00',12,1,88,NULL,NULL),(78,'New Day Zooming - Closed, Men','new-day-zooming-closed-men',1,'07:00:00',12,1,46,NULL,NULL),(79,'Shakers Zoom Participation','shakers-zoom-participation-2',1,'07:00:00',12,1,34,NULL,NULL),(80,'Valley Club - Topic Discussion','valley-club-topic-discussion',1,'07:00:00',12,1,53,NULL,NULL),(81,'A Gathering Of Men Men','a-gathering-of-men',1,'07:00:00',12,1,79,NULL,NULL),(82,'Shakers Participation','shakers-participation',1,'07:00:00',12,1,35,NULL,NULL),(83,'SFV 8AM Online','sfv-8am-online',1,'08:00:00',12,1,66,NULL,NULL),(84,'Discussion','discussion',1,'08:00:00',12,1,65,NULL,NULL),(85,'Coffee Pot & Resentment Step Study','coffee-pot-resentment-stp-stdy',1,'09:00:00',12,1,75,NULL,NULL),(86,'Rule 62','rule-62',1,'09:00:00',12,1,66,NULL,NULL),(87,'Beeman Park','beeman-park',1,'09:00:00',12,1,78,NULL,NULL),(88,'Unit A - All-R-Welcomed Book Study','unit-a',1,'09:00:00',12,1,101,NULL,NULL),(89,'Unit A - All-R-Welcomed Book Study','unit-a-all-r-welcomed-book-study',1,'09:00:00',12,1,50,NULL,NULL),(90,'Good Morning Participation','good-morning-participation',1,'09:00:00',12,1,80,NULL,NULL),(91,'Valley Club - Freedom','valley-club-freedom',1,'09:00:00',12,1,56,NULL,NULL),(92,'Whitefire Speaker','whitefire-speaker',1,'09:00:00',12,1,74,NULL,NULL),(93,'Speakeasy','speakeasy',1,'09:30:00',12,1,66,NULL,NULL),(94,'Ladies\' Morning Step Study Women','ladies-morning-step-study',1,'10:30:00',12,1,27,NULL,NULL),(95,'Serenity With Sobriety','serenity-with-sobriety',1,'11:30:00',12,1,89,NULL,NULL),(96,'Monday Noon Daily Reflections','monday-noon-daily-reflections',1,'18:00:00',12,1,11,NULL,NULL),(97,'Topic Discussion','topic-discussion',1,'18:00:00',12,1,44,NULL,NULL),(98,'High Noon Hope','high-noon-hope',1,'18:00:00',12,1,10,NULL,NULL),(99,'Hole in the Sky - Big Book Study','hole-in-the-sky-big-book-study',1,'18:00:00',12,1,27,NULL,NULL),(100,'Women\'s Zoom Room Big Book - Open, Women Women','womens-zoom-room-big-book-open-women',1,'18:00:00',12,1,42,NULL,NULL),(101,'The End Of The Line - Men\'s Stag Men','the-end-of-the-line-mens-stag',1,'18:00:00',12,1,32,NULL,NULL),(102,'Open Participation','open-participation',1,'18:00:00',12,1,65,NULL,NULL),(103,'Good Day Speaker','good-day-speaker',1,'18:00:00',12,1,80,NULL,NULL),(104,'The Lunch Bunch','the-lunch-bunch',1,'18:00:00',12,1,20,NULL,NULL),(105,'Valley Club - Old Timers\' Meeting','valley-club-old-timers-meeting',1,'18:00:00',12,1,56,NULL,NULL),(106,'Happy, Joyous at Three','happy-joyous-at-three',1,'15:00:00',12,1,77,NULL,NULL),(107,'Valley Club - Discussion','valley-club-discussion',1,'15:00:00',12,1,53,NULL,NULL),(108,'Pacoima Participation','pacoima-participation',1,'17:30:00',12,1,57,NULL,NULL),(109,'Topic Discussion','topic-discussion-2',1,'17:30:00',12,1,65,NULL,NULL),(110,'Men\'s Stag Men','mens-stag-2',1,'18:00:00',12,1,26,NULL,NULL),(111,'How It Works','how-it-works-2',1,'18:00:00',12,1,44,NULL,NULL),(112,'As Bill Sees It (Women) Women','as-bill-sees-it-women',1,'18:00:00',12,1,17,NULL,NULL),(113,'Burbank Men\'s Crosstalk Discussion - hybrid','burbank-mens-crosstalk-discussion-hybrid',1,'18:00:00',12,1,17,NULL,NULL),(114,'Hole in the Sky - Men\'s Stag','hole-in-the-sky-mens-stag-closed',1,'18:00:00',12,1,27,NULL,NULL),(115,'Unit A - Newcomers','unit-a-beginners',1,'18:00:00',12,1,50,NULL,NULL),(116,'Burbank Men\'s Crosstalk Discussion Men','burbank-mens-crosstalk-discussion',1,'18:00:00',12,1,20,NULL,NULL),(117,'Women\'s Stag Women','womens-stag',1,'18:00:00',12,1,56,NULL,NULL),(118,'Sobriety First Women','sobriety-first-3',1,'18:30:00',12,1,29,NULL,NULL),(119,'Newcomers Participation','newcomers-participation',1,'18:30:00',12,1,41,NULL,NULL),(120,'Hole in the Sky - Spiritual Discussion','hole-in-the-sky-spiritual-discussion',1,'18:45:00',12,1,27,NULL,NULL),(121,'We Are Not Saints Women','we-are-not-saints-2',1,'19:00:00',12,1,87,NULL,NULL),(122,'Stags Of Sobriety (Cabrito House) Men','stags-of-sobriety-cabrito-house',1,'19:00:00',12,1,24,NULL,NULL),(123,'Encino Hills Speaker','encino-hills-speaker',1,'19:00:00',12,1,70,NULL,NULL),(124,'LGBTQIA Our History and Sobriety','lgbtqia-our-history-and-sobriety',1,'19:00:00',12,1,66,NULL,NULL),(125,'Women to Women Women','women-to-women',1,'19:00:00',12,1,61,NULL,NULL),(126,'Northridge Women\'s Book Study Women','northridge-womens-bk-study',1,'19:00:00',12,1,54,NULL,NULL),(127,'Trudging Buddies Women','trudging-buddies',1,'19:00:00',12,1,35,NULL,NULL),(128,'Sobriety Together Discussion','sobriety-together-discussion',1,'19:00:00',12,1,37,NULL,NULL),(129,'Chapter 12 Men\'s Stag Men','chapter-12-mens-stag-2',1,'19:30:00',12,1,75,NULL,NULL),(130,'West Valley Participation','west-valley-participation',1,'19:30:00',12,1,52,NULL,NULL),(131,'Book Study','book-study',1,'19:30:00',12,1,58,NULL,NULL),(132,'Quality of Life Book Study, Closed','quality-of-life-book-study-closed',1,'19:30:00',12,1,90,NULL,NULL),(133,'Reach Out Discussion','reach-out-discussion',1,'19:30:00',12,1,95,NULL,NULL),(134,'Staying in the Now Big Book Study','staying-in-the-now-big-book-study',1,'19:30:00',12,1,95,NULL,NULL),(135,'Pacoima Participation','pacoima-participation-2',1,'19:30:00',12,1,57,NULL,NULL),(136,'Quality of Life Book Study','quality-of-life-book-study',1,'19:30:00',12,1,64,NULL,NULL),(137,'Open Discussion','open-discussion',1,'19:30:00',12,1,65,NULL,NULL),(138,'Just the Italics','just-the-italics',1,'19:30:00',12,1,80,NULL,NULL),(139,'Prime Time Women\'s Solution Women','prime-time-womens-solution',1,'19:30:00',12,1,73,NULL,NULL),(140,'Solutions by the Steps Women','solutions-by-the-steps',1,'19:30:00',12,1,73,NULL,NULL),(141,'Shoup Group Big Book Study','shoup-group-big-book-study',1,'19:30:00',12,1,98,NULL,NULL),(142,'Shadow Ranch Big Book Study','shadow-ranch-big-book-study',1,'19:30:00',12,1,99,NULL,NULL),(143,'Reach Out Speaker/Discussion','reach-out-speaker-discussion',1,'19:30:00',12,1,100,NULL,NULL),(144,'We Do Recover','we-do-recover',1,'20:00:00',12,1,44,NULL,NULL),(145,'Wobblies Discussion Men','wobblies-discussion',1,'20:00:00',12,1,76,NULL,NULL),(146,'Astoria St Discussion','astoria-st-discussion',1,'20:00:00',12,1,82,NULL,NULL),(147,'Living in the Solutions - LGBTQ+, hybrid','living-in-the-solutions-lgbtq-hybrid',1,'20:00:00',12,1,50,NULL,NULL),(148,'Unit A - LGBTQ+ Meeting','unit-a-lgbtq-meeting',1,'20:00:00',12,1,50,NULL,NULL),(149,'Nitty Gritty Women\'s Discussion Women','nitty-gritty-womens-discussion',1,'20:00:00',12,1,73,NULL,NULL),(150,'Prime Time Men\'s Stag Men','prime-time-mens-stag-2',1,'20:00:00',12,1,73,NULL,NULL),(151,'Burbank Open Participation - hybrid','burbank-open-participation-hybrid',1,'20:00:00',12,1,20,NULL,NULL),(152,'Speaker','speaker-3',1,'20:00:00',12,1,56,NULL,NULL),(153,'West Valley Men\'s 12&12 Men','west-valley-mens-1212',1,'20:00:00',12,1,100,NULL,NULL),(154,'Participation','participation-15',1,'20:30:00',12,1,69,NULL,NULL),(155,'Burbank Participation - hybrid','burbank-participation-hybrid',1,'22:00:00',12,1,20,NULL,NULL),(156,'Valley Club - Big Book Passage Discussion','valley-club-big-book-passage-discussion',2,'05:30:00',12,1,56,NULL,NULL),(157,'Daily Reflections','daily-reflections',2,'06:00:00',12,1,41,NULL,NULL),(158,'WAA On Awakening','waa-on-awakening-2',2,'06:30:00',12,1,48,NULL,NULL),(159,'The Solution Meeting - Closed, Men Men','the-solution-meeting-closed-men-2',2,'06:45:00',12,1,24,NULL,NULL),(160,'Spiritual Discussion','spiritual-discussion-2',2,'06:45:00',12,1,26,NULL,NULL),(161,'Hole in the Sky - Spiritual Discussion','hole-in-the-sky-spiritual-discussion-2',2,'06:45:00',12,1,27,NULL,NULL),(162,'Wake Up Group','wake-up-group',2,'06:45:00',12,1,62,NULL,NULL),(163,'Winners Attitude Adjustment','winners-attitude-adjustment-2',2,'07:00:00',12,1,87,NULL,NULL),(164,'New Attitude','new-attitude',2,'07:00:00',12,1,12,NULL,NULL),(165,'New Day Zooming - Closed, Men Men','new-day-zooming-closed-men-2',2,'07:00:00',12,1,46,NULL,NULL),(166,'Shakers Zoom Participation','shakers-zoom-participation-3',2,'07:00:00',12,1,34,NULL,NULL),(167,'A Gathering Of Men Men','a-gathering-of-men-2',2,'07:00:00',12,1,79,NULL,NULL),(168,'Shakers Participation','shakers-participation-2',2,'07:00:00',12,1,35,NULL,NULL),(169,'A New Day Dawning Discussion Men','a-new-day-dawning-disc',2,'07:00:00',12,1,49,NULL,NULL),(170,'Valley Club - Big Book Study/Participation','valley-club-big-book-study-participation-2',2,'07:00:00',12,1,56,NULL,NULL),(171,'SFV 8AM Online','sfv-8am-online-2',2,'08:00:00',12,1,66,NULL,NULL),(172,'Open Discussion','open-discussion-2',2,'08:00:00',12,1,65,NULL,NULL),(173,'Growing Into Ladies Big Book/Discussion Women','growing-into-ladies-big-bk-disc',2,'09:00:00',12,1,75,NULL,NULL),(174,'Big Book Study','big-book-study-5',2,'09:00:00',12,1,77,NULL,NULL),(175,'Rule 62','rule-62-2',2,'09:00:00',12,1,66,NULL,NULL),(176,'Beeman Park','beeman-park-2',2,'09:00:00',12,1,78,NULL,NULL),(177,'Unit A - All-R-Welcomed Book Study','unit-a-all-r-welcomed-book-study-2',2,'09:00:00',12,1,50,NULL,NULL),(178,'Unit A - All-R-Welcomed Book Study','unit-a-7',2,'09:00:00',12,1,101,NULL,NULL),(179,'Valley Club - Acceptance','valley-club-acceptance',2,'09:00:00',12,1,56,NULL,NULL),(180,'Whitefire Big Book Study','whitefire-big-book-study',2,'09:00:00',12,1,74,NULL,NULL),(181,'Speakeasy','speakeasy-2',2,'09:30:00',12,1,66,NULL,NULL),(182,'Usual Suspects Men\'s Stag Men','usual-suspects-mens-stag',2,'10:00:00',12,1,66,NULL,NULL),(183,'Living In The Solution 12&12 - Women, Closed, hybrid Women','living-in-the-solution-1212-women-closed-hybrid',2,'10:00:00',12,1,99,NULL,NULL),(184,'Serenity With Sobriety','serenity-with-sobriety-2',2,'11:30:00',12,1,89,NULL,NULL),(185,'Women\'s Rap Session Women','womens-rap-session',2,'18:00:00',12,1,24,NULL,NULL),(186,'Big Book Study','big-book-study-2',2,'18:00:00',12,1,26,NULL,NULL),(187,'Topic Discussion','topic-discussion-3',2,'18:00:00',12,1,44,NULL,NULL),(188,'Hole in the Sky - 12&12 Study','hole-in-the-sky-1212-study',2,'18:00:00',12,1,27,NULL,NULL),(189,'Pacific Park Participation','pacific-park-participation',2,'18:00:00',12,1,17,NULL,NULL),(190,'The End Of The Line - Men\'s Stag Men','the-end-of-the-line-2',2,'18:00:00',12,1,32,NULL,NULL),(191,'Pacoima Participation','pacoima-participation-3',2,'18:00:00',12,1,57,NULL,NULL),(192,'Question & Answer','question-answer',2,'18:00:00',12,1,65,NULL,NULL),(193,'As Bill Sees It','as-bill-sees-it-2',2,'18:00:00',12,1,80,NULL,NULL),(194,'Solutions','solutions',2,'18:00:00',12,1,56,NULL,NULL),(195,'La Canada Noon Speaker','la-canada-noon-speaker',2,'12:30:00',12,1,39,NULL,NULL),(196,'Deep Dive Women\'s Big Book Study - Closed Women','deep-dive-womens-big-book-study-closed',2,'12:30:00',12,1,66,NULL,NULL),(197,'As Bill Sees It','as-bill-sees-it',2,'15:00:00',12,1,77,NULL,NULL),(198,'Happy, Joyous at Three','happy-joyous-at-three-2',2,'15:00:00',12,1,77,NULL,NULL),(199,'Valley Club - Life Boat Meeting','valley-club-life-boat-meeting',2,'15:00:00',12,1,53,NULL,NULL),(200,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-2',2,'16:00:00',12,1,66,NULL,NULL),(201,'Pacoima Participation','pacoima-participation-9',2,'17:30:00',12,1,57,NULL,NULL),(202,'Open Discussion','open-discussion-3',2,'17:30:00',12,1,65,NULL,NULL),(203,'Slums of Norway','slums-of-norway',2,'18:00:00',12,1,89,NULL,NULL),(204,'How It Works','how-it-works-3',2,'18:00:00',12,1,44,NULL,NULL),(205,'How It Works','how-it-works',2,'18:00:00',12,1,46,NULL,NULL),(206,'Into Action - (Closed)','into-action-closed',2,'18:00:00',12,1,66,NULL,NULL),(207,'Seniors in Sobriety','seniors-in-sobriety',2,'18:00:00',12,1,95,NULL,NULL),(208,'Valley Club - The Primary Purpose','valley-club-the-primary-purpose',2,'18:00:00',12,1,53,NULL,NULL),(209,'Unit A - Open Meeting','unit-a-open-meeting',2,'18:00:00',12,1,50,NULL,NULL),(210,'Burbank Topic Discussion - hybrid','burbank-topic-discussion-hybrid',2,'18:00:00',12,1,20,NULL,NULL),(211,'Big Book Study','big-book-study-3',2,'18:00:00',12,1,56,NULL,NULL),(212,'Lowell Companions','lowell-companions',2,'18:30:00',12,1,40,NULL,NULL),(213,'Hole in the Sky - Women\'s Stag Women','hole-in-the-sky-womens-stag-closed',2,'18:30:00',12,1,26,NULL,NULL),(214,'Women\'s Stag Women','womens-stag-2',2,'18:30:00',12,1,26,NULL,NULL),(215,'Layers of the Onion - Women (Closed) Women','layers-of-the-onion-women-closed',2,'18:30:00',12,1,43,NULL,NULL),(216,'Canyon Step Study','canyon-step-study',2,'19:00:00',12,1,86,NULL,NULL),(217,'Learning To Live Book Study','learning-to-live-bk-study',2,'19:00:00',12,1,24,NULL,NULL),(218,'Tuesday Night Discussion','tuesdayday-night-discussion',2,'19:00:00',12,1,93,NULL,NULL),(219,'Calabasas Group of A.A. - hybrid','calabasas-group-of-a-a-hybrid',2,'19:00:00',12,1,22,NULL,NULL),(220,'SFV Steps & Traditions','sfv-steps-traditions',2,'19:00:00',12,1,76,NULL,NULL),(221,'Learning To Live Book Study','learning-to-live-book-study',2,'19:00:00',12,1,27,NULL,NULL),(222,'SFV Steps and Traditions','sfv-steps-and-traditions',2,'19:00:00',12,1,77,NULL,NULL),(223,'Serenity Speakers, Closed, Women Women','serenity-speakers-closed-women',2,'19:00:00',12,1,66,NULL,NULL),(224,'Sunset Group Big Book Study','sunset-group-big-book-study',2,'19:00:00',12,1,17,NULL,NULL),(225,'Tuesday Night Lotto','tuesday-night-lotto',2,'19:00:00',12,1,72,NULL,NULL),(226,'Speaker','speaker',2,'19:30:00',12,1,58,NULL,NULL),(227,'Western Group - Leader Discussion','western-group-leader-discussion',2,'19:30:00',12,1,72,NULL,NULL),(228,'Pacoima Speaker','pacoima-speaker',2,'19:30:00',12,1,57,NULL,NULL),(229,'Comercio Questions & Answers','comercio-questions-answers',2,'19:30:00',12,1,96,NULL,NULL),(230,'Pacific Group Speaker/Discussion','pacific-group-speaker-discussion',2,'19:30:00',12,1,84,NULL,NULL),(231,'Book Study','book-study-2',2,'19:30:00',12,1,65,NULL,NULL),(232,'Positive Solutions Speaker/Discussion','positive-solutions',2,'19:30:00',12,1,50,NULL,NULL),(233,'Unit A - LGBTQ+ Positive Solutions','unit-a-lgbtq-positive-solutions',2,'19:30:00',12,1,50,NULL,NULL),(234,'A Day At A Time Speaker','a-day-at-a-time-speaker',2,'20:00:00',12,1,34,NULL,NULL),(235,'Burbank Women\'s Discussion - hybrid','burbank-womens-discussion-hybrid',2,'20:00:00',12,1,17,NULL,NULL),(236,'Frank Kelly Memorial Men\'s Stag Men','frank-kelly-memorial-mens-stag',2,'20:00:00',12,1,27,NULL,NULL),(237,'Topanga Fireside Discussion','topanga-fireside-discussion',2,'20:00:00',12,1,85,NULL,NULL),(238,'U.S.R. 1 Hour Book Study Men','u-s-r-1-hour-book-study',2,'20:00:00',12,1,61,NULL,NULL),(239,'Frank Kelly Memorial Men\'s Stag Men','frank-kelly-memorial-mens-stag-2',2,'20:00:00',12,1,28,NULL,NULL),(240,'Acceptance Candlelight Discussion','acceptance-candlelight-discussion',2,'20:00:00',12,1,37,NULL,NULL),(241,'Current Solutions Discussion Men','current-solutions-discussion',2,'20:00:00',12,1,91,NULL,NULL),(242,'Burbank Women\'s Discussion Women','burbank-womens-discussion',2,'20:00:00',12,1,20,NULL,NULL),(243,'AA Participation','aa-participation',2,'20:00:00',12,1,56,NULL,NULL),(244,'Candlelight Leader/Participation','candlelight-leader-participation',2,'20:00:00',12,1,21,NULL,NULL),(245,'Candlelight Leader/Participation (Hybrid)','candlelight-leader-participation-hybrid',2,'20:00:00',12,1,21,NULL,NULL),(246,'The God Shot Big Book Study','the-god-shot-big-book-study',2,'21:00:00',12,1,17,NULL,NULL),(247,'Burbank Participation - hybrid','burbank-participation-hybrid-2',2,'22:00:00',12,1,17,NULL,NULL),(248,'Burbank Participation','burbank-participation-2',2,'22:00:00',12,1,20,NULL,NULL),(249,'Curtain Call Speaker/Participation','curtain-call-speaker-participation',2,'22:30:00',12,1,47,NULL,NULL),(250,'Valley Club - 12 & 12 Book Study','valley-club-12-12-book-study',3,'05:30:00',12,1,56,NULL,NULL),(251,'12 & 12','12-12',3,'06:00:00',12,1,41,NULL,NULL),(252,'WAA On Awakening','waa-on-awakening-3',3,'06:30:00',12,1,48,NULL,NULL),(253,'The Solution Meeting - Closed, Men Men','the-solution-3',3,'06:45:00',12,1,24,NULL,NULL),(254,'Spiritual Discussion','spiritual-discussion-3',3,'06:45:00',12,1,26,NULL,NULL),(255,'Winners Attitude Adjustment','winners-attitude-adjustment-3',3,'07:00:00',12,1,87,NULL,NULL),(256,'New Attitude','new-attitude-2',3,'07:00:00',12,1,12,NULL,NULL),(257,'Attitude Adjustment','attitude-adjustment-2',3,'07:00:00',12,1,88,NULL,NULL),(258,'Bring Your Own Coffee & Big Book','bring-your-own-coffee-big-book',3,'07:00:00',12,1,95,NULL,NULL),(259,'New Day Zooming - Closed, Men Men','new-day-zooming-closed-men-3',3,'07:00:00',12,1,46,NULL,NULL),(260,'Shakers Zoom Participation','shakers-zoom-participation-4',3,'07:00:00',12,1,34,NULL,NULL),(261,'Valley Club - Topic Discussion','valley-club-topic-discussion-2',3,'07:00:00',12,1,53,NULL,NULL),(262,'A Gathering Of Men Men','a-gathering-of-men-3',3,'07:00:00',12,1,79,NULL,NULL),(263,'Shakers Participation','shakers-participation-3',3,'07:00:00',12,1,35,NULL,NULL),(264,'SFV 8AM Online','sfv-8am-online-3',3,'08:00:00',12,1,66,NULL,NULL),(265,'Open Discussion','open-discussion-4',3,'08:00:00',12,1,65,NULL,NULL),(266,'The Solution is in the Steps','the-solution-is-in-the-steps',3,'09:00:00',12,1,75,NULL,NULL),(267,'Rule 62','rule-62-3',3,'09:00:00',12,1,66,NULL,NULL),(268,'Unit A - All-R-Welcomed Book Study','unit-a-2',3,'09:00:00',12,1,46,NULL,NULL),(269,'Beeman Park','beeman-park-3',3,'09:00:00',12,1,78,NULL,NULL),(270,'Unit A - All-R-Welcomed Book Study','unit-a-all-r-welcomed-book-study-3',3,'09:00:00',12,1,50,NULL,NULL),(271,'Good Morning Participation','good-morning-participation-2',3,'09:00:00',12,1,80,NULL,NULL),(272,'Valley Club - On Awakening','valley-club-on-awakening',3,'09:00:00',12,1,56,NULL,NULL),(273,'Tree House','tree-house',3,'09:00:00',12,1,74,NULL,NULL),(274,'Whitefire Speaker','whitefire-speaker-2',3,'09:00:00',12,1,74,NULL,NULL),(275,'Speakeasy','speakeasy-3',3,'09:30:00',12,1,66,NULL,NULL),(276,'Women\'s Steps 1, 2 and 3 - Closed, Women\'s Women','womens-steps-12-and-3-closed-womens',3,'11:00:00',12,1,41,NULL,NULL),(277,'Serenity With Sobriety','serenity-with-sobriety-3',3,'11:30:00',12,1,89,NULL,NULL),(278,'Living Sober Study','living-sober-study',3,'18:00:00',12,1,26,NULL,NULL),(279,'The 12 Traditions','the-12-traditions',3,'18:00:00',12,1,44,NULL,NULL),(280,'High Noon Hope','high-noon-hope-2',3,'18:00:00',12,1,10,NULL,NULL),(281,'Hole in the Sky - Living Sober Book Study','hole-in-the-sky-living-sober-book-study',3,'18:00:00',12,1,27,NULL,NULL),(282,'The End Of The Line - Men\'s Stag Men','the-end-of-the-line-mens-stag-3',3,'18:00:00',12,1,32,NULL,NULL),(283,'Pacoima Part','pacoima-part',3,'18:00:00',12,1,57,NULL,NULL),(284,'Pacoima Participation','participation-4',3,'18:00:00',12,1,57,NULL,NULL),(285,'12 & 12 Book Study','12-12-book-study-3',3,'18:00:00',12,1,65,NULL,NULL),(286,'Good Day 12&12','good-day-1212',3,'18:00:00',12,1,80,NULL,NULL),(287,'The Lunch Bunch Step Study','the-lunch-bunch-step-study',3,'18:00:00',12,1,20,NULL,NULL),(288,'Sugar Free','aa-participation-2',3,'18:00:00',12,1,56,NULL,NULL),(289,'Sober Sals Participation - Women, Closed','sober-sals-participation-women-closed',3,'13:00:00',12,1,62,NULL,NULL),(290,'Happy, Joyous at Three','happy-joyous-at-three-3',3,'15:00:00',12,1,77,NULL,NULL),(291,'Valley Club - Discussion','valley-club-discussion-2',3,'15:00:00',12,1,53,NULL,NULL),(292,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-3',3,'16:00:00',12,1,66,NULL,NULL),(293,'Pacoima Participation','pacoima-participation-4',3,'17:30:00',12,1,57,NULL,NULL),(294,'Open Discussion','open-discussion-5',3,'17:30:00',12,1,65,NULL,NULL),(295,'Wednesday 12 & 12','wednesdaynesday-12-12',3,'18:00:00',12,1,29,NULL,NULL),(296,'Beginners Participation','beginners-participation',3,'18:00:00',12,1,26,NULL,NULL),(297,'Hole in the Sky - Beginner\'s Workshop','hole-in-the-sky-beginners-workshop',3,'18:00:00',12,1,26,NULL,NULL),(298,'How It Works','how-it-works-4',3,'18:00:00',12,1,44,NULL,NULL),(299,'Big Book Study','big-book-study',3,'18:00:00',12,1,95,NULL,NULL),(300,'LGBTQIA Speaker & Discussion','lgbtqia-speaker-discussion',3,'18:00:00',12,1,66,NULL,NULL),(301,'Unit A - Humpday Meeting','unit-a-humpday-meeting',3,'18:00:00',12,1,50,NULL,NULL),(302,'Burbank Big Book Study','burbank-big-book-study',3,'18:00:00',12,1,20,NULL,NULL),(303,'Burbank Big Book Study - hybrid','burbank-big-book-study-hybrid',3,'18:00:00',12,1,20,NULL,NULL),(304,'Valley Club - 12 & 12 Book Study','valley-club-12-12-book-study-2',3,'18:00:00',12,1,56,NULL,NULL),(305,'Woodland Hills Big Book Study','woodland-hills-big-book-study',3,'18:00:00',12,1,99,NULL,NULL),(306,'Women\'s Newcomer Meeting Women','womens-newcomer-meeting',3,'18:30:00',12,1,66,NULL,NULL),(307,'Hole in the Sky - Spiritual Discussion','hole-in-the-sky-spiritual-discussion-3',3,'18:45:00',12,1,27,NULL,NULL),(308,'An Hour Under the Oaks (women) Women','an-hour-under-the-oaks-women',3,'19:00:00',12,1,30,NULL,NULL),(309,'The Page Turners Book Studies','the-page-turners-bk-studies',3,'19:00:00',12,1,37,NULL,NULL),(310,'Remain Teachable','remain-teachable',3,'19:00:00',12,1,84,NULL,NULL),(311,'Serenity With Sobriety','serenity-with-sobriety-4',3,'19:30:00',12,1,89,NULL,NULL),(312,'Fun Bunch Discussion','fun-bunch-discussion',3,'19:30:00',12,1,94,NULL,NULL),(313,'Prime Time Is Now','prime-time-is-now',3,'19:30:00',12,1,23,NULL,NULL),(314,'Women\'s Discussion (Closed) Women','womens-discussion-closed',3,'19:30:00',12,1,58,NULL,NULL),(315,'Women\'s Problem Discussion (Closed) Women','womens-problem-discussion-closed',3,'19:30:00',12,1,77,NULL,NULL),(316,'Pacoima Women\'s Discussion Women','pacoima-womens-discussion',3,'19:30:00',12,1,57,NULL,NULL),(317,'Quality of Life Men\'s Stag (Closed) Men','quality-of-life-mens-stag-closed',3,'19:30:00',12,1,64,NULL,NULL),(318,'Candlelight','candlelight',3,'19:30:00',12,1,65,NULL,NULL),(319,'Rebellion Dogs Men','rebellion-dogs',3,'19:30:00',12,1,80,NULL,NULL),(320,'Dunsmore Group Participation','dunsmore-group-participation',3,'20:00:00',12,1,41,NULL,NULL),(321,'We Are Not Amateurs','we-are-not-amateurs',3,'20:00:00',12,1,26,NULL,NULL),(322,'Step Study Workshop','step-study-workshop',3,'20:00:00',12,1,44,NULL,NULL),(323,'Hole in the Sky - Candlelight Meeting','hole-in-the-sky-candlelight-meeting',3,'20:00:00',12,1,27,NULL,NULL),(324,'Tarzana Speaker','tarzana-speaker',3,'20:00:00',12,1,83,NULL,NULL),(325,'Topic Lounge Men\'s Men','topic-lounge-mens',3,'20:00:00',12,1,73,NULL,NULL),(326,'Burbank Steps & Traditions - hybrid','burbank-steps-traditions-hybrid',3,'20:00:00',12,1,20,NULL,NULL),(327,'AA Participation','aa-participation-3',3,'20:00:00',12,1,56,NULL,NULL),(328,'Easy Does It Speaker','easy-does-it-speaker',3,'20:00:00',12,1,36,NULL,NULL),(329,'Burbank Participation - hybrid','burbank-participation-hybrid-3',3,'22:00:00',12,1,20,NULL,NULL),(330,'Valley Club - As Bill Sees It Discussion','valley-club-as-bill-sees-it-discussion',4,'05:30:00',12,1,56,NULL,NULL),(331,'Getting Better & Better','getting-better-better',4,'06:00:00',12,1,41,NULL,NULL),(332,'WAA On Awakening','waa-on-awakening-4',4,'06:30:00',12,1,48,NULL,NULL),(333,'The Solution Meeting - Closed, Men Men','the-solution-meeting-closed-men-4',4,'06:45:00',12,1,24,NULL,NULL),(334,'Wake Up Group','wake-up-group-2',4,'06:45:00',12,1,62,NULL,NULL),(335,'Winners Attitude Adjustment','winners-attitude-adjustment-4',4,'07:00:00',12,1,87,NULL,NULL),(336,'New Attitude','new-attitude-3',4,'07:00:00',12,1,12,NULL,NULL),(337,'New Day Zooming - Closed, Men','new-day-zooming-closed-men-4',4,'07:00:00',12,1,46,NULL,NULL),(338,'Shakers Zoom Participation','shakers-zoom-participation-5',4,'07:00:00',12,1,34,NULL,NULL),(339,'Valley Club - Topic Discussion','valley-club-topic-discussion-3',4,'07:00:00',12,1,53,NULL,NULL),(340,'A Gathering Of Men Men','a-gathering-of-men-4',4,'07:00:00',12,1,79,NULL,NULL),(341,'Shakers Participation','shakers-participation-4',4,'07:00:00',12,1,35,NULL,NULL),(342,'A New Day Dawning Discussion Men','a-new-day-dawning-discussion',4,'07:00:00',12,1,49,NULL,NULL),(343,'SFV 8AM Online','sfv-8am-online-4',4,'08:00:00',12,1,66,NULL,NULL),(344,'Open Discussion','open-discussion-6',4,'08:00:00',12,1,65,NULL,NULL),(345,'One Page at a Time Men','one-page-at-a-time',4,'09:00:00',12,1,75,NULL,NULL),(346,'Rule 62','rule-62-4',4,'09:00:00',12,1,66,NULL,NULL),(347,'Unit A - All-R-Welcomed Book Study','unit-a-3',4,'09:00:00',12,1,46,NULL,NULL),(348,'Beeman Park','beeman-park-4',4,'09:00:00',12,1,78,NULL,NULL),(349,'Unit A - All-R-Welcomed Book Study','unit-a-all-r-welcomed-book-study-4',4,'09:00:00',12,1,50,NULL,NULL),(350,'Step Study','step-study',4,'09:00:00',12,1,80,NULL,NULL),(351,'Valley Club - Keys of the Kingdom','valley-club-keys-of-the-kingdom',4,'09:00:00',12,1,56,NULL,NULL),(352,'Whitefire 12 & 12 Study','whitefire-12-12-study',4,'09:00:00',12,1,74,NULL,NULL),(353,'Speakeasy','speakeasy-4',4,'09:30:00',12,1,66,NULL,NULL),(354,'Serenity With Sobriety','serenity-with-sobriety-5',4,'11:30:00',12,1,89,NULL,NULL),(355,'Topic Disc','topic-disc',4,'18:00:00',12,1,44,NULL,NULL),(356,'Noon Discussion (\"The Six\")','noon-discussion-the-six-2',4,'18:00:00',12,1,23,NULL,'2022-08-17 15:26:41'),(357,'Pacific Park Participation','pacific-park-participation-2',4,'18:00:00',12,1,17,NULL,NULL),(358,'The End Of The Line - Men\'s Stag Men','the-end-of-the-line-mens-stag-4',4,'18:00:00',12,1,32,NULL,NULL),(359,'Pacoima Participation','pacoima-participation-5',4,'18:00:00',12,1,57,NULL,NULL),(360,'Closed Discussion','closed-discussion',4,'18:00:00',12,1,65,NULL,NULL),(361,'Unit A - Living Sober','unit-a-9',4,'18:00:00',12,1,50,NULL,NULL),(362,'Good Day Participation','good-day-participation',4,'18:00:00',12,1,80,NULL,NULL),(363,'AA Participation','aa-participation-4',4,'18:00:00',12,1,56,NULL,NULL),(364,'It is Your Turn','it-is-your-turn',4,'18:00:00',12,1,56,NULL,NULL),(365,'Whitsett Women\'s Meeting Women','whitsett-womens-meeting',4,'12:30:00',12,1,75,NULL,NULL),(366,'Big Book Stories & Steps - Women, Closed Women','big-book-stories-steps-women-closed',4,'13:00:00',12,1,27,NULL,NULL),(367,'Happy, Joyous at Three','happy-joyous-at-three-4',4,'15:00:00',12,1,77,NULL,NULL),(368,'Valley Club - H.O.W.','valley-club-h-o-w',4,'15:00:00',12,1,53,NULL,NULL),(369,'Discussion','discussion-2',4,'15:00:00',12,1,56,NULL,NULL),(370,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-4',4,'16:00:00',12,1,66,NULL,NULL),(371,'Grapevine Meeting','grapevine-meeting',4,'17:00:00',12,1,26,NULL,NULL),(372,'Hole in the Sky - Grapevine Meeting','hole-in-the-sky-grapevine-meeting',4,'17:00:00',12,1,27,NULL,NULL),(373,'Pacoima Participation','participation-7',4,'17:30:00',12,1,57,NULL,NULL),(374,'Open Discussion','open-discussion-7',4,'17:30:00',12,1,65,NULL,NULL),(375,'Leaders Choice Women\'s Grp Women','leaders-choice-womens-grp',4,'18:00:00',12,1,41,NULL,NULL),(376,'How It Works','how-it-works-5',4,'18:00:00',12,1,44,NULL,NULL),(377,'Burbank Women\'s Step Study Women','burbank-womens-step-study-hybrid',4,'18:00:00',12,1,17,NULL,NULL),(378,'Leaders Choice Women\'s Group - Closed, Women','leaders-choice-womens-group-closed-women',4,'18:00:00',12,1,42,NULL,NULL),(379,'Valley Club - Women\'s Stag','valley-club-womens-stag',4,'18:00:00',12,1,53,NULL,NULL),(380,'Participation','participation-13',4,'18:00:00',12,1,45,NULL,NULL),(381,'Unit A - Open Meeting','unit-a-step-study',4,'18:00:00',12,1,50,NULL,NULL),(382,'Burbank Women\'s Step Study Women','burbank-womens-step-study',4,'18:00:00',12,1,20,NULL,NULL),(383,'Discussion','discussion-3',4,'18:00:00',12,1,56,NULL,NULL),(384,'12&12 Discussion Group','1212-discussion-group',4,'18:00:00',12,1,99,NULL,NULL),(385,'Hole in the Sky - Spiritual Discussion','hole-in-the-sky-spiritual-discussion-4',4,'18:45:00',12,1,27,NULL,NULL),(386,'Thursday Night Lights','thursday-night-lights',4,'19:00:00',12,1,24,NULL,NULL),(387,'A Textbook for Living Book Study','a-textbook-for-living-book-study',4,'19:00:00',12,1,29,NULL,NULL),(388,'Present of Presence Step Study','present-of-presence-step-study',4,'19:00:00',12,1,76,NULL,NULL),(389,'Sunset Group Speaker Meeting','sunset-group-speaker-meeting',4,'19:00:00',12,1,72,NULL,NULL),(390,'There Is A Solution Participation','there-is-a-solution-participation',4,'19:00:00',12,1,37,NULL,NULL),(391,'Men\'s Book Study Men','mens-book-study',4,'19:00:00',12,1,64,NULL,NULL),(392,'Cal Community AA Step Study','cal-community-aa-step-study',4,'19:30:00',12,1,8,NULL,NULL),(393,'The Valley Book Study','the-valley-book-study',4,'19:30:00',12,1,51,NULL,NULL),(394,'4th Edition Big Book Study','4th-edition-big-book-study',4,'19:30:00',12,1,13,NULL,NULL),(395,'Men\'s Discussion (Closed)','mens-discussion-closed',4,'19:30:00',12,1,58,NULL,NULL),(396,'Principles Before Personalities BB Study','principles-before-personalities-bb-study',4,'19:30:00',12,1,72,NULL,NULL),(397,'Quality of Life (women\'s stag - closed) Women','quality-of-life-womens-stag-closed',4,'19:30:00',12,1,90,NULL,NULL),(398,'The Solution Group','the-solution-group',4,'19:30:00',12,1,72,NULL,NULL),(399,'Pacoima Men\'s Stag Men','mens-stag-4',4,'19:30:00',12,1,57,NULL,NULL),(400,'Big Book Study/Discussion','big-book-study-discussion',4,'19:30:00',12,1,96,NULL,NULL),(401,'Women\'s Discussion Women','womens-discussion',4,'19:30:00',12,1,65,NULL,NULL),(402,'Western Group Leader/Discussion','western-group-leader-discussion-2',4,'19:30:00',12,1,73,NULL,NULL),(403,'Just The Black Print Big Book','just-the-black-print-big-book',4,'19:45:00',12,1,72,NULL,NULL),(404,'Robbers Roost Participation','robbers-roost-participation',4,'20:00:00',12,1,41,NULL,NULL),(405,'West Valley Men\'s Stag','west-valley-mens-stag',4,'20:00:00',12,1,33,NULL,NULL),(406,'U.S.R. Men\'s Discussion Men','u-s-r-mens-discussion',4,'20:00:00',12,1,61,NULL,NULL),(407,'Moksha AA Group Women','moksha-aa-group',4,'20:00:00',12,1,55,NULL,NULL),(408,'Honest Desire Book Study Men','honest-desire-book-study',4,'20:00:00',12,1,91,NULL,NULL),(409,'West Valley Men\'s Stag Men','west-valley-mens-stag-2',4,'20:00:00',12,1,104,NULL,NULL),(410,'Burbank Directed To Newcomer','burbank-directed-to-newcomer',4,'20:00:00',12,1,20,NULL,NULL),(411,'Speaker Participation','speaker-participation',4,'20:00:00',12,1,56,NULL,NULL),(412,'Burbank Participation - hybrid','burbank-participation-hybrid-4',4,'22:00:00',12,1,20,NULL,NULL),(413,'Valley Club - Daily Reflections','valley-club-daily-reflections-discussion',5,'05:30:00',12,1,56,NULL,NULL),(414,'Speaker/Participation','speaker-participation-2',5,'06:00:00',12,1,41,NULL,NULL),(415,'WAA On Awakening','waa-on-awakening-6',5,'06:30:00',12,1,48,NULL,NULL),(416,'The Solution Meeting - Closed, Men Men','the-solution-meeting-closed-men-5',5,'06:45:00',12,1,24,NULL,NULL),(417,'Winners Attitude Adjustment','winners-attitude-adjustment-5',5,'07:00:00',12,1,87,NULL,NULL),(418,'New Attitude Big Book Study','new-attitude-big-book-study',5,'07:00:00',12,1,12,NULL,NULL),(419,'Attitude Adjustment','attitude-adjustment-3',5,'07:00:00',12,1,88,NULL,NULL),(420,'New Day Zooming - Closed, Men','new-day-zooming-closed-men-5',5,'07:00:00',12,1,46,NULL,NULL),(421,'Shakers Zoom Participation','shakers-zoom-participation-6',5,'07:00:00',12,1,34,NULL,NULL),(422,'Valley Club - Topic Discussion','valley-club-topic-discussion-4',5,'07:00:00',12,1,53,NULL,NULL),(423,'A Gathering Of Men Men','a-gathering-of-men-5',5,'07:00:00',12,1,79,NULL,NULL),(424,'Shakers Participation','shakers-participation-6',5,'07:00:00',12,1,35,NULL,NULL),(425,'SFV 8AM Online','sfv-8am-online-5',5,'08:00:00',12,1,66,NULL,NULL),(426,'Open Discussion','open-discussion-8',5,'08:00:00',12,1,65,NULL,NULL),(427,'As Bill Sees It','as-bill-sees-it-4',5,'09:00:00',12,1,75,NULL,NULL),(428,'Rule 62','rule-62-5',5,'09:00:00',12,1,66,NULL,NULL),(429,'Unit A - All-R-Welcomed Book Study','unit-a-4',5,'09:00:00',12,1,46,NULL,NULL),(430,'Beeman Park','beeman-park-5',5,'09:00:00',12,1,78,NULL,NULL),(431,'Unit A - All-R-Welcomed Book Study','unit-a-all-r-welcomed-book-study-5',5,'09:00:00',12,1,50,NULL,NULL),(432,'As Bill Sees It','as-bill-sees-it-8',5,'09:00:00',12,1,80,NULL,NULL),(433,'Valley Club - Promises','valley-club-promises',5,'09:00:00',12,1,56,NULL,NULL),(434,'Whitefire Speaker','whitefire-speaker-3',5,'09:00:00',12,1,74,NULL,NULL),(435,'Speakeasy','speakeasy-5',5,'09:30:00',12,1,66,NULL,NULL),(436,'Women\'s Topic Discussion Women','womens-topic-discussion',5,'10:00:00',12,1,99,NULL,NULL),(437,'Sobriety Sisters (Women, Closed)','sobriety-sisters-women-closed',5,'10:30:00',12,1,95,NULL,NULL),(438,'Serenity With Sobriety','serenity-with-sobriety-6',5,'11:30:00',12,1,89,NULL,NULL),(439,'Topic Discussion','topic-discussion-4',5,'18:00:00',12,1,44,NULL,NULL),(440,'Circle of Women','circle-of-women',5,'18:00:00',12,1,17,NULL,NULL),(441,'High Noon Hope','high-noon-hope-3',5,'18:00:00',12,1,10,NULL,NULL),(442,'Hole in the Sky - Big Book Study','hole-in-the-sky-big-book-study-2',5,'18:00:00',12,1,27,NULL,NULL),(443,'The End Of The Line - Men\'s Stag','the-end-of-the-line-mens-stag-5',5,'18:00:00',12,1,33,NULL,NULL),(444,'Discussion','discussion-4',5,'18:00:00',12,1,65,NULL,NULL),(445,'Good Day Big Book','good-day-big-book',5,'18:00:00',12,1,80,NULL,NULL),(446,'Live & Let Live','live-let-live',5,'18:00:00',12,1,56,NULL,NULL),(447,'Women\'s Discussion Women','womens-discussion-2',5,'12:30:00',12,1,24,NULL,NULL),(448,'Valley Club - One Page at a Time','valley-club-one-page-at-a-time',5,'15:00:00',12,1,53,NULL,NULL),(449,'Happy, Joyous at Three Leader/Participation','happy-joyous-at-three-5',5,'15:00:00',12,1,102,NULL,NULL),(450,'Discussion','discussion-5',5,'15:00:00',12,1,56,NULL,NULL),(451,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-5',5,'16:00:00',12,1,66,NULL,NULL),(452,'Pacoima Participation','pacoima-participation-6',5,'17:30:00',12,1,57,NULL,NULL),(453,'Open Discussion','open-discussion-9',5,'17:30:00',12,1,65,NULL,NULL),(454,'As Bill Sees It Women','as-bill-sees-it-3',5,'18:00:00',12,1,41,NULL,NULL),(455,'As Bill Sees It Women','as-bill-sees-it-6',5,'18:00:00',12,1,41,NULL,NULL),(456,'Daily Reflections','daily-reflections-3',5,'18:00:00',12,1,26,NULL,NULL),(457,'How It Works','how-it-works-6',5,'18:00:00',12,1,44,NULL,NULL),(458,'Hole in the Sky - Daily Reflections Meeting','hole-in-the-sky-daily-reflections-meeting',5,'18:00:00',12,1,27,NULL,NULL),(459,'Into Action - (Closed)','into-action-closed-2',5,'18:00:00',12,1,66,NULL,NULL),(460,'Unit A - Speaker/Participation','unit-a-speaker-participation',5,'18:00:00',12,1,50,NULL,NULL),(461,'Burbank Emotional Sobriety - hybrid','burbank-emotional-sobriety',5,'18:00:00',12,1,20,NULL,NULL),(462,'Magic of Recovery','magic-of-recovery',5,'18:00:00',12,1,56,NULL,NULL),(463,'Valley Club - Joy of Recovery','valley-club-joy-of-recovery',5,'18:00:00',12,1,56,NULL,NULL),(464,'Friday Night Men\'s Big Book Discussion, Closed, Men','friday-night-mens-big-book-discussion-closed-men',5,'18:30:00',12,1,42,NULL,NULL),(465,'Women\'s Step & Tradition Study, Closed, Women','womens-step-tradition-study-closed-women',5,'18:30:00',12,1,66,NULL,NULL),(466,'Hole in the Sky - Spiritual Discussion','hole-in-the-sky-spiritual-discussion-5',5,'18:45:00',12,1,27,NULL,NULL),(467,'KYHOOYA Discussion','kyhooya-discussion',5,'19:00:00',12,1,66,NULL,NULL),(468,'LGBTQIA Speaker & Discussion','lgbtqia-speaker-discussion-2',5,'19:00:00',12,1,66,NULL,NULL),(469,'Valley Men\'s Discussion Men','valley-mens-discussion',5,'19:00:00',12,1,96,NULL,NULL),(470,'Friday Night Newcomers','fridayday-night-newcomers',5,'19:00:00',12,1,80,NULL,NULL),(471,'Step & Traditions','step-traditions',5,'19:00:00',12,1,19,NULL,NULL),(472,'Hole in the Sky - West Valley Speaker','hole-in-the-sky-west-valley-speaker',5,'19:30:00',12,1,26,NULL,NULL),(473,'West Valley Group Speaker','west-valley-group-speaker',5,'19:30:00',12,1,26,NULL,NULL),(474,'Students of the Big Book','students-of-the-big-book',5,'19:30:00',12,1,95,NULL,NULL),(475,'Women\'s Problems & Solutions','womens-problems-solutions',5,'19:30:00',12,1,66,NULL,NULL),(476,'Woodland Hills Speaker/Participation','woodland-hills-speaker-participation',5,'19:30:00',12,1,95,NULL,NULL),(477,'Friday Nite Speaker/Step/Chip','fridayday-nite-speaker-step-chip',5,'19:30:00',12,1,63,NULL,NULL),(478,'Mixed Discussion','mixed-discussion',5,'20:00:00',12,1,24,NULL,NULL),(479,'Friday Night Men\'s Stag Men','fridayday-night-mens-stag',5,'20:00:00',12,1,41,NULL,NULL),(480,'Calabasas Beginners Discussion','calabasas-beginners-discussion',5,'20:00:00',12,1,95,NULL,NULL),(481,'Friday Night FITS','friday-night-fits',5,'20:00:00',12,1,27,NULL,NULL),(482,'Road to Recovery','road-to-recovery',5,'20:00:00',12,1,46,NULL,NULL),(483,'Working in the Solution','working-in-the-solution',5,'20:00:00',12,1,72,NULL,NULL),(484,'Scandalous Pigs Men','scandalous-pigs',5,'20:00:00',12,1,50,NULL,NULL),(485,'Unit A - Scandalous Pigs Men','unit-a-scandalous-pigs',5,'20:00:00',12,1,50,NULL,NULL),(486,'Beverly Glen Speaker','beverly-glen-speaker',5,'20:00:00',12,1,73,NULL,NULL),(487,'Burbank Speaker - Barefoot - hybrid','burbank-speaker-barefoot-hybrid',5,'20:00:00',12,1,20,NULL,NULL),(488,'Big Book Leader Participation','big-book-leader-participation',5,'20:00:00',12,1,56,NULL,NULL),(489,'Unit A - Candlelight','unit-a-candlelight',5,'21:30:00',12,1,50,NULL,NULL),(490,'Burbank Candlelight - hybrid','burbank-candlelight-hybrid',5,'22:00:00',12,1,20,NULL,NULL),(491,'Late Night Candlelight Participation','late-night-candlelight-participation',5,'17:00:00',12,1,69,NULL,NULL),(492,'Valley Club - Participation','valley-club-participation',6,'05:30:00',12,1,53,NULL,NULL),(493,'Discussion','discussion-6',6,'05:30:00',12,1,56,NULL,NULL),(494,'Daily Reflections','daily-reflections-4',6,'06:00:00',12,1,41,NULL,NULL),(495,'Wake Up Group','wake-up-group-3',6,'06:45:00',12,1,103,NULL,NULL),(496,'Winners Attitude Adjustment','winners-attitude-adjustment-6',6,'07:00:00',12,1,87,NULL,NULL),(497,'New Day Zooming - Closed, Men','new-day-zooming-closed-men-6',6,'07:00:00',12,1,46,NULL,NULL),(498,'Shakers Zoom Participation','shakers-speaker-and-participation-3',6,'07:00:00',12,1,34,NULL,NULL),(499,'A Gathering Of Men Men','a-gathering-of-men-6',6,'07:00:00',12,1,79,NULL,NULL),(500,'Shakers Speaker and Participation','shakers-speaker-and-participation',6,'07:00:00',12,1,35,NULL,NULL),(501,'Valley Club - The Big Show','valley-club-the-big-show',6,'07:00:00',12,1,56,NULL,NULL),(502,'Live at the Park Men','live-at-the-park',6,'07:00:00',12,1,97,NULL,NULL),(503,'Doing The Deal Men','doing-the-deal',6,'07:00:00',12,1,99,NULL,NULL),(504,'The End Of The Line - Men\'s Stag','the-end-of-the-line-mens-stag-6',6,'07:15:00',12,1,33,NULL,NULL),(505,'Sunlight of the Spirit Women','sunlight-of-the-spirit',6,'08:00:00',12,1,75,NULL,NULL),(506,'Spiritual Discussion','spiritual-discussion-4',6,'08:00:00',12,1,26,NULL,NULL),(507,'SFV 8AM Online','sfv-8am-online-6',6,'08:00:00',12,1,66,NULL,NULL),(508,'Popsicle Open Discussion','popsicle-open-discussion',6,'08:00:00',12,1,65,NULL,NULL),(509,'Sunrise Big Book Speaker/Participation','sunrise-big-book-speaker-participation',6,'08:15:00',12,1,49,NULL,NULL),(510,'North Hollywood Speaker/Participation','north-hollywood-speaker-participation',6,'08:30:00',12,1,46,NULL,NULL),(511,'Came to Believe Women','came-to-believe',6,'09:00:00',12,1,41,NULL,NULL),(512,'Participation','participation-9',6,'09:00:00',12,1,58,NULL,NULL),(513,'Rule 62','rule-62-6',6,'09:00:00',12,1,66,NULL,NULL),(514,'Unit A - All-R-Welcomed Book Study','unit-a-5',6,'09:00:00',12,1,46,NULL,NULL),(515,'Valley Club - Laugh Out Loud','valley-club-laugh-out-loud',6,'09:00:00',12,1,53,NULL,NULL),(516,'Unit A - Open Meeting','unit-a-8',6,'09:00:00',12,1,50,NULL,NULL),(517,'LOL','lol',6,'09:00:00',12,1,56,NULL,NULL),(518,'Men\'s Stag','mens-stag',6,'09:30:00',12,1,34,NULL,NULL),(519,'Saturday Morning Women\'s Meeting Women','saturday-morning-womens-meeting',6,'09:30:00',12,1,16,NULL,NULL),(520,'Speakeasy','speakeasy-6',6,'09:30:00',12,1,66,NULL,NULL),(521,'We Are Not Saints Women','we-are-not-saints',6,'10:00:00',12,1,75,NULL,NULL),(522,'12 & 12 Step Study','12-12-step-study',6,'10:00:00',12,1,44,NULL,NULL),(523,'12 & 12 Book Study','12-12-book-study',6,'10:00:00',12,1,59,NULL,NULL),(524,'Keep It Simple (Women\'s meeting)','keep-it-simple-womens-meeting',6,'10:00:00',12,1,77,NULL,NULL),(525,'Sober Solutions (Women, Closed, Hybrid) Women','sober-solutions-women-closed-hybrid',6,'10:00:00',12,1,64,NULL,NULL),(526,'Saturday Dumetz Women\'s Meeting Women','saturday-dumetz-womens-meeting',6,'10:30:00',12,1,99,NULL,NULL),(527,'Participation','participation',6,'11:00:00',12,1,41,NULL,NULL),(528,'Pacoima 12 & 12 Book Study','pacoima-12-12-book-study',6,'11:00:00',12,1,57,NULL,NULL),(529,'Drop the Rock','drop-the-rock',6,'11:00:00',12,1,65,NULL,NULL),(530,'Serenity With Sobriety','serenity-with-sobriety-7',6,'11:30:00',12,1,89,NULL,NULL),(531,'Hole in the Sky - 12&12 Study','hole-in-the-sky-1212-study-2',6,'18:00:00',12,1,27,NULL,NULL),(532,'Moorpark','moorpark',6,'18:00:00',12,1,77,NULL,NULL),(533,'Burbank Men\'s Stag - hybrid Men','burbank-mens-stag-hybrid',6,'18:00:00',12,1,20,NULL,NULL),(534,'Men\'s Stag Men','mens-stag-3',6,'18:00:00',12,1,56,NULL,NULL),(535,'Love and Care Women\'s Meeting','love-and-care-womens-meeting',6,'12:30:00',12,1,62,NULL,NULL),(536,'Book Study','book-study-3',6,'14:00:00',12,1,65,NULL,NULL),(537,'Grapevine Article','grapevine-article',6,'15:00:00',12,1,56,NULL,NULL),(538,'Topic Discussion - Closed (alcoholics only)','topic-discussion-closed-alcoholics-only-6',6,'16:00:00',12,1,66,NULL,NULL),(539,'Serenity With Sobriety','serenity-with-sobriety-8',6,'17:30:00',12,1,89,NULL,NULL),(540,'The Peeling Onions of Recovery','the-peeling-onions-of-recovery',6,'17:30:00',12,1,89,NULL,NULL),(541,'Pacoima Participation','pacoima-participation-7',6,'17:30:00',12,1,57,NULL,NULL),(542,'How It Works','how-it-works-7',6,'18:00:00',12,1,44,NULL,NULL),(543,'Hole in the Sky - Sobriety Speaks Out Speaker/Part','hole-in-the-sky-sobriety-speaks-out-speaker-part',6,'18:00:00',12,1,27,NULL,NULL),(544,'Unit A - Open Meeting','unit-a-open-meeting-2',6,'18:00:00',12,1,50,NULL,NULL),(545,'Sobriety First Speaker/Discussion','sobriety-first-2',6,'18:00:00',12,1,80,NULL,NULL),(546,'Burbank Topic Discussion - hybrid','burbank-topic-discussion-hybrid-2',6,'18:00:00',12,1,18,NULL,NULL),(547,'Discussion','discussion-7',6,'18:00:00',12,1,56,NULL,NULL),(548,'Saddles in Serenity','saddles-in-serenity',6,'18:30:00',12,1,81,NULL,NULL),(549,'Saturday Night Live','saturdayurday-night-live',6,'19:00:00',12,1,24,NULL,NULL),(550,'Saturday Night Live','saturday-night-live',6,'19:00:00',12,1,27,NULL,NULL),(551,'Nite Lite','nite-lite',6,'19:30:00',12,1,89,NULL,NULL),(552,'Saturday Night Live','saturday-night-live-2',6,'19:30:00',12,1,41,NULL,NULL),(553,'Lottery Discussion','lottery-discussion',6,'19:30:00',12,1,77,NULL,NULL),(554,'Open Meeting','open-meeting',6,'19:30:00',12,1,66,NULL,NULL),(555,'Purple Room AA Participation','purple-room-aa-participation',6,'19:30:00',12,1,90,NULL,NULL),(556,'Quality of Life Speaker','quality-of-life-speaker',6,'19:30:00',12,1,64,NULL,NULL),(557,'Feelings Discussion','feelings-discussion',6,'19:30:00',12,1,92,NULL,NULL),(558,'Prime Time Saturday Night','prime-time-saturdayurday-night',6,'19:30:00',12,1,73,NULL,NULL),(559,'Night Talking','night-talking',6,'20:00:00',12,1,26,NULL,NULL),(560,'Solutions in Sobriety (Gay Speaker)','solutions-in-sobriety-gay-speaker',6,'20:00:00',12,1,46,NULL,NULL),(561,'Newcomers Meeting','newcomers-meeting',6,'20:00:00',12,1,65,NULL,NULL),(562,'Speaker','speaker-4',6,'20:00:00',12,1,56,NULL,NULL),(563,'Burbank Participation - hybrid','burbank-participation-hybrid-5',6,'22:00:00',12,1,20,NULL,NULL),(564,'Burbank AA Approved Literature Study','burbank-aa-approved-literature-study',6,'23:30:00',12,1,20,NULL,NULL),(565,'AA Sample Area Meeting IV','aa-sample-area-meeting-iv',0,'18:37:00',12,1,11,'2022-08-16 18:39:12','2022-08-16 18:39:12'),(566,'sample area meeting','sample-area-meeting',0,'19:28:00',1,1,71,'2022-08-16 19:29:05','2022-08-16 19:29:05'),(567,'Rafters','rafters',0,'20:00:00',12,1,69,'2022-10-02 18:28:56','2022-10-02 18:28:56'),(568,'End of the World','end-of-the-world',0,'12:00:00',12,1,55,'2022-10-02 18:44:28','2022-10-02 18:44:28'),(569,'Women\'s Stag','women\'s-stag',5,'17:30:00',9,1,93,'2022-10-06 09:51:04','2022-10-06 09:51:04'),(570,'Beginners Participation and Speaker Meeting','beginners-participation-and-speaker-meeting',6,'20:00:00',7,1,56,'2022-10-06 09:57:35','2022-10-06 09:57:35'),(571,'Concious Contact Women\'s Stag','concious-contact-women\'s-stag',3,'19:00:00',9,1,37,'2022-10-06 10:17:34','2022-10-06 10:17:34'),(572,'Women\'s Empowerment Big Book Study/WEBBS','women\'s-empowerment-big-book-study-weebs',1,'19:30:00',2,1,92,'2022-10-06 11:43:57','2022-10-06 11:43:57'),(573,'Happy Candlestick Makers','happy-candlestick-makers',3,'19:30:00',12,1,64,'2022-11-15 17:33:39','2022-11-15 17:33:39'),(574,'The Spirit of the Kukui','the-spirit-of-the-kukui',0,'12:00:00',12,1,51,'2022-11-15 17:46:05','2022-11-15 17:46:05'),(575,'Outright Mental Defectives Men\'s Stag','outright-mental-defectives-mens-stag',1,'20:00:00',12,1,89,'2022-11-15 17:51:46','2022-11-15 17:51:46'),(576,'La Libertad','la-libertad',0,'15:00:00',7,1,65,'2022-12-06 16:11:11','2022-12-06 16:11:11'),(577,'The Barefoot Group','the-barefoot-group',5,'20:00:00',12,1,12,'2022-12-06 17:10:21','2022-12-06 17:10:21'),(578,'Messengers of Recovery','messengers-of-recovery',2,'19:30:00',12,1,59,'2022-12-06 17:16:17','2022-12-06 17:16:17'),(579,'Acceptance','acceptance',2,'20:00:00',12,1,37,'2022-12-06 17:21:25','2022-12-06 17:21:25'),(580,'We Care Mens Stag','we-care-mens-stag',1,'18:00:00',6,1,26,'2022-12-06 18:06:12','2022-12-06 18:06:12'),(581,'West Valley Rovers','west-valley-rovers',6,'10:30:00',12,1,73,'2022-12-06 21:54:40','2022-12-06 21:54:40'),(582,'Principles Before Pandemic','principles-before-pandemic',6,'21:00:00',12,1,95,'2022-12-12 17:02:26','2022-12-12 18:03:46'),(583,'R2 - Reason and Recovery Secular Zoom Meeting','r2-reason-and-recovery',0,'18:00:00',12,1,95,'2022-12-14 17:40:27','2022-12-14 17:41:34'),(584,'Friday Night Woodland Hills Men\'s Stag','friday-night-woodland-hills-mens-stag',5,'19:00:00',6,1,95,'2022-12-28 09:19:09','2022-12-28 09:19:09'),(585,'Armenian Group','armenian-group',4,'20:00:00',12,1,36,'2022-12-28 11:35:39','2022-12-28 11:35:39'),(586,'Valley Club 5:30 am Meeting','valley--club-5:30-am-meeting',0,'05:30:00',12,1,56,'2022-12-30 11:13:25','2022-12-30 11:13:25');

--
-- Table structure for table `article_translations`
--

CREATE TABLE `article_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `menu_title` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `intro` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `abstract` text DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` varchar(255) DEFAULT NULL,
  `seo_keywords` varchar(255) DEFAULT NULL,
  `seo_no_index` varchar(255) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `update_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `article_translations_article_id_locale_unique` (`article_id`,`locale`),
  KEY `article_translations_locale_index` (`locale`),
  CONSTRAINT `article_translations_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `article_translations`
--

INSERT INTO `article_translations` VALUES (1,1,'it','home','Home','Home','LaraCms',NULL,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec volutpat maximus purus, sit amet congue nulla maximus quis. Nam sit amet massa sed ante rhoncus vehicula. Nam nec metus eu lorem porttitor suscipit. In at mi sit amet felis tincidunt lobortis ac quis nulla. Morbi condimentum eros vel felis iaculis facilisis. Nam at elit a odio elementum fringilla a vel magna. Vestibulum varius bibendum lectus, sed cursus leo consectetur a. Duis venenatis hendrerit enim, vitae tincidunt quam. Phasellus sollicitudin lobortis turpis, quis mollis purus porttitor sit amet.</p>','','','','','0',0,0,'2016-07-04 11:53:04','2017-08-01 19:12:25'),(2,1,'en','home','Home','Home','',NULL,'','','','','','',0,0,'2016-07-04 11:53:04','2021-02-04 23:25:35'),(3,2,'it','azienda','Azienda','Azienda','','','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus egestas aliquam mollis. Donec luctus luctus dui, vitae dapibus ipsum fermentum a. Quisque fermentum sodales iaculis. Nunc blandit ante luctus urna laoreet sollicitudin. Praesent a libero vitae elit pretium cursus. Ut maximus felis pretium augue ullamcorper venenatis. Aenean mattis hendrerit dui id aliquet. Nunc rhoncus ipsum ut orci posuere semper vel quis diam. Duis pulvinar molestie nisi, sed sollicitudin metus fermentum sit amet. Phasellus semper, nibh sed laoreet blandit, ligula neque egestas tortor, ac porttitor massa justo ut diam.</p>\r\n<p>Donec id sem sem. Pellentesque augue quam, euismod nec neque non, sollicitudin tincidunt purus. Sed viverra libero eget ante sollicitudin iaculis. Donec erat tellus, aliquet aliquam nisi vel, faucibus interdum est. In aliquet pharetra eros vel lacinia. Nam sit amet ex tristique, pretium quam quis, ullamcorper dolor. Vestibulum gravida eros accumsan gravida iaculis. Suspendisse eu elit metus. Pellentesque iaculis rutrum augue quis blandit. Fusce at lacus vestibulum, placerat justo vitae, lacinia nisl. Phasellus accumsan enim vitae ex condimentum rhoncus.</p>\r\n<p>Duis feugiat semper eros, vitae consectetur mauris volutpat viverra. Aenean at augue dui. Sed varius tincidunt hendrerit. Cras sed condimentum nunc. Vestibulum consequat eget ipsum a ultrices. Proin auctor commodo facilisis. Praesent quis neque tellus. Fusce venenatis, odio nec facilisis molestie, orci lacus lobortis orci, nec commodo tortor tortor et eros. Sed lacinia nisi et eleifend pharetra. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Morbi sodales diam quis diam volutpat, et egestas purus scelerisque. Phasellus bibendum diam venenatis tortor pretium iaculis. Aliquam a faucibus mauris. Aenean sed urna velit. Nam malesuada dui eget scelerisque fermentum.</p>','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus egestas aliquam mollis. Donec luctus luctus dui, vitae dapibus ipsum fermentum a. Quisque fermentum sodales iaculis. Nunc blandit ante luctus urna laoreet sollicitudin. Praesent a libero vitae elit pretium cursus. Ut maximus felis pretium augue ullamcorper venenatis. Aenean mattis hendrerit dui id aliquet. Nunc rhoncus ipsum ut orci posuere semper vel quis diam. Duis pulvinar molestie nisi, sed sollicitudin metus fermentum sit amet. Phasellus semper, nibh sed laoreet blandit, ligula neque egestas tortor, ac porttitor massa justo ut diam.</p>\r\n<p>Donec id sem sem. Pellentesque augue quam, euismod nec neque non, sollicitudin tincidunt purus. Sed viverra libero eget ante sollicitudin iaculis. Donec erat tellus, aliquet aliquam nisi vel, faucibus interdum est. In aliquet pharetra eros vel lacinia. Nam sit amet ex tristique, pretium quam quis, ullamcorper dolor. Vestibulum gravida eros accumsan gravida iaculis. Suspendisse eu elit metus. Pellentesque iaculis rutrum augue quis blandit. Fusce at lacus vestibulum, placerat justo vitae, lacinia nisl. Phasellus accumsan enim vitae ex condimentum rhoncus.</p>\r\n<p>Duis feugiat semper eros, vitae consectetur mauris volutpat viverra. Aenean at augue dui. Sed varius tincidunt hendrerit. Cras sed condimentum nunc. Vestibulum consequat eget ipsum a ultrices. Proin auctor commodo facilisis. Praesent quis neque tellus. Fusce venenatis, odio nec facilisis molestie, orci lacus lobortis orci, nec commodo tortor tortor et eros. Sed lacinia nisi et eleifend pharetra. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Morbi sodales diam quis diam volutpat, et egestas purus scelerisque. Phasellus bibendum diam venenatis tortor pretium iaculis. Aliquam a faucibus mauris. Aenean sed urna velit. Nam malesuada dui eget scelerisque fermentum.</p>','','','','',0,0,'2016-07-04 11:53:13','2017-08-01 18:31:48'),(4,2,'en','events','Events','Events','','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus egestas aliquam mollis. Donec luctus luctus dui, vitae dapibus ipsum fermentum a. Quisque fermentum sodales iaculis. Nunc blandit ante luctus urna laoreet sollicitudin. Praesent a liber','<h2>ALCOHOLICS ANONYMOUS MEETINGS</h2>\r\n<ul>\r\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Early Bird Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Friday Welcome Ceremony and Speaker Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Saturday Night Banquet & Speaker Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Saturday Night Interview with an Alcoholic</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sunday Morning Spiritual Breakfast & Speaker Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">AA Marathons</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Longtimer&rsquo;s Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Newcomer&rsquo;s Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H&I Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">General Service Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sunrise Meditation Workshops</span></li>\n\n\r\n</ul>\r\n<h2>AL-ANON MEETINGS</h2>\r\n<ul>\r\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Friday Night Opening Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Al-Anon Skit</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Al-Anon Saturday Luncheon & Speaker Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Family Meeting Workshop</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Business Meeting and Workshops</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sunday Closing Meeting</span></li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Al-Anon Marathon Meetings</span></li>\n\n\r\n</ul>\r\n<h2><strong>ALATEEN MEETINGS</strong></h2>\r\n<ul>\r\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Family Meeting</span></li>\r\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Workshops</span></li>\r\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Candlelight Meeting</span></li>\r\n</ul>\r\n<h2 id=\"mealsentertainment\">CEREMONIES &amp; ENTERTAINMENT</h2>\r\n<p>Attend the Friday Opening Ceremonies to see the Friday Night Entertainment, then following the Friday Night Welcome Speaker, get your groove on at our Friday Late Night AA Dance Party. Also on Friday, you won’t want to miss the Al-Anon Skit.  Following the Saturday Night Banquet Speaker Meeting, attend our Interview with an Alcoholic featuring a candid one-on-one question and answer session with an interesting Alkie. Then, to cap off the night, join us for another great lineup at the Saturday Night Banquet Entertainment.</p>','<p>Lorem ipsum dolor sit amet, est rebum detraxit perpetua no. Est ad minimum contentiones. Modo alterum mediocrem no eum. Ut pri error efficiendi delicatissimi, mei cu modo malis imperdiet. Pro quaeque scaevola tacimates te, at pro natum mundi.</p>','','','','',0,0,'2016-07-04 11:53:13','2021-09-13 21:15:00'),(5,3,'it','privacy','Privacy','Privacy','',NULL,'','','','','','',0,0,'2016-07-04 11:53:28','2017-08-01 18:33:01'),(6,3,'en','privacy','Privacy','Privacy','',NULL,'','','','','','',0,0,'2016-07-04 11:53:28','2017-08-01 18:33:01'),(7,5,'it','prodotti','Prodotti','Prodotti','',NULL,'','','','','','',0,0,'2016-07-04 11:53:38','2017-08-02 18:55:34'),(8,5,'en','products','Products','Products','',NULL,'<p>Here is the products page (testing)</p>','','','','','',0,0,'2016-07-04 11:53:38','2018-04-09 19:04:19'),(9,4,'it','contatti','Contatti','Contatti','',NULL,'','','','','','',0,0,'2016-07-04 11:54:32','2017-08-01 18:32:40'),(10,4,'en','contact','Contact Us','Contact Us','',NULL,'','','','','','',0,0,'2016-07-04 11:54:32','2018-04-03 09:15:53'),(13,6,'it','news','Information','News','',NULL,'','','','','','',0,0,'2016-08-04 15:24:58','2017-08-01 18:33:11'),(14,6,'en','news','News','News','',NULL,'','','','','','',0,0,'2016-08-04 15:24:58','2017-08-01 18:33:11'),(15,7,'it','login','login','login','login',NULL,'','','Login','','','',0,0,'2016-08-09 17:12:14','2017-08-01 18:33:20'),(16,7,'en','login','Login','Login','Login',NULL,'','','Login','','','',0,0,'2016-08-09 17:12:14','2017-08-01 18:33:20'),(17,8,'it','dashboard','Dashboard','Dashboard','Dashboard',NULL,'','','','','','',0,0,'2016-08-09 17:24:04','2017-08-01 18:33:30'),(18,8,'en','dashboard','Dashboard','Dashboard','',NULL,'','','','','','',0,0,'2016-08-09 17:24:04','2017-08-01 18:33:30'),(19,9,'it','users','','Users','Users',NULL,'','','','','','',0,0,'2016-08-10 11:16:26','2017-08-01 19:56:45'),(20,9,'en','users','Users','UUsers','',NULL,'','','','','','',0,0,'2016-08-10 11:16:26','2017-08-01 19:56:21'),(21,10,'it','profile','Profile','Profile','Profile',NULL,'','','','','','',0,0,'2016-08-10 11:17:38','2017-08-01 18:33:37'),(22,10,'en','user-profile','User profile','User profile','',NULL,'','','','','','',0,0,'2016-08-10 11:17:38','2017-08-01 18:33:37'),(25,12,'en','event_register','Registration','Registration Form','',NULL,'<div style=\"text-align: center;\">\r\n<h2>Pre-registration and ticket sales are now closed</h2>\r\n<p>Convention registration WILL be available onsite for $30.</p>\r\n</div>','','','','','',0,0,'2018-04-03 08:47:17','2019-10-05 12:38:20'),(26,12,'it','','','','',NULL,'','','','','','',0,0,'2018-04-03 08:47:17','2018-04-03 08:47:17'),(27,13,'en','information','Information','Information','',NULL,'<p><a href=\"../../../events/\"><img style=\"width: 100%;\" src=\"../../../media/images/aa-information-crop.jpg\" alt=\"\" /></a></p>\n\n<h2>About - Alcoholics Anonymous</h2>\n\n<p>Alcoholics Anonymous is a fellowship of men and women who share their experience, strength and hope with each other that they may solve their common problem and help others to recover from alcoholism.</p>\n\n<p>The only requirement for membership is a desire to stop drinking. There are no due or fees for A.A. membership; we are self-supporting through our own contributions. A.A. is not allied with any sect, denomination, politics, organization or institution; does not wish to engage in any controversy; neither endorses nor opposes any causes. Our primary purpose is to stay sober and help other alcoholics to achieve sobriety.</p>\n\n<h2>About - Our Convention</h2>\n<p>We are so excited to bring you the 46th Annual San Fernando Valley AA Convention, Rocketed into a 4th Dimension! This event is hosted by the Sober Alcoholics who live in the San Fernando Valley. Together with our friends from Al-Anon and Alateen we have planned a Convention filled with fun events, in person fellowship and recovery. We welcome you to join us for a three-day weekend of Speaker Meetings and Marathon Meetings, and a host of other AA and Al-Anon events.</p>\n\n<h2>Why Do We Have To Pay?</h2>\n<p>Most associations like to hold conferences or conventions. However, in AA, a conference or convention is an important opportunity to share the AA experience in a broad way. There are many AA conferences held around the world. One of the most common misconceptions of these gatherings is that they are AA meetings, and since \"There are no dues or fees for AA membership...\" there should be no fees to attend.</p>\n\n<p>Conventions and conferences are special events, not regular meetings. They require months of planning, preparations, and money to present. Since most events are held in hotels/convention centers, there is a charge for the use of these facilities. Other expenses include travel and lodging for conference speakers, printing of flyers and schedules, postage and supplies. A large event requires a substantial amount of money. This conference/convention is self-supporting. No group monies are used to pay for this event. The cost of the event is paid through registration fees. No baskets are passed. The ideal goal for any committee of such an event is to break even; therefore, the registration fee is nominal compared to a weekend\'s worth of spiritual events anywhere else. Attendance is voluntary and as responsible AA members, we \"pay our own way.\"</p>\n\n<h2>Ticket and Refund Policy</h2>\n<ul>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">No refunds or cancellations.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Confirmations &amp; tickets will not be mailed to you; you pick them up at the event. All badges and tickets will be held in the name of the Main Registrant.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Pre-orders of commemorative merchandise will be available for pick up at the convention.  In the event that you do not pick up your merchandise it will be wrapped up with your name on it and available for pick up 48 hours after the convention convenes at the San Fernando Valley Central Office located at 16132 Sherman Way, Van Nuys CA 91406.   Commemorative merchandise will not be delivered in the US Mail this year, it will be available by pick-up only.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Registrations and tickets are not transferable.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">All ticket orders are handled on a 1st come; 1st served basis. Up to 10 people are seated per table. To sit with a group, (1) have one person purchase tickets for the group, or (2) make Group Seating Requests in the Notes section on the Registration Page.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For group purchases of more than two tables, the convention cannot guarantee adjacent table seating.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tickets for the Luncheon, Banquet and Breakfast WILL NOT be available for purchase at the event.</span></li>\n</ul>\n<h2>Vegetarian Meals</h2>\n<ul>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Vegetarian meals are available for the Luncheon, Banquet and Breakfast and must be pre-ordered. Simply enter the number of vegetarian meals on the registration form as you enter the quantity of tickets.</span></li>\n\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">At the hotel’s request, no onsite requests for vegetarian meals will be honored.</span></li>\n\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The SFV Convention makes every attempt to accommodate special dietary requests; however, all meal preparation is controlled by the hotel. Therefore, we cannot guarantee the availability of each and every request.</span></li>\n</ul>','<p>this is the information sidebar</p>','','','','',0,0,'2018-04-03 09:08:56','2020-05-14 00:48:11'),(28,13,'it','','','','',NULL,'','','','','','',0,0,'2018-04-03 09:08:56','2018-04-03 09:08:56'),(29,14,'en','volunteer','Volunteer','Volunteer','',NULL,'<p>&nbsp;</p>\r\n\n<p>Do you ever wonder what it takes to put on a convention for hundreds or even thousands of people? Come to the convention planning meetings and find out. The 2023 San Fernando Valley AA Convention is just around the corner and there will be plenty of opportunities for service to create the next event. Come join the team and be a part of the next chapter in the legacy of our convention. Become a volunteer on either the AA or the Al-Anon committee.</p> \n\n<p>The AA Planning Committee meets the third Tuesday of the month, 7pm, at St. Innocent Church, 5657 Lindley Ave, Tarzana, CA 91356.</p>\n \n<p>See below for the SFV AA Convention planning meeting dates for our 2023 convention:</p>\n<ul>\n    <li>April 19, 2022</li>\n    <li>May 17, 2022</li>\n    <li>June 21, 2022</li>\n    <li>July 19, 2022</li>\n    <li>August 16, 2022</li>\n    <li>September 20, 2022</li>\n    <li>October 18, 2022</li>\n    <li>November 15, 2022</li>\n    <li>December 20, 2022</li>\n    <li>January 17, 2023 (Meeting held at the Warner Center Marriott)</li>\n</ul>','<p>side panel goes here</p>','','','','',0,0,'2018-04-03 09:11:59','2020-10-26 13:06:51'),(30,14,'it','events','Marathonsssss','Marathonssssss','Marathonsccccccc',NULL,'','','','','','',0,0,'2018-04-03 09:11:59','2018-04-03 09:11:59'),(33,16,'en','testproduct','test product','test product','test product',NULL,'<p>test product&nbsp;test product&nbsp;test product&nbsp;test product&nbsp;test product&nbsp;test product</p>','<p>test product</p>','','','','',0,0,'2018-04-09 20:22:17','2018-04-09 20:22:17'),(34,17,'en','events-schedule','Events Schedule ','Events Schedule','schedule',NULL,'<p>Events Schedule Page</p>','','','','','',0,0,'2018-04-22 09:36:03','2018-04-22 09:36:03'),(35,18,'en','speaker-meetings','Speaker Meetings','Speaker Meetings','Speaker Meetings',NULL,'<p>Speaker Meetings Schedule</p>','','','','','',0,0,'2018-04-22 09:38:43','2018-04-22 09:38:43'),(36,19,'en','marathon-meetings','AA Marathon Meetings','Marathon Meetings','Marathon Meetings',NULL,'<p>Marathon meetings schedule</p>','','','','','',0,0,'2018-04-22 09:41:05','2020-12-08 10:17:48'),(37,20,'en','al-anon-events','Al-Anon Events','Al-Anon Events','Al-Anon Events',NULL,'<p>Check back soon for the Al-Anon Events schedule.</p>','','','','','',0,0,'2018-04-22 09:43:41','2018-04-22 09:43:41'),(38,21,'en','all-events','All Events','All Events','All Events',NULL,'<ul id=\"pills-tab\" class=\"nav nav-pills mb-3\">\r\n<li class=\"nav-item\"><a id=\"pills-events-tab\" class=\"nav-link active\" href=\"#pills-events\" data-toggle=\"pill\">Events Schedule</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-speaker-tab\" class=\"nav-link\" href=\"#pills-speaker\" data-toggle=\"pill\">Speaker Meetings</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-marathon-tab\" class=\"nav-link\" href=\"#pills-marathon\" data-toggle=\"pill\">Marathon Meetings</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-alanon-tab\" class=\"nav-link\" href=\"#pills-alanon\" data-toggle=\"pill\">Al-Anon Events</a></li>\r\n</ul>\r\n<div id=\"pills-tabContent\" class=\"tab-content\">\r\n<div id=\"pills-events\" class=\"tab-pane fade show active\">\r\n<h2>ALCOHOLICS ANONYMOUS MEETINGSsssssssssssss</h2>\r\n<ul>\r\n<li>AA Speaker Meetings</li>\r\n<li>AA Marathons</li>\r\n<li>Saturday Night Speaker Meeting</li>\r\n<li>Sunday Morning Spiritual Meeting</li>\r\n<li>Young Peoples Meetings</li>\r\n</ul>\r\n<p><a href=\"#\">View the AA Meeting Schedule</a></p>\r\n<h2>AL-ANON MEETINGS</h2>\r\n<ul>\r\n<li>Opening Topic Meeting</li>\r\n<li>Al-Anon Luncheon</li>\r\n<li>Al-Anon Marathon Meetings</li>\r\n<li>Final Topic Meeting</li>\r\n</ul>\r\n<p><a href=\"#\">View the Al-Anon Meeting Schedule</a></p>\r\n<h2>Ceremonies &amp; Entertainment</h2>\r\n<ul>\r\n<li>Opening Ceremonies</li>\r\n<li>Saturday BBQ</li>\r\n<li>Music</li>\r\n<li>Dancing</li>\r\n<li>AA Movies</li>\r\n</ul>\r\n<h2>Sporting Events</h2>\r\n<ul>\r\n<li>5K Fun Run/Walk</li>\r\n<li>Golf Tournament</li>\r\n</ul>\r\n<h2>Al-Anon Luncheon</h2>\r\n<ul>\r\n<li>Date: Saturday, August 25, 2018</li>\r\n<li>Time: 11:30am&nbsp;(doors open at 11:00am)</li>\r\n<li>Place: Madonna Inn\'s Garden Room</li>\r\n<li>Attendees MUST be registered for the convention and the event to attend. Seating is limited and sells out quickly! Pre-registration is recommended. For any questions, email:&nbsp;<a class=\"email\" href=\"mailto:alanonlunchdistrict22convention@gmail.com\">alanonlunchdistrict22convention@gmail.com</a>.</li>\r\n</ul>\r\n<h2>Golf Tournament</h2>\r\n<ul>\r\n<li>Date: Friday, Aug. 24, 2018</li>\r\n<li>Time: 7:30am</li>\r\n<li>Place: Monarch Dunes Golf Course</li>\r\n<li>Come golf with us at the Dunes. Format is a four person scramble with Men\'s and Women\'s long drive and closest to the pin contests.</li>\r\n<li>For more information, contact Matt G. at (805) 610-2571.</li>\r\n</ul>\r\n<h2>5K Fun Run/Walk</h2>\r\n<ul>\r\n<li>Date: Saturday, Aug. 25, 2018</li>\r\n<li>Time: 8:00am</li>\r\n<li>Place: 801 Grand Ave., SLO</li>\r\n<li>No T-shirts and no participation charge or registration this year. Just come out for fun and fellowship. Contact Matt E. at<br />(805) 478-8401 for information.</li>\r\n</ul>\r\n</div>\r\n<div id=\"pills-speaker\" class=\"tab-pane fade\">\r\n<table class=\"table table-striped table-bordered\">\r\n<tbody>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Friday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>8:00p</td>\r\n<td>Friday Night Speaker Meeting<br /><small>speaker: </small>Steve L., Nashville, TN</td>\r\n</tr>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Saturday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>11:30a</td>\r\n<td>Al-Anon Luncheon Speaker Meeting<br /><small>speaker: </small>Larcine G., Hawthorne</td>\r\n</tr>\r\n<tr>\r\n<td>2:30p</td>\r\n<td>H&amp;I Speaker Meeting<br /><small>speaker: </small>Bill D., Rocklin</td>\r\n</tr>\r\n<tr>\r\n<td>6:00p</td>\r\n<td>Young People&rsquo;s Speaker Meeting<br /><small>speaker: </small>Mary Ann, Los Angeles</td>\r\n</tr>\r\n<tr>\r\n<td>8:00p</td>\r\n<td>Saturday Night Speaker Meeting<br /><small>speaker: </small>Bill C., Torrance</td>\r\n</tr>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Sunday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>10:00a</td>\r\n<td>Sunday Morning Speaker Meeting<br /><small>speaker: </small>Patricia P., Los Angeles</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n<div id=\"pills-marathon\" class=\"tab-pane fade\">This will also be like Tab 2</div>\r\n<div id=\"pills-alanon\" class=\"tab-pane fade\">Al-Anon events. This will be similar to tab 1 I think</div>\r\n</div>','','','','','',0,0,'2018-04-22 09:45:18','2018-04-22 09:47:57'),(39,22,'en','information-about','About','About','',NULL,'<p><a href=\"../../../events/\"><img style=\"width: 100%;\" src=\"../../../media/images/aa-information-crop.jpg\" alt=\"\" /></a></p>\n\n<h2>xxxxxxxxxxxAbout - Alcoholics Anonymous</h2>\n\n<p>Alcoholics Anonymous is a fellowship of men and women who share their experience, strength and hope with each other that they may solve their common problem and help others to recover from alcoholism.</p>\n\n<p>The only requirement for membership is a desire to stop drinking. There are no dues or fees for A.A. membership; we are self-supporting through our own contributions. A.A. is not allied with any sect, denomination, politics, organization or institution; does not wish to engage in any controversy; neither endorses nor opposes any causes. Our primary purpose is to stay sober and help other alcoholics to achieve sobriety.</p>\n\n<h2>About - Our Convention</h2>\n<p>We are so excited to bring you the 46th Annual San Fernando Valley AA Convention, Rocketed into a 4th Dimension! This event is hosted by the Sober Alcoholics who live in the San Fernando Valley. Together with our friends from Al-Anon and Alateen we have planned a Convention filled with fun events, in person fellowship and recovery. We welcome you to join us for a three-day weekend of Speaker Meetings and Marathon Meetings, and a host of other AA and Al-Anon events.</p>\n\n<h2>Why Do We Have To Pay?</h2>\n<p>Most associations like to hold conferences or conventions. However, in AA, a conference or convention is an important opportunity to share the AA experience in a broad way. There are many AA conferences held around the world. One of the most common misconceptions of these gatherings is that they are AA meetings, and since \"There are no dues or fees for AA membership...\" there should be no fees to attend.</p>\n\n<p>Conventions and conferences are special events, not regular meetings. They require months of planning, preparations, and money to present. Since most events are held in hotels/convention centers, there is a charge for the use of these facilities. Other expenses include travel and lodging for conference speakers, printing of flyers and schedules, postage and supplies. A large event requires a substantial amount of money. This conference/convention is self-supporting. No group monies are used to pay for this event. The cost of the event is paid through registration fees. No baskets are passed. The ideal goal for any committee of such an event is to break even; therefore, the registration fee is nominal compared to a weekend\'s worth of spiritual events anywhere else. Attendance is voluntary and as responsible AA members, we \"pay our own way.\"</p>\n\n<h2>Ticket and Refund Policy</h2>\n<ul>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">No refunds or cancellations.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Confirmations &amp; tickets will not be mailed to you; you pick them up at the event. All badges and tickets will be held in the name of the Main Registrant.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Pre-orders of commemorative merchandise will be available for pick up at the convention.  In the event that you do not pick up your merchandise it will be wrapped up with your name on it and available for pick up 48 hours after the convention convenes at the San Fernando Valley Central Office located at 16132 Sherman Way, Van Nuys CA 91406.   Commemorative merchandise will not be delivered in the US Mail this year, it will be available by pick-up only.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Registrations and tickets are not transferable.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">All ticket orders are handled on a 1st come; 1st served basis. Up to 10 people are seated per table. To sit with a group, (1) have one person purchase tickets for the group, or (2) make Group Seating Requests in the Notes section on the Registration Page.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For group purchases of more than two tables, the convention cannot guarantee adjacent table seating.</span></li>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tickets for the Luncheon, Banquet and Breakfast WILL NOT be available for purchase at the event.</span></li>\n</ul>\n<h2>Vegetarian Meals</h2>\n<ul>\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Vegetarian meals are available for the Luncheon, Banquet and Breakfast and must be pre-ordered. Simply enter the number of vegetarian meals on the registration form as you enter the quantity of tickets.</span></li>\n\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">At the hotel’s request, no onsite requests for vegetarian meals will be honored.</span></li>\n\n    <li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The SFV Convention makes every attempt to accommodate special dietary requests; however, all meal preparation is controlled by the hotel. Therefore, we cannot guarantee the availability of each and every request.</span></li>\n</ul>','','','','','',0,0,'2018-09-02 10:42:16','2021-09-13 18:14:22'),(40,23,'en','chairpersons-message-aa','AA Chairperson\'s Message','AA Chairperson\'s Message','',NULL,'<p span style=\"font-weight: 400;\">Welcome Convention Family, Friends, and Guests!</p>\n\n<p span style=\"font-weight: 400;\">On behalf of the AA Convention Planning Committee, I’d like to extend a warm and sincere WELCOME HOME to the 46th annual San Fernando Valley AA Convention with Al-Anon and Alateen participation.  After a year’s absence, we are thrilled to return to the Warner Center Marriott in Woodland Hills California to bring to you the live, in person conference we have all enjoyed and cherished throughout our recovery.</p>\n\n<p span style=\"font-weight: 400;\">This year’s theme, ”Rocketed Into A Fourth Dimension”, comes from the “spiritual experience” described on page 25 of the Big Book of Alcoholics Anonymous.  The text is not the experience of one person, but that of many people who have come to stay in Alcoholics Anonymous.  “We had found much of heaven and we have been rocketed into a fourth dimension of existence of which we had not even dreamed”.</p>\n\n<p span style=\"font-weight: 400;\">When I first showed up on the doorstep of AA, it never occurred to me exactly what connecting to a higher power, to my fellows, and to my own spirit would do for my life.  Taking AA’s Twelve Steps would make me accountable for my flattened view of what life was for me.  AA gave me the opportunity to grow my life into an enlightened view of what it could be now.  Being able to see life from this substantial new angle, I was able to find the hope, belief and ability to make that new view into reality.  I was no longer choosing to walk alone on a selfish and unaided path, I was now on a road where others mattered and where it was easy and natural to connect to God’s will for me.  This was an existence I had never known before.  I had been rocketed into a new dimension of living, moving past my personal twilight zone, with spiritual connection and feet firmly planted on the ground.  This place of both Spirit and Earth put my heart in exactly the right place and I knew I was now truly part of a world where I loved and felt love.  My life had taken on new meaning and the obsession to drink was lifted.  Every day when I allow my spirit to connect ahead of my human thoughts, I can get out of my own way and remain in this fourth dimension of existence that has no room for any of my former obsessions.  What a great place to be!</p>\n\n<p span style=\"font-weight: 400;\">It has been my honor to serve as the Chairperson of this Planning Committee throughout the pandemic.  The people who work tirelessly to put on this conference have done a stellar job keeping the SFVAA Convention alive and healthy in a time when a virus threatened all we have come to know.  When our reality was deep in lock-down, we brought you a wildly successful Unconventional convention and I have profound gratitude to the Unconventional Planning Committee for all their hard work.  This year we have been allowed to come back strong and in person, and, while there have been challenges and limitations along the way, the Convention Planning Committee is once again working hard to bring to you a Conventional Convention filled with recovery, marathon meetings, exciting events with great speakers, all wrapped within an atmosphere of love and fellowship you can expect to find in the Fourth Dimension.</p>\n\n<p span style=\"font-weight: 400;\">A much heartfelt thanks to my hardworking and creative Co-Chairperson, Sande B; the bright and beautiful Al-Anon team, headed up by Chairperson, Keith K, and Co-Chairperson, Laura B; and our awesome Alateen Chairperson, Claire A.  It has been my delight to work with each of them as well as their respective team of volunteers.  I am in amazement at the efforts made and the convention we have produced together. There is no doubt that the result will be an extremely incredible and memorable weekend.</p>\n\n\n<p span style=\"font-weight: 400;\">In Love and Service (and direct from the Fourth Dimension),<br />\nTodd G.<br />\n2022 SFVAA Convention Chairperson</p>','','','','','',1,1,'2020-10-09 23:23:57','2020-10-21 11:30:05'),(41,24,'en','chairpersons-message-al-anon','Al-Anon Chairperson\'s Message','Al-Anon Chairperson\'s Message','',NULL,'<p><span style=\"font-weight: 400;\">Welcome Al-Anon, Alateen, and A.A. Family and Friends!</span></p>\n\n<p><span style=\"font-weight: 400;\">It is my great pleasure to welcome you to the 46th Annual San Fernando Valley A.A. Convention with Al-Anon and Alateen participation. On behalf of the Al-Anon Convention Planning Committee, guest speakers and volunteers, I extend our wishes that you have a marvelous return to the traditional convention experience.</span></p>\n\n<p><span style=\"font-weight: 400;\">Although each year is presented with its unique challenges, this year has seen a much anticipated return to our usual convention, but with restrictions unlike any previous year. Undaunted, the Al-Anon Planning Committee has persevered to ensure that the excitement and the camaraderie and, especially the recovery, continue.</span></p>\n\n<p><span style=\"font-weight: 400;\">My journey in recovery began in 2000 and I attended my first SFVAA Convention with a mere twenty days in these rooms. I joined the Planning Committee in 2003 and have maintained a presence at this convention since. You have shown me that if I keep coming back, I will witness the change to become the person I want to be. You told me that your story is just like mine: \"Someone hurt me ... and I got lucky.\" And you demonstrated how you would love me until I could love myself. I am grateful to be a part of this fellowship and that we could continue to bring this magnificent event to you, the family that I got to choose.</span></p>\n\n<p><span style=\"font-weight: 400;\">Many thanks to Todd G. and Sande B. and Alcoholics Anonymous for allowing and encouraging Al-Anon and Alateen participation in this very special event. And thanks to the Executive Committee: Laura B., Sydney K., and Heather G. for putting up with me while so proficiently supporting this fantastic endeavor. And to Frankie Anne for being the wizened advisor and muse. And to the Planning Committee for creatively producing a revived convention under such challenging circumstances.  This, indeed, promises to be the SFVAAC that we have waited for.</span></p>\n\n<p><span style=\"font-weight: 400;\">Loving being of service,</span></p>\n\n<p><span style=\"font-weight: 400;\">Keith K.<br />\n2022 SFVAA Convention Al-Anon Chair</span></p>\n','','','','','',0,0,'2018-09-02 10:47:23','2020-10-21 11:33:23'),(43,26,'en','chairpersons-message-alateen','Alateen Chairperson\'s Message','Alateen Chairperson\'s Message','',NULL,'<p><span style=\"font-weight: 400;\">Welcome to the 46th Annual San Fernando Valley A.A. Convention with Al-Anon and Alateen participation!  After a year and a half of only seeing each other in an online chat room, I am super excited to see everyone in person!  It is a huge honor to be serving as your Alateen Chair this year, and I know it’s going to be a great convention!</span></p>\n\n<p><span style=\"font-weight: 400;\">I have been attending this convention since 2005 when I just tagged along with my gramma.  Although I didn’t know exactly what was going on, I could tell that everybody was having a really good time, and I noticed there were always lots of hugs in the hallways!</span></p>\n\n<p><span style=\"font-weight: 400;\">I was so excited when I was old enough to actually participate with the Alateens because it was right around the time when my dad was getting sober, so I knew it was important for our whole family to be focused on recovery.  In my meetings, I found a safe space to talk honestly about what was going on in my life, and I was able to share with other kids that there is always hope to be found in the rooms of Alateen.</span></p>\n\n<p><span style=\"font-weight: 400;\">The thing I love the most about being in Alateen is the fun and friendships that we develop along the way.  Whether you have participated in our convention before or not, I know we are all going to have an amazing weekend, with something for everyone!</span></p>\n\n<p><span style=\"font-weight: 400;\">I’d like to thank our A.A. Chair, Todd G., our Al-Anon Chair, Keith K., and all our AMIAS and Alateen sponsors for helping me throughout this year.</span></p>\n\n<p><span style=\"font-weight: 400;\">I hope you’ll join us as we are Rocketed Into the Fourth Dimension of fun and fellowship, and thank you again for the honor of allowing me to serve as this year’s Alateen Chair!</span></p>\n\n<p><span style=\"font-weight: 400;\">In love and service,</span></p>\n\n<p><span style=\"font-weight: 400;\">Claire A.<br />\n2022 Alateen Chair\r\n','','','','','',0,0,'2018-09-02 10:47:23','2020-11-01 11:15:02'),(44,27,'en','welcome','Welcome','Welcome','',NULL,'','','','','','',0,0,'2018-09-15 13:34:21','2018-09-15 13:34:21'),(46,23,'it','information-aa-message','Information AA message','Information AA Message',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL),(47,24,'it','information-al-anon-message','Information Al-Anon message','Information Al-Anon Message',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL),(48,26,'it','information-alateen-message','Information Alateen message','Information Alateen Message',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL),(49,22,'it','information-about','Information About','Information About',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL),(50,27,'it','welcome','Welcome','Welcome',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL),(51,28,'en','marathon_signup','Marathon Request','Marathon Meeting Request Form','Meeting Request Form',NULL,'<p>Marathon Meeting Request Page</p>','<p>&nbsp;Form to sign up for Marathon Meetings</p>','','','','',0,0,'2019-10-04 21:44:21','2019-10-04 21:50:52'),(52,29,'en','#pills-aa-marathon','AA Marathon Meetings','Marathon Meeting Schedule','Meeting Schedule',NULL,'<p>Marathon Meeting Schedule</p>','<p>Redirect to Marathon Meetings view</p>','','','','',0,0,'2020-01-17 13:18:24','2021-10-22 16:45:06'),(53,16,'it','testproduct','test product','test product','test product',NULL,'<p>test product&nbsp;test product&nbsp;test product&nbsp;test product&nbsp;test product&nbsp;test product</p>','<p>test product</p>','','','','',0,0,'2018-04-09 20:22:17','2018-04-09 20:22:17'),(54,17,'it','events-schedule','Events Schedule ','Events Schedule','schedule',NULL,'<p>Events Schedule Page</p>','','','','','',0,0,'2018-04-22 09:36:03','2018-04-22 09:36:03'),(55,18,'it','speaker-meetings','Speaker Meetings','Speaker Meetings','Speaker Meetings',NULL,'<p>Speaker Meetings Schedule</p>','','','','','',0,0,'2018-04-22 09:38:43','2018-04-22 09:38:43'),(56,19,'it','marathon-meetings','Marathon Meetings','Marathon Meetings','Marathon Meetings',NULL,'<p>Marathon meetings schedule</p>','','','','','',0,0,'2018-04-22 09:41:05','2018-04-22 09:41:05'),(57,20,'it','al-anon-events','Al-Anon Events','Al-Anon Events','Al-Anon Events',NULL,'<p>Check back soon for the Al-Anon Events schedule.</p>','','','','','',0,0,'2018-04-22 09:43:41','2018-04-22 09:43:41'),(58,21,'it','all-events','All Events','All Events','All Events',NULL,'<ul id=\"pills-tab\" class=\"nav nav-pills mb-3\">\r\n<li class=\"nav-item\"><a id=\"pills-events-tab\" class=\"nav-link active\" href=\"#pills-events\" data-toggle=\"pill\">Events Schedule</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-speaker-tab\" class=\"nav-link\" href=\"#pills-speaker\" data-toggle=\"pill\">Speaker Meetings</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-marathon-tab\" class=\"nav-link\" href=\"#pills-marathon\" data-toggle=\"pill\">Marathon Meetings</a></li>\r\n<li class=\"nav-item\"><a id=\"pills-alanon-tab\" class=\"nav-link\" href=\"#pills-alanon\" data-toggle=\"pill\">Al-Anon Events</a></li>\r\n</ul>\r\n<div id=\"pills-tabContent\" class=\"tab-content\">\r\n<div id=\"pills-events\" class=\"tab-pane fade show active\">\r\n<h2>ALCOHOLICS ANONYMOUS MEETINGS</h2>\r\n<ul>\r\n<li>AA Speaker Meetings</li>\r\n<li>AA Marathons</li>\r\n<li>Saturday Night Speaker Meeting</li>\r\n<li>Sunday Morning Spiritual Meeting</li>\r\n<li>Young Peoples Meetings</li>\r\n</ul>\r\n<p><a href=\"#\">View the AA Meeting Schedule</a></p>\r\n<h2>AL-ANON MEETINGS</h2>\r\n<ul>\r\n<li>Opening Topic Meeting</li>\r\n<li>Al-Anon Luncheon</li>\r\n<li>Al-Anon Marathon Meetings</li>\r\n<li>Final Topic Meeting</li>\r\n</ul>\r\n<p><a href=\"#\">View the Al-Anon Meeting Schedule</a></p>\r\n<h2>Ceremonies &amp; Entertainment</h2>\r\n<ul>\r\n<li>Opening Ceremonies</li>\r\n<li>Saturday BBQ</li>\r\n<li>Music</li>\r\n<li>Dancing</li>\r\n<li>AA Movies</li>\r\n</ul>\r\n<h2>Sporting Events</h2>\r\n<ul>\r\n<li>5K Fun Run/Walk</li>\r\n<li>Golf Tournament</li>\r\n</ul>\r\n<h2>Al-Anon Luncheon</h2>\r\n<ul>\r\n<li>Date: Saturday, August 25, 2018</li>\r\n<li>Time: 11:30am&nbsp;(doors open at 11:00am)</li>\r\n<li>Place: Madonna Inn\'s Garden Room</li>\r\n<li>Attendees MUST be registered for the convention and the event to attend. Seating is limited and sells out quickly! Pre-registration is recommended. For any questions, email:&nbsp;<a class=\"email\" href=\"mailto:alanonlunchdistrict22convention@gmail.com\">alanonlunchdistrict22convention@gmail.com</a>.</li>\r\n</ul>\r\n<h2>Golf Tournament</h2>\r\n<ul>\r\n<li>Date: Friday, Aug. 24, 2018</li>\r\n<li>Time: 7:30am</li>\r\n<li>Place: Monarch Dunes Golf Course</li>\r\n<li>Come golf with us at the Dunes. Format is a four person scramble with Men\'s and Women\'s long drive and closest to the pin contests.</li>\r\n<li>For more information, contact Matt G. at (805) 610-2571.</li>\r\n</ul>\r\n<h2>5K Fun Run/Walk</h2>\r\n<ul>\r\n<li>Date: Saturday, Aug. 25, 2018</li>\r\n<li>Time: 8:00am</li>\r\n<li>Place: 801 Grand Ave., SLO</li>\r\n<li>No T-shirts and no participation charge or registration this year. Just come out for fun and fellowship. Contact Matt E. at<br />(805) 478-8401 for information.</li>\r\n</ul>\r\n</div>\r\n<div id=\"pills-speaker\" class=\"tab-pane fade\">\r\n<table class=\"table table-striped table-bordered\">\r\n<tbody>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Friday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>8:00p</td>\r\n<td>Friday Night Speaker Meeting<br /><small>speaker: </small>Steve L., Nashville, TN</td>\r\n</tr>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Saturday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>11:30a</td>\r\n<td>Al-Anon Luncheon Speaker Meeting<br /><small>speaker: </small>Larcine G., Hawthorne</td>\r\n</tr>\r\n<tr>\r\n<td>2:30p</td>\r\n<td>H&amp;I Speaker Meeting<br /><small>speaker: </small>Bill D., Rocklin</td>\r\n</tr>\r\n<tr>\r\n<td>6:00p</td>\r\n<td>Young People&rsquo;s Speaker Meeting<br /><small>speaker: </small>Mary Ann, Los Angeles</td>\r\n</tr>\r\n<tr>\r\n<td>8:00p</td>\r\n<td>Saturday Night Speaker Meeting<br /><small>speaker: </small>Bill C., Torrance</td>\r\n</tr>\r\n<tr class=\"warning\">\r\n<td colspan=\"2\"><strong>Sunday, August 25</strong></td>\r\n</tr>\r\n<tr>\r\n<td>10:00a</td>\r\n<td>Sunday Morning Speaker Meeting<br /><small>speaker: </small>Patricia P., Los Angeles</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n<div id=\"pills-marathon\" class=\"tab-pane fade\">This will also be like Tab 2</div>\r\n<div id=\"pills-alanon\" class=\"tab-pane fade\">Al-Anon events. This will be similar to tab 1 I think</div>\r\n</div>','','','','','',0,0,'2018-04-22 09:45:18','2018-04-22 09:47:57'),(59,28,'it','marathon_signup','Marathon Request','Marathon Meeting Request Form','Meeting Request Form',NULL,'<p>Marathon Meeting Request Page</p>','<p>&nbsp;Form to sign up for Marathon Meetings</p>','','','','',0,0,'2019-10-04 21:44:21','2019-10-04 21:50:52'),(60,29,'it','#pills-aa-marathon','Marathon Meetings','Marathon Meeting Schedule','Meeting Schedule',NULL,'<p>Marathon Meeting Schedule</p>','<p>Redirect to Marathon Meetings view</p>','','','','',0,0,'2020-01-17 13:18:24','2020-01-17 13:18:24'),(62,30,'en','marathons','Marathons','Marathons','Marathons',NULL,'<p>Marathon Meeting Schedule</p>','','','','','',0,0,'2018-09-02 10:47:23','2021-10-22 17:04:35'),(65,33,'en','#pills-al-anon-marathon','Al-Anon Marathon Meetings','Al-Anon Marathons','Al-Anon Marathons',NULL,'','','','','','',0,0,'2021-10-22 17:05:56','2021-10-22 17:05:56'),(68,34,'en','covid-19-update','COVID-19 Update','COVID-19 Update','',NULL,'<p style=\"font-style:italic\">\"Our common welfare should come first...\"</p>\n\n<div style=\"font-size:larger; font-weight:bold; color:red;\">Covid-19 Protocols for the 2022 SFVAA Convention</div>\n\n<p style=\"padding-top:20px; color:red; font-weight:bold;\">UPDATED January 24, 2022</p>\n\n<p style=\"padding-top:20px\">As promised the SFVAA Convention Committee wants to keep you informed of all changes in guidelines that affect our Convention. <span style=\"color:red; font-weight:bold\">Recent updates</span> are highlighted in <span style=\"color:red; font-weight:bold\">RED</span>.</p>\n\n<p style=\"padding-top:20px\">The SFVAA Convention Committee takes seriously our responsibility to provide the safest environment we can in these difficult and unprecedented times. Therefore, in compliance with the City and County of Los Angeles COVID-19 ordinances, the following protocols will be in place at this year\'s convention:</p>\n<ol>\n    <li style=\"padding-bottom:10px;\">Masks will be required at all times while indoors at the Marriott. This includes all hallways, elevators and meeting rooms. Your mask must cover your mouth AND your nose. Both Marriott and Convention Security will be enforcing this guideline. Anyone who does not wear a properly fitting mask will be asked to leave by Convention and Marriott Security. Masks will be available on site.</span></li>\n    <li style=\"padding-bottom:10px;\">All events held in the Grand Ballroom, as well as the Al-Anon Opening Meeting and Al-Anon Skit in the Hidden Hills Room, will require proof of full vaccination or proof of a negative COVID-19 viral test result within 72 hours prior to entry at the Marriott. PCR tests must be conducted within 48 hours prior to entry, and antigen tests must be conducted within 24 hours. Home tests are not acceptable. If you need further clarification regarding vaccination and testing requirements, please refer to the links provided at the bottom of this notice.</li>\n    <li style=\"padding-bottom:10px;\">In order to verify your vaccination/testing status, we will have COVID-19 Compliance Officers located in the hallway to the left of the Grand Ballroom during the following hours:<br />\n        <p style=\"margin: 20px 0 0 20px;\">\n            Friday, January 28, 2022 - 4:00 pm to 10:00 pm<br />\n            Saturday, January 29, 2022 - 9:00 am to 9:00 pm<br />\n            Sunday, January 30, 2022 - 8:00 am to 11:00 am\n        </p>\n        <p style=\"padding-top:15px;\">The COVID-19 Compliance Officers will provide you with a wristband once your vaccination or negative test status has been verified and this wristband will be required for entry into all events listed in Paragraph #2 above.</p>\n        <p style=\"padding-top:15px; color:red; font-weight: bold;\">If you are using a negative COVID test to enter the convention:</p>\n        <ol type=\"A\">\n            <li style=\"color:red; font-weight: bold;\">HOME TESTS WILL NOT BE ACCEPTED.</li>\n            <li style=\"color:red; font-weight: bold;\">Tests are only good for 72 hours from the time the test was taken.</li>\n            <li style=\"color:red; font-weight: bold;\">Please see below for some free COVID Rapid Testing Sites.</li>\n        </ol>\n\n        <p style=\"padding-top:15px; color:red; font-weight: bold;\">Your test must be dated Thursday, 1/27/22 or later to be able to attend any event on Sunday.</p>\n    </li>\n    <li style=\"padding-bottom:10px;\">The Hospitality Room will be open for all to purchase food and drink, however a wristband will be required in order to sit and eat in the Hospitality Room.</li>\n    <li style=\"padding-bottom:10px;\">Marathon Meetings will not allow any food or drink, and masks must be worn. Proof of vaccination or a negative COVID-19 test is not required for Marathon Meetings.</li>\n    <li style=\"padding-bottom:10px;\">Lecterns will be sanitized between readers and speakers in all meeting and marathon rooms.</li>\n</ol>\n<p>We appreciate your understanding as we strive to bring you the best possible convention this year. If you are not comfortable with the LA County guidelines, we respectfully ask that you simply skip the convention this year, but we look forward to welcoming you back in 2023.</p>\n<h3 style=\"color:red;\">Here are some free COVID Rapid Testing locations:</h3>\n<p style=\"color:red; font-weight: bold;\">Go online today to make an appointment: <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://covid19.lacounty.gov/testing\">https://covid19.lacounty.gov/testing</a></p>\n            \n<p style=\"padding-top:20px; color:red; font-weight: bold;\">West Valley Family YMCA<br />\n    18810 Vanowen Street<br />\n    Reseda, CA 91335<br />\n    <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://www.google.com/maps/place/18810+Vanowen+St,+Reseda,+CA+91335/@34.1934933,-118.545563,17z/data=34.1934933!4d-118.5433743\">Map</a>\n</p>\n<p style=\"padding-top:20px;color:red; font-weight: bold;\">Balboa Park<br />\n    5903 N. Balboa Boulevard<br />\n    Van Nuys, CA 91316<br />\n    <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://www.google.com/maps/place/5903+Balboa+Blvd,+Encino,+CA+91316/@34.1787933,-118.5036957,17z/data=34.1787933!4d-118.501507\">Map</a>\n</p>\n<p style=\"padding-top:20px;color:red; font-weight: bold;\">Pierce College<br />\n    6201 Winnetka Avenue<br />\n    Parking Lot #7<br />\n    Woodland Hills, CA<br />\n    <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://www.google.com/maps/place/Winnetka,+CA+91306/@34.1876129,-118.5803519,18z/data=!3m1!4b1!4m8!1m2!3m1!2sPierce+College+Parking+Lot+7!3m4!1s0x80c2995552e1108d:0x15d2626ef18537ea!8m2!3d34.1876129!4d-118.5796902\">Map</a>\n</p>\n<p style=\"padding-top:20px;color:red; font-weight: bold;\">Sepulveda Recreation Center<br />\n    8825 Kester Avenue<br />\n    Panorama City, CA<br />\n    <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://www.google.com/maps/place/8825+Kester+Ave,+Panorama+City,+CA+91402/@34.229917,-118.4600758,17z/data=34.229917!4d-118.4578818\">Map</a>\n</p>\n<p style=\"padding-top:20px;color:red; font-weight: bold;\">Richie Valens Park<br />\n    10726 Laurel Canyon Boulevard<br />\n    Pacoima, CA<br />\n    <a style=\"text-decoration:underline;\" target=\"_blank\" href=\"https://www.google.com/maps/place/10726+Laurel+Canyon+Blvd,+Pacoima,+CA+91331/@34.2656129,-118.4407115,17z/data=34.2656129!4d-118.4385175\">Map</a>\n</p>\n\n<h3>Questions? Concerns?</h3>\n\n<p>Email us at <a href=\"mailto:info@sfvaaconvention.org\">info@sfvaaconvention.org</a> </p>\n\n<h3>Additional Information</h3>\n\n<p>For additional information on newest LA County guidelines, click\n    here:<br />\n    <a style=\"margin-left:20px; text-decoration:underline;\" target=\"_blank\"\n    href=\"https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Beyond-Blueprint-Framework.aspx#asterisk2\">https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Beyond-Blueprint-Framework.aspx#asterisk2</a>\n</p>\n\n<p>To see the Los Angeles County requirements for Proof of Full Vaccination, click here:<br />\n    <a style=\"margin-left:20px; text-decoration:underline;\" target=\"_blank\"\n    href=\"http://publichealth.lacounty.gov/media/Coronavirus/docs/HOO/Proof_vaccine_card.pdf\">http://publichealth.lacounty.gov/media/Coronavirus/docs/HOO/Proof_vaccine_card.pdf</a>\n</p>\n\n<p>To see the Los Angeles County requirements for proof negative COVID-19 viral test result, click here:<br />\n    <a style=\"margin-left:20px; text-decoration:underline;\" target=\"_blank\"\n    href=\"http://publichealth.lacounty.gov/media/Coronavirus/docs/HOO/Proof_neg_test.pdf\">http://publichealth.lacounty.gov/media/Coronavirus/docs/HOO/Proof_neg_test.pdf</a>\n</p>\n\n<p>To access a digital copy of your vaccination record, click here:<br />\n    <a style=\"margin-left:20px; text-decoration:underline;\" target=\"_blank\"\n    href=\"https://myvaccinerecord.cdph.ca.gov/\">https://myvaccinerecord.cdph.ca.gov/</a>\n</p>','','','','','',1,1,'2021-10-25 17:15:47','2021-10-25 17:15:47'),(69,35,'en','aa-marathons','AA Marathon Meetings','AA Marathon Meetings','',NULL,'<p>Coming soon</p>','<p>Coming soon (abstract)</p>','','','','',1,1,'2021-10-25 18:20:59','2021-10-25 22:23:52'),(70,36,'en','al-anon-marathons','Al-Anon Marathon Meetings','Al-Anon Marathon Meetings','',NULL,'<p>Coming Soon</p>','<p>Coming Soon (abstract)</p>','','','','',0,0,'2021-10-25 18:32:30','2021-10-25 18:33:07'),(71,37,'en','regclosed','','Online Registration','Online pre-registration Closed',NULL,'<p>Pre-registration for Rocketed Into A Fourth Dimension, the 46th Annual SFVAA Convention with Al-Anon and Alateen participation has closed and is no longer available online.</p>\r\n<p>You will have the opportunity to purchase your registration and any commemorative merchandise on site at the Warner Center Marriott when the convention begins.</p>\r\n<p>We look forward to welcoming you to the Convention on January 28, 29 and 30, 2022.</p>','','','','','',0,0,'2022-01-17 11:01:37','2022-01-18 04:05:48');

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menu_title` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT '',
  `subtitle` varchar(255) DEFAULT NULL,
  `intro` varchar(255) DEFAULT NULL,
  `abstract` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image_caption` varchar(255) DEFAULT NULL,
  `image_width` varchar(255) DEFAULT NULL,
  `image_height` varchar(255) DEFAULT NULL,
  `image_position` varchar(255) DEFAULT NULL,
  `image_credits` varchar(255) DEFAULT NULL,
  `is_rich_text` tinyint(4) NOT NULL DEFAULT 1,
  `sort` int(11) NOT NULL,
  `published` tinyint(4) DEFAULT 1,
  `top_menu` int(11) DEFAULT 1,
  `is_parent` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` VALUES (44,'Register','Serenity by the Sea 2024 Registration',NULL,NULL,NULL,'<p>Welcome! To complete your registration, kindly provide your name, address, phone, and email. Specify the number of registrations and personalize badge names. Consider a voluntary donation and share any special notes. The event fee is $50 per person. Secure your spot soon, and thank you for being part of Serenity by the Sea 2024!</p>\r\n\r\n<p>Payments for registration, ticketed events, and contributions are made via credit card by clicking PAY NOW on the order review page during the registration process.</p>\r\n\r\n<p><strong>EVERYONE WHO ATTENDS THE EVENT MUST BE REGISTERED.</strong></p>','register',NULL,NULL,NULL,NULL,NULL,NULL,1,3000,1,1,0,NULL,NULL,1,0,'2022-03-21 17:50:22','2023-09-17 17:25:18'),(46,'Documentation','Help',NULL,NULL,NULL,'<p>&nbsp;</p>\r\n\r\n<p><a href=\"/docs/orders\">Orders</a></p>\r\n\r\n<p><a href=\"/docs/meals\">Meals</a></p>\r\n\r\n<p><a href=\"/docs/meetings\">Meetings</a></p>\r\n\r\n<p><a href=\"/docs/help\">Help</a></p>\r\n\r\n<p>Documentation</p>','docs',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,NULL,NULL,1,0,'2022-03-21 13:50:22','2022-04-15 03:45:55'),(47,'Orders','Orders',NULL,NULL,NULL,'<p>&nbsp;</p>\r\n\r\n<p><a href=\"/docs/orders\">Orders</a></p>\r\n\r\n<p><a href=\"/docs/meals\">Meals</a></p>\r\n\r\n<p><a href=\"/docs/meetings\">Meetings</a></p>\r\n\r\n<p><a href=\"/docs/help\">Help</a></p>','Orders',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,46,NULL,1,0,'2022-03-21 13:50:22','2022-05-13 03:54:00'),(48,'Meetings','Meetings',NULL,NULL,NULL,'<p>&nbsp;</p>\r\n\r\n<p><a href=\"/docs/orders\">Orders</a></p>\r\n\r\n<p><a href=\"/docs/meals\">Meals</a></p>\r\n\r\n<p><a href=\"/docs/meetings\">Meetings</a></p>\r\n\r\n<p><a href=\"/docs/help\">Help</a></p>','meetings',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,46,NULL,1,0,'2022-03-21 13:50:22','2022-05-13 03:53:26'),(49,'Meals','Meals',NULL,NULL,NULL,'<p>&nbsp;</p>\r\n\r\n<p><a href=\"/docs/orders\">Orders</a></p>\r\n\r\n<p><a href=\"/docs/meals\">Meals</a></p>\r\n\r\n<p><a href=\"/docs/meetings\">Meetings</a></p>\r\n\r\n<p><a href=\"/docs/help\">Help</a></p>','meals',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,46,NULL,1,0,'2022-03-21 13:50:22','2022-05-13 03:53:07'),(50,'Help','Help',NULL,NULL,NULL,'<p>&nbsp;</p>\r\n\r\n<p><a href=\"/docs/orders\">Orders</a></p>\r\n\r\n<p><a href=\"/docs/meals\">Meals</a></p>\r\n\r\n<p><a href=\"/docs/meetings\">Meetings</a></p>\r\n\r\n<p><a href=\"/docs/help\">Help</a></p>','help',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,46,NULL,1,0,'2022-03-21 13:50:22','2022-05-13 03:53:47'),(52,'Policies','Policies',NULL,NULL,NULL,'<p>Policies</p>\r\n\r\n<ul>\r\n	<li><a href=\"/policies/privacy-policy\">Privacy Policy</a></li>\r\n	<li><a href=\"/policies/terms-of-use\">Terms of Use</a></li>\r\n</ul>','policies',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,NULL,0,1,0,'2022-04-09 09:27:16','2022-04-11 13:55:50'),(53,'Privacy Policy','Privacy Policy',NULL,'<h1>Privacy Policy</h1>\r\n\r\n<p>&nbsp;</p>','<h1>Privacy Policy</h1>\r\n\r\n<p>&nbsp;</p>','<ul>\n    <li><a href=\"/policies/privacy-policy\">Privacy Policy</a></li>\n    <li><a href=\"/policies/terms-of-use\">Terms of Use</a></li>\n</ul>\n\n<h2>&nbsp;</h2>\n\n<h1>Privacy Policy</h1>\n\n<p>This privacy policy sets out how SFV Convention uses and protects any information that you give SFV Convention when you use this website. SFV Convention is committed to ensuring that your privacy is protected. Should we ask you to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. SFV Convention may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes.</p>\n\n<h2>What we collect</h2>\n\n<p>We may collect the following information:</p>\n\n<ul>\n    <li>name</li>\n    <li>contact information including email address</li>\n    <li>demographic information such as postcode, preferences and interests</li>\n    <li>other information relevant to customer surveys and/or offers</li>\n</ul>\n\n<h2>What we do with the information we gather</h2>\n\n<p>We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:</p>\n\n<ul>\n    <li>Internal record keeping.</li>\n    <li>We may use the information to improve our products and services.</li>\n    <li>We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided.</li>\n    <li>From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information to customise the website according to your interests.</li>\n</ul>\n\n<h2>Security</h2>\n\n<p>We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure, we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.</p>\n\n<h2>How we use cookies</h2>\n\n<p>A cookie is a small file which asks permission to be placed on your computer&#39;s hard drive. Once you agree, the file is added and the cookie helps analyse web traffic or lets you know when you visit a particular site. Cookies allow web applications to respond to you as an individual. The web application can tailor its operations to your needs, likes and dislikes by gathering and remembering information about your preferences.</p>\n\n<p>We use traffic log cookies to identify which pages are being used. This helps us analyse data about web page traffic and improve our website in order to tailor it to customer needs. We only use this information for statistical analysis purposes and then the data is removed from the system.</p>\n\n<p>Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website.</p>\n\n<h2>Links to other websites</h2>\n\n<p>Our website may contain links to other websites of interest. However, once you have used these links to leave our site, you should note that we do not have any control over that other website. Therefore, we cannot be responsible for the protection and privacy of any information which you provide whilst visiting such sites and such sites are not governed by this privacy statement. You should exercise caution and look at the privacy statement applicable to the website in question.</p>\n\n<h2>Controlling your personal information</h2>\n\n<p>You may choose to restrict the collection or use of your personal information in the following ways:</p>\n\n<ul>\n    <li>whenever you are asked to fill in a form on the website, look for the box that you can click to indicate that you do not want the information to be used by anybody for direct marketing purposes</li>\n    <li>if you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at info@sfvaac.orgg</li>\n</ul>\n\n<p>We will not sell, distribute or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen.</p>\n\n<p>You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you would like a copy of the information held on you please write to PO Box 573413 Tarzana, CA 91357-3413&nbsp;</p>\n\n<p>If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.</p>','privacy-policy-304',NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,0,0,52,0,1,0,'2022-04-09 09:27:16','2022-09-03 19:48:56'),(54,'Terms of Use','Terms of Use',NULL,NULL,NULL,'<ul>\r\n	<li><a href=\"/policies/privacy-policy\">Privacy Policy</a></li>\r\n	<li><a href=\"/policies/terms-of-use\">Terms of Use</a></li>\r\n</ul>\r\n\r\n\n  <div class=\"container mx-auto my-8 p-8 bg-white shadow-md rounded-md\">\n\n    <h1 class=\"text-3xl font-bold mb-6\">Terms of Use</h1>\n\n    <p class=\"mb-4\">\n      Welcome to the Serenity by the Sea website. By accessing and using this website, you agree to comply with and be bound by the following terms and conditions of use. If you do not agree with these terms, please do not use this website.\n    </p>\n\n    <h2 class=\"text-xl font-semibold mb-4\">1. Event Registration</h2>\n\n    <p class=\"mb-4\">\n      To attend the Serenity by the Sea event, guests are required to purchase one or more seats. Registration fees are non-refundable. Seats are limited and will be allocated on a first-come, first-served basis.\n    </p>\n\n    <h2 class=\"text-xl font-semibold mb-4\">2. Event Duration</h2>\n\n    <p class=\"mb-4\">\n      The Serenity by the Sea event is scheduled to last for four hours. Guests are expected to arrive on time and encouraged to stay for the entire duration of the event.\n    </p>\n\n    <h2 class=\"text-xl font-semibold mb-4\">3. Code of Conduct</h2>\n\n    <p class=\"mb-4\">\n      All guests are expected to conduct themselves in a respectful and courteous manner during the event. Any disruptive or inappropriate behavior may result in removal from the premises without refund.\n    </p>\n\n    <h2 class=\"text-xl font-semibold mb-4\">4. Disclaimer</h2>\n\n    <p class=\"mb-4\">\n      This website and the Serenity by the Sea event are provided \"as is\" without any warranties, expressed or implied. The organizers of the event are not responsible for any loss, injury, or damage that may occur during the event.\n    </p>\n\n    <h2 class=\"text-xl font-semibold mb-4\">5. Changes to Terms</h2>\n\n    <p class=\"mb-4\">\n      The organizers reserve the right to update or modify these terms of use at any time without prior notice. It is the responsibility of the user to check for changes periodically.\n    </p>\n\n    <p class=\"mt-8\">\n      For any questions regarding these terms of use, please contact us at <a href=\"mailto:info@serenitybythesea.org\">info@serenitybythesea.org</a>.\n    </p>\n\n  </div>\n','terms-of-use',NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,52,0,1,0,'2022-04-09 09:27:16','2022-04-11 13:59:44'),(55,'home','District 3 Al-Anon Serenity by the Sea Luncheon Event, 2024',NULL,NULL,NULL,'<div class=\"max-w-md md:max-w-2xl lg:max-w-4xl text-left text-gray-700\">\r\n      <p class=\"mb-4\"><span class=\"font-bold text-gray-800\">SAVE THE DATE</span><br>February 24, 2024, 10 am – 2:30 pm<br>Ventana Grill, Pismo Beach, CA</p>\r\n\r\n      <p class=\"mb-4 font-bold\">Registration is <a class=\"underline italic\" href=\"/register\">full</a>. Join the waitlist today! </p>\r\n\r\n      <div class=\"mb-4\">\r\n        <p class=\"font-bold text-gray-800\">IN-PERSON EVENT</p>\r\n        <ul class=\"list-disc list-inside\">\r\n          <li>Luncheon: Herb chicken, salmon, rice pilaf, steamed veggies, green salad, rolls, and dessert!</li>\r\n          <li>Al-Anon Speakers: One main speaker and two local speakers! </li>\r\n          <li>Raffles: Baskets from the local District 3 Al-Anon meetings! </li>\r\n          <li>Fellowship: Gratitude, inspiration, and fun! </li>\r\n          <li>$50 per person</li>\r\n          <li><span class=\"font-bold text-gray-800\">Space is limited; please plan accordingly!</span></li>\r\n        </ul>\r\n      </div>\r\n\r\n      <p class=\"mb-4\">Please Note: We are inviting each Al-Anon Family Group in District 3 to begin to gather ideas and donations for your BASKET design for our raffle! Be Inspired, Get Creative, Live in Joy!</p>\r\n\r\n      <p class=\"mb-0 text-gray-800\">We look forward to seeing you at the annual Al-Anon Family Group Serenity by the Sea 2024 event!</p>\r\n    </div>','homepage',NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,0,0,NULL,NULL,0,28,'2022-04-15 04:25:50','2024-01-25 06:15:09'),(57,'Footer Links 1','Column 1','Events',NULL,NULL,'<p>\r\n<a class=\"hover:underline\" href=\"/events/schedule\">Convention Timeline</a><br />\r\n<a class=\"hover:underline\" href=\"/events/speaker-meetings\">Speaker Meetings</a><br />\r\n<a class=\"hover:underline\" href=\"/marathons/aa\">Marathon Meetings</a><br />\r\n<a class=\"hover:underline\" href=\"/events/schedule/?affiliation=2\">Al-Anon Events</a><br />\r\n<a class=\"hover:underline\" href=\"/events/fundraising-events\">Fundraising Events</a>\r\n</p>','homepage-footer-links1',NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,0,0,NULL,NULL,0,0,'2022-04-15 07:16:05','2023-08-25 16:04:39'),(58,'Events','Events','','','','sds','events','',NULL,NULL,NULL,NULL,NULL,1,1000,1,0,1,NULL,NULL,1,0,'2022-04-30 12:12:10','2022-04-30 12:12:10'),(65,'Contact Us','Contact Us','','','','sds','contacts','',NULL,NULL,NULL,NULL,NULL,1,6000,0,0,0,NULL,NULL,1,0,'2022-04-30 12:12:10','2022-04-30 12:12:10'),(73,'Footer Links 2','Column 2','Register','','','<p>\r\n<a class=\"hover:underline\" href=\"/register\">Registration</a><br />\r\n</p>','homepage-footer-links2','',NULL,NULL,NULL,NULL,NULL,1,2,0,0,NULL,NULL,NULL,0,0,'2022-05-17 17:31:51','2022-05-17 17:49:55'),(74,'Footer Links 3','Column 3','More',NULL,NULL,'<p>\r\n<a class=\"hover:underline\" href=\"/contacts\">Contact Us</a><br />\r\n<a class=\"hover:underline\" href=\"/information/about/\">About Us</a><br />\r\n<a class=\"hover:underline\" href=\"/information/hotel-information\">Hotel Information</a><br />\r\n<a class=\"hover:underline\" href=\"/information/convention-information\">Convention Information</a><br />\r\n<a class=\"hover:underline\" href=\"/information/volunteer\">Volunteer</a><br />\r\n</p>','homepage-footer-links3',NULL,NULL,NULL,NULL,NULL,NULL,1,3,0,0,NULL,NULL,NULL,0,0,'2022-05-17 17:39:05','2023-08-13 12:44:25'),(75,'Pre-Registration Closed','Serenity by the Sea','registration_closed',NULL,'','','registration-closed',NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,0,0,NULL,NULL,0,1,'2022-05-28 18:05:00','2024-01-22 08:09:49'),(86,'What\'s New','What\'s New','','','','<h2>Title</h2>\r\n\r\n<p>Para 1</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h2>Title 2</h2>\r\n\r\n<p>Para 2</p>\r\n\r\n<p>&nbsp;</p>','whats-new','',NULL,NULL,NULL,NULL,NULL,1,4800,0,0,NULL,39,NULL,0,0,'2022-09-14 23:39:39','2023-09-17 21:38:38'),(103,'Privacy Policy','Privacy Policy',NULL,'<h1>Privacy Policy</h1>\r\n\r\n<p>&nbsp;</p>','<h1>Privacy Policy</h1>\r\n\r\n<p>&nbsp;</p>','<ul>\n    <li><a href=\"/policies/privacy-policy\">Privacy Policy</a></li>\n    <li><a href=\"/policies/terms-of-use\">Terms of Use</a></li>\n</ul>\n\n<h2>&nbsp;</h2>\n\n<h1>Privacy Policy</h1>\n\n<p>This privacy policy sets out how Serenity by the Sea Committee uses and protects any information that you give Serenity by the Sea Committee when you use this website. Serenity by the Sea Committee is committed to ensuring that your privacy is protected. Should we ask you to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Serenity by the Sea Committee may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes.</p>\n\n<h2>What we collect</h2>\n\n<p>We may collect the following information:</p>\n\n<ul>\n    <li>name</li>\n    <li>contact information including email address</li>\n    <li>demographic information such as postcode, preferences and interests</li>\n    <li>other information relevant to customer surveys and/or offers</li>\n</ul>\n\n<h2>What we do with the information we gather</h2>\n\n<p>We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:</p>\n\n<ul>\n    <li>Internal record keeping.</li>\n    <li>We may use the information to improve our products and services.</li>\n    <li>We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided.</li>\n    <li>From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information to customise the website according to your interests.</li>\n</ul>\n\n<h2>Security</h2>\n\n<p>We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure, we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.</p>\n\n<h2>How we use cookies</h2>\n\n<p>A cookie is a small file which asks permission to be placed on your computer&#39;s hard drive. Once you agree, the file is added and the cookie helps analyse web traffic or lets you know when you visit a particular site. Cookies allow web applications to respond to you as an individual. The web application can tailor its operations to your needs, likes and dislikes by gathering and remembering information about your preferences.</p>\n\n<p>We use traffic log cookies to identify which pages are being used. This helps us analyse data about web page traffic and improve our website in order to tailor it to customer needs. We only use this information for statistical analysis purposes and then the data is removed from the system.</p>\n\n<p>Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website.</p>\n\n<h2>Links to other websites</h2>\n\n<p>Our website may contain links to other websites of interest. However, once you have used these links to leave our site, you should note that we do not have any control over that other website. Therefore, we cannot be responsible for the protection and privacy of any information which you provide whilst visiting such sites and such sites are not governed by this privacy statement. You should exercise caution and look at the privacy statement applicable to the website in question.</p>\n\n<h2>Controlling your personal information</h2>\n\n<p>You may choose to restrict the collection or use of your personal information in the following ways:</p>\n\n<ul>\n    <li>whenever you are asked to fill in a form on the website, look for the box that you can click to indicate that you do not want the information to be used by anybody for direct marketing purposes</li>\n    <li>if you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at info@serenitybts.orgg</li>\n</ul>\n\n<p>We will not sell, distribute or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen.</p>\n\n<p>You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you would like a copy of the information held on you please write to info@serenitybts.org&nbsp;</p>\n\n<p>If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.</p>','privacy-policy',NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,0,0,52,0,1,0,'2022-04-09 09:27:16','2022-09-03 19:48:56');

--
-- Table structure for table `attendees_orders`
--

CREATE TABLE `attendees_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `tag_line_1` varchar(25) DEFAULT NULL,
  `tag_line_2` varchar(25) DEFAULT NULL,
  `tag_line_3` varchar(25) DEFAULT NULL,
  `affiliation_type_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `attendees_orders`
--

INSERT INTO `attendees_orders` VALUES (3,1,0,'Gary','NEW YORK',NULL,2,'2023-12-08 11:32:19','2023-12-08 11:32:19'),(7,3,0,'Gary','NEW YORK',NULL,2,'2023-12-09 07:46:00','2023-12-09 07:46:00'),(9,2,0,'Gary','EVG',NULL,2,'2023-12-09 13:08:17','2023-12-09 13:08:17'),(10,6,0,'Jim','Cayucos Monday Morning',NULL,5,'2024-01-01 07:19:24','2024-01-01 07:19:24'),(11,6,0,'Paul','Morro Bay Afternoon',NULL,5,'2024-01-01 07:19:24','2024-01-01 07:19:24'),(17,8,0,'Delfina M.','AFG Works, SLO',NULL,2,'2024-01-01 13:49:21','2024-01-01 13:49:21'),(18,9,0,'Nancy C.','Cayucos',NULL,2,'2024-01-01 14:26:17','2024-01-01 14:26:17'),(19,9,0,'Crystal','Los Osos',NULL,6,'2024-01-01 14:26:17','2024-01-01 14:26:17'),(22,7,0,'Laurie M','Cayucos',NULL,5,'2024-01-01 15:41:49','2024-01-01 15:41:49'),(23,10,0,'Lisa A','Saturday AFG',NULL,2,'2024-01-01 19:41:39','2024-01-01 19:41:39'),(25,11,0,'Sandi P','“How it Works”PasoRobles',NULL,2,'2024-01-01 19:46:52','2024-01-01 19:46:52'),(26,12,0,'Carolyn E','A Hope for Today',NULL,2,'2024-01-01 21:01:15','2024-01-01 21:01:15'),(27,12,0,'SteveP','Recovery in an hour , Ven',NULL,6,'2024-01-01 21:01:15','2024-01-01 21:01:15'),(28,13,0,'Gary','NEW YORK',NULL,2,'2024-01-01 22:56:22','2024-01-01 22:56:22'),(29,14,0,'Erica N.','San Luis Obispo',NULL,2,'2024-01-02 08:19:34','2024-01-02 08:19:34'),(30,15,0,'Gerald T Bednorz','Early Risers',NULL,1,'2024-01-02 09:21:28','2024-01-02 09:21:28'),(31,15,0,'Lizzy B','Changed Attitudes',NULL,2,'2024-01-02 09:21:28','2024-01-02 09:21:28'),(32,16,0,'Gerald T Bednorz','Early Risers',NULL,1,'2024-01-02 09:22:25','2024-01-02 09:22:25'),(33,16,0,'Lizzy B','Changed Attitudes',NULL,2,'2024-01-02 09:22:25','2024-01-02 09:22:25'),(34,17,0,'Wilma W','Lit Study Monday a.m. Cay',NULL,2,'2024-01-02 11:32:13','2024-01-02 11:32:13'),(35,18,0,'Keely Diamantopoulos','Arroyo Grande',NULL,2,'2024-01-02 14:24:07','2024-01-02 14:24:07'),(36,19,0,'Jane A','Pismo Women’s Serenity',NULL,2,'2024-01-02 14:25:52','2024-01-02 14:25:52'),(37,20,0,'Joan S.','Atascadero',NULL,6,'2024-01-02 17:09:24','2024-01-02 17:09:24'),(38,21,0,'Emily L','Atascadero Monday Night',NULL,2,'2024-01-03 17:52:42','2024-01-03 17:52:42'),(39,22,0,'Jen','San Luis Obispo',NULL,2,'2024-01-04 09:49:42','2024-01-04 09:49:42'),(40,23,0,'Marlene Kelly','Paso Tuesday Noon Al-Anon',NULL,2,'2024-01-04 14:11:36','2024-01-04 14:11:36'),(41,24,0,'Cheryl C','Los Angeles',NULL,2,'2024-01-04 21:35:57','2024-01-04 21:35:57'),(42,24,0,'Teresa S','Santa Barbara',NULL,2,'2024-01-04 21:35:57','2024-01-04 21:35:57'),(43,25,0,'Ashley T.','SBTS Treasurer & Los Osos',NULL,2,'2024-01-05 06:21:51','2024-01-05 06:21:51'),(44,26,0,'Michelle Turner','Nipomo',NULL,2,'2024-01-05 08:25:43','2024-01-05 08:25:43'),(45,27,0,'TammyB','Al Anon Works',NULL,2,'2024-01-05 08:46:35','2024-01-05 08:46:35'),(46,28,0,'Margaret G.','10 am Cayucos Literature ',NULL,2,'2024-01-05 11:02:43','2024-01-05 11:02:43'),(47,28,0,'Bob G.','10 am On-line Cayucos',NULL,2,'2024-01-05 11:02:43','2024-01-05 11:02:43'),(48,29,0,'Cindy S.','AFG Works SLO',NULL,2,'2024-01-06 11:32:30','2024-01-06 11:32:30'),(49,30,0,'Irene M','Tuesday Noon Paso Robles',NULL,2,'2024-01-06 11:39:37','2024-01-06 11:39:37'),(50,31,0,'Steve Rein','Los Osos',NULL,5,'2024-01-06 15:18:44','2024-01-06 15:18:44'),(51,31,0,'Kateri Rein','Los Osos',NULL,2,'2024-01-06 15:18:44','2024-01-06 15:18:44'),(52,32,0,'Karen','San Luis Obispo',NULL,2,'2024-01-06 15:36:23','2024-01-06 15:36:23'),(53,33,0,'Lupe C.','Pismo Beach',NULL,2,'2024-01-07 15:51:37','2024-01-07 15:51:37'),(54,34,0,'Stephanie S.','Keep it Simple',NULL,2,'2024-01-07 22:22:41','2024-01-07 22:22:41'),(55,35,0,'Louise','Atascadero',NULL,2,'2024-01-08 19:50:20','2024-01-08 19:50:20'),(57,36,0,'Nancy Shokohi','Los Osos',NULL,5,'2024-01-10 05:54:26','2024-01-10 05:54:26'),(59,37,0,'Kay B.','Grover Beach',NULL,2,'2024-01-10 08:50:12','2024-01-10 08:50:12'),(60,38,0,'Kay B.','Grover Beach',NULL,2,'2024-01-10 08:50:13','2024-01-10 08:50:13'),(61,39,0,'Kay B.','Grover Beach',NULL,2,'2024-01-10 08:50:14','2024-01-10 08:50:14'),(62,40,0,'Kay B.','Grover Beach',NULL,2,'2024-01-10 08:50:14','2024-01-10 08:50:14'),(63,41,0,'Kay B.','Grover Beach',NULL,2,'2024-01-10 08:53:31','2024-01-10 08:53:31'),(65,43,0,'Dorothy','Cayucos',NULL,2,'2024-01-11 11:09:54','2024-01-11 11:09:54'),(67,44,0,'Katie E.','Mon MB Keep It Simple',NULL,2,'2024-01-11 11:59:48','2024-01-11 11:59:48'),(68,42,0,'Teri E','Open Hearts',NULL,2,'2024-01-11 15:32:43','2024-01-11 15:32:43'),(71,45,0,'Sandy Fisher','Faith and Serenity',NULL,5,'2024-01-12 17:09:51','2024-01-12 17:09:51'),(72,46,0,'Sandra','Miracles Happen',NULL,2,'2024-01-12 17:10:50','2024-01-12 17:10:50'),(73,47,0,'Cathy','San Luis Obispo',NULL,2,'2024-01-13 10:12:31','2024-01-13 10:12:31'),(74,48,0,'Judy M','Saturday morning SLO',NULL,2,'2024-01-13 11:01:57','2024-01-13 11:01:57'),(75,49,0,'Susan P','San Luis Obispo',NULL,2,'2024-01-13 13:26:47','2024-01-13 13:26:47'),(76,50,0,'Debra','paso robles',NULL,2,'2024-01-13 13:31:04','2024-01-13 13:31:04'),(77,51,0,'Heather Y','Courage to Change',NULL,2,'2024-01-13 14:35:08','2024-01-13 14:35:08'),(78,52,0,'Deborah Byron','CA - Arroyo Grande',NULL,2,'2024-01-13 15:47:12','2024-01-13 15:47:12'),(79,53,0,'Deborah Byron','CA - Arroyo Grande',NULL,2,'2024-01-13 15:50:30','2024-01-13 15:50:30'),(80,54,0,'Cathy','San Luis Obispo',NULL,2,'2024-01-13 18:33:07','2024-01-13 18:33:07'),(81,55,0,'Amber','Arroyo Grande',NULL,2,'2024-01-13 18:37:51','2024-01-13 18:37:51'),(82,56,0,'Martha','Tuesday Serenity Group, O',NULL,2,'2024-01-14 16:28:39','2024-01-14 16:28:39'),(83,57,0,'Cindy R.','Ojai, CA',NULL,2,'2024-01-14 16:42:03','2024-01-14 16:42:03'),(84,58,0,'Barbara W','Monday Night Atascadero A',NULL,2,'2024-01-14 17:07:51','2024-01-14 17:07:51'),(85,59,0,'Brianna B.','Speaker',NULL,2,'2024-01-14 18:02:37','2024-01-14 18:02:37'),(87,60,0,'Gil M.','Monday Night Atascadero',NULL,5,'2024-01-15 22:18:02','2024-01-15 22:18:02'),(88,61,0,'Hiromi H.','Tustin',NULL,2,'2024-01-16 13:18:38','2024-01-16 13:18:38'),(89,62,0,'Anna','Arroyo Grande',NULL,5,'2024-01-16 13:45:19','2024-01-16 13:45:19'),(90,63,0,'Meredith','SLO',NULL,5,'2024-01-16 15:52:12','2024-01-16 15:52:12'),(92,64,0,'Robbie R.','Sat noon Bayshore Park',NULL,2,'2024-01-16 18:05:40','2024-01-16 18:05:40'),(93,65,0,'Anne','Orcutt',NULL,2,'2024-01-16 18:20:23','2024-01-16 18:20:23'),(94,66,0,'Sheri W.','Serenity Group',NULL,1,'2024-01-16 19:03:19','2024-01-16 19:03:19'),(95,66,0,'Meghann F.','Serenity group',NULL,1,'2024-01-16 19:03:19','2024-01-16 19:03:19'),(96,67,0,'Sheri W.','Serenity',NULL,1,'2024-01-16 20:44:35','2024-01-16 20:44:35'),(97,67,0,'Meghann F.','Serenity',NULL,1,'2024-01-16 20:44:35','2024-01-16 20:44:35'),(98,67,0,'Pamela J.','Serenity',NULL,1,'2024-01-16 20:44:35','2024-01-16 20:44:35'),(99,68,0,'Rosy E.','Womens group',NULL,2,'2024-01-17 12:57:28','2024-01-17 12:57:28'),(100,69,0,'Jeanne','San Luis Obispo',NULL,5,'2024-01-17 14:34:34','2024-01-17 14:34:34'),(101,70,0,'Julie F','Outdoor Morro Bay',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(102,70,0,'Erich L','.',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(103,70,0,'Guest 1','.',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(104,70,0,'Guest 2','.',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(105,70,0,'Guest 3','.',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(106,70,0,'Guest 4','.',NULL,2,'2024-01-17 15:10:42','2024-01-17 15:10:42'),(107,71,0,'Corrin','SLO',NULL,5,'2024-01-17 15:18:52','2024-01-17 15:18:52'),(108,72,0,'Sue P','Pismo Women\'s Thursday',NULL,2,'2024-01-17 20:01:15','2024-01-17 20:01:15'),(111,73,0,'Sarah H.','AFG Works, SLO',NULL,2,'2024-01-18 13:00:07','2024-01-18 13:00:07'),(112,73,0,'Mike M.','AFG Works, SLO',NULL,2,'2024-01-18 13:00:07','2024-01-18 13:00:07'),(115,74,0,'Sheri','Serenity',NULL,1,'2024-01-18 13:01:29','2024-01-18 13:01:29'),(116,74,0,'Meghann','Serenity',NULL,1,'2024-01-18 13:01:29','2024-01-18 13:01:29'),(117,75,0,'Lisa Leonard','Central Coast Serenity',NULL,2,'2024-01-18 13:31:21','2024-01-18 13:31:21'),(118,76,0,'Terri Houser','Mesa Group',NULL,1,'2024-01-18 16:19:04','2024-01-18 16:19:04'),(119,76,0,'Craig Houser','Mesa Group',NULL,1,'2024-01-18 16:19:04','2024-01-18 16:19:04'),(120,77,0,'Beatriz','SLO',NULL,2,'2024-01-18 20:06:51','2024-01-18 20:06:51'),(121,78,0,'Kim','Paso Robles',NULL,2,'2024-01-19 08:35:51','2024-01-19 08:35:51'),(122,79,0,'Eileen','Cayucos Monday Morning St',NULL,2,'2024-01-19 13:20:18','2024-01-19 13:20:18'),(123,79,0,'Earlene','Cayucos Monday Morning St',NULL,2,'2024-01-19 13:20:18','2024-01-19 13:20:18'),(124,80,0,'Angie B.','Faith & Serenity AFG',NULL,2,'2024-01-19 20:02:53','2024-01-19 20:02:53'),(125,80,0,'Christina H.','Faith & Serenity AFG',NULL,2,'2024-01-19 20:02:53','2024-01-19 20:02:53'),(126,81,0,'Teri H','Morro Bay',NULL,2,'2024-01-20 11:33:56','2024-01-20 11:33:56'),(127,82,0,'Teri H','Morro Bay',NULL,2,'2024-01-20 11:35:43','2024-01-20 11:35:43'),(128,83,0,'Carol','Hell or High Water',NULL,2,'2024-01-20 15:32:15','2024-01-20 15:32:15'),(129,84,0,'Kay B.','Grover Beach',NULL,2,'2024-01-20 17:52:03','2024-01-20 17:52:03'),(133,85,0,'Ray V.','Freedom Group Lompoc',NULL,1,'2024-01-21 11:24:43','2024-01-21 11:24:43'),(134,85,0,'Catarina V.','Tuesday Senenity Group',NULL,2,'2024-01-21 11:24:43','2024-01-21 11:24:43'),(135,85,0,'Daisy V.','Tuesday Serenity Group',NULL,2,'2024-01-21 11:24:43','2024-01-21 11:24:43'),(136,86,0,'Nora','Tues Noon Paso',NULL,2,'2024-01-21 12:26:12','2024-01-21 12:26:12'),(137,87,0,'Kathryn G','Cayucos',NULL,2,'2024-01-21 16:05:10','2024-01-21 16:05:10'),(138,88,0,'Shawn N','Monday Night Atascadero',NULL,2,'2024-01-24 19:50:16','2024-01-24 19:50:16'),(139,89,0,'Sarah I AM WORTH','Still Hip',NULL,2,'2024-01-25 15:10:06','2024-01-25 15:10:06'),(140,90,0,'Monica','How Al-Anon Works, Paso',NULL,2,'2024-01-25 15:21:42','2024-01-25 15:21:42'),(142,91,0,'Sandra','Miracles Happen',NULL,2,'2024-01-26 20:41:28','2024-01-26 20:41:28'),(143,92,0,'Barbara I.','Nipomo Peace & Serenity',NULL,2,'2024-01-30 13:14:23','2024-01-30 13:14:23'),(144,93,0,'Shari B.','Monday Morning Cayucos',NULL,5,'2024-01-30 14:08:25','2024-01-30 14:08:25'),(145,94,0,'Cynde F',NULL,NULL,2,'2024-01-30 14:19:21','2024-01-30 14:19:21'),(146,94,0,'Bob F',NULL,NULL,2,'2024-01-30 14:19:21','2024-01-30 14:19:21'),(147,95,0,'Danielle','Atascadero',NULL,2,'2024-01-30 14:27:34','2024-01-30 14:27:34');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` int(10) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `abstract` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_visible` int(11) NOT NULL DEFAULT 1,
  `slug` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `doc` varchar(255) NOT NULL,
  `sort` int(11) NOT NULL,
  `published` tinyint(1) DEFAULT 1,
  `goal` int(11) NOT NULL DEFAULT 0,
  `is_tracked` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (11,0,'Donations','Additional Donation (Optional)','<p>Donate any amount to support District 3</p>',1,'donations-al-anon','','','',7,1,1000,1,0,NULL,'2022-09-05 21:40:40'),(36,1,'Luncheon Pre-Registration',NULL,'<p>Pre-Registration</p>',1,'pre-registration','','','',1,1,88,1,1,'2024-01-01 21:31:32','2024-01-22 08:04:44');

--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `category_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` varchar(255) DEFAULT NULL,
  `seo_keywords` varchar(255) DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `update_by` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_translations_category_id_locale_unique` (`category_id`,`locale`),
  KEY `categories_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category_translations`
--

INSERT INTO `category_translations` VALUES (1,'',1,'en','Meal Choices','<p>Possible to add a description here</p>',NULL,NULL,NULL,0,0,NULL,NULL),(2,'',2,'en','Scholarships/Contributions','<p>Contribute any amount you choose to help provide scholarship registrations for another Alcoholic, Al-Anon or Alateen attend the Convention and help defray Convention costs to the hotel for this year. Cash contributions can be made by entering the amount you wish to give in the Scholarships/Contributions box below.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(3,'',3,'en','Clothing (optional)','<p>Possible to add a description here</p>',NULL,NULL,NULL,0,0,NULL,NULL),(4,'',4,'en','5K Fun Run/Walk','<p>No participation fee and no T-Shirt this year</p>',NULL,NULL,NULL,0,0,NULL,NULL),(5,'',5,'en','Al-Anon Luncheon','<p>The AL-ANON SPEAKER MEETING LUNCHEON in the Grand Ballroom at the Warner Center Marriott is always an event not to be missed, and this year will be no exception!</p>\n\n<p>Enter your choices of regular or vegetarian.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(6,'',6,'en','Saturday Night AA Banquet','<p style=\"font-size:larger;\"><strong><em>This event is SOLD OUT!</em></strong></p><p>&nbsp;</p>',NULL,NULL,NULL,0,0,NULL,NULL),(7,'',7,'en','Spiritual Breakfast','<p>The AA SUNDAY SPIRITUAL BREAKFAST MEETING in the Grand Ballroom at the Warner Center Marriott is the grand finale to our weekend of fellowship and recovery.  You won’t want to miss the Sobriety Countdown, presentation of the Big Book to our newest member and the feeling of love and service that permeates this event.</p>\n\n<p>Enter your choices of regular or vegetarian.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(8,'',8,'en','Alateen Package ($15)','<p>The ALATEEN PACKAGE includes Alateen Registration, Alateen Meetings and Workshops, and the popular Alateen Game Night. Ages 12 and over please.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(9,'',9,'en','Sporting Events',NULL,NULL,NULL,NULL,0,0,NULL,NULL),(10,'',10,'en','Golf Tournament','',NULL,NULL,NULL,0,0,NULL,NULL),(11,'',11,'en','Donationvvvvvvvv','Donate any amount (DATABASE)',NULL,NULL,NULL,0,0,NULL,NULL),(12,'',12,'en','Ladies T-Shirts (starting at $24)','<p>This year’s beautiful V-Neck ROCKETED INTO A 4TH DIMENSION LADIES T-SHIRT has been created in a vibrant shade of blue.  These collector T-Shirts are currently available in sizes from Small to 3X-Large.  Order early to ensure you get the size you want!  If we have any left, they will be for sale at the Commemoratives Desk at the Convention.</p>\n\n<p>All T-shirt orders can be picked up at the Commemoratives Desk at the Convention.</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n',NULL,NULL,NULL,0,0,NULL,NULL),(13,'',13,'en','Mens T-Shirts (starting at $24)','<p>This year’s handsome crew neck ROCKETED INTO A 4TH DIMENSION MEN’S T-SHIRT proudly carries the 2022 Convention logo on a light blue heavyweight tee shirt. These collector T-Shirts are currently available in sizes from Small to 3X-Large.  Order early to ensure you get the size you want!  If we have any left, they will be for sale at the Commemoratives Desk at the Convention.</p>\n<p>All T-shirt orders can be picked up at the Commemoratives Desk at the Convention.</p> \n<p>&nbsp;</p>\n<p>&nbsp;</p>',NULL,NULL,NULL,0,0,NULL,NULL),(14,'',14,'en','Merchandise (Optional)','<p style=\"padding: 0 0 0 0;\">Merchandise includes Mugs, Swag Bags, and Commemorative T-Shirts for women and men. Price includes shipping to Contintental US only; international shipping rates will apply to all other deliveries.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(15,'',15,'en','Personalized Coffee Mugs ($28) (Logo, First Name, Last initial and Sobriety Date)','<p style=\"padding: 0 0 0 0;\">The second option is the 2022 ROCKETED INTO A 4TH DIMENSION COMMEMORATIVE PERSONALIZED MUG.  This is our same 14oz mug only with a personal touch!  The front side has the standard Rocketed Into A 4th Dimension logo and the back side is personalized with your name and sobriety date!  Buy one for yourself and another for your sponsees, sponsor or friends. Personalization is limited to two lines.  The first line has a text character limit of 12 and is intended for your first name and last initial.  The second line is a date field for your sobriety date.</p>\n\n<p>All Coffee Mug orders can be picked up at the Commemoratives Desk at the Convention.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(16,'',16,'en','Swag Bags ($21)','<p style=\"padding: 0 0 0 0;\">\n\n\nA Zippered Tote Bag with convention swag inside. Includes:\n<ul>\n<li>Face Mask</li>\n<li>Hand Sanitizer</li>\n<li>Magnet</li>\n<li>Convention Pin</li>\n</ul>\n</p>\n<p>To purchase an individual convention pin, go to: \"<a style=\"text-decoration:underline; color:#0000EE;\" target=\"_blank\" href=\"https://www.sfvalanon.org/\">sfvalanon.org</a>\"</p>',NULL,NULL,NULL,0,0,NULL,NULL),(18,'',17,'en','Coffee Mugs ($22) (Logo Only)','<p style=\"padding: 0 0 0 0;\">This year we are offering two different options for your 2022 ROCKETED INTO A 4TH DIMENSION COMMEMORATIVE COFFEE MUGS!</p>\n\n<p>The first option is the standard 2022 ROCKETED INTO A 4TH DIMENSION COMMEMORATIVE COFFEE MUG.  These large 14oz mugs have the Rocketed Into A 4th Dimension logo printed on one side and feature handles and insides with a stylish blue color. So comfortable in your hand, it’s a coffee drinkers dream!\nAll Coffee Mug orders can be picked up at the Commemoratives Desk at the Convention.</p>\n<p>&nbsp;</p>',NULL,NULL,NULL,0,0,NULL,NULL),(19,'',18,'en','Candles (starting at $9)','<p style=\"padding: 0 0 0 0;\">We are excited to offer scented ROCKETED INTO A 4TH DIMENSION COMMEMORATIVE CANDLES this year. Just imagine lighting one of these candles at home to set the tone while you are connecting in your morning or evening meditation!  Ahhhhhh, ZEN! Purchase all three candles in a set and save $3.00. These candles make great gift items for your sponsor or sponsee or any of your fellows in recovery!</p>\n\n<p>All Candle orders can be picked up at the Commemoratives Desk at the Convention.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(20,'',19,'en','Sweat shirts (starting at $28)','<p>Our fleece-lined crew neck ROCKETED INTO A 4TH DIMENSION SWEATSHIRT proudly carries the 2022 Convention logo on warm, light blue, long sleeved Sweatshirt. These collector Sweatshirts are currently available in sizes from Small to 3X-Large.  Order early to ensure you get the size you want!  If we have any left, they will be for sale at the Commemoratives Desk at the Convention.</p>\n\n<p>All sweatshirt orders can be picked up at the Commemoratives Desk at the Convention.</p>',NULL,NULL,NULL,0,0,NULL,NULL),(21,'',20,'en','Sweat shirts','<p>Sweat shirts are available in sizes from Small to 3X-Large. Orders placed before December 5 will be delivered prior to the convention. Orders placed after January 1 will be delivered 3 to 4 weeks after close of convention. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n<p>&nbsp;</p>',NULL,NULL,NULL,0,0,NULL,NULL),(22,'',21,'en','Fans ($14)','<p style=\"padding: 0 0 0 0;\">We have something else new for you this year!  These gorgeous handheld, high-quality ROCKETED INTO A 4TH DIMENSION FANS are made of durable silk paper and bamboo sticks.  The fans have our Rocketed Into a 4th Dimension logo centered amongst a field of stars to commemorate our 2022 convention.  Fans are 25 inches across the bottom and 12 inches high.  Another perfect gift item you won’t want to miss!</p>',NULL,NULL,NULL,0,0,NULL,NULL),(23,'1',22,'en','Clothing','<p><span style=\"font-size:larger; font-weight:bold; font-style:italic\">Clothing items are no longer available online.</span> <br />Go to the Commemorative Sales Desk on site at the Convention and get yours before they are sold out!</p>','','','',0,0,NULL,NULL);

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `form_message` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,'Contact Form: sdwe wer wer twert','wertwer ser wer twer w','Gerion E','gedberg@westlinks.com',1,'2024-01-01 00:57:07','2024-01-01 00:57:07'),(2,'Contact Form: test test tes','test test','Gerion E','gedberg@westlinks.com',1,'2024-01-01 01:11:15','2024-01-01 01:11:15'),(3,'Contact Form: another test','test','Gerion E','gedberg@westlinks.com',1,'2024-01-01 01:37:42','2024-01-01 01:37:42'),(4,'Contact Form: test from contacts page','testing from /contacts','Gerion E','gedberg@westlinks.com',1,'2024-01-01 01:51:50','2024-01-01 01:51:50'),(5,'Contact Form: Test message from Gary- please disregard','working on recaptcha','Gerion E','gedberg@westlinks.com',1,'2024-01-01 02:02:22','2024-01-01 02:02:22'),(7,'Contact Form: Hi  i am wrote about   the prices','Sveiki, es gribēju zināt savu cenu.','RobertPeabe','lucido.leinteract@gmail.com',NULL,'2024-01-19 20:35:11','2024-01-19 20:35:11'),(8,'Contact Form: Tickets','I would like to buy a ticket','Susan Dever','susandever44@gmail.com',NULL,'2024-01-22 10:17:32','2024-01-22 10:17:32'),(9,'Contact Form: Checking on registration','I don’t know if my registration went through? Can you let me know?\r\nThank you','Anne Pena','penafamily5@aol.com',NULL,'2024-01-22 16:16:27','2024-01-22 16:16:27'),(10,'Contact Form: Ticket','I wouldn’t like a ticket for serenity by the sea.\r\n80 610-6440','Monica Niznik','niznikmonica@gmail.com',NULL,'2024-01-22 19:18:28','2024-01-22 19:18:28'),(11,'Contact Form: Hallo,   write about your   prices','Hej, jeg ønskede at kende din pris.','MasonPeabe','kaenquirynicholls@gmail.com',NULL,'2024-01-23 20:27:26','2024-01-23 20:27:26');

--
-- Table structure for table `convention_role`
--

CREATE TABLE `convention_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `convention_role`
--

INSERT INTO `convention_role` VALUES (1,'chair','Convention Chair',NULL,NULL),(2,'cochair','Co-Chair',NULL,NULL),(3,'alanon-cochair','Al-Anon Co-Chair',NULL,NULL),(4,'alanon-chair','Al-Anon Chair',NULL,NULL),(5,'alateen-chair','Alateen Chair',NULL,NULL);

--
-- Table structure for table `convention_user`
--

CREATE TABLE `convention_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `convention_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `convention_role_id` int(11) NOT NULL DEFAULT 1,
  `published` int(11) NOT NULL DEFAULT 1,
  `sort` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `convention_user`
--

INSERT INTO `convention_user` VALUES (1,48,109,1,1,1,NULL,NULL),(2,48,16,2,1,2,NULL,NULL),(3,47,193,1,1,1,NULL,NULL),(4,47,109,2,1,2,NULL,NULL),(5,46,5,1,1,1,NULL,NULL),(6,46,193,2,1,2,NULL,NULL);

--
-- Table structure for table `conventions`
--

CREATE TABLE `conventions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `location_id` varchar(255) DEFAULT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `logo_file` varchar(255) DEFAULT NULL,
  `flyer_file` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `conventions`
--

INSERT INTO `conventions` VALUES (1,'1',NULL,'1',NULL,NULL,NULL,'1968-08-01 00:00:00','1968-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(2,'2',NULL,'1',NULL,NULL,NULL,'1969-08-01 00:00:00','1969-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(3,'3',NULL,'1',NULL,NULL,NULL,'1970-08-01 00:00:00','1970-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(4,'4',NULL,'1',NULL,NULL,NULL,'1971-08-01 00:00:00','1971-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(5,'5',NULL,'1',NULL,NULL,NULL,'1972-08-01 00:00:00','1972-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(6,'6',NULL,'1',NULL,NULL,NULL,'1973-08-01 00:00:00','1973-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(7,'7',NULL,'1',NULL,NULL,NULL,'1974-08-01 00:00:00','1974-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(8,'8',NULL,'1',NULL,NULL,NULL,'1975-08-01 00:00:00','1975-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(9,'9',NULL,'1',NULL,NULL,NULL,'1976-08-01 00:00:00','1976-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(10,'10',NULL,'1',NULL,NULL,NULL,'1977-08-01 00:00:00','1977-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(11,'11',NULL,'1',NULL,NULL,NULL,'1978-08-01 00:00:00','1978-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(12,'12',NULL,'1',NULL,NULL,NULL,'1979-08-01 00:00:00','1979-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(13,'13',NULL,'1',NULL,NULL,NULL,'1980-08-01 00:00:00','1980-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(14,'14',NULL,'1',NULL,NULL,NULL,'1981-08-01 00:00:00','1981-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(15,'15',NULL,'1',NULL,NULL,NULL,'1982-08-01 00:00:00','1982-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(16,'16',NULL,'1',NULL,NULL,NULL,'1983-08-01 00:00:00','1983-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(17,'17',NULL,'1',NULL,NULL,NULL,'1984-08-01 00:00:00','1984-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(18,'18',NULL,'1',NULL,NULL,NULL,'1985-08-01 00:00:00','1985-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(19,'19',NULL,'1',NULL,NULL,NULL,'1986-08-01 00:00:00','1986-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(20,'20',NULL,'1',NULL,NULL,NULL,'1987-08-01 00:00:00','1987-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(21,'21',NULL,'1',NULL,NULL,NULL,'1988-08-01 00:00:00','1988-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(22,'22',NULL,'1',NULL,NULL,NULL,'1989-08-01 00:00:00','1989-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(23,'23',NULL,'1',NULL,NULL,NULL,'1990-08-01 00:00:00','1990-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(24,'24',NULL,'1',NULL,NULL,NULL,'1991-08-01 00:00:00','1991-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(25,'25',NULL,'1',NULL,NULL,NULL,'1992-08-01 00:00:00','1992-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(26,'26',NULL,'1',NULL,NULL,NULL,'1993-08-01 00:00:00','1993-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(27,'27',NULL,'1',NULL,NULL,NULL,'1994-08-01 00:00:00','1994-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(28,'28',NULL,'1',NULL,NULL,NULL,'1995-08-01 00:00:00','1995-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(29,'29',NULL,'1',NULL,NULL,NULL,'1996-08-01 00:00:00','1996-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(30,'30',NULL,'1',NULL,NULL,NULL,'1997-08-01 00:00:00','1997-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(31,'31',NULL,'1',NULL,NULL,NULL,'1998-08-01 00:00:00','1998-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(32,'32',NULL,'1',NULL,NULL,NULL,'1999-08-01 00:00:00','1999-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(33,'33',NULL,'1',NULL,NULL,NULL,'2000-08-01 00:00:00','2000-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(34,'34',NULL,'1',NULL,NULL,NULL,'2001-08-01 00:00:00','2001-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(35,'35',NULL,'1',NULL,NULL,NULL,'2002-08-01 00:00:00','2002-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(36,'36',NULL,'1',NULL,NULL,NULL,'2003-08-01 00:00:00','2003-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(37,'37',NULL,'1',NULL,NULL,NULL,'2004-08-01 00:00:00','2004-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(38,'38',NULL,'1',NULL,NULL,NULL,'2005-08-01 00:00:00','2005-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(39,'39',NULL,'1',NULL,NULL,NULL,'2006-08-01 00:00:00','2006-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(40,'40',NULL,'1',NULL,NULL,NULL,'2007-08-01 00:00:00','2007-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(41,'41',NULL,'1',NULL,NULL,NULL,'2008-08-01 00:00:00','2008-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(42,'42',NULL,'1',NULL,NULL,NULL,'2009-08-01 00:00:00','2009-08-01 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(43,'43rd Annual San Fernando Valley AA Convention',NULL,'1','Just Stay - It\'s the Easier Softer Way','/public/media/gT7C0W6SjdNU0itRSvYUNV22maArsKpZRG55UmkK.png',NULL,'2019-01-25 00:00:00','2019-01-27 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(44,'44th Annual San Fernando Valley AA Convention',NULL,'1','Spiritual Life is Not a Theory','/public/media/iUXqoeWyV5Lin6jNzc6ABXDh7xIOY7iHsg9spDZW.jpg',NULL,'2020-01-31 00:00:00','2020-02-02 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(45,'45th Annual San Fernando Valley AA Convention',NULL,'1','SFV AA Unconventional Not Our Plan','/public/media/LIxBfCrSte2M9GOdXAX6Vw9ZQP4fi0zfnTyV2vOn.jpg',NULL,'2021-01-29 00:00:00','2021-01-31 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(46,'46th Annual San Fernando Valley AA Convention',NULL,'1','Rocketed to the 4th Dimension','/public/media/AOgXNfggRUnUPrU9b4PtUImCA5z3GiYRL9WmiLy4.png',NULL,'2022-01-28 00:00:00','2022-01-30 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(47,'47th Annual San Fernando Valley AA Convention',NULL,'1','Trust Got Clean House Help Others','/public/media/S1O8DyTaBBi0T5BvplQ8giMZ7tZmGWdvfv6NEz6h.png',NULL,'2023-01-26 00:00:00','2023-08-28 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26'),(48,'48th Annual San Fernando Valley AA Convention',NULL,'1','Let Go & Let God','/public/media/Xh1gAo9UfluyLT5JBq1wwkqfbYippIRQpo2fPjK0.jpg',NULL,'2024-01-26 00:00:00','2024-01-28 00:00:00',NULL,'2023-08-31 00:52:26','2023-08-31 00:52:26');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `iso_code` varchar(3) NOT NULL,
  `id_continent` int(11) DEFAULT NULL,
  `eu` tinyint(1) DEFAULT NULL,
  `vat` decimal(4,1) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Andorra','AD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(2,'United Arab Emirates','AE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(3,'Afghanistan','AF',NULL,0,0.0,1,NULL,NULL,'2016-08-09 02:00:00','2017-01-03 18:45:12'),(4,'Antigua And Barbuda','AG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(5,'Anguilla','AI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(6,'Albania','AL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(7,'Armenia','AM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(8,'Angola','AO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(9,'Antarctica','AQ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(10,'Argentina','AR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(11,'American Samoa','AS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(12,'Austria','AT',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(13,'Australia','AU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(14,'Aruba','AW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(15,'Aland Islands','AX',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2017-01-03 18:45:13'),(16,'Azerbaijan','AZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(17,'Bosnia And Herzegovina','BA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(18,'Barbados','BB',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(19,'Bangladesh','BD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(20,'Belgium','BE',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(21,'Burkina Faso','BF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(22,'Bulgaria','BG',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(23,'Bahrain','BH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(24,'Burundi','BI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(25,'Benin','BJ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(26,'Saint Barthelemy','BL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(27,'Bermuda','BM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(28,'Brunei','BN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(29,'Bolivia','BO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(30,'Bonaire, Saint Eustatius And Saba ','BQ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(31,'Brazil','BR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(32,'Bahamas','BS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(33,'Bhutan','BT',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(34,'Bouvet Island','BV',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(35,'Botswana','BW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(36,'Belarus','BY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(37,'Belize','BZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(38,'Canada','CA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(39,'Cocos Islands','CC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(40,'Democratic Republic Of The Congo','CD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(41,'Central African Republic','CF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(42,'Republic Of The Congo','CG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(43,'Switzerland','CH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(44,'Ivory Coast','CI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(45,'Cook Islands','CK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(46,'Chile','CL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(47,'Cameroon','CM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(48,'China','CN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(49,'Colombia','CO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(50,'Costa Rica','CR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(51,'Cuba','CU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(52,'Cape Verde','CV',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(53,'Curacao','CW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(54,'Christmas Island','CX',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(55,'Cyprus','CY',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(56,'Czech Republic','CZ',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(57,'Germany','DE',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(58,'Djibouti','DJ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(59,'Denmark','DK',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(60,'Dominica','DM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(61,'Dominican Republic','DO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(62,'Algeria','DZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(63,'Ecuador','EC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(64,'Estonia','EE',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(65,'Egypt','EG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(66,'Western Sahara','EH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(67,'Eritrea','ER',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(68,'Spain','ES',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(69,'Ethiopia','ET',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(70,'Finland','FI',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(71,'Fiji','FJ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(72,'Falkland Islands','FK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(73,'Micronesia','FM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(74,'Faroe Islands','FO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(75,'France','FR',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(76,'Gabon','GA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(77,'United Kingdom','GB',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(78,'Grenada','GD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(79,'Georgia','GE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(80,'French Guiana','GF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(81,'Guernsey','GG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(82,'Ghana','GH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(83,'Gibraltar','GI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(84,'Greenland','GL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(85,'Gambia','GM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(86,'Guinea','GN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(87,'Guadeloupe','GP',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(88,'Equatorial Guinea','GQ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(89,'Greece','GR',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(90,'South Georgia And The South Sandwich Islands','GS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(91,'Guatemala','GT',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(92,'Guam','GU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(93,'Guinea-Bissau','GW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(94,'Guyana','GY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(95,'Hong Kong','HK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(96,'Honduras','HN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(97,'Croatia','HR',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(98,'Haiti','HT',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(99,'Hungary','HU',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(100,'Indonesia','ID',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(101,'Ireland','IE',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(102,'Israel','IL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(103,'Isle Of Man','IM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(104,'India','IN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(105,'British Indian Ocean Territory','IO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(106,'Iraq','IQ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(107,'Iran','IR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(108,'Iceland','IS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(109,'Italy','IT',0,1,22.0,1,0,1,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(110,'Jersey','JE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(111,'Jamaica','JM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(112,'Jordan','JO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(113,'Japan','JP',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(114,'Kenya','KE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(115,'Kyrgyzstan','KG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(116,'Cambodia','KH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(117,'Kiribati','KI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(118,'Comoros','KM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(119,'Saint Kitts And Nevis','KN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(120,'North Korea','KP',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(121,'South Korea','KR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(122,'Kuwait','KW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(123,'Cayman Islands','KY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(124,'Kazakhstan','KZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(125,'Laos','LA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(126,'Lebanon','LB',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(127,'Saint Lucia','LC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(128,'Liechtenstein','LI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(129,'Sri Lanka','LK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(130,'Liberia','LR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(131,'Lesotho','LS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(132,'Lithuania','LT',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(133,'Luxembourg','LU',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(134,'Latvia','LV',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(135,'Libya','LY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(136,'Morocco','MA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(137,'Monaco','MC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(138,'Moldova','MD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(139,'Montenegro','ME',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(140,'Saint Martin','MF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(141,'Madagascar','MG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(142,'Marshall Islands','MH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(143,'Macedonia','MK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(144,'Mali','ML',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(145,'Myanmar','MM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(146,'Mongolia','MN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(147,'Macao','MO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(148,'Northern Mariana Islands','MP',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(149,'Martinique','MQ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(150,'Mauritania','MR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(151,'Montserrat','MS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(152,'Malta','MT',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(153,'Mauritius','MU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(154,'Maldives','MV',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(155,'Malawi','MW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(156,'Mexico','MX',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(157,'Malaysia','MY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(158,'Mozambique','MZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(159,'Namibia','NA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(160,'New Caledonia','NC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(161,'Niger','NE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(162,'Norfolk Island','NF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(163,'Nigeria','NG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(164,'Nicaragua','NI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(165,'Netherlands','NL',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(166,'Norway','NO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(167,'Nepal','NP',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(168,'Nauru','NR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(169,'Niue','NU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(170,'New Zealand','NZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(171,'Oman','OM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(172,'Panama','PA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(173,'Peru','PE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(174,'French Polynesia','PF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(175,'Papua New Guinea','PG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(176,'Philippines','PH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(177,'Pakistan','PK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(178,'Poland','PL',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(179,'Saint Pierre And Miquelon','PM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(180,'Puerto Rico','PR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(181,'Palestinian Territory','PS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(182,'Portugal','PT',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(183,'Palau','PW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(184,'Paraguay','PY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(185,'Qatar','QA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(186,'Reunion','RE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(187,'Romania','RO',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(188,'Serbia','RS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(189,'Russia','RU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(190,'Rwanda','RW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(191,'Saudi Arabia','SA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(192,'Solomon Islands','SB',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(193,'Seychelles','SC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(194,'Sudan','SD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(195,'Sweden','SE',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(196,'Singapore','SG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(197,'Saint Helena','SH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(198,'Slovenia','SI',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(199,'Svalbard And Jan Mayen','SJ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(200,'Slovakia','SK',0,1,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(201,'Sierra Leone','SL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(202,'San Marino','SM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(203,'Senegal','SN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(204,'Somalia','SO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(205,'Suriname','SR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(206,'South Sudan','SS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(207,'Sao Tome And Principe','ST',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(208,'El Salvador','SV',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(209,'Sint Maarten','SX',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(210,'Syria','SY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(211,'Swaziland','SZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(212,'Turks And Caicos Islands','TC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(213,'Chad','TD',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(214,'French Southern Territories','TF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(215,'Togo','TG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(216,'Thailand','TH',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(217,'Tajikistan','TJ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(218,'Tokelau','TK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(219,'East Timor','TL',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(220,'Turkmenistan','TM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(221,'Tunisia','TN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(222,'Tonga','TO',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(223,'Turkey','TR',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(224,'Trinidad And Tobago','TT',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(225,'Tuvalu','TV',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(226,'Taiwan','TW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(227,'Tanzania','TZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(228,'Ukraine','UA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(229,'Uganda','UG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(230,'United States Minor Outlying Islands','UM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(231,'United States','US',NULL,0,0.0,1,NULL,3,'2016-08-09 02:00:00','2018-04-03 08:40:39'),(232,'Uruguay','UY',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(233,'Uzbekistan','UZ',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(234,'Saint Vincent And The Grenadines','VC',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(235,'Venezuela','VE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(236,'British Virgin Islands','VG',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(237,'U.S. Virgin Islands','VI',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(238,'Vietnam','VN',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(239,'Vanuatu','VU',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(240,'Wallis And Futuna','WF',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(241,'Samoa','WS',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(242,'Kosovo','XK',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(243,'Yemen','YE',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(244,'Mayotte','YT',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(245,'South Africa','ZA',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(246,'Zambia','ZM',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00'),(247,'Zimbabwe','ZW',0,0,0.0,1,0,0,'2016-08-09 02:00:00','2016-08-09 02:00:00');

--
-- Table structure for table `dining_tables`
--

CREATE TABLE `dining_tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `plate_count` int(11) NOT NULL,
  `event_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1140 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dining_tables`
--


--
-- Table structure for table `do_not_import`
--

CREATE TABLE `do_not_import` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `send_sms` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `do_not_import`
--


--
-- Table structure for table `domain_translations`
--

CREATE TABLE `domain_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `domain_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `update_by` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `domains_translations_domain_id_locale_unique` (`domain_id`,`locale`),
  KEY `domains_translations_locale_index` (`locale`),
  CONSTRAINT `domains_translations_domain_id_foreign` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `domain_translations`
--

INSERT INTO `domain_translations` VALUES (1,1,'it','Top Header Slider',0,'2016-06-23 11:36:42','2016-06-28 11:58:39'),(2,1,'en','Top Header Slider',0,'2016-06-23 11:36:42','2016-06-28 11:58:39'),(7,2,'it','Bottom Slider Image',0,'2016-06-23 11:38:24','2016-06-28 11:59:19'),(8,2,'en','page gallery',0,'2016-06-23 11:38:24','2016-12-27 20:38:49'),(121,21,'it','Template con sottopagine',0,'2016-06-28 17:18:04','2016-07-04 11:38:10'),(122,21,'en','Sub page template',0,'2016-06-28 17:18:04','2016-12-27 18:17:28');

--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `sort` int(11) NOT NULL,
  `pub` tinyint(4) DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `domains`
--

INSERT INTO `domains` VALUES (1,'imagetype','','',10,1,0,'2016-06-23 11:36:42','2016-06-28 11:58:39'),(2,'imagetype','','',20,1,0,'2016-06-23 11:38:24','2016-06-28 11:59:19'),(21,'template','','template_subpage',30,1,0,'2016-06-28 17:18:04','2016-12-27 18:17:35');

--
-- Table structure for table `event_group`
--

CREATE TABLE `event_group` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_group`
--


--
-- Table structure for table `event_roles`
--

CREATE TABLE `event_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_roles`
--

INSERT INTO `event_roles` VALUES (1,'Meeting Leader','Speak for 30-45 minutes',NULL,NULL),(2,'Secretary',NULL,NULL,NULL),(3,'Announcer','Announce the readers and leader',NULL,NULL),(4,'Speaker',NULL,NULL,NULL),(5,'Leader','Speak for 30-45 minutes',NULL,NULL),(6,'Invocation','Blessing',NULL,'2022-08-18 12:29:25'),(7,'Spiritual Timekeeper','Keep time of participants. Announce 1 minute remaining followed by time up.',NULL,'2022-05-07 14:43:37'),(8,'Chapter 5','Chapter 5, More about Alcoholism','2022-05-07 17:06:02','2022-08-18 12:31:02'),(9,'Greeter','Greet incoming attendees','2022-05-07 17:09:53','2022-05-07 17:09:53'),(10,'Statement of Anonymity','Statement of Anonymity','2022-08-18 12:29:55','2022-08-18 12:29:55'),(11,'I Am Responsible','I Am Responsible','2022-08-18 12:30:19','2022-08-18 12:30:19'),(12,'Chapter 3, How It Works','Chapter 3, How It Works','2022-08-18 12:30:39','2022-08-18 12:31:37'),(13,'12 Traditions','12 Traditions','2022-08-18 12:32:06','2022-08-18 12:32:06'),(14,'A Vision for You/Lord\'s Prayer','A Vision for You/Lord\'s Prayer','2022-08-18 12:32:57','2022-08-18 12:32:57'),(15,'Security','Security Volunteer','2022-10-22 23:44:27','2022-10-22 23:44:27');

--
-- Table structure for table `event_types`
--

CREATE TABLE `event_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `event_types`
--

INSERT INTO `event_types` VALUES (1,'All','2018-05-10 22:00:00','2018-05-10 22:00:00'),(2,'Events','2018-05-10 22:00:00','2018-05-10 22:00:00'),(3,'Speaker','2018-05-10 22:00:00','2018-05-10 22:00:00'),(4,'AA Marathon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(5,'Al-Anon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(6,'Alateen','2018-05-10 22:00:00','2018-05-10 22:00:00'),(7,'Business','2018-05-10 22:00:00','2018-05-10 22:00:00'),(8,'Other','2018-05-10 22:00:00','2018-05-10 22:00:00'),(9,'Entertainment','2018-05-10 22:00:00','2018-05-10 22:00:00'),(10,'Meals','2018-05-10 22:00:00','2018-05-10 22:00:00'),(11,'Al-Anon Marathon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(12,'Al-Anon Speaker','2018-05-10 22:00:00','2018-05-10 22:00:00'),(13,'Greeting','2018-05-10 22:00:00','2018-05-10 22:00:00'),(14,'Sporting Events','2018-05-10 22:00:00','2018-05-10 22:00:00'),(15,'Spanish Al-Anon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(16,'Spanish AA','2018-05-10 22:00:00','2018-05-10 22:00:00'),(17,'Spanish Al-Anon Marathon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(18,'Spanish AA Marathon','2018-05-10 22:00:00','2018-05-10 22:00:00'),(19,'Speaker-2022','2018-05-10 22:00:00','2018-05-10 22:00:00'),(20,'Archive','2018-05-10 22:00:00','2018-05-10 22:00:00'),(21,'Meal + Speaker','2018-05-10 22:00:00','2018-05-10 22:00:00'),(22,'Security','2022-10-23 02:40:18','2022-10-23 02:40:18'),(23,'ACA','2022-12-17 16:25:21','2022-12-17 16:25:21'),(24,'Workshop','2022-12-17 16:25:21','2022-12-17 16:25:21'),(25,'Bingo','2022-12-17 16:25:21','2022-12-17 16:25:21'),(26,'Panel','2022-12-17 16:25:21','2022-12-17 16:25:21'),(27,'Zoomathons','2022-12-17 16:25:21','2022-12-17 16:25:21'),(28,'Golf','2022-12-17 16:25:21','2022-12-17 16:25:21');

--
-- Table structure for table `event_user`
--

CREATE TABLE `event_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `event_role_id` int(11) NOT NULL,
  `requested_at` datetime DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_user`
--

INSERT INTO `event_user` VALUES (1,1,NULL,5,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:31:54'),(2,2,NULL,5,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:32:07'),(3,3,NULL,8,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:33:06'),(4,4,NULL,13,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:33:29'),(5,5,NULL,3,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:33:50'),(6,6,69,5,'2024-01-24 18:47:59',NULL,'2022-08-25 21:43:59','2024-01-24 18:47:59'),(7,7,55,5,'2024-01-24 18:47:05',NULL,'2022-08-25 21:43:59','2024-01-24 18:47:05'),(8,9,NULL,3,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:34:41'),(9,10,NULL,5,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:34:53'),(10,11,NULL,3,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:35:13'),(11,12,NULL,3,NULL,NULL,'2022-08-25 21:43:59','2023-12-07 12:35:40'),(12,13,NULL,5,NULL,NULL,'2022-08-25 21:43:59','2022-08-25 21:44:02');

--
-- Table structure for table `example_article`
--

CREATE TABLE `example_article` (
  `example_id` int(10) unsigned NOT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `example_article_example_id_index` (`example_id`),
  KEY `example_article_article_id_index` (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `example_article`
--

INSERT INTO `example_article` VALUES (1,8,NULL,NULL),(1,7,NULL,NULL),(1,1,NULL,NULL);

--
-- Table structure for table `example_translations`
--

CREATE TABLE `example_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `example_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `description_2` text DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_description` varchar(255) DEFAULT NULL,
  `seo_keywords` varchar(255) DEFAULT NULL,
  `seo_no_index` varchar(255) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `update_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `example_translations_example_id_locale_unique` (`example_id`,`locale`),
  KEY `example_translations_locale_unique` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `example_translations`
--


--
-- Table structure for table `examples`
--

CREATE TABLE `examples` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_id` int(11) NOT NULL,
  `article_2_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT '',
  `description` text NOT NULL,
  `description_2` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `doc` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT 0,
  `pub` tinyint(4) DEFAULT 1,
  `color` varchar(7) DEFAULT '0',
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `examples`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `field_types`
--

CREATE TABLE `field_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `field_types`
--

INSERT INTO `field_types` VALUES (1,'text','2018-08-12 06:42:13','2018-08-12 06:42:13'),(2,'increments','2018-08-12 06:42:13','2018-08-12 06:42:13'),(3,'select','2018-08-12 06:42:13','2018-08-12 06:42:13'),(4,'checkbox','2018-08-12 06:42:13','2018-08-12 06:42:13'),(5,'number','2018-08-12 06:42:13','2018-08-12 06:42:13'),(6,'text-info','2018-08-12 06:42:13','2018-08-12 06:42:13');

--
-- Table structure for table `golfers`
--

CREATE TABLE `golfers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `golfer1` varchar(255) DEFAULT NULL,
  `golfer2` varchar(255) DEFAULT NULL,
  `golfer3` varchar(255) DEFAULT NULL,
  `golfer4` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `golfers`
--


--
-- Table structure for table `greetings`
--

CREATE TABLE `greetings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `greetings`
--

INSERT INTO `greetings` VALUES (2,'Thank you for calling 2024 San Fernando Valley AA Convention   with al-anon and Alateen participation,  which will be held in Woodland Hills, California  on Friday Sat and Sun January 26th through the 28th 2024  at Warner Center Marriott 21850 Oxnard St','2023-09-20 18:47:34','2023-09-20 18:49:06');

--
-- Table structure for table `group_user`
--

CREATE TABLE `group_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_user`
--


--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `location_id` tinyint(4) DEFAULT NULL,
  `affiliation_type_id` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1,'Sunday Night Speaker & Participation',24,1,'2022-08-07 17:21:53','2022-08-11 04:55:18'),(2,'Saturday Dumetz Women\'s Meeting',99,1,'2022-08-07 17:34:51','2022-08-11 05:00:01'),(3,'Principles Before Pandemic',86,1,'2022-12-12 17:05:55','2022-12-12 17:05:55'),(4,'Valley Club 5:30 am Meeting',56,1,'2022-12-30 11:07:11','2022-12-30 11:07:11');

--
-- Table structure for table `hpsliders`
--

CREATE TABLE `hpsliders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `sort` int(11) NOT NULL,
  `is_active` tinyint(4) DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hpsliders_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hpsliders`
--

INSERT INTO `hpsliders` VALUES (1,'maguttiCms Slider','free open source CMS based on the Laravel PHP Framework',NULL,'LogoOriginal.jpg','','laracms-slier',200,1,0,'2016-12-27 21:34:38','2018-04-03 08:34:52'),(2,'magutti 5.5','District 22 Convention Information and Registration',NULL,'17984-dist22conv-logo-square-100.png','','district22convention',100,1,0,'2016-12-27 22:18:09','2018-04-03 08:39:44');

--
-- Table structure for table `location_types`
--

CREATE TABLE `location_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `location_types`
--

INSERT INTO `location_types` VALUES (1,'Marathon Room','2022-08-07 16:52:27','2022-08-07 16:52:27'),(2,'Large Hall','2022-08-07 16:52:27','2022-08-07 16:52:27'),(3,'Lobby','2022-08-07 16:52:27','2022-08-07 16:52:27'),(4,'Group Location','2022-08-07 16:52:27','2022-08-07 16:52:27'),(5,'Parking Facility','2022-08-07 16:52:27','2022-08-07 16:52:27'),(6,'Golf Course','2022-08-07 16:52:27','2022-08-07 16:52:27'),(7,'Virtual','2022-08-07 16:52:27','2022-08-07 16:52:27'),(8,'Fundraising Location','2022-08-07 16:52:27','2022-08-07 16:52:27');

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_type_id` int(11) NOT NULL DEFAULT 1,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `address2` varchar(28) DEFAULT NULL,
  `room` varchar(255) DEFAULT NULL,
  `dining_table_count` int(11) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `postal_code` varchar(18) DEFAULT NULL,
  `longitude` varchar(15) DEFAULT NULL,
  `latitude` varchar(15) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` VALUES (1,2,'Ventana Grill	','Restaurant perched on a coastal bluff specializing in Latin-inspired dishes & fresh seafood.','2575 Price St.	',NULL,'',NULL,'Pismo Beach',25,231,'93449','35.1497269','-120.6543655','2022-08-04 05:46:48','2022-08-07 22:01:35');

--
-- Table structure for table `marathon_groups`
--

CREATE TABLE `marathon_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `meeting_at` datetime NOT NULL,
  `size` varchar(255) NOT NULL,
  `is_women_meeting` int(11) NOT NULL DEFAULT 0,
  `city` varchar(255) NOT NULL,
  `district` varchar(255) NOT NULL,
  `leader_id` int(11) NOT NULL,
  `requester_id` int(11) DEFAULT NULL,
  `topic` varchar(255) NOT NULL,
  `time_slot` varchar(255) NOT NULL,
  `time_slot_previous` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `marathon_groups`
--


--
-- Table structure for table `marathon_requests`
--

CREATE TABLE `marathon_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `requester_user_id` int(11) DEFAULT NULL,
  `requester_firstname` varchar(255) DEFAULT NULL,
  `requester_lastname` varchar(255) DEFAULT NULL,
  `requester_email` varchar(255) DEFAULT NULL,
  `requester_phone` varchar(255) DEFAULT NULL,
  `requester_email_opt_in` tinyint(4) NOT NULL DEFAULT 1,
  `requester_sms_authorized` tinyint(4) NOT NULL DEFAULT 1,
  `area_meeting_id` int(11) DEFAULT NULL,
  `area_meeting_name` varchar(255) NOT NULL,
  `area_meeting_day` varchar(255) NOT NULL,
  `area_meeting_time` time NOT NULL,
  `area_meeting_size` int(11) NOT NULL DEFAULT 1,
  `area_meeting_city` varchar(255) NOT NULL,
  `area_meeting_district` varchar(255) DEFAULT NULL,
  `secretary_user_id` varchar(255) DEFAULT NULL,
  `secretary_firstname` varchar(255) DEFAULT NULL,
  `secretary_lastname` varchar(255) DEFAULT NULL,
  `secretary_email` varchar(255) DEFAULT NULL,
  `secretary_phone` varchar(255) DEFAULT NULL,
  `secretary_email_opt_in` tinyint(4) NOT NULL DEFAULT 1,
  `secretary_sms_authorized` tinyint(4) NOT NULL DEFAULT 1,
  `leader_user_id` varchar(255) DEFAULT NULL,
  `leader_firstname` varchar(255) NOT NULL,
  `leader_lastname` varchar(255) NOT NULL,
  `leader_city` varchar(255) DEFAULT NULL,
  `leader_email` varchar(255) NOT NULL,
  `leader_phone` varchar(255) NOT NULL,
  `leader_email_opt_in` tinyint(4) NOT NULL DEFAULT 1,
  `leader_sms_authorized` tinyint(4) NOT NULL DEFAULT 1,
  `comments` text DEFAULT NULL,
  `chairperson_comments` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marathon_requests`
--

INSERT INTO `marathon_requests` VALUES (3,25,714,'lloyd','vaughn','lloydlvaughn@yahoo.com','3106147604',1,1,396,'USR MENS STAG','Thursday','19:30:00',50,'NORTHRIDGE','1','714','lloyd','vaughn','lloydlvaughn@yahoo.com','3106147604',1,1,'714','lloyd','vaughn','WINNETKA','lloydlvaughn@yahoo.com','3106147604',1,1,NULL,NULL,'2022-09-23 10:36:15','2023-11-12 12:17:28'),(4,NULL,718,'Nicole','Araujo-Gomez','niknaknumbers@gmail.com','4247316473',1,1,NULL,'Women\'s Empowerment Big BookStudy/ WEBBS','Monday','19:30:00',50,'Van Nuys','01','722','Nicole','Araujo-Gomez','WEBBSAA@gmail.com','747-254-5316',1,1,'718','Nicole','Araujo-Gomez','Van Nuys','niknaknumbers@gmail.com','4247316473',1,1,NULL,NULL,'2022-09-26 11:02:18','2023-11-21 19:05:26'),(7,95,747,'Jennifer','Oberle','jjoberle@gmail.com','(323) 762-4587',1,1,NULL,'We Are Responsible Group','Wednesday','12:00:00',20,'North Hollywood','17','747','Jennifer','Oberle','jjoberle@gmail.com','(323) 762-4587',1,1,'747','Jennifer','Oberle','North Hollywood','jjoberle@gmail.com','(323) 762-4587',1,1,NULL,NULL,'2022-10-22 13:58:14','2023-11-07 18:02:48'),(8,116,755,'Daisy','Q','ladaisy_11@yahoo.com','12134715000',1,1,429,'SHAKERS','Friday','21:00:00',8,'Glendale','11','755','Daisy','Q','ladaisy_11@yahoo.com','213-471-5000',1,1,'755','Daisy','Q','Los Angeles','ladaisy_11@yahoo.com','12134715000',1,1,NULL,NULL,'2022-10-30 23:00:28','2023-11-21 18:47:49'),(9,NULL,312,'Nathan','Hershfeld','nathan.hershfeld@gmail.com','8053120947',1,1,NULL,'R2 - Reason and Recovery Secular Zoom Meeting','Sunday','18:00:00',45,'Woodland Hills','None','312','Nathan','Hershfeld','nathan.hershfeld@gmail.com','8053120947',1,1,'312','Nathan','Hershfeld','Woodland Hills','Nathan.Hershfeld@gmail.com','8053120947',1,1,NULL,NULL,'2022-11-01 09:32:08','2023-11-21 19:10:24'),(10,NULL,812,'Stefani','Uhler','stefaniuhler@gmail.com','3108017353',1,1,701,'The Six','Thursday','12:00:00',12,'Calabasas','1','812','Stefani','Uhler','stefaniuhler@gmail.com','3108017353',1,1,'812','Stefani','Uhler','Woodland Hills','stefaniuhler@gmail.com','3108017353',1,1,'Hi- I just received this email , so I am late with this registration. Pleaase give this group a decent hour as most of the women are seniors. Thank you for you service.\r\n\r\nBest regards, Stefani U',NULL,'2022-11-27 17:52:27','2023-11-14 20:46:27'),(14,NULL,836,'Kim','Nakae','kim@nineleaves.com','3106661813',1,1,NULL,'West Valley Rovers','Saturday','10:30:00',15,'Sherman Oaks','12','836','Kim','Nakae','kim@nineleaves.com','3106661813',1,1,'836','Kim','Nakae','sherman oaks','kim@nineleaves.com','310-666-1813',1,1,'NOt sure about our district number',NULL,'2022-12-04 15:27:59','2023-11-21 19:22:04'),(15,177,815,'Wesley','Idol','w@idol.la','310 963-7225',1,1,177,'Calabasas Group','Tuesday','19:00:00',30,'Calabasas','1','815','Wesley','Idol','W@idol.la','310 963-7225',1,1,NULL,'Wesley','Idol','Calabasas','w@idol.la','310 963-7225',1,1,'If possible, we would like to request Friday 6 pm or Saturday 5 pm, Thank you!',NULL,'2022-12-05 11:47:06','2023-11-19 14:14:59'),(16,108,833,'Piper','Norwood','Pipernorwood@gmail.com','3109955178',1,1,582,'Principles Before Pandemic','Saturday','21:00:00',50,'Los Angeles','93','806','Nancy','McClesky','Nemac@theriver.com','+1 (928) 699-3795',1,1,NULL,'Piper','Norwood','Woodland Hills','Pipernorwood@gmail.com','3109955178',1,1,NULL,NULL,'2022-12-06 09:02:04','2022-12-12 17:18:15'),(17,117,84,'Diane','Deats','diane@deatsdesign.com','818 620-2537',1,1,665,'Sunday 4:30 at Hole in the Sky','Sunday','16:30:00',60,'Canoga Park','1','22','Sari','Averill','sariaverill@sbcglobal.net','(818) 384-7161',1,1,'22','Sari','Averill','Reseda','sariaverill@sbcglobal.net','(818) 384-7161',1,1,'Thank you for your service!',NULL,'2022-12-06 09:21:34','2023-11-12 12:56:00'),(34,33,312,'Nathan','Hershfeld','nathan.hershfeld@gmail.com','805-312-0947',1,1,226,'Reason and Recovery Secular Zoom Group of AA','Sunday','18:00:00',60,'Woodland Hills','93','312','Nathan','Hershfeld','nathan.hershfeld@gmail.com','805-312-0947',1,1,NULL,'Nathan','Hershfeld','Woodland Hills','nathan.hershfeld@gmail.com','805-312-0947',1,1,'Meeting had a slot at the 2023 convention that was well attended.',NULL,'2023-09-25 14:25:42','2023-11-07 19:55:34'),(35,NULL,2064,'Garth','Collings','drgaudio@gmail.com','8057957756',1,1,NULL,'Westlake Friday Night Fellowship Group','Friday','20:00:00',200,'Thousand Oaks','93','2064','Garth','Collings','drgaudio@gmail.com','8057957756',1,1,'2064','Garth','Collings','Thousand Oaks','drgaudio@gmail.com','8057957756',1,1,'I will be attending the Saturday Banquet & Meeting.',NULL,'2023-09-26 13:52:59','2023-09-26 13:52:59'),(36,106,2070,'astrid','Howe','astridhowe@gmail.com','8183146168',1,1,599,'call Prime time coed Saturday night','Saturday','19:30:00',80,'Sherman Oaks','Howe','2070','Astridhowe@gmail.com','Howe','astridhowe@gmail.com','8183146168',1,1,'2070','astrid','Howe','Sherman Oaks','astridhowe@gmail.com','8183146168',1,1,'so we have signed up for a marathon slots so many times and we’ve been given these midnight slots over and over. Do you think we could have something during the day on Saturday?',NULL,'2023-10-02 18:56:06','2023-11-12 13:04:33'),(37,93,894,'Dana','Nierenberg','dnierenberg1@socal.rr.com','818-903-0746',1,1,59,'Sobriety First','Monday','06:30:00',22,'Chatsworth','1','894','Dana','Nierenberg','dnierenberg1@socal.rr.com','818-903-0746',1,1,'894','Dana','Nierenberg','Northridge','dnierenberg1@socal.rr.com','818-903-0746',1,1,'If possible the group would prefer an 11:00 am time slot on Saturday.',NULL,'2023-10-02 20:32:50','2023-11-12 13:08:47'),(38,31,2072,'Luis','Servin','luisaarecovery@gmail.com','3108015248',1,1,193,'Pacific Group Speaker Discussion','Tuesday','19:30:00',70,'Tarzana','SFV','2073','Keith','S','keithstone0731@gmail.com','5628100026',1,1,'2073','Keith','S','Tarzana','keithstone0731@gmail.com','5628100026',1,1,NULL,NULL,'2023-10-03 11:34:56','2023-11-12 13:12:02'),(39,80,2072,'Luis','Servin','luisaarecovery@gmail.com','3108015248',1,1,632,'Sunday Morning Speaker Meeting','Sunday','09:00:00',75,'Van Nuys','SFV','2074','Rich','B','rchrdrichr@aol.com','8183212067',1,1,'2074','Rich','B','Van Nuys','rchrdrichr@aol.com','8183212067',1,1,'Please note this is a separate application from the one sent earlier for different home group. Thank you!',NULL,'2023-10-03 13:00:25','2023-11-12 13:20:34'),(40,26,179,'Viken','Fermanian','victor@victorselectronicrepairs.com','8182940080',1,1,390,'Men\'s Book Study','Thursday','19:00:00',20,'Reseda','1','878','Elias','Khelil','elias.khelil@icloud.com','747-308-5969',1,1,'2076','Adam','Cabral','Woodland Hills','cabral_adam@yahoo.com','818-312-3704',1,1,NULL,NULL,'2023-10-04 09:32:15','2023-11-12 13:16:17'),(41,99,2078,'John','Porter','jporter.090588@gmail.com','6613135047',1,1,490,'Valley Men’s Discussion','Friday','19:00:00',60,'Woodland Hills','1','2078','John','Porter','jporter.090588@gmail.com','6613135047',1,1,'2078','John','Porter','Thousand Oaks','jporter.090588@gmail.com','6613135047',1,1,'A time on Saturday mid morning would be ideal and greatly appreciated. Thank you!',NULL,'2023-10-05 08:09:30','2023-11-12 13:24:54'),(42,NULL,200,'Robert','Lawrence','lawrence.j.robert@gmail.com','8184192734',1,1,NULL,'End of the World Vanalden Park','Friday','19:00:00',50,'Northridge','SFV','200','Robert','Lawrence','lawrence.j.robert@gmail.com','8184192734',1,1,'200','Robert','Lawrence','Northridge','lawrence.j.robert@gmail.com','8184192734',1,1,'This is our 4th year we are very grateful and excited',NULL,'2023-10-09 12:25:05','2023-10-09 12:25:05'),(43,NULL,2080,'Scott','Martens','sshcott51603@yahoo.com','818 731-7099',1,1,NULL,'Living to live big book study','Tuesday','19:00:00',15,'Canoga Park','1','2081','Steve','Kennedy','steveleila@socal.rr.com','818 6871132',1,1,'2082','Steve','Kennedy','steteleila@socal.rr.com','818 687 1132','818 687 1132',1,1,NULL,NULL,'2023-10-10 20:39:24','2023-10-10 20:39:24'),(44,88,457,'damon','smith','deegoodvibes@yahoo.com','8189002154',1,1,499,'Friday Night Phuckits','Friday','20:00:00',25,'canoga park','sfv','457','damon','smith','deegoodvibes@yahoo.com','8189002154',1,1,'457','Damon','Smith','Canoga Park','deegoodvibes@yahoo.com','8189002154',1,1,NULL,NULL,'2023-10-11 12:07:46','2023-11-12 13:38:47'),(45,62,79,'Camille','Norris','cammydavis@yahoo.com','8186794486',1,1,56,'Unit A','Monday','18:00:00',100,'North Hollywood','17','79','Camille','Nortis','cammydavis@yahoo.com','8186794486',1,1,'79','Kelly','Brown','North hollywood','cammydavis@yahoo.com','8186794486',0,1,'Unit A has 3 MTG a day, 7 days a week.  Would prefer morning or early afternoon time slot this year 😁',NULL,'2023-10-11 17:41:25','2023-11-12 13:42:01'),(46,86,79,'Camille','Norris','cammydavis@yahoo.com','8186794486',1,1,56,'Unit A','Monday','18:00:00',100,'North Hollywood','17','79','Camille','Nortis','cammydavis@yahoo.com','8186794486',1,1,'79','Kelly','Brown','North hollywood','cammydavis@yahoo.com','8186794486',0,1,'Unit A has 3 MTG a day, 7 days a week.  Would prefer morning or early afternoon time slot this year 😁',NULL,'2023-10-11 17:41:26','2023-11-21 19:39:41'),(47,32,200,'Robert','Lawrence','lawrence.j.robert@gmail.com','8184192734',1,1,703,'End of World Vanalden Park','Sunday','12:00:00',50,'Northridge','SFV','200','Robert','Lawrence','lawrence.j.robert@gmail.com','8184192734',1,1,'200','Robert','Lawrence','Northridge','lawrence.j.robert@gmail.com','8184192734',1,1,NULL,NULL,'2023-10-12 20:47:38','2023-11-19 14:11:12'),(48,87,116,'Kendra','Day','Kendraday88@gmail.com','8184264333',0,0,NULL,'Dumetz Women','Saturday','10:30:00',50,'Woodland Hills','??','116','Kendra','Day','Kendraday88@gmail.com','818.426.4333',1,1,'116','Kendra','Day','Canoga Park','Kendraday88@gmail.com','8184265333',1,1,'Please give us a Saturday10am slot if possible.',NULL,'2023-10-14 10:30:38','2023-11-12 13:48:50'),(49,NULL,2060,'Laurie','Steele','laurie_steele@yahoo.com','8054901183',1,1,NULL,'Burbank Saturday Morning Women\'s','Saturday','09:30:00',50,'Burbank','11','2090','Brenda','Barbee','brendaferr@gmail.com','206-819-4882',1,0,'2060','Laurie','Steele','Granada Hills','laurie_steele@yahoo.com','8054901183',1,1,NULL,NULL,'2023-10-14 16:21:21','2023-10-14 16:21:21'),(50,34,37,'Angelica','Hernandez','angie.hernandez74@yahoo.com','818-606-9280',1,1,660,'San Fernando Group','Saturday','14:00:00',20,'San Fernando','16','37','Angelica','Hernandez','angie.hernandez74@yahoo.com','8186069280',1,1,'37','Angelica','Hernandez','Van Nuys','angie.hernandez74@yahoo.com','8186069280',1,1,NULL,NULL,'2023-10-14 20:58:02','2023-11-19 13:57:54'),(51,89,917,'Serena','Fahey','sfahey1999@gmail.com','7604985790',1,1,71,'Sobriety Together Discussion','Monday','19:00:00',35,'Granada Hills','16','917','Serena','Fahey','Sfahey1999@gmail.com','7604985790',1,1,'968','Robert','LeBlanc','Granada Hills','Bob72286@earthlink.net','8184302191',1,1,NULL,NULL,'2023-10-14 21:29:37','2023-11-12 14:02:35'),(52,NULL,2091,'Christopher','Kerrigan','ck91602818@gmail.com','7143694049',1,1,NULL,'Happy Candlestick Makers','Wednesday','19:30:00',25,'Lake Balboa','1','2092','Pat','A','patrickatzman@gmail.com','8184572024',1,0,'2093','Kevin','J','Van Nuys','kevinsjohn75@gmail.com','8185270788',1,0,'Please include me (Chris Kerrigan) in any and all notes regarding the Convention.  I am the GSR for the meeting.',NULL,'2023-10-15 11:30:57','2023-10-15 11:30:57'),(53,NULL,33,'MaryAnn','Bowser','msmatcher@aol.com','2138199570',1,1,NULL,'Sat Womens Dumetz','Saturday','10:30:00',40,'Woodland Hills','1','2094','Kendra','Day','?','?',1,1,'33','MaryAnn','Bowser','Woodland Hills','msmatcher@aol.com','2138199570',1,1,NULL,NULL,'2023-10-16 17:34:51','2023-10-16 17:34:51'),(54,NULL,740,'Norm','Symonds','GamerNormS@aol.com','18184221081',1,1,NULL,'End of the Line','Monday','12:00:00',30,'Encino','16','740','Multiple','Secretaries','GamerNormS@aol.com','18184221081',1,1,'2097','Allen','H','Chatsworth','allen@chakraorganics.com','2512159570',1,1,'Saturday morning or afternoon if possible. Some of our members with long term sobriety are elderly and do not like to drive at night.\r\nNote: the meeting meets 5 days a week at noon',NULL,'2023-10-17 17:41:20','2023-10-17 17:41:20'),(55,25,2099,'Luky','Fernandez','lukyfer97@gmail.com','8187234250',1,0,591,'Saturday Night Live (SNL)','Saturday','19:00:00',20,'Canoga Park','1','2099','Luky','Fernandez','lukyfer97@gmail.com','8197234250',1,0,'2099','Luky','Fernandez','Winnetka','lukyfer97@gmail.com','8187234250',1,0,NULL,NULL,'2023-10-17 19:28:44','2023-11-12 14:05:26'),(56,NULL,833,'Piper','Norwood','pipernorwood@gmail.com','3109955178',1,1,NULL,'Principles Before Pandemic','Saturday','21:00:00',40,'Los Angeles','05','806','Nancy','McCleskey','nemac@theriver.com','928.699.3795',0,0,'833','Piper','Norwood','Woodland Hills','pipernorwood@gmail.com','3109955178',1,1,NULL,NULL,'2023-10-17 19:57:09','2023-10-17 19:57:09'),(57,245,833,'Piper','Norwood','pipernorwood@gmail.com','3109955178',1,1,705,'The Early Show','Sunday','06:00:00',60,'South Pasadena','3','2100','Herb','Callahan','626.673.2385','Herbcallahan@gmail.com',1,1,'833','Piper','Norwood','Woodland Hills','pipernorwood@gmail.com','3109955178',1,1,NULL,NULL,'2023-10-19 13:31:29','2023-11-19 14:42:04'),(58,90,84,'Diane','Deats','diane@deatsdesign.com','8186202537',1,1,170,'Women’s stag at Hole in the Sky','Tuesday','18:30:00',45,'Canoga Park','1','199','Suzy','Phipps','dogies4me@gmail.com','8184372104',1,1,'199','Suzy','Phipps','West Hills','dogies4me@gmail.com','8184372104',1,1,'Thank you!',NULL,'2023-10-19 13:38:27','2023-11-12 15:05:53'),(59,174,2101,'Stewart','Deats','Stew@deatsdesign.com','8186202144',1,1,706,'We Care Men’s stag','Monday','18:00:00',35,'Canoga Park','1','845','Rick','Reid','bigtimectr@aol.com','(818) 314-4794',1,1,'845','Rick','Reid','North Hills','bigtimectr@aol.com','(818) 314-4794',1,1,NULL,NULL,'2023-10-19 13:43:24','2023-11-21 20:01:09'),(60,101,996,'Bob','Wass','bobwass@mindspring.com','8184372818',1,1,269,'Wednesday 12x12','Wednesday','18:00:00',60,'Chatsworth','1 one','996','Bob','Wass','bobwass@mindspring.com','8184372818',1,1,'996','Bob','Wass','Chatsworth','bobwass@mindspring.com','8184372818',1,1,'we\'re older and prefer a slot before 8pm 😉',NULL,'2023-10-20 14:24:13','2023-11-12 15:09:10'),(61,NULL,84,'Diane','Deats','diane@deatsdesign.com','8186202537',1,1,NULL,'Hole in the Sky Participation','Sunday','16:30:00',65,'Canoga Park','1','22','Sari','Averill','sariaverill@sbcglobal.net','818 384-7161',1,1,'22','Sari','Averill','Reseda','sariaverill@sbcglobal.net','818 384-7161',1,1,NULL,NULL,'2023-10-20 17:32:47','2023-10-20 17:32:47'),(62,NULL,812,'Stefani Kong','Uhler','stefaniuhler@gmail.com','3108017353',1,1,NULL,'The Six','Thursday','12:00:00',16,'Calabasas','1','812','Stefani','Uhler','stefaniuhler@gmail.com','3108017353',1,1,'812','Stefani','Uhler','Woodland Hills','stefaniuhler@gmail.com','3108017353',1,1,'This group will have seniors on the marathon panel. Please give us a day light time.',NULL,'2023-10-21 03:12:21','2023-10-21 03:12:21'),(63,33,317,'Steven','Goshgarian','steveg1296@yahoo.com','8182694704',1,1,527,'Doing The Deal','Saturday','07:00:00',80,'Woodland Hills','AA district 9?? Not Sure??','2102','Tim','Gray','timgray@live.com','818-261-2634',1,1,'2102','Tim','Gray','Woodland Hills','timgray@live.com','818-261-2634',1,1,'Hoping for a late morning or early afternoon on Saturday. I appreciate whatever efforts that can be made. Thank you!!',NULL,'2023-10-21 13:36:28','2023-11-12 15:11:21'),(64,57,84,'Diane','Deats','diane@deatsdesign.com','8186202537',1,1,602,'Night Talkers','Saturday','20:00:00',35,'Canoga Park','1','2103','Daniel','Palma','danielpalma123.dp@gmail.com','818 470-1855',1,1,'2103','Daniel','Palma','Canoga Park','danielpalma123.dp@gmail.com','818 470-1855',1,1,NULL,NULL,'2023-10-21 15:51:31','2023-11-12 15:12:35'),(65,NULL,356,'Pat','Kramer','pat@writerpatkramer.com','818 468-7278',1,1,NULL,'Pat A. Kramer','Sunday','18:00:00',50,'La Crescenta, CA','11','2106','Dave','Delbis','pat@writerpatkramer.com - not sure of David\'s at this moment','1818 468-7278',1,1,'356','Pat','Kramer','La Crescenta','pat@writerpatkramer.com','818 468-7278',1,1,'This meeting would be for the whole Verdugo Hills Alano Club (aka: Dunsmore). Any timeslot that doesn\'t conflict with the banquet would be nice. I don\'t have David\'s email and phone. Will have it in a few minutes.',NULL,'2023-10-23 15:37:10','2023-10-23 15:37:10'),(66,102,524,'Adrian','Gonzalez','Agondaddy@gmail.com','818-454-0204',1,1,65,'Stags of Sobriety','Monday','19:00:00',70,'Canoga Park','1','524','Adrian','Gonzalez','Agondaddy@gmail.com','818-454-0204',1,1,'524','Adrian','Gonzalez','Van Nuys','Agondaddy@gmail.com','818-454-0204',1,1,NULL,NULL,'2023-10-23 18:20:38','2023-11-12 15:14:57'),(67,100,744,'Derrick','Carbon','vcboard2017@gmail.com','8186402389',1,1,543,'Laugh Out Loud','Saturday','09:00:00',50,'Northridge','9','744','Derrick','C.','vcboard2017@gmail.com','8186402389',1,1,'744','Derrick','C.','Northridge','vcboard2017@gmail.com','8186402389',1,1,NULL,NULL,'2023-10-30 08:54:34','2023-11-12 15:16:08'),(68,84,84,'Diane','Deats','diane@deatsdesign.com','8186202537',1,1,4,'Hole in the Sky Spiritual Discussion','Monday','06:30:00',40,'Canoga Park','1','2123','Mandalyn','Ungarsky','mandalyn2122020@gmail.com','(818) 697-3416',1,1,'2123','Mandalyn','Ungarsky','Simi Valley','mandalyn2122020@gmail.com','(818) 697-3416',1,1,'M-F Zoom meeting at 6:45am\r\nThank you!',NULL,'2023-10-31 11:50:14','2023-11-12 15:20:32'),(69,103,2125,'Kim','Barton','kimbarton@mail.com','818-730-6292',1,1,644,'Pacoima Group','Sunday','11:00:00',65,'Pacoima','D-16','536','John','Baca','johnbaca1971@gmail.com','818-792-3539',1,1,'536','John','Baca','Pacoima','johnbaca1971@gmail.com','818-792-3539',1,1,NULL,NULL,'2023-10-31 16:45:38','2023-11-12 13:00:08'),(70,28,67,'Suzanne','Bassani','mothergoddess23@gmail.com','818-458-7548',1,1,131,'Living In The Solution - Women\'s 12 & 12','Tuesday','10:00:00',15,'Woodland Hills','Los Angeles','2127','Tamara','Wynn','Thetamster2@gmail.com','(818) 294-5300‬',1,1,'67','Suzanne','Bassani','Woodland Hills, CA','mothergoddess23@gmail.com','818-458-7548',1,1,NULL,NULL,'2023-11-01 14:39:42','2023-11-12 15:21:47'),(71,83,2130,'Damien','Tapia','Damien6tapia@gmail.com','8054902540',1,0,396,'USR','Thursday','19:30:00',50,'Northridge','District 1','2131','Steve','Faith','stevefaith01@gmail.com','8182231838',1,0,'2130','Damien','Tapia','Northridge','Damien6tapia@gmail.com','8054902540',1,1,NULL,NULL,'2023-11-02 21:24:37','2023-11-12 15:30:43'),(72,53,5,'Todd','Grossman','toddg2021chair@gmail.com','8185127333',1,1,1,'530 AM VALLEY CLUB','Monday','05:30:00',45,'Northridge','16','5','Todd','Grossman','toddg2021chair@gmail.com','8185127333',1,1,'5','Todd','Grossman','Lake Balboa','toddg2021chair@gmail.com','8185127333',1,1,'It would be great if we could be scheduled either before or after the laugh out loud meeting.',NULL,'2023-11-03 07:09:01','2023-11-12 15:32:53'),(73,104,2132,'Cheryl','Blonsky','CherBears5654@aol.com','8182983765',1,1,NULL,'Woman’s Friday Question&Answer','Friday','12:30:00',18,'Canoga Park','Ex','859','Linda','Nieves','nivives@aol.com','None',1,0,'2132','Cheryl','Blonsky','Canoga Park','CherBears5654@aol.com','8182983765',1,1,'Late morning, or afternoon slots',NULL,'2023-11-03 13:37:44','2023-11-12 15:36:28'),(74,NULL,2132,'Cheryl','Blonsky','CherBears5654@aol.com','8182983765',1,1,NULL,'Woman’s Friday Question&Answer','Friday','12:30:00',18,'Canoga Park','Ex','859','Linda','Nieves','nivives@aol.com','None',1,0,'2132','Cheryl','Blonsky','Canoga Park','CherBears5654@aol.com','8182983765',1,1,'Late morning, or afternoon slots',NULL,'2023-11-03 13:37:45','2023-11-03 13:37:45'),(75,NULL,2132,'Cheryl','Blonsky','CherBears5654@aol.com','8182983765',1,1,NULL,'Friday Question&Answer Woman’s Meeting','Friday','12:30:00',18,'Canoga Park','01','859','Linda','Nieves','nivives@aol.com','8187997277',0,0,'859','Linda','Nieves','Canoga Park','nivives@aol.com','8182983765',1,1,'Late morning, afternoon, slot',NULL,'2023-11-03 13:52:17','2023-11-03 13:52:17'),(76,91,2134,'Tigran','Danielian','danieliantigran83@gmail.com','8186358987',0,1,413,'Armenian AA','Thursday','20:30:00',20,'Glendale','11','2134','Alfred','Aper','danieliantigran83@gmail.com','8186358987',1,0,'2134','Tigran (Tig)','Danielian','Tujunga','danieliantigran83@gmail.com','8186358987',0,0,'Please allot a time prior to midnight.',NULL,'2023-11-03 19:54:19','2023-11-14 21:05:42'),(77,119,84,'Diane','Deats','diane@deatsdesign.com','8186202537',1,1,494,'West Valley Group Speaker meeting','Friday','19:30:00',50,'Canoga Park','1','2101','Stewart','Deats','Stew@deatsdesign.com','8186202144',1,1,'2101','Stewart','Deats','Woodland Hills','stew@deatsdesign.com','8186202144',1,1,NULL,NULL,'2023-11-04 14:05:45','2023-11-12 15:47:33'),(78,81,2139,'Bennett','Quevedo','Quevedoben@gmail.com','8186251717',1,1,601,'Quality of life','Saturday','19:30:00',20,'Van nuys','??','2139','Bennett','Quevedo','Quevedoben@gmail.com','8186251717',1,1,'2139','Bennett','Quevedo','Northridge','Quevedoben@gmail.com','8186251727',1,1,NULL,NULL,'2023-11-06 10:10:04','2023-11-14 20:05:56'),(79,173,2142,'Lyn','Wilson','lyncwilson5@gmail.com','8184252785',1,0,175,'Tuesday Night Discussion','Tuesday','07:00:00',20,'West Hills','1','2142','Lyn','Wilson','lyncwilson5@gmail.com','8184252785',1,0,'2142','Lyn','Wilson','Granada Hills','lyncwilson5@gmail.com','8184252785',1,0,'We are a mature group and request a daytime time slot for the marathon meeting.',NULL,'2023-11-08 08:46:06','2023-11-14 19:59:39'),(80,115,2147,'Marnie','Bromberg','marniej777@gmail.com','8189151515',1,1,421,'Winners Attitude Adjustment','Sunday','07:00:00',25,'Valley Village','17','2147','Marnie','Bromberg','marniej777@gmail.com','818-915-1515',1,0,'2147','Marnie','Bromberg','Studio City','marniej777@gmail.com','818-915-1515',1,1,'Our meeting meets 7 days a week.  We would like to request a meeting time in the morning or early afternoon.',NULL,'2023-11-11 12:34:02','2023-11-12 15:52:57'),(81,58,1324,'Tina','Kramer','tina.kramer1192@gmail.com','7472463202',1,0,609,'Radford Zombies','Saturday','22:00:00',50,'Van Nuys','Unknown','1324','Tina','Kramer','tina.kramer1192@gmail.com','7472463202',1,0,'1324','Tina','Kramer','VAN NUYS','tina.kramer1192@gmail.com','7472463202',1,0,'If 10 pm slot is unavailable, we would prefer an earlier time rather than later. Thank you!',NULL,'2023-11-13 18:33:11','2023-11-14 19:48:51'),(82,107,2113,'Bruce','Lerner','brucelerner@earthlink.net','3109894896',1,1,694,'Beginners Candlelight','Sunday','19:30:00',50,'Woodland Hills','93?','2113','Craig','F','brucelerner@earthlink.net','3109894896',1,0,'2113','Bruce','Lerner','Topanga','brucelerner@earthlink.net','3109894896',1,1,'Mid morning or After noon PLEASE',NULL,'2023-11-13 21:28:27','2023-11-14 19:45:14'),(83,62,912,'Richard','Gosselin','Richardgssln@yahoo.com','8188231355',1,1,479,'The Burbank Group','Friday','18:00:00',40,'Burbank','11','912','Richard','Gosselin','Richardgssln@yahoo.com','8188231355',1,1,'912','Richard','Gosselin','Burbank','Richardgssln@yahoo.com','8188231355',1,1,NULL,NULL,'2023-11-14 09:09:33','2023-11-14 19:40:08'),(84,57,854,'Doug','Finn','formsetr@aol.com','8185194350',1,1,202,'Acceptance Group Candlelight','Tuesday','20:00:00',10,'Granada Hills','16','854','Doug','Finn','formsetr@aol.com','8185194350',1,1,'854','Doug','Finn','Granada Hills','formsetr@aol.com','8185194350',1,1,NULL,NULL,'2023-11-15 14:12:16','2023-11-21 19:17:35'),(85,57,2157,'Doug','Rowell','rowelldoug8@gmail,com','818-353-4607',1,1,220,'New Attitude   (daily)','Wednesday','07:00:00',30,'Burbank','17','542','Sharon','Miller','doug@carverdoug.com','818-450-7364',1,1,'2158','Rick','Larimore','Burbank','onesequoia@earthlink.net','310-770-2439',1,1,'Meeting meets daily @ 7:00 AM',NULL,'2023-11-17 06:07:59','2023-11-19 14:33:10'),(86,92,2163,'George','Medici','george@georgemedici.com','6462958218',1,0,704,'Solutions Group (GSO #000654358)','Thursday','19:30:00',25,'Studio City','17','2164','Matt','Vacca','mattvacca@gmail.com','9172263130',1,0,'2163','George','Medici','Woodland Hills','george@georgemedici.com','6462958218',1,0,NULL,NULL,'2023-11-19 14:08:52','2023-11-19 14:29:23'),(87,NULL,983,'Suzanne','Kahane','srkahane@icloud.com','818-416-1109',1,0,NULL,'We Are Responsible Group/WARG','Saturday','10:00:00',30,'Studio City','17','983','Suzanne','Kahane','srkahane@icloud.com','818-416-1109',1,0,'983','Suzanne','Kahane','Studio City','srkahane@icloud.com','818-416-1109',1,0,'We are just receiving information to sign up for the meetings.  Let me know if there\'s the possibility of participating.  Thanks for your help and service.',NULL,'2023-11-21 08:35:12','2023-11-21 08:35:12'),(88,187,17,'Alex','Angel','alex1983angel@gmail.com','818-674-6429',1,1,NULL,'Sober cartel','Saturday','22:00:00',50,'Grenada hills','West valley','17','Bobby','Salas','alex1983angel@gmail.com','818 458-3853',1,1,'17','Boby','Salas','Grenada Hills','alex1983angel@gmail.com','818-458-3858',1,1,NULL,NULL,'2023-11-21 21:59:39','2023-11-26 14:01:19'),(89,NULL,16,'Lacy','Merino','lmerino333@gmail.com','8188240411',1,0,NULL,'Remain Teachable','Wednesday','19:00:00',20,'Tarzana','1','2173','Diane','Belding','Dbelding11@gmail.com','818-660-3632',1,0,'2173','Diane','Belding','Sherman Oaks','Dbelding11@gmail.com','818-660-3632',1,1,NULL,NULL,'2023-11-23 22:05:17','2023-11-23 22:05:17'),(90,NULL,5,'Todd','Grossman','toddg2021chair@gmail.com','8185127333',1,1,NULL,'Valley Club','Monday','12:00:00',100,'NORTHRIDGE','1','2177','Todd','Grossman','toddg2021chair','8185127333',1,1,'5','Todd','Grossman','Lake Balboa','toddg2021chair@gmail.com','8185127333',1,1,'This is the main meeting for Valley Club, and needs to be in Ventura Room. Could have 100+ people in it.\r\nThe first valley club meeting I signed up for is actually called the 530AM Valley Club Meeting, that one can be in a smaller room and should host about 50 people.',NULL,'2023-11-25 12:20:26','2023-11-25 12:20:26'),(91,NULL,2179,'David','Phama','phamadavid13@gmail.com','818 3097992',1,1,NULL,'Sunday night speaker','Sunday','19:30:00',15,'Canoga park','1','2179','David','Phama','phamadavid13@gmail.com','818 3097992',1,1,'2179','David','Phama','Canoga park','phamadavid13@gmail.com','818 309 7992',1,1,NULL,NULL,'2023-11-26 14:29:55','2023-11-26 14:29:55'),(92,NULL,30,'Eric','Landeen','landeen2050@gmail.com','818-573-3513',1,1,NULL,'Thursday Night Lights','Thursday','19:00:00',20,'Canoga Park','1','1656','Matt','Musgrove','mttmsgrv@gmail.com','805-990-9141',1,1,'30','Eric','Landeen','Simi Valley','landeen2050@gmail.com','8185733513',1,1,NULL,NULL,'2023-11-28 08:40:45','2023-11-28 08:40:45'),(93,NULL,236,'Kristin','Miller','kristin.eliz.miller@gmail.com','3174967283',1,1,NULL,'The Spirit of the Kukui','Tuesday','19:00:00',40,'Chatsworth','SFV','236','Ellen','Joy','kristin.eliz.miller@gmail.com','3174967283',1,1,'236','Kristin','Miller','Sherman Oaks','kristin.eliz.miller@gmail.com','3174967283',1,1,NULL,NULL,'2023-11-28 09:48:58','2023-11-28 09:48:58'),(94,NULL,833,'Piper','Norwood','pipernorwood@gmail.com','3109955178',1,1,NULL,'Live and Let Live','Wednesday','08:30:00',30,'Woodland Hills','93','2186','Amberly','Lago','amberly@amberlylago.com','818.606.3447',0,0,'33','MARY ANN','Bowser','Woodland Hills','MSMATCHER@AOL.COM','213-819-9570',1,1,'Please contact MaryAnn 213.819.9170 or Piper 310.995.5178.',NULL,'2023-11-28 14:27:09','2023-11-28 14:27:09'),(95,NULL,833,'Piper','Norwood','pipernorwood@gmail.com','3109955178',1,1,NULL,'The Early Show','Sunday','06:00:00',60,'South Pasadena','05','519','Elisa','Wishan','Elwishan@gmail.com','818.425.8979',1,1,'833','Piper','Norwood','Woodland Hills','pipernorwood@gmail.com','3109955178',1,1,NULL,NULL,'2023-11-28 20:58:22','2023-11-28 20:58:22'),(96,NULL,2191,'Neil','Bucknam','nbucknam@aol.com','818 522-8760',1,1,NULL,'Rule 62 Mens Stag-Zoom','Sunday','09:00:00',50,'Zoom only','17','2191','Neil','Bucknam','nbucknam@aol.com','818 522-8760',1,1,'2191','Neil','Bucknam','Big Bear Lake','nbucknam@aol.com','818 522-8760',1,1,'We are a zoom meeting but have hosted a marathon meeting at the convention for the last two years.  We are a 7 days a week meeting at 9 am, registered on the San Fernando Valley Central Office meeting directory.',NULL,'2023-11-29 11:48:04','2023-11-29 11:48:04'),(97,NULL,2193,'Sean','Vanger','seanvanger@gmail.com','3107458053',1,1,NULL,'The Spirit Of the Kukui','Tuesday','19:30:00',25,'SFV','21','2193','Sean','Vanger','seanvanger@gmail.com','3107458053',1,1,'2193','Sean','Vanger','Northridge','seanvanger@gmail.com','3107458053',1,1,NULL,NULL,'2023-11-30 21:12:53','2023-11-30 21:12:53'),(98,NULL,339,'Amy','Vassallo','Amyplays89@gmail.com','8189331750',1,1,NULL,'Women’s Problem Discussion','Wednesday','19:30:00',30,'Valley Village','16','2194','Nadia','Geller','Nadia@nadiageller.com','3104865277',0,1,'339','Amy','Vassallo','Valley Village','Amyplays89@gmail.com','8189331750',0,0,NULL,NULL,'2023-12-01 07:55:39','2023-12-01 07:55:39'),(99,NULL,33,'MaryAnn','Bowser','msmatcher@aol.com','2138199570',1,1,NULL,'Friday Womens Calvary Church Meeting','Friday','05:30:00',25,'Canoga Park','1','873','Terri','Smith','Smithterri799@gmail.com','323-244-7649',1,1,'873','Terri','Smith','Canoga Park','Smithterri799@gmail.com','323-244-7649',1,1,NULL,NULL,'2023-12-01 10:15:48','2023-12-01 10:15:48');

--
-- Table structure for table `meal_user`
--

CREATE TABLE `meal_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `dining_table_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meal_user`
--


--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `thumbnail` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` VALUES (1,'2024 Flyer','public/media/z5kxhZb4CsrbhcnivXkVopJ7oOLuzKKSlOPcT0rK.png','<p>Flyer</p>',NULL,'2023-12-07 11:37:07','2023-12-07 11:37:07'),(2,'Logo (old)','public/media/wgsspf427q9oPLqflU4pJQ6c2gvWcwNuBPbkHNQp.png','<p>Logo</p>',NULL,'2023-12-07 11:37:45','2023-12-07 11:37:45'),(3,'Logo - small','public/media/eNZdFzPXJeL0VPPp7OTaCrnn5rp1asy2Z2ReAK10.png','<p>Logo - Small</p>',NULL,'2023-12-08 00:49:32','2023-12-08 00:49:32'),(4,'Logo - small - no shadow','public/media/pJEYrV74IvLe97AOW7EZ2PDhM1SnmvzxsjmmcpPk.png','<p>Logo - small - no shadow</p>',NULL,'2023-12-08 00:52:13','2023-12-08 00:52:13'),(5,'dashboard top','public/media/6rhr9iFz1xXHZL18YPGiQPVryS4vb9Wl6Ky4DsM7.png','<p>Dashboard top</p>',NULL,'2023-12-08 00:57:24','2023-12-08 00:57:24');

--
-- Table structure for table `meeting_types`
--

CREATE TABLE `meeting_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `meeting_types`
--

INSERT INTO `meeting_types` VALUES (1,'12 x 12','2018-05-03 03:02:14','2018-05-03 03:02:14'),(2,'Big Book','2018-05-03 03:02:14','2018-05-03 03:02:14'),(3,'Discussion','2018-05-03 03:02:14','2018-05-03 03:02:14'),(4,'LGBTQ','2018-05-03 03:02:14','2018-05-03 03:02:14'),(5,'Meditation','2018-05-03 03:02:14','2018-05-03 03:02:14'),(6,'Men\'s','2018-05-03 03:02:14','2018-05-03 03:02:14'),(7,'Speaker','2018-05-03 03:02:14','2018-05-03 03:02:14'),(8,'Topic','2018-05-03 03:02:14','2018-05-03 03:02:14'),(9,'Woman\'s','2018-05-03 03:02:14','2018-05-03 03:02:14'),(10,'Marathon','2018-05-05 03:02:14','2018-05-05 03:02:14'),(11,'Al-Anon','2018-05-05 03:02:14','2018-05-05 03:02:14'),(12,'Undefined','2022-08-16 17:37:22','2022-08-16 17:37:22');

--
-- Table structure for table `meetings`
--

CREATE TABLE `meetings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `affiliation_type_id` int(11) DEFAULT NULL,
  `meeting_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `confirmed` tinyint(4) NOT NULL DEFAULT 0,
  `start_at` datetime NOT NULL,
  `duration` int(11) DEFAULT 1,
  `topic` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
