Compalex

Database schema compare tool

tables views procedures functions indexes triggers  all changed

compalex_dev

localhost/compalex_dev

compalex_prod

localhost/compalex_prod

customer_list 0

customer_list 9

  • ID smallint(5) unsigned
  • name varchar(91)
  • address varchar(50)
  • zip code varchar(10)
  • phone varchar(20)
  • city varchar(50)
  • country varchar(50)
  • notes varchar(6)
  • SID tinyint(3) unsigned
Sample data (100 rows)

film_list 8

  • FID smallint(5) unsigned
  • title varchar(255)
  • description text
  • category varchar(25)
  • price decimal(4,2)
  • length smallint(5) unsigned
  • rating enum('G','PG','PG-13','R','NC-17')
  • actors text
Sample data (100 rows)

film_list 8

  • FID smallint(5) unsigned
  • title varchar(255)
  • description text
  • category varchar(25)
  • price decimal(4,2)
  • length smallint(5) unsigned
  • rating enum('G','PG','PG-13','R','NC-17')
  • actors text
Sample data (100 rows)

nicer_but_slower_film_list 8

  • FID smallint(5) unsigned
  • title varchar(255)
  • description text
  • category varchar(25)
  • price decimal(4,2)
  • length smallint(5) unsigned
  • rating enum('G','PG','PG-13','R','NC-17')
  • actors text
Sample data (100 rows)

nicer_but_slower_film_list 8

  • FID smallint(5) unsigned
  • title varchar(255)
  • description text
  • category varchar(25)
  • price decimal(4,2)
  • length smallint(5) unsigned
  • rating enum('G','PG','PG-13','R','NC-17')
  • actors text
Sample data (100 rows)

sales_by_film_category 2

  • category varchar(25)
  • total_sales decimal(27,2)
Sample data (100 rows)

sales_by_film_category 2

  • category varchar(25)
  • total_sales decimal(27,2)
Sample data (100 rows)

sales_by_store 3

  • store varchar(101)
  • manager varchar(91)
  • total_sales decimal(27,2)
Sample data (100 rows)

sales_by_store 3

  • store varchar(101)
  • manager varchar(91)
  • total_sales decimal(27,2)
Sample data (100 rows)

staff_list 8

  • ID tinyint(3) unsigned
  • name varchar(91)
  • address varchar(50)
  • zip code varchar(10)
  • phone varchar(20)
  • city varchar(50)
  • country varchar(50)
  • SID tinyint(3) unsigned
Sample data (100 rows)

staff_list 8

  • ID tinyint(3) unsigned
  • name varchar(91)
  • address varchar(50)
  • zip code varchar(10)
  • phone varchar(20)
  • city varchar(50)
  • country varchar(50)
  • SID tinyint(3) unsigned
Sample data (100 rows)