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;
26
import java.sql.Timestamp;
30
drop table if exists datetimetypes;
31
create table datetimetypes (
32
id int not null primary key,
34
datetime_null_hash datetime,
35
datetime_null_btree datetime,
36
datetime_null_both datetime,
37
datetime_null_none datetime,
39
datetime_not_null_hash datetime,
40
datetime_not_null_btree datetime,
41
datetime_not_null_both datetime,
42
datetime_not_null_none datetime
44
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
46
create unique index idx_datetime_null_hash using hash on datetimetypes(datetime_null_hash);
47
create index idx_datetime_null_btree on datetimetypes(datetime_null_btree);
48
create unique index idx_datetime_null_both on datetimetypes(datetime_null_both);
50
create unique index idx_datetime_not_null_hash using hash on datetimetypes(datetime_not_null_hash);
51
create index idx_datetime_not_null_btree on datetimetypes(datetime_not_null_btree);
52
create unique index idx_datetime_not_null_both on datetimetypes(datetime_not_null_both);
56
@Index(name="idx_datetime_not_null_both", columns=@Column(name="datetime_not_null_both"))
58
@PersistenceCapable(table="datetimetypes")
59
@PrimaryKey(column="id")
60
public interface DatetimeAsSqlTimestampTypes extends IdBase {
66
@Column(name="datetime_not_null_hash")
67
@Index(name="idx_datetime_not_null_hash")
68
Timestamp getDatetime_not_null_hash();
69
void setDatetime_not_null_hash(Timestamp value);
71
@Column(name="datetime_not_null_btree")
72
@Index(name="idx_datetime_not_null_btree")
73
Timestamp getDatetime_not_null_btree();
74
void setDatetime_not_null_btree(Timestamp value);
76
@Column(name="datetime_not_null_both")
77
Timestamp getDatetime_not_null_both();
78
void setDatetime_not_null_both(Timestamp value);
80
@Column(name="datetime_not_null_none")
81
Timestamp getDatetime_not_null_none();
82
void setDatetime_not_null_none(Timestamp value);