Jump to content

CC3 Release Date!


Guest

Recommended Posts

This is great to hear, I will be purchasing a license shortly or maybe even two, Never hurts to have a spare.

Anyway hopefully brooky might be able to clear one small thing up for me how different is the products & catagtories table going to be in the database, Will it be a big job altering the CSV files i created to import through phpmyadmin or should it be fairly easy.

Link to comment
Share on other sites

  • Replies 149
  • Created
  • Last Reply

Top Posters In This Topic

This is the current CC3 Database STRUCTURE ONLY:

There are 15 New Tables

-- phpMyAdmin SQL Dump

-- version 2.6.1-pl2

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Generation Time: Mar 28, 2005 at 07:55 AM

-- Server version: 4.0.24

-- PHP Version: 4.3.10

-- 

-- Database: `xxxxxxxxx`

-- 



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_Downloads`

-- 



CREATE TABLE `CubeCart_Downloads` (

  `id` int(11) NOT NULL auto_increment,

  `customerId` int(11) NOT NULL default '0',

  `cart_order_id` varchar(32) NOT NULL default '',

  `noDownloads` int(11) NOT NULL default '0',

  `expire` int(11) NOT NULL default '0',

  `productId` int(11) NOT NULL default '0',

  `accessKey` varchar(10) NOT NULL default '',

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=14;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_Modules`

-- 



CREATE TABLE `CubeCart_Modules` (

  `moduleId` int(11) NOT NULL auto_increment,

  `module` varchar(10) NOT NULL default '',

  `folder` varchar(30) NOT NULL default '',

  `status` smallint(1) NOT NULL default '0',

  `default` int(1) NOT NULL default '0',

  KEY `moduleId` (`moduleId`)

) TYPE=MyISAM AUTO_INCREMENT=12;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_admin_permissions`

-- 



CREATE TABLE `CubeCart_admin_permissions` (

  `permissionId` int(11) NOT NULL auto_increment,

  `sectId` int(11) NOT NULL default '0',

  `adminId` int(11) NOT NULL default '0',

  `read` int(11) NOT NULL default '0',

  `write` int(11) NOT NULL default '0',

  `edit` int(11) NOT NULL default '0',

  `delete` int(11) NOT NULL default '0',

  PRIMARY KEY  (`permissionId`)

) TYPE=MyISAM AUTO_INCREMENT=78;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_admin_sections`

-- 



CREATE TABLE `CubeCart_admin_sections` (

  `sectId` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL default '',

  `description` text NOT NULL,

  KEY `sectId` (`sectId`)

) TYPE=MyISAM AUTO_INCREMENT=11;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_admin_sessions`

-- 



CREATE TABLE `CubeCart_admin_sessions` (

  `loginId` int(11) NOT NULL auto_increment,

  `username` varchar(255) NOT NULL default '',

  `time` int(11) NOT NULL default '0',

  `ipAddress` varchar(20) NOT NULL default '',

  `success` int(11) NOT NULL default '0',

  KEY `loginId` (`loginId`)

) TYPE=MyISAM AUTO_INCREMENT=235;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_admin_users`

-- 



CREATE TABLE `CubeCart_admin_users` (

  `adminId` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL default '',

  `username` varchar(255) NOT NULL default '',

  `password` varchar(32) NOT NULL default '',

  `email` varchar(255) NOT NULL default '',

  `noLogins` int(11) NOT NULL default '0',

  `isSuper` int(11) NOT NULL default '0',

  `notes` text,

  KEY `adminId` (`adminId`)

) TYPE=MyISAM AUTO_INCREMENT=4;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_category`

-- 



CREATE TABLE `CubeCart_category` (

  `cat_name` text NOT NULL,

  `cat_id` int(16) NOT NULL auto_increment,

  `cat_father_id` int(16) NOT NULL default '0',

  `cat_image` varchar(250) NOT NULL default '',

  `per_ship` decimal(20,2) NOT NULL default '0.00',

  `item_ship` decimal(20,2) NOT NULL default '0.00',

  `item_int_ship` decimal(20,2) NOT NULL default '0.00',

  `per_int_ship` decimal(20,2) NOT NULL default '0.00',

  `noProducts` int(11) default '0',

  PRIMARY KEY  (`cat_id`,`cat_id`)

) TYPE=MyISAM AUTO_INCREMENT=31;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_cats_idx`

-- 



CREATE TABLE `CubeCart_cats_idx` (

  `id` int(11) NOT NULL auto_increment,

  `cat_id` int(11) NOT NULL default '0',

  `productId` int(11) NOT NULL default '0',

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=88;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_config`

-- 



CREATE TABLE `CubeCart_config` (

  `site_email` varchar(40) NOT NULL default '',

  `site_country` varchar(225) NOT NULL default '',

  `site_tax` decimal(10,2) NOT NULL default '0.00',

  `site_url` varchar(225) NOT NULL default '',

  `site_url_ssl` varchar(225) NOT NULL default '',

  `site_name` varchar(50) NOT NULL default '',

  `site_phone` varchar(50) NOT NULL default '',

  `site_fax` varchar(50) NOT NULL default '',

  `site_address` text NOT NULL,

  `site_dir` varchar(225) NOT NULL default '',

  `site_currency` varchar(20) NOT NULL default '',

  `bg_colour` varchar(7) NOT NULL default '',

  `colour_1` varchar(7) NOT NULL default '',

  `colour_2` varchar(7) NOT NULL default '',

  `colour_3` varchar(7) NOT NULL default '',

  `colour_4` varchar(7) NOT NULL default '',

  `on_ssl` char(1) NOT NULL default 'N',

  `date` int(16) NOT NULL default '0',

  `online` char(1) NOT NULL default 'Y',

  `offmsg` text NOT NULL,

  `sale` char(1) NOT NULL default 'N',

  `site_business` varchar(225) NOT NULL default '',

  `site_cookie` int(16) NOT NULL default '0',

  `site_language` varchar(225) NOT NULL default '',

  `banned_ip` text NOT NULL,

  `admin_ip` text NOT NULL,

  `stats_disp` char(1) NOT NULL default 'Y',

  `sale_disp` char(1) NOT NULL default 'Y',

  `pop_disp` char(1) NOT NULL default 'Y',

  `spot_disp` char(1) NOT NULL default 'Y',

  `prod_limit` int(16) NOT NULL default '0',

  `prod_order` varchar(30) NOT NULL default '',

  `cat_rows` int(16) NOT NULL default '0',

  `cat_order` varchar(30) NOT NULL default '',

  `cat_format` varchar(30) NOT NULL default '',

  `cart_thumb` char(1) NOT NULL default 'Y',

  `refer_url` char(1) NOT NULL default 's',

  `welcome_note` text NOT NULL,

  `site_notify` char(1) NOT NULL default 'Y',

  `pay_default` varchar(30) NOT NULL default ''

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_countries`

-- 



CREATE TABLE `CubeCart_countries` (

  `country` text NOT NULL,

  `country_id` int(16) NOT NULL default '0',

  `status` char(1) NOT NULL default 'i',

  PRIMARY KEY  (`country_id`,`country_id`)

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_currencies`

-- 



CREATE TABLE `CubeCart_currencies` (

  `currencyId` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL default '',

  `code` varchar(5) NOT NULL default '',

  `symbolLeft` varchar(10) default NULL,

  `symbolRight` varchar(10) default NULL,

  `value` decimal(10,5) NOT NULL default '0.00000',

  `decimalPlaces` int(11) NOT NULL default '0',

  `lastUpdated` int(10) NOT NULL default '0',

  `active` int(1) NOT NULL default '0',

  KEY `curencyId` (`currencyId`)

) TYPE=MyISAM AUTO_INCREMENT=13;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_customer`

-- 



CREATE TABLE `CubeCart_customer` (

  `email` varchar(50) NOT NULL default '',

  `password` varchar(100) NOT NULL default '',

  `title` varchar(10) default NULL,

  `firstName` varchar(255) NOT NULL default '',

  `lastName` varchar(255) NOT NULL default '',

  `add_1` varchar(100) NOT NULL default '',

  `add_2` varchar(100) NOT NULL default '',

  `town` varchar(100) NOT NULL default '',

  `county` varchar(100) NOT NULL default '',

  `zoneId` int(3) NOT NULL default '0',

  `postcode` varchar(15) NOT NULL default '',

  `country` char(3) NOT NULL default '',

  `phone` varchar(20) NOT NULL default '',

  `mobile` varchar(50) default NULL,

  `customer_id` int(11) NOT NULL auto_increment,

  `regTime` int(10) NOT NULL default '0',

  `ipAddress` varchar(30) NOT NULL default '',

  `noOrders` int(11) default '0',

  `optIn1st` int(11) NOT NULL default '0',

  `htmlEmail` int(11) NOT NULL default '1',

  `type` int(11) default '0',

  PRIMARY KEY  (`customer_id`)

) TYPE=MyISAM AUTO_INCREMENT=798;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_docs`

-- 



CREATE TABLE `CubeCart_docs` (

  `doc_name` varchar(255) NOT NULL default '',

  `doc_content` text NOT NULL,

  `doc_id` int(16) NOT NULL auto_increment,

  KEY `doc_id` (`doc_id`)

) TYPE=MyISAM AUTO_INCREMENT=10;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_docs_lang`

-- 



CREATE TABLE `CubeCart_docs_lang` (

  `id` int(11) NOT NULL auto_increment,

  `doc_master_id` int(11) NOT NULL default '0',

  `doc_lang` varchar(20) NOT NULL default '',

  `doc_name` varchar(255) NOT NULL default '',

  `doc_content` text NOT NULL,

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=3;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_gateways`

-- 



CREATE TABLE `CubeCart_gateways` (

  `gateway` varchar(50) NOT NULL default '',

  `status` char(1) NOT NULL default '',

  `acc` varchar(50) NOT NULL default '',

  `cust1` varchar(50) NOT NULL default '',

  `cust2` varchar(50) NOT NULL default '',

  `cust3` varchar(50) NOT NULL default ''

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_img_idx`

-- 



CREATE TABLE `CubeCart_img_idx` (

  `id` int(11) NOT NULL auto_increment,

  `productId` int(11) NOT NULL default '0',

  `img` varchar(255) NOT NULL default '',

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=9;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_inv_lang`

-- 



CREATE TABLE `CubeCart_inv_lang` (

  `id` int(11) NOT NULL default '0',

  `name` varchar(255) NOT NULL default '',

  `prod_lang` varchar(20) NOT NULL default '',

  `prod_master_id` int(11) NOT NULL default '0',

  `description` text NOT NULL,

  KEY `id` (`id`)

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_inventory`

-- 



CREATE TABLE `CubeCart_inventory` (

  `productId` int(11) NOT NULL auto_increment,

  `productCode` varchar(60) NOT NULL default '',

  `quantity` int(16) NOT NULL default '1',

  `description` text NOT NULL,

  `image` varchar(250) NOT NULL default '',

  `noImages` int(11) NOT NULL default '0',

  `price` decimal(30,2) NOT NULL default '0.00',

  `name` varchar(250) NOT NULL default '0',

  `cat_id` int(16) NOT NULL default '0',

  `popularity` bigint(64) NOT NULL default '0',

  `sale_price` decimal(30,2) NOT NULL default '0.00',

  `stock_level` int(11) default '0',

  `useStockLevel` int(11) default '1',

  `digital` int(11) NOT NULL default '0',

  `digitalDir` varchar(255) default NULL,

  `prodWeight` decimal(10,2) default NULL,

  `taxType` int(11) default NULL,

  PRIMARY KEY  (`productId`)

) TYPE=MyISAM AUTO_INCREMENT=32;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_iso_counties`

-- 



CREATE TABLE `CubeCart_iso_counties` (

  `id` int(11) NOT NULL auto_increment,

  `countryId` int(4) NOT NULL default '0',

  `abbrev` varchar(4) NOT NULL default '',

  `name` varchar(40) NOT NULL default '',

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=441;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_iso_countries`

-- 



CREATE TABLE `CubeCart_iso_countries` (

  `id` int(11) NOT NULL auto_increment,

  `iso` char(2) NOT NULL default '',

  `printable_name` varchar(80) NOT NULL default '',

  `iso3` char(3) default NULL,

  `numcode` smallint(6) default NULL,

  PRIMARY KEY  (`iso`),

  KEY `id` (`id`),

  KEY `id_2` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=241;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_options_bot`

-- 



CREATE TABLE `CubeCart_options_bot` (

  `assign_id` int(32) NOT NULL auto_increment,

  `product` int(11) NOT NULL default '0',

  `option_id` int(32) NOT NULL default '0',

  `value_id` int(32) NOT NULL default '0',

  `option_price` decimal(30,2) NOT NULL default '0.00',

  `option_symbol` char(1) NOT NULL default '',

  PRIMARY KEY  (`assign_id`)

) TYPE=MyISAM AUTO_INCREMENT=84;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_options_mid`

-- 



CREATE TABLE `CubeCart_options_mid` (

  `value_id` int(16) NOT NULL auto_increment,

  `value_name` varchar(30) NOT NULL default '',

  `father_id` int(16) NOT NULL default '0',

  PRIMARY KEY  (`value_id`)

) TYPE=MyISAM AUTO_INCREMENT=19;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_options_top`

-- 



CREATE TABLE `CubeCart_options_top` (

  `option_id` int(16) NOT NULL auto_increment,

  `option_name` varchar(30) NOT NULL default '',

  PRIMARY KEY  (`option_id`)

) TYPE=MyISAM AUTO_INCREMENT=7;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_order_inv`

-- 



CREATE TABLE `CubeCart_order_inv` (

  `productId` int(11) NOT NULL default '0',

  `productCode` varchar(255) NOT NULL default '',

  `name` varchar(225) NOT NULL default '',

  `quantity` int(32) NOT NULL default '0',

  `price` decimal(30,2) NOT NULL default '0.00',

  `cart_order_id` varchar(30) NOT NULL default '',

  `id` int(32) NOT NULL auto_increment,

  `product_options` text NOT NULL,

  `digital` int(1) NOT NULL default '0',

  PRIMARY KEY  (`id`),

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=15;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_order_state`

-- 



CREATE TABLE `CubeCart_order_state` (

  `id` int(11) NOT NULL default '0',

  `state` varchar(255) NOT NULL default '',

  KEY `id` (`id`)

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_order_sum`

-- 



CREATE TABLE `CubeCart_order_sum` (

  `cart_order_id` varchar(30) NOT NULL default '',

  `customer_id` int(11) NOT NULL default '0',

  `name` varchar(225) NOT NULL default '',

  `add_1` varchar(225) NOT NULL default '',

  `add_2` varchar(225) NOT NULL default '',

  `town` varchar(225) NOT NULL default '',

  `county` varchar(225) NOT NULL default '',

  `postcode` varchar(225) NOT NULL default '',

  `country` varchar(225) NOT NULL default '',

  `name_d` varchar(225) NOT NULL default '',

  `add_1_d` varchar(225) NOT NULL default '',

  `add_2_d` varchar(225) NOT NULL default '',

  `town_d` varchar(225) NOT NULL default '',

  `county_d` varchar(225) NOT NULL default '',

  `postcode_d` varchar(225) NOT NULL default '',

  `country_d` varchar(225) NOT NULL default '',

  `phone` varchar(225) NOT NULL default '',

  `mobile` varchar(255) default NULL,

  `subtotal` decimal(30,2) NOT NULL default '0.00',

  `prod_total` decimal(30,2) NOT NULL default '0.00',

  `total_tax` decimal(30,2) NOT NULL default '0.00',

  `total_ship` decimal(30,2) NOT NULL default '0.00',

  `status` int(16) NOT NULL default '1',

  `sec_order_id` varchar(30) default NULL,

  `ip` varchar(20) NOT NULL default '',

  `time` int(10) NOT NULL default '0',

  `email` varchar(225) NOT NULL default '',

  `comments` text,

  `ship_date` varchar(50) default NULL,

  `gateway` varchar(50) NOT NULL default '',

  `currency` varchar(5) NOT NULL default '',

  `customer_comments` text,

  PRIMARY KEY  (`cart_order_id`)

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_search`

-- 



CREATE TABLE `CubeCart_search` (

  `searchstr` varchar(255) NOT NULL default '',

  `hits` int(64) NOT NULL default '0',

  `id` int(64) NOT NULL auto_increment,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=23;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_sessions`

-- 



CREATE TABLE `CubeCart_sessions` (

  `sessId` varchar(32) NOT NULL default '',

  `basket` text,

  `timeStart` int(11) NOT NULL default '0',

  `timeLast` int(11) NOT NULL default '0',

  `customer_id` int(11) NOT NULL default '0',

  `location` varchar(255) default NULL,

  `lang` varchar(20) default NULL,

  `currency` char(3) default NULL,

  PRIMARY KEY  (`sessId`)

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_stats`

-- 



CREATE TABLE `CubeCart_stats` (

  `date` varchar(11) NOT NULL default '0',

  `hits` int(64) NOT NULL default '0'

) TYPE=MyISAM;



-- --------------------------------------------------------



-- 

-- Table structure for table `CubeCart_taxes`

-- 



CREATE TABLE `CubeCart_taxes` (

  `id` int(11) NOT NULL auto_increment,

  `taxName` varchar(50) NOT NULL default '',

  `percent` decimal(5,4) NOT NULL default '0.0000',

  KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=4;

        

Link to comment
Share on other sites

So am I... Only have to fix a few bugs, build front lang file and create an install script and we are there.

Took the whole of yesterday just to make the admin language file... 700 Lines long. The front end is bigger... Sleepless nights ahead.

Cut and past cuat and paste....

Link to comment
Share on other sites

Thanks for that Brooky, It looks like there will be some modifications to the CSV file but should be to bad most of the other columns look like they are going to be just blank values for me when i move the products over.

Cannot wait to get a copy to play with.

Link to comment
Share on other sites

Is this acceptable do you think? (It will be less than 5 steps...)

Looks good to me ;)

Oh BTW, we know the date its going to be released, is there a set time, or is it just whenever you feel like it :P I dont particularly feel like sitting in front of the PC for 24 hours constantly refreshing the page (though i will if i have to ::w00t:)

Aargh, i'd better hurry up and finish redesigning my hosting site, cause once this comes out, no time for anything else - and that includes school and sleep :P :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...