Add additional schema indexes

[josephmancuso]

need to make sure we have:

• primary
• index
• unique
• fulltext

We should have primary already

[josephmancuso]

Here is a good resource https://vanseodesign.com/web-design/create-add-indexes-mysql/

[corentinalcoy]

@josephmancuso assign to me

[josephmancuso]

I added fulltext to description

[corentinalcoy]

@josephmancuso We have an issue.
With the base code there we can not do something like that

CREATE TABLE Customer(
   LastName CHAR(30) NOT NULL,
  FirstName CHAR(30) NOT NULL,
  Email CHAR(50) NOT NULL,
  INDEX (LastName,FirstName) 
);

or

CREATE TABLE Customer(
   lastname varchar(30) not null,
  firstname varchar(30) not null,
  Email CHAR(50) not null,
  constraint email_lastname_unique UNIQUE (email, lastname) 
);

[corentinalcoy]

I think we should fix it before continue

[josephmancuso]

Hmm you are right. I'm gonna take another look at the schema stuff because the grammars for that are all broken down. They aren't well connected like the select query is.

Let me take a look at that tonight

[josephmancuso]

It seems to be difficult for you and @Marlysson to build these things out so thats a foundation problem

[corentinalcoy]

Okay
Keep in mind we can take the name of the index or constraint from like a parameter.

[josephmancuso]

yeah let me refactor some of the schema stuff first @Marlysson

[Marlysson]

@josephmancuso Do I keep the code intact while do you refactor this part, for while?

[josephmancuso]

yeah just keep everything the same. I will take a look tonight