← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/padre/oneiric

« back to all changes in this revision

Viewing changes to share/timeline/migrate-8.pl

  • Committer: Bazaar Package Importer
  • Author(s): Damyan Ivanov
  • Date: 2009-04-28 16:21:53 UTC
  • mfrom: (1.1.2 upstream)
  • Revision ID: james.westby@ubuntu.com-20090428162153-9p3ygfznr9xt08sn
Tags: 0.34-1
* New upstream release

* bump liborlite-perl (build-)dependency to 1.20
* bump liborlite-migrate-perl (build-)dependency to 0.03
* refresh patches

Show diffs side-by-side

added added

removed removed

Lines of Context:
share/timeline/migrate-8.pl
 
1
use strict;
 
2
use ORLite::Migrate::Patch;
 
3
 
 
4
# remove the session table created in migrate-5
 
5
do(<<'END_SQL');
 
6
DROP TABLE session
 
7
END_SQL
 
8
 
 
9
# create the new session table
 
10
do(<<'END_SQL');
 
11
CREATE TABLE session (
 
12
        id INTEGER NOT NULL PRIMARY KEY,
 
13
        name VARCHAR(255) UNIQUE NOT NULL,
 
14
        description VARCHAR(255),
 
15
        last_update DATE
 
16
)
 
17
END_SQL
 
18
 
 
19
# create the table containing the session files
 
20
do(<<'END_SQL');
 
21
CREATE TABLE session_file (
 
22
        id INTEGER NOT NULL PRIMARY KEY,
 
23
        file VARCHAR(255) NOT NULL,
 
24
        position INTEGER NOT NULL,
 
25
        focus BOOLEAN NOT NULL,
 
26
        session INTEGER NOT NULL,
 
27
        FOREIGN KEY (session) REFERENCES session(id)
 
28
)
 
29
END_SQL