Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create_table :words, {:id => false} do |t|
- t.integer :id
- t.integer :language_id
- t.string :value
- t.timestamps
- end
- execute "ALTER TABLE words ADD PRIMARY KEY (id,language_id);"
- class Word < ActiveRecord::Base
- self.primary_keys = :id,:language_id
- end
- CREATE TABLE Project_Lang(
- project_id INT NOT NULL,
- language_id INT NOT NULL,
- title VARCHAR(80),
- description TEXT,
- PRIMARY KEY pk_Project_Lang(project_id, language_id),
- FOREIGN KEY fk_Project_Lang_Project(project_id)
- REFERENCES Project(project_id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- FOREIGN KEY fk_Project_Lang_Language(language_id)
- REFERENCES Language(language_id)
- ON DELETE RESTRICT ON UPDATE CASCADE
- )ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_spanish_ci;
- CREATE TABLE Project_Lang(
- project_lang_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
- project_id INT NOT NULL,
- language_id INT NOT NULL,
- title VARCHAR(80),
- description TEXT,
- UNIQUE INDEX(project_id, language_id),
- FOREIGN KEY fk_Project_Lang_Project(project_id)
- REFERENCES Project(project_id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- FOREIGN KEY fk_Project_Lang_Language(language_id)
- REFERENCES Language(language_id)
- ON DELETE RESTRICT ON UPDATE CASCADE
- )ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_spanish_ci;
- self.primary_key = "project_lang_id"
- class User < ActiveRecord::Base
- has_secure_password
- self.primary_keys = :name
- end
- class CreateUsers < ActiveRecord::Migration
- def change
- create_table :users do |t|
- t.string :name, null: false
- t.string :emailid
- t.string :password_digest
- t.integer :locked, :default => 0
- t.text :secretquestion
- t.string :answer
- t.timestamps null: false
- end
- add_index :users, :name, :unique => true
- end
- end
- ALTER TABLE sections DROP PRIMARY KEY, ADD PRIMARY KEY(id, workspace_id, section_key);
- create_table :words, primary_key: [:id, :language_id] do |t|
- t.integer :id
- t.integer :language_id
- t.string :value
- t.timestamps
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement