diff options
Diffstat (limited to 'config')
| -rw-r--r-- | config/config.php | 5 | ||||
| -rw-r--r-- | config/databases.yml | 5 | ||||
| -rw-r--r-- | config/generated-schema-transformed.xml | 2 | ||||
| -rw-r--r-- | config/propel.ini | 44 | ||||
| -rw-r--r-- | config/properties.ini | 2 | ||||
| -rw-r--r-- | config/rsync_exclude.txt | 4 | ||||
| -rw-r--r-- | config/schema-transformed.xml | 2 | ||||
| -rw-r--r-- | config/schema.yml | 68 |
8 files changed, 132 insertions, 0 deletions
diff --git a/config/config.php b/config/config.php new file mode 100644 index 0000000..381af2c --- /dev/null +++ b/config/config.php @@ -0,0 +1,5 @@ +<?php + +// symfony directories +$sf_symfony_lib_dir = '/usr/share/php5/PEAR/symfony'; +$sf_symfony_data_dir = '/usr/share/php5/PEAR/data/symfony'; diff --git a/config/databases.yml b/config/databases.yml new file mode 100644 index 0000000..023d652 --- /dev/null +++ b/config/databases.yml @@ -0,0 +1,5 @@ +all: + propel: + class: sfPropelDatabase + param: + dsn: mysql://user:password@localhost/mailadmin diff --git a/config/generated-schema-transformed.xml b/config/generated-schema-transformed.xml new file mode 100644 index 0000000..28b9c86 --- /dev/null +++ b/config/generated-schema-transformed.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="UTF-8"?> +<database defaultPhpNamingMethod="underscore" heavyIndexing="false" name="propel" defaultIdMethod="native" noXsd="true" package="lib.model"><table skipSql="false" abstract="false" name="role" phpName="Role"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="credentials" type="varchar" size="255"/></table><table skipSql="false" abstract="false" name="user" phpName="User"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="parent_user_id" type="integer" default="-1"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="nickname" type="varchar" size="50"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="first_name" type="varchar" size="100"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="last_name" type="varchar" size="100"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="email" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="sha1_password" type="varchar" size="40"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="salt" type="varchar" size="32"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="role_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="last_login" type="timestamp"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="created_at" type="timestamp"/><foreign-key onUpdate="none" foreignTable="user" onDelete="setnull"><reference local="parent_user_id" foreign="id"/></foreign-key><foreign-key onDelete="none" onUpdate="none" foreignTable="role"><reference local="role_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="domain_permission" phpName="DomainPermission"><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="user_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="domain_id" type="integer"/><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><foreign-key onUpdate="none" foreignTable="user" onDelete="cascade"><reference local="user_id" foreign="id"/></foreign-key><foreign-key onUpdate="none" foreignTable="domain" onDelete="cascade"><reference local="domain_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="domain" phpName="Domain"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="creator_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="mailbox_prefix" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="max_mailbox_count" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="quota" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="default_mailbox_quota" type="integer"/><foreign-key onUpdate="none" foreignTable="user" onDelete="setnull"><reference local="creator_id" foreign="id"/></foreign-key><unique name="i2"><unique-column name="name"/></unique></table><table skipSql="false" abstract="false" name="mailbox" phpName="Mailbox"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="domain_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="varchar" size="30"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="password" type="varchar" size="40"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="max_quota" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="max_address_count" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="last_login" type="timestamp"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="active" type="boolean" default="1"/><foreign-key onUpdate="none" foreignTable="domain" onDelete="setnull"><reference local="domain_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="address" phpName="Address"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="mailbox_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="localpart" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="domain_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="alias" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="destination" type="longvarchar"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="active" type="boolean" default="1"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="save_in_mailbox" type="boolean" default="1"/><foreign-key onUpdate="none" foreignTable="mailbox" onDelete="cascade"><reference local="mailbox_id" foreign="id"/></foreign-key><foreign-key onDelete="none" onUpdate="none" foreignTable="domain"><reference local="domain_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="log" phpName="LogEntry"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="user_id" type="integer" default="null"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="created_at" type="timestamp"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="message" type="longvarchar"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="host" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="priority" type="integer"/><foreign-key onUpdate="none" foreignTable="user" onDelete="setnull"><reference local="user_id" foreign="id"/></foreign-key></table></database> diff --git a/config/propel.ini b/config/propel.ini new file mode 100644 index 0000000..92b813f --- /dev/null +++ b/config/propel.ini @@ -0,0 +1,44 @@ +propel.targetPackage = lib.model +propel.packageObjectModel = true +propel.project = mailadmin +propel.database = mysql +propel.database.createUrl = mysql://user:password@localhost/ +propel.database.url = mysql://ruser:password@localhost/mailadmin + +propel.addGenericAccessors = true +propel.addGenericMutators = true +propel.addTimeStamp = false + +propel.schema.validate = false + +; directories +propel.home = . +propel.output.dir = /home/mszulecki/projects/mailadmin +propel.schema.dir = ${propel.output.dir}/config +propel.conf.dir = ${propel.output.dir}/config +propel.phpconf.dir = ${propel.output.dir}/config +propel.sql.dir = ${propel.output.dir}/data/sql +propel.runtime.conf.file = runtime-conf.xml +propel.php.dir = ${propel.output.dir} +propel.default.schema.basename = schema +propel.datadump.mapper.from = *schema.xml +propel.datadump.mapper.to = *data.xml + +; builder settings +propel.builder.peer.class = addon.propel.builder.SfPeerBuilder +propel.builder.object.class = addon.propel.builder.SfObjectBuilder + +propel.builder.objectstub.class = addon.propel.builder.SfExtensionObjectBuilder +propel.builder.peerstub.class = addon.propel.builder.SfExtensionPeerBuilder +propel.builder.objectmultiextend.class = addon.propel.builder.SfMultiExtendObjectBuilder +propel.builder.mapbuilder.class = addon.propel.builder.SfMapBuilderBuilder +propel.builder.interface.class = propel.engine.builder.om.php5.PHP5InterfaceBuilder +propel.builder.node.class = propel.engine.builder.om.php5.PHP5NodeBuilder +propel.builder.nodepeer.class = propel.engine.builder.om.php5.PHP5NodePeerBuilder +propel.builder.nodestub.class = propel.engine.builder.om.php5.PHP5ExtensionNodeBuilder +propel.builder.nodepeerstub.class = propel.engine.builder.om.php5.PHP5ExtensionNodePeerBuilder + +propel.builder.addIncludes = false +propel.builder.addComments = false + +propel.builder.addBehaviors = false diff --git a/config/properties.ini b/config/properties.ini new file mode 100644 index 0000000..be28321 --- /dev/null +++ b/config/properties.ini @@ -0,0 +1,2 @@ +[symfony] + name=mailadmin diff --git a/config/rsync_exclude.txt b/config/rsync_exclude.txt new file mode 100644 index 0000000..4b76ea8 --- /dev/null +++ b/config/rsync_exclude.txt @@ -0,0 +1,4 @@ +.svn +/web/uploads/* +/cache/* +/log/* diff --git a/config/schema-transformed.xml b/config/schema-transformed.xml new file mode 100644 index 0000000..ea51a55 --- /dev/null +++ b/config/schema-transformed.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="UTF-8"?> +<database defaultPhpNamingMethod="underscore" heavyIndexing="false" name="propel" defaultIdMethod="native" noXsd="true" package="lib.model"><table skipSql="false" abstract="false" name="role" phpName="Role"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="varchar" size="255"/></table><table skipSql="false" abstract="false" name="user" phpName="User"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="parent_user_id" type="integer" default="-1"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="nickname" type="varchar" size="50"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="first_name" type="varchar" size="100"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="last_name" type="varchar" size="100"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="email" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="sha1_password" type="varchar" size="40"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="salt" type="varchar" size="32"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="role_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="lastlogin" type="timestamp"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="created_at" type="timestamp"/><foreign-key onDelete="none" onUpdate="none" foreignTable="role"><reference local="role_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="domain" phpName="Domain"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="longvarchar"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="creator_user_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="mailbox_prefix" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="max_mailbox_count" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="quota" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="max_mailbox_quota" type="integer"/><foreign-key onDelete="none" onUpdate="none" foreignTable="user" name="creator"><reference local="creator_user_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="mailbox" phpName="Mailbox"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="domain_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="name" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="password" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="last_login" type="timestamp"/><foreign-key onDelete="none" onUpdate="none" foreignTable="domain"><reference local="domain_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="address" phpName="Address"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="mailbox_id" type="integer"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="alias" type="varchar" size="255"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="destination" type="varchar" size="255"/><foreign-key onDelete="none" onUpdate="none" foreignTable="mailbox"><reference local="mailbox_id" foreign="id"/></foreign-key></table><table skipSql="false" abstract="false" name="log" phpName="LogEntry"><column autoIncrement="false" lazyLoad="false" name="id" type="integer" required="true" primaryKey="true" autoincrement="true"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="created_at" type="timestamp"/><column primaryKey="false" required="false" autoIncrement="false" lazyLoad="false" name="message" type="longvarchar"/></table></database> diff --git a/config/schema.yml b/config/schema.yml new file mode 100644 index 0000000..58f0f72 --- /dev/null +++ b/config/schema.yml @@ -0,0 +1,68 @@ +propel: + role: + _attributes: { phpName: Role } + id: + name: varchar(255) + credentials: varchar(255) + + user: + _attributes: { phpName: User } + id: + parent_user_id: { type: integer, default: -1, foreignTable: user, foreignReference: id, onDelete: setnull } + nickname: varchar(50) + first_name: varchar(100) + last_name: varchar(100) + email: varchar(255) + sha1_password: varchar(40) + salt: varchar(32) + role_id: + last_login: timestamp + created_at: + + domain_permission: + _attributes: { phpName: DomainPermission } + user_id: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade } + domain_id: { type: integer, foreignTable: domain, foreignReference: id, onDelete: cascade } + + domain: + _attributes: { phpName: Domain } + id: + name: varchar(255) + creator_id: { type: integer, foreignTable: user, foreignReference: id, onDelete: setnull } + mailbox_prefix: varchar(255) + max_mailbox_count: integer + quota: integer + default_mailbox_quota: integer + _uniques: + i2: [name] + + mailbox: + _attributes: { phpName: Mailbox } + id: + domain_id: { type: integer, foreignTable: domain, foreignReference: id, onDelete: setnull } + name: varchar(30) + password: varchar(40) + max_quota: integer + max_address_count: integer + last_login: timestamp + active: { type: boolean, default: true } + + address: + _attributes: { phpName: Address } + id: + mailbox_id: { type: integer, foreignTable: mailbox, foreignReference: id, onDelete: cascade } + localpart: varchar(255) + domain_id: + alias: varchar(255) + destination: longvarchar + active: { type: boolean, default: true } + save_in_mailbox: { type: boolean, default: true } + + log: + _attributes: { phpName: LogEntry } + id: + user_id: { type: integer, default: null, foreignTable: user, foreignReference: id, onDelete: setnull } + created_at: + message: longvarchar + host: varchar(255) + priority: integer |