7 lines
189 B
SQL
7 lines
189 B
SQL
CREATE TABLE `users` (
|
|
`id` integer PRIMARY KEY AUTOINCREMENT,
|
|
`username` text NOT NULL,
|
|
`password` text NOT NULL
|
|
);
|
|
CREATE UNIQUE INDEX `idx_users_username` ON `users` (`username`);
|