Languages

Prefix for Database Tables 1.0

Version: 1.0

Downloads:0

Hits:347

SourceNO

Link Broken:Report It!

Package:Without source

Price:$0

More info Download

Description

The object is simple: stick a small common prefix in front of each database table in the catalog, so that you can easily tell one catalog from another within the same database.I've done this by:1. Adding a variable - DB_TABLE_PREFIX - to the configure.php files2. Inserting this new variable into all the define statements for the database tablesI have also:a. Modified the Backup tool to include the catalog's prefix in the file name and the header within the fileb. Added a checkbox to the Backup options enabling backup of just the tables matching the current catalog prefix, or the entire databasec. Modified the New Installation routines to capture and configure the table prefix, and to apply that prefix when loading the standard demo oscommerce shopd. Modified the Update Installation routines to cope with applying an update to a catalog that already has a prefix applied to itI have provided descriptions of the changes required for a standard 2.2MS2 release, and for a CVS release of 2.2MS1. Whether you will find the MS1 or MS2 instructions more applicable depends entirely upon your own version of osCommerce.

Language: PHP

Related:

Database - Database Tables - Oscommerce Addon - Oscommerce Prefix - Prefix - Tables

User Reviews:

Write Review *
Your name *
Email *
(Your comments will be reviewed by our staff before they are posted)
Rate this product *
Captcha Image
Enter code from image *

 

Related:

Database Schema for DB Designer 1.0

This contribution intends to provide a schema of a database for database designer software.

By: addons.oscommerce.com Homepage

Freeware

Database Update Scripts 1.0

This is a small collection of simple PHP scripts that run SQL commands to update your oscommerce "products" table.

By: addons.oscommerce.com Homepage

Freeware

WAP-enable 1.1

I have written this addon for anyone who would love to enable osCommerce to be accessible through WAP phone.

By: addons.oscommerce.com Homepage

Freeware

Import Stock from Quickbooks 1.0

Quick perl hack that uses QODBC to read the item list from quickbooks, and upload it to yoru oscommerce site.

By: addons.oscommerce.com Homepage

Freeware

Docs to Excel 1.0

Addon for oscommerce to create excel files to printout invoices, package slips and delivery document.

By: addons.oscommerce.com Homepage

Freeware

ApexSQL Clean 2.8.90

ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.If database object bloat is the...

By: Apex SQL tools

Freeware

Database Architect 2.0

Define database tables, fields, references, and generate the database. When working with Database Architect, software developer defines database...

By: Guru Developers Homepage

Shareware

DBSync for Firebird and MS SQL 1.0.0

DBSync for Firebird and MS SQL is a tool for a quick and accurate database conversion and synchronization from Firebird database to MS SQL server....

By: Dmitry Narizhnykh Homepage

Shareware

CodeThatGrid 1.(x)

CodeThatTable is an advanced JavaScript table that enables user to display in efficient and fancy way the massives of data from variety of sources...

By: aakaab Homepage

Freeware

CodeThatTable 1.(x)

CodeThatTable is an advanced JavaScript table that enables user to display in efficient and fancy way the massives of data from variety of sources...

By: aakaab Homepage

Freeware