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

예제 #1

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::ARTICLE_NAME, 300);
     parent::_addBoolean(self::ARTICLE_IS_CATEGORY);
     parent::_addVarchar(self::CATEGORY_NAME, 300);
 }

예제 #2

파일: 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);
 }

예제 #3

파일: 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);
 }

예제 #4

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addInteger(self::SCOPE, 10);
     parent::_addVarchar(self::NAME, 200);
     parent::_addText(self::DESCRIPTION, false);
     parent::_addBoolean(self::IS_ACTIVE);
 }

예제 #5

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 45);
     parent::_addVarchar(self::MODULE, 45);
     parent::_addVarchar(self::VALUE, 200);
     parent::_addInteger(self::UID, 10);
     parent::_addInteger(self::UPDATED_AT, 10);
 }

예제 #6

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::SUBJECT, 255);
     parent::_addVarchar(self::FROM, 255);
     parent::_addText(self::TO);
     parent::_addText(self::MESSAGE);
     parent::_addText(self::MESSAGE_HTML);
     parent::_addInteger(self::DATE, 10);
 }

예제 #7

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

 public function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 255);
     parent::_addText(self::CONTENT, false);
     parent::_addBoolean(self::IS_PUBLISHED);
     parent::_addInteger(self::DATE, 10);
     parent::_addInteger(self::AUTHOR, 10);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #8

파일: 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);
 }

예제 #9

파일: 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);
 }

예제 #10

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 200);
     parent::_addInteger(self::VIEW);
     parent::_addInteger(self::PID);
     parent::_addInteger(self::TARGET_TYPE);
     parent::_addInteger(self::TID);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #11

파일: 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);
 }

예제 #12

파일: 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());
 }

예제 #13

파일: TBGPermissionsTable.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::_addInteger(self::UID, 10);
     parent::_addInteger(self::GID, 10);
     parent::_addInteger(self::TID, 10);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #14

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::MODULE_NAME, 50);
     parent::_addInteger(self::NOTIFY_TYPE, 5);
     parent::_addInteger(self::TARGET_ID, 10);
     parent::_addVarchar(self::TITLE, 100);
     parent::_addText(self::CONTENTS, false);
     parent::_addInteger(self::STATUS, 5);
     parent::_addInteger(self::UID, 10);
     parent::_addInteger(self::GID, 10);
     parent::_addInteger(self::TID, 10);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #15

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 200);
     parent::_addText(self::DESCRIPTION, false);
     parent::_addBoolean(self::IS_PUBLIC);
     parent::_addVarchar(self::TEMPLATE_NAME, 200);
     parent::_addVarchar(self::TEMPLATE_PARAMETER, 200);
     parent::_addInteger(self::ISSUES_PER_PAGE, 10);
     parent::_addVarchar(self::GROUPBY, 100);
     parent::_addVarchar(self::GROUPORDER, 5);
     parent::_addInteger(self::APPLIES_TO_PROJECT, 10);
     parent::_addInteger(self::UID, 10);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #16

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 200);
     parent::_addVarchar(self::SERVER, 200);
     parent::_addInteger(self::PORT, 3);
     parent::_addInteger(self::SERVER_TYPE, 10);
     parent::_addBoolean(self::SSL);
     parent::_addBoolean(self::KEEP_EMAIL);
     parent::_addVarchar(self::USERNAME, 200);
     parent::_addVarchar(self::PASSWORD, 200);
     parent::_addInteger(self::PROJECT, 10);
     parent::_addInteger(self::ISSUETYPE, 10);
     parent::_addInteger(self::NUM_LAST_FETCHED, 10);
     parent::_addInteger(self::TIME_LAST_FETCHED, 10);
     parent::_addInteger(self::SCOPE, 10);
 }

예제 #17

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addInteger(self::TARGET_ID, 10);
     parent::_addInteger(self::TARGET_TYPE, 3);
     parent::_addText(self::CONTENT, false);
     parent::_addInteger(self::POSTED, 10);
     parent::_addInteger(self::UPDATED, 10);
     parent::_addInteger(self::COMMENT_NUMBER, 10);
     parent::_addInteger(self::REPLY_TO_COMMENT, 10);
     parent::_addBoolean(self::DELETED);
     parent::_addBoolean(self::IS_PUBLIC, true);
     parent::_addVarchar(self::MODULE, 50);
     parent::_addBoolean(self::SYSTEM_COMMENT);
     parent::_addInteger(self::SCOPE, 10);
     parent::_addInteger(self::UPDATED_BY, 10);
     parent::_addInteger(self::POSTED_BY, 10);
 }

예제 #18

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addInteger(self::ISSUE_NO, 10);
     parent::_addVarchar(self::TITLE, 255);
     parent::_addInteger(self::POSTED, 10);
     parent::_addInteger(self::LAST_UPDATED, 10);
     parent::_addInteger(self::PROJECT_ID, 10);
     parent::_addText(self::DESCRIPTION, false);
     parent::_addBoolean(self::STATE);
     parent::_addInteger(self::POSTED_BY, 10);
     parent::_addFloat(self::USER_PAIN, 3);
     parent::_addInteger(self::PAIN_BUG_TYPE, 3);
     parent::_addInteger(self::PAIN_EFFECT, 3);
     parent::_addInteger(self::PAIN_LIKELIHOOD, 3);
     parent::_addText(self::REPRODUCTION_STEPS, false);
     parent::_addInteger(self::RESOLUTION, 10);
     parent::_addInteger(self::ISSUE_TYPE, 10);
     parent::_addInteger(self::STATUS, 10);
     parent::_addInteger(self::PRIORITY, 10);
     parent::_addInteger(self::CATEGORY, 10);
     parent::_addInteger(self::SEVERITY, 10);
     parent::_addInteger(self::REPRODUCABILITY, 10);
     parent::_addVarchar(self::SCRUMCOLOR, 7, '#FFFFFF');
     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::_addInteger(self::ESTIMATED_POINTS);
     parent::_addInteger(self::SPENT_MONTHS, 10);
     parent::_addInteger(self::SPENT_WEEKS, 10);
     parent::_addInteger(self::SPENT_DAYS, 10);
     parent::_addInteger(self::SPENT_HOURS, 10);
     parent::_addInteger(self::VOTES_TOTAL, 10);
     parent::_addInteger(self::SPENT_POINTS);
     parent::_addInteger(self::PERCENT_COMPLETE, 2);
     parent::_addInteger(self::DUPLICATE_OF, 10);
     parent::_addBoolean(self::DELETED);
     parent::_addBoolean(self::BLOCKING);
     parent::_addBoolean(self::LOCKED);
     parent::_addInteger(self::BEING_WORKED_ON_BY_USER, 10);
     parent::_addInteger(self::BEING_WORKED_ON_BY_USER_SINCE, 10);
     parent::_addInteger(self::MILESTONE, 10);
     parent::_addInteger(self::WORKFLOW_STEP_ID, 10);
     parent::_addInteger(self::SCOPE, 10);
     parent::_addInteger(self::OWNER_USER, 10);
     parent::_addInteger(self::OWNER_TEAM, 10);
     parent::_addInteger(self::ASSIGNEE_TEAM, 10);
     parent::_addInteger(self::ASSIGNEE_USER, 10);
 }

예제 #19

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::ARTICLE_NAME, 300);
     parent::_addVarchar(self::LINK_ARTICLE_NAME, 300);
 }

예제 #20

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

 protected function _initialize()
 {
     parent::_setup(self::B2DBNAME, self::ID);
     parent::_addVarchar(self::NAME, 200);
     parent::_addVarchar(self::KEY, 200);
     parent::_addInteger(self::SMALL_ICON, 10);
     parent::_addInteger(self::LARGE_ICON, 10);
     parent::_addVarchar(self::PREFIX, 25, '');
     parent::_addBoolean(self::USE_PREFIX);
     parent::_addBoolean(self::USE_SCRUM);
     parent::_addBoolean(self::HAS_DOWNLOADS);
     parent::_addVarchar(self::HOMEPAGE, 200, '');
     parent::_addInteger(self::OWNER_USER, 10);
     parent::_addInteger(self::OWNER_TEAM, 10);
     parent::_addInteger(self::LEADER_USER, 10);
     parent::_addInteger(self::LEADER_TEAM, 10);
     parent::_addInteger(self::QA_USER, 10);
     parent::_addInteger(self::QA_TEAM, 10);
     parent::_addText(self::DESCRIPTION, false);
     parent::_addVarchar(self::DOC_URL, 200, '');
     parent::_addBoolean(self::ALLOW_CHANGING_WITHOUT_WORKING);
     parent::_addBoolean(self::RELEASED);
     parent::_addInteger(self::RELEASE_DATE, 10);
     parent::_addBoolean(self::ENABLE_BUILDS);
     parent::_addBoolean(self::ENABLE_EDITIONS);
     parent::_addBoolean(self::ENABLE_COMPONENTS);
     parent::_addBoolean(self::SHOW_IN_SUMMARY, true);
     parent::_addVarchar(self::SUMMARY_DISPLAY, 15, 'issuetypes');
     parent::_addBoolean(self::LOCKED);
     parent::_addBoolean(self::ARCHIVED);
     parent::_addInteger(self::SCOPE, 10);
     parent::_addInteger(self::WORKFLOW_SCHEME_ID, 10);
     parent::_addInteger(self::ISSUETYPE_SCHEME_ID, 10);
     parent::_addInteger(self::CLIENT, 10);
     parent::_addInteger(self::PARENT_PROJECT_ID, 10);
     parent::_addBoolean(self::DELETED);
     parent::_addBoolean(self::AUTOASSIGN);
 }