X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fen_US-new.sql;h=268ef89cd34de5b2b78db8b62b8b5035658f7628;hb=9a4dbbda763486152d2e98485a7a2a699426141d;hp=2d9ca1144f950330173c35f113e0bb779cb5142a;hpb=39cfd6e5b3170a5eddeffacef1d88e9796bcc418;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 2d9ca114..268ef89c 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1,5 +1,5 @@ -- MySQL dump of database 'en_US-new' on host 'localhost' --- Backup Date and Time: 2020-01-21 11:16 +-- Backup Date and Time: 2021-01-21 11:16 -- Built by FrontAccounting 2.4.7 -- http://frontaccounting.com -- Company: Training Co. @@ -636,7 +636,7 @@ CREATE TABLE `0_fiscal_year` ( -- Data of table `0_fiscal_year` -- INSERT INTO `0_fiscal_year` VALUES -('1', '2019-01-01', '2019-12-31', '1'); +('1', '2021-01-01', '2021-12-31', '1'); -- Structure of table `0_gl_trans` -- @@ -1612,7 +1612,9 @@ INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1'), ('dim_on_recurrent_invoice','setup.company', 'tinyint', 1, '0'), ('long_description_invoice','setup.company', 'tinyint', 1, '0'), -('use_fixed_assets','setup.company', 'tinyint', 1, '1'); +('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` -- @@ -1783,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', '2019-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` --