jro_apps/redmine Files · vendor/plugins/classic_pagination/test/fixtures/schema.sql

Port async delivery methods to Rails 3....

Port async delivery methods to Rails 3. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@9532 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r962:6d9490ddcc9c


                r9350:26868d8b1404

Download file

             schema.sql
        
                    42 lines
            
             | 948 B
            
                | text/x-sql
            
             |
                SqlLexer
            
             / vendor / plugins / classic_pagination / test / fixtures / schema.sql
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Jean-Philippe Lang
    
Merged Rails 2.0 compatibility changes....

              r962
            
      CREATE TABLE 'companies' (

        'id' INTEGER PRIMARY KEY NOT NULL,

        'name' TEXT DEFAULT NULL,

        'rating' INTEGER DEFAULT 1

      );

      CREATE TABLE 'replies' (

        'id' INTEGER PRIMARY KEY NOT NULL, 

        'content' text, 

        'created_at' datetime, 

        'updated_at' datetime, 

        'topic_id' integer

      );

      CREATE TABLE 'topics' (

        'id' INTEGER PRIMARY KEY NOT NULL, 

        'title' varchar(255), 

        'subtitle' varchar(255), 

        'content' text, 

        'created_at' datetime, 

        'updated_at' datetime

      );

      CREATE TABLE 'developers' (

        'id' INTEGER PRIMARY KEY NOT NULL,

        'name' TEXT DEFAULT NULL,

        'salary' INTEGER DEFAULT 70000,

        'created_at' DATETIME DEFAULT NULL,

        'updated_at' DATETIME DEFAULT NULL

      );

      CREATE TABLE 'projects' (

        'id' INTEGER PRIMARY KEY NOT NULL,

        'name' TEXT DEFAULT NULL

      );

      CREATE TABLE 'developers_projects' (

        'developer_id' INTEGER NOT NULL,

        'project_id' INTEGER NOT NULL,

        'joined_on' DATE DEFAULT NULL,

        'access_level' INTEGER DEFAULT 1

      );

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

Jean-Philippe Lang Merged Rails 2.0 compatibility changes....	r962	CREATE TABLE 'companies' (
		'id' INTEGER PRIMARY KEY NOT NULL,
		'name' TEXT DEFAULT NULL,
		'rating' INTEGER DEFAULT 1
		);

		CREATE TABLE 'replies' (
		'id' INTEGER PRIMARY KEY NOT NULL,
		'content' text,
		'created_at' datetime,
		'updated_at' datetime,
		'topic_id' integer
		);

		CREATE TABLE 'topics' (
		'id' INTEGER PRIMARY KEY NOT NULL,
		'title' varchar(255),
		'subtitle' varchar(255),
		'content' text,
		'created_at' datetime,
		'updated_at' datetime
		);

		CREATE TABLE 'developers' (
		'id' INTEGER PRIMARY KEY NOT NULL,
		'name' TEXT DEFAULT NULL,
		'salary' INTEGER DEFAULT 70000,
		'created_at' DATETIME DEFAULT NULL,
		'updated_at' DATETIME DEFAULT NULL
		);

		CREATE TABLE 'projects' (
		'id' INTEGER PRIMARY KEY NOT NULL,
		'name' TEXT DEFAULT NULL
		);

		CREATE TABLE 'developers_projects' (
		'developer_id' INTEGER NOT NULL,
		'project_id' INTEGER NOT NULL,
		'joined_on' DATE DEFAULT NULL,
		'access_level' INTEGER DEFAULT 1
		);