We are working for update doc for SXIMO 5.1.7

Create Your First Module

Before we create module , you need to create database table . in this example , we whave table with schema bellow .
CREATE TABLE IF NOT EXISTS `employee` (
  `EmployeeId` int(11) NOT NULL,
  `LastName` varchar(20) CHARACTER SET utf8 NOT NULL,
  `FirstName` varchar(20) CHARACTER SET utf8 NOT NULL,
  `ReportsTo` int(11) DEFAULT NULL,
  `BirthDate` date DEFAULT NULL,
  `HireDate` date DEFAULT NULL,
  `Phone` varchar(24) CHARACTER SET utf8 DEFAULT NULL,
  `Email` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `Foto` varchar(100) DEFAULT NULL,
  `Status` enum('0','1') DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

Copy paste code above into your phpmyadmin SQL editor To make sure CRUD have complete functionality such add , edit , delete , table must have Primary Key and Autoincrement , this is  mandatory Now after table are ready . Login to your dashboard and go to
 Control Panel -> Root Access ->Crud Generator



 
As you can see image above . you need to input basic info everytime you create new module .
Module Title - This is head title of menu 
Module Note
- This will be menu sub head title 
Template / module type - Select basic technology for CRUD creation - Ajax grid only available if you install ajax plugins 
Class controller
- Give name for controller , do not use white space or any html tag 
Module Table
- This will be basic table for your module 
SQL
- there are 2 type of SQL . auto creation or writing your own SQL statment  . check image



Once you done , submit form . you will see new module are created on your module lists as dispayed at image bellow



Now to view your first module , go to  view module you will see new beautifull module as shown bellow






Good Job !. you already made your first module with fully functionality CRUDS . In next chapter we will show you how to edito your current module