Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

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
0
rgb192
Asked:
rgb192
  • 2
1 Solution
 
Mark GilbertSenior Performance EngineerCommented:
Search for all statements in the code containing  (case insensitive if needed):

 CREATE TABLE

Open in new window

0
 
rinfoCommented:
There is no sql file in there.
Table creation happens in install2.php at line 70
these are excerpts from in there
//Tables Creation ***************************************************************************************

require "config.php";
//Tickets Table
$sql = "CREATE TABLE `" . $bd . "` .`tickets` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`user` TINYTEXT NOT NULL ,
`contenido` TEXT NOT NULL ,
`fecha` TINYTEXT NOT NULL ,
`ultimo` TINYTEXT NOT NULL ,
`departamento` TINYTEXT NOT NULL ,
`asunto` TINYTEXT NOT NULL ,
`leido` INT( 1 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
INDEX ( `id` )
) ENGINE = MYISAM";
mysql_db_query($bd, $sql, $conexion);

Open in new window

0
 
rinfoCommented:
And not its not creating any table called statistics
In fact word statistics  is never used in the entire script.
0
 
rgb192Author Commented:
most complete sql finding example

thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now