# <?-- mysql_dump_file
#	Copyright (c) 2002 by AP Mall (http://www.apmall.com)
#	apmall.sql version 1.0.0 (Horsey)
#----------------------------------------------------------------#
# 	Host: localhost    Database: Horsey
# 	MySQL Server version	3.22.32
#----------------------------------------------------------------#
# Table structure for table 'userh' -- home user 
#drop table userh;
#
CREATE TABLE userh (
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod, halt, del) 
 datec datetime,
 datem datetime,
 datel datetime,
 numlog int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------login & pwd
 email varchar(60) DEFAULT '' NOT NULL,
 pwd varchar(32) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 title varchar(6) DEFAULT '' NOT NULL,
 firstname varchar(32) DEFAULT '' NOT NULL,
 midname varchar(1),
 lastname varchar(32) DEFAULT '' NOT NULL,
 dob varchar(10) DEFAULT '' NOT NULL,
#---------------------------------------------------------home contact (primary shipping address)
 addressh varchar(255) DEFAULT '' NOT NULL,
 zipcodeh varchar(10) DEFAULT '' NOT NULL, 
 phoneh varchar(15) DEFAULT '' NOT NULL,
 shiprateh decimal(5,2) DEFAULT '1.00' NOT NULL,
#---------------------------------------------------------work contact (secondary shipping address)
 addressw varchar(255),
 zipcodew varchar(10), 
 phonew varchar(15),
 extw varchar(8),
 shipratew decimal(5,2) DEFAULT '1.00' NOT NULL,
#---------------------------------------------------------account present
 limits double(16,4) DEFAULT '0' NOT NULL,
 credit double(16,4) DEFAULT '0' NOT NULL,
 fill double(16,4) DEFAULT '0' NOT NULL,
 onorder double(16,4) DEFAULT '0' NOT NULL,
 power double(16,4) DEFAULT '0' NOT NULL,
 balance double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------account total
 price double(16,4) DEFAULT '0' NOT NULL,
 bid double(16,4) DEFAULT '0' NOT NULL,
 save double(16,4) DEFAULT '0' NOT NULL,
 creditt double(16,4) DEFAULT '0' NOT NULL,
 ship double(16,4) DEFAULT '0' NOT NULL,
 tax double(16,4) DEFAULT '0' NOT NULL,
 due double(16,4) DEFAULT '0' NOT NULL,
 paid double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------credit rating
 rating varchar(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (uhid)
);
# Table structure for table 'listh' -- home user shopping list
#drop table listh;
#
CREATE TABLE listh (
 lhid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, old) 
 datec datetime,
 datem datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (lhid)
);
# Table structure for table 'listhp' -- home user products on shopping list
#drop table listhp;
#
CREATE TABLE listhp (
 datec datetime,
#---------------------------------------------------------general
 lhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 prid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL
);
# Table structure for table 'ratingh' -- home user's company rating
#drop table ratingh;
#
CREATE TABLE ratingh (
 crid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status
 datec datetime,
 datem datetime,
#---------------------------------------------------------general
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 rating char(1) DEFAULT '' NOT NULL,
 comment char(255) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (crid)
);
# Table structure for table 'cardh' -- home user credit card/bank card info
#drop table cardh;
#
CREATE TABLE cardh (
 chid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, old) 
 datec datetime,
 datem datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 type varchar(1) DEFAULT '' NOT NULL,
 num varchar(19) DEFAULT '' NOT NULL,
 expire varchar(5) DEFAULT '' NOT NULL,
 extra text,
#---------------------------------------------------------key & index
 PRIMARY KEY (chid)
);
# Table structure for table 'userb' -- business user info
#drop table userb;
#
CREATE TABLE userb (
 ubid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod, halt, del)
 datec datetime,
 datem datetime,
 datel datetime,
 numlog  int(10) UNSIGNED DEFAULT '0'  NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#----------------------------------------------------------login pwd
 email varchar(60) DEFAULT '' NOT NULL,
 pwd varchar(32) DEFAULT '' NOT NULL,
#----------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 title varchar(6) DEFAULT '' NOT NULL,
 firstname varchar(32) DEFAULT '' NOT NULL,
 midname varchar(1),
 lastname varchar(32) DEFAULT '' NOT NULL,
 position varchar(32) DEFAULT '' NOT NULL,
#----------------------------------------------------------access
 IVie int(1) DEFAULT '0' NOT NULL, 
 VCos int(1) DEFAULT '0' NOT NULL,
 PEdi int(1) DEFAULT '0' NOT NULL, 
 PDel int(1) DEFAULT '0' NOT NULL, 
 PNew int(1) DEFAULT '0' NOT NULL, 
 MCat int(1) DEFAULT '0' NOT NULL, 
 MUni int(1) DEFAULT '0' NOT NULL, 
 VOrd int(1) DEFAULT '0' NOT NULL, 
 OFil int(1) DEFAULT '0' NOT NULL, 
 ORej int(1) DEFAULT '0' NOT NULL, 
 OShi int(1) DEFAULT '0' NOT NULL, 
 OVoi int(1) DEFAULT '0' NOT NULL,
 MRej int(1) DEFAULT '0' NOT NULL,
 MVoi int(1) DEFAULT '0' NOT NULL,
 MUsr int(1) DEFAULT '0' NOT NULL,
 MCom int(1) DEFAULT '0' NOT NULL,
 MAcc int(1) DEFAULT '0' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (ubid)
);
# Table structure for table 'ratingb' -- home user company rating
#drop table ratingb;
#
CREATE TABLE ratingb (
 rbid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status
 datec datetime,
 datem datetime,
#---------------------------------------------------------general
 ubid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 caid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 rating char(1) DEFAULT '' NOT NULL,
 comment char(255) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (rbid)
);
# Table structure for table 'company' -- company info
#drop table company;
#
CREATE TABLE company (
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
 csid int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------status(new, ok, mod, halt, del) 
 datec datetime,
 datem datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#----------------------------------------------------------general
 names varchar(30) DEFAULT '' NOT NULL,
 namef varchar(255) DEFAULT '' NOT NULL,
 regnum varchar(20) DEFAULT '' NOT NULL,
 abstract varchar(255) DEFAULT '' NOT NULL,
 logo varchar(20) DEFAULT '' NOT NULL,
 rating varchar(20) DEFAULT '' NOT NULL,
 type varchar(50) DEFAULT '' NOT NULL,
#----------------------------------------------------------address
 address varchar(255) DEFAULT '' NOT NULL,
 zipcode varchar(10) DEFAULT '' NOT NULL,
 phone varchar(15) DEFAULT '' NOT NULL,
 ext varchar(8),
 fax varchar(15),
#----------------------------------------------------------administrator & contact
 title varchar(6) DEFAULT '' NOT NULL,
 firstname varchar(32) DEFAULT '' NOT NULL,
 midname varchar(1),
 lastname varchar(32) DEFAULT '' NOT NULL,
 position varchar(32) DEFAULT '' NOT NULL,
 addressc varchar(255) DEFAULT '' NOT NULL,
 zipcodec varchar(10) DEFAULT '' NOT NULL,
 phonec varchar(15) DEFAULT '' NOT NULL,
 extc varchar(8),
 faxc varchar(15),
 email varchar(60) DEFAULT '' NOT NULL,
#---------------------------------------------------------account present
 credit double(16,4) DEFAULT '0' NOT NULL,
 recievable double(16,4) DEFAULT '0' NOT NULL,
 fee double(16,4) DEFAULT '0' NOT NULL,
 balance double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------account total
 price double(16,4) DEFAULT '0' NOT NULL,
 fill double(16,4) DEFAULT '0' NOT NULL,
 cost double(16,4) DEFAULT '0' NOT NULL,
 profit double(16,4) DEFAULT '0' NOT NULL,
 tax double(16,4) DEFAULT '0' NOT NULL,
 feet double(16,4) DEFAULT '0' NOT NULL,
 creditt double(16,4) DEFAULT '0' NOT NULL,
 paid double(16,4) DEFAULT '0' NOT NULL,
 recievablet double(16,4) DEFAULT '0' NOT NULL,
 recieved double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------user statics
 numu int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------inventory statics
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numactive int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numout int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numnew int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numsale int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numfeature int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numcat int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numscat int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numunit int(10) UNSIGNED DEFAULT '0' NOT NULL,
 #---------------------------------------------------------product sale statics
 numo int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numexpire int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numfill int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numreject int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numship int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numvoid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numrejectr int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numvoidr int(10) UNSIGNED DEFAULT '0' NOT NULL,
#----------------------------------------------------------return policy & disclaimer
 disclaimer text,
 policyr text,
#----------------------------------------------------------accepted payment
 payment varchar(20) DEFAULT '' NOT NULL,
#----------------------------------------------------------customer service email
 cemail varchar(60) DEFAULT '' NOT NULL,
#---------------------------------------------------------hit statics
 numhit int(10) UNSIGNED DEFAULT '0' NOT NULL,
#----------------------------------------------------------accept order
 via varchar(20) DEFAULT '' NOT NULL,
 toll varchar(40) DEFAULT '' NOT NULL,
 discount int(2) DEFAULT '99' NOT NULL,
#---------------------------------------------------------links
 urlweb text,
 urlmap text,
#---------------------------------------------------------key & index
 PRIMARY KEY (cpid)
);
## Table structure for table 'catb' -- biz user defined categories
#drop table catb;
#
CREATE TABLE catb (
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
 cmid int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 numsub int(10) UNSIGNED DEFAULT '0' NOT NULL,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numactive int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(40) DEFAULT '' NOT NULL, 
 abstract varchar(80) DEFAULT '' NOT NULL, 
 type varchar(50) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (cbid)
);
## Table structure for table 'scatb' -- biz user defined sub-categories
#drop table scatb;
#
CREATE TABLE scatb (
 scid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numactive int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(40) DEFAULT '' NOT NULL, 
 abstract varchar(80) DEFAULT '' NOT NULL, 
#---------------------------------------------------------key & index
 PRIMARY KEY (scid)
);
## Table structure for table 'unit' -- biz user defined units
#drop table unitb;
#
CREATE TABLE unitb (
 unid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status
 datec datetime,
 datem datetime,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(15) DEFAULT '' NOT NULL, 
 abstract varchar(30) DEFAULT '' NOT NULL, 
#---------------------------------------------------------key & index
 PRIMARY KEY (unid)
);
## Table structure for table 'reject' -- biz user defined reasons for reject orders
#drop table rejectb;
#
CREATE TABLE rejectb (
 rjid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 numo int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(20) DEFAULT '' NOT NULL, 
 abstract varchar(50) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (rjid)
);
## Table structure for table 'void' -- biz user defined reasons for void orders
#drop table voidb;
#
CREATE TABLE voidb (
 vdid int(11) DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 numo int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(20) DEFAULT '' NOT NULL, 
 abstract varchar(50) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (vdid)
);
# Table structure for table 'product' -- product & inventory info
#
#drop table product;
#
CREATE TABLE product (
 prid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status(new, ok, sale, feature, out, del) 
 datec datetime,
 datem datetime,
 onlist int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numlist int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numorder int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status char(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(50) DEFAULT '' NOT NULL,
 catalog varchar(20) DEFAULT '' NOT NULL,
 barcode varchar(20) DEFAULT '' NOT NULL,
 trademark varchar(50) DEFAULT '' NOT NULL,
 manufacturer varchar(50) DEFAULT '' NOT NULL,
 model varchar(40) DEFAULT '' NOT NULL,
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 scid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 image varchar(20) DEFAULT '' NOT NULL, 
 abstract varchar(255) DEFAULT '' NOT NULL,
 detail text,
 weight varchar(20) DEFAULT '' NOT NULL, 
 rating varchar(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------unit & pricing
 unit varchar(26) DEFAULT '' NOT NULL,
 minorder int(5) UNSIGNED DEFAULT '0' NOT NULL,
 increment int(5) UNSIGNED DEFAULT '0' NOT NULL,
 cost decimal(10,2) DEFAULT '0.00' NOT NULL,
 price decimal(10,2) DEFAULT '0.00' NOT NULL,
 taxrate int(2) DEFAULT '0' NOT NULL,
 prices decimal(10,2) DEFAULT '0.00' NOT NULL,
 percents int(2) DEFAULT '0' NOT NULL,
#---------------------------------------------------------inventory
 instock int(10) UNSIGNED DEFAULT '0' NOT NULL,
 onorder int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (prid)
);
# Table structure for table 'orders' -- order info
#
#drop table orders;
#
CREATE TABLE orders (
 orid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status 
#--(open, filled, rejected, expired, cancelled, shipping, void, delivered, failed)
 datec datetime,
 datem datetime,
 datee datetime,
 datef datetime,
 dates datetime,
 dater datetime,
 datev datetime,
 dated datetime,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
 pay varchar(2) DEFAULT '0' NOT NULL, 
#---------------------------------------------------------general
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 type varchar(10) DEFAULT '' NOT NULL, 
 prid text DEFAULT '' NOT NULL, 
 name text DEFAULT '' NOT NULL,
 catalog text DEFAULT '' NOT NULL,
 barcode text DEFAULT '' NOT NULL,
 trademark text DEFAULT '' NOT NULL,
 model text DEFAULT '' NOT NULL,
 qty text DEFAULT '' NOT NULL, 
 unit text DEFAULT '' NOT NULL, 
 price text DEFAULT '' NOT NULL,
 pricesub text DEFAULT '' NOT NULL,
 costsub text DEFAULT '' NOT NULL,
 taxrate text DEFAULT '' NOT NULL, 
#---------------------------------------------------------total
 pricet double(16,4) DEFAULT '0' NOT NULL,
 costt double(16,4) DEFAULT '0' NOT NULL,
 discountp int(2) DEFAULT '0' NOT NULL,
 discountv double(16,4) DEFAULT '0' NOT NULL,
 bidt double(16,4) DEFAULT '0' NOT NULL,
 profit double(16,4) DEFAULT '0' NOT NULL,
 margin int(2) DEFAULT '0' NOT NULL,
 ship double(16,4) DEFAULT '0' NOT NULL,
 tax double(16,4) DEFAULT '0' NOT NULL,
 debt double(16,4) DEFAULT '0' NOT NULL,
 address varchar(160) DEFAULT '' NOT NULL,
 #---------------------------------------------------------record
 fillby int(10) UNSIGNED DEFAULT '0' NOT NULL,
 rejectby int(10) UNSIGNED DEFAULT '0' NOT NULL,
 voidby int(10) UNSIGNED DEFAULT '0' NOT NULL,
 shipby int(10) UNSIGNED DEFAULT '0' NOT NULL,
 deliverby int(10) UNSIGNED DEFAULT '0' NOT NULL,
 reject varchar(32),
 void varchar(32),
 carrier varchar(30) DEFAULT '' NOT NULL,
 weight varchar(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (orid)
);
# Table structure for table 'note' -- home user order 's note 
#
#drop table note;
#
CREATE TABLE note (
 orid int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------status 
#--(open, filled, rejected, expired, cancelled, shipping, void, delivered, failed)
 datem datetime,
 datev datetime,
 dated datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 note text,
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL
);
## Table structure for table 'userc' -- carrier's user info
#drop table userc;
#
CREATE TABLE userc (
 ucid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod, halt, del)
 datec datetime,
 datem datetime,
 datel datetime,
 numlog  int(10) UNSIGNED DEFAULT '0'  NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#----------------------------------------------------------login pwd
 email varchar(60) DEFAULT '' NOT NULL,
 pwd varchar(32) DEFAULT '' NOT NULL,
#----------------------------------------------------------general
 caid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 title varchar(6) DEFAULT '' NOT NULL,
 firstname varchar(32) DEFAULT '' NOT NULL,
 midname varchar(1),
 lastname varchar(32) DEFAULT '' NOT NULL,
 position varchar(32) DEFAULT '' NOT NULL,
#----------------------------------------------------------access
 OShi int(1) DEFAULT '0' NOT NULL, 
 MUsr int(1) DEFAULT '0' NOT NULL,
 MCom int(1) DEFAULT '0' NOT NULL,
 MAcc int(1) DEFAULT '0' NOT NULL, 
#---------------------------------------------------------key & index
 PRIMARY KEY (ucid)
);
# Table structure for table 'carrier' -- carrier company info
#drop table carrier;
#
CREATE TABLE carrier (
 caid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod, halt, del)
 datec datetime,
 datem datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#----------------------------------------------------------general
 names varchar(30) DEFAULT '' NOT NULL,
 namef varchar(255) DEFAULT '' NOT NULL,
 regnum varchar(50) DEFAULT '' NOT NULL,
 abstract varchar(255) DEFAULT '' NOT NULL,
 detail text DEFAULT '' NOT NULL,
 logo varchar(20) DEFAULT '' NOT NULL,
 rating varchar(20) DEFAULT '' NOT NULL,
 type int(1) DEFAULT '0' NOT NULL,
#----------------------------------------------------------address
 address varchar(255) DEFAULT '' NOT NULL,
 zipcode varchar(10) DEFAULT '' NOT NULL,
 phone varchar(15) DEFAULT '' NOT NULL,
 ext varchar(8),
 fax varchar(15),
#----------------------------------------------------------administrator & contact
 title varchar(6) DEFAULT '' NOT NULL,
 firstname varchar(32) DEFAULT '' NOT NULL,
 midname varchar(1),
 lastname varchar(32) DEFAULT '' NOT NULL,
 position varchar(32) DEFAULT '' NOT NULL,
 addressc varchar(255) DEFAULT '' NOT NULL,
 zipcodec varchar(10) DEFAULT '' NOT NULL,
 phonec varchar(15) DEFAULT '' NOT NULL,
 extc varchar(8),
 faxc varchar(15),
 email varchar(60) DEFAULT '' NOT NULL,
#---------------------------------------------------------account present
 credit double(16,4) DEFAULT '0' NOT NULL,
 recievable double(16,4) DEFAULT '0' NOT NULL,
 fee double(16,4) DEFAULT '0' NOT NULL,
 balance double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------account total
 numo int(10) UNSIGNED DEFAULT '0' NOT NULL,
 bid double(16,4) DEFAULT '0' NOT NULL,
 weight double(16,4) DEFAULT '0' NOT NULL,
 creditt double(16,4) DEFAULT '0' NOT NULL,
 feet double(16,4) DEFAULT '0' NOT NULL,
 recievablet double(16,4) DEFAULT '0' NOT NULL,	
 recieved double(16,4) DEFAULT '0' NOT NULL,
 paid double(16,4) DEFAULT '0' NOT NULL,
#---------------------------------------------------------user
 numu int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------customer service email
 cemail varchar(60) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (caid)
);
# Table structure for table 'ads' -- classified ads info
#
#drop table ads;
#
CREATE TABLE ads (
 adid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status(ok, expire, remove) 
 datec datetime,
 datem datetime,
 status char(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 uhid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(50) DEFAULT '' NOT NULL,
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 scid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 detail text,
#---------------------------------------------------------links
 urlweb text,
 urlimg text,
#---------------------------------------------------------key & index
 PRIMARY KEY (adid)
);
## Table structure for table 'cata' -- mall owner defined categories for classified ads
#drop table cata;
#
CREATE TABLE cata (
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 numsub int(10) UNSIGNED DEFAULT '0' NOT NULL,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 name varchar(40) DEFAULT '' NOT NULL, 
 abstract varchar(255) DEFAULT '' NOT NULL,
 type varchar(20) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (cbid)
);
## Table structure for table 'scata' -- mall owner defined sub-categories for classified ads
#drop table scata;
#
CREATE TABLE scata (
 scid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 cbid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 name varchar(40) DEFAULT '' NOT NULL, 
 abstract varchar(255) DEFAULT '' NOT NULL, 
#---------------------------------------------------------key & index
 PRIMARY KEY (scid)
);
## Table structure for table 'shiprate' -- mall owner defined shipping rate
#drop table shiprate;
#
CREATE TABLE shiprate (
 srid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (ok)
 datec datetime,
 datem datetime,
 numu int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------rate
 zipcode varchar(10) DEFAULT '' NOT NULL,
 street varchar(255) DEFAULT '' NOT NULL,
 rate decimal(5,2) DEFAULT '1.00' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (srid)
);
## Table structure for table 'seclog' -- web security related log
#drop table seclog;
#
CREATE TABLE seclog (
 slid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (admin, intruder, hack)
 datec datetime,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------logged info
 browser varchar(64) DEFAULT '' NOT NULL,
 ip varchar(15) DEFAULT '' NOT NULL,
 host varchar(64) DEFAULT '' NOT NULL,
 referer varchar(64) DEFAULT '' NOT NULL,
 page varchar(32) DEFAULT '' NOT NULL,
 err varchar(64) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (slid)
);
## Table structure for table 'banner' -- ad banners
#drop table banner;
#
CREATE TABLE banner (
 bnid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (ok, finish)
 datec datetime,
 datef datetime,
 status varchar(10) DEFAULT '' NOT NULL,
#---------------------------------------------------------general (ctype - com, car, ext, lan, su; shown - y, n; ltype - i, e)
 ctype varchar(10) DEFAULT '' NOT NULL,
 clid int(10) UNSIGNED DEFAULT '0' NOT NULL,
 imgurl varchar(100) DEFAULT '' NOT NULL,
 clickurl varchar(200) DEFAULT '' NOT NULL,
 total int(10) UNSIGNED DEFAULT '0' NOT NULL,
 made int(10) UNSIGNED DEFAULT '0' NOT NULL,
 click int(10) UNSIGNED DEFAULT '0' NOT NULL,
 shown varchar(1) DEFAULT '' NOT NULL,
 ltype varchar(10) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (bnid)
);
## Table structure for table 'companyallow' -- store's allowed users, products, etc.
#drop table companyallow;
#
CREATE TABLE companyallow (
 cpid int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------general
 product int(10) UNSIGNED DEFAULT '0' NOT NULL,
 cat int(10) UNSIGNED DEFAULT '0' NOT NULL,
 scat int(10) UNSIGNED DEFAULT '0' NOT NULL,
 unit int(10) UNSIGNED DEFAULT '0' NOT NULL,
 reject int(10) UNSIGNED DEFAULT '0' NOT NULL,
 void int(10) UNSIGNED DEFAULT '0' NOT NULL,
 user int(10) UNSIGNED DEFAULT '1' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (cpid)
);
## Table structure for table 'carrierallow' -- carrier's allowed users.
#drop table carrierallow;
#
CREATE TABLE carrierallow (
 caid int(10) UNSIGNED DEFAULT '0' NOT NULL,
#---------------------------------------------------------general
 user int(10) UNSIGNED DEFAULT '1' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (caid)
);
## Table structure for table 'catm' -- mall owner defined categories
#drop table catm;
#
CREATE TABLE catm (
 cmid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 nump int(10) UNSIGNED DEFAULT '0' NOT NULL,
 numactive int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 name varchar(40) DEFAULT '' NOT NULL,
 path varchar(255) DEFAULT '' NOT NULL,
 abstract varchar(255) DEFAULT '' NOT NULL, 
 type varchar(50) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (cmid)
);
## Table structure for table 'cats' -- mall owner defined store categories
#drop table cats;
#
CREATE TABLE cats (
 csid int(10) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
#---------------------------------------------------------status (new, ok, mod)
 datec datetime,
 datem datetime,
 nums int(10) UNSIGNED DEFAULT '0' NOT NULL,
 status varchar(15) DEFAULT '' NOT NULL,
#---------------------------------------------------------general
 name varchar(40) DEFAULT '' NOT NULL,
 path varchar(255) DEFAULT '' NOT NULL,
 abstract varchar(255) DEFAULT '' NOT NULL, 
 type varchar(50) DEFAULT '' NOT NULL,
#---------------------------------------------------------key & index
 PRIMARY KEY (csid)
);