
INSERT INTO `TableManager` (`ID`, `TableName`, `Fields`, `VisibleFields`, `VisibleFieldsValues`, `FieldNames`, `LinkedTables`, `ActiveTable`, `SaveTables`, `SaveRules`, `DelRow`) VALUES
(NULL, 'Products', 'ProductID,ProductName,ProductPrice,ProductWeight,ProductShortDesc,ProductLongDesc,ProductThumb,CategoryID,ProductDate,ProductUpdateDate,ProductStock,ProductLive,PurchasePrice,SupplierID,SKU,Tags\n', 'ProductName,ProductPrice,CategoryID,SupplierID,ProductLongDesc,PurchasePrice,SKU,Tags,ProductThumb', 'Text,Text,DynamicText,DynamicText,HTML,Text,Random,Tags,ImagesMulti,Options', 'Product Name,Product Price,Category,Supplier,Description,Stock Level,SKU,Search Tags,Photos', 'CategoryID-Categories@CategoryID>CategoryName(Lose)/SupplierID-Suppliers@SupplierID>SupplierName(Lose)/ImageProducts-ImageProducts@ProductID>ImageID,Def*Images@ImageID>FileLocation(Strict)/ProductOptions-ProductOptions@ProductID>OptionID,OptionStockLevels,OptionPrices*Options@OptionID>OptionID,OptionName*OptionGroups@OptionGroupID>OptionGroupName(Strict)', 'True', 'ProductShortDesc=ProductLongDesc/ProductThumb-Def/ProductDate-YMD/ProductUpdateDate-YMD/ProductLive-1', 'ProductPrice-Required/ProductLongDesc-Required', ''),

(NULL, 'Categories', 'CategoryID,CategoryName,CategoryLevel,Root', 'CategoryName', 'Categories', 'Category Name', 'CategoryID-Categories@CategoryID>CategoryName(Lose)', 'True', '', '', '');


INSERT INTO `AdminPanel` (`ID`, `Name`, `Permission`, `FileName`, `ClassName`, `TableName`, `LinkVar`) VALUES
(NULL, 'Sales Widget', 'False', 'Statistics/Sales.php', 'Widget', '', ''),
(NULL, 'Sales Graph', 'False', 'Statistics/MainGraph.php', 'Graph', '', ''),
(NULL, 'Products', 'True', 'ViewTable.php', 'Table', 'Products', '?ID=Products'),

(NULL, 'Categories', 'True', 'ViewTable.php', 'Table', 'Categories', '?ID=Categories');



INSERT INTO `TableManager` (`ID`, `TableName`, `Fields`, `VisibleFields`, `VisibleFieldsValues`, `FieldNames`, `LinkedTables`, `ActiveTable`, `SaveTables`, `SaveRules`, `DelRow`) VALUES (NULL, 'Accounts', 'AccountID,Email,Password,FirstName,LastName,County,Country,PostCode,ContactNumber,AddressOne,AddressTwo,IP,Active,Reset,RegisterDate,Cart,Profile,AdminLevel,Status,ShowFullName,ShowProfileImage,ShowAvailability,IAN,BN,DOB,DayPlan,WeekPlan,MontyPlan,DayConf,WeekConf,MontyConf,Currency,Balance', 'Email,FirstName,LastName,County,Country,PostCode,ContactNumber,AddressOne,AddressTwo,RegisterDate,IAN,BN,DOB,Currency,Balance', 'Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text', 'Email,First Name, Last Name,County/State,Country,Postcode, Phone Number,Address Line One, Address Line Two, Join Date, IAN, BN, DoB, Currency, Balance', '', 'True', '', '', '')


INSERT INTO `AdminPanel` (`ID`, `Name`, `Permission`, `FileName`, `ClassName`, `TableName`, `LinkVar`) VALUES (NULL, 'Accounts', 'True', 'ViewTable.php', 'Table', 'Accounts', '?ID=Accounts')