Salary Market

use salarymarket;

CREATE TABLE company_inscriptions (

    id INT PRIMARY KEY AUTO_INCREMENT,

    email VARCHAR(255) UNIQUE NOT NULL,

    firstName VARCHAR(255) NOT NULL,

    lastName VARCHAR(255) NOT NULL,

    phone VARCHAR(20) NOT NULL,

    poste VARCHAR(255) NOT NULL,

    raisonSociale VARCHAR(255),

    subscription VARCHAR(255) DEFAULT 'Advanced' NOT NULL,

    type VARCHAR(255) DEFAULT 'Customer' NOT NULL,

    status VARCHAR(255),

    code TEXT NOT NULL,

    businessSector VARCHAR(255) NOT NULL,

    subSector VARCHAR(255) NOT NULL,

    country VARCHAR(255) NOT NULL,

    taxRegistration VARCHAR(100) NOT NULL,

    menuSelections JSON,

    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

    updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

);