Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

94 lines (66 sloc) 2.581 kb
<h2>William Jiang From June 07, 2011.</h2>
<ol>
<li>(1) Copy the resources from PAMS2 (version 2 which is a milestone including user permissions).</li>
<li>(2) build Database Schemas: import CIBP (4 tables schemas and data), UFCW (tables schemas and data) to build/integrate new PAMS data schemas.</li>
<li>(3) import CIBP, UFCW codes, aside with original user admin codes.</li>
<li>(4) change/adjust codes structures, directories.</li>
<li>(5) modify UFCW codes, add plan/pension part into PAMS, besides CIBP's health benefits.</li>
</ol>
<ul>
<li>pams_cibp: for cibp inheritance (healthy)</li>
<li>pams_ufcw: for ufcw inheritance (plan, pension)</li>
<li>pams_abc: for sales purpose (both pension and healthy).</li>
</ul>
<div> .ini: text-style general config files. </div>
<div> .inc: php-style config files. </div>
delimiter |
CREATE TRIGGER actions_insert BEFORE INSERT ON `admin_users`
FOR EACH ROW BEGIN
INSERT INTO actions SET action=NEW.title;
END;
|
delimiter ;
------------------------------------------------------------
delimiter |
CREATE TRIGGER AFTER DELETE ON `modules`
FOR EACH ROW BEGIN
DELETE FROM `components_modules` SET action=NEW.title;
END;
|
delimiter ;
------------------------------------------------------------
delimiter |
CREATE TRIGGER AFTER DELETE ON `components`
FOR EACH ROW BEGIN
DELETE FROM `components_modules` SET action=NEW.title;
END;
|
delimiter ;
------------------------------------------------------------
delimiter |
CREATE TRIGGER AFTER DELETE ON `contents`
FOR EACH ROW BEGIN
DELETE FROM `contents_resources` SET action=NEW.title;
END;
|
delimiter ;
------------------------------------------------------------
delimiter |
CREATE TRIGGER AFTER DELETE ON `resources`
FOR EACH ROW BEGIN
DELETE FROM `contents_resources` SET action=NEW.title;
END;
|
delimiter ;
The latest version has been updated to cdat.com/demo. I did the test, they work properly, and still some trivial bugs, display issues, or even structure adjustments.
And the test and applying would be great help for the improvement.
The operation steps:
(1) create sites;
(2) create components;
(3) create modules;
The components are not related to modules; they are both the branches of 'sites'.
(4) Under the modules, create contents;
(5) Under the modules, create resources;
(6) associate 'contents' with 'resources'.
(7) adjust or assign modules/contents/resources whatever the user want.
The resources are not related to contents by default; they are both the branches of 'modules'.
Jump to Line
Something went wrong with that request. Please try again.