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

Doc and version update for 0.7.1 release....

Doc and version update for 0.7.1 release. git-svn-id: http://redmine.rubyforge.org/svn/branches/0.7-stable@1413 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r962:6d9490ddcc9c


                r1398:c0db7007fa11

Download file

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

      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

				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
				);