hi,

i read alembic documentation but its still hard for me transform this 
example table to alembic


CREATE TABLE `user_properties` (
  `users_id` int(11) NOT NULL COMMENT 'ID from users table',
  `property_name` varchar(255) NOT NULL COMMENT 'property key',
  `property_value` mediumtext NOT NULL COMMENT 'property value',
  UNIQUE KEY `property_name_users_id` (`property_name`,`users_id`),
  KEY `users_id` (`users_id`),
  CONSTRAINT `user_properties_ibfk_1` FOREIGN KEY (`users_id`) REFERENCES 
`users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user properties';


is there some alembic helper which can analyze sql create table?

if not. i think i understand howto transform columns 

but can you help me with 
  UNIQUE KEY `property_name_users_id` (`property_name`,`users_id`),
  KEY `users_id` (`users_id`),
  CONSTRAINT `user_properties_ibfk_1` FOREIGN KEY (`users_id`) REFERENCES 
`users` (`id`) ON DELETE CASCADE

thanks
Marek

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to