blob: 1e8190a223e0747c115f68757fc5dd62ef6e0baf (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE services_times (
timeid bigint unsigned DEFAULT '0' NOT NULL,
serviceid bigint unsigned DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
ts_from integer DEFAULT '0' NOT NULL,
ts_to integer DEFAULT '0' NOT NULL,
note varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (timeid)
) ENGINE=InnoDB;
CREATE INDEX services_times_times_1 on services_times (serviceid,type,ts_from,ts_to);
|
