Skip to content

Installation script has errors and does not create all tables #12

@jim7fl

Description

@jim7fl

while attempting to setup database with the included addressbook.sql file, I received the following error msg:
mysql> source addressbook.sql
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

The only two tables actually added were
mysql> show tables;
+-----------------------+
| Tables_in_addressbook |
+-----------------------+
| month_lookup |
| users |
+-----------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions