55 lines
7.7 KiB
SQL
55 lines
7.7 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: hotlunch
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.36
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!50503 SET NAMES utf8 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `_form_permission`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `_form_permission`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8 */;
|
|
CREATE TABLE `_form_permission` (
|
|
`action_name` varchar(100) NOT NULL,
|
|
`action_permission_user_type` varchar(100) NOT NULL,
|
|
`action_permission_allowed` enum('Y','N') DEFAULT 'Y',
|
|
`record_num` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
UNIQUE KEY `record_num` (`record_num`),
|
|
KEY `action_name` (`action_name`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `_form_permission`
|
|
--
|
|
|
|
LOCK TABLES `_form_permission` WRITE;
|
|
/*!40000 ALTER TABLE `_form_permission` DISABLE KEYS */;
|
|
INSERT INTO `_form_permission` VALUES ('classes','System Administrator','Y',1),('classes','Application Administrator','Y',2),('classes','Application Volunteer','N',3),('classes','Administration Team','Y',4),('classes','Schedule Volunteer','N',5),('classes','Schedule Team','N',6),('classes','Schedule Reporting','Y',7),('classes','Financial','Y',8),('classes','Financial Team','Y',9),('classes','Volunteer Administrator','N',10),('classes','Communications Administrator','N',11),('classes','Parent','N',12),('classes','Guest','N',13),('form-actions','System Administrator','Y',14),('form-actions','Application Administrator','N',15),('form-actions','Application Volunteer','N',16),('form-actions','Administration Team','N',17),('form-actions','Schedule Volunteer','N',18),('form-actions','Schedule Team','N',19),('form-actions','Schedule Reporting','N',20),('form-actions','Financial','N',21),('form-actions','Financial Team','N',22),('form-actions','Volunteer Administrator','N',23),('form-actions','Communications Administrator','N',24),('form-actions','Parent','N',25),('form-actions','Guest','N',26),('form-fields','System Administrator','Y',27),('form-fields','Application Administrator','N',28),('form-fields','Application Volunteer','N',29),('form-fields','Administration Team','N',30),('form-fields','Schedule Volunteer','N',31),('form-fields','Schedule Team','N',32),('form-fields','Schedule Reporting','N',33),('form-fields','Financial','N',34),('form-fields','Financial Team','N',35),('form-fields','Volunteer Administrator','N',36),('form-fields','Communications Administrator','N',37),('form-fields','Parent','N',38),('form-fields','Guest','N',39),('form-permissions','System Administrator','Y',40),('form-permissions','Application Administrator','N',41),('form-permissions','Application Volunteer','N',42),('form-permissions','Administration Team','N',43),('form-permissions','Schedule Volunteer','N',44),('form-permissions','Schedule Team','N',45),('form-permissions','Schedule Reporting','N',46),('form-permissions','Financial','N',47),('form-permissions','Financial Team','N',48),('form-permissions','Volunteer Administrator','N',49),('form-permissions','Communications Administrator','N',50),('form-permissions','Parent','N',51),('form-permissions','Guest','N',52),('school_contact_list','System Administrator','Y',53),('school_contact_list','Application Administrator','Y',54),('school_contact_list','Application Volunteer','N',55),('school_contact_list','Administration Team','Y',56),('school_contact_list','Schedule Volunteer','N',57),('school_contact_list','Schedule Team','N',58),('school_contact_list','Schedule Reporting','N',59),('school_contact_list','Financial','Y',60),('school_contact_list','Financial Team','N',61),('school_contact_list','Volunteer Administrator','N',62),('school_contact_list','Communications Administrator','Y',63),('school_contact_list','Parent','N',64),('school_contact_list','Guest','N',65),('staff-people','System Administrator','Y',66),('staff-people','Application Administrator','Y',67),('staff-people','Application Volunteer','Y',68),('staff-people','Administration Team','Y',69),('staff-people','Schedule Volunteer','N',70),('staff-people','Schedule Team','N',71),('staff-people','Schedule Reporting','N',72),('staff-people','Financial','Y',73),('staff-people','Financial Team','N',74),('staff-people','Volunteer Administrator','N',75),('staff-people','Communications Administrator','Y',76),('staff-people','Parent','N',77),('staff-people','Guest','N',78),('user_account_trx_codes','System Administrator','Y',79),('user_account_trx_codes','Application Administrator','Y',80),('user_account_trx_codes','Application Volunteer','Y',81),('user_account_trx_codes','Administration Team','Y',82),('user_account_trx_codes','Schedule Volunteer','N',83),('user_account_trx_codes','Schedule Team','N',84),('user_account_trx_codes','Schedule Reporting','N',85),('user_account_trx_codes','Financial','Y',86),('user_account_trx_codes','Financial Team','N',87),('user_account_trx_codes','Volunteer Administrator','N',88),('user_account_trx_codes','Communications Administrator','N',89),('user_account_trx_codes','Parent','N',90),('user_account_trx_codes','Guest','N',91),('users','System Administrator','Y',92),('users','Application Administrator','Y',93),('users','Application Volunteer','Y',94),('users','Administration Team','Y',95),('users','Schedule Volunteer','N',96),('users','Schedule Team','N',97),('users','Schedule Reporting','N',98),('users','Financial','Y',99),('users','Financial Team','Y',100),('users','Volunteer Administrator','Y',101),('users','Communications Administrator','N',102),('users','Parent','N',103),('users','Guest','N',104),('student-people','System Administrator','Y',105),('student-people','Application Administrator','Y',106),('student-people','Application Volunteer','N',107),('student-people','Administration Team','N',108),('student-people','Schedule Volunteer','N',109),('student-people','Schedule Team','N',110),('student-people','Schedule Reporting','N',111),('student-people','Financial','N',112),('student-people','Financial Team','N',113),('student-people','Volunteer Administrator','N',114),('student-people','Communications Administrator','N',115),('student-people','Parent','N',116),('student-people','Guest','N',117),('','System Administrator','Y',118),('','Application Administrator','Y',119),('','Application Volunteer','N',120),('','Administration Team','N',121),('','Schedule Volunteer','N',122),('','Schedule Team','N',123),('','Schedule Reporting','N',124),('','Financial','N',125),('','Financial Team','N',126),('','Volunteer Administrator','N',127),('','Communications Administrator','N',128),('','Parent','N',129),('','Guest','N',130);
|
|
/*!40000 ALTER TABLE `_form_permission` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2024-08-06 23:55:01
|