PHP thebuggenie\core\entities\tables ScopedTable::_addForeignKeyColumn 예제들

예제 #1

파일: IssueTags.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::ISSUE_ID, Issues::getTable(), Issues::ID);
     parent::_addVarchar(self::TAG_NAME, 50);
     parent::_addInteger(self::ADDED, 10);
 }

예제 #2

파일: Votes.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addInteger(self::TARGET, 10);
     parent::_addInteger(self::VOTE, 2);
     parent::_addForeignKeyColumn(self::UID, Users::getTable(), Users::ID);
 }

예제 #3

파일: IssueRelations.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addBoolean(self::MUSTFIX);
     parent::_addForeignKeyColumn(self::PARENT_ID, Issues::getTable(), Issues::ID);
     parent::_addForeignKeyColumn(self::CHILD_ID, Issues::getTable(), Issues::ID);
 }

예제 #4

파일: ProjectAssignedTeams.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::PROJECT_ID, Projects::getTable());
     parent::_addForeignKeyColumn(self::ROLE_ID, ListTypes::getTable());
     parent::_addForeignKeyColumn(self::TEAM_ID, Teams::getTable());
 }

예제 #5

파일: WorkflowIssuetype.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::WORKFLOW_ID, Workflows::getTable());
     parent::_addForeignKeyColumn(self::WORKFLOW_SCHEME_ID, WorkflowSchemes::getTable());
     parent::_addForeignKeyColumn(self::ISSUETYPE_ID, IssueTypes::getTable());
 }

예제 #6

파일: WorkflowStepTransitions.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::WORKFLOW_ID, Workflows::getTable(), Workflows::ID);
     parent::_addForeignKeyColumn(self::FROM_STEP_ID, WorkflowSteps::getTable(), WorkflowSteps::ID);
     parent::_addForeignKeyColumn(self::TRANSITION_ID, WorkflowTransitions::getTable(), WorkflowTransitions::ID);
 }

예제 #7

파일: UserScopes.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addBoolean(self::CONFIRMED);
     parent::_addForeignKeyColumn(self::USER_ID, Users::getTable(), Users::ID);
     parent::_addForeignKeyColumn(self::GROUP_ID, Groups::getTable(), Groups::ID);
 }

예제 #8

파일: IssueFiles.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::UID, Users::getTable(), Users::ID);
     parent::_addForeignKeyColumn(self::ISSUE_ID, Issues::getTable(), Issues::ID);
     parent::_addForeignKeyColumn(self::FILE_ID, Files::getTable(), Files::ID);
     parent::_addInteger(self::ATTACHED_AT, 10);
 }

예제 #9

파일: ArticleFiles.php 프로젝트: RTechSoft/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::UID, \thebuggenie\core\entities\tables\Users::getTable(), \thebuggenie\core\entities\tables\Users::ID);
     parent::_addForeignKeyColumn(self::ARTICLE_ID, Articles::getTable(), Articles::ID);
     parent::_addForeignKeyColumn(self::FILE_ID, \thebuggenie\core\entities\tables\Files::getTable(), \thebuggenie\core\entities\tables\Files::ID);
     parent::_addInteger(self::ATTACHED_AT, 10);
 }

예제 #10

파일: IssueCustomFields.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::ISSUE_ID, Issues::getTable(), Issues::ID);
     parent::_addForeignKeyColumn(self::CUSTOMFIELDS_ID, CustomFields::getTable(), CustomFields::ID);
     parent::_addForeignKeyColumn(self::CUSTOMFIELDOPTION_ID, CustomFieldOptions::getTable(), CustomFieldOptions::ID);
     parent::_addText(self::OPTION_VALUE, false);
 }

예제 #11

파일: IssuetypeSchemeLink.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::ISSUETYPE_SCHEME_ID, IssuetypeSchemes::getTable(), IssuetypeSchemes::ID);
     parent::_addForeignKeyColumn(self::ISSUETYPE_ID, IssueTypes::getTable(), IssueTypes::ID);
     parent::_addBoolean(self::REPORTABLE, true);
     parent::_addBoolean(self::REDIRECT_AFTER_REPORTING, true);
 }

예제 #12

파일: IssueAffectsBuild.php 프로젝트: RTechSoft/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addBoolean(self::CONFIRMED);
     parent::_addForeignKeyColumn(self::BUILD, Builds::getTable(), Builds::ID);
     parent::_addForeignKeyColumn(self::ISSUE, Issues::getTable(), Issues::ID);
     parent::_addForeignKeyColumn(self::STATUS, ListTypes::getTable(), ListTypes::ID);
 }

예제 #13

파일: SavedSearchFilters.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::VALUE, 200);
     parent::_addVarchar(self::OPERATOR, 40);
     parent::_addVarchar(self::FILTER_KEY, 100);
     parent::_addForeignKeyColumn(self::SEARCH_ID, SavedSearches::getTable(), SavedSearches::ID);
 }

예제 #14

파일: IssueFields.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::FIELD_KEY, 100);
     parent::_addBoolean(self::REQUIRED);
     parent::_addBoolean(self::REPORTABLE);
     parent::_addBoolean(self::ADDITIONAL);
     parent::_addForeignKeyColumn(self::ISSUETYPE_ID, IssueTypes::getTable(), IssueTypes::ID);
     parent::_addForeignKeyColumn(self::ISSUETYPE_SCHEME_ID, IssuetypeSchemes::getTable(), IssuetypeSchemes::ID);
 }

예제 #15

파일: Links.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::URL, 300);
     parent::_addInteger(self::LINK_ORDER, 3);
     parent::_addVarchar(self::TARGET_TYPE, 30);
     parent::_addInteger(self::TARGET_ID, 10);
     parent::_addVarchar(self::DESCRIPTION, 100, '');
     parent::_addForeignKeyColumn(self::UID, Users::getTable(), Users::ID);
 }

예제 #16

파일: ArticleHistory.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::ARTICLE_NAME, 255);
     parent::_addText(self::OLD_CONTENT, false);
     parent::_addText(self::NEW_CONTENT, false);
     parent::_addVarchar(self::REASON, 255);
     parent::_addInteger(self::DATE, 10);
     parent::_addInteger(self::REVISION, 10);
     parent::_addForeignKeyColumn(self::AUTHOR, \thebuggenie\core\entities\tables\Users::getTable(), \thebuggenie\core\entities\tables\Users::ID);
 }

예제 #17

파일: IssueEstimates.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::ISSUE_ID, Issues::getTable(), Issues::ID);
     parent::_addForeignKeyColumn(self::EDITED_BY, Users::getTable(), Users::ID);
     parent::_addInteger(self::EDITED_AT, 10);
     parent::_addInteger(self::ESTIMATED_MONTHS, 10);
     parent::_addInteger(self::ESTIMATED_WEEKS, 10);
     parent::_addInteger(self::ESTIMATED_DAYS, 10);
     parent::_addInteger(self::ESTIMATED_HOURS, 10);
     parent::_addFloat(self::ESTIMATED_POINTS);
 }

예제 #18

파일: Permissions.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::PERMISSION_TYPE, 100);
     parent::_addVarchar(self::TARGET_ID, 200, 0);
     parent::_addBoolean(self::ALLOWED);
     parent::_addVarchar(self::MODULE, 50);
     parent::_addForeignKeyColumn(self::UID, Users::getTable());
     parent::_addForeignKeyColumn(self::GID, Groups::getTable());
     parent::_addForeignKeyColumn(self::TID, Teams::getTable());
     parent::_addForeignKeyColumn(self::ROLE_ID, ListTypes::getTable());
 }

예제 #19

파일: VisibleMilestones.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::MILESTONE_ID, Milestones::getTable(), Milestones::ID);
     parent::_addForeignKeyColumn(self::PROJECT_ID, Projects::getTable(), Projects::ID);
 }

예제 #20

파일: EditionComponents.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::EDITION, Editions::getTable(), Editions::ID);
     parent::_addForeignKeyColumn(self::COMPONENT, Components::getTable(), Components::ID);
 }

예제 #21

파일: TeamMembers.php 프로젝트: founderio/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::UID, Users::getTable());
     parent::_addForeignKeyColumn(self::TID, Teams::getTable());
 }

예제 #22

파일: VisibleIssueTypes.php 프로젝트: pkdevboxy/thebuggenie

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addForeignKeyColumn(self::ISSUETYPE_ID, IssueTypes::getTable(), IssueTypes::ID);
     parent::_addForeignKeyColumn(self::PROJECT_ID, Projects::getTable(), Projects::ID);
 }