Howto create enum, set data types/fields

Hi Peter,

still not working, this is what I now entered:

‘Nein’,’Ja’
‘Konto’,’Facebook’,’Twitter’,’Telegram’,’Telegrambeitraege’

And this is the error message I get:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘NULL,PRIMARY KEY (id))’ at line 1

But the key-definition worked the first time I tried to design a table.

Key is defined as follows:

Index Name: ‘id’ (‘id’ is an int-field)
Unique: ‘yes’
Column Names: ‘id’

What could be the error here?

Thanks for your help.

Best,
Hannes

Hi Peter,

cool! 🙂 Here you are:

INSERT INTO rB3ABb_wpda_table_design (wpda_table_name, wpda_table_design, wpda_date_created, wpda_last_updated) VALUES
(‘spairdropcheck’,'{\”design_mode\”:\”advanced\”,\”engine\”:\”InnoDB\”,\”collation\”:\”utf8_general_ci\”,\”table\”:[{\”column_name\”:\”id\”,\”data_type\”:\”int\”,\”type_attribute\”:\”\”,\”key\”:\”Yes\”,\”mandatory\”:\”Yes\”,\”max_length\”:\”\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”user\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”Yes\”,\”max_length\”:\”25\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”email\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”Yes\”,\”max_length\”:\”37\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”displayname\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”31\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”nickname\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”25\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”firstname\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”28\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”lastname\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”47\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”telegramuser\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”99\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”telegramusername\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”23\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”posts\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”11\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”facebookuser\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”85\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”twitteruser\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”56\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”externalethaddress\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”434\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”ethaddress\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”84\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”note\”,\”data_type\”:\”mediumtext\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”termsagreed\”,\”data_type\”:\”varchar\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”3\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\”},{\”column_name\”:\”checked\”,\”data_type\”:\”enum\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”\”,\”extra\”:\”\”,\”default\”:\”\’Nein\’\”,\”list\”:\”\’Nein\’,\’Ja\’\”},{\”column_name\”:\”offen\”,\”data_type\”:\”set\”,\”type_attribute\”:\”\”,\”key\”:\”No\”,\”mandatory\”:\”No\”,\”max_length\”:\”\”,\”extra\”:\”\”,\”default\”:\”\”,\”list\”:\”\’Konto\’,\’Facebook\’,\’Twitter\’,\’Telegram\’,\’Telegrambeitraege\’\”}],\”indexes\”:[{\”index_name\”:\”id\”,\”unique\”:\”Yes\”,\”column_names\”:\”id\”}]}’,’2019-04-09 18:02:37′,’2019-04-12 23:15:33′);

Hi Peter,

thank you. Now creating the designed table works fine. 🙂

There are two minor things I’d like to add:

1. When you make a new table-design and do a “Reverse Engineering” from a table containing “default”- and “list”-values, it imports their content without single quotes ‘ So when you just keep some of the “reverse engineered” list data, you will again get this error, when you do not know, that you have to add single quotes ‘

2. Is there a plan to add a feature where we can edit the structure of an existing table, which was created by WP Data Access? I do not mean the content of the table, I mean e.g. adding additional fields to the table and altering/deleting existing fields in the table-structure. This would be very useful.

Best,
Hannes