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