[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] MySQL UNIQUE index needs NOT NULL
Hi Shane,
At 17:18 02/12/99 -0800, Shane Roberts wrote:
>ERROR 1121: Column 'code' is used with UNIQUE or INDEX but is not
>defined as NOT NULL
>
>Has anyone run into this problem before. What do you have to tell
>MiniVend for it to properly create the index for the products
>table?
I had this come up at first too.
I now have the following which doesn't give that error:
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| code | varchar(14) | | PRI | | |
| description | varchar(128) | YES | | | |
| title | varchar(64) | YES | | | |
| artist | varchar(128) | YES | | | |
| comment | text | YES | | | |
| display | varchar(128) | YES | | | |
| image | varchar(128) | YES | | | |
| price | varchar(20) | YES | | | |
| category | varchar(128) | YES | | | |
| nontaxable | varchar(128) | YES | | | |
| weight | varchar(128) | YES | | | |
| size | varchar(128) | YES | | | |
| color | varchar(128) | YES | | | |
| related | varchar(128) | YES | | | |
+-------------+--------------+------+-----+---------+-------+
I'm still playing around with this, so don't take it as correct.
All the best,
Tom..
---------------------------------------------------
W: http://www.paradoxcafe.com/
?: new media design - Paradox Cafe
