sql/core_template.sql

diff --git a/sql/core_template.sql b/sql/core_template.sql
new file mode 100644 (file)
index 0000000..62c8a04
--- /dev/null
+++ b/sql/core_template.sql
@@ -0,0 +1,11 @@
+-- template .
+CREATE TABLE  core_template (
+  id int(11)  NOT NULL AUTO_INCREMENT,
+  template varchar(254)  NOT NULL,
+  updated datetime  NOT NULL,
+  lang varchar(6)  NOT NULL,
+  PRIMARY KEY (id),
+  INDEX lookup(template, lang)
+);
+
+ALTER TABLE core_template ADD COLUMN view_name varchar(32) NOT NULL default '';