blob: 6c55a4be3c029f9cd0ad48c4429fbf1606dfa33a (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE screens_tmp (
screenid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT 'Screen' NOT NULL,
hsize integer DEFAULT '1' NOT NULL,
vsize integer DEFAULT '1' NOT NULL,
PRIMARY KEY (screenid)
) ENGINE=InnoDB;
insert into screens_tmp select * from screens;
drop table screens;
alter table screens_tmp rename screens;
|
