function GroupPermission($db, &$creator) { $enabled = new dbEnumField('enabled', DB_TYPE_ENUM, 'Y', 'N'); $permName = new dbField('permission_name', DB_TYPE_STRING, 255); $groupID = new dbField('group_id', DB_TYPE_INT, 255); $groupJoin = new oneToOneJoinField('group', 'groups', 'group_id', $groupID); parent::DBTableObject($db, array($enabled, $permName, $groupID), 'groupPermissions', 'permission_id', $creator); }
/** * Constructor. * * @param $db (dbModule) * @param $creator (object) * @param $extraFields (object dbField array) * @param $extraJoins (object genericJoinField array) */ function UserTranslatedGroup($db, &$creator, $extraFields = array(), $extraJoins = array()) { $name = new dbField('name', DB_TYPE_STRING, 255); $description = new dbField('description', DB_TYPE_TEXT); $groupID = new dbField('group_id', DB_TYPE_INT); $groupID->canBeNull = true; $lCode = new dbField('language_code', DB_TYPE_STRING, 5); parent::DBTableObject($db, array($name, $description, $groupID, $lCode), 'translatedGroups', 'translated_group_id', $creator, $extraFields); }
function Author(&$db, &$creator) { $firstName = new dbField('firstname', DB_TYPE_STRING, 70); $lastName = new dbField('lastname', DB_TYPE_STRING, 70); $ID = new dbField('authorid', DB_TYPE_INT, 11); $basicFields = array($ID, $firstName, $lastName); $joins = array(new OneToMultipleJoinField('books', 'Books', 'authorid', $ID)); parent::DBTableObject($db, $basicFields, 'authors', 'authorid', $creator, array(), $joins); }
function calendarEvent(&$db, $extraOptions, &$creator) { $name = new dbField('name', 'string'); $start = new dbField('start', 'datetime'); $end = new dbField('end', 'datetime'); $desc = new dbField('description', 'text'); $group = new dbField('groupID', 'int'); parent::DBTableObject($db, $extraOptions, array('name' => $name, 'start' => $start, 'end' => $end, 'description' => $desc, 'groupID' => $group), 'calendar', 'eventID', $creator); }
/** * Constructor * * @param $db (object database) the database module * @param $parent (object) * @param $extraFields (dbField array) an array with extra fields * @param $extraJoins (dbGenericJoinField array) an array with extra joins */ function User($db, &$parent, $extraFields = array(), $extraJoins = array()) { $login = new dbField('login', DB_TYPE_STRING, 255); $email = new dbField('email', DB_TYPE_STRING, 255); $pass = new dbField('password', DB_TYPE_STRING, 32); // md5ied always length 32 $ID = new dbField('user_id', DB_TYPE_INT, 11); $groupJoin = new MultipleToMultipleJoinField('groups', 'group', 'group_id', $ID, 'groupUsers'); parent::DBTableObject($db, array($login, $email, $pass), 'users', 'user_id', $parent, $extraFields, array_merge(array($groupJoin), $extraJoins)); }
/** * Constructor * * @param $db (dbModule) * @param $parent (object) the creator of this object (a pagemanager object) * @param $extraFields (object dbField array) * @param $extraJoins (object dbGenericJoinField array) */ function TranslatedPage(&$db, &$parent, $extraFields = array(), $extraJoins = array()) { $translatedTitle = new dbField('translated_title', DB_TYPE_STRING, 255); $translatedNavTitle = new dbField('translated_nav_title', DB_TYPE_STRING, 255); $translatedNavTitle->canBeNull = true; $translatedContent = new dbField('translated_content', DB_TYPE_TEXT); $translatedContent->canBeNull = true; $pageID = new dbField('page_id', DB_TYPE_INT, 11); $pageID->canBeNull = true; $languageCode = new dbField('language_code', DB_TYPE_STRING, 25); $ID = new dbField('translated_page_id', DB_TYPE_INT, 11); parent::DBTableObject($db, array($ID, $translatedTitle, $translatedNavTitle, $translatedContent, $pageID, 'languageCode' => $languageCode), 'translatedPages', 'translated_page_id', $parent, $extraFields); }
/** * Constructor * * @param $db (object dbModule) * @param $parent (object) The creator * @param $allEFields (dbField array) all extra fields * @param $allEJoins (dbGenericJoin array) all extra joins */ function Page(&$db, &$parent, $allEFields = array(), $allEJoins = array()) { $name = new dbField('name', DB_TYPE_STRING, 255); $parentPageID = new dbField('parent_page_id', DB_TYPE_INT, 11); $placeInMenu = new dbField('place_in_menu', DB_TYPE_INT, 4); $placeInMenu->canBeNull = true; $action = new dbField('action', DB_TYPE_STRING, 255); $action->canBeNull = true; $pluginID = new dbField('plugin_id', DB_TYPE_STRING, 38); $pluginID->canBeNull = true; $ID = new dbField('page_id', DB_TYPE_INT, 11); $translatedJoin = new oneToMultipleJoinField('translatedPages', $db->getPrefix() . 'translatedPages', 'page_id', $ID); $childJoin = new oneToMultipleJoinField('childPages', $db->getPrefix() . 'pages', 'parent_page_id', $ID); parent::DBTableObject($db, array($ID, $name, $parentPageID, $placeInMenu, $action, $pluginID), 'pages', 'page_id', $parent, $allEFields, array($translatedJoin, $childJoin)); }
/** * Constructor * * @param $db (object database) the database module * @param $creator (object) * @param $extraFields (dbField array) * @param $extraJoins (dbGenericJoinField array) */ function UserGroup($db, &$creator, $extraFields = array(), $extraJoins = array()) { $genericName = new dbField('generic_name', DB_TYPE_STRING, 255); $genericDescription = new dbField('generic_description', DB_TYPE_TEXT); parent::DBTableObject($db, array($genericName, $genericDescription), 'groups', 'group_id', $creator, $extraFields); }