SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE suppliers ( supplier_id SERIAL PRIMARY KEY, supplier_name VARCHAR(100) NOT NULL UNIQUE, supplier_address TEXT, supplier_phone VARCHAR(20), supplier_email VARCHAR(100) CHECK ( supplier_email ~* '^[^@\s]+@[^@\s]+\.[^@\s]+$' ) ); INSERT INTO suppliers (supplier_name, supplier_email) VALUES ('АвтоЗапчасти ООО', 'auto-spares@mail.ru'), ('ТехноМотор ИП', 'technomotor@yandex.ru'), ('АвтоИмпорт ЗАО', 'importauto@company.ru'), ('CarParts Ltd', 'info@carparts.com'), ('AutoCloth', 'contact@autocloth.ru'), ('GearBox Supplies', 'gearbox@supplier.ru'), ('EngineParts', 'engineparts@mail.ru'), ('BrakeSystems', 'brakes@brakes.ru'), ('Suspension Co', 'suspension@supplier.com'), ('LightingWorld', 'lighting@lightingworld.ru');