Guest Posted March 28, 2005 Share Posted March 28, 2005 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. Quote Link to comment Share on other sites More sharing options...
Guest twisted Posted March 28, 2005 Share Posted March 28, 2005 So I still have time.... Now, to get these people to pay their invoices!!! heh Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 28, 2005 Share Posted March 28, 2005 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; Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 *is getting very excited* :w00t: Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 28, 2005 Share Posted March 28, 2005 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.... Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 cuat and paste.... i can see the lack of sleep :w00t: Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 mMmMmMmM CCV3 Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 28, 2005 Share Posted March 28, 2005 Is this acceptable do you think? (It will be less than 5 steps...) Quote Link to comment Share on other sites More sharing options...
Guest [email protected] Posted March 28, 2005 Share Posted March 28, 2005 Brooky maybe a strange question but is it going to be an implementation of your original store something like an upgrade or do we have to change the look of the store as well and do the designing all over again ?? Marco Hope to see it soon Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 28, 2005 Share Posted March 28, 2005 It is a complete rewrite and the code is 99.99% new. However it was built using the old database structure as a basis. We will release an upgrade script towards the latter stages of release. This will be quite a large task itself. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 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 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 :) 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 :D Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 28, 2005 Share Posted March 28, 2005 I love the enthusiasm. Sadly there is no set time but I expect it to be at about 5pm GMT. And so far no one has spotted my gag in the screenshot :D Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 Is that it? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 Mine too... :w00t: Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 29, 2005 Share Posted March 29, 2005 Yeah thats it alright. I have the sense of humour of a 3 year old. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 well, gotta do something to stay sane eh? (2 Days to go ) Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 29, 2005 Share Posted March 29, 2005 God help me!! Bug fixing today :w00t: Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 God help me!! Bug fixing today *hands brooky a fly-swatter* C'mon now, you're supposed to laugh WITH me not AT me :P Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 :w00t: 2 days, 5 hours to go :D Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 29, 2005 Share Posted March 29, 2005 There are LOTs of bugs at the moment!! :w00t: Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 Maybe this would help? :w00t: Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 29, 2005 Share Posted March 29, 2005 That and a big big can of whoop arse. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 ;) ROFLMFAO! :w00t: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.