;

;

;

;

;

;

;

;

;

;

;

;

CREATE TABLE `jcow_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fbid` bigint NOT NULL DEFAULT '0',
  `email` varchar(120) NOT NULL DEFAULT '',
  `lastact` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `username` varchar(25) NOT NULL DEFAULT '',
  `fullname` varchar(30) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `level` tinyint NOT NULL DEFAULT '0',
  `points` int NOT NULL DEFAULT '0',
  `avatar` varchar(200) NOT NULL DEFAULT '',
  `signature` text,
  `blurbs` text,
  `profile_permission` tinyint NOT NULL DEFAULT '0',
  `location` varchar(100) NOT NULL DEFAULT '',
  `lastlogin` int NOT NULL DEFAULT '0',
  `ipaddress` varchar(30) NOT NULL DEFAULT '',
  `chpass` varchar(10) NOT NULL DEFAULT '',
  `disabled` tinyint NOT NULL DEFAULT '0',
  `intr` text,
  `gender` tinyint NOT NULL DEFAULT '0',
  `about_me` text,
  `birthyear` int NOT NULL DEFAULT '0',
  `birthmonth` tinyint NOT NULL DEFAULT '0',
  `birthday` tinyint NOT NULL DEFAULT '0',
  `hide_age` tinyint(1) NOT NULL DEFAULT '0',
  `reg_code` varchar(8) NOT NULL DEFAULT '',
  `forum_posts` int NOT NULL DEFAULT '0',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `roles` varchar(255) NOT NULL DEFAULT '',
  `country` varchar(50) NOT NULL DEFAULT '',
  `locale` varchar(50) NOT NULL DEFAULT '',
  `state` varchar(50) NOT NULL DEFAULT '',
  `jcowsess` char(12) NOT NULL DEFAULT '',
  `token` varchar(32) NOT NULL DEFAULT '',
  `wall_id` int NOT NULL DEFAULT '0',
  `followers` int NOT NULL DEFAULT '0',
  `coins` int NOT NULL DEFAULT '0',
  `verified` int NOT NULL DEFAULT '0',
  `settings` text,
  `var1` varchar(255) NOT NULL DEFAULT '',
  `var2` varchar(255) NOT NULL DEFAULT '',
  `var3` varchar(255) NOT NULL DEFAULT '',
  `var4` varchar(255) NOT NULL DEFAULT '',
  `var5` varchar(255) NOT NULL DEFAULT '',
  `var6` varchar(255) NOT NULL DEFAULT '',
  `var7` varchar(255) NOT NULL DEFAULT '',
  `pass` varchar(32) NOT NULL DEFAULT '',
  `hide_me` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `lastlogin` (`lastlogin`),
  KEY `email` (`email`),
  KEY `fbid` (`fbid`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb3;

;

;

;

CREATE TABLE `jcow_awards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `cost` int NOT NULL DEFAULT '0',
  `profit` int NOT NULL DEFAULT '0',
  `image` varchar(100) NOT NULL DEFAULT '',
  `image_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_awards`
VALUES
  (
    6,
    'You Have The Key',
    150,
    75,
    'static/awards/you_have_the_key.png',
    0
  ),
  (
    7,
    'Love Song',
    150,
    75,
    'static/awards/love_song.png',
    0
  ),
  (
    8,
    'Coffee Cup',
    150,
    75,
    'static/awards/coffee_cup.png',
    0
  ),
  (
    9,
    'Chocolate Box',
    150,
    75,
    'static/awards/chocolate_box.png',
    0
  ),
  (
    10,
    'Cookies',
    150,
    75,
    'static/awards/cookies.png',
    0
  ),
  (
    11,
    'Love Letter',
    150,
    75,
    'static/awards/love_letter.png',
    0
  ),
  (
    12,
    'Be Mine',
    150,
    75,
    'static/awards/be_mine.png',
    0
  ),
  (
    13,
    'Love Message',
    150,
    75,
    'static/awards/love_message.png',
    0
  ),
  (14, 'Bee', 150, 75, 'static/awards/bee.png', 0),
  (
    15,
    'Got You',
    150,
    75,
    'static/awards/got_you.png',
    0
  ),
  (
    16,
    'Love You',
    150,
    75,
    'static/awards/love_you.png',
    0
  ),
  (
    17,
    'Valentines Day',
    150,
    75,
    'static/awards/valentines_day.png',
    0
  ),
  (
    18,
    'I Love You',
    150,
    75,
    'static/awards/i_love_you.png',
    0
  ),
  (
    19,
    'Cupid',
    150,
    75,
    'static/awards/cupid.png',
    0
  ),
  (
    20,
    'Love Birds',
    150,
    75,
    'static/awards/love_birds.png',
    0
  ),
  (
    21,
    'Flower',
    150,
    75,
    'static/awards/flower.png',
    0
  ),
  (
    22,
    'Cassette Tape',
    150,
    75,
    'static/awards/cassette_tape.png',
    0
  ),
  (23, 'Love', 150, 75, 'static/awards/love.png', 0);

;


;

;

CREATE TABLE `jcow_awards_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `award_id` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  `author_id` int NOT NULL DEFAULT '0',
  `cost` int NOT NULL DEFAULT '0',
  `profit` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_banned` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `ip1` varchar(3) NOT NULL DEFAULT '',
  `ip2` varchar(3) NOT NULL DEFAULT '',
  `ip3` varchar(3) NOT NULL DEFAULT '',
  `ip4` varchar(3) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `expired` int NOT NULL DEFAULT '0',
  `operator` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 15 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_blacks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `bid` int NOT NULL DEFAULT '0',
  `bname` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`, `bid`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_cache` (
  `ckey` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8mb3_unicode_ci,
  `expired` int NOT NULL DEFAULT '0'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3 COLLATE = utf8mb3_unicode_ci;

;


;

INSERT INTO
  `jcow_cache`
VALUES
  (
    'jcow_langs_en',
    '{\"Home\":\"\",\"Menu\":\"\",\"Logout\":\"\",\"Friends\":\"\",\"Text message\":\"\",\"Search\":\"\",\"View Profile\":\"\",\"Edit Profile\":\"\",\"Images\":\"\",\"Members\":\"\",\"Admin CP\":\"\",\"Your Shortcuts\":\"\",\"Sign Up\":\"\",\"Full Name\":\"\",\"Email Address\":\"\",\"Username\":\"\",\"Password\":\"\",\"Birthday\":\"\",\"Month\":\"\",\"Day\":\"\",\"Year\":\"\",\"Gender\":\"\",\"Male\":\"\",\"Female\":\"\",\"Hide\":\"\",\"Already have an account?\":\"\",\"Login Here\":\"\",\"My feed\":\"\",\"News feed\":\"\",\"Your Badge\":\"\",\"What\'s on your mind, {1}?\":\"\",\"Share\":\"\",\"Status\":\"\",\"Recording\":\"\",\"Finished recording\":\"\",\"Remove\":\"\",\"My account\":\"\",\"Birthdays coming up\":\"\",\"My Profile\":\"\",\"{1} views\":\"\",\"{1} following\":\"\",\"{1} followers\":\"\",\"Preference\":\"\",\"My images\":\"\",\"none\":\"\",\"Admin Panel\":\"\",\"Configuration\":\"\",\"Modules\":\"\",\"themes\":\"\",\"Member fields\":\"\",\"Member roles\":\"\",\"Permissions\":\"\",\"Text\":\"\",\"Translation\":\"\",\"Stream monitor\":\"\",\"Cache controller\":\"\",\"Ad blocks\":\"\",\"Award\":\"\",\"Operation success\":\"\",\"Invite\":\"\"}',
    1
  );

;


;

;

CREATE TABLE `jcow_chatrooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `fid` int NOT NULL DEFAULT '0',
  `content` text,
  `updated` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `request_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`, `fid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `target_id` varchar(20) NOT NULL DEFAULT '',
  `uid` int NOT NULL DEFAULT '0',
  `message` text,
  `created` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `target_id` (`target_id`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_disliked` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`, `stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_favorites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `fuid` int NOT NULL DEFAULT '0',
  `fapp` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `fsid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`, `fuid`, `fsid`, `created`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_followers` (
  `uid` int NOT NULL DEFAULT '0',
  `fid` int NOT NULL DEFAULT '0',
  KEY `uid` (`uid`, `fid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_footer_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `link_name` varchar(255) NOT NULL DEFAULT '',
  `content` text,
  `weight` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_footer_pages`
VALUES
  (
    1,
    'About Us',
    'About Us',
    'You(admin) can edit this page from \"Admin CP\"-\"Footer Pages\".',
    1
  ),
  (
    2,
    'Contact Us',
    'Contact Us',
    'You(admin) can edit this page from \"Admin CP\"-\"Footer Pages\".',
    2
  );

;


;

;

CREATE TABLE `jcow_forum_attachments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int NOT NULL DEFAULT '0',
  `tid` int NOT NULL DEFAULT '0',
  `uri` varchar(100) NOT NULL DEFAULT '',
  `des` varchar(255) NOT NULL DEFAULT '',
  `size` int NOT NULL DEFAULT '0',
  `orginal_name` varchar(255) NOT NULL DEFAULT '',
  `downloads` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `tid` (`tid`)
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_forum_polls` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` int NOT NULL DEFAULT '0',
  `question` varchar(100) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `options` text,
  `timeout` int NOT NULL DEFAULT '0',
  `options_per_user` tinyint NOT NULL DEFAULT '0',
  `voters` text,
  `total` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tid` (`tid`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_forum_posts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` bigint NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `message` text,
  `created` int NOT NULL DEFAULT '0',
  `ip` varchar(30) NOT NULL DEFAULT '',
  `is_first` tinyint NOT NULL DEFAULT '0',
  `attach` int NOT NULL DEFAULT '0',
  `bbcode_off` tinyint NOT NULL DEFAULT '0',
  `emote_off` tinyint NOT NULL DEFAULT '0',
  `got_attach` tinyint NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tid` (`tid`),
  KEY `author_id` (`uid`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_forum_subscribes` (
  `uid` int NOT NULL DEFAULT '0',
  `tid` int NOT NULL DEFAULT '0',
  KEY `uid` (`uid`, `tid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_forum_threads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fid` int NOT NULL DEFAULT '0',
  `old_fid` int NOT NULL DEFAULT '0',
  `pid` int NOT NULL DEFAULT '0',
  `userid` int NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `topic` varchar(255) NOT NULL DEFAULT '',
  `views` int NOT NULL DEFAULT '0',
  `posts` int NOT NULL DEFAULT '0',
  `closed` smallint NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `lastpostusername` varchar(255) NOT NULL DEFAULT '0',
  `lastpostcreated` int NOT NULL DEFAULT '0',
  `icon` tinyint NOT NULL DEFAULT '0',
  `thread_type` tinyint(1) NOT NULL DEFAULT '0',
  `thread_lock` tinyint(1) NOT NULL DEFAULT '0',
  `got_poll` tinyint NOT NULL DEFAULT '0',
  `got_attach` tinyint NOT NULL DEFAULT '0',
  `stressed` tinyint NOT NULL DEFAULT '0',
  `digg` int NOT NULL DEFAULT '0',
  `dugg` int NOT NULL DEFAULT '0',
  `votes` text,
  PRIMARY KEY (`id`),
  KEY `fid` (`fid`),
  KEY `thread_type` (`thread_type`)
) ENGINE = InnoDB AUTO_INCREMENT = 29 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_forums` (
  `id` int NOT NULL AUTO_INCREMENT,
  `weight` int NOT NULL DEFAULT '0',
  `parent_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type_pic` varchar(255) NOT NULL DEFAULT '',
  `description` tinytext,
  `rules` text,
  `forum_type` varchar(50) NOT NULL DEFAULT '0',
  `threads` int NOT NULL DEFAULT '0',
  `posts` int NOT NULL DEFAULT '0',
  `lastpostname` varchar(32) NOT NULL DEFAULT '',
  `lastposttopicid` int NOT NULL DEFAULT '0',
  `lastposttopic` varchar(70) NOT NULL DEFAULT '',
  `lastpostcreated` int NOT NULL DEFAULT '0',
  `moderator` varchar(255) NOT NULL DEFAULT '',
  `settings` text,
  `fmembers` int NOT NULL DEFAULT '0',
  `image` varchar(250) NOT NULL DEFAULT '',
  `read_roles` varchar(255) NOT NULL DEFAULT '',
  `upload_roles` varchar(255) NOT NULL DEFAULT '',
  `thread_roles` varchar(255) NOT NULL DEFAULT '',
  `reply_roles` varchar(255) NOT NULL DEFAULT '',
  `moderators` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `belong_id` (`parent_id`),
  KEY `order_num` (`weight`),
  KEY `type_class` (`forum_type`)
) ENGINE = InnoDB AUTO_INCREMENT = 9 DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_forums`
VALUES
  (
    7,
    1,
    0,
    'General Category',
    '',
    '',
    '',
    'category',
    0,
    0,
    '',
    0,
    '',
    0,
    '',
    '',
    0,
    '',
    '',
    '',
    '',
    '',
    ''
  ),
  (
    8,
    1,
    7,
    'General Forum',
    '',
    'This is a general forum',
    '',
    'forum',
    0,
    0,
    '',
    0,
    '',
    0,
    '',
    '',
    0,
    '',
    '1|2',
    '2',
    '2',
    '2',
    ''
  );

;


;

;

CREATE TABLE `jcow_friend_reqs` (
  `uid` int NOT NULL DEFAULT '0',
  `fid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `msg` varchar(200) NOT NULL DEFAULT '',
  KEY `uid` (`uid`, `fid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_friends` (
  `uid` int NOT NULL DEFAULT '0',
  `fid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  KEY `uid` (`uid`, `fid`),
  KEY `fid` (`fid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `groups` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_members` (
  `gid` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `nickname` varchar(20) NOT NULL DEFAULT '',
  `about_me` text,
  `hide_profile` tinyint(1) NOT NULL DEFAULT '0',
  KEY `gid` (`gid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_members_pending` (
  `uid` int NOT NULL DEFAULT '0',
  `gid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `ignored` tinyint NOT NULL DEFAULT '0',
  KEY `uid` (`uid`, `gid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_polls` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` int NOT NULL DEFAULT '0',
  `question` varchar(100) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `options` text,
  `timeout` int NOT NULL DEFAULT '0',
  `options_per_user` tinyint NOT NULL DEFAULT '0',
  `voters` text,
  `total` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tid` (`tid`)
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_postcats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `gid` (`gid`)
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_posts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL DEFAULT '0',
  `tid` bigint NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `rtid` int NOT NULL DEFAULT '0',
  `rid` int NOT NULL DEFAULT '0',
  `rname` varchar(100) NOT NULL DEFAULT '',
  `message` text,
  `created` int NOT NULL DEFAULT '0',
  `ip` varchar(30) NOT NULL DEFAULT '',
  `attach` int NOT NULL DEFAULT '0',
  `bbcode_off` tinyint NOT NULL DEFAULT '0',
  `emote_off` tinyint NOT NULL DEFAULT '0',
  `got_attach` tinyint NOT NULL DEFAULT '0',
  `topic` varchar(100) NOT NULL DEFAULT '',
  `is_first` tinyint NOT NULL DEFAULT '0',
  `replies` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tid` (`tid`),
  KEY `uid` (`uid`),
  KEY `gid` (`gid`),
  KEY `rtid` (`rtid`),
  KEY `rid` (`rid`)
) ENGINE = InnoDB AUTO_INCREMENT = 100 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_group_topics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL DEFAULT '0',
  `old_fid` int NOT NULL DEFAULT '0',
  `pid` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `username` varchar(50) NOT NULL DEFAULT '',
  `topic` varchar(255) NOT NULL DEFAULT '',
  `views` int NOT NULL DEFAULT '0',
  `posts` int NOT NULL DEFAULT '0',
  `closed` smallint NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `lastpostusername` varchar(255) NOT NULL DEFAULT '0',
  `lastpostcreated` int NOT NULL DEFAULT '0',
  `icon` tinyint NOT NULL DEFAULT '0',
  `thread_type` tinyint(1) NOT NULL DEFAULT '0',
  `thread_lock` tinyint(1) NOT NULL DEFAULT '0',
  `got_poll` tinyint NOT NULL DEFAULT '0',
  `got_attach` tinyint NOT NULL DEFAULT '0',
  `stressed` tinyint NOT NULL DEFAULT '0',
  `digg` int NOT NULL DEFAULT '0',
  `dugg` int NOT NULL DEFAULT '0',
  `votes` text,
  PRIMARY KEY (`id`),
  KEY `gid` (`gid`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uri` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `slogan` varchar(200) NOT NULL DEFAULT '',
  `creatorid` int NOT NULL DEFAULT '0',
  `creator` varchar(50) NOT NULL DEFAULT '',
  `description` text,
  `members` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `logo` varchar(100) NOT NULL DEFAULT '',
  `private` tinyint NOT NULL DEFAULT '0',
  `needapproval` tinyint NOT NULL DEFAULT '0',
  `posts` int NOT NULL DEFAULT '0',
  `topics` int NOT NULL DEFAULT '0',
  `lastptime` int NOT NULL DEFAULT '0',
  `lastpname` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `custom_css` text,
  `style_ids` varchar(50) NOT NULL DEFAULT '',
  `category` char(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `creatorid` (`creatorid`),
  KEY `uri` (`uri`)
) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_gvars` (
  `gkey` varchar(50) NOT NULL DEFAULT '',
  `gvalue` text,
  KEY `gkey` (`gkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_gvars`
VALUES
  ('theme_folder', 'themes/default'),
  ('cf_var1', 'disabled'),
  ('cf_var2', 'disabled'),
  ('cf_var3', 'disabled'),
  ('cf_var4', 'disabled'),
  ('cf_var5', 'disabled'),
  ('cf_var6', 'disabled'),
  ('cf_var7', 'disabled'),
  ('jcow_version', '4.0'),
  ('app_music_disable', '0'),
  ('story_access', 'all'),
  ('profile_access', 'all'),
  ('site_slogan', 'This is a Social Network'),
  ('ad_block_content_top', ''),
  ('ad_block_content_bottom', ''),
  ('site_name', 'My Jcow Network'),
  ('site_email', 'name@domain.com'),
  ('block_top', ''),
  ('block_bottom', ''),
  ('only_invited', '0'),
  ('session_lived', '1267784005'),
  ('permission_etheme', '2'),
  ('permission_atheme', '2|11'),
  ('private_network', '0'),
  ('theme_tpl', 'default'),
  ('theme_css', '1.css'),
  ('hide_ad_roles', '3'),
  ('acc_verify', '0'),
  ('permission_upload', '2'),
  ('permission_comment', '2'),
  ('permission_add', '2'),
  ('permission_browse', '1|2'),
  ('permission_feed', '1|2'),
  (
    'theme_block_adsbar',
    'Go to \"Admin CP\" - \"Themes\" - \"Manage Blocks\" to edit this message.'
  ),
  ('limit_posting_num', '5'),
  ('app_music', '0');

;


;

;

CREATE TABLE `jcow_im` (
  `id` int NOT NULL AUTO_INCREMENT,
  `from_id` int NOT NULL DEFAULT '0',
  `to_id` int NOT NULL DEFAULT '0',
  `pid` int NOT NULL DEFAULT '0',
  `message` text,
  `created` int NOT NULL DEFAULT '0',
  `hasread` tinyint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `from_id` (`from_id`, `to_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_invites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `code` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_langs` (
  `lang_from` varchar(255) NOT NULL DEFAULT '',
  `lang_to` text,
  `lang` varchar(20) NOT NULL DEFAULT '',
  KEY `lang_from` (`lang_from`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;



;


;

;

CREATE TABLE `jcow_liked` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_limit_posting` (
  `uid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `act` varchar(50) NOT NULL DEFAULT '',
  KEY `uid` (`uid`, `created`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_mentions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  `wall_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `tab_name` varchar(50) NOT NULL DEFAULT '',
  `weight` int NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL DEFAULT '',
  `app` varchar(50) NOT NULL DEFAULT '',
  `actived` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(25) NOT NULL DEFAULT '',
  `protected` tinyint(1) NOT NULL DEFAULT '0',
  `allowed_roles` text,
  `icon` varchar(255) NOT NULL DEFAULT '',
  `parent` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 136 DEFAULT CHARSET = utf8mb3;

;


;



;


;

;

CREATE TABLE `jcow_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `message` text,
  `from_id` int NOT NULL DEFAULT '0',
  `to_id` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `hasread` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from_id` (`from_id`, `to_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 25 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_messages_sent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `message` text,
  `from_id` int NOT NULL DEFAULT '0',
  `to_id` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `hasread` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `from_id` (`from_id`, `to_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_modules` (
  `name` varchar(50) NOT NULL DEFAULT '',
  `actived` tinyint(1) NOT NULL DEFAULT '0',
  `hooking` tinyint NOT NULL DEFAULT '0',
  KEY `name` (`name`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_modules`
VALUES
  ('browse', 1, 0),
  ('feed', 1, 0),
  ('dashboard', 1, 1),
  ('account', 1, 0),
  ('admin', 1, 1),
  ('u', 1, 0),
  ('member', 1, 0),
  ('follow', 1, 0),
  ('friends', 1, 0),
  ('jquery', 1, 0),
  ('language', 1, 0),
  ('message', 1, 0),
  ('notifications', 1, 0),
  ('preference', 1, 0),
  ('report', 1, 0),
  ('rss', 1, 0),
  ('search', 1, 0),
  ('invite', 1, 0),
  ('apps', 1, 0),
  ('blacklist', 1, 0),
  ('update', 1, 0),
  ('forums', 0, 1),
  ('forumadmin', 0, 0),
  ('ads', 0, 1),
  ('music', 0, 1),
  ('blogs', 0, 1),
  ('page', 0, 0),
  ('group', 0, 0),
  ('groups', 0, 1),
  ('videos', 0, 1),
  ('events', 0, 1),
  ('pages', 0, 1),
  ('questions', 0, 1),
  ('chatbar', 0, 1),
  ('cache', 0, 1),
  ('fblogin', 0, 0),
  ('mobile', 0, 1),
  ('hashtags', 0, 1),
  ('emailmarketing', 0, 1),
  ('polls', 0, 1),
  ('jobs', 0, 0),
  ('wiki', 0, 1),
  ('classifieds2', 0, 0);

;


;

;

CREATE TABLE `jcow_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `uri` varchar(200) NOT NULL DEFAULT '',
  `message` text,
  `from_uid` int NOT NULL DEFAULT '0',
  `hasread` tinyint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_page_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pid` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`, `uid`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_page_visitors` (
  `pid` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  KEY `pid_uid` (`pid`, `uid`),
  KEY `pid_updated` (`pid`, `updated`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uri` varchar(30) NOT NULL DEFAULT '',
  `uid` int NOT NULL DEFAULT '0',
  `views` int NOT NULL DEFAULT '0',
  `logo` varchar(200) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `style_ids` text,
  `custom_css` text,
  `background` varchar(200) NOT NULL DEFAULT '',
  `type` varchar(25) NOT NULL DEFAULT '',
  `description` text,
  `users` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  `var1` varchar(255) NOT NULL DEFAULT '',
  `var2` varchar(255) NOT NULL DEFAULT '',
  `var3` varchar(255) NOT NULL DEFAULT '',
  `text1` text,
  `text2` text,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `uri` (`uri`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb3;

;

;

;

CREATE TABLE `jcow_pending_review` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `content` text,
  `uri` varchar(255) NOT NULL DEFAULT '',
  `post_id` varchar(50) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `ignored` tinyint NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `post_id` (`post_id`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_points` (
  `uid` int NOT NULL,
  `type` text NOT NULL,
  `points` int NOT NULL,
  KEY `uid` (`uid`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_profile_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `target_id` int NOT NULL DEFAULT '0',
  `message` text,
  `created` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `stream_id` (`stream_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_profiles` (
  `id` int NOT NULL DEFAULT '0',
  `style_ids` varchar(255) NOT NULL DEFAULT '',
  `custom_css` text,
  `background` varchar(100) NOT NULL DEFAULT '',
  `videoid` int NOT NULL DEFAULT '0',
  `favorites` int NOT NULL DEFAULT '0',
  `views` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `message` text,
  `hasread` tinyint(1) NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL DEFAULT '0',
  `question` text,
  `answer` text,
  `created` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_roles` (
  `id` int NOT NULL DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_roles`
VALUES
  (1, 'Guest'),
  (2, 'General member'),
  (3, 'Administrator');

;


;

;

CREATE TABLE `jcow_shortcuts` (
  `uid` int NOT NULL,
  `page_id` int NOT NULL,
  `weight` int NOT NULL,
  KEY `uid` (`uid`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_signup_attempts` (
  `ipaddress` varchar(255) DEFAULT NULL,
  `created` int DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_spammers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userkey` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userkey` (`userkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_spammers_cloud` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userkey` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userkey` (`userkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_status_photos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sid` int NOT NULL DEFAULT '0',
  `pid` int NOT NULL DEFAULT '0',
  `uri` varchar(100) NOT NULL DEFAULT '',
  `des` varchar(255) NOT NULL DEFAULT '',
  `thumb` varchar(100) NOT NULL DEFAULT '',
  `size` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sid` (`sid`),
  KEY `pid` (`pid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_stories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` int NOT NULL DEFAULT '0',
  `sticky` tinyint NOT NULL DEFAULT '0',
  `closed` tinyint NOT NULL DEFAULT '0',
  `title` varchar(120) NOT NULL DEFAULT '',
  `thumbnail` varchar(255) NOT NULL DEFAULT '',
  `content` text,
  `uid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `lastreply` int NOT NULL DEFAULT '0',
  `lastreplyuname` varchar(50) NOT NULL DEFAULT '',
  `lastreplyuid` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  `views` int NOT NULL DEFAULT '0',
  `comments` int NOT NULL DEFAULT '0',
  `stream_id` int NOT NULL DEFAULT '0',
  `app` varchar(50) NOT NULL DEFAULT '',
  `digg` int NOT NULL DEFAULT '0',
  `dugg` int NOT NULL DEFAULT '0',
  `photos` int NOT NULL DEFAULT '0',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `featured` tinyint NOT NULL DEFAULT '0',
  `var1` varchar(255) NOT NULL DEFAULT '',
  `var2` varchar(255) NOT NULL DEFAULT '',
  `var3` varchar(255) NOT NULL DEFAULT '',
  `var4` varchar(255) NOT NULL DEFAULT '',
  `var5` varchar(255) NOT NULL DEFAULT '',
  `inte1` int NOT NULL DEFAULT '0',
  `inte2` int NOT NULL DEFAULT '0',
  `text1` text,
  `text2` text,
  `blob1` blob,
  `rating` text,
  `page_id` int NOT NULL DEFAULT '0',
  `page_type` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `app` (`app`),
  KEY `uid` (`uid`),
  KEY `page_id` (`page_id`),
  KEY `cid` (`cid`)
) ENGINE = InnoDB AUTO_INCREMENT = 79 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_story_cat_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `app` varchar(50) NOT NULL DEFAULT '',
  `weight` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_story_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL DEFAULT '',
  `description` text,
  `weight` int NOT NULL DEFAULT '0',
  `app` varchar(50) NOT NULL DEFAULT '',
  `var1` varchar(255) NOT NULL DEFAULT '',
  `var2` varchar(255) NOT NULL DEFAULT '',
  `var3` varchar(255) NOT NULL DEFAULT '',
  `var4` varchar(255) NOT NULL DEFAULT '',
  `var5` varchar(255) NOT NULL DEFAULT '',
  `uri` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `app` (`app`),
  KEY `weight` (`weight`)
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_story_photos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sid` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `uri` varchar(100) NOT NULL DEFAULT '',
  `des` varchar(255) NOT NULL DEFAULT '',
  `thumb` varchar(100) NOT NULL DEFAULT '',
  `size` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sid` (`sid`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB AUTO_INCREMENT = 48 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_streams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `message` text,
  `wall_id` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  `comments` int NOT NULL DEFAULT '0',
  `attachment` text,
  `like_types` text,
  `created` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `app` varchar(20) NOT NULL DEFAULT '',
  `fb_post_id` varchar(50) NOT NULL DEFAULT '',
  `aid` int NOT NULL DEFAULT '0',
  `hide` tinyint(1) NOT NULL DEFAULT '0',
  `likes` int NOT NULL DEFAULT '0',
  `dislikes` int NOT NULL DEFAULT '0',
  `stuff_id` int NOT NULL DEFAULT '0',
  `audio_uri` varchar(255) NOT NULL DEFAULT '',
  `pid` int NOT NULL DEFAULT '0',
  `data` text,
  PRIMARY KEY (`id`),
  KEY `app` (`app`),
  KEY `aid` (`aid`),
  KEY `jcow_streams_wall_id` (`wall_id`),
  KEY `stuff_id` (`stuff_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

;


;

;


;

;

CREATE TABLE `jcow_subscr` (
  `id` varchar(32) NOT NULL DEFAULT '',
  `item_number` varchar(32) NOT NULL DEFAULT '',
  `status` varchar(25) NOT NULL DEFAULT '',
  `uid` int NOT NULL DEFAULT '0',
  `timeline` int NOT NULL DEFAULT '0',
  KEY `id` (`id`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_tag_ids` (
  `tid` int NOT NULL DEFAULT '0',
  `sid` int NOT NULL DEFAULT '0',
  KEY `tid` (`tid`, `sid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `app` varchar(25) NOT NULL DEFAULT '',
  `lowercase` varchar(100) NOT NULL DEFAULT '',
  `num` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `lowercase` (`lowercase`)
) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_texts` (
  `tkey` varchar(50) NOT NULL DEFAULT '',
  `tvalue` text,
  KEY `tkey` (`tkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

INSERT INTO
  `jcow_texts`
VALUES
  (
    'welcome_pm',
    'Hello %username%!\r\nThank you for your registeration!\r\nPlease invite your friends to join our community.'
  ),
  (
    'welcome_email',
    'Dear %username%,\r\nWelcome to %sitelink%!\r\nYour login email is: %email%\r\nOur URL is:\r\n%sitelink%'
  ),
  ('welcome_msg', 'Welcome to our Community!'),
  ('rules_conditions', 'none'),
  ('footermsg', 'Your footer here..'),
  (
    'locations',
    'Afghanistan  \r\nAlbania  \r\nAlgeria  \r\nAmerican Samoa  \r\nAndorra  \r\nAngola  \r\nAnguilla  \r\nAntarctica  \r\nAntigua and Barbuda  \r\nArgentina  \r\nArmenia  \r\nAruba  \r\nAustralia  \r\nAustria  \r\nAzerbaidjan  \r\nBahamas  \r\nBahrain  \r\nBangladesh  \r\nBarbados  \r\nBelarus  \r\nBelgium  \r\nBelize  \r\nBenin  \r\nBermuda  \r\nBhutan  \r\nBolivia  \r\nBosnia-Herzegovina  \r\nBotswana  \r\nBouvet Island  \r\nBrazil  \r\nBrunei Darussalam  \r\nBulgaria  \r\nBurkina Faso  \r\nBurundi  \r\nCambodia  \r\nCameroon  \r\nCanada  \r\nCape Verde  \r\nCayman Islands  \r\nCentral African Republic  \r\nChad  \r\nChile  \r\nChina  \r\nChristmas Island  \r\nCocos Islands  \r\nColombia  \r\nComoros  \r\nCongo  \r\nCook Islands  \r\nCosta Rica  \r\nCroatia  \r\nCuba  \r\nCyprus  \r\nCzech Republic  \r\nDenmark  \r\nDjibouti  \r\nDominica  \r\nDominican Republic  \r\nEast Timor  \r\nEcuador  \r\nEgypt  \r\nEl Salvador  \r\nEquatorial Guinea  \r\nEstonia  \r\nEthiopia  \r\nFalkland Islands  \r\nFaroe Islands  \r\nFiji  \r\nFinland  \r\nFormer Czechoslovakia  \r\nFrance  \r\nFrench Guyana  \r\nGabon  \r\nGambia  \r\nGeorgia  \r\nGermany  \r\nGhana  \r\nGibraltar  \r\nGreat Britain  \r\nGreece  \r\nGreenland  \r\nGrenada  \r\nGuadeloupe  \r\nGuam  \r\nGuatemala  \r\nGuinea  \r\nGuinea Bissau  \r\nGuyana  \r\nHaiti  \r\nHonduras  \r\nHong Kong  \r\nHungary  \r\nIceland  \r\nIndia  \r\nIndonesia  \r\nIran  \r\nIraq  \r\nIreland  \r\nIsrael  \r\nItaly  \r\nIvory Coast  \r\nJamaica  \r\nJapan  \r\nJordan  \r\nKazakhstan  \r\nKenya  \r\nKiribati  \r\nKuwait  \r\nKyrgyzstan  \r\nLaos  \r\nLatvia  \r\nLebanon  \r\nLesotho  \r\nLiberia  \r\nLibya  \r\nLiechtenstein  \r\nLithuania  \r\nLuxembourg  \r\nMacau  \r\nMacedonia  \r\nMadagascar  \r\nMalawi  \r\nMalaysia  \r\nMaldives  \r\nMali  \r\nMalta  \r\nMarshall Islands  \r\nMartinique  \r\nMauritania  \r\nMauritius  \r\nMayotte  \r\nMexico  \r\nMicronesia  \r\nMoldavia  \r\nMonaco  \r\nMongolia  \r\nMontserrat  \r\nMorocco  \r\nMozambique  \r\nMyanmar  \r\nNamibia  \r\nNauru  \r\nNepal  \r\nNetherlands  \r\nNetherlands Antilles  \r\nNeutral Zone  \r\nNew Caledonia  \r\nNew Zealand  \r\nNicaragua  \r\nNiger  \r\nNigeria  \r\nNiue  \r\nNorfolk Island  \r\nNorth Korea  \r\nNorway  \r\nOman  \r\nPakistan  \r\nPalau  \r\nPanama  \r\nPapua New Guinea  \r\nParaguay  \r\nPeru  \r\nPhilippines  \r\nPitcairn Island  \r\nPoland  \r\nPolynesia  \r\nPortugal  \r\nPuerto Rico  \r\nQatar  \r\nReunion  \r\nRomania  \r\nRussian Federation  \r\nRwanda  \r\nSaint Helena  \r\nSaint Lucia  \r\nSaint Vincent and Grenadines  \r\nSamoa  \r\nSan Marino  \r\nSaudi Arabia  \r\nSenegal  \r\nSeychelles  \r\nSierra Leone  \r\nSingapore  \r\nSlovak Republic  \r\nSlovenia  \r\nSolomon Islands  \r\nSomalia  \r\nSouth Africa  \r\nSouth Korea  \r\nSpain  \r\nSri Lanka  \r\nSudan  \r\nSuriname  \r\nSwaziland  \r\nSweden  \r\nSwitzerland  \r\nSyria  \r\nTadjikistan  \r\nTaiwan  \r\nTanzania  \r\nThailand  \r\nTogo  \r\nTokelau  \r\nTonga  \r\nTrinidad and Tobago  \r\nTunisia  \r\nTurkey  \r\nTurkmenistan  \r\nTuvalu  \r\nUganda  \r\nUkraine  \r\nUnited Arab Emirates  \r\nUnited Kingdom  \r\nUnited States  \r\nUruguay  \r\nUzbekistan  \r\nVanuatu  \r\nVatican City State  \r\nVenezuela  \r\nVietnam  \r\nVirgin Islands (British)  \r\nVirgin Islands (USA)  \r\nWallis and Futuna Islands  \r\nWestern Sahara  \r\nYemen  \r\nYugoslavia  \r\nZaire  \r\nZambia  \r\nZimbabwe'
  );

;


;

;

CREATE TABLE `jcow_tmp` (
  `tkey` varchar(70) NOT NULL DEFAULT '',
  `tcontent` text,
  KEY `tkey` (`tkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_topic_ids` (
  `tid` int NOT NULL DEFAULT '0',
  `sid` int NOT NULL DEFAULT '0',
  KEY `tid` (`tid`, `sid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_topics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `stories` int NOT NULL DEFAULT '0',
  `followers` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL DEFAULT '0',
  `featured` tinyint NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `stories` (`stories`),
  KEY `featured` (`featured`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_topics_followed` (
  `uid` int NOT NULL DEFAULT '0',
  `tid` int NOT NULL DEFAULT '0',
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_user_crafts` (
  `uid` int NOT NULL DEFAULT '0',
  `hash` varchar(5) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  KEY `uid` (`uid`, `created`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_var_cache` (
  `name` varchar(60) NOT NULL DEFAULT '',
  `content` varchar(255) NOT NULL DEFAULT '',
  `created` int NOT NULL DEFAULT '0',
  KEY `name` (`name`, `created`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_votes` (
  `sid` int NOT NULL DEFAULT '0',
  `created` int NOT NULL DEFAULT '0',
  `rate` int NOT NULL DEFAULT '0',
  `uid` int NOT NULL DEFAULT '0',
  KEY `sid` (`sid`, `uid`),
  KEY `created` (`created`),
  KEY `uid` (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

CREATE TABLE `jcow_wiki_versions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `sid` int NOT NULL,
  `created` int NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `tags` text NOT NULL,
  `note` text NOT NULL,
  `type` text NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sid` (`sid`),
  KEY `uid` (`uid`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb3;

;


;

;


;

;

;

;

;

;

;

;