Initial import.

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

1 files changed, 68 insertions, 0 deletions

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