DROP TABLE IF EXISTS cdb_court_litigation;
CREATE TABLE cdb_court_litigation (
  id Integer NOT NULL AUTO_INCREMENT,
  accuser Varchar(255) NOT NULL,
  appellee Varchar(255) NOT NULL,
  lititype Tinyint(1) NOT NULL DEFAULT '1',
  litititle Varchar(50) NOT NULL,
  lititext Text NOT NULL,
  litiproof Text NOT NULL,
  liticlaimid Tinyint(2) NOT NULL DEFAULT '1',
  liticlaimtext Varchar(20) NOT NULL,
  litiappsay Text NOT NULL,
  pacification1 Tinyint(1) NOT NULL,
  pacification2 Tinyint(1) NOT NULL,
  pacification3 Tinyint(1) NOT NULL,
  lititime Varchar(16) NOT NULL DEFAULT '0',
  judgement Tinyint(1) NOT NULL DEFAULT '0',
  judgetimes Integer NOT NULL DEFAULT '0',
  judgeuser Varchar(255) NOT NULL,
  judgeclaimid Tinyint(2) NOT NULL,
  judgeclaimtext Varchar(20) NOT NULL,
  judgetext Text NOT NULL,
  judgetime Varchar(16) NOT NULL DEFAULT '0',
  PRIMARY KEY(id)
);
DROP TABLE IF EXISTS cdb_court_judge;
CREATE TABLE cdb_court_judge (
  id Integer NOT NULL AUTO_INCREMENT,
  userid Varchar(10) NOT NULL,
  lastjudge Varchar(10) NOT NULL,
  judgement Integer NOT NULL DEFAULT '0',
  grade Integer NOT NULL DEFAULT '0',
  addadmin Varchar(255) NOT NULL,
  addtime Varchar(16) NOT NULL DEFAULT '0',
  PRIMARY KEY(id)
);
DROP TABLE IF EXISTS cdb_court_grade;
CREATE TABLE cdb_court_grade (
  id Integer NOT NULL AUTO_INCREMENT,
  username Varchar(255) NOT NULL,
  judgename Varchar(255) NOT NULL,
  gradenum Tinyint(1) NOT NULL DEFAULT '0',
  gradetime Varchar(16) NOT NULL DEFAULT '0',
  PRIMARY KEY(id)
);