8000 SQL schema/structure · Issue #1 · dud3/MailTree · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
SQL schema/structure #1
Open
Open
@dud3

Description

@dud3

Description

Create a database called e_fwd.

Schema

Really simple schema(at least for now).
Basically Every email in email_address_list contains keyword(s), if the keywords match from the incoming email(such as from the gmail account), then store into the mails table, and from there to the email_address that they belong to.
e_fwd_db_scheme

Tables

CREATE TABLE IF NOT EXISTS `email_address_list`;
CREATE TABLE IF NOT EXISTS `mails`;
CREATE TABLE IF NOT EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `keywords_list;`
CREATE TABLE IF NOT EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `throttle`;
CREATE TABLE IF NOT EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users_groups`; 

References

63217ed

Metadata

Metadata

Assignees

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0