Fakturo

Website
Log out

Backup Database

Backup Database

Download SQL backup
Exports your full database as a .sql file you can use to restore or migrate. 

DROP
  TABLE IF EXISTS `si_biller`;
CREATE TABLE `si_biller` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `name` varchar(255) DEFAULT NULL,
  `street_address` varchar(255) DEFAULT NULL,
  `street_address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `mobile_phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `paypal_business_name` varchar(255) DEFAULT NULL,
  `paypal_notify_url` varchar(255) DEFAULT NULL,
  `paypal_return_url` varchar(255) DEFAULT NULL,
  `eway_customer_id` varchar(255) DEFAULT NULL,
  `paymentsgateway_api_id` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `custom_field1` varchar(255) DEFAULT NULL,
  `custom_field2` varchar(255) DEFAULT NULL,
  `custom_field3` varchar(255) DEFAULT NULL,
  `custom_field4` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`domain_id`, `id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_biller` (
  `id`, `domain_id`, `name`, `street_address`,
  `street_address2`, `city`, `state`,
  `zip_code`, `country`, `phone`, `mobile_phone`,
  `fax`, `email`, `logo`, `footer`,
  `paypal_business_name`, `paypal_notify_url`,
  `paypal_return_url`, `eway_customer_id`,
  `paymentsgateway_api_id`, `notes`,
  `custom_field1`, `custom_field2`,
  `custom_field3`, `custom_field4`,
  `enabled`
)
VALUES
  (
    '1', '1', 'Noelle Fanning', '', '',
    '', '', '', '', '', '', '', 'noelle@delifreshgo.com',
    '_default_blank_logo.png', '', '',
    '', '', '', '', '', '', '', '', '', '1'
  );
DROP
  TABLE IF EXISTS `si_cron`;
CREATE TABLE `si_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` varchar(10) DEFAULT NULL,
  `recurrence` int(11) NOT NULL,
  `recurrence_type` varchar(11) NOT NULL,
  `email_biller` tinyint(1) NOT NULL DEFAULT 0,
  `email_customer` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`domain_id`, `id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_cron_log`;
CREATE TABLE `si_cron_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `cron_id` varchar(25) DEFAULT NULL,
  `run_date` date NOT NULL,
  PRIMARY KEY (`domain_id`, `id`),
  UNIQUE KEY `CronIdUnq` (
    `domain_id`, `cron_id`, `run_date`
  )
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_custom_fields`;
CREATE TABLE `si_custom_fields` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_custom_field` varchar(255) DEFAULT NULL,
  `cf_custom_label` varchar(255) DEFAULT NULL,
  `cf_display` tinyint(1) NOT NULL DEFAULT 1,
  `domain_id` int(11) NOT NULL,
  PRIMARY KEY (`cf_id`, `domain_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 17 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '1', 'biller_cf1', 'Example custom field',
    '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  ('2', 'biller_cf2', NULL, '0', '1');
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  ('3', 'biller_cf3', NULL, '0', '1');
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  ('4', 'biller_cf4', NULL, '0', '1');
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '5', 'customer_cf1', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '6', 'customer_cf2', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '7', 'customer_cf3', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '8', 'customer_cf4', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  ('9', 'product_cf1', NULL, '0', '1');
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '10', 'product_cf2', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '11', 'product_cf3', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '12', 'product_cf4', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '13', 'invoice_cf1', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '14', 'invoice_cf2', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '15', 'invoice_cf3', NULL, '0', '1'
  );
INSERT INTO `si_custom_fields` (
  `cf_id`, `cf_custom_field`, `cf_custom_label`,
  `cf_display`, `domain_id`
)
VALUES
  (
    '16', 'invoice_cf4', NULL, '0', '1'
  );
DROP
  TABLE IF EXISTS `si_customers`;
CREATE TABLE `si_customers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `attention` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `street_address` varchar(255) DEFAULT NULL,
  `street_address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `mobile_phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `custom_field1` varchar(255) DEFAULT NULL,
  `custom_field2` varchar(255) DEFAULT NULL,
  `custom_field3` varchar(255) DEFAULT NULL,
  `custom_field4` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`domain_id`, `id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_customers` (
  `id`, `domain_id`, `attention`, `name`,
  `department`, `street_address`,
  `street_address2`, `city`, `state`,
  `zip_code`, `country`, `phone`, `mobile_phone`,
  `fax`, `email`, `notes`, `custom_field1`,
  `custom_field2`, `custom_field3`,
  `custom_field4`, `enabled`
)
VALUES
  (
    '1', '1', '', 'Clifton McDonald europe S.L',
    '', '', '', '', '', '', '', '', '', '',
    'mark@delifreshgo.com', '', '', '',
    '', '', '1'
  );
DROP
  TABLE IF EXISTS `si_extensions`;
CREATE TABLE `si_extensions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`, `domain_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_extensions` (
  `id`, `domain_id`, `name`, `description`,
  `enabled`
)
VALUES
  (
    '1', '0', 'core', 'Core part of Simple Invoices - always enabled',
    '1'
  );
DROP
  TABLE IF EXISTS `si_index`;
CREATE TABLE `si_index` (
  `id` int(11) NOT NULL,
  `node` varchar(255) NOT NULL,
  `sub_node` varchar(255) DEFAULT NULL,
  `sub_node_2` varchar(255) DEFAULT NULL,
  `domain_id` int(11) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_inventory`;
CREATE TABLE `si_inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(25, 6) NOT NULL,
  `cost` decimal(25, 6) DEFAULT NULL,
  `date` date NOT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`domain_id`, `id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_invoice_item_tax`;
CREATE TABLE `si_invoice_item_tax` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_item_id` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL,
  `tax_type` char(1) NOT NULL DEFAULT '%',
  `tax_rate` decimal(25, 6) NOT NULL,
  `tax_amount` decimal(25, 6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UnqInvTax` (`invoice_item_id`, `tax_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_invoice_items`;
CREATE TABLE `si_invoice_items` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(10) NOT NULL DEFAULT 0,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `quantity` decimal(25, 6) NOT NULL DEFAULT 0.000000,
  `product_id` int(10) DEFAULT 0,
  `unit_price` decimal(25, 6) DEFAULT 0.000000,
  `tax_amount` decimal(25, 6) DEFAULT 0.000000,
  `gross_total` decimal(25, 6) DEFAULT 0.000000,
  `description` text DEFAULT NULL,
  `total` decimal(25, 6) DEFAULT 0.000000,
  `attribute` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `DomainInv` (`invoice_id`, `domain_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_invoice_type`;
CREATE TABLE `si_invoice_type` (
  `inv_ty_id` int(11) NOT NULL AUTO_INCREMENT,
  `inv_ty_description` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`inv_ty_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_invoice_type` (
  `inv_ty_id`, `inv_ty_description`
)
VALUES
  ('1', 'Total');
INSERT INTO `si_invoice_type` (
  `inv_ty_id`, `inv_ty_description`
)
VALUES
  ('2', 'Itemised');
INSERT INTO `si_invoice_type` (
  `inv_ty_id`, `inv_ty_description`
)
VALUES
  ('3', 'Consulting');
DROP
  TABLE IF EXISTS `si_invoices`;
CREATE TABLE `si_invoices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `index_id` int(11) NOT NULL,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `biller_id` int(10) NOT NULL DEFAULT 0,
  `customer_id` int(10) NOT NULL DEFAULT 0,
  `type_id` int(10) NOT NULL DEFAULT 0,
  `preference_id` int(10) NOT NULL DEFAULT 0,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `custom_field1` varchar(50) DEFAULT NULL,
  `custom_field2` varchar(50) DEFAULT NULL,
  `custom_field3` varchar(50) DEFAULT NULL,
  `custom_field4` varchar(50) DEFAULT NULL,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`domain_id`, `id`),
  KEY `domain_id` (`domain_id`),
  KEY `biller_id` (`biller_id`),
  KEY `customer_id` (`customer_id`),
  KEY `UniqDIB` (
    `index_id`, `preference_id`, `biller_id`,
    `domain_id`
  ),
  KEY `IdxDI` (
    `index_id`, `preference_id`, `domain_id`
  )
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_log`;
CREATE TABLE `si_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `userid` int(11) NOT NULL DEFAULT 1,
  `sqlquerie` text NOT NULL,
  `last_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`, `domain_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_payment`;
CREATE TABLE `si_payment` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ac_inv_id` int(11) NOT NULL,
  `ac_amount` decimal(25, 6) NOT NULL,
  `ac_notes` text NOT NULL,
  `ac_date` datetime NOT NULL,
  `ac_payment_type` int(10) NOT NULL DEFAULT 1,
  `domain_id` int(11) NOT NULL,
  `online_payment_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`domain_id`, `id`),
  KEY `domain_id` (`domain_id`),
  KEY `ac_inv_id` (`ac_inv_id`),
  KEY `ac_amount` (`ac_amount`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_payment_types`;
CREATE TABLE `si_payment_types` (
  `pt_id` int(10) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `pt_description` varchar(250) NOT NULL,
  `pt_enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`domain_id`, `pt_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_payment_types` (
  `pt_id`, `domain_id`, `pt_description`,
  `pt_enabled`
)
VALUES
  ('1', '1', 'Cash', '1');
INSERT INTO `si_payment_types` (
  `pt_id`, `domain_id`, `pt_description`,
  `pt_enabled`
)
VALUES
  ('2', '1', 'Credit Card', '1');
DROP
  TABLE IF EXISTS `si_preferences`;
CREATE TABLE `si_preferences` (
  `pref_id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `pref_description` varchar(50) DEFAULT NULL,
  `pref_currency_sign` varchar(50) DEFAULT NULL,
  `pref_inv_heading` varchar(50) DEFAULT NULL,
  `pref_inv_wording` varchar(50) DEFAULT NULL,
  `pref_inv_detail_heading` varchar(50) DEFAULT NULL,
  `pref_inv_detail_line` text DEFAULT NULL,
  `pref_inv_payment_method` varchar(50) DEFAULT NULL,
  `pref_inv_payment_line1_name` varchar(50) DEFAULT NULL,
  `pref_inv_payment_line1_value` varchar(50) DEFAULT NULL,
  `pref_inv_payment_line2_name` varchar(50) DEFAULT NULL,
  `pref_inv_payment_line2_value` varchar(50) DEFAULT NULL,
  `pref_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL,
  `locale` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `index_group` int(11) NOT NULL,
  `currency_code` varchar(25) DEFAULT NULL,
  `include_online_payment` varchar(255) DEFAULT NULL,
  `currency_position` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`domain_id`, `pref_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_preferences` (
  `pref_id`, `domain_id`, `pref_description`,
  `pref_currency_sign`, `pref_inv_heading`,
  `pref_inv_wording`, `pref_inv_detail_heading`,
  `pref_inv_detail_line`, `pref_inv_payment_method`,
  `pref_inv_payment_line1_name`,
  `pref_inv_payment_line1_value`,
  `pref_inv_payment_line2_name`,
  `pref_inv_payment_line2_value`,
  `pref_enabled`, `status`, `locale`,
  `language`, `index_group`, `currency_code`,
  `include_online_payment`, `currency_position`
)
VALUES
  (
    '1', '1', 'Invoice', '$', 'Invoice',
    'Invoice', 'Details', 'Payment is to be made within 14 days of the invoice being sent',
    'Electronic Funds Transfer', 'Account name',
    'H. & M. Simpson', 'Account number:',
    '0123-4567-7890', '1', '1', 'en_GB',
    'en_GB', '1', 'USD', NULL, 'left'
  );
INSERT INTO `si_preferences` (
  `pref_id`, `domain_id`, `pref_description`,
  `pref_currency_sign`, `pref_inv_heading`,
  `pref_inv_wording`, `pref_inv_detail_heading`,
  `pref_inv_detail_line`, `pref_inv_payment_method`,
  `pref_inv_payment_line1_name`,
  `pref_inv_payment_line1_value`,
  `pref_inv_payment_line2_name`,
  `pref_inv_payment_line2_value`,
  `pref_enabled`, `status`, `locale`,
  `language`, `index_group`, `currency_code`,
  `include_online_payment`, `currency_position`
)
VALUES
  (
    '2', '1', 'Receipt', '$', 'Receipt',
    'Receipt', 'Details', '<br />This transaction has been paid in full, please keep this receipt as proof of purchase.<br /> Thank you',
    NULL, NULL, NULL, NULL, NULL, '1', '1',
    'en_GB', 'en_GB', '1', 'USD', NULL,
    'left'
  );
INSERT INTO `si_preferences` (
  `pref_id`, `domain_id`, `pref_description`,
  `pref_currency_sign`, `pref_inv_heading`,
  `pref_inv_wording`, `pref_inv_detail_heading`,
  `pref_inv_detail_line`, `pref_inv_payment_method`,
  `pref_inv_payment_line1_name`,
  `pref_inv_payment_line1_value`,
  `pref_inv_payment_line2_name`,
  `pref_inv_payment_line2_value`,
  `pref_enabled`, `status`, `locale`,
  `language`, `index_group`, `currency_code`,
  `include_online_payment`, `currency_position`
)
VALUES
  (
    '3', '1', 'Estimate', '$', 'Estimate',
    'Estimate', 'Details', '<br />This is an estimate of the final value of services rendered.<br />Thank you',
    NULL, NULL, NULL, NULL, NULL, '1', '0',
    'en_GB', 'en_GB', '1', 'USD', NULL,
    'left'
  );
INSERT INTO `si_preferences` (
  `pref_id`, `domain_id`, `pref_description`,
  `pref_currency_sign`, `pref_inv_heading`,
  `pref_inv_wording`, `pref_inv_detail_heading`,
  `pref_inv_detail_line`, `pref_inv_payment_method`,
  `pref_inv_payment_line1_name`,
  `pref_inv_payment_line1_value`,
  `pref_inv_payment_line2_name`,
  `pref_inv_payment_line2_value`,
  `pref_enabled`, `status`, `locale`,
  `language`, `index_group`, `currency_code`,
  `include_online_payment`, `currency_position`
)
VALUES
  (
    '4', '1', 'Quote', '$', 'Quote', 'Quote',
    'Details', '<br />This is a quote of the final value of services rendered.<br />Thank you',
    NULL, NULL, NULL, NULL, NULL, '1', '0',
    'en_GB', 'en_GB', '1', 'USD', NULL,
    'left'
  );
DROP
  TABLE IF EXISTS `si_products`;
CREATE TABLE `si_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT 1,
  `description` text NOT NULL,
  `unit_price` decimal(25, 6) DEFAULT 0.000000,
  `default_tax_id` int(11) DEFAULT NULL,
  `default_tax_id_2` int(11) DEFAULT NULL,
  `cost` decimal(25, 6) DEFAULT 0.000000,
  `reorder_level` int(11) DEFAULT NULL,
  `custom_field1` varchar(255) DEFAULT NULL,
  `custom_field2` varchar(255) DEFAULT NULL,
  `custom_field3` varchar(255) DEFAULT NULL,
  `custom_field4` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `attribute` varchar(255) DEFAULT NULL,
  `notes_as_description` char(1) DEFAULT NULL,
  `show_description` char(1) DEFAULT NULL,
  PRIMARY KEY (`domain_id`, `id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_products_attribute_type`;
CREATE TABLE `si_products_attribute_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = MyISAM AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_products_attribute_type` (`id`, `name`)
VALUES
  ('1', 'list');
INSERT INTO `si_products_attribute_type` (`id`, `name`)
VALUES
  ('2', 'decimal');
INSERT INTO `si_products_attribute_type` (`id`, `name`)
VALUES
  ('3', 'free');
DROP
  TABLE IF EXISTS `si_products_attributes`;
CREATE TABLE `si_products_attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type_id` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_products_values`;
CREATE TABLE `si_products_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attribute_id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
DROP
  TABLE IF EXISTS `si_sql_patchmanager`;
CREATE TABLE `si_sql_patchmanager` (
  `sql_id` int(11) NOT NULL AUTO_INCREMENT,
  `sql_patch_ref` int(11) NOT NULL,
  `sql_patch` varchar(255) DEFAULT NULL,
  `sql_release` varchar(25) DEFAULT NULL,
  `sql_statement` text DEFAULT NULL,
  PRIMARY KEY (`sql_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 297 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '1', '1', 'Create sql_patchmanger table',
    '20060514', 'CREATE TABLE si_sql_patchmanager (sql_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,sql_patch_ref VARCHAR( 50 ) NOT NULL ,sql_patch VARCHAR( 255 ) NOT NULL ,sql_release VARCHAR( 25 ) NOT NULL ,sql_statement TEXT NOT NULL) ENGINE = MYISAM '
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('2', '2', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('3', '3', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('4', '4', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('5', '5', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('6', '6', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('7', '7', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('8', '8', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('9', '9', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('10', '10', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('11', '11', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('12', '12', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('13', '13', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('14', '14', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('15', '15', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('16', '16', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('17', '17', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('18', '18', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('19', '19', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('20', '20', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('21', '21', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('22', '22', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('23', '23', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('24', '24', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('25', '25', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('26', '26', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('27', '27', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('28', '28', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('29', '29', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('30', '30', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('31', '31', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('32', '32', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('33', '33', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('34', '34', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('35', '35', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('36', '36', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '37', '0', 'Start', '20060514', NULL
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('38', '37', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('39', '38', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('40', '39', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('41', '40', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('42', '41', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('43', '42', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('44', '43', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('45', '44', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('46', '45', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('47', '46', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('48', '47', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('49', '48', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('50', '49', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('51', '50', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('52', '51', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('53', '52', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('54', '53', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('55', '54', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('56', '55', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('57', '56', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('58', '57', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('59', '58', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('60', '59', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('61', '60', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('62', '61', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('63', '62', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('64', '63', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('65', '64', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('66', '65', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('67', '66', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('68', '67', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('69', '68', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('70', '69', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('71', '70', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('72', '71', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('73', '72', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('74', '73', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('75', '74', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('76', '75', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('77', '76', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('78', '77', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('79', '78', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('80', '79', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('81', '80', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('82', '81', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('83', '82', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('84', '83', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('85', '84', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('86', '85', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('87', '86', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('88', '87', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('89', '88', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('90', '89', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('91', '90', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('92', '91', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('93', '92', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('94', '93', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('95', '94', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('96', '95', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('97', '96', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('98', '97', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('99', '98', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('100', '99', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('101', '100', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('102', '101', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('103', '102', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('104', '103', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('105', '104', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('106', '105', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('107', '106', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('108', '107', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('109', '108', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('110', '109', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('111', '110', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('112', '111', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('113', '112', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('114', '113', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('115', '114', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('116', '115', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('117', '116', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('118', '117', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('119', '118', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('120', '119', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('121', '120', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('122', '121', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('123', '122', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('124', '123', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('125', '124', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('126', '125', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('127', '126', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('128', '127', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('129', '128', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('130', '129', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('131', '130', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('132', '131', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('133', '132', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('134', '133', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('135', '134', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('136', '135', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('137', '136', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('138', '137', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('139', '138', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('140', '139', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('141', '140', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('142', '141', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('143', '142', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('144', '143', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('145', '144', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('146', '145', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('147', '146', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('148', '147', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('149', '148', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('150', '149', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('151', '150', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('152', '151', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('153', '152', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('154', '153', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('155', '154', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('156', '155', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('157', '156', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('158', '157', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('159', '158', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('160', '159', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('161', '160', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('162', '161', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('163', '162', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('164', '163', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('165', '164', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('166', '165', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('167', '166', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('168', '167', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('169', '168', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('170', '169', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('171', '170', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('172', '171', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('173', '172', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('174', '173', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('175', '174', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('176', '175', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('177', '176', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('178', '177', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('179', '178', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('180', '179', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('181', '180', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('182', '181', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('183', '182', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('184', '183', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('185', '184', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('186', '185', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('187', '186', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('188', '187', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('189', '188', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('190', '189', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('191', '190', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('192', '191', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('193', '192', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('194', '193', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('195', '194', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('196', '195', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('197', '196', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('198', '197', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('199', '198', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('200', '199', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '201', '200', 'Update extensions table',
    '20090529', 'UPDATE si_extensions SET id = 0 WHERE name = core LIMIT 1'
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '202', '201', 'Set domain_id on system defaults table to 1',
    '20090622', 'UPDATE si_system_defaults SET domain_id = 1'
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '203', '202', 'Set extension_id on system defaults table to 1',
    '20090622', 'UPDATE si_system_defaults SET extension_id = 1'
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '204', '203', 'Move all old consulting style invoices to itemised',
    '20090704', 'UPDATE si_invoices SET type_id = 2 where type_id = 3'
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('205', '204', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('206', '205', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('207', '206', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('208', '207', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('209', '208', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('210', '209', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('211', '210', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('212', '211', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('213', '212', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('214', '213', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('215', '214', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('216', '215', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('217', '216', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('218', '217', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('219', '218', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('220', '219', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('221', '220', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('222', '221', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('223', '222', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('224', '223', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('225', '224', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('226', '225', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('227', '226', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('228', '227', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('229', '228', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('230', '229', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('231', '230', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('232', '231', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('233', '232', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('234', '233', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('235', '234', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('236', '235', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('237', '236', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('238', '237', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('239', '238', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('240', '239', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('241', '240', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('242', '241', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('243', '242', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('244', '243', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('245', '244', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('246', '245', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('247', '246', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('248', '247', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('249', '248', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('250', '249', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('251', '250', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('252', '251', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('253', '252', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('254', '253', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('255', '254', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('256', '255', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('257', '256', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('258', '257', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('259', '258', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('260', '259', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('261', '260', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('262', '261', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('263', '262', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('264', '263', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('265', '264', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('266', '265', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('267', '266', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('268', '267', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('269', '268', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('270', '269', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('271', '270', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('272', '271', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('273', '272', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('274', '273', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('275', '274', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('276', '275', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('277', '276', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('278', '277', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('279', '278', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('280', '279', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('281', '280', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('282', '281', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('283', '282', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('284', '283', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('285', '284', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('286', '285', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('287', '286', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('288', '287', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('289', '288', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('290', '289', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('291', '290', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('292', '291', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  ('293', '292', NULL, NULL, NULL);
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '294', '293', 'Add department to the customers',
    '20161004', 'ALTER TABLE si_customers ADD COLUMN department VARCHAR(255) NULL AFTER name'
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '295', '294', 'Prepare user table for Laravel Fortify',
    '20260329', '\n            ALTER TABLE `si_user` CHANGE `password` `password` VARCHAR(255) NULL;\n            ALTER TABLE `si_user` ADD COLUMN `remember_token` VARCHAR(100) NULL AFTER `password`;\n        '
  );
INSERT INTO `si_sql_patchmanager` (
  `sql_id`, `sql_patch_ref`, `sql_patch`,
  `sql_release`, `sql_statement`
)
VALUES
  (
    '296', '295', 'Add name field to user table for display name',
    '20260331', 'ALTER TABLE `si_user` ADD COLUMN `name` VARCHAR(255) NULL AFTER `email`;'
  );
DROP
  TABLE IF EXISTS `si_system_defaults`;
CREATE TABLE `si_system_defaults` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `value` varchar(30) DEFAULT NULL,
  `domain_id` int(5) NOT NULL DEFAULT 0,
  `extension_id` int(5) NOT NULL DEFAULT 0,
  PRIMARY KEY (`domain_id`, `id`),
  UNIQUE KEY `UnqNameInDomain` (`domain_id`, `name`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('1', 'biller', NULL, '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('2', 'customer', NULL, '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('3', 'tax', '1', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('4', 'preference', '1', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('5', 'line_items', '5', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '6', 'template', 'default', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('7', 'payment_type', '1', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('8', 'language', 'en_GB', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '9', 'dateformate', 'Y-m-d', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '10', 'spreadsheet', 'xls', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '11', 'wordprocessor', 'doc', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '12', 'pdfscreensize', '800', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '13', 'pdfpapersize', 'A4', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '14', 'pdfleftmargin', '15', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '15', 'pdfrightmargin', '15', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '16', 'pdftopmargin', '15', '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '17', 'pdfbottommargin', '15', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '18', 'emailhost', 'localhost', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '19', 'emailusername', NULL, '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '20', 'emailpassword', NULL, '1', '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('21', 'logging', '0', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('22', 'delete', 'N', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '23', 'tax_per_line_item', '1', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  ('24', 'inventory', '0', '1', '1');
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '25', 'product_attributes', '0', '1',
    '1'
  );
INSERT INTO `si_system_defaults` (
  `id`, `name`, `value`, `domain_id`,
  `extension_id`
)
VALUES
  (
    '26', 'large_dataset', '0', '1', '1'
  );
DROP
  TABLE IF EXISTS `si_tax`;
CREATE TABLE `si_tax` (
  `tax_id` int(11) NOT NULL AUTO_INCREMENT,
  `tax_description` varchar(50) DEFAULT NULL,
  `tax_percentage` decimal(25, 6) DEFAULT 0.000000,
  `type` char(1) NOT NULL DEFAULT '%',
  `tax_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `domain_id` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`, `tax_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_tax` (
  `tax_id`, `tax_description`, `tax_percentage`,
  `type`, `tax_enabled`, `domain_id`
)
VALUES
  (
    '1', 'GST', '10.000000', '%', '1', '1'
  );
INSERT INTO `si_tax` (
  `tax_id`, `tax_description`, `tax_percentage`,
  `type`, `tax_enabled`, `domain_id`
)
VALUES
  (
    '2', 'VAT', '10.000000', '%', '1', '1'
  );
INSERT INTO `si_tax` (
  `tax_id`, `tax_description`, `tax_percentage`,
  `type`, `tax_enabled`, `domain_id`
)
VALUES
  (
    '3', 'Sales Tax', '10.000000', '%',
    '1', '1'
  );
INSERT INTO `si_tax` (
  `tax_id`, `tax_description`, `tax_percentage`,
  `type`, `tax_enabled`, `domain_id`
)
VALUES
  (
    '4', 'No Tax', '0.000000', '%', '1',
    '1'
  );
INSERT INTO `si_tax` (
  `tax_id`, `tax_description`, `tax_percentage`,
  `type`, `tax_enabled`, `domain_id`
)
VALUES
  (
    '5', 'Postage', '20.000000', '$', '1',
    '1'
  );
DROP
  TABLE IF EXISTS `si_user`;
CREATE TABLE `si_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(191) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `domain_id` int(11) NOT NULL DEFAULT 0,
  `password` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`domain_id`, `id`),
  UNIQUE KEY `UnqEMail` (`email`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_user` (
  `id`, `email`, `name`, `role_id`, `domain_id`,
  `password`, `remember_token`, `enabled`,
  `user_id`
)
VALUES
  (
    '1', 'demo@simpleinvoices.org', NULL,
    '1', '1', 'fe01ce2a7fbac8fafaed7c982a04e229',
    NULL, '1', '0'
  );
DROP
  TABLE IF EXISTS `si_user_domain`;
CREATE TABLE `si_user_domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE = MyISAM AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_user_domain` (`id`, `name`)
VALUES
  ('1', 'default');
DROP
  TABLE IF EXISTS `si_user_role`;
CREATE TABLE `si_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE = MyISAM AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_uca1400_ai_ci;
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('1', 'administrator');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('2', 'domain_administrator');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('3', 'user');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('4', 'operator');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('5', 'customer');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('6', 'biller');
INSERT INTO `si_user_role` (`id`, `name`)
VALUES
  ('7', 'viewer');
Cancel