Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

[8] Fix | Delete

/*!40101 SET NAMES utf8 */;

[9] Fix | Delete

[10] Fix | Delete

[11] Fix | Delete

-- Database: `sentri32`

[12] Fix | Delete

[13] Fix | Delete

[14] Fix | Delete

-- --------------------------------------------------------

[15] Fix | Delete

[16] Fix | Delete

[17] Fix | Delete

-- Table structure for table `assets`

[18] Fix | Delete

[19] Fix | Delete

[20] Fix | Delete

CREATE TABLE `assets` (

[21] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[22] Fix | Delete

`category` int(11) DEFAULT NULL,

[23] Fix | Delete

`sub_category` int(11) DEFAULT NULL,

[24] Fix | Delete

`company_asset_code` int(11) DEFAULT NULL,

[25] Fix | Delete

`name` varchar(50) NOT NULL,

[26] Fix | Delete

`location` varchar(15) NOT NULL,

[27] Fix | Delete

`allocated_to` int(11) DEFAULT NULL,

[28] Fix | Delete

`responsible_technician` int(11) DEFAULT NULL,

[29] Fix | Delete

`vendor` int(11) DEFAULT NULL,

[30] Fix | Delete

`asset_classification` varchar(50) NOT NULL,

[31] Fix | Delete

`purchase_date` date DEFAULT NULL,

[32] Fix | Delete

`invoice_number` varchar(50) DEFAULT NULL,

[33] Fix | Delete

`manufacturer` varchar(50) NOT NULL,

[34] Fix | Delete

`key_number` varchar(11) NOT NULL,

[35] Fix | Delete

`warenty_status` enum('Yes','No') NOT NULL,

[36] Fix | Delete

`warenty_end_date` date DEFAULT NULL,

[37] Fix | Delete

`is_working` enum('No','Yes') NOT NULL,

[38] Fix | Delete

`notes` text,

[39] Fix | Delete

`image` text,

[40] Fix | Delete

`imagencrpname` text NOT NULL,

[41] Fix | Delete

`qr_image` text NOT NULL,

[42] Fix | Delete

`isactive` tinyint(4) DEFAULT NULL,

[43] Fix | Delete

`created_by` int(11) DEFAULT NULL,

[44] Fix | Delete

`modified_by` int(11) DEFAULT NULL,

[45] Fix | Delete

`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[46] Fix | Delete

`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

[47] Fix | Delete

PRIMARY KEY (`id`)

[48] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;

[49] Fix | Delete

[50] Fix | Delete

-- --------------------------------------------------------

[51] Fix | Delete

[52] Fix | Delete

[53] Fix | Delete

-- Table structure for table `assets_categories`

[54] Fix | Delete

[55] Fix | Delete

[56] Fix | Delete

CREATE TABLE `assets_categories` (

[57] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[58] Fix | Delete

`name` varchar(50) CHARACTER SET latin1 NOT NULL,

[59] Fix | Delete

`parent` int(11) DEFAULT NULL,

[60] Fix | Delete

`is_active` tinyint(4) DEFAULT NULL,

[61] Fix | Delete

`created_by` int(11) DEFAULT NULL,

[62] Fix | Delete

`modified_by` varchar(11) DEFAULT NULL,

[63] Fix | Delete

`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[64] Fix | Delete

`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

[65] Fix | Delete

PRIMARY KEY (`id`)

[66] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=198 ;

[67] Fix | Delete

[68] Fix | Delete

-- --------------------------------------------------------

[69] Fix | Delete

[70] Fix | Delete

[71] Fix | Delete

-- Table structure for table `assets_history`

[72] Fix | Delete

[73] Fix | Delete

[74] Fix | Delete

CREATE TABLE `assets_history` (

[75] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[76] Fix | Delete

`asset_id` int(11) DEFAULT NULL,

[77] Fix | Delete

`user_id` int(11) DEFAULT NULL,

[78] Fix | Delete

`history` varchar(500) DEFAULT NULL,

[79] Fix | Delete

`isactive` tinyint(1) DEFAULT NULL,

[80] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[81] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[82] Fix | Delete

`createddate` datetime DEFAULT NULL,

[83] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[84] Fix | Delete

PRIMARY KEY (`id`)

[85] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=233 ;

[86] Fix | Delete

[87] Fix | Delete

-- --------------------------------------------------------

[88] Fix | Delete

[89] Fix | Delete

[90] Fix | Delete

-- Table structure for table `expenses`

[91] Fix | Delete

[92] Fix | Delete

[93] Fix | Delete

CREATE TABLE `expenses` (

[94] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[95] Fix | Delete

`expense_name` varchar(100) DEFAULT NULL,

[96] Fix | Delete

`category_id` int(11) DEFAULT NULL,

[97] Fix | Delete

`project_id` int(11) DEFAULT NULL,

[98] Fix | Delete

`client_id` int(11) DEFAULT NULL,

[99] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[100] Fix | Delete

`manager_id` int(11) DEFAULT NULL,

[101] Fix | Delete

`expense_date` date DEFAULT NULL,

[102] Fix | Delete

`expense_currency_id` int(11) DEFAULT NULL,

[103] Fix | Delete

`expense_amount` float(10,2) DEFAULT NULL,

[104] Fix | Delete

`expense_conversion_rate` float(5,2) DEFAULT NULL,

[105] Fix | Delete

`application_currency_id` int(11) DEFAULT NULL,

[106] Fix | Delete

`application_amount` float(10,2) DEFAULT NULL,

[107] Fix | Delete

`advance_amount` float(10,2) DEFAULT NULL,

[108] Fix | Delete

`is_reimbursable` tinyint(1) DEFAULT NULL,

[109] Fix | Delete

`is_from_advance` tinyint(1) DEFAULT '0',

[110] Fix | Delete

`expense_payment_id` int(11) DEFAULT NULL,

[111] Fix | Delete

`expense_payment_ref_no` varchar(200) DEFAULT NULL,

[112] Fix | Delete

`description` text,

[113] Fix | Delete

`status` enum('saved','submitted','approved','rejected') DEFAULT 'saved',

[114] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[115] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[116] Fix | Delete

`createddate` datetime DEFAULT NULL,

[117] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[118] Fix | Delete

`isactive` tinyint(1) DEFAULT NULL,

[119] Fix | Delete

PRIMARY KEY (`id`)

[120] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[121] Fix | Delete

[122] Fix | Delete

-- --------------------------------------------------------

[123] Fix | Delete

[124] Fix | Delete

[125] Fix | Delete

-- Table structure for table `expense_advacne_summary`

[126] Fix | Delete

[127] Fix | Delete

[128] Fix | Delete

CREATE TABLE `expense_advacne_summary` (

[129] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[130] Fix | Delete

`employee_id` int(11) DEFAULT NULL,

[131] Fix | Delete

`total` float(10,2) DEFAULT NULL,

[132] Fix | Delete

`utilized` float(10,2) DEFAULT NULL,

[133] Fix | Delete

`returned` float(10,2) DEFAULT NULL,

[134] Fix | Delete

`balance` float(10,2) DEFAULT NULL,

[135] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[136] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[137] Fix | Delete

`createddate` datetime DEFAULT NULL,

[138] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[139] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[140] Fix | Delete

PRIMARY KEY (`id`),

[141] Fix | Delete

UNIQUE KEY `UNIQUEEMP` (`employee_id`)

[142] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[143] Fix | Delete

[144] Fix | Delete

-- --------------------------------------------------------

[145] Fix | Delete

[146] Fix | Delete

[147] Fix | Delete

-- Table structure for table `expense_advance`

[148] Fix | Delete

[149] Fix | Delete

[150] Fix | Delete

CREATE TABLE `expense_advance` (

[151] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[152] Fix | Delete

`type` enum('advance','return') DEFAULT 'advance',

[153] Fix | Delete

`from_id` int(11) DEFAULT NULL,

[154] Fix | Delete

`to_id` int(11) DEFAULT NULL,

[155] Fix | Delete

`payment_ref_number` varchar(200) DEFAULT NULL,

[156] Fix | Delete

`payment_mode_id` int(11) DEFAULT NULL,

[157] Fix | Delete

`project_id` int(11) DEFAULT NULL,

[158] Fix | Delete

`currency_id` int(11) DEFAULT NULL,

[159] Fix | Delete

`amount` float(10,2) DEFAULT NULL,

[160] Fix | Delete

`application_currency_id` int(11) DEFAULT NULL,

[161] Fix | Delete

`application_amount` float(10,2) DEFAULT NULL,

[162] Fix | Delete

`advance_conversion_rate` float(10,2) DEFAULT NULL,

[163] Fix | Delete

`description` text,

[164] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[165] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[166] Fix | Delete

`createddate` datetime NOT NULL,

[167] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[168] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[169] Fix | Delete

PRIMARY KEY (`id`)

[170] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[171] Fix | Delete

[172] Fix | Delete

-- --------------------------------------------------------

[173] Fix | Delete

[174] Fix | Delete

[175] Fix | Delete

-- Table structure for table `expense_categories`

[176] Fix | Delete

[177] Fix | Delete

[178] Fix | Delete

CREATE TABLE `expense_categories` (

[179] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[180] Fix | Delete

`expense_category_name` varchar(100) DEFAULT NULL,

[181] Fix | Delete

`unit_price` varchar(50) DEFAULT NULL,

[182] Fix | Delete

`unit_name` varchar(50) DEFAULT NULL,

[183] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[184] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[185] Fix | Delete

`created_date` datetime DEFAULT NULL,

[186] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[187] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[188] Fix | Delete

PRIMARY KEY (`id`)

[189] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[190] Fix | Delete

[191] Fix | Delete

-- --------------------------------------------------------

[192] Fix | Delete

[193] Fix | Delete

[194] Fix | Delete

-- Table structure for table `expense_forward`

[195] Fix | Delete

[196] Fix | Delete

[197] Fix | Delete

CREATE TABLE `expense_forward` (

[198] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[199] Fix | Delete

`expense_id` int(11) DEFAULT NULL,

[200] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[201] Fix | Delete

`from_id` int(11) DEFAULT NULL,

[202] Fix | Delete

`to_id` int(11) DEFAULT NULL,

[203] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[204] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[205] Fix | Delete

`createddate` datetime DEFAULT NULL,

[206] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[207] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[208] Fix | Delete

PRIMARY KEY (`id`)

[209] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[210] Fix | Delete

[211] Fix | Delete

-- --------------------------------------------------------

[212] Fix | Delete

[213] Fix | Delete

[214] Fix | Delete

-- Table structure for table `expense_history`

[215] Fix | Delete

[216] Fix | Delete

[217] Fix | Delete

CREATE TABLE `expense_history` (

[218] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[219] Fix | Delete

`expense_id` int(11) DEFAULT NULL,

[220] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[221] Fix | Delete

`history` varchar(500) DEFAULT NULL,

[222] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[223] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[224] Fix | Delete

`createddate` datetime DEFAULT NULL,

[225] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[226] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[227] Fix | Delete

PRIMARY KEY (`id`)

[228] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[229] Fix | Delete

[230] Fix | Delete

-- --------------------------------------------------------

[231] Fix | Delete

[232] Fix | Delete

[233] Fix | Delete

-- Table structure for table `expense_notifications`

[234] Fix | Delete

[235] Fix | Delete

[236] Fix | Delete

CREATE TABLE `expense_notifications` (

[237] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[238] Fix | Delete

`expense_id` int(11) DEFAULT NULL,

[239] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[240] Fix | Delete

`notification` varchar(500) DEFAULT NULL,

[241] Fix | Delete

`link` varchar(200) DEFAULT NULL,

[242] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[243] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[244] Fix | Delete

`createddate` datetime DEFAULT NULL,

[245] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[246] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[247] Fix | Delete

PRIMARY KEY (`id`)

[248] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[249] Fix | Delete

[250] Fix | Delete

-- --------------------------------------------------------

[251] Fix | Delete

[252] Fix | Delete

[253] Fix | Delete

-- Table structure for table `expense_payment_methods`

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

CREATE TABLE `expense_payment_methods` (

[257] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[258] Fix | Delete

`payment_method_name` varchar(100) DEFAULT NULL,

[259] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[260] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[261] Fix | Delete

`created_date` datetime DEFAULT NULL,

[262] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[263] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[264] Fix | Delete

PRIMARY KEY (`id`)

[265] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[266] Fix | Delete

[267] Fix | Delete

-- --------------------------------------------------------

[268] Fix | Delete

[269] Fix | Delete

[270] Fix | Delete

-- Table structure for table `expense_receipts`

[271] Fix | Delete

[272] Fix | Delete

[273] Fix | Delete

CREATE TABLE `expense_receipts` (

[274] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[275] Fix | Delete

`expense_id` int(11) DEFAULT NULL,

[276] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[277] Fix | Delete

`receipt_name` varchar(100) DEFAULT NULL COMMENT 'orginal file name',

[278] Fix | Delete

`receipt_filename` varchar(100) DEFAULT NULL COMMENT 'auto generated file name',

[279] Fix | Delete

`receipt_file_type` varchar(5) DEFAULT NULL,

[280] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[281] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[282] Fix | Delete

`createddate` datetime DEFAULT NULL,

[283] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[284] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[285] Fix | Delete

PRIMARY KEY (`id`)

[286] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[287] Fix | Delete

[288] Fix | Delete

-- --------------------------------------------------------

[289] Fix | Delete

[290] Fix | Delete

[291] Fix | Delete

-- Table structure for table `expense_return_advance`

[292] Fix | Delete

[293] Fix | Delete

[294] Fix | Delete

CREATE TABLE `expense_return_advance` (

[295] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[296] Fix | Delete

`from_id` int(11) DEFAULT NULL,

[297] Fix | Delete

`to_id` int(11) DEFAULT NULL,

[298] Fix | Delete

`currency_id` int(11) DEFAULT NULL,

[299] Fix | Delete

`returned_amount` float(10,2) DEFAULT NULL,

[300] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[301] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[302] Fix | Delete

`createddate` datetime DEFAULT NULL,

[303] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[304] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[305] Fix | Delete

PRIMARY KEY (`id`)

[306] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[307] Fix | Delete

[308] Fix | Delete

-- --------------------------------------------------------

[309] Fix | Delete

[310] Fix | Delete

[311] Fix | Delete

-- Table structure for table `expense_trips`

[312] Fix | Delete

[313] Fix | Delete

[314] Fix | Delete

CREATE TABLE `expense_trips` (

[315] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[316] Fix | Delete

`manager_id` int(11) DEFAULT NULL,

[317] Fix | Delete

`trip_name` varchar(100) DEFAULT NULL,

[318] Fix | Delete

`from_date` date DEFAULT NULL,

[319] Fix | Delete

`to_date` date DEFAULT NULL,

[320] Fix | Delete

`description` text,

[321] Fix | Delete

`status` enum('NS','S','A','R') DEFAULT 'NS' COMMENT 'NS-Notsubmitted,S-submitted,R-Rejected,A-Approved',

[322] Fix | Delete

`rejected_note` text,

[323] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[324] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[325] Fix | Delete

`createddate` datetime DEFAULT NULL,

[326] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[327] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[328] Fix | Delete

PRIMARY KEY (`id`)

[329] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[330] Fix | Delete

[331] Fix | Delete

-- --------------------------------------------------------

[332] Fix | Delete

[333] Fix | Delete

[334] Fix | Delete

-- Table structure for table `expense_trip_history`

[335] Fix | Delete

[336] Fix | Delete

[337] Fix | Delete

CREATE TABLE `expense_trip_history` (

[338] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[339] Fix | Delete

`trip_id` int(11) DEFAULT NULL,

[340] Fix | Delete

`expense_id` int(11) DEFAULT NULL,

[341] Fix | Delete

`history` varchar(500) DEFAULT NULL,

[342] Fix | Delete

`createdby` int(11) DEFAULT NULL,

[343] Fix | Delete

`modifiedby` int(11) DEFAULT NULL,

[344] Fix | Delete

`createddate` datetime DEFAULT NULL,

[345] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[346] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[347] Fix | Delete

PRIMARY KEY (`id`)

[348] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[349] Fix | Delete

[350] Fix | Delete

-- --------------------------------------------------------

[351] Fix | Delete

[352] Fix | Delete

[353] Fix | Delete

-- Table structure for table `main_accountclasstype`

[354] Fix | Delete

[355] Fix | Delete

[356] Fix | Delete

CREATE TABLE `main_accountclasstype` (

[357] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[358] Fix | Delete

`accountclasstype` varchar(255) DEFAULT NULL,

[359] Fix | Delete

`description` varchar(255) DEFAULT NULL,

[360] Fix | Delete

`createdby` int(11) unsigned DEFAULT NULL,

[361] Fix | Delete

`modifiedby` int(11) unsigned DEFAULT NULL,

[362] Fix | Delete

`createddate` datetime DEFAULT NULL,

[363] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[364] Fix | Delete

`isactive` tinyint(1) unsigned DEFAULT '1',

[365] Fix | Delete

PRIMARY KEY (`id`)

[366] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[367] Fix | Delete

[368] Fix | Delete

-- --------------------------------------------------------

[369] Fix | Delete

[370] Fix | Delete

[371] Fix | Delete

-- Table structure for table `main_allottedleaveslog`

[372] Fix | Delete

[373] Fix | Delete

[374] Fix | Delete

CREATE TABLE `main_allottedleaveslog` (

[375] Fix | Delete

`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,

[376] Fix | Delete

`userid` bigint(11) unsigned DEFAULT NULL,

[377] Fix | Delete

`assignedleaves` int(5) DEFAULT NULL,

[378] Fix | Delete

`totalleaves` int(5) DEFAULT NULL,

[379] Fix | Delete

`year` int(5) DEFAULT NULL,

[380] Fix | Delete

`createdby` bigint(11) unsigned DEFAULT NULL,

[381] Fix | Delete

`modifiedby` bigint(11) unsigned DEFAULT NULL,

[382] Fix | Delete

`createddate` datetime DEFAULT NULL,

[383] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[384] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[385] Fix | Delete

PRIMARY KEY (`id`)

[386] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[387] Fix | Delete

[388] Fix | Delete

-- --------------------------------------------------------

[389] Fix | Delete

[390] Fix | Delete

[391] Fix | Delete

-- Table structure for table `main_announcements`

[392] Fix | Delete

[393] Fix | Delete

[394] Fix | Delete

CREATE TABLE `main_announcements` (

[395] Fix | Delete

`id` bigint(20) NOT NULL AUTO_INCREMENT,

[396] Fix | Delete

`businessunit_id` text,

[397] Fix | Delete

`department_id` text,

[398] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[399] Fix | Delete

`description` text,

[400] Fix | Delete

`attachments` text,

[401] Fix | Delete

`status` tinyint(1) DEFAULT NULL COMMENT '1-Save as draft, 2-Posted',

[402] Fix | Delete

`isactive` tinyint(1) DEFAULT NULL,

[403] Fix | Delete

`createdby` bigint(20) DEFAULT NULL,

[404] Fix | Delete

`createdby_role` bigint(20) DEFAULT NULL,

[405] Fix | Delete

`createdby_group` bigint(20) DEFAULT NULL,

[406] Fix | Delete

`modifiedby` bigint(20) DEFAULT NULL,

[407] Fix | Delete

`modifiedby_role` bigint(20) DEFAULT NULL,

[408] Fix | Delete

`modifiedby_group` bigint(20) DEFAULT NULL,

[409] Fix | Delete

`createddate` datetime DEFAULT NULL,

[410] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[411] Fix | Delete

PRIMARY KEY (`id`)

[412] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[413] Fix | Delete

[414] Fix | Delete

-- --------------------------------------------------------

[415] Fix | Delete

[416] Fix | Delete

[417] Fix | Delete

-- Table structure for table `main_assignmententryreasoncode`

[418] Fix | Delete

[419] Fix | Delete

[420] Fix | Delete

CREATE TABLE `main_assignmententryreasoncode` (

[421] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[422] Fix | Delete

`assignmententryreasoncode` varchar(255) NOT NULL,

[423] Fix | Delete

`description` varchar(255) DEFAULT NULL,

[424] Fix | Delete

`createdby` int(11) unsigned DEFAULT NULL,

[425] Fix | Delete

`modifiedby` int(11) unsigned DEFAULT NULL,

[426] Fix | Delete

`createddate` datetime DEFAULT NULL,

[427] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[428] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[429] Fix | Delete

PRIMARY KEY (`id`)

[430] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[431] Fix | Delete

[432] Fix | Delete

-- --------------------------------------------------------

[433] Fix | Delete

[434] Fix | Delete

[435] Fix | Delete

-- Table structure for table `main_attendancestatuscode`

[436] Fix | Delete

[437] Fix | Delete

[438] Fix | Delete

CREATE TABLE `main_attendancestatuscode` (

[439] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[440] Fix | Delete

`attendancestatuscode` varchar(255) DEFAULT NULL,

[441] Fix | Delete

`description` varchar(255) DEFAULT NULL,

[442] Fix | Delete

`createdby` int(11) unsigned DEFAULT NULL,

[443] Fix | Delete

`modifiedby` int(11) unsigned DEFAULT NULL,

[444] Fix | Delete

`createddate` datetime DEFAULT NULL,

[445] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[446] Fix | Delete

`isactive` tinyint(1) unsigned DEFAULT '1',

[447] Fix | Delete

PRIMARY KEY (`id`)

[448] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[449] Fix | Delete

[450] Fix | Delete

-- --------------------------------------------------------

[451] Fix | Delete

[452] Fix | Delete

[453] Fix | Delete

-- Table structure for table `main_bankaccounttype`

[454] Fix | Delete

[455] Fix | Delete

[456] Fix | Delete

CREATE TABLE `main_bankaccounttype` (

[457] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[458] Fix | Delete

`bankaccounttype` varchar(255) NOT NULL,

[459] Fix | Delete

`description` varchar(255) DEFAULT NULL,

[460] Fix | Delete

`createdby` int(11) unsigned DEFAULT NULL,

[461] Fix | Delete

`modifiedby` int(11) unsigned DEFAULT NULL,

[462] Fix | Delete

`createddate` datetime DEFAULT NULL,

[463] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[464] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[465] Fix | Delete

PRIMARY KEY (`id`)

[466] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[467] Fix | Delete

[468] Fix | Delete

-- --------------------------------------------------------

[469] Fix | Delete

[470] Fix | Delete

[471] Fix | Delete

-- Table structure for table `main_bgagencylist`

[472] Fix | Delete

[473] Fix | Delete

[474] Fix | Delete

CREATE TABLE `main_bgagencylist` (

[475] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[476] Fix | Delete

`user_id` int(11) unsigned DEFAULT NULL,

[477] Fix | Delete

`agencyname` varchar(255) NOT NULL,

[478] Fix | Delete

`primaryphone` varchar(100) NOT NULL,

[479] Fix | Delete

`secondaryphone` varchar(100) DEFAULT NULL,

[480] Fix | Delete

`address` text,

[481] Fix | Delete

`bg_checktype` varchar(255) NOT NULL,

[482] Fix | Delete

`website_url` varchar(255) DEFAULT NULL,

[483] Fix | Delete

`flag` tinyint(1) DEFAULT '1',

[484] Fix | Delete

`createdby` int(11) unsigned DEFAULT NULL,

[485] Fix | Delete

`modifiedby` int(11) unsigned DEFAULT NULL,

[486] Fix | Delete

`createddate` datetime DEFAULT NULL,

[487] Fix | Delete

`modifieddate` datetime DEFAULT NULL,

[488] Fix | Delete

`isactive` tinyint(1) DEFAULT '1',

[489] Fix | Delete

PRIMARY KEY (`id`)

[490] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[491] Fix | Delete

[492] Fix | Delete

[493] Fix | Delete

-- Triggers `main_bgagencylist`

[494] Fix | Delete

[495] Fix | Delete

DROP TRIGGER IF EXISTS `main_agencylist_aft_upd`;

[496] Fix | Delete

DELIMITER //

[497] Fix | Delete

CREATE TRIGGER `main_agencylist_aft_upd` AFTER UPDATE ON `main_bgagencylist`

[498] Fix | Delete

FOR EACH ROW BEGIN

[499] Fix | Delete

12 3 4 5 6 ...28