标题: pkg: sqlite error while executing CREATE TABLE licenses [打印本页] 作者: hjfeng1988 时间: 2015-05-13 10:25 标题: pkg: sqlite error while executing CREATE TABLE licenses 在看Restoring the Package Database，没注意到restore字眼。
pkg backup -r /path/to/pkg.sql
复制代码
提示我：No such file or directory，我就自己touch了空文件。再次restore，然后pkg就坏了。之前没有备份
root@host102:~ # pkg info
pkg: sqlite error while executing CREATE TABLE licenses (id INTEGER PRIMARY KEY, license TEXT NOT NULL UNIQUE );CREATE TABLE pkg_licenses_assoc (package_id INTEGER REFERENCES packages(id) ON DELETE CASCADE ON UPDATE CASCADE, license_id INTEGER REFERENCES licenses(id) ON DELETE RESTRICT ON UPDATE RESTRICT, PRIMARY KEY (package_id, license_id));CREATE VIEW pkg_licenses AS SELECT origin, license FROM packages INNER JOIN pkg_licenses_assoc ON packages.id = pkg_licenses_assoc.package_id INNER JOIN licenses ON pkg_licenses_assoc.license_id = licenses.id;CREATE TRIGGER license_insert INSTEAD OF INSERT ON pkg_licenses FOR EACH ROW BEGIN INSERT OR IGNORE INTO licenses(license) values (NEW.license);INSERT INTO pkg_licenses_assoc(package_id, license_id) VALUES ((SELECT id FROM packages where origin = NEW.origin), (SELECT id FROM categories WHERE name = NEW.name));END; in file pkgdb.c:2333: no such table: main.packages
