← Back to branch summary

~automne-team/automne/4.1

« back to all changes in this revision

Viewing changes to automne/sql/updates/v402-to-v410-2.sql

  • Committer: sebastien
  • Date: 2010-10-13 15:57:36 UTC
  • mto: This revision was merged to the branch mainline in revision 303.
  • Revision ID: sebastien.pauchet@ws-interactive.fr-20101013155736-y74xmc1d0zb6es2l
Move directories :
/html to /automne/html
/sql to /automne/sql
/automne_bin to /automne/bin
/automne_modules_files to /files

Show diffs side-by-side

added added

removed removed

Lines of Context:
automne/sql/updates/v402-to-v410-2.sql
 
1
ALTER TABLE `pagesBaseData_public` ADD `codename_pbd` VARCHAR( 20 ) NOT NULL ;
 
2
ALTER TABLE `pagesBaseData_edited` ADD `codename_pbd` VARCHAR( 20 ) NOT NULL ;
 
3
ALTER TABLE `pagesBaseData_deleted` ADD `codename_pbd` VARCHAR( 20 ) NOT NULL ;
 
4
ALTER TABLE `pagesBaseData_archived` ADD `codename_pbd` VARCHAR( 20 ) NOT NULL ;
 
5
 
 
6
ALTER TABLE  `pagesBaseData_public` DROP INDEX  `title_pbd` ,
 
7
ADD FULLTEXT  `title_pbd` (
 
8
`title_pbd` ,
 
9
`linkTitle_pbd` ,
 
10
`keywords_pbd` ,
 
11
`description_pbd` ,
 
12
`codename_pbd`
 
13
)
 
14
ALTER TABLE  `pagesBaseData_edited` DROP INDEX  `title_pbd` ,
 
15
ADD FULLTEXT  `title_pbd` (
 
16
`title_pbd` ,
 
17
`linkTitle_pbd` ,
 
18
`keywords_pbd` ,
 
19
`description_pbd` ,
 
20
`codename_pbd`
 
21
)
 
 
b'\\ No newline at end of file'