Changeset 370 for trunk/app/config

Timestamp:

04/06/08 13:50:06 (8 months ago)

Author:

aarkerio

Message:

Wiki starting

Location:

trunk/app/config

Files:

• core.php (modified) (1 diff)
• sql/karamelo_postgres.sql (modified) (3 diffs)

trunk/app/config/core.php

@@ -14 +14 @@
  * In development mode, you need to click the flash message to continue.
  */
-    Configure::write('debug', 1);
+    Configure::write('debug', 2);
 /**
  * Application wide charset encoding

trunk/app/config/sql/karamelo_postgres.sql

@@ -87 +87 @@
 INSERT INTO subjects (code, title) VALUES ('0006', 'Music');
 INSERT INTO subjects (code, title) VALUES ('0007', 'Psichology');
-INSERT INTO subjects (code, title) VALUES ('0008', 'Chemistry');
-INSERT INTO subjects (code, title) VALUES ('0009', 'Physiscs');
-INSERT INTO subjects (code, title) VALUES ('0010', 'Science');
-INSERT INTO subjects (code, title) VALUES ('0011', 'Public health');
-INSERT INTO subjects (code, title) VALUES ('0012', 'Biology');
-INSERT INTO subjects (code, title) VALUES ('0013', 'Sociology');
-INSERT INTO subjects (code, title) VALUES ('0014', 'Archeology');
-INSERT INTO subjects (code, title) VALUES ('0015', 'Spanish');
-INSERT INTO subjects (code, title) VALUES ('0016', 'Geography');
-INSERT INTO subjects (code, title) VALUES ('0017', 'Computing');
-INSERT INTO subjects (code, title) VALUES ('0018', 'Business Studies');
-INSERT INTO subjects (code, title) VALUES ('0019', 'Genre Studies');
-INSERT INTO subjects (code, title) VALUES ('0020', 'French');
-INSERT INTO subjects (code, title) VALUES ('0021', 'German');
-INSERT INTO subjects (code, title) VALUES ('0022', 'Health Care');
-INSERT INTO subjects (code, title) VALUES ('0023', 'Commerce');
-INSERT INTO subjects (code, title) VALUES ('0024', 'Graphic Design');
-INSERT INTO subjects (code, title) VALUES ('0025', 'Administration');
-INSERT INTO subjects (code, title) VALUES ('0026', 'Accounting');
-INSERT INTO subjects (code, title) VALUES ('0027', 'Classic Latin');
-INSERT INTO subjects (code, title) VALUES ('0028', 'Literature');
-INSERT INTO subjects (code, title) VALUES ('0029', 'Japanese');
-INSERT INTO subjects (code, title) VALUES ('0030', 'Chinese');
-INSERT INTO subjects (code, title) VALUES ('0031', 'Engineering');
-INSERT INTO subjects (code, title) VALUES ('0032', 'Sports');
+
 
 -- Confirms user registration table, just a support table until new user confirm his/her email
@@ -590 +566 @@
 --HABTM
 CREATE TABLE "tests_vclassrooms" (
+ "id" serial PRIMARY KEY,
  "test_id" int NOT NULL REFERENCES tests(id),
  "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
-  PRIMARY KEY  ("test_id", "vclassroom_id")
+  UNIQUE  ("test_id", "vclassroom_id")
 );
 
@@ -674 +651 @@
  status int NOT NULL DEFAULT 0
 );
+
+-- Wiki tables beggin
+CREATE TABLE wikis (
+  id serial PRIMARY KEY,
+  title varchar(255) NOT NULL,
+  content text NOT NULL,
+  access smallint NOT NULL DEFAULT 0,
+  modified timestamp NOT NULL default now(),
+  user_id serial NOT NULL,
+  ip varchar(15) NOT NULL,
+  revision int(5) NOT NULL,
+  accessed datetime NOT NULL
+);
+
+CREATE TABLE wiki_revisions (
+  id serial PRIMARY KEY,
+  title varchar(255) NOT NULL,
+  content text NOT NULL,
+  access smallint NOT NULL default 0,
+  modified timestamp NOT NULL default now(),
+  user_id serial NOT NULL,
+  ip varchar(15) NOT NULL,
+  revision int(5) NOT NULL,
+  accessed date NOT NULL default now()
+);
+
+CREATE TABLE settings (
+  id serial PRIMARY KEY,
+  name varchar(50) NOT NULL UNIQUE,
+  value varchar(255) NOT NULL,
+  default varchar(255) NOT NULL,
+  description varchar(255) NOT NULL
+);
+
+CREATE TABLE upload_revisions (
+  id serial PRIMARY KEY,
+  filename varchar(250) NOT NULL,
+  location varchar(250) NOT NULL,
+  access smallint NOT NULL,
+  modified timestamp NOT NULL default now(),
+  user_id int NOT NULL REFERENCES users(id),
+  ip varchar(15) NOT NULL,
+  revision int NOT NULL
+);
+
+CREATE TABLE uploads (
+  id serial PRIMARY KEY,
+  filename varchar(255) NOT NULL UNIQUE,
+  location varchar(255) NOT NULL,
+  access smallint NOT NULL,
+  modified timestamp NOT NULL default now(),
+  user_id int NOT NULL REFERENCES users(id),
+  ip varchar(15) NOT NULL,
+  revision int NOT NULL
+);
+
+-- wiki tables ends