Contents

USE `ridgepole_test`;

DROP TABLE IF EXISTS `clubs`;
CREATE TABLE `clubs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
);

DROP TABLE IF EXISTS `places`;
CREATE TABLE `places` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `location` geometry NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
);

Version data entries

43 entries across 43 versions & 1 rubygems

Version	Path
ridgepole-0.8.1	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.8.0	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.8.0.rc2	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.8	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.8.0.rc1	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.7	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.6	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.5	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.5.beta3	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.5.beta2	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.5.beta	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.4	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.3	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.3.beta3	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.3.beta2	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.3.beta	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.2	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.2.beta	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.1	spec/mysql/ridgepole_test_tables_unknown_column_type.sql
ridgepole-0.7.1.beta5	spec/mysql/ridgepole_test_tables_unknown_column_type.sql