lorien lorien web domains web_site manage py sqlevolve blsearch dev nu

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
lorien@lorien /web/domains/web_site $ ./manage.py sqlevolve blsearch 2>/dev/null
BEGIN;
ALTER TABLE `blsearch_link` MODIFY COLUMN `anchor` longtext NOT NULL;
ALTER TABLE `blsearch_link` ALTER COLUMN `anchor` SET DEFAULT '';
COMMIT;
lorien@lorien /web/domains/web_site $ ./manage.py sqlevolve blsearch 2>/dev/null | mysql doorgen
lorien@lorien /web/domains/web_site $ ./manage.py sqlevolve blsearch 2>/dev/null
BEGIN;
ALTER TABLE `blsearch_link` MODIFY COLUMN `anchor` longtext NOT NULL;
ALTER TABLE `blsearch_link` ALTER COLUMN `anchor` SET DEFAULT '';
COMMIT;
lorien@lorien /web/domains/web_site $ mysql -e 'show create table doorgen.blsearch_link'
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| blsearch_link | CREATE TABLE `blsearch_link` (
`id` int(11) NOT NULL auto_increment,
`anchor` longtext NOT NULL,
`src_url` longtext NOT NULL,
`dst_url` longtext NOT NULL,
`time_touched` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+