diff options
| author | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-02-15 13:46:08 +0000 |
|---|---|---|
| committer | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-02-15 13:46:08 +0000 |
| commit | c6f3234b15bdbd2de3dda10c9941b36ed147fb76 (patch) | |
| tree | 601a29ca7fc5792feb68469b4fff80388d7eeec8 /engine/schema/mysql.sql | |
| parent | d5b835cbf12253bdbb3ce2c89f97e921e06ad1f2 (diff) | |
| download | elgg-c6f3234b15bdbd2de3dda10c9941b36ed147fb76.tar.gz elgg-c6f3234b15bdbd2de3dda10c9941b36ed147fb76.tar.bz2 | |
Adding more plugin-related fun
git-svn-id: https://code.elgg.org/elgg/trunk@41 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema/mysql.sql')
| -rw-r--r-- | engine/schema/mysql.sql | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 9b8304b80..9c0428ce7 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -14,7 +14,7 @@ -- Table structure for table `access_groups`
--
-CREATE TABLE `access_groups` (
+CREATE TABLE `prefix_access_groups` (
`id` int(11) NOT NULL,
`name` varchar(16) NOT NULL,
PRIMARY KEY (`id`),
@@ -25,7 +25,7 @@ CREATE TABLE `access_groups` ( -- Dumping data for table `access_groups`
--
-INSERT INTO `access_groups` (`id`, `name`) VALUES
+INSERT INTO `prefix_access_groups` (`id`, `name`) VALUES
(0, 'PRIVATE'),
(1, 'LOGGED_IN'),
(2, 'PUBLIC');
@@ -36,7 +36,7 @@ INSERT INTO `access_groups` (`id`, `name`) VALUES -- Table structure for table `access_group_membership`
--
-CREATE TABLE `access_group_membership` (
+CREATE TABLE `prefix_access_group_membership` (
`user_id` int(11) NOT NULL,
`access_group_id` int(11) NOT NULL,
PRIMARY KEY (`user_id`,`access_group_id`)
@@ -49,7 +49,7 @@ CREATE TABLE `access_group_membership` ( -- Table structure for table `configuration`
--
-CREATE TABLE `configuration` (
+CREATE TABLE `prefix_configuration` (
`id` int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`value` text NOT NULL,
@@ -64,7 +64,7 @@ CREATE TABLE `configuration` ( -- Table structure for table `metadata_type`
--
-CREATE TABLE `metadata_type` (
+CREATE TABLE `prefix_metadata_type` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
@@ -78,7 +78,7 @@ CREATE TABLE `metadata_type` ( -- Table structure for table `metadata_value`
--
-CREATE TABLE `metadata_value` (
+CREATE TABLE `prefix_metadata_value` (
`id` int(11) NOT NULL auto_increment,
`value` text NOT NULL,
PRIMARY KEY (`id`)
@@ -91,7 +91,7 @@ CREATE TABLE `metadata_value` ( -- Table structure for table `objects`
--
-CREATE TABLE `objects` (
+CREATE TABLE `prefix_objects` (
`id` int(11) NOT NULL auto_increment,
`owner_id` int(11) NOT NULL,
`site_id` int(11) NOT NULL,
@@ -110,7 +110,7 @@ CREATE TABLE `objects` ( -- Table structure for table `object_metadata`
--
-CREATE TABLE `object_metadata` (
+CREATE TABLE `prefix_object_metadata` (
`id` int(11) NOT NULL auto_increment,
`object_id` int(11) NOT NULL,
`metadata_type_id` int(11) NOT NULL,
@@ -127,7 +127,7 @@ CREATE TABLE `object_metadata` ( -- Table structure for table `object_types`
--
-CREATE TABLE `object_types` (
+CREATE TABLE `prefix_object_types` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(16) NOT NULL,
PRIMARY KEY (`id`),
@@ -140,7 +140,7 @@ CREATE TABLE `object_types` ( -- Table structure for table `users`
--
-CREATE TABLE `users` (
+CREATE TABLE `prefix_users` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`username` varchar(12) NOT NULL default '',
@@ -165,7 +165,7 @@ CREATE TABLE `users` ( -- Table structure for table `user_metadata`
--
-CREATE TABLE `user_metadata` (
+CREATE TABLE `prefix_user_metadata` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`metadata_type_id` int(11) NOT NULL,
|