wehub-resource-sync
10 lines
380 B
SQL
10 lines
380 B
SQL
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_users` (
|
|
`id` integer,
|
|
`name` integer NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_users`("id", "name") SELECT "id", "name" FROM `users`;--> statement-breakpoint
|
|
DROP TABLE `users`;--> statement-breakpoint
|
|
ALTER TABLE `__new_users` RENAME TO `users`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON; |