Solved

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

Posted on 2013-01-21
4
261 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Displaying a google org chart from php/mysql code 27 47
MySql Linux vs Windows: bad results for Windows but why? 10 74
PHP substring 3 52
Secure registration PHP 7 43
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

751 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