X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=268ef89cd34de5b2b78db8b62b8b5035658f7628;hb=9a4dbbda763486152d2e98485a7a2a699426141d;hp=e1ddc2d709842c6241957d22d5200fc8e5253f41;hpb=1a88a3e8c8dc9b63d88697e4f330a0501a301f44;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index e1ddc2d7..268ef89c 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1,6 +1,6 @@ -- MySQL dump of database 'en_US-new' on host 'localhost' --- Backup Date and Time: 2019-01-21 11:16 --- Built by FrontAccounting 2.4.6 +-- Backup Date and Time: 2021-01-21 11:16 +-- Built by FrontAccounting 2.4.7 -- http://frontaccounting.com -- Company: Training Co. -- User: Administrator @@ -636,7 +636,7 @@ CREATE TABLE `0_fiscal_year` ( -- Data of table `0_fiscal_year` -- INSERT INTO `0_fiscal_year` VALUES -('1', '2018-01-01', '2018-12-31', '1'); +('1', '2021-01-01', '2021-12-31', '1'); -- Structure of table `0_gl_trans` -- @@ -1610,7 +1610,11 @@ INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'), ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'), ('use_manufacturing','setup.company', 'tinyint', 1, '1'), -('use_fixed_assets','setup.company', 'tinyint', 1, '1'); +('dim_on_recurrent_invoice','setup.company', 'tinyint', 1, '0'), +('long_description_invoice','setup.company', 'tinyint', 1, '0'), +('max_days_in_docs','setup.company', 'smallint', 5, '180'), +('use_fixed_assets','setup.company', 'tinyint', 1, '1'), +('company_logo_on_views', 'setup.company', 'tinyint', '1', '0'); -- Structure of table `0_tag_associations` -- @@ -1781,7 +1785,7 @@ CREATE TABLE `0_users` ( -- Data of table `0_users` -- INSERT INTO `0_users` VALUES -('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); +('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2021-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); -- Structure of table `0_voided` --