#眉標=Open Source Solution #副標=免費好用的開發工具(2) #大標=資料倉儲系統實作(上) #作者=文/徐武駿 ==程式1 =========== /* create users for Pentaho BI and setup their privileges*/ CREATE USER SA@localhost; GRANT ALL ON *.* TO SA@localhost ; CREATE USER PENTAHO_ADMIN@localhost identified by 'PASSWORD'; GRANT ALL ON *.* TO PENTAHO_ADMIN@localhost; CREATE USER PENTAHO_USER@localhost identified by 'PASSWORD'; GRANT SELECT ON dm.* TO PENTAHO_USER@localhost; ================ ==程式2 =========== Alter table customer_w_ter add unique index1 (CUSTOMERNUMBER); Alter table customer_w_ter add Foreign Key (CUSTOMERNUMBER) references customers (CUSTOMERNUMBER) on delete restrict on update restrict; Alter table payments add Foreign Key (CUSTOMERNUMBER) references customers (CUSTOMERNUMBER) on delete restrict on update restrict; Alter table quadrant_actuals add Foreign Key (REGION) references department_managers (REGION) on delete restrict on update restrict; Alter table customer_w_ter add Foreign Key (EMPLOYEENUMBER) references employees (EMPLOYEENUMBER) on delete restrict on update restrict; Alter table orderdetails add Foreign Key (ORDERNUMBER) references orders (ORDERNUMBER) on delete restrict on update restrict; Alter table orderdetails add Foreign Key (PRODUCTCODE) references products (PRODUCTCODE) on delete restrict on update restrict; ================