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.