nooku is a Public Portfolio from Assembla

Assembla offers free public and private SVN/Git repositories and project hosting with bug/issue tracking and collaboration tools.

Create your own Portfolio or check out other free and subscription products from Assembla that will help accelerate your development projects.

nooku-server

Commit 3533

User picture
  • Author: ercanozkaya
  • 2012-04-02 13:51 (about 2 years ago)

re #207: Add semi-colons to the end of queries

Files Affected

 
35323533
1
# Change session table storage engine to InnoDB
1
# Change session table storage engine to InnoDB
2
# http://nooku.assembla.com/spaces/nooku-server/tickets/190
2
# http://nooku.assembla.com/spaces/nooku-server/tickets/190
3
ALTER TABLE `#__session` ENGINE InnoDB
3
ALTER TABLE `#__session` ENGINE InnoDB;
4
 
4
 
5
# Make sure email and username are unique fields
5
# Make sure email and username are unique fields
6
ALTER TABLE  `#__users` ADD UNIQUE  `username` (  `username` )
6
ALTER TABLE  `#__users` ADD UNIQUE  `username` (  `username` );
7
ALTER TABLE  `#__users` ADD UNIQUE  `email` (  `email` )
7
ALTER TABLE  `#__users` ADD UNIQUE  `email` (  `email` );
8
 
8
 
9
# Add UUID field required by identifiable behahvior
9
# Add UUID field required by identifiable behahvior
10
ALTER TABLE  `#__users` ADD  `uuid` VARCHAR( 36 ) NOT NULL , ADD UNIQUE (`uuid`)
10
ALTER TABLE  `#__users` ADD  `uuid` VARCHAR( 36 ) NOT NULL , ADD UNIQUE (`uuid`);