Da ne pomislis da se mi ovde samo zezamo evo ti mali primer kako bi mogao da resis bazu:
Code:
#
# Table structure for table 'articles'
#
DROP TABLE IF EXISTS articles;
CREATE TABLE `articles` (
`article_id` int(10) unsigned NOT NULL auto_increment,
`description` varchar(60) NOT NULL default '',
`price` float NOT NULL default '0',
PRIMARY KEY (`article_id`)
) ENGINE=MyISAM;
#
# Table structure for table 'customers'
#
DROP TABLE IF EXISTS customers;
CREATE TABLE `customers` (
`customer_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`surname` varchar(35) NOT NULL default '',
`address` varchar(60) NOT NULL default '',
`city` varchar(25) NOT NULL default '',
`zip` varchar(8) NOT NULL default '',
`state` varchar(25) NOT NULL default '',
`country` varchar(35) NOT NULL default '',
PRIMARY KEY (`customer_id`)
) ENGINE=MyISAM;
#
# Table structure for table 'order_items'
#
DROP TABLE IF EXISTS order_items;
CREATE TABLE `order_items` (
`order_item_id` int(10) unsigned NOT NULL auto_increment,
`order_id` int(10) unsigned NOT NULL default '0',
`article_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`order_item_id`)
) ENGINE=MyISAM;
#
# Table structure for table 'orders'
#
DROP TABLE IF EXISTS orders;
CREATE TABLE `orders` (
`order_id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned NOT NULL default '0',
`date` timestamp(14) NOT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM;
Ovo je, naravno samo primer. U konkretnoj implementaciji verovatno mora da se prosiruje.
Kao sto vec rekose, ako hoces da u istoj fizickoj bazi drzis vise 'baza' onda svim tabelama koej pripadajujednoj bazi stavi neki prefiks, za ovu namenu recimo tabele mozes zvati shop_articles, shop_customers, shop_order_items i shop_orders