users

PriyaKumari's profile image PriyaKumari posted 2 days ago in Running SQL scripts Permalink

CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(25) NOT NULL UNIQUE, email VARCHAR(100) NOT NULL UNIQUE, password VARCHAR(256) NOT NULL, is_admin TINYINT(1) not null default 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

Please login to leave a reply, or register at first.