jaromail

a commandline tool to easily and privately handle your e-mail
git clone git://parazyd.org/jaromail.git
Log | Files | Refs | Submodules | README

db-schemas.txt (3012B)

      1 
      2 users:
      3 +-------------+------------------+------+-----+---------------------+----------------+
      4 | Field       | Type             | Null | Key | Default             | Extra          |
      5 +-------------+------------------+------+-----+---------------------+----------------+
      6 | user_id     | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
      7 | username    | varchar(128)     | NO   | MUL | NULL                |                |
      8 | mail_host   | varchar(128)     | NO   |     | NULL                |                |
      9 | created     | datetime         | NO   |     | 1000-01-01 00:00:00 |                |
     10 | last_login  | datetime         | YES  |     | NULL                |                |
     11 | language    | varchar(5)       | YES  |     | NULL                |                |
     12 | preferences | longtext         | YES  |     | NULL                |                |
     13 +-------------+------------------+------+-----+---------------------+----------------+
     14 
     15 mysql> describe contacts;
     16 +------------+------------------+------+-----+---------------------+----------------+
     17 | Field      | Type             | Null | Key | Default             | Extra          |
     18 +------------+------------------+------+-----+---------------------+----------------+
     19 | contact_id | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
     20 | changed    | datetime         | NO   |     | 1000-01-01 00:00:00 |                |
     21 | del        | tinyint(1)       | NO   |     | 0                   |                |
     22 | name       | varchar(128)     | NO   |     |                     |                |
     23 | email      | text             | NO   |     | NULL                |                |
     24 | firstname  | varchar(128)     | NO   |     |                     |                |
     25 | surname    | varchar(128)     | NO   |     |                     |                |
     26 | vcard      | longtext         | YES  |     | NULL                |                |
     27 | words      | text             | YES  |     | NULL                |                |
     28 | user_id    | int(10) unsigned | NO   | MUL | NULL                |                |
     29 +------------+------------------+------+-----+---------------------+----------------+
     30 
     31 TODO: support also automatic_addressbook plugin which creates a new table:
     32 
     33 CREATE TABLE `collected_contacts` (
     34  `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
     35  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
     36  `del` tinyint(1) NOT NULL DEFAULT '0',
     37  `name` varchar(128) NOT NULL DEFAULT '',
     38  `email` text NOT NULL,
     39  `firstname` varchar(128) NOT NULL DEFAULT '',
     40  `surname` varchar(128) NOT NULL DEFAULT '',
     41  `vcard` longtext NULL,
     42  `words` text NULL,
     43  `user_id` int(10) UNSIGNED NOT NULL,
     44  PRIMARY KEY(`contact_id`),
     45  CONSTRAINT `user_id_fk_collected_contacts` FOREIGN KEY (`user_id`)
     46    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
     47  INDEX `user_collected_contacts_index` (`user_id`,`del`)
     48 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;