[TEP-COMMIT] [CVS catalog] define new newsletter logging table

Commit in catalog/catalog/install on MAIN

oscommerce.sql +9 1.101 -> 1.102

define new newsletter logging table

----------

catalog /catalog /install

oscommerce.sql 1.101 -> 1.102

diff -u -r1.101 -r1.102
--- oscommerce.sql 2004/08/06 10:59:11 1.101
+++ oscommerce.sql 2004/08/17 23:47:54 1.102
@@ -264,6 +264,15 @@

PRIMARY KEY (newsletters_id)
);

+DROP TABLE IF EXISTS osc_newsletters_log;
+CREATE TABLE osc_newsletters_log (
+ newsletters_id int NOT NULL,
+ email_address varchar(255) NOT NULL,
+ date_sent datetime,
+ KEY IDX_NEWSLETTERS_LOG_NEWSLETTERS_ID (newsletters_id),
+ KEY IDX_NEWSLETTERS_LOG_EMAIL_ADDRESS (email_address)
+);
+

DROP TABLE IF EXISTS osc_orders;
CREATE TABLE osc_orders (
orders_id int NOT NULL auto_increment,

CVSspam 0.2.9

-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285