Initial import.

git-svn-id: http://svn.sukimashita.com/repos/mailadmin/trunk@2 4281df72-ff29-0410-8fee-2d9ac0c5f5a7

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