User Tools

Site Tools


start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start [2012/10/24 17:30]
leland791 created
start [2017/10/18 16:56] (current)
daniel [Database schema]
Line 1: Line 1:
-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? - <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 soldOakville ​is often 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 stepThe 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 ​itan 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 conscioushave 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]], ​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 [[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 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 spooldirIt 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'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]] 
start.1351092616.txt.gz · Last modified: 2012/10/24 17:30 by leland791