From 9f108dd1a969473375341d92a7b1252fa2cedc9a Mon Sep 17 00:00:00 2001 From: mszulecki Date: Thu, 14 Jun 2007 17:09:01 +0000 Subject: Initial import. git-svn-id: http://svn.sukimashita.com/repos/mailadmin/trunk@2 4281df72-ff29-0410-8fee-2d9ac0c5f5a7 --- lib/model/map/AddressMapBuilder.php | 52 +++++++++++++++++++++++++ lib/model/map/DomainMapBuilder.php | 50 ++++++++++++++++++++++++ lib/model/map/DomainPermissionMapBuilder.php | 42 ++++++++++++++++++++ lib/model/map/LogEntryMapBuilder.php | 48 +++++++++++++++++++++++ lib/model/map/MailboxMapBuilder.php | 52 +++++++++++++++++++++++++ lib/model/map/RoleMapBuilder.php | 42 ++++++++++++++++++++ lib/model/map/UserMapBuilder.php | 58 ++++++++++++++++++++++++++++ 7 files changed, 344 insertions(+) create mode 100644 lib/model/map/AddressMapBuilder.php create mode 100644 lib/model/map/DomainMapBuilder.php create mode 100644 lib/model/map/DomainPermissionMapBuilder.php create mode 100644 lib/model/map/LogEntryMapBuilder.php create mode 100644 lib/model/map/MailboxMapBuilder.php create mode 100644 lib/model/map/RoleMapBuilder.php create mode 100644 lib/model/map/UserMapBuilder.php (limited to 'lib/model/map') diff --git a/lib/model/map/AddressMapBuilder.php b/lib/model/map/AddressMapBuilder.php new file mode 100644 index 0000000..8993460 --- /dev/null +++ b/lib/model/map/AddressMapBuilder.php @@ -0,0 +1,52 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('address'); + $tMap->setPhpName('Address'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addForeignKey('MAILBOX_ID', 'MailboxId', 'int', CreoleTypes::INTEGER, 'mailbox', 'ID', false, null); + + $tMap->addColumn('LOCALPART', 'Localpart', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addForeignKey('DOMAIN_ID', 'DomainId', 'int', CreoleTypes::INTEGER, 'domain', 'ID', false, null); + + $tMap->addColumn('ALIAS', 'Alias', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addColumn('DESTINATION', 'Destination', 'string', CreoleTypes::LONGVARCHAR, false, null); + + $tMap->addColumn('ACTIVE', 'Active', 'boolean', CreoleTypes::BOOLEAN, false, null); + + $tMap->addColumn('SAVE_IN_MAILBOX', 'SaveInMailbox', 'boolean', CreoleTypes::BOOLEAN, false, null); + + } +} \ No newline at end of file diff --git a/lib/model/map/DomainMapBuilder.php b/lib/model/map/DomainMapBuilder.php new file mode 100644 index 0000000..36e0d83 --- /dev/null +++ b/lib/model/map/DomainMapBuilder.php @@ -0,0 +1,50 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('domain'); + $tMap->setPhpName('Domain'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addForeignKey('CREATOR_ID', 'CreatorId', 'int', CreoleTypes::INTEGER, 'user', 'ID', false, null); + + $tMap->addColumn('MAILBOX_PREFIX', 'MailboxPrefix', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addColumn('MAX_MAILBOX_COUNT', 'MaxMailboxCount', 'int', CreoleTypes::INTEGER, false, null); + + $tMap->addColumn('QUOTA', 'Quota', 'int', CreoleTypes::INTEGER, false, null); + + $tMap->addColumn('DEFAULT_MAILBOX_QUOTA', 'DefaultMailboxQuota', 'int', CreoleTypes::INTEGER, false, null); + + } +} \ No newline at end of file diff --git a/lib/model/map/DomainPermissionMapBuilder.php b/lib/model/map/DomainPermissionMapBuilder.php new file mode 100644 index 0000000..380be1c --- /dev/null +++ b/lib/model/map/DomainPermissionMapBuilder.php @@ -0,0 +1,42 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('domain_permission'); + $tMap->setPhpName('DomainPermission'); + + $tMap->setUseIdGenerator(true); + + $tMap->addForeignKey('USER_ID', 'UserId', 'int', CreoleTypes::INTEGER, 'user', 'ID', false, null); + + $tMap->addForeignKey('DOMAIN_ID', 'DomainId', 'int', CreoleTypes::INTEGER, 'domain', 'ID', false, null); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + } +} \ No newline at end of file diff --git a/lib/model/map/LogEntryMapBuilder.php b/lib/model/map/LogEntryMapBuilder.php new file mode 100644 index 0000000..737ea21 --- /dev/null +++ b/lib/model/map/LogEntryMapBuilder.php @@ -0,0 +1,48 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('log'); + $tMap->setPhpName('LogEntry'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addForeignKey('USER_ID', 'UserId', 'int', CreoleTypes::INTEGER, 'user', 'ID', false, null); + + $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); + + $tMap->addColumn('MESSAGE', 'Message', 'string', CreoleTypes::LONGVARCHAR, false, null); + + $tMap->addColumn('HOST', 'Host', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addColumn('PRIORITY', 'Priority', 'int', CreoleTypes::INTEGER, false, null); + + } +} \ No newline at end of file diff --git a/lib/model/map/MailboxMapBuilder.php b/lib/model/map/MailboxMapBuilder.php new file mode 100644 index 0000000..54bbe40 --- /dev/null +++ b/lib/model/map/MailboxMapBuilder.php @@ -0,0 +1,52 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('mailbox'); + $tMap->setPhpName('Mailbox'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addForeignKey('DOMAIN_ID', 'DomainId', 'int', CreoleTypes::INTEGER, 'domain', 'ID', false, null); + + $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 30); + + $tMap->addColumn('PASSWORD', 'Password', 'string', CreoleTypes::VARCHAR, false, 40); + + $tMap->addColumn('MAX_QUOTA', 'MaxQuota', 'int', CreoleTypes::INTEGER, false, null); + + $tMap->addColumn('MAX_ADDRESS_COUNT', 'MaxAddressCount', 'int', CreoleTypes::INTEGER, false, null); + + $tMap->addColumn('LAST_LOGIN', 'LastLogin', 'int', CreoleTypes::TIMESTAMP, false, null); + + $tMap->addColumn('ACTIVE', 'Active', 'boolean', CreoleTypes::BOOLEAN, false, null); + + } +} \ No newline at end of file diff --git a/lib/model/map/RoleMapBuilder.php b/lib/model/map/RoleMapBuilder.php new file mode 100644 index 0000000..44aeb93 --- /dev/null +++ b/lib/model/map/RoleMapBuilder.php @@ -0,0 +1,42 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('role'); + $tMap->setPhpName('Role'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addColumn('CREDENTIALS', 'Credentials', 'string', CreoleTypes::VARCHAR, false, 255); + + } +} \ No newline at end of file diff --git a/lib/model/map/UserMapBuilder.php b/lib/model/map/UserMapBuilder.php new file mode 100644 index 0000000..3ee3252 --- /dev/null +++ b/lib/model/map/UserMapBuilder.php @@ -0,0 +1,58 @@ +dbMap !== null); + } + + + public function getDatabaseMap() + { + return $this->dbMap; + } + + + public function doBuild() + { + $this->dbMap = Propel::getDatabaseMap('propel'); + + $tMap = $this->dbMap->addTable('user'); + $tMap->setPhpName('User'); + + $tMap->setUseIdGenerator(true); + + $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null); + + $tMap->addForeignKey('PARENT_USER_ID', 'ParentUserId', 'int', CreoleTypes::INTEGER, 'user', 'ID', false, null); + + $tMap->addColumn('NICKNAME', 'Nickname', 'string', CreoleTypes::VARCHAR, false, 50); + + $tMap->addColumn('FIRST_NAME', 'FirstName', 'string', CreoleTypes::VARCHAR, false, 100); + + $tMap->addColumn('LAST_NAME', 'LastName', 'string', CreoleTypes::VARCHAR, false, 100); + + $tMap->addColumn('EMAIL', 'Email', 'string', CreoleTypes::VARCHAR, false, 255); + + $tMap->addColumn('SHA1_PASSWORD', 'Sha1Password', 'string', CreoleTypes::VARCHAR, false, 40); + + $tMap->addColumn('SALT', 'Salt', 'string', CreoleTypes::VARCHAR, false, 32); + + $tMap->addForeignKey('ROLE_ID', 'RoleId', 'int', CreoleTypes::INTEGER, 'role', 'ID', false, null); + + $tMap->addColumn('LAST_LOGIN', 'LastLogin', 'int', CreoleTypes::TIMESTAMP, false, null); + + $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); + + } +} \ No newline at end of file -- cgit v1.1-32-gdbae