
--
-- Table structure for table `sfvaa_cities`
--

CREATE TABLE `sfvaa_cities` (
  `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=41 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sfvaa_cities`
--

INSERT INTO `sfvaa_cities` VALUES (1,'Acton','2018-09-14 21:48:00','2018-09-14 21:48:00'),(2,'Agoura Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(3,'Agua Dulce','2018-09-14 21:48:00','2018-09-14 21:48:00'),(4,'Bel Air','2018-09-14 21:48:00','2018-09-14 21:48:00'),(5,'Burbank','2018-09-14 21:48:00','2018-09-14 21:48:00'),(6,'Calabasas','2018-09-14 21:48:00','2018-09-14 21:48:00'),(7,'Canoga Park','2018-09-14 21:48:00','2018-09-14 21:48:00'),(8,'Canyon Country','2018-09-14 21:48:00','2018-09-14 21:48:00'),(9,'Chatsworth','2018-09-14 21:48:00','2018-09-14 21:48:00'),(10,'Encino','2018-09-14 21:48:00','2018-09-14 21:48:00'),(11,'Frazier Park','2018-09-14 21:48:00','2018-09-14 21:48:00'),(12,'Glendale','2018-09-14 21:48:00','2018-09-14 21:48:00'),(13,'Granada Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(14,'La Canada','2018-09-14 21:48:00','2018-09-14 21:48:00'),(15,'La Crescenta','2018-09-14 21:48:00','2018-09-14 21:48:00'),(16,'Newhall','2018-09-14 21:48:00','2018-09-14 21:48:00'),(17,'North Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(18,'North Hollywood','2018-09-14 21:48:00','2018-09-14 21:48:00'),(19,'Northridge','2018-09-14 21:48:00','2018-09-14 21:48:00'),(20,'Pacoima','2018-09-14 21:48:00','2018-09-14 21:48:00'),(21,'Reseda','2018-09-14 21:48:00','2018-09-14 21:48:00'),(22,'San Fernando','2018-09-14 21:48:00','2018-09-14 21:48:00'),(23,'Santa Clarita','2018-09-14 21:48:00','2018-09-14 21:48:00'),(24,'Saugus','2018-09-14 21:48:00','2018-09-14 21:48:00'),(25,'Shadow Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(26,'Sherman Oaks','2018-09-14 21:48:00','2018-09-14 21:48:00'),(27,'Studio City','2018-09-14 21:48:00','2018-09-14 21:48:00'),(28,'Sun Valley','2018-09-14 21:48:00','2018-09-14 21:48:00'),(29,'Sunland','2018-09-14 21:48:00','2018-09-14 21:48:00'),(30,'Sylmar','2018-09-14 21:48:00','2018-09-14 21:48:00'),(31,'Tarzana','2018-09-14 21:48:00','2018-09-14 21:48:00'),(32,'Topanga','2018-09-14 21:48:00','2018-09-14 21:48:00'),(33,'Val Verde','2018-09-14 21:48:00','2018-09-14 21:48:00'),(34,'Valencia','2018-09-14 21:48:00','2018-09-14 21:48:00'),(35,'Van Nuys','2018-09-14 21:48:00','2018-09-14 21:48:00'),(36,'West Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(37,'Westlake Village','2018-09-14 21:48:00','2018-09-14 21:48:00'),(38,'Winnetka','2018-09-14 21:48:00','2018-09-14 21:48:00'),(39,'Woodland Hills','2018-09-14 21:48:00','2018-09-14 21:48:00'),(40,'Other','2018-09-14 21:48:00','2018-09-14 21:48:00');

--
-- Table structure for table `sfvaa_meetings`
--

CREATE TABLE `sfvaa_meetings` (
  `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=321 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sfvaa_meetings`
--

INSERT INTO `sfvaa_meetings` VALUES (1,'1 Hour Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(2,'10th Step','2019-09-23 21:48:10','2019-09-23 21:48:18'),(3,'11th Step Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(4,'11th Step Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(5,'11th Step Prayer & Meditation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(6,'12 & 12 Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(7,'12 & 12 Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(8,'12 & 12 Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(9,'12 Steps Come Alive','2019-09-23 21:48:10','2019-09-23 21:48:18'),(10,'24 Hour A Day Discussion/Meditation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(11,'A Day in the Life Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(12,'A Gathering Of Men','2019-09-23 21:48:10','2019-09-23 21:48:18'),(13,'A New Attitude','2019-09-23 21:48:10','2019-09-23 21:48:18'),(14,'A Vision for You','2019-09-23 21:48:10','2019-09-23 21:48:18'),(15,'A.A. Literature Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(16,'A.M. Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(17,'AA Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(18,'Agoura Morning Fellowship','2019-09-23 21:48:10','2019-09-23 21:48:18'),(19,'Agoura Morning Fellowship Stp Stdy','2019-09-23 21:48:10','2019-09-23 21:48:18'),(20,'All R Welcome 1 Hour Living Sober','2019-09-23 21:48:10','2019-09-23 21:48:18'),(21,'All R Welcome 1 Hr Big Bk Stories','2019-09-23 21:48:10','2019-09-23 21:48:18'),(22,'All R Welcome 1 Hr Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(23,'All R Welcome Grapevine','2019-09-23 21:48:10','2019-09-23 21:48:18'),(24,'Always on Sunday','2019-09-23 21:48:10','2019-09-23 21:48:18'),(25,'AM Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(26,'An Hour Under the Oaks Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(27,'Artists in Recovery','2019-09-23 21:48:10','2019-09-23 21:48:18'),(28,'As Bill Sees It','2019-09-23 21:48:10','2019-09-23 21:48:18'),(29,'As Bill Sees It Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(30,'As Bill Sees It Women’s Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(31,'Attraction In Action Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(32,'B.Y.O.B. 12&12 Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(33,'Back to Basics','2019-09-23 21:48:10','2019-09-23 21:48:18'),(34,'Back to Basics Book Stdy','2019-09-23 21:48:10','2019-09-23 21:48:18'),(35,'Barefoot Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(36,'Beginners Cndlt Discuss.','2019-09-23 21:48:10','2019-09-23 21:48:18'),(37,'Beginners Participation/Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(38,'Beginners Workshop','2019-09-23 21:48:10','2019-09-23 21:48:18'),(39,'Best of the Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(40,'Beverly Glen Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(41,'Big Book Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(42,'Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(43,'Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(44,'Breakaway Big Book/Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(45,'Breakfast With Bill','2019-09-23 21:48:10','2019-09-23 21:48:18'),(46,'Bring Your Own Coffee & Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(47,'Burbank ½ Hr. Meditation then Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(48,'Burbank ½ Hr.Meditation then Discuss','2019-09-23 21:48:10','2019-09-23 21:48:18'),(49,'Burbank AA Approved Literature Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(50,'Burbank Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(51,'Burbank Candlelight','2019-09-23 21:48:10','2019-09-23 21:48:18'),(52,'Burbank Emotional Sobriety','2019-09-23 21:48:10','2019-09-23 21:48:18'),(53,'Burbank Guest Panel Part. (Last Saturday is a Longtimers Meeting.)','2019-09-23 21:48:10','2019-09-23 21:48:18'),(54,'Burbank Leader/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(55,'Burbank Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(56,'Burbank Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(57,'Burbank Promises Candl’t Speaker/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(58,'Burbank Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(59,'Burbank Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(60,'Burbank Steps & Traditions','2019-09-23 21:48:10','2019-09-23 21:48:18'),(61,'Burbank Topic Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(62,'Calabasas Beginners Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(63,'Came to Believe','2019-09-23 21:48:10','2019-09-23 21:48:18'),(64,'Candlelight','2019-09-23 21:48:10','2019-09-23 21:48:18'),(65,'Candlelight Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(66,'Canoga Park Sunday Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(67,'Chatsworth Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(68,'Choose Your Own Adventure','2019-09-23 21:48:10','2019-09-23 21:48:18'),(69,'Circle of Women','2019-09-23 21:48:10','2019-09-23 21:48:18'),(70,'Colfax Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(71,'Conscious Contact Women\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(72,'Coyote Group','2019-09-23 21:48:10','2019-09-23 21:48:18'),(73,'Crescenta Valley Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(74,'Daily Reflections','2019-09-23 21:48:10','2019-09-23 21:48:18'),(75,'Daily Reflections Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(76,'Dare to Share Candlelight','2019-09-23 21:48:10','2019-09-23 21:48:18'),(77,'Day Breakers','2019-09-23 21:48:10','2019-09-23 21:48:18'),(78,'Dead Men Talking','2019-09-23 21:48:10','2019-09-23 21:48:18'),(79,'Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(80,'Doing The Deal','2019-09-23 21:48:10','2019-09-23 21:48:18'),(81,'Doing The Deal Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(82,'Drop the Rock','2019-09-23 21:48:10','2019-09-23 21:48:18'),(83,'Dump Your Garbage Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(84,'Dunsmore Real Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(85,'E.D.I. Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(86,'Each Day A New Beginning','2019-09-23 21:48:10','2019-09-23 21:48:18'),(87,'Early Bird','2019-09-23 21:48:10','2019-09-23 21:48:18'),(88,'Early Bird Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(89,'Early Bird Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(90,'Easy Does It Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(91,'Emotional Sobriety','2019-09-23 21:48:10','2019-09-23 21:48:18'),(92,'Eye Opener','2019-09-23 21:48:10','2019-09-23 21:48:18'),(93,'Eye Opener Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(94,'Eye Opener Group','2019-09-23 21:48:10','2019-09-23 21:48:18'),(95,'Favorite Part of the 12 & 12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(96,'Feelings Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(97,'Fellowship Of The Spirit Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(98,'Fifth Step Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(99,'Freedom of Choice Spkr/Part','2019-09-23 21:48:10','2019-09-23 21:48:18'),(100,'Fri. Night “Wake Up” Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(101,'Friday Night FITS','2019-09-23 21:48:10','2019-09-23 21:48:18'),(102,'Friday Night Newcomers','2019-09-23 21:48:10','2019-09-23 21:48:18'),(103,'Friday Nite Fellowship','2019-09-23 21:48:10','2019-09-23 21:48:18'),(104,'Friday Rap Group','2019-09-23 21:48:10','2019-09-23 21:48:18'),(105,'Fun Bunch Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(106,'Glendale Coffee Break','2019-09-23 21:48:10','2019-09-23 21:48:18'),(107,'Glendale Nooners','2019-09-23 21:48:10','2019-09-23 21:48:18'),(108,'Glendale Trouble Shooters Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(109,'Good Day 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(110,'Good Day Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(111,'Good Morning Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(112,'Good Morning To You Speaker/Q&A','2019-09-23 21:48:10','2019-09-23 21:48:18'),(113,'Gratitude Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(114,' Happy Joyous and Free','2019-09-23 21:48:10','2019-09-23 21:48:18'),(115,'Happy Candlemakers Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(116,'Happy Hour Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(117,'Hope & Honesty','2019-09-23 21:48:10','2019-09-23 21:48:18'),(118,'Hour of Recovery','2019-09-23 21:48:10','2019-09-23 21:48:18'),(119,'How It Works Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(120,'Hump Day Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(121,'Integridad (Spanish language)','2019-09-23 21:48:10','2019-09-23 21:48:18'),(122,'Interview with an Alcoholic','2019-09-23 21:48:10','2019-09-23 21:48:18'),(123,'Into Action Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(124,'Joe & Charlie Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(125,'Joy of Recovery','2019-09-23 21:48:10','2019-09-23 21:48:18'),(126,'Just Let Him Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(127,'Just the Black Print Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(128,'Just the Facts BB Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(129,'Kids Are Welcome','2019-09-23 21:48:10','2019-09-23 21:48:18'),(130,'Ladies Of Success','2019-09-23 21:48:10','2019-09-23 21:48:18'),(131,'Lamplight Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(132,'Language of the Heart','2019-09-23 21:48:10','2019-09-23 21:48:18'),(133,'Laugh Out Loud','2019-09-23 21:48:10','2019-09-23 21:48:18'),(134,'Laugh-In','2019-09-23 21:48:10','2019-09-23 21:48:18'),(135,'Leader/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(136,'Learning To Live Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(137,'Life Is More Spkr Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(138,'Live & Let Live Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(139,'Live & Let Live Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(140,'Live & Let Live Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(141,'Living Sober Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(142,'Living Sober Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(143,'Living Sober/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(144,'Long Timer Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(145,'Long Timers Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(146,'Lottery Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(147,'Love and Care Women’s Group','2019-09-23 21:48:10','2019-09-23 21:48:18'),(148,'Made a Decision 3rd Step Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(149,'Magic Mountain Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(150,'Magic Of Recovery','2019-09-23 21:48:10','2019-09-23 21:48:18'),(151,'Meat & Potatoes Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(152,'Men’s 12 & 12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(153,'Men\'s Fifth Step Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(154,'Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(155,'Men\'s Stag Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(156,'More About Alcoholism','2019-09-23 21:48:10','2019-09-23 21:48:18'),(157,'Natural High','2019-09-23 21:48:10','2019-09-23 21:48:18'),(158,'New & Old Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(159,'New Leaf Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(160,'Newcomers Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(161,'No Spin Zone','2019-09-23 21:48:10','2019-09-23 21:48:18'),(162,'Noon Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(163,'Nooner','2019-09-23 21:48:10','2019-09-23 21:48:18'),(164,'Obviously 12&12 Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(165,'Old & New','2019-09-23 21:48:10','2019-09-23 21:48:18'),(166,'On Awakening','2019-09-23 21:48:10','2019-09-23 21:48:18'),(167,'One Day At A Time','2019-09-23 21:48:10','2019-09-23 21:48:18'),(168,'Open Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(169,'Out of the Hat','2019-09-23 21:48:10','2019-09-23 21:48:18'),(170,'Pacoima 12 & 12 Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(171,'Pacoima Beginners Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(172,'Pacoima Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(173,'Pacoima Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(174,'Pacoima Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(175,'Pacoima Q & A','2019-09-23 21:48:10','2019-09-23 21:48:18'),(176,'Pacoima Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(177,'Pacoima Women\'s Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(178,'Page by Page Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(179,'Panel Q&A','2019-09-23 21:48:10','2019-09-23 21:48:18'),(180,'Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(181,'Pass It On','2019-09-23 21:48:10','2019-09-23 21:48:18'),(182,'Pass It On Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(183,'Podium Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(184,'Popsicle Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(185,'Potluck Sunday Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(186,'Prime Time Is Now','2019-09-23 21:48:10','2019-09-23 21:48:18'),(187,'Prime Time Saturday Night','2019-09-23 21:48:10','2019-09-23 21:48:18'),(188,'Promises','2019-09-23 21:48:10','2019-09-23 21:48:18'),(189,'Quality of Life Men’s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(190,'Quality of Life Newcomers Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(191,'Quality of Life Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(192,'Quality of Life Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(193,'Question & Answer','2019-09-23 21:48:10','2019-09-23 21:48:18'),(194,'Rafters 11th Step Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(195,'Rafters 50/50 Speaker/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(196,'Rafters Beginners Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(197,'Rafters Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(198,'Rafters Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(199,'Rafters Burning Desire','2019-09-23 21:48:10','2019-09-23 21:48:18'),(200,'Rafters Candlelight','2019-09-23 21:48:10','2019-09-23 21:48:18'),(201,'Rafters Candlelight Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(202,'Rafters Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(203,'Rafters Happy Hour Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(204,'Rafters Men\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(205,'Rafters Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(206,'Rafters Saturday Night Live','2019-09-23 21:48:10','2019-09-23 21:48:18'),(207,'Rafters Step & Traditions Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(208,'Rafters Women\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(209,'Rafters YP Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(210,'Rebellion Dogs Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(211,'Recoverettes','2019-09-23 21:48:10','2019-09-23 21:48:18'),(212,'Relationship with God','2019-09-23 21:48:10','2019-09-23 21:48:18'),(213,'Reliance Not Defiance','2019-09-23 21:48:10','2019-09-23 21:48:18'),(214,'Reseda Big Book Study & Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(215,'Rise & Shine Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(216,'Road to Recovery','2019-09-23 21:48:10','2019-09-23 21:48:18'),(217,'Rule 62 Men\'s Big Book and 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(218,'Saddles and Serenity','2019-09-23 21:48:10','2019-09-23 21:48:18'),(219,'Santa Clarita Group Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(220,'Saturday Morning Gratitude','2019-09-23 21:48:10','2019-09-23 21:48:18'),(221,'Saturday Morning Spkr/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(222,'Saturday Morning Women\'s Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(223,'Saturday Night Live','2019-09-23 21:48:10','2019-09-23 21:48:18'),(224,'Saturday Night Live Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(225,'Scandalous Pigs','2019-09-23 21:48:10','2019-09-23 21:48:18'),(226,'Selected Grapevine Book Stdy','2019-09-23 21:48:10','2019-09-23 21:48:18'),(227,'Serenity With Sobriety Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(228,'SF 12&12 Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(229,'SF Breakfast Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(230,'SF Candlelight Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(231,'SF Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(232,'Shakers AM Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(233,'Shakers Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(234,'Shakers Speaker/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(235,'Simply the Steps','2019-09-23 21:48:10','2019-09-23 21:48:18'),(236,'Sisters In Sobriety Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(237,'Sisters of Sobriety','2019-09-23 21:48:10','2019-09-23 21:48:18'),(238,'Sober Sals Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(239,'Sober Solutions','2019-09-23 21:48:10','2019-09-23 21:48:18'),(240,'Sober Sunday','2019-09-23 21:48:10','2019-09-23 21:48:18'),(241,'Sobriety First','2019-09-23 21:48:10','2019-09-23 21:48:18'),(242,'Sobriety on a Stick','2019-09-23 21:48:10','2019-09-23 21:48:18'),(243,'Sobriety Sisters','2019-09-23 21:48:10','2019-09-23 21:48:18'),(244,'Solutions','2019-09-23 21:48:10','2019-09-23 21:48:18'),(245,'Solutions In Sobriety','2019-09-23 21:48:10','2019-09-23 21:48:18'),(246,'Solutions Only','2019-09-23 21:48:10','2019-09-23 21:48:18'),(247,'Speak to Me Spkr Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(248,'Speaker / Participation at Jensen Hall','2019-09-23 21:48:10','2019-09-23 21:48:18'),(249,'Spiritual Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(250,'Squirrelly on Sunday','2019-09-23 21:48:10','2019-09-23 21:48:18'),(251,'Step & Traditions','2019-09-23 21:48:10','2019-09-23 21:48:18'),(252,'Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(253,'Students Of The Big Book','2019-09-23 21:48:10','2019-09-23 21:48:18'),(254,'Sugar Free','2019-09-23 21:48:10','2019-09-23 21:48:18'),(255,'Sunday AM Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(256,'Sunday AM Spkr','2019-09-23 21:48:10','2019-09-23 21:48:18'),(257,'Sunday Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(258,'Sunday Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(259,'Sunlight of the Spirit','2019-09-23 21:48:10','2019-09-23 21:48:18'),(260,'Sunrise Group Big Book Speaker/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(261,'Tarzana Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(262,'The Big Show','2019-09-23 21:48:10','2019-09-23 21:48:18'),(263,'The End Of The Line','2019-09-23 21:48:10','2019-09-23 21:48:18'),(264,'The Glum Not Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(265,'The Great Reality Part.','2019-09-23 21:48:10','2019-09-23 21:48:18'),(266,'The Original What It’s Like Now Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(267,'The Page Turners Book Studies','2019-09-23 21:48:10','2019-09-23 21:48:18'),(268,'The Solution is in the Steps','2019-09-23 21:48:10','2019-09-23 21:48:18'),(269,'The Solution Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(270,'The Steps','2019-09-23 21:48:10','2019-09-23 21:48:18'),(271,'The Week That Was Disc','2019-09-23 21:48:10','2019-09-23 21:48:18'),(272,'Third Tradition Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(273,'Toluca Lake Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(274,'Topanga Canyon Friday Night Step Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(275,'Topic Disc','2019-09-23 21:48:10','2019-09-23 21:48:18'),(276,'Topic Lounge Men’s Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(277,'Topics Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(278,'Tree House','2019-09-23 21:48:10','2019-09-23 21:48:18'),(279,'Trudge The Road Part.','2019-09-23 21:48:10','2019-09-23 21:48:18'),(280,'Try God Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(281,'Try God Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(282,'Turning Point Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(283,'Twelve Traditions','2019-09-23 21:48:10','2019-09-23 21:48:18'),(284,'Valley Men’s Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(285,'Varney St. 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(286,'Varney Street Speaker','2019-09-23 21:48:10','2019-09-23 21:48:18'),(287,'Veterans\' Voice','2019-09-23 21:48:10','2019-09-23 21:48:18'),(288,'Visions of the Valley','2019-09-23 21:48:10','2019-09-23 21:48:18'),(289,'Wake Up Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(290,'We Agnostics of the Valley','2019-09-23 21:48:10','2019-09-23 21:48:18'),(291,'We Are Not Saints','2019-09-23 21:48:10','2019-09-23 21:48:18'),(292,'We Are Responsible','2019-09-23 21:48:10','2019-09-23 21:48:18'),(293,'We Are Responsible - Beginners','2019-09-23 21:48:10','2019-09-23 21:48:18'),(294,'We Are Responsible Newcomers Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(295,'We Do Recover','2019-09-23 21:48:10','2019-09-23 21:48:18'),(296,'Wed Night Men\'s Crosstalk','2019-09-23 21:48:10','2019-09-23 21:48:18'),(297,'Wednesday Nite 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(298,'West Valley Group Speaker Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(299,'WH Action Spkr/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(300,'What It\'s Like Now','2019-09-23 21:48:10','2019-09-23 21:48:18'),(301,'Winners Attitude Adjustment','2019-09-23 21:48:10','2019-09-23 21:48:18'),(302,'Winners Attitude Adjustment 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(303,'Winners Attitude Adjustment Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(304,'Women Into Recovery Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(305,'Women’s Open Door 12&12','2019-09-23 21:48:10','2019-09-23 21:48:18'),(306,'Women’s Problem Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(307,'Women’s Step & Tradition Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(308,'Women’s Steps 1','2019-09-23 21:48:10','2019-09-23 21:48:18'),(309,'Women’s Wake Up Call','2019-09-23 21:48:10','2019-09-23 21:48:18'),(310,'Women\'s Early Bird','2019-09-23 21:48:10','2019-09-23 21:48:18'),(311,'Women\'s Happy Hour','2019-09-23 21:48:10','2019-09-23 21:48:18'),(312,'Women\'s Panel Q&A','2019-09-23 21:48:10','2019-09-23 21:48:18'),(313,'Women\'s Stag','2019-09-23 21:48:10','2019-09-23 21:48:18'),(314,'Women\'s Topic Discussion','2019-09-23 21:48:10','2019-09-23 21:48:18'),(315,'Woodland Hills Big Book Study','2019-09-23 21:48:10','2019-09-23 21:48:18'),(316,'Woodland Hills Speaker/Participation','2019-09-23 21:48:10','2019-09-23 21:48:18'),(317,'Working In The Solution','2019-09-23 21:48:10','2019-09-23 21:48:18'),(318,'You Are Not Alone','2019-09-23 21:48:10','2019-09-23 21:48:18'),(319,'YPAA Speaker Meeting','2019-09-23 21:48:10','2019-09-23 21:48:18'),(320,'Other','2019-09-23 21:48:10','2019-09-23 21:48:18');

--
-- Table structure for table `sms_broadcasts`
--

CREATE TABLE `sms_broadcasts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `minutes_before_event` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `response_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sms_broadcasts`
--


--
-- Table structure for table `sms_logs`
--

CREATE TABLE `sms_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `response` int(11) DEFAULT NULL,
  `sms_broadcast_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sms_logs`
--


--
-- Table structure for table `socials`
--

CREATE TABLE `socials` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT 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`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `socials`
--

INSERT INTO `socials` VALUES (1,'facebook',NULL,'fa-facebook','','http://www.facebook.com',10,1,0,'2016-08-09 16:50:01','2016-08-09 14:50:01'),(2,'Twitter','','fa-twitter','','http://www.twitter.com',20,1,0,'2016-06-28 16:58:53','2016-06-28 14:58:53'),(3,'Linkedin','','fa-linkedin','','http://www.linkedin.com',30,1,0,'2016-06-28 16:58:59','2016-06-28 14:58:59');

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `country_id` int(8) NOT NULL,
  `title` varchar(255) NOT NULL,
  `state_code` varchar(3) NOT NULL,
  `zone` varchar(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_country` (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (21,231,'Alabama','AL','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(22,231,'Alaska','AK','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(23,231,'Arizona','AZ','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(24,231,'Arkansas','AR','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(25,231,'California','CA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(26,231,'Colorado','CO','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(27,231,'Connecticut','CT','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(28,231,'Delaware','DE','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(29,231,'District of Columbia','DC','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(30,231,'Florida','FL','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(31,231,'Georgia','GA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(32,231,'Hawaii','HI','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(33,231,'Idaho','ID','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(34,231,'Illinois','IL','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(35,231,'Indiana','IN','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(36,231,'Iowa','IA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(37,231,'Kansas','KS','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(38,231,'Kentucky','KY','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(39,231,'Louisiana','LA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(40,231,'Maine','ME','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(41,231,'Maryland','MD','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(42,231,'Massachusetts','MA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(43,231,'Michigan','MI','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(44,231,'Minnesota','MN','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(45,231,'Mississippi','MS','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(46,231,'Missouri','MO','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(47,231,'Montana','MT','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(48,231,'Nebraska','NE','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(49,231,'Nevada','NV','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(50,231,'New Hampshire','NH','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(51,231,'New Jersey','NJ','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(52,231,'New Mexico','NM','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(53,231,'New York','NY','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(54,231,'North Carolina','NC','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(55,231,'North Dakota','ND','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(56,231,'Ohio','OH','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(57,231,'Oklahoma','OK','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(58,231,'Oregon','OR','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(59,231,'Pennsylvania','PA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(60,231,'Puerto Rico','PR','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(61,231,'Rhode Island','RI','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(62,231,'South Carolina','SC','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(63,231,'South Dakota','SD','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(64,231,'Tennessee','TN','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(65,231,'Texas','TX','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(66,231,'Utah','UT','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(67,231,'Vermont','VT','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(68,231,'Virginia','VA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(69,231,'Washington','WA','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(70,231,'West Virginia','WV','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(71,231,'Wisconsin','WI','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(72,231,'Wyoming','WY','US','2020-10-09 18:57:02','2020-10-09 18:57:02'),(73,38,'Alberta','AB','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(74,38,'British Columbia','BC','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(75,38,'Manitoba','MB','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(76,38,'New Brunswick','NB','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(77,38,'Newfoundland and Labrador','NL','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(78,38,'Northwest Territories','NT','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(79,38,'Nova Scotia','NS','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(80,38,'Nunavut','NU','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(81,38,'Ontario','ON','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(82,38,'Prince Edward Island','PE','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(83,38,'Quebec','QC','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(84,38,'Saskatchewan','SK','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02'),(85,38,'Yukon','YT','Canada','2020-10-09 18:57:02','2020-10-09 18:57:02');

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_product` varchar(255) NOT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_price_unique` (`subscription_id`,`stripe_price`),
  UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_status` varchar(255) NOT NULL,
  `stripe_price` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`),
  KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `tag_translations`
--

CREATE TABLE `tag_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_translations_tag_id_locale_unique` (`tag_id`,`locale`),
  KEY `tag_translations_locale_index` (`locale`),
  CONSTRAINT `tag_translations_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tag_translations`
--

INSERT INTO `tag_translations` VALUES (1,1,'en','Tag','2016-12-27 22:07:07','2016-12-27 21:07:07'),(2,1,'it','tag','2016-12-27 18:46:45','2016-12-27 17:46:45'),(3,2,'en','PHP','2016-12-27 21:07:15','2016-12-27 21:07:15'),(4,2,'it','Php','2016-12-27 21:07:15','2017-08-02 18:02:09'),(7,4,'it','Artisan','2017-08-02 18:01:53','2017-08-02 18:01:53'),(8,4,'en','Artisan','2017-08-02 18:01:53','2017-08-02 18:01:53');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(100) NOT 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`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'','tag',0,0,'2016-12-27 22:07:28','2016-12-27 21:07:28'),(2,'','php',0,0,'2016-12-27 21:07:15','2016-12-27 21:07:15'),(4,'','artisan',0,0,'2017-08-02 18:01:53','2017-08-02 18:01:53');

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_no` varchar(255) DEFAULT NULL,
  `order_id` int(11) NOT NULL,
  `check_number` varchar(255) DEFAULT NULL,
  `payment_type_id` int(11) NOT NULL DEFAULT 1,
  `transaction_status` varchar(255) NOT NULL DEFAULT 'pending',
  `payment_amount` decimal(8,2) NOT NULL,
  `comments` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `transactions`
--


--
-- Table structure for table `virtual_types`
--

CREATE TABLE `virtual_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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `virtual_types`
--

INSERT INTO `virtual_types` VALUES (1,'Zoom','2022-07-16 02:05:15','2022-07-16 02:05:15'),(2,'Google Meet','2022-07-16 02:05:15','2022-07-16 02:05:15'),(3,'Microsoft Teams','2022-07-16 02:05:15','2022-07-16 02:05:15');


