SQL

Run SQL scripts

ehu's picture
Submitted by ehu on Wed, 11/14/2012 - 12:58


psql [database name]then
 \i /usr/share/ledgersmb/sql/upgrade/1.3-1.2.sqlor
psql [dbname] < /usr/share/ledgersmb/sql/upgrade/1.3-1.2.sql

Select the database version

ehu's picture
Submitted by ehu on Wed, 11/14/2012 - 12:55

SELECT * FROM defaults WHERE setting_key = 'version';

Select the default settings

ehu's picture
Submitted by ehu on Wed, 11/14/2012 - 12:53

The Defaults settings ( System/Defaults)
select * from defaults order by setting_key;

Select all parts in orders

ehu's picture
Submitted by ehu on Fri, 11/09/2012 - 13:25

All parts in order, from '2012-04-21' and '2012-04-22':

select p.partnumber, count(*), sum(qty) from orderitems o join parts p on p.id = o.parts_id where trans_id in (select id from oe where not closed and transdate between '2012-04-21' and '2012-04-22') group by p.partnumber;

Grant permission to manage users (on a terminal)

ehu's picture
Submitted by ehu on Fri, 11/09/2012 - 13:24

GRANT lsmb_"your company"__users_manage TO "your username";

List available user roles (access types)

ehu's picture
Submitted by ehu on Fri, 11/09/2012 - 13:23

SELECT * FROM lsmb_roles;

Change expire time on users

ehu's picture
Submitted by ehu on Fri, 11/09/2012 - 13:19

Change expire time on users, so they can log in and change password when changing through the web interface is no longer an option:

ALTER USER 'myusername' WITH VALID UNTIL '2011-11-09';

Subscribe to SQL