Version Table Result

[dbsrgits/DBIx-Class-DeploymentHandler.git] / lib / DBIx / Class / DeploymentHandler / VersionResult.pm

diff --git a/lib/DBIx/Class/DeploymentHandler/VersionResult.pm b/lib/DBIx/Class/DeploymentHandler/VersionResult.pm
new file mode 100644 (file)
index 0000000..f5f7663
--- /dev/null
+++ b/lib/DBIx/Class/DeploymentHandler/VersionResult.pm
@@ -0,0 +1,32 @@
+package DBIx::Class::DepolymentHandler::VersionResult;
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class::Core';
+
+__PACKAGE__->table('dbix_class_deploymenthandler_versions');
+
+__PACKAGE__->add_columns (
+       installed => {
+               data_type         => 'int',
+               is_auto_increment => 1,
+       },
+       version => {
+               data_type         => 'varchar',
+               size              => '20'
+       },
+       ddl => {
+               data_type         => 'text',
+               is_nullable       => 1,
+       },
+       upgrade_sql => {
+               data_type         => 'text',
+               is_nullable       => 1,
+       },
+);
+
+__PACKAGE__->set_primary_key('installed');
+__PACKAGE__->add_unique_constraint(['version']);
+
+1;