2 Copyright 2010 Sun Microsystems, Inc.
3 All rights reserved. Use is subject to license terms.
5 This program is free software; you can redistribute it and/or modify
6 it under the terms of the GNU General Public License as published by
7 the Free Software Foundation; version 2 of the License.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program; if not, write to the Free Software
16 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
19 package testsuite.clusterj.model;
21 import com.mysql.clusterj.annotation.Column;
22 import com.mysql.clusterj.annotation.Index;
23 import com.mysql.clusterj.annotation.Indices;
24 import com.mysql.clusterj.annotation.PersistenceCapable;
25 import com.mysql.clusterj.annotation.PrimaryKey;
27 import java.util.Date;
31 drop table if exists datetimetypes;
32 create table datetimetypes (
33 id int not null primary key,
35 datetime_null_hash datetime,
36 datetime_null_btree datetime,
37 datetime_null_both datetime,
38 datetime_null_none datetime,
40 datetime_not_null_hash datetime,
41 datetime_not_null_btree datetime,
42 datetime_not_null_both datetime,
43 datetime_not_null_none datetime
45 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
47 create unique index idx_datetime_null_hash using hash on datetimetypes(datetime_null_hash);
48 create index idx_datetime_null_btree on datetimetypes(datetime_null_btree);
49 create unique index idx_datetime_null_both on datetimetypes(datetime_null_both);
51 create unique index idx_datetime_not_null_hash using hash on datetimetypes(datetime_not_null_hash);
52 create index idx_datetime_not_null_btree on datetimetypes(datetime_not_null_btree);
53 create unique index idx_datetime_not_null_both on datetimetypes(datetime_not_null_both);
57 @Index(name="idx_datetime_not_null_both", columns=@Column(name="datetime_not_null_both"))
59 @PersistenceCapable(table="datetimetypes")
60 @PrimaryKey(column="id")
61 public interface DatetimeAsUtilDateTypes extends IdBase {
67 @Column(name="datetime_not_null_hash")
68 @Index(name="idx_datetime_not_null_hash")
69 Date getDatetime_not_null_hash();
70 void setDatetime_not_null_hash(Date value);
72 @Column(name="datetime_not_null_btree")
73 @Index(name="idx_datetime_not_null_btree")
74 Date getDatetime_not_null_btree();
75 void setDatetime_not_null_btree(Date value);
77 @Column(name="datetime_not_null_both")
78 Date getDatetime_not_null_both();
79 void setDatetime_not_null_both(Date value);
81 @Column(name="datetime_not_null_none")
82 Date getDatetime_not_null_none();
83 void setDatetime_not_null_none(Date value);