diff options
author | David Rousselie <dax@happycoders.org> | 2007-12-04 20:12:50 +0300 |
---|---|---|
committer | David Rousselie <dax@happycoders.org> | 2007-12-04 20:12:50 +0300 |
commit | 1c5d2d073b3c109ecbf0b7016f6f384df11e2fb9 (patch) | |
tree | 70f25cd686fe0842e17bb6234f9ad82a3a7049a6 /sqlobject_history | |
parent | 8aa2ede6ae411d23d13bdc0feaa638afcab35167 (diff) |
Store error as string in account instead of just a boolean (in_error)
darcs-hash:20071204171250-86b55-759d1ea8fe52fb896fa59cddd915a872ef601f7d.gz
Diffstat (limited to 'sqlobject_history')
-rw-r--r-- | sqlobject_history/2007-12-04/Account_sqlite.sql | 14 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/IMAPAccount_sqlite.sql | 9 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/LegacyJID_sqlite.sql | 10 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/MailAccount_sqlite.sql | 18 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/POP3Account_sqlite.sql | 9 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/PresenceAccount_sqlite.sql | 13 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/SMTPAccount_sqlite.sql | 16 | ||||
-rw-r--r-- | sqlobject_history/2007-12-04/User_sqlite.sql | 9 |
8 files changed, 98 insertions, 0 deletions
diff --git a/sqlobject_history/2007-12-04/Account_sqlite.sql b/sqlobject_history/2007-12-04/Account_sqlite.sql new file mode 100644 index 0000000..4f08e86 --- /dev/null +++ b/sqlobject_history/2007-12-04/Account_sqlite.sql @@ -0,0 +1,14 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- Class jcl.model.account.Account +-- Database: sqlite +CREATE TABLE account ( + id INTEGER PRIMARY KEY, + name TEXT, + jid TEXT, + status TEXT, + error TEXT, + enabled TINYINT, + lastlogin TIMESTAMP, + user_id INT CONSTRAINT user_id_exists REFERENCES user(id) , + child_name VARCHAR(255) +) diff --git a/sqlobject_history/2007-12-04/IMAPAccount_sqlite.sql b/sqlobject_history/2007-12-04/IMAPAccount_sqlite.sql new file mode 100644 index 0000000..1dd19d9 --- /dev/null +++ b/sqlobject_history/2007-12-04/IMAPAccount_sqlite.sql @@ -0,0 +1,9 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- 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/2007-12-04/LegacyJID_sqlite.sql b/sqlobject_history/2007-12-04/LegacyJID_sqlite.sql new file mode 100644 index 0000000..7496507 --- /dev/null +++ b/sqlobject_history/2007-12-04/LegacyJID_sqlite.sql @@ -0,0 +1,10 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- Class jcl.model.account.LegacyJID +-- Database: sqlite +CREATE TABLE legacy_j_id ( + id INTEGER PRIMARY KEY, + legacy_address TEXT, + jid TEXT, + account_id INT CONSTRAINT account_id_exists REFERENCES account(id) , + child_name VARCHAR(255) +) diff --git a/sqlobject_history/2007-12-04/MailAccount_sqlite.sql b/sqlobject_history/2007-12-04/MailAccount_sqlite.sql new file mode 100644 index 0000000..976a190 --- /dev/null +++ b/sqlobject_history/2007-12-04/MailAccount_sqlite.sql @@ -0,0 +1,18 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- 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/2007-12-04/POP3Account_sqlite.sql b/sqlobject_history/2007-12-04/POP3Account_sqlite.sql new file mode 100644 index 0000000..4585746 --- /dev/null +++ b/sqlobject_history/2007-12-04/POP3Account_sqlite.sql @@ -0,0 +1,9 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- 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/2007-12-04/PresenceAccount_sqlite.sql b/sqlobject_history/2007-12-04/PresenceAccount_sqlite.sql new file mode 100644 index 0000000..10e1f4a --- /dev/null +++ b/sqlobject_history/2007-12-04/PresenceAccount_sqlite.sql @@ -0,0 +1,13 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- Class jcl.model.account.PresenceAccount +-- Database: sqlite +CREATE TABLE presence_account ( + id INTEGER PRIMARY KEY, + chat_action INT, + online_action INT, + away_action INT, + xa_action INT, + dnd_action INT, + offline_action INT, + child_name VARCHAR(255) +) diff --git a/sqlobject_history/2007-12-04/SMTPAccount_sqlite.sql b/sqlobject_history/2007-12-04/SMTPAccount_sqlite.sql new file mode 100644 index 0000000..fe78d15 --- /dev/null +++ b/sqlobject_history/2007-12-04/SMTPAccount_sqlite.sql @@ -0,0 +1,16 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- Class jmc.model.account.SMTPAccount +-- Database: sqlite +CREATE TABLE smtp_account ( + id INTEGER PRIMARY KEY, + login TEXT, + password TEXT, + host TEXT, + port INT, + tls TINYINT, + store_password TINYINT, + waiting_password_reply TINYINT, + default_from TEXT, + default_account TINYINT, + child_name VARCHAR(255) +) diff --git a/sqlobject_history/2007-12-04/User_sqlite.sql b/sqlobject_history/2007-12-04/User_sqlite.sql new file mode 100644 index 0000000..8721cdd --- /dev/null +++ b/sqlobject_history/2007-12-04/User_sqlite.sql @@ -0,0 +1,9 @@ +-- Exported definition from 2007-12-04T17:57:39 +-- Class jcl.model.account.User +-- Database: sqlite +CREATE TABLE user ( + id INTEGER PRIMARY KEY, + jid TEXT, + has_received_motd TINYINT, + child_name VARCHAR(255) +) |