← Back to branch summary

~automne-team/automne/4.1

« back to all changes in this revision

Viewing changes to 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:
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'