Enano CMS (1.1.x): comparison schema.sql

equal deleted inserted replaced

-:53ba55d33abb
+:8acd77a6c19d
 CREATE TABLE {{TABLE_PREFIX}}categories(
 page_id varchar(64),
 namespace varchar(64),
 category_id varchar(64)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}comments(
 comment_id int(12) NOT NULL auto_increment,
 page_id text,
 namespace text,
 name text,
 approved tinyint(1) default 1,
 user_id mediumint(8) NOT NULL DEFAULT -1,
 time int(12) NOT NULL DEFAULT 0,
 PRIMARY KEY ( comment_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}config(
 config_name varchar(63),
 config_value text
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}logs(
 log_type varchar(16),
 action varchar(16),
 time_id int(12) NOT NULL default '0',
 page_text text,
 char_tag varchar(40),
 author varchar(63),
 edit_summary text,
 minor_edit tinyint(1)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}page_text(
 page_id varchar(63),
 namespace varchar(16) NOT NULL default 'Article',
 page_text text,
 protected tinyint(1) NOT NULL DEFAULT 0,
 wiki_mode tinyint(1) NOT NULL DEFAULT 2,
 delvotes int(10) NOT NULL default 0,
 password varchar(40) NOT NULL DEFAULT '',
 delvote_ips text DEFAULT NULL
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}session_keys(
 session_key varchar(32),
 salt varchar(32),
 user_id mediumint(8),
 auth_level tinyint(1) NOT NULL default '0',
 source_ip varchar(10) default '0x7f000001',
 time bigint(15) default '0'
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}themes(
 theme_id varchar(63),
 theme_name text,
 theme_order smallint(5) NOT NULL default '1',
 default_style varchar(63) NOT NULL DEFAULT '',
 enabled tinyint(1) NOT NULL default '1'
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}users(
 user_id mediumint(8) NOT NULL auto_increment,
 username text,
 password varchar(255),
 temp_password text,
 temp_password_time int(12) NOT NULL DEFAULT 0,
 user_coppa tinyint(1) NOT NULL DEFAULT 0,
 user_lang smallint(5) NOT NULL,
 PRIMARY KEY  (user_id)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}users_extra(
 user_id mediumint(8) NOT NULL,
 user_aim varchar(63),
 user_yahoo varchar(63),
 user_location text,
 user_job text,
 user_hobbies text,
 email_public tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY ( user_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}banlist(
 ban_id mediumint(8) NOT NULL auto_increment,
 ban_type tinyint(1),
 ban_value varchar(64),
 is_regex tinyint(1) DEFAULT 0,
 reason text,
 PRIMARY KEY ( ban_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}files(
 file_id int(12) NOT NULL auto_increment,
 time_id int(12) NOT NULL,
 page_id varchar(63) NOT NULL,
 size bigint(15) NOT NULL,
 mimetype varchar(63) default NULL,
 file_extension varchar(8) default NULL,
 file_key varchar(32) NOT NULL,
 PRIMARY KEY (file_id)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}buddies(
 buddy_id int(15) NOT NULL auto_increment,
 user_id mediumint(8),
 buddy_user_id mediumint(8),
 is_friend tinyint(1) NOT NULL default '1',
 PRIMARY KEY  (buddy_id)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}privmsgs(
 message_id int(15) NOT NULL auto_increment,
 message_from varchar(63),
 message_to varchar(255),
 subject varchar(63),
 message_text text,
 folder_name varchar(63),
 message_read tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY  (message_id)
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}sidebar(
 item_id smallint(3) NOT NULL auto_increment,
 item_order smallint(3) NOT NULL DEFAULT 0,
 item_enabled tinyint(1) NOT NULL DEFAULT 1,
 sidebar_id smallint(3) NOT NULL DEFAULT 1,
 block_name varchar(63) NOT NULL,
 block_type tinyint(1) NOT NULL DEFAULT 0,
 block_content text,
 PRIMARY KEY ( item_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}hits(
 hit_id bigint(20) NOT NULL auto_increment,
 username varchar(63) NOT NULL,
 time int(12) NOT NULL DEFAULT 0,
 page_id varchar(63),
 namespace varchar(63),
 PRIMARY KEY ( hit_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}search_index(
-word varbinary(64) NOT NULL,
+word varchar(64) NOT NULL,
 page_names text,
 PRIMARY KEY ( word )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}groups(
 group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
 group_name varchar(64),
 group_type tinyint(1) NOT NULL DEFAULT 1,
 PRIMARY KEY ( group_id ),
 system_group tinyint(1) NOT NULL DEFAULT 0
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}group_members(
 member_id int(12) UNSIGNED NOT NULL auto_increment,
 group_id mediumint(5) UNSIGNED NOT NULL,
 user_id int(12) NOT NULL,
 is_mod tinyint(1) NOT NULL DEFAULT 0,
 pending tinyint(1) NOT NULL DEFAULT 0,
 PRIMARY KEY ( member_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 CREATE TABLE {{TABLE_PREFIX}}acl(
 rule_id int(12) UNSIGNED NOT NULL auto_increment,
 target_type tinyint(1) UNSIGNED NOT NULL,
 target_id int(12) UNSIGNED NOT NULL,
 page_id varchar(255),
 namespace varchar(24),
 rules text,
 PRIMARY KEY ( rule_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-CREATE TABLE {{TABLE_PREFIX}}search_cache(
-search_id int(15) NOT NULL auto_increment,
-search_time int(11) NOT NULL,
-query text,
-results longblob,
-PRIMARY KEY ( search_id )
-) CHARACTER SET `utf8`;
 -- Added in 1.0.1
 CREATE TABLE {{TABLE_PREFIX}}page_groups(
 pg_id mediumint(8) NOT NULL auto_increment,
 pg_type tinyint(2) NOT NULL DEFAULT 1,
 pg_name varchar(255) NOT NULL DEFAULT '',
 pg_target varchar(255) DEFAULT NULL,
 PRIMARY KEY ( pg_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 -- Added in 1.0.1
 CREATE TABLE {{TABLE_PREFIX}}page_group_members(
 pg_member_id int(12) NOT NULL auto_increment,
 pg_id mediumint(8) NOT NULL,
 page_id varchar(63) NOT NULL,
 namespace varchar(63) NOT NULL DEFAULT 'Article',
 PRIMARY KEY ( pg_member_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 -- Added in 1.0.1
 CREATE TABLE {{TABLE_PREFIX}}tags(
 tag_id int(12) NOT NULL auto_increment,
 tag_name varchar(63) NOT NULL DEFAULT 'bla',
 page_id varchar(255) NOT NULL,
 namespace varchar(255) NOT NULL,
 user mediumint(8) NOT NULL DEFAULT 1,
 PRIMARY KEY ( tag_id )
-) CHARACTER SET `utf8`;
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 -- Added in 1.1.1
 CREATE TABLE {{TABLE_PREFIX}}lockout(
 id int(12) NOT NULL auto_increment,

changeset 279	8acd77a6c19d
parent 266	917dcc6c4ceb
parent 275	956263992d48
child 304	e2cb5f1432c8