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;
29 drop table if exists yeartypes;
30 create table yeartypes (
31 id int not null primary key,
38 year_not_null_hash year,
39 year_not_null_btree year,
40 year_not_null_both year,
41 year_not_null_none year
43 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
45 create unique index idx_year_null_hash using hash on yeartypes(year_null_hash);
46 create index idx_year_null_btree on yeartypes(year_null_btree);
47 create unique index idx_year_null_both on yeartypes(year_null_both);
49 create unique index idx_year_not_null_hash using hash on yeartypes(year_not_null_hash);
50 create index idx_year_not_null_btree on yeartypes(year_not_null_btree);
51 create unique index idx_year_not_null_both on yeartypes(year_not_null_both);
55 @Index(name="idx_year_null_both", columns=@Column(name="year_null_both")),
56 @Index(name="idx_year_not_null_both", columns=@Column(name="year_not_null_both"))
58 @PersistenceCapable(table="yeartypes")
59 @PrimaryKey(column="id")
60 public interface YearTypes extends IdBase {
66 @Column(name="year_null_hash")
67 @Index(name="idx_year_null_hash")
68 Short getYear_null_hash();
69 void setYear_null_hash(Short value);
71 @Column(name="year_null_btree")
72 @Index(name="idx_year_null_btree")
73 Short getYear_null_btree();
74 void setYear_null_btree(Short value);
76 @Column(name="year_null_both")
77 Short getYear_null_both();
78 void setYear_null_both(Short value);
80 @Column(name="year_null_none")
81 Short getYear_null_none();
82 void setYear_null_none(Short value);
84 @Column(name="year_not_null_hash")
85 @Index(name="idx_year_not_null_hash")
86 short getYear_not_null_hash();
87 void setYear_not_null_hash(short value);
89 @Column(name="year_not_null_btree")
90 @Index(name="idx_year_not_null_btree")
91 short getYear_not_null_btree();
92 void setYear_not_null_btree(short value);
94 @Column(name="year_not_null_both")
95 short getYear_not_null_both();
96 void setYear_not_null_both(short value);
98 @Column(name="year_not_null_none")
99 short getYear_not_null_none();
100 void setYear_not_null_none(short value);