Prefix for Database Tables 1.0

Date Added: May 10, 2013 | Visits: 587

Report Broken Link
Printer Friendly Version

Product Homepage
Download (64 downloads)

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.

Requirements: No special requirements

Platforms: Windows, *nix, Linux, PHP , BSD

Keyword: Database, Database Tables, Oscommerce Addon, Oscommerce Prefix, Prefix, Tables

Users rating: 0/10

License: Freeware

USER REVIEWS

More Reviews or Write Review

PREFIX FOR DATABASE TABLES RELATED

Libraries - Basset::DB::Table 1.04 Basset::DB::Table is used to define database tables, ways to load that data into memory and build queries based upon the table information. SYNOPSIS For example, my $table = Basset::DB::Table->new( name => user, primary_column => id,...	143.36 KB
Database Tools - PHP SQLDiff 2.2 PHP SQLDiff is a Web application that shows the difference between two SQL database tables. If you manage your database tables like I do, you also make copious copies of the tables. When I go to make any serious change to a table, I copy the...	573.44 KB
Database Tools - SQLDiff 2.2 SQLDiff is a Web application that shows the difference between two SQL database tables. It makes use of PEAR::DB for its database access and this means that most common databases should work. This application has been tested with Mysql, Postgres...
Modules - DB Toolkit 0.2.2.1 Adds interfaces to database tables on pages, posts, dashboard and custom menu groups within admin, to manage data. Build custom databased application for managing data from simple data entries to more complex linking tables.I'm running a tutorial...	2.33 MB
Modules - Views Schema 6.x-1.x-de Auto-generates table descriptions for Views based on actual database tables. Requires schema.module for gathering information about the table. Basic usage:You can augment and alter the auto-generated information by implementing...	10 KB
Database Tools - Database Copier 1.0 Database Copier can access a MySQL server, list its tables, query the table record data, connect to another MySQL server and recreate the database tables with data copied from the first database.If there are destination tables with the same name,...	10 KB
Database Tools - backup & restore database 1.0 backup & restore database can generate a backup file that contain SQL statements to create all the database tables and insert its table record data.Previously generated SQL backup files can be read and executed to restore the database tables and...	10 KB
Business - Compare Database Table Data 0.22.06 A generic SQL driven data audit tool for detecting differences between any JDBC accessible database tables and other data sources. Platform independent. It's a unix like diff for databases. Produces key values with the differing column name and data	15.53 MB
Modules - Bulk Image Assignment 0.1 After importing a 3000-product database into osCommerce, I did not have the time to go through each product and assign an image to it, so I came up with this tool to allow me to take one image and assign it to all the products in a single...
Database Tools - Closure Table 1.0 Closure Table can create MySQL database tables that will store information about hierarchies of nodes stored in other database tables.Nodes can be organized hierarchically by weight and depth by different classes. They can be inserted, deleted,...	30.72 KB

NEW DOWNLOADS IN SCRIPTS, MODULES

Scripts - Free Ecommerce website creator 1.2 Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...	1.44 KB
Scripts - MochiGames PHP Script ZDR 1.00 MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...	368.54 KB
Scripts - Php Chat 2.0 Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....	938.87 KB
Scripts - Nibbleblog 3.0.1 Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....	371.09 KB
Scripts - PHP File Manager \| CloudOsys 2.9b8 CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...	1.41 MB
Modules - TinyMCE Node Picker 6.x-2.1 This module will de discontinued and replaced with Node Picker as soon as a stable release is available.TinyMCE Node Picker provides a button in TinyMCE that displays a list of links to content. Choosing a link inserts it into the editor.The...	20.48 KB
Modules - Fapilicious 5.x-1.x-de Fapilicious is a collection of FormAPI goodies.I hope to make it a repository of reusable FormAPI trickery and short cuts. Currently it has small collection of powerful FormAPI element validators.Please submit your favorite tricks as patches so we...	10 KB
Modules - Donation Goals 6.x-1.x-de The Donation Goals module lets you create nodes of the type "Donation Goal." These goals allow you to set an amount of money you'll need for whatever you're saving up for. Visitors of the site can then donate money through PayPal. Once the target...	20.48 KB
Modules - Plica Twitter 1.0.1 Plica TwitterInstallation : * Download, unzip, and install plugin dir in /wp-content/plugins * Activate * All right now	10 KB
Modules - Page Array 5.x-1.x-de The pagearray module is a small (single function) helper module that can be used whenever there is a need to load the output of any Drupal path in data form. Based on the code in index.php, Page Array bypasses the theme('page') call, instead...	10 KB

Windows Software	BeOS Software
Macintosh Software	Linux Software
PDA Software	OS/2 Software
Mobile Software	Scripts