-- /www/doc/sql/upgrade-3.3-3.4.sql
--
-- Script to upgrade ACS 3.3 database to ACS 3.4 database
--
-- upgrade-3.3.1-3.4.sql,v 1.1.2.3 2000/10/10 20:22:04 jmileham Exp
---------------------------- BEGIN general-links
-- 2000-07-14 ryanlee@mit.edu
-- add a primary key to the link_kill_pattern table
alter table link_kill_patterns add (pattern_id integer);
create sequence link_kill_pattern_id start with 1;
create or replace procedure fill_link_kill_pattern_id
IS
CURSOR c_id IS
select pattern_id, rowid from link_kill_patterns;
v_lkp_row c_id%ROWTYPE;
BEGIN
FOR v_lkp_row IN c_id LOOP
IF v_lkp_row.pattern_id IS NULL THEN
UPDATE link_kill_patterns
set pattern_id = link_kill_pattern_id.nextval
WHERE ROWID=v_lkp_row.rowid;
END IF;
END LOOP;
END;
/
show errors
BEGIN
fill_link_kill_pattern_id();
END;
/
show errors
alter table link_kill_patterns add constraint lkp_id_pk primary key (pattern_id);
---------------------------- END general-links
---------------------------- BEGIN ecommerce
-- 2000-07-17 ryanlee@mit.edu
-- change the ADP templates to remove $db variable references;
-- this isn't a data model change so much as a reflection of the
-- new db API
update ec_templates
set template = '' || CHR(10) || '<%= $product_name %>' || CHR(10) || '' || CHR(10) || '' || CHR(10) || CHR(10) || '<%= $product_name %>
' || CHR(10) || CHR(10) || '' || CHR(10) || '' || CHR(10) || '' || CHR(10) || ' ' || CHR(10) || ' ' || CHR(10) || ' | <%= [ec_linked_thumbnail_if_it_exists $dirname] %> | ' || CHR(10) || ' ' || CHR(10) || ' <%= $one_line_description %>' || CHR(10) || '
' || CHR(10) || ' <%= [ec_price_line $product_id $user_id $offer_code] %>' || CHR(10) || ' | ' || CHR(10) || ' ' || CHR(10) || ' ' || CHR(10) || ' | ' || CHR(10) || '' || CHR(10) || '<%= [ec_add_to_cart_link $product_id] %>' || CHR(10) || ' | ' || CHR(10) || '
' || CHR(10) || '
' || CHR(10) || CHR(10) || '' || CHR(10) || '<%= $detailed_description %>' || CHR(10) || CHR(10) || '<%= [ec_display_product_purchase_combinations $product_id] %>' || CHR(10) || CHR(10) || '<%= [ec_product_links_if_they_exist $product_id] %>' || CHR(10) || CHR(10) || '<%= [ec_professional_reviews_if_they_exist $product_id] %>' || CHR(10) || CHR(10) || '<%= [ec_customer_comments $product_id $comments_sort_by] %>' || CHR(10) || CHR(10) || '
' || CHR(10) || CHR(10) || '<%= [ec_mailing_list_link_for_a_product $product_id] %>' || CHR(10) || CHR(10) || '<%= [ec_footer] %>' || CHR(10) || '' || CHR(10) || '