| vinayakb | 38b7ca4 | 2012-03-05 05:44:15 +0000 | [diff] [blame] | 1 | use dataverse demo0927; |
| 2 | |||||
| 3 | declare type CustomerType as closed { | ||||
| 4 | cid: int32, | ||||
| 5 | name: string, | ||||
| 6 | age: int32?, | ||||
| 7 | address: AddressType?, | ||||
| 8 | lastorder: { | ||||
| 9 | oid: int32, | ||||
| 10 | total: float | ||||
| 11 | } | ||||
| 12 | } | ||||
| 13 | |||||
| 14 | declare type AddressType as closed { | ||||
| 15 | number: int32, | ||||
| 16 | street: string, | ||||
| 17 | city: string | ||||
| 18 | } | ||||
| 19 | |||||
| 20 | declare nodegroup group1 on nc1,nc2; | ||||
| 21 | |||||
| 22 | declare dataset Customers(CustomerType) | ||||
| 23 | partitioned by key cid on group1; | ||||
| 24 | |||||
| 25 | create index NameIndex on Customers(name); | ||||