summaryrefslogtreecommitdiffstats
path: root/config
diff options
context:
space:
mode:
Diffstat (limited to 'config')
-rw-r--r--config/config.php5
-rw-r--r--config/databases.yml5
-rw-r--r--config/generated-schema-transformed.xml2
-rw-r--r--config/propel.ini44
-rw-r--r--config/properties.ini2
-rw-r--r--config/rsync_exclude.txt4
-rw-r--r--config/schema-transformed.xml2
-rw-r--r--config/schema.yml68
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