[countll]

i got 2 script which i wannto combine it to 1..i mean put it into 1 folder to my public_html...
theres 2 database.sql to be upload to mysql database...
can i just copy nad paste make it to 1?
is it will overide in the mysql?


here is the database...

# phpMyAdmin MySQL-Dump
#
# Table structure for table `admin`
#
 
DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
  user varchar(100) NOT NULL DEFAULT '',
  pass varchar(100) NOT NULL DEFAULT ''
) TYPE=MyISAM;
 
INSERT INTO admin VALUES ( 'adnet', '*******'); 
 
# --------------------------------------------------------
 
#
# Table structure for table `affiliates`
#
 
DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
  refid varchar(30) NOT NULL DEFAULT '',
  pass varchar(20) NOT NULL DEFAULT '',
  company varchar(100) NOT NULL DEFAULT '',
  title varchar(5) NOT NULL DEFAULT '',
  firstname varchar(40) NOT NULL DEFAULT '',
  lastname varchar(40) NOT NULL DEFAULT '',
  website varchar(100) NOT NULL DEFAULT '',
  email varchar(100) NOT NULL DEFAULT '',
  payableto varchar(100) NOT NULL DEFAULT '',
  street varchar(100) NOT NULL DEFAULT '',
  town varchar(100) NOT NULL DEFAULT '',
  county varchar(100) NOT NULL DEFAULT '',
  postcode varchar(20) NOT NULL DEFAULT '',
  country varchar(100) NOT NULL DEFAULT '',
  phone varchar(30) NOT NULL DEFAULT '',
  fax varchar(30) NOT NULL DEFAULT '',
  date varchar(40) NOT NULL DEFAULT ''
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `banners`
#
 
DROP TABLE IF EXISTS banners;
CREATE TABLE banners (
  number int(3) NOT NULL AUTO_INCREMENT,
  name varchar(50) NOT NULL DEFAULT '',
  image varchar(60) NOT NULL DEFAULT '',
  description varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY  (number)
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `clickthroughs`
#
 
DROP TABLE IF EXISTS clickthroughs;
CREATE TABLE clickthroughs (
  refid varchar(20) DEFAULT 'none',
  date date NOT NULL DEFAULT '0000-00-00',
  time time NOT NULL DEFAULT '00:00:00',
  browser varchar(200) DEFAULT 'Could Not Find This Data',
  ipaddress varchar(50) DEFAULT 'Could Not Find This Data',
  refferalurl varchar(200) DEFAULT 'none detected (maybe a direct link)',
  buy varchar(10) DEFAULT 'NO'
) TYPE=MyISAM;
# --------------------------------------------------------
 
#
# Table structure for table `sales`
#
 
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
  refid varchar(20) NOT NULL DEFAULT '',
  date date NOT NULL DEFAULT '0000-00-00',
  time time NOT NULL DEFAULT '00:00:00',
  browser varchar(100) NOT NULL DEFAULT '',
  ipaddress varchar(20) NOT NULL DEFAULT '',
  payment varchar(10) NOT NULL DEFAULT ''
) TYPE=MyISAM; 

AND THIS>>>>

CREATE TABLE `admin` (
  `AdminID` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '',
  `PASSWORD` varchar(32) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`AdminID`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `banners`
#
 
CREATE TABLE `banners` (
  `BannerID` int(10) NOT NULL AUTO_INCREMENT,
  `BannerFile` text NOT NULL,
  `BannerAlt` varchar(255) NOT NULL DEFAULT '',
  `BannerURL` text NOT NULL,
  PRIMARY KEY  (`BannerID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `cart`
#
 
CREATE TABLE `cart` (
  `OrderID` varchar(32) NOT NULL DEFAULT '',
  `ItemID` int(10) NOT NULL DEFAULT '0',
  `ItemPrice` float(10,2) NOT NULL DEFAULT '0.00',
  `ItemQty` int(10) NOT NULL DEFAULT '0',
  `ItemTotal` float(10,2) NOT NULL DEFAULT '0.00',
  `download_status` char(1) NOT NULL DEFAULT 'n'
) TYPE=MyISAM;
 
# --------------------------------------------------------
 
#
# Table structure for table `categories`
#
 
CREATE TABLE `categories` (
  `CategoryID` int(10) NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`CategoryID`),
  UNIQUE KEY `CategoryName` (`CategoryName`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `items`
#
 
CREATE TABLE `items` (
  `ItemID` int(10) NOT NULL AUTO_INCREMENT,
  `ItemName` varchar(255) NOT NULL DEFAULT '',
  `ItemDesc` text NOT NULL,
  `ItemPrice` float(10,2) NOT NULL DEFAULT '0.00',
  `ItemImage` text NOT NULL,
  `DownloadURL` text NOT NULL,
  `ItemCategory` int(10) NOT NULL DEFAULT '0',
  `ItemSubcategory` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`ItemID`),
  UNIQUE KEY `ItemName` (`ItemName`)
) TYPE=MyISAM AUTO_INCREMENT=88 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `links`
#
 
CREATE TABLE `links` (
  `LinkID` int(10) NOT NULL AUTO_INCREMENT,
  `LinkName` varchar(255) NOT NULL DEFAULT '',
  `LinkURL` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`LinkID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `newsletter`
#
 
CREATE TABLE `newsletter` (
  `nemail` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY  (`nemail`)
) TYPE=MyISAM;
 
# --------------------------------------------------------
 
#
# Table structure for table `orders_info`
#
 
CREATE TABLE `orders_info` (
  `OrderID` int(10) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(100) NOT NULL DEFAULT '',
  `LastName` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `order_paid` char(1) NOT NULL DEFAULT 'n',
  `order_date` int(10) NOT NULL DEFAULT '0',
  `order_total` float(10,2) NOT NULL DEFAULT '0.00',
  `ExpDate` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`OrderID`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
 
# --------------------------------------------------------
 
#
# Table structure for table `settings`
#
 
CREATE TABLE `settings` (
  `id` int(1) NOT NULL DEFAULT '0',
  `SiteName` text NOT NULL,
  `SiteTitle` text NOT NULL,
  `SiteKeywords` text NOT NULL,
  `SiteDesc` text NOT NULL,
  `help` text NOT NULL,
  `PayPalEmail` varchar(255) NOT NULL DEFAULT '',
  `ContactEmail` varchar(255) NOT NULL DEFAULT '',
  `currency_id` varchar(50) NOT NULL DEFAULT 'USD',
  `currency_sign` varchar(20) NOT NULL DEFAULT '$',
  `download_days` int(3) NOT NULL DEFAULT '14',
  `sp_payee_email` varchar(255) NOT NULL DEFAULT '',
  `sp_vendor_email` varchar(255) NOT NULL DEFAULT '',
  `sp_secret_code` varchar(255) NOT NULL DEFAULT ''
) TYPE=MyISAM;
 
# --------------------------------------------------------
 
#
# Table structure for table `subcategories`
#
 
CREATE TABLE `subcategories` (
  `SubcategoryID` int(10) NOT NULL AUTO_INCREMENT,
  `SubcategoryName` varchar(255) NOT NULL DEFAULT '',
  `CategoryID` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`SubcategoryID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; 

please help me dive in it.thanks....

[NeverMind]

since there are 2 tables with the same name (admin, banner) then you can't put them in one database unless you rename them in one of the script and then trace all the occurences in the script that uses them and rename them there as well.
Then you also have to make sure that the script files themselves don't have names conflicts.

[Sxooter]

Since MySQL kinda treats databases like postgresql and oracle do schemas (i.e. you can do cross db joins and such in mysql) is there a real big reason to want to put them into the same db?

If not, you can leave them in separate dbs and they should be fine.

otherwise you're gonna have to do something to tell the table(s) with the same name apart, i.e. rename them and edit all the code that accesses them, which can be error prone.