View file sql/wapchat.sql

File size: 3.31Kb
#
# Struktur dari tabel `wc_advert`
#

DROP TABLE IF EXISTS wc_advert;
CREATE TABLE wc_advert (
  ID tinyint(4) NOT NULL auto_increment,
  ADV_NAME varchar(16) default '',
  ADV_TYPE tinyint(1) default '0',
  ADV_ACTIVATE tinyint(1) default '0',
  ADV_WRAP tinyint(1) default '0',
  ADV_TEXT varchar(250) default '',
  COB_ID varchar(16) NOT NULL default '',
  ROOM_ID varchar(32) default '',
  CREATED_BY varchar(16) default '',
  DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_advert`
#

INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (1, 'successkid', 1, 1, 1, 'Visit SuccessKid.com', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:05:20');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (2, 'successkid2', 0, 1, 1, 'Visit SuccessKid.com', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:06:28');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (3, 'successkid', 1, 1, 1, 'Visit SuccessKid.com', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:07:58');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (4, 'successkid2', 0, 1, 1, 'Visit SuccessKid.com', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:08:14');

# --------------------------------------------------------

#
# Struktur dari tabel `wc_message`
#

DROP TABLE IF EXISTS wc_message;
CREATE TABLE wc_message (
  COB_ID varchar(16) NOT NULL default '',
  USER_ID varchar(16) NOT NULL default '',
  DEST_ID varchar(16) NOT NULL default '',
  ROOM_ID varchar(32) NOT NULL default '',
  MESSAGE text NOT NULL,
  DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_message`
#


# --------------------------------------------------------

#
# Struktur dari tabel `wc_room`
#

DROP TABLE IF EXISTS wc_room;
CREATE TABLE wc_room (
  COB_ID varchar(16) NOT NULL default '',
  ROOM_ID varchar(32) NOT NULL default '',
  ROOM_NAME varchar(16) NOT NULL default '',
  CREATED_BY varchar(16) NOT NULL default '',
  DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ROOM_ID)
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_room`
#

INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('ITDIV', 'admin20050927095737', 'IT Room', 'admin', '2005-09-27 09:57:37');
INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('HRDIV', 'admin20050927095832', 'HR Room', 'admin', '2005-09-27 09:58:32');

# --------------------------------------------------------

#
# Struktur dari tabel `wc_user`
#

DROP TABLE IF EXISTS wc_user;
CREATE TABLE wc_user (
  COB_ID varchar(16) NOT NULL default '',
  USER_ID varchar(16) NOT NULL default '',
  PASSWORD varchar(16) NOT NULL default '',
  EMAIL varchar(32) NOT NULL default '',
  LAST_LOGIN datetime NOT NULL default '0000-00-00 00:00:00',
  DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_user`
#