projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'master' of git.freeside.biz:/home/git/freeside
[freeside.git]
/
rt
/
etc
/
upgrade
/
3.9.8
/
schema.SQLite
diff --git
a/rt/etc/upgrade/3.9.8/schema.SQLite
b/rt/etc/upgrade/3.9.8/schema.SQLite
index
29ed7e8
..
b5af936
100644
(file)
--- a/
rt/etc/upgrade/3.9.8/schema.SQLite
+++ b/
rt/etc/upgrade/3.9.8/schema.SQLite
@@
-1,3
+1,4
@@
+DROP TABLE IF EXISTS Classes;
CREATE TABLE Classes (
id INTEGER PRIMARY KEY,
Name varchar(255) NOT NULL DEFAULT '',
CREATE TABLE Classes (
id INTEGER PRIMARY KEY,
Name varchar(255) NOT NULL DEFAULT '',
@@
-11,6
+12,7
@@
LastUpdated TIMESTAMP NULL,
HotList smallint NOT NULL DEFAULT 0
);
HotList smallint NOT NULL DEFAULT 0
);
+DROP TABLE IF EXISTS Articles;
CREATE TABLE Articles (
id INTEGER PRIMARY KEY,
Name varchar(255) NOT NULL DEFAULT '',
CREATE TABLE Articles (
id INTEGER PRIMARY KEY,
Name varchar(255) NOT NULL DEFAULT '',
@@
-25,7
+27,7
@@
LastUpdatedBy integer NOT NULL DEFAULT 0,
LastUpdated TIMESTAMP NULL
);
LastUpdated TIMESTAMP NULL
);
-
+DROP TABLE IF EXISTS Topics;
CREATE TABLE Topics (
id INTEGER PRIMARY KEY,
Parent integer NOT NULL DEFAULT 0,
CREATE TABLE Topics (
id INTEGER PRIMARY KEY,
Parent integer NOT NULL DEFAULT 0,
@@
-36,6
+38,7
@@
ObjectId integer NOT NULL
);
);
+DROP TABLE IF EXISTS ObjectTopics;
CREATE TABLE ObjectTopics (
id INTEGER PRIMARY KEY,
Topic integer NOT NULL,
CREATE TABLE ObjectTopics (
id INTEGER PRIMARY KEY,
Topic integer NOT NULL,
@@
-43,6
+46,7
@@
ObjectType varchar(64) NOT NULL DEFAULT '',
ObjectId integer NOT NULL
);
ObjectId integer NOT NULL
);
+DROP TABLE IF EXISTS ObjectClasses;
CREATE TABLE ObjectClasses (
id INTEGER PRIMARY KEY,
Class integer NOT NULL,
CREATE TABLE ObjectClasses (
id INTEGER PRIMARY KEY,
Class integer NOT NULL,