| Server IP : 138.197.176.125 / Your IP : 216.73.217.55 Web Server : Apache/2.4.41 (Ubuntu) System : Linux SuiteCRM-8 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.3.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/soltelcocrm/modules/Assets/ |
Upload File : |
<?xml version='1.0'?> <schema> <tables> <table> <name>vtiger_assets</name> <sql><![CDATA[CREATE TABLE `vtiger_assets` ( `assetsid` int(11) NOT NULL, `asset_no` varchar(30) NOT NULL, `account` int(19), `product` int(19) NOT NULL, `serialnumber` varchar(200), `datesold` date, `dateinservice` date, `assetstatus` varchar(200) default 'In Service', `tagnumber` varchar(300) default NULL, `invoiceid` int(19) default NULL, `shippingmethod` varchar(200) default NULL, `shippingtrackingnumber` varchar(200) default NULL, `assetname` varchar(100) default NULL, PRIMARY KEY (`assetsid`), CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ]]></sql> </table> <table> <name>vtiger_assetscf</name> <sql><![CDATA[CREATE TABLE `vtiger_assetscf` ( `assetsid` int(19) NOT NULL, PRIMARY KEY (`assetsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ]]></sql> </table> </tables> </schema>