| v1.81.0 dict-schema.sql, dict-data.sql [message #3986] |
Sun, 01 December 2013 15:03  |
jbusciglio
Messages: 4
Registered: November 2013
|
Junior Member |
|
|
I checked the schema and data for both mySql and sqlsrv,
it looks to me like the schema has the column for table dict_relationship:
mysql - `key_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PRIMARY'
sqlsrv - key_name nvarchar(64) NOT NULL DEFAULT 'PRIMARY'
there are a total of 18 columns in the schema for this table. The data inserts only have 17 columns.
key_name is the 14th column. I am not sure if I should omit this column in the schema or insert the not null default value of 'PRIMARY' for each record. Both options don't seem feasible.
Since I am not sure what that field controls, I don't know what other values it might take besides 'PRIMARY'. I will try and leave the field to '' and see what happens.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
