1stop slave;
2drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3reset master;
4reset slave;
5drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6start slave;
7DROP DATABASE IF EXISTS TEST_DB;
8CREATE DATABASE TEST_DB;
9USE TEST_DB;
10CREATE TABLE SUBSCRIBER
11( NUMBER       CHAR(12) BINARY NOT NULL,
12NAME         CHAR(32) BINARY NOT NULL,
13GROUP_ID     INT UNSIGNED NOT NULL,
14LOCATION     INT UNSIGNED NOT NULL,
15SESSIONS     INT UNSIGNED NOT NULL,
16CHANGED_BY   CHAR(32) BINARY NOT NULL,
17CHANGED_TIME CHAR(32) BINARY NOT NULL,
18PRIMARY KEY USING HASH (NUMBER))
19ENGINE = NDB;
20CREATE TABLE GROUP2
21( GROUP_ID     INT UNSIGNED NOT NULL,
22GROUP_NAME   CHAR(32) BINARY NOT NULL,
23ALLOW_READ   CHAR(1)  BINARY NOT NULL,
24ALLOW_INSERT INT UNSIGNED NOT NULL,
25ALLOW_DELETE INT UNSIGNED NOT NULL,
26PRIMARY KEY USING HASH (GROUP_ID))
27ENGINE = NDB;
28CREATE TABLE SESSION
29( NUMBER    CHAR(12)   BINARY NOT NULL,
30SERVER_ID INT UNSIGNED NOT NULL,
31DATA      BINARY(2000) NOT NULL,
32PRIMARY KEY USING HASH (NUMBER,SERVER_ID))
33ENGINE = NDB;
34CREATE TABLE SERVER
35( SUFFIX       CHAR(2)  BINARY NOT NULL,
36SERVER_ID    INT UNSIGNED NOT NULL,
37NAME         CHAR(32) BINARY NOT NULL,
38NO_OF_READ   INT UNSIGNED NOT NULL,
39NO_OF_INSERT INT UNSIGNED NOT NULL,
40NO_OF_DELETE INT UNSIGNED NOT NULL,
41PRIMARY KEY USING HASH (SUFFIX, SERVER_ID))
42ENGINE = NDB;
43