| This is an ongoing list of *any* changes to *any* DataDict array in a schema_inc in *any* package.
|
|
|
| ||Date|Table|Reason|who
|
| +15-SEP-2009 | bitcommerce | major refactor of order and shopping cart, move to database only carts (no more session junk) | [/spider] |
| +Sql92 UPDATE: |{code source="sql"} |
| +ALTER TABLE com_products RENAME products_price_sorter TO lowest_purchase_price; |
| + |
| +DELETE FROM com_customers_basket_att; |
| +DELETE FROM com_customers_basket; |
| + |
| +ALTER TABLE com_customers_basket RENAME products_id TO products_key; |
| +ALTER TABLE com_customers_basket ADD products_id INT NOT NULL; |
| +ALTER TABLE com_customers_basket ADD CONSTRAINT com_customers_basket_products_ref FOREIGN KEY (products_id) REFERENCES com_products(products_id); |
| +ALTER TABLE com_customers_basket DROP customers_basket_date_added; |
| +ALTER TABLE com_customers_basket ADD date_added TIMESTAMP; |
| +ALTER TABLE com_customers_basket ADD cookie VARCHAR(64); |
| + |
| +ALTER TABLE com_customers_basket_att DROP COLUMN customers_id; |
| +ALTER TABLE com_customers_basket_att DROP COLUMN products_id; |
| +ALTER TABLE com_customers_basket_att ADD customers_basket_id int NOT NULL; |
| +ALTER TABLE com_customers_basket_att ADD CONSTRAINT com_customers_basket_att_ref FOREIGN KEY (customers_basket_id) REFERENCES com_customers_basket(customers_basket_id); |
| + |
| +ALTER TABLE com_customers_basket_att DROP products_options_sort_order; |
| +ALTER TABLE com_customers_basket_att RENAME COLUMN products_options_id TO products_options_key; |
| +ALTER TABLE com_customers_basket_att ADD products_options_id INT NOT NULL; |
| +ALTER TABLE com_customers_basket_att RENAME products_options_value_id TO products_options_values_id; |
| +ALTER TABLE com_customers_basket RENAME customers_basket_quantity TO products_quantity;{/code} |
| +01-AUG-2007 | bitcommerce | trim products_options_html_attributes field name | [/lsces] |
| +Sql92 UPDATE: |{code source="sql"} |
| +ALTER TABLE com_products_options |
| +RENAME products_options_html_attributes TO products_options_html_attrib |
| +{/code} |
| 04-APR-2007 | bitcommerce | add commission payment table | [/spider]
|
| Sql92 UPDATE: |{code source="sql"}
|
| CREATE TABLE com_commissions_payments ( commissions_payment_id SERIAL PRIMARY KEY, payee_user_id INT NOT NULL, payer_user_id INT NOT NULL, period_start_date BIGINT NOT NULL, period_end_date BIGINT NOT NULL, payment_date BIGINT NOT NULL, payment_amount NUMERIC(15,2) NOT NULL, payment_method VARCHAR(250) NOT NULL, payment_reference_number VARCHAR(250) NOT NULL, payment_note TEXT, CONSTRAINT com_commissions_payments_payee_ref FOREIGN KEY (payee_user_id) REFERENCES users_users(user_id), CONSTRAINT com_commissions_payments_payer_ref FOREIGN KEY (payer_user_id) REFERENCES users_users(user_id) );
|