Add new SQL schema

darcs-hash:20080530061218-86b55-d37cce11e09c780eaea7a1b765f578f0b6b55c85.gz

6 files changed, 66 insertions, 0 deletions

diff --git a/sqlobject_history/2008-05-29/AbstractSMTPAccount_sqlite.sql b/sqlobject_history/2008-05-29/AbstractSMTPAccount_sqlite.sql
new file mode 100644
index 0000000..1d5b828
--- /dev/null
+++ b/sqlobject_history/2008-05-29/AbstractSMTPAccount_sqlite.sql
@@ -0,0 +1,9 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.AbstractSMTPAccount
+-- Database: sqlite
+CREATE TABLE abstract_smtp_account (
+    id INTEGER PRIMARY KEY,
+    default_from TEXT,
+    default_account TINYINT,
+    child_name VARCHAR(255)
+)
diff --git a/sqlobject_history/2008-05-29/GlobalSMTPAccount_sqlite.sql b/sqlobject_history/2008-05-29/GlobalSMTPAccount_sqlite.sql
new file mode 100644
index 0000000..62e2a65
--- /dev/null
+++ b/sqlobject_history/2008-05-29/GlobalSMTPAccount_sqlite.sql
@@ -0,0 +1,14 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.GlobalSMTPAccount
+-- Database: sqlite
+CREATE TABLE global_smtp_account (
+    id INTEGER PRIMARY KEY,
+    login TEXT,
+    password TEXT,
+    host TEXT,
+    port INT,
+    tls TINYINT,
+    store_password TINYINT,
+    waiting_password_reply TINYINT,
+    child_name VARCHAR(255)
+)
diff --git a/sqlobject_history/2008-05-29/IMAPAccount_sqlite.sql b/sqlobject_history/2008-05-29/IMAPAccount_sqlite.sql
new file mode 100644
index 0000000..d7eb835
--- /dev/null
+++ b/sqlobject_history/2008-05-29/IMAPAccount_sqlite.sql
@@ -0,0 +1,9 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.IMAPAccount
+-- Database: sqlite
+CREATE TABLE imap_account (
+    id INTEGER PRIMARY KEY,
+    mailbox TEXT,
+    delimiter TEXT,
+    child_name VARCHAR(255)
+)
diff --git a/sqlobject_history/2008-05-29/MailAccount_sqlite.sql b/sqlobject_history/2008-05-29/MailAccount_sqlite.sql
new file mode 100644
index 0000000..df3c222
--- /dev/null
+++ b/sqlobject_history/2008-05-29/MailAccount_sqlite.sql
@@ -0,0 +1,18 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.MailAccount
+-- Database: sqlite
+CREATE TABLE mail_account (
+    id INTEGER PRIMARY KEY,
+    login TEXT,
+    password TEXT,
+    host TEXT,
+    port INT,
+    _ssl TINYINT,
+    _interval INT,
+    store_password TINYINT,
+    live_email_only TINYINT,
+    lastcheck INT,
+    waiting_password_reply TINYINT,
+    first_check TINYINT,
+    child_name VARCHAR(255)
+)
diff --git a/sqlobject_history/2008-05-29/POP3Account_sqlite.sql b/sqlobject_history/2008-05-29/POP3Account_sqlite.sql
new file mode 100644
index 0000000..5555576
--- /dev/null
+++ b/sqlobject_history/2008-05-29/POP3Account_sqlite.sql
@@ -0,0 +1,9 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.POP3Account
+-- Database: sqlite
+CREATE TABLE po_p3_account (
+    id INTEGER PRIMARY KEY,
+    nb_mail INT,
+    lastmail INT,
+    child_name VARCHAR(255)
+)
diff --git a/sqlobject_history/2008-05-29/SMTPAccount_sqlite.sql b/sqlobject_history/2008-05-29/SMTPAccount_sqlite.sql
new file mode 100644
index 0000000..f116a5c
--- /dev/null
+++ b/sqlobject_history/2008-05-29/SMTPAccount_sqlite.sql
@@ -0,0 +1,7 @@
+-- Exported definition from 2008-05-29T19:26:03
+-- Class jmc.model.account.SMTPAccount
+-- Database: sqlite
+CREATE TABLE smtp_account (
+    id INTEGER PRIMARY KEY,
+    child_name VARCHAR(255)
+)