How to start anew

[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

[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%';

[alexdp]

Worked great. Thank you.

[toms]

You're welcome!

[admin]

.