Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../front
• File: front.sql
[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
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `front2418`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `0_areas`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `0_areas` (
[20] Fix | Delete
`area_code` int(11) NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[22] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[23] Fix | Delete
PRIMARY KEY (`area_code`),
[24] Fix | Delete
UNIQUE KEY `description` (`description`)
[25] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
[26] Fix | Delete
[27] Fix | Delete
--
[28] Fix | Delete
-- Dumping data for table `0_areas`
[29] Fix | Delete
--
[30] Fix | Delete
[31] Fix | Delete
INSERT INTO `0_areas` VALUES
[32] Fix | Delete
(1, 'Global', 0);
[33] Fix | Delete
[34] Fix | Delete
-- --------------------------------------------------------
[35] Fix | Delete
[36] Fix | Delete
--
[37] Fix | Delete
-- Table structure for table `0_attachments`
[38] Fix | Delete
--
[39] Fix | Delete
[40] Fix | Delete
CREATE TABLE `0_attachments` (
[41] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[42] Fix | Delete
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[43] Fix | Delete
`type_no` int(11) NOT NULL DEFAULT '0',
[44] Fix | Delete
`trans_no` int(11) NOT NULL DEFAULT '0',
[45] Fix | Delete
`unique_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[46] Fix | Delete
`tran_date` date NOT NULL DEFAULT '0000-00-00',
[47] Fix | Delete
`filename` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[48] Fix | Delete
`filesize` int(11) NOT NULL DEFAULT '0',
[49] Fix | Delete
`filetype` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[50] Fix | Delete
PRIMARY KEY (`id`),
[51] Fix | Delete
KEY `type_no` (`type_no`,`trans_no`)
[52] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[53] Fix | Delete
[54] Fix | Delete
-- --------------------------------------------------------
[55] Fix | Delete
[56] Fix | Delete
--
[57] Fix | Delete
-- Table structure for table `0_audit_trail`
[58] Fix | Delete
--
[59] Fix | Delete
[60] Fix | Delete
CREATE TABLE `0_audit_trail` (
[61] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[62] Fix | Delete
`type` smallint(6) unsigned NOT NULL DEFAULT '0',
[63] Fix | Delete
`trans_no` int(11) unsigned NOT NULL DEFAULT '0',
[64] Fix | Delete
`user` smallint(6) unsigned NOT NULL DEFAULT '0',
[65] Fix | Delete
`stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[66] Fix | Delete
`description` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
[67] Fix | Delete
`fiscal_year` int(11) NOT NULL DEFAULT '0',
[68] Fix | Delete
`gl_date` date NOT NULL DEFAULT '0000-00-00',
[69] Fix | Delete
`gl_seq` int(11) unsigned DEFAULT NULL,
[70] Fix | Delete
PRIMARY KEY (`id`),
[71] Fix | Delete
KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`),
[72] Fix | Delete
KEY `Type_and_Number` (`type`,`trans_no`)
[73] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[74] Fix | Delete
[75] Fix | Delete
-- --------------------------------------------------------
[76] Fix | Delete
[77] Fix | Delete
--
[78] Fix | Delete
-- Table structure for table `0_bank_accounts`
[79] Fix | Delete
--
[80] Fix | Delete
[81] Fix | Delete
CREATE TABLE `0_bank_accounts` (
[82] Fix | Delete
`account_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[83] Fix | Delete
`account_type` smallint(6) NOT NULL DEFAULT '0',
[84] Fix | Delete
`bank_account_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[85] Fix | Delete
`bank_account_number` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[86] Fix | Delete
`bank_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[87] Fix | Delete
`bank_address` tinytext COLLATE utf8_unicode_ci,
[88] Fix | Delete
`bank_curr_code` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[89] Fix | Delete
`dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
[90] Fix | Delete
`id` smallint(6) NOT NULL AUTO_INCREMENT,
[91] Fix | Delete
`bank_charge_act` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[92] Fix | Delete
`last_reconciled_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
[93] Fix | Delete
`ending_reconcile_balance` double NOT NULL DEFAULT '0',
[94] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[95] Fix | Delete
PRIMARY KEY (`id`),
[96] Fix | Delete
KEY `bank_account_name` (`bank_account_name`),
[97] Fix | Delete
KEY `bank_account_number` (`bank_account_number`),
[98] Fix | Delete
KEY `account_code` (`account_code`)
[99] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
[100] Fix | Delete
[101] Fix | Delete
--
[102] Fix | Delete
-- Dumping data for table `0_bank_accounts`
[103] Fix | Delete
--
[104] Fix | Delete
[105] Fix | Delete
INSERT INTO `0_bank_accounts` VALUES
[106] Fix | Delete
('1060', 0, 'Current account', 'N/A', 'N/A', NULL, 'USD', 1, 1, '5690', '0000-00-00 00:00:00', 0, 0),
[107] Fix | Delete
('1065', 3, 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', 0, 2, '5690', '0000-00-00 00:00:00', 0, 0);
[108] Fix | Delete
[109] Fix | Delete
-- --------------------------------------------------------
[110] Fix | Delete
[111] Fix | Delete
--
[112] Fix | Delete
-- Table structure for table `0_bank_trans`
[113] Fix | Delete
--
[114] Fix | Delete
[115] Fix | Delete
CREATE TABLE `0_bank_trans` (
[116] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[117] Fix | Delete
`type` smallint(6) DEFAULT NULL,
[118] Fix | Delete
`trans_no` int(11) DEFAULT NULL,
[119] Fix | Delete
`bank_act` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[120] Fix | Delete
`ref` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
[121] Fix | Delete
`trans_date` date NOT NULL DEFAULT '0000-00-00',
[122] Fix | Delete
`amount` double DEFAULT NULL,
[123] Fix | Delete
`dimension_id` int(11) NOT NULL DEFAULT '0',
[124] Fix | Delete
`dimension2_id` int(11) NOT NULL DEFAULT '0',
[125] Fix | Delete
`person_type_id` int(11) NOT NULL DEFAULT '0',
[126] Fix | Delete
`person_id` tinyblob,
[127] Fix | Delete
`reconciled` date DEFAULT NULL,
[128] Fix | Delete
PRIMARY KEY (`id`),
[129] Fix | Delete
KEY `bank_act` (`bank_act`,`ref`),
[130] Fix | Delete
KEY `type` (`type`,`trans_no`),
[131] Fix | Delete
KEY `bank_act_2` (`bank_act`,`reconciled`),
[132] Fix | Delete
KEY `bank_act_3` (`bank_act`,`trans_date`)
[133] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[134] Fix | Delete
[135] Fix | Delete
-- --------------------------------------------------------
[136] Fix | Delete
[137] Fix | Delete
--
[138] Fix | Delete
-- Table structure for table `0_bom`
[139] Fix | Delete
--
[140] Fix | Delete
[141] Fix | Delete
CREATE TABLE `0_bom` (
[142] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[143] Fix | Delete
`parent` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[144] Fix | Delete
`component` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[145] Fix | Delete
`workcentre_added` int(11) NOT NULL DEFAULT '0',
[146] Fix | Delete
`loc_code` char(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[147] Fix | Delete
`quantity` double NOT NULL DEFAULT '1',
[148] Fix | Delete
PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
[149] Fix | Delete
KEY `component` (`component`),
[150] Fix | Delete
KEY `id` (`id`),
[151] Fix | Delete
KEY `loc_code` (`loc_code`),
[152] Fix | Delete
KEY `parent` (`parent`,`loc_code`),
[153] Fix | Delete
KEY `workcentre_added` (`workcentre_added`)
[154] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[155] Fix | Delete
[156] Fix | Delete
-- --------------------------------------------------------
[157] Fix | Delete
[158] Fix | Delete
--
[159] Fix | Delete
-- Table structure for table `0_budget_trans`
[160] Fix | Delete
--
[161] Fix | Delete
[162] Fix | Delete
CREATE TABLE `0_budget_trans` (
[163] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[164] Fix | Delete
`tran_date` date NOT NULL DEFAULT '0000-00-00',
[165] Fix | Delete
`account` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[166] Fix | Delete
`memo_` tinytext COLLATE utf8_unicode_ci NOT NULL,
[167] Fix | Delete
`amount` double NOT NULL DEFAULT '0',
[168] Fix | Delete
`dimension_id` int(11) DEFAULT '0',
[169] Fix | Delete
`dimension2_id` int(11) DEFAULT '0',
[170] Fix | Delete
PRIMARY KEY (`id`),
[171] Fix | Delete
KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
[172] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[173] Fix | Delete
[174] Fix | Delete
-- --------------------------------------------------------
[175] Fix | Delete
[176] Fix | Delete
--
[177] Fix | Delete
-- Table structure for table `0_chart_class`
[178] Fix | Delete
--
[179] Fix | Delete
[180] Fix | Delete
CREATE TABLE `0_chart_class` (
[181] Fix | Delete
`cid` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
[182] Fix | Delete
`class_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[183] Fix | Delete
`ctype` tinyint(1) NOT NULL DEFAULT '0',
[184] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[185] Fix | Delete
PRIMARY KEY (`cid`)
[186] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[187] Fix | Delete
[188] Fix | Delete
--
[189] Fix | Delete
-- Dumping data for table `0_chart_class`
[190] Fix | Delete
--
[191] Fix | Delete
[192] Fix | Delete
INSERT INTO `0_chart_class` VALUES
[193] Fix | Delete
('1', 'Assets', 1, 0),
[194] Fix | Delete
('2', 'Liabilities', 2, 0),
[195] Fix | Delete
('3', 'Income', 4, 0),
[196] Fix | Delete
('4', 'Costs', 6, 0);
[197] Fix | Delete
[198] Fix | Delete
-- --------------------------------------------------------
[199] Fix | Delete
[200] Fix | Delete
--
[201] Fix | Delete
-- Table structure for table `0_chart_master`
[202] Fix | Delete
--
[203] Fix | Delete
[204] Fix | Delete
CREATE TABLE `0_chart_master` (
[205] Fix | Delete
`account_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[206] Fix | Delete
`account_code2` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[207] Fix | Delete
`account_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[208] Fix | Delete
`account_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
[209] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[210] Fix | Delete
PRIMARY KEY (`account_code`),
[211] Fix | Delete
KEY `account_name` (`account_name`),
[212] Fix | Delete
KEY `accounts_by_type` (`account_type`,`account_code`)
[213] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[214] Fix | Delete
[215] Fix | Delete
--
[216] Fix | Delete
-- Dumping data for table `0_chart_master`
[217] Fix | Delete
--
[218] Fix | Delete
[219] Fix | Delete
INSERT INTO `0_chart_master` VALUES
[220] Fix | Delete
('1060', '', 'Checking Account', '1', 0),
[221] Fix | Delete
('1065', '', 'Petty Cash', '1', 0),
[222] Fix | Delete
('1200', '', 'Accounts Receivables', '1', 0),
[223] Fix | Delete
('1205', '', 'Allowance for doubtful accounts', '1', 0),
[224] Fix | Delete
('1510', '', 'Inventory', '2', 0),
[225] Fix | Delete
('1520', '', 'Stocks of Raw Materials', '2', 0),
[226] Fix | Delete
('1530', '', 'Stocks of Work In Progress', '2', 0),
[227] Fix | Delete
('1540', '', 'Stocks of Finished Goods', '2', 0),
[228] Fix | Delete
('1550', '', 'Goods Received Clearing account', '2', 0),
[229] Fix | Delete
('1820', '', 'Office Furniture & Equipment', '3', 0),
[230] Fix | Delete
('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', 0),
[231] Fix | Delete
('1840', '', 'Vehicle', '3', 0),
[232] Fix | Delete
('1845', '', 'Accum. Amort. -Vehicle', '3', 0),
[233] Fix | Delete
('2100', '', 'Accounts Payable', '4', 0),
[234] Fix | Delete
('2105', '', 'Deferred Income', '4', 0),
[235] Fix | Delete
('2110', '', 'Accrued Income Tax - Federal', '4', 0),
[236] Fix | Delete
('2120', '', 'Accrued Income Tax - State', '4', 0),
[237] Fix | Delete
('2130', '', 'Accrued Franchise Tax', '4', 0),
[238] Fix | Delete
('2140', '', 'Accrued Real & Personal Prop Tax', '4', 0),
[239] Fix | Delete
('2150', '', 'Sales Tax', '4', 0),
[240] Fix | Delete
('2160', '', 'Accrued Use Tax Payable', '4', 0),
[241] Fix | Delete
('2210', '', 'Accrued Wages', '4', 0),
[242] Fix | Delete
('2220', '', 'Accrued Comp Time', '4', 0),
[243] Fix | Delete
('2230', '', 'Accrued Holiday Pay', '4', 0),
[244] Fix | Delete
('2240', '', 'Accrued Vacation Pay', '4', 0),
[245] Fix | Delete
('2310', '', 'Accr. Benefits - 401K', '4', 0),
[246] Fix | Delete
('2320', '', 'Accr. Benefits - Stock Purchase', '4', 0),
[247] Fix | Delete
('2330', '', 'Accr. Benefits - Med, Den', '4', 0),
[248] Fix | Delete
('2340', '', 'Accr. Benefits - Payroll Taxes', '4', 0),
[249] Fix | Delete
('2350', '', 'Accr. Benefits - Credit Union', '4', 0),
[250] Fix | Delete
('2360', '', 'Accr. Benefits - Savings Bond', '4', 0),
[251] Fix | Delete
('2370', '', 'Accr. Benefits - Garnish', '4', 0),
[252] Fix | Delete
('2380', '', 'Accr. Benefits - Charity Cont.', '4', 0),
[253] Fix | Delete
('2620', '', 'Bank Loans', '5', 0),
[254] Fix | Delete
('2680', '', 'Loans from Shareholders', '5', 0),
[255] Fix | Delete
('3350', '', 'Common Shares', '6', 0),
[256] Fix | Delete
('3590', '', 'Retained Earnings - prior years', '7', 0),
[257] Fix | Delete
('4010', '', 'Sales', '8', 0),
[258] Fix | Delete
('4430', '', 'Shipping & Handling', '9', 0),
[259] Fix | Delete
('4440', '', 'Interest', '9', 0),
[260] Fix | Delete
('4450', '', 'Foreign Exchange Gain', '9', 0),
[261] Fix | Delete
('4500', '', 'Prompt Payment Discounts', '9', 0),
[262] Fix | Delete
('4510', '', 'Discounts Given', '9', 0),
[263] Fix | Delete
('5010', '', 'Cost of Goods Sold - Retail', '10', 0),
[264] Fix | Delete
('5020', '', 'Material Usage Varaiance', '10', 0),
[265] Fix | Delete
('5030', '', 'Consumable Materials', '10', 0),
[266] Fix | Delete
('5040', '', 'Purchase price Variance', '10', 0),
[267] Fix | Delete
('5050', '', 'Purchases of materials', '10', 0),
[268] Fix | Delete
('5060', '', 'Discounts Received', '10', 0),
[269] Fix | Delete
('5100', '', 'Freight', '10', 0),
[270] Fix | Delete
('5410', '', 'Wages & Salaries', '11', 0),
[271] Fix | Delete
('5420', '', 'Wages - Overtime', '11', 0),
[272] Fix | Delete
('5430', '', 'Benefits - Comp Time', '11', 0),
[273] Fix | Delete
('5440', '', 'Benefits - Payroll Taxes', '11', 0),
[274] Fix | Delete
('5450', '', 'Benefits - Workers Comp', '11', 0),
[275] Fix | Delete
('5460', '', 'Benefits - Pension', '11', 0),
[276] Fix | Delete
('5470', '', 'Benefits - General Benefits', '11', 0),
[277] Fix | Delete
('5510', '', 'Inc Tax Exp - Federal', '11', 0),
[278] Fix | Delete
('5520', '', 'Inc Tax Exp - State', '11', 0),
[279] Fix | Delete
('5530', '', 'Taxes - Real Estate', '11', 0),
[280] Fix | Delete
('5540', '', 'Taxes - Personal Property', '11', 0),
[281] Fix | Delete
('5550', '', 'Taxes - Franchise', '11', 0),
[282] Fix | Delete
('5560', '', 'Taxes - Foreign Withholding', '11', 0),
[283] Fix | Delete
('5610', '', 'Accounting & Legal', '12', 0),
[284] Fix | Delete
('5615', '', 'Advertising & Promotions', '12', 0),
[285] Fix | Delete
('5620', '', 'Bad Debts', '12', 0),
[286] Fix | Delete
('5660', '', 'Amortization Expense', '12', 0),
[287] Fix | Delete
('5685', '', 'Insurance', '12', 0),
[288] Fix | Delete
('5690', '', 'Interest & Bank Charges', '12', 0),
[289] Fix | Delete
('5700', '', 'Office Supplies', '12', 0),
[290] Fix | Delete
('5760', '', 'Rent', '12', 0),
[291] Fix | Delete
('5765', '', 'Repair & Maintenance', '12', 0),
[292] Fix | Delete
('5780', '', 'Telephone', '12', 0),
[293] Fix | Delete
('5785', '', 'Travel & Entertainment', '12', 0),
[294] Fix | Delete
('5790', '', 'Utilities', '12', 0),
[295] Fix | Delete
('5795', '', 'Registrations', '12', 0),
[296] Fix | Delete
('5800', '', 'Licenses', '12', 0),
[297] Fix | Delete
('5810', '', 'Foreign Exchange Loss', '12', 0),
[298] Fix | Delete
('9990', '', 'Year Profit/Loss', '12', 0);
[299] Fix | Delete
[300] Fix | Delete
-- --------------------------------------------------------
[301] Fix | Delete
[302] Fix | Delete
--
[303] Fix | Delete
-- Table structure for table `0_chart_types`
[304] Fix | Delete
--
[305] Fix | Delete
[306] Fix | Delete
CREATE TABLE `0_chart_types` (
[307] Fix | Delete
`id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
[308] Fix | Delete
`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[309] Fix | Delete
`class_id` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[310] Fix | Delete
`parent` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-1',
[311] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[312] Fix | Delete
PRIMARY KEY (`id`),
[313] Fix | Delete
KEY `name` (`name`),
[314] Fix | Delete
KEY `class_id` (`class_id`)
[315] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[316] Fix | Delete
[317] Fix | Delete
--
[318] Fix | Delete
-- Dumping data for table `0_chart_types`
[319] Fix | Delete
--
[320] Fix | Delete
[321] Fix | Delete
INSERT INTO `0_chart_types` VALUES
[322] Fix | Delete
('1', 'Current Assets', '1', '', 0),
[323] Fix | Delete
('10', 'Cost of Goods Sold', '4', '', 0),
[324] Fix | Delete
('11', 'Payroll Expenses', '4', '', 0),
[325] Fix | Delete
('12', 'General & Administrative expenses', '4', '', 0),
[326] Fix | Delete
('2', 'Inventory Assets', '1', '', 0),
[327] Fix | Delete
('3', 'Capital Assets', '1', '', 0),
[328] Fix | Delete
('4', 'Current Liabilities', '2', '', 0),
[329] Fix | Delete
('5', 'Long Term Liabilities', '2', '', 0),
[330] Fix | Delete
('6', 'Share Capital', '2', '', 0),
[331] Fix | Delete
('7', 'Retained Earnings', '2', '', 0),
[332] Fix | Delete
('8', 'Sales Revenue', '3', '', 0),
[333] Fix | Delete
('9', 'Other Revenue', '3', '', 0);
[334] Fix | Delete
[335] Fix | Delete
-- --------------------------------------------------------
[336] Fix | Delete
[337] Fix | Delete
--
[338] Fix | Delete
-- Table structure for table `0_comments`
[339] Fix | Delete
--
[340] Fix | Delete
[341] Fix | Delete
CREATE TABLE `0_comments` (
[342] Fix | Delete
`type` int(11) NOT NULL DEFAULT '0',
[343] Fix | Delete
`id` int(11) NOT NULL DEFAULT '0',
[344] Fix | Delete
`date_` date DEFAULT '0000-00-00',
[345] Fix | Delete
`memo_` tinytext COLLATE utf8_unicode_ci,
[346] Fix | Delete
KEY `type_and_id` (`type`,`id`)
[347] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[348] Fix | Delete
[349] Fix | Delete
-- --------------------------------------------------------
[350] Fix | Delete
[351] Fix | Delete
--
[352] Fix | Delete
-- Table structure for table `0_credit_status`
[353] Fix | Delete
--
[354] Fix | Delete
[355] Fix | Delete
CREATE TABLE `0_credit_status` (
[356] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[357] Fix | Delete
`reason_description` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[358] Fix | Delete
`dissallow_invoices` tinyint(1) NOT NULL DEFAULT '0',
[359] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[360] Fix | Delete
PRIMARY KEY (`id`),
[361] Fix | Delete
UNIQUE KEY `reason_description` (`reason_description`)
[362] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
[363] Fix | Delete
[364] Fix | Delete
--
[365] Fix | Delete
-- Dumping data for table `0_credit_status`
[366] Fix | Delete
--
[367] Fix | Delete
[368] Fix | Delete
INSERT INTO `0_credit_status` VALUES
[369] Fix | Delete
(1, 'Good History', 0, 0),
[370] Fix | Delete
(3, 'No more work until payment received', 1, 0),
[371] Fix | Delete
(4, 'In liquidation', 1, 0);
[372] Fix | Delete
[373] Fix | Delete
-- --------------------------------------------------------
[374] Fix | Delete
[375] Fix | Delete
--
[376] Fix | Delete
-- Table structure for table `0_crm_categories`
[377] Fix | Delete
--
[378] Fix | Delete
[379] Fix | Delete
CREATE TABLE `0_crm_categories` (
[380] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'pure technical key',
[381] Fix | Delete
`type` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'contact type e.g. customer',
[382] Fix | Delete
`action` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'detailed usage e.g. department',
[383] Fix | Delete
`name` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT 'for category selector',
[384] Fix | Delete
`description` tinytext COLLATE utf8_unicode_ci NOT NULL COMMENT 'usage description',
[385] Fix | Delete
`system` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'nonzero for core system usage',
[386] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[387] Fix | Delete
PRIMARY KEY (`id`),
[388] Fix | Delete
UNIQUE KEY `type` (`type`,`action`),
[389] Fix | Delete
UNIQUE KEY `type_2` (`type`,`name`)
[390] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
[391] Fix | Delete
[392] Fix | Delete
--
[393] Fix | Delete
-- Dumping data for table `0_crm_categories`
[394] Fix | Delete
--
[395] Fix | Delete
[396] Fix | Delete
INSERT INTO `0_crm_categories` VALUES
[397] Fix | Delete
(1, 'cust_branch', 'general', 'General', 'General contact data for customer branch (overrides company setting)', 1, 0),
[398] Fix | Delete
(2, 'cust_branch', 'invoice', 'Invoices', 'Invoice posting (overrides company setting)', 1, 0),
[399] Fix | Delete
(3, 'cust_branch', 'order', 'Orders', 'Order confirmation (overrides company setting)', 1, 0),
[400] Fix | Delete
(4, 'cust_branch', 'delivery', 'Deliveries', 'Delivery coordination (overrides company setting)', 1, 0),
[401] Fix | Delete
(5, 'customer', 'general', 'General', 'General contact data for customer', 1, 0),
[402] Fix | Delete
(6, 'customer', 'order', 'Orders', 'Order confirmation', 1, 0),
[403] Fix | Delete
(7, 'customer', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0),
[404] Fix | Delete
(8, 'customer', 'invoice', 'Invoices', 'Invoice posting', 1, 0),
[405] Fix | Delete
(9, 'supplier', 'general', 'General', 'General contact data for supplier', 1, 0),
[406] Fix | Delete
(10, 'supplier', 'order', 'Orders', 'Order confirmation', 1, 0),
[407] Fix | Delete
(11, 'supplier', 'delivery', 'Deliveries', 'Delivery coordination', 1, 0),
[408] Fix | Delete
(12, 'supplier', 'invoice', 'Invoices', 'Invoice posting', 1, 0);
[409] Fix | Delete
[410] Fix | Delete
-- --------------------------------------------------------
[411] Fix | Delete
[412] Fix | Delete
--
[413] Fix | Delete
-- Table structure for table `0_crm_contacts`
[414] Fix | Delete
--
[415] Fix | Delete
[416] Fix | Delete
CREATE TABLE `0_crm_contacts` (
[417] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[418] Fix | Delete
`person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons',
[419] Fix | Delete
`type` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'foreign key to crm_categories',
[420] Fix | Delete
`action` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'foreign key to crm_categories',
[421] Fix | Delete
`entity_id` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'entity id in related class table',
[422] Fix | Delete
PRIMARY KEY (`id`),
[423] Fix | Delete
KEY `type` (`type`,`action`)
[424] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[425] Fix | Delete
[426] Fix | Delete
-- --------------------------------------------------------
[427] Fix | Delete
[428] Fix | Delete
--
[429] Fix | Delete
-- Table structure for table `0_crm_persons`
[430] Fix | Delete
--
[431] Fix | Delete
[432] Fix | Delete
CREATE TABLE `0_crm_persons` (
[433] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[434] Fix | Delete
`ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
[435] Fix | Delete
`name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
[436] Fix | Delete
`name2` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
[437] Fix | Delete
`address` tinytext COLLATE utf8_unicode_ci,
[438] Fix | Delete
`phone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
[439] Fix | Delete
`phone2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
[440] Fix | Delete
`fax` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
[441] Fix | Delete
`email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
[442] Fix | Delete
`lang` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
[443] Fix | Delete
`notes` tinytext COLLATE utf8_unicode_ci NOT NULL,
[444] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[445] Fix | Delete
PRIMARY KEY (`id`),
[446] Fix | Delete
KEY `ref` (`ref`)
[447] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[448] Fix | Delete
[449] Fix | Delete
-- --------------------------------------------------------
[450] Fix | Delete
[451] Fix | Delete
--
[452] Fix | Delete
-- Table structure for table `0_currencies`
[453] Fix | Delete
--
[454] Fix | Delete
[455] Fix | Delete
CREATE TABLE `0_currencies` (
[456] Fix | Delete
`currency` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[457] Fix | Delete
`curr_abrev` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[458] Fix | Delete
`curr_symbol` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[459] Fix | Delete
`country` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[460] Fix | Delete
`hundreds_name` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[461] Fix | Delete
`auto_update` tinyint(1) NOT NULL DEFAULT '1',
[462] Fix | Delete
`inactive` tinyint(1) NOT NULL DEFAULT '0',
[463] Fix | Delete
PRIMARY KEY (`curr_abrev`)
[464] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[465] Fix | Delete
[466] Fix | Delete
--
[467] Fix | Delete
-- Dumping data for table `0_currencies`
[468] Fix | Delete
--
[469] Fix | Delete
[470] Fix | Delete
INSERT INTO `0_currencies` VALUES
[471] Fix | Delete
('CA Dollars', 'CAD', '$', 'Canada', 'Cents', 1, 0),
[472] Fix | Delete
('Euro', 'EUR', '€', 'Europe', 'Cents', 1, 0),
[473] Fix | Delete
('Pounds', 'GBP', '£', 'England', 'Pence', 1, 0),
[474] Fix | Delete
('US Dollars', 'USD', '$', 'United States', 'Cents', 1, 0);
[475] Fix | Delete
[476] Fix | Delete
-- --------------------------------------------------------
[477] Fix | Delete
[478] Fix | Delete
--
[479] Fix | Delete
-- Table structure for table `0_cust_allocations`
[480] Fix | Delete
--
[481] Fix | Delete
[482] Fix | Delete
CREATE TABLE `0_cust_allocations` (
[483] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[484] Fix | Delete
`person_id` int(11) DEFAULT NULL,
[485] Fix | Delete
`amt` double unsigned DEFAULT NULL,
[486] Fix | Delete
`date_alloc` date NOT NULL DEFAULT '0000-00-00',
[487] Fix | Delete
`trans_no_from` int(11) DEFAULT NULL,
[488] Fix | Delete
`trans_type_from` int(11) DEFAULT NULL,
[489] Fix | Delete
`trans_no_to` int(11) DEFAULT NULL,
[490] Fix | Delete
`trans_type_to` int(11) DEFAULT NULL,
[491] Fix | Delete
PRIMARY KEY (`id`),
[492] Fix | Delete
UNIQUE KEY `trans_type_from` (`person_id`,`trans_type_from`,`trans_no_from`,`trans_type_to`,`trans_no_to`),
[493] Fix | Delete
KEY `From` (`trans_type_from`,`trans_no_from`),
[494] Fix | Delete
KEY `To` (`trans_type_to`,`trans_no_to`)
[495] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[496] Fix | Delete
[497] Fix | Delete
-- --------------------------------------------------------
[498] Fix | Delete
[499] Fix | Delete
12345
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function