| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| start [2012/10/24 15:30] – created leland791 | start [2017/10/18 14:56] (current) – [Database schema] daniel |
|---|
| When [[http://www.debracurran.ca/">Oakville Real Estate Services</a> Debra Curran is asked how the market place is carrying out certainly one of her initially responses is “which market? - <a href="http://www.debracurran.ca/MLS_Listings/page_1774094.html">Homes For Sale Oakville</a> or someplace else inside the GTA? The reality is Oakville real estate listings and sales have already been powerful for the previous couple of years and as certainly one of the best person Oakville genuine estate agents for Royal LePage, Debra has had among her busiest and most profitable years selling Oakville Real estate listings. Curran points out that in spite of her very best intentions to hold an open house, usually times there is not even an opportunity to hold <a href="http://www.debracurran.ca/Open_Houses/page_2295008.html|Open Houses In Oakville]] ahead of the houses are sold. Oakville is often a wonderful community and folks usually do their study when figuring out whether or not they desire to move right here. <br />“Honestly” says, Curran, “as an Oakville real estate agent, among the ideal pieces of advice I can offer someone searching a residence in Oakville will be to make a point of establishing a partnership with an agent, get your self set up to get the most recent listings - for instance, I place my clients on an automatic emailer to ensure that the moment something comes in the marketplace they are aware of it. That may be a critical 1st step. The following one particular is usually to be ready to move speedily. In a fast marketplace buyers do not possess the luxury of purchasing week right after week at Oakville open houses - even though it’s an excellent solution to turn out to be familiar with an area - but as soon as you understand where you wish to be that is the time to become on major of it, effectively ahead of an open house that may well happen pretty much a complete week right after the property has been put available. Just think of how much worthwhile time was wasted when when you have that important relationship you will be already conscious, have probably noticed the property had two visits before the open house. It’s pretty vital to understand that shopping for a residence is usually a very precise and personal choice; occasionally it could possibly take weeks or maybe months, before the proper dwelling comes along. <br /> | ====== Manitou-Mail Wiki ====== |
| | Welcome to the Wiki for [[http://www.manitou-mail.org|Manitou-Mail]], a database-driven mail user agent. |
| | |
| | ===== manitou-mdx ===== |
| | manitou-mdx is a Perl program that is responsible for importing incoming mail into the database, and exporting outgoing mail to a [[http://en.wikipedia.org/wiki/Mail_transfer_agent|Mail Transfert Agent]]. MDX stands for **M**ail **D**atabase e**X**changer. It generally runs as a daemon (a permanent process in background) although it can also be invoked as a normal command to import existing mailboxes.\\ |
| | Its functionalities can be vastly extended by user-contributed plugins written in the Perl language.\\ |
| | |
| | The main documentation for manitou-mdx is part of the [[http://www.manitou-mail.org/doc/|Manitou-Mail's manual]]. |
| | |
| | Additional information is available on this wiki: |
| | * [[mdx_debian_package|Debian package]] How to create a debian package from scratch for manitou-mdx. |
| | * [[mdx_filters|Filters]] On the use of server-side mail filters. |
| | * [[mdx_word_extractors|Word extractors]] External scripts that extract text from attachments for the full-text indexer. |
| | |
| | The [[mdx_plugins|Plugins page]] provides documentation and sample plugins. |
| | |
| | manitou-mdx can be monitored with [[mdx_nagios_plugin|Nagios]] |
| | |
| | ===== manitou-spool ===== |
| | manitou-spool is a very simple shell maildrop script that copies its standard input into a separate file with a unique name in a spooldir. It is meant to be called by programs such as fetchmail or an stmp server through an entry in the /etc/aliases file. |
| | [[spool_tips|Tips about the spool directory]] |
| | |
| | |
| | ===== Database schema ===== |
| | The current version of an installed Manitou-Mail database can be queried in SQL by: |
| | <code sql> |
| | SELECT rt_value FROM runtime_info WHERE rt_key='schema_version' |
| | </code> |
| | |
| | A visual representation of the schema can be seen on [[http://www.manitou-mail.org/screenshots/db-diagram.png|this diagram]] |
| | |
| | [[access_rights|Access rights]] Scripts to grant access rights for multi-user installations. For the latest version. |
| | |
| | ==== Version 1.0.0 and above ==== |
| | [[schema_1_0_0_upgrade|Upgrade script]] To upgrade the db schema from 0.9.12 |
| | |
| | Starting from 1.0, it's also possible to perform a schema upgrade to the latest version by this shell command: |
| | <code>$ manitou-mgr --upgrade-schema</code> |
| | "Latest" here means the latest known to the manitou-mgr command. |
| | |
| | |
| | |
| | ===== User Interface ===== |
| | [[nsis_script|NSIS script for Windows]] The script that is used to create Manitou-Installer.exe |
| | |
| | [[http://www.manitou-mail.org/showsource.php|Source code]] The C++ source code can be read online (one HTML page per file) |
| | |
| | ===== SQL tips and queries ===== |
| | [[sample_user_queries|Sample user queries (easy)]], with the Quick Selection panel in the user interface \\ |
| | [[adv_sample_user_queries_plus|Sample user queries (advanced)]] \\ |
| | [[sql_analysis|Queries for analysis]] \\ |
| | [[sql_analysis_dedup_attachments|Analyzing the attachments deduplication]] \\ |
| | [[inverted_word_index|Querying the full text search index]] \\ |
| | [[support_functions|Support functions]] \\ |
| | [[sql_basic_stats|Basic statistics]] |
