Page 1 of 1

How to start anew

Posted: Sat Apr 21, 2018 3:33 pm
by alexdp
Hello you all,
After playing with nuBuilder, creating tables and nuObjects (forms, etc.), I am now ready to create a new project. My question is how to proceed in order to get rid of nuObjects I created while playing with nuBuilder. I deleted all tables that did not start with the name zzzz_. What is the next step to delete nuObjects ? It would be nice if I did not have to reinstal nuBuilder Forte.
Regards,
Alex DP

Re: How to start anew

Posted: Sat Apr 21, 2018 3:49 pm
by toms
Hi,

Run all these queries (create a backup first by exporting the db to a sql file)

Deletes all records that do not start with ids starting with 'nu'

Code: Select all

DELETE FROM zzzzsys_form WHERE zzzzsys_form_id NOT LIKE 'nu%' ;
DELETE FROM zzzzsys_object WHERE zzzzsys_object_id NOT LIKE 'nu%';
DELETE FROM zzzzsys_event WHERE zzzzsys_event_id NOT LIKE 'nu%'; 										
DELETE FROM zzzzsys_file WHERE zzzzsys_file_id NOT LIKE 'nu%';										
DELETE FROM zzzzsys_format WHERE zzzzsys_format_id NOT LIKE 'nu%';										
DELETE FROM zzzzsys_php WHERE sph_zzzzsys_form_id NOT LIKE 'nu%' AND zzzzsys_php_id NOT LIKE 'nu%' ;		  				
DELETE FROM zzzzsys_tab WHERE  syt_zzzzsys_form_id NOT LIKE 'nu%';

Re: How to start anew

Posted: Sat Apr 21, 2018 4:04 pm
by alexdp
Worked great. Thank you.

Re: How to start anew

Posted: Sat Apr 21, 2018 6:46 pm
by toms
You're welcome!

Re: How to start anew

Posted: Sun Apr 22, 2018 2:13 am
by admin
.