【SQL开源代码栏目提醒】:本文主要为网学会员提供FreeWebshop.sql,希望对需要FreeWebshop.sql网友有所帮助,学习一下!
-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 05, 2006 at 12:08 PM
-- Server version: 4.0.25
--
PHP Version: 4.4.2
--
-- --------------------------------------------------------
--
-- Table structure for table `basket`
--
DROP TABLE IF EXISTS `basket`;
CREATE TABLE `basket` (
`ID` int(11) NOT NULL auto_increment,
`CUSTOMERID` int(11) NOT NULL default '0',
`PRODUCTID` varchar(60) NOT NULL default '0',
`STATUS` varchar(15) NOT NULL default '',
`ORDERID` int(11) NOT NULL default '0',
`LINEADDDATE` varchar(20) NOT NULL default '',
`QTY` int(11) NOT NULL default '1',
`DESCRIPTION` varchar(255) NOT NULL default '',
`PRICE` double NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`ID` int(11) NOT NULL auto_increment,
`DESC` varchar(40) NOT NULL default '',
`GROUPID` varchar(11) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Table structure for table `customer`
--
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`ID` int(11) NOT NULL auto_increment,
`LOGINNAME` varchar(20) NOT NULL default '',
`PASSWORD` varchar(15) NOT NULL default '',
`LASTNAME` varchar(50) NOT NULL default '',
`MIDDLENAME` varchar(10) NOT NULL default '',
`INITIALS` varchar(10) NOT NULL default '',
`IP` varchar(20) NOT NULL default '',
`ADDRESS` varchar(100) NOT NULL default '',
`ZIP` varchar(20) NOT NULL default '',
`CITY` varchar(75) NOT NULL default '',
`PHONE` varchar(30) NOT NULL default '',
`EMAIL` varchar(75) NOT NULL default '',
`GROUP` varchar(15) NOT NULL default 'CUSTOMER',
`COUNTRY` varchar(75) NOT NULL default '',
`COMPANY` varchar(75) NOT NULL default '',
`JOINDATE` varchar(20) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` VALUES (1, 'admin', 'admin_1234', 'ADMIN', '', 'A', '', 'Test address 12', '1234 TT', 'Amsterdam', '012344-323', 'webmaster@yourdomain.com', 'ADMIN', 'Netherlands', '', '');
--
-- Table structure for table `group`
--
DROP TABLE IF EXISTS `group`;
CREATE TABLE `groups` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(30) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Table structure for table `order`
--
DROP TABLE IF EXISTS `order`;
CREATE TABLE `orders` (
`ID` int(11) NOT NULL auto_increment,
`DATE` varchar(20) NOT NULL default '',
`STATUS` tinyint(1) NOT NULL default '0',
`SHIPPING` tinyint(1) NOT NULL default '0',
`PAYMENT` tinyint(1) NOT NULL default '0',
`CUSTOMERID` int(11) NOT NULL default '0',
`TOPAY` double NOT NULL default '0',
`WEBID` varchar(25) default NULL,
`NOTES` longtext,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Table structure for table `product`
--
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`ID` int(11) NOT NULL auto_increment,
`PRODUCTID` varchar(60) NOT NULL default '0',
`CATID` int(11) NOT NULL default '0',
`DESCRIPTION` longtext NOT NULL,
`PRICE` double NOT NULL default '0',
`STOCK` int(1) default NULL,
`FRONTPAGE` tinyint(1) NOT NULL default '0',
`NEW` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
`theme` varchar(50) default NULL,
`send_default_country` varchar(50) default NULL,
`sendcosts_default_country` double default NULL,
`sendcosts_other_country` double default NULL,
`rembours_costs` double default NULL,
`currency` varchar(10) default NULL,
`currency_symbol` varchar(10) default NULL,
`paymentdays` tinyint(4) default NULL,
`vat` double default NULL,
`show_vat` varchar(10) default NULL,
`db_prices_including_vat` tinyint(1) default NULL,
`sales_mail` varchar(50) default NULL,
`shopname` varchar(100) default NULL,
`shopurl` varchar(100) default NULL,
`default_lang` char(2) default NULL,
`order_prefix` varchar(10) default NULL,
`order_suffix` varchar(10) default NULL,
`stock_enabled` tinyint(1) default NULL,
`ordering_enabled` tinyint(1) default NULL,
`shop_disabled` tinyint(1) default NULL,
`shop_disabled_title` varchar(50) default NULL,
`shop_disabled_reason` varchar(100) default NULL,
`webmaster_mail` varchar(50) defau