Location: PHPKode > projects > eCanteen > ecanteen/documentation/ecanteen-config.txt
eCanteen Setup

To set up the tables, use the sql file "ecanteen-tables-views.sql". Open phpAdmin or an MySQL session and run the sql file. This will create the tables for eCanteen.

The Tables are:

 active_guests : for tracking active guests.
 active_users : for tracking active users.
 banned_users : for tracking banned users - not implemented in eCanteen.
 break: the meal breaks per pay.
 class: the class/delivery point for the orders.
 customersandorders: tracks minor cusotmer orders and menu items.
 itemtype: categories of menu items.
 majorcustomer: the accounts that order for minor accounts.
 majorcustomerextract: a view used in minorcustomer to identify majorcustomers. The parameter DEFINER=`root`@`localhost` should have 
 the proper credentials for you MySQL database.
 menuitem: an individual menu item.
 minorcustomer: the accounts managed by the majorcustomer.
 siteid: site detials table.
 specialdate: dates and range of dates of consequence to the operation of the eCanteen.
 transactions: the collated order of the items in customerandorders.
 supervisor: the supervisor account is stored here to setup sites on the system.

After running the first script, the second script "ecanteen-config.sql" has to be run. This sets the database user the scripts use to access the tables. 

The "ecanteen-config.sql" can be configured to reflect local circumstances. The default servername is "localhost" and the db user is 'canteene'@'localhost' with the password 'can5pass'.

Whatever changes made must be included in the include/constants.php file in the DB variables section.

define("DB_SERVER", "localhost");
define("DB_USER", "canteene");
define("DB_PASS", "can5pass");
define("DB_NAME", "ecanteen");

The link to access a live eCanteen site is "http://<servername>/index.php?site=1".

Other sites can be added to the same database and accessed by changing the site parameter. Sites are added with the supervisor page. Refer to the SiteSupervisorGuide pdf for details.

Return current item: eCanteen