From 1dd09c8731bdef87885260a77091e5e0e9918bfe Mon Sep 17 00:00:00 2001
From: Ralph Amissah <ralph@amissah.com>
Date: Mon, 31 Dec 2007 13:41:20 +0000
Subject: change primary key indexes to bigint (requested)
---
lib/sisu/v0/db_create.rb | 36 ++++++++++++++++++------------------
1 file changed, 18 insertions(+), 18 deletions(-)
(limited to 'lib')
diff --git a/lib/sisu/v0/db_create.rb b/lib/sisu/v0/db_create.rb
index 68d0ae3d..ac8f78bf 100644
--- a/lib/sisu/v0/db_create.rb
+++ b/lib/sisu/v0/db_create.rb
@@ -7,14 +7,14 @@
* Author: Ralph Amissah
* Copyright: (C) 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006,
- 2007 Ralph Amissah All Rights Reserved.
+ 2007, 2008 Ralph Amissah All Rights Reserved.
* License: GPL 3 or later:
SiSU, a framework for document structuring, publishing and search
Copyright (C) 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006,
- 2007 Ralph Amissah
+ 2007, 2008 Ralph Amissah
This program is free software: you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
@@ -98,7 +98,7 @@ module SiSU_DB_create
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE metadata (
- tid INT4 PRIMARY KEY,
+ tid BIGINT PRIMARY KEY,
title VARCHAR(#{lt_title}) NULL,
subtitle VARCHAR(#{lt_subtitle}) NULL,
creator VARCHAR(#{lt_creator}) NULL,
@@ -163,8 +163,8 @@ module SiSU_DB_create
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE documents (
- lid INT4 PRIMARY KEY,
- metadata_tid INT4 REFERENCES metadata,
+ lid BIGINT PRIMARY KEY,
+ metadata_tid BIGINT REFERENCES metadata,
ocn SMALLINT,
ocnd VARCHAR(6),
ocns VARCHAR(6),
@@ -193,14 +193,14 @@ module SiSU_DB_create
end
def endnotes
print %{
- to be populated from documents files
+ to be populated from document files
create tables endnotes
data import through ruby transfer
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE endnotes (
- nid INT4 PRIMARY KEY,
- document_lid INT4 REFERENCES documents,
+ nid BIGINT PRIMARY KEY,
+ document_lid BIGINT REFERENCES documents,
nr SMALLINT,
clean TEXT NULL,
body TEXT NULL,
@@ -208,21 +208,21 @@ module SiSU_DB_create
ocnd VARCHAR(6),
ocns VARCHAR(6),
digest_clean CHAR(#{@@dl}),
- metadata_tid INT4 REFERENCES metadata
+ metadata_tid BIGINT REFERENCES metadata
);
#{@comment.endnotes}
})
end
def endnotes_asterisk
print %{
- to be populated from documents files
+ to be populated from document files
create tables endnotes_asterisk
data import through ruby transfer
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE endnotes_asterisk (
- nid INT4 PRIMARY KEY,
- document_lid INT4 REFERENCES documents,
+ nid BIGINT PRIMARY KEY,
+ document_lid BIGINT REFERENCES documents,
nr SMALLINT,
clean TEXT NULL,
body TEXT NULL,
@@ -230,21 +230,21 @@ module SiSU_DB_create
ocnd VARCHAR(6),
ocns VARCHAR(6),
digest_clean CHAR(#{@@dl}),
- metadata_tid INT4 REFERENCES metadata
+ metadata_tid BIGINT REFERENCES metadata
);
#{@comment.endnotes_asterisk}
})
end
def endnotes_plus
print %{
- to be populated from documents files
+ to be populated from document files
create tables endnotes_plus
data import through ruby transfer
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE endnotes_plus (
- nid INT4 PRIMARY KEY,
- document_lid INT4 REFERENCES documents,
+ nid BIGINT PRIMARY KEY,
+ document_lid BIGINT REFERENCES documents,
nr SMALLINT,
clean TEXT NULL,
body TEXT NULL,
@@ -252,7 +252,7 @@ module SiSU_DB_create
ocnd VARCHAR(6),
ocns VARCHAR(6),
digest_clean CHAR(#{@@dl}),
- metadata_tid INT4 REFERENCES metadata
+ metadata_tid BIGINT REFERENCES metadata
);
#{@comment.endnotes_plus}
})
@@ -266,7 +266,7 @@ module SiSU_DB_create
} unless @opt.cmd =~/q/
@conn.execute(%{
CREATE TABLE urls (
- metadata_tid INT4 REFERENCES metadata,
+ metadata_tid BIGINT REFERENCES metadata,
plaintext varchar(512),
html_toc varchar(512),
html_doc varchar(512),
--
cgit v1.2.3