diff options
| -rw-r--r-- | design/database.sql | 7 | ||||
| -rwxr-xr-x | scripts/forward_emails.php | 5 |
2 files changed, 8 insertions, 4 deletions
diff --git a/design/database.sql b/design/database.sql index 06b607c..475dac2 100644 --- a/design/database.sql +++ b/design/database.sql @@ -26,6 +26,7 @@ CREATE TABLE category ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, shortname VARCHAR(30) NOT NULL, name VARCHAR(30) NOT NULL, + description VARCHAR(255) NOT NULL, PRIMARY KEY(id) ); @@ -93,11 +94,11 @@ CREATE TABLE page ( -- The following creates some sample data INSERT INTO category (name, shortname) VALUES + ('Give', 'give'), + ('Needs', 'needs'), ('Jobs', 'jobs'), ('Housing', 'housing'), - ('Events', 'events'), - ('For Sale','forsale'), - ('Needs', 'needs'); + ('Events', 'events'); INSERT INTO source (name) VALUES ('Foursquare Church'); diff --git a/scripts/forward_emails.php b/scripts/forward_emails.php index bd4846f..d40afac 100755 --- a/scripts/forward_emails.php +++ b/scripts/forward_emails.php @@ -47,10 +47,13 @@ foreach ($splitmsg as $line) { $subject = $header[1]; break; - case 'delivered-to': + case 'x-original-to': $to = $header[1]; break; + case 'delivered-to': + break; + default: $headers .= "$line\n"; } |