X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.5.sql;fp=sql%2Falter2.5.sql;h=3994822e62871774c571db0cb834e92110b78e01;hb=89e8ca2be9235215ac2e2bf5e58d7eedd2dda84d;hp=1511ff1123b49565094629456dde9a352aba4aff;hpb=5a7ef37131354aabdcf04c639a903e5876b743e4;p=fa-stable.git

diff --git a/sql/alter2.5.sql b/sql/alter2.5.sql
index 1511ff11..3994822e 100644
--- a/sql/alter2.5.sql
+++ b/sql/alter2.5.sql
@@ -59,3 +59,15 @@ UPDATE `0_cust_branch` branch
 	SET branch.default_ship_via=stock.stock_id;
 
 ALTER TABLE `0_tax_group_items` DROP COLUMN `tax_shipping`;
+
+# new debug trail
+DROP TABLE `1_sql_trail`;
+CREATE TABLE `1_db_trail` (
+		`id` int(11) NOT NULL AUTO_INCREMENT,
+		`stamp` timestamp DEFAULT CURRENT_TIMESTAMP,
+		`user` tinyint(3) unsigned NOT NULL DEFAULT '0',
+		`msg`  varchar(255) DEFAULT '',
+		`entry`  varchar(255) DEFAULT '',
+		`data` text DEFAULT NULL,
+	PRIMARY KEY (`id`)
+	) ENGINE=MyISAM;