Link to home
Start Free TrialLog in
Avatar of rgb192
rgb192Flag for United States of America

asked on

looking for the create database commands in a php cms (so I can delete the tables)

I want to undo the changes to the database I made while installing opensupports php mysql email ticketing


http://www.opensupports.com

I downloaded version 2 stable (attached)

I can not find a .sql file

what are all the tables in opensupports

in install2.php
I dropped these tables

drop table tickets;
drop table usuarios;
drop table code;
drop table departamentos;
drop table guias;
drop table comentariostickets;
drop table comentariosarticulos;
drop table staff;


I think there is a table called statistics
Avatar of Mark Gilbert
Mark Gilbert
Flag of United States of America image

Search for all statements in the code containing  (case insensitive if needed):

 CREATE TABLE

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of rinfo
rinfo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rinfo
rinfo

And not its not creating any table called statistics
In fact word statistics  is never used in the entire script.
Avatar of rgb192

ASKER

most complete sql finding example

thanks