DROP TABLE IF EXISTS cdb_court_litigation;
CREATE TABLE cdb_court_litigation (		# ݱ
  id Integer NOT NULL AUTO_INCREMENT,		# ID
  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',	# ԭID
  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,		# оID
  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,		# ¼ID
  userid Varchar(10) NOT NULL,			# UID
  lastjudge Varchar(10) NOT NULL,		# һеID
  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,		# ּ¼ID
  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)
);