Solved

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

Posted on 2013-01-21
4
257 Views
Last Modified: 2013-01-23
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
Comment
Question by:rgb192
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Mark Gilbert
ID: 38804201
Search for all statements in the code containing  (case insensitive if needed):

 CREATE TABLE

Open in new window

0
 
LVL 9

Accepted Solution

by:
rinfo earned 500 total points
ID: 38804949
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
 
LVL 9

Expert Comment

by:rinfo
ID: 38804951
And not its not creating any table called statistics
In fact word statistics  is never used in the entire script.
0
 

Author Closing Comment

by:rgb192
ID: 38812466
most complete sql finding example

thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Php logic to add to date card 9 36
EditableGrid how to fetch rows from MySql in php 14 44
php mysql pdo 13 30
Get data from two MySQL tables 6 18
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question