loginews / business-accounting

Written in Microsoft Access, this is a complete accounting suite. We are in the process of moving it to CakePHP
0 stars 1 forks source link

Structure changes required #10

Open loginews opened 7 years ago

loginews commented 7 years ago

When I debugged the program to allow CakePHP to work, I had to make the following changes to the structure of users and param tables:

ALTER TABLE users CHANGE stkmain gldept stkmain_gldept VARCHAR(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '*';

ALTER TABLE users CHANGE ba-junior bajunior CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N';

ALTER TABLE param ADD id INT NOT NULL AUTO_INCREMENT AFTER POAUTONUM, ADD PRIMARY KEY (id);