2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
5
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6
INSERT INTO t1 (c1) VALUES(NOW());
7
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
9
INSERT INTO t1 (c1) VALUES(NOW());
12
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
13
INSERT INTO t1 (c1) VALUES(1999);
14
INSERT INTO t1 (c1) VALUES(2000);
16
INSERT INTO t1 (c1) VALUES(1999);
19
CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
20
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
21
INSERT INTO t1 (c1) VALUES(NOW());
22
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
24
INSERT INTO t1 (c1) VALUES(NOW());
27
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
28
INSERT INTO t1 (c1) VALUES(1999);
29
INSERT INTO t1 (c1) VALUES(2000);
31
INSERT INTO t1 (c1) VALUES(1999);
34
CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
35
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
36
INSERT INTO t1 (c1) VALUES(NOW());
37
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
39
INSERT INTO t1 (c1) VALUES(NOW());
42
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
43
INSERT INTO t1 (c1) VALUES(1999);
44
INSERT INTO t1 (c1) VALUES(2000);
46
INSERT INTO t1 (c1) VALUES(1999);
49
CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
50
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
51
INSERT INTO t1 (c1) VALUES(NOW());
52
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
54
INSERT INTO t1 (c1) VALUES(NOW());
57
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
58
INSERT INTO t1 (c1) VALUES(1999);
59
INSERT INTO t1 (c1) VALUES(2000);
61
INSERT INTO t1 (c1) VALUES(1999);