Compalex

Database schema compare tool

tables views procedures functions indexes triggers  all changed

compalex_dev

localhost/compalex_dev

compalex_prod

localhost/compalex_prod

actor 4

engine: InnoDB
collation: utf8_general_ci
  • actor_id smallint(5) unsigned
  • first_name varchar(45)
  • last_name varchar(45)
  • last_update timestamp
Sample data (100 rows)

actor 4

engine: InnoDB
collation: utf8_general_ci
  • actor_id smallint(5) unsigned
  • first_name varchar(45)
  • last_name varchar(45)
  • last_update timestamp
Sample data (100 rows)

address 7

engine: InnoDB
collation: utf8_general_ci
  • address_id smallint(5) unsigned
  • address varchar(50)
  • district varchar(20)
  • city_id smallint(5) unsigned
  • postal_code varchar(10)
  • phone varchar(20)
  • last_update timestamp
Sample data (100 rows)

address 8

engine: InnoDB
collation: utf8_general_ci
  • address_id smallint(5) unsigned
  • address varchar(50)
  • address2 varchar(50)
  • district varchar(20)
  • city_id smallint(5) unsigned
  • postal_code varchar(10)
  • phone varchar(20)
  • last_update timestamp
Sample data (100 rows)

category 3

engine: InnoDB
collation: utf8_general_ci
  • category_id tinyint(3) unsigned
  • name varchar(25)
  • last_update timestamp
Sample data (100 rows)

category 3

engine: InnoDB
collation: utf8_general_ci
  • category_id tinyint(3) unsigned
  • name varchar(25)
  • last_update timestamp
Sample data (100 rows)

city 4

engine: InnoDB
collation: utf8_general_ci
  • city_id smallint(5) unsigned
  • city varchar(50)
  • country_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)

city 4

engine: InnoDB
collation: utf8_general_ci
  • city_id smallint(5) unsigned
  • city varchar(50)
  • country_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)

country 3

engine: InnoDB
collation: utf8_general_ci
  • country_id smallint(5) unsigned
  • country varchar(50)
  • last_update timestamp
Sample data (100 rows)

country 3

engine: InnoDB
collation: utf8_general_ci
  • country_id smallint(5) unsigned
  • country varchar(50)
  • last_update timestamp
Sample data (100 rows)

customer 8

engine: InnoDB
collation: utf8_general_ci
  • customer_id smallint(5) unsigned
  • store_id tinyint(3) unsigned
  • first_name varchar(45)
  • email varchar(50)
  • address_id smallint(5) unsigned
  • active tinyint(1)
  • create_date datetime
  • last_update timestamp
Sample data (100 rows)

customer 9

engine: InnoDB
collation: utf8_general_ci
  • customer_id smallint(5) unsigned
  • store_id tinyint(3) unsigned
  • first_name varchar(45)
  • last_name varchar(45)
  • email varchar(50)
  • address_id smallint(5) unsigned
  • active tinyint(1)
  • create_date datetime
  • last_update timestamp
Sample data (100 rows)

film 13

engine: InnoDB
collation: utf8_general_ci
  • film_id smallint(5) unsigned
  • title varchar(255)
  • description text
  • release_year year(4)
  • language_id tinyint(3) unsigned
  • original_language_id tinyint(3) unsigned
  • rental_duration tinyint(3) unsigned
  • rental_rate decimal(4,2)
  • length smallint(5) unsigned
  • replacement_cost decimal(5,2)
  • rating enum('G','PG','PG-13','R','NC-17')
  • special_features set('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
  • last_update timestamp
Sample data (100 rows)

film 13

engine: InnoDB
collation: utf8_general_ci
  • film_id smallint(5) unsigned
  • title varchar(255)
  • description text
  • release_year year(4)
  • language_id tinyint(3) unsigned
  • original_language_id tinyint(3) unsigned
  • rental_duration tinyint(3) unsigned
  • rental_rate decimal(4,2)
  • length smallint(5) unsigned
  • replacement_cost decimal(5,2)
  • rating enum('G','PG','PG-13','R','NC-17')
  • special_features set('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
  • last_update timestamp
Sample data (100 rows)

film_actor 3

engine: InnoDB
collation: utf8_general_ci
  • actor_id smallint(5) unsigned
  • film_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)

film_actor 3

engine: InnoDB
collation: utf8_general_ci
  • actor_id smallint(5) unsigned
  • film_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)

film_category 3

engine: InnoDB
collation: utf8_general_ci
  • film_id smallint(5) unsigned
  • category_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

film_category 3

engine: InnoDB
collation: utf8_general_ci
  • film_id smallint(5) unsigned
  • category_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

film_text 3

engine: MyISAM
collation: utf8_general_ci
  • film_id smallint(6)
  • title varchar(255)
  • description text
Sample data (100 rows)

film_text 0

inventory 4

engine: InnoDB
collation: utf8_general_ci
  • inventory_id mediumint(8) unsigned
  • film_id smallint(5) unsigned
  • store_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

inventory 4

engine: InnoDB
collation: utf8_general_ci
  • inventory_id mediumint(8) unsigned
  • film_id smallint(5) unsigned
  • store_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

language 3

engine: InnoDB
collation: utf8_general_ci
  • language_id tinyint(3) unsigned
  • name char(20)
  • last_update timestamp
Sample data (100 rows)

language 3

engine: InnoDB
collation: utf8_general_ci
  • language_id tinyint(3) unsigned
  • name char(20)
  • last_update timestamp
Sample data (100 rows)

payment 7

engine: InnoDB
collation: utf8_general_ci
  • payment_id smallint(5) unsigned
  • customer_id smallint(5) unsigned
  • staff_id tinyint(3) unsigned
  • rental_id int(11)
  • amount decimal(5,2)
  • payment_date datetime
  • last_update timestamp
Sample data (100 rows)

payment 7

engine: InnoDB
collation: utf8_general_ci
  • payment_id smallint(5) unsigned
  • customer_id smallint(5) unsigned
  • staff_id tinyint(3) unsigned
  • rental_id int(11)
  • amount decimal(5,2)
  • payment_date datetime
  • last_update timestamp
Sample data (100 rows)

rental 7

engine: InnoDB
collation: utf8_general_ci
  • rental_id int(11)
  • rental_date datetime
  • inventory_id mediumint(8) unsigned
  • customer_id smallint(5) unsigned
  • return_date datetime
  • staff_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

rental 7

engine: InnoDB
collation: utf8_general_ci
  • rental_id int(11)
  • rental_date datetime
  • inventory_id mediumint(8) unsigned
  • customer_id smallint(5) unsigned
  • return_date datetime
  • staff_id tinyint(3) unsigned
  • last_update timestamp
Sample data (100 rows)

staff 11

engine: InnoDB
collation: utf8_general_ci
  • staff_id tinyint(3) unsigned
  • first_name varchar(45)
  • last_name varchar(45)
  • address_id smallint(5) unsigned
  • picture blob
  • email varchar(50)
  • store_id tinyint(3) unsigned
  • active tinyint(1)
  • username varchar(16)
  • password varchar(40)
  • last_update timestamp
Sample data (100 rows)

staff 10

engine: InnoDB
collation: utf8_general_ci
  • staff_id tinyint(3) unsigned
  • first_name varchar(45)
  • last_name varchar(45)
  • address_id smallint(5) unsigned
  • email varchar(50)
  • store_id tinyint(3) unsigned
  • active tinyint(1)
  • username varchar(16)
  • password varchar(40)
  • last_update timestamp
Sample data (100 rows)

store 4

engine: InnoDB
collation: utf8_general_ci
  • store_id tinyint(3) unsigned
  • manager_staff_id tinyint(3) unsigned
  • address_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)

store 4

engine: InnoDB
collation: utf8_general_ci
  • store_id tinyint(3) unsigned
  • manager_staff_id tinyint(3) unsigned
  • address_id smallint(5) unsigned
  • last_update timestamp
Sample data (100 rows)