address.mysql

CREATE TABLE ec_address (
aid int(11) NOT NULL auto_increment,
uid int(11) NOT NULL default '0',
firstname varchar(32) NOT NULL default '',
lastname varchar(32) NOT NULL default '',
street1 varchar(64) NOT NULL default '',
street2 varchar(64) NOT NULL default '',
zip varchar(10) NOT NULL default '',
city varchar(32) NOT NULL default '',
state varchar(32) default NULL,
country int(11) NOT NULL default '0',
PRIMARY KEY (aid)
) TYPE=MyISAM;

store.mysql

-- Table structure for table `ec_address`
--

CREATE TABLE ec_address (
aid int(11) NOT NULL auto_increment,
uid int(11) NOT NULL default '0',
firstname varchar(32) NOT NULL default '',
lastname varchar(32) NOT NULL default '',
street1 varchar(64) NOT NULL default '',
street2 varchar(64) NOT NULL default '',
zip varchar(10) NOT NULL default '',
city varchar(32) NOT NULL default '',
state varchar(32) default NULL,
country int(11) NOT NULL default '0',
PRIMARY KEY (aid)
) TYPE=MyISAM;

Comments

matt westgate’s picture

matt westgate commented

I don't see an error here.

Have you read the README?

3. After the directory is in place, browse in the filesystem to modules/ecommerce/store and load the global database definition file (store.mysql) for all the ecommerce modules using the tool of your choice. For example, if you prefer using a database front-end, such as PhpMyAdmin, simply upload the store.mysql file. Otherwise from the command line run:

mysql -u user -p drupal < store.mysql

Replace 'user' with the MySQL username that has permission to modify the database, and 'drupal' with the database being written to. The database must already be created.

carlmcdade’s picture

carlmcdade commented

That is not clear when installing the system. I installed the store first and then when running the address.mysql got an error because the table was already there. Even so in the adress readme there is nothing that says not to use that file. Either the adress.mysql should not be their or the documentation should be cleared up. The documentation should also have an order of installtion if there is going to be a conflict caused by order of installation.