Nope. But they are pretty similar. Taking a quick look at the 1.6ST upgrade.sql (included ni the 1.6st archive) it runs the following:

ALTER TABLE `%TABLE_PREFIX%ticket` ADD `topic_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `priority_id`;

ALTER TABLE `%TABLE_PREFIX%ticket` ADD INDEX ( `topic_id` );

ALTER TABLE `%TABLE_PREFIX%ticket` CHANGE `topic` `helptopic` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

ALTER TABLE `%TABLE_PREFIX%groups` ADD `can_create_tickets` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `dept_access`;

ALTER TABLE `%TABLE_PREFIX%staff` ADD `auto_refresh_rate` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `max_page_size`;

ALTER TABLE `%TABLE_PREFIX%config` ADD `ticket_notice_active` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `message_autoresponder`;

ALTER TABLE `%TABLE_PREFIX%config` ADD `enable_captcha` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `use_email_priority`;

ALTER TABLE `%TABLE_PREFIX%config` ADD `log_ticket_activity` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `strip_quoted_reply`;

ALTER TABLE `%TABLE_PREFIX%config` ADD `staff_ip_binding` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `enable_daylight_saving`;

ALTER TABLE `%TABLE_PREFIX%staff` CHANGE `signature` `signature` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `%TABLE_PREFIX%department` CHANGE `dept_signature` `dept_signature` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `%TABLE_PREFIX%email_template`

ADD `ticket_notice_subj` VARCHAR( 255 ) NOT NULL AFTER `ticket_autoresp_body` ,

ADD `ticket_notice_body` TEXT NOT NULL AFTER `ticket_notice_subj`;

INSERT INTO `%TABLE_PREFIX%kb_premade` (`premade_id`, `dept_id`, `isenabled`, `title`, `answer`, `created`, `updated`) VALUES

('', 0, 1, 'Sample (with variables)', '\r\n%name,\r\n\r\nYour ticket #%ticket created on %createdate is in %dept department.\r\n\r\n', NOW(), NOW());

You would find the sql files located in the 1.6st archive located at: upload\setup\inc

I'm gonna overwrite my existing 1.6RC5 files with 1.6ST files without changing any databases or tables. Because I need the data in the existing database. Do both versions use same database table structure?

I am right now in inckka situation, tried to run those queries but I am getting

#1146 - Table 'database.%TABLE_PREFIX%ticket' doesn't exist

Not sure what am I doing wrong :

Anyone's help is welcome

_______________________________________________________________________________________________________

I have finally learned what "upward compatible" means. It means we get to keep all our old mistakes. (Free hosting)

You have to change %TABLE_PREFIX% to whatever you used as your table prefix. View the tables in your database and you should be able to figure out what you used fairly quickly. Alternatively you can look at your osticket configuration file. Depending on when you installed and if you renamed the config file it could be settings.php, ostconfig.php, or ost-config.php. The config file is located in the /include directory. Just search the file for "TABLE_PREFIX".