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;
30 drop table if exists datetypes;
31 create table datetypes (
32 id int not null primary key,
39 date_not_null_hash date,
40 date_not_null_btree date,
41 date_not_null_both date,
42 date_not_null_none date
44 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
46 create unique index idx_date_null_hash using hash on datetypes(date_null_hash);
47 create index idx_date_null_btree on datetypes(date_null_btree);
48 create unique index idx_date_null_both on datetypes(date_null_both);
50 create unique index idx_date_not_null_hash using hash on datetypes(date_not_null_hash);
51 create index idx_date_not_null_btree on datetypes(date_not_null_btree);
52 create unique index idx_date_not_null_both on datetypes(date_not_null_both);
56 @Index(name="idx_date_not_null_both", columns=@Column(name="date_not_null_both"))
58 @PersistenceCapable(table="datetypes")
59 @PrimaryKey(column="id")
60 public interface DateAsSqlDateTypes extends IdBase {
66 @Column(name="date_not_null_hash")
67 @Index(name="idx_date_not_null_hash")
68 Date getDate_not_null_hash();
69 void setDate_not_null_hash(Date value);
71 @Column(name="date_not_null_btree")
72 @Index(name="idx_date_not_null_btree")
73 Date getDate_not_null_btree();
74 void setDate_not_null_btree(Date value);
76 @Column(name="date_not_null_both")
77 Date getDate_not_null_both();
78 void setDate_not_null_both(Date value);
80 @Column(name="date_not_null_none")
81 Date getDate_not_null_none();
82 void setDate_not_null_none(Date value);